Fossil SCM
Update the built-in SQLite to the version that contains the fix for the ORDER BY optimization bug that was fixed in SQLite version 3.7.15.2.
Commit
6b3e97a328c1dd70a22863e8951a164271233a8b
Parent
5b7f084fd4a274c…
2 files changed
+2
-2
+1
-1
+2
-2
| --- src/sqlite3.c | ||
| +++ src/sqlite3.c | ||
| @@ -673,11 +673,11 @@ | ||
| 673 | 673 | ** [sqlite3_libversion_number()], [sqlite3_sourceid()], |
| 674 | 674 | ** [sqlite_version()] and [sqlite_source_id()]. |
| 675 | 675 | */ |
| 676 | 676 | #define SQLITE_VERSION "3.7.16" |
| 677 | 677 | #define SQLITE_VERSION_NUMBER 3007016 |
| 678 | -#define SQLITE_SOURCE_ID "2013-01-08 12:48:10 cda790280a52d65f98a45bacb9123367b159ac7c" | |
| 678 | +#define SQLITE_SOURCE_ID "2013-01-09 11:31:17 5774f2175ce621dfc4b6b93f7ee13fd66f3ec2b9" | |
| 679 | 679 | |
| 680 | 680 | /* |
| 681 | 681 | ** CAPI3REF: Run-Time Library Version Numbers |
| 682 | 682 | ** KEYWORDS: sqlite3_version, sqlite3_sourceid |
| 683 | 683 | ** |
| @@ -106006,11 +106006,11 @@ | ||
| 106006 | 106006 | int bRev = 2; |
| 106007 | 106007 | WHERETRACE((" --> before isSortingIndex: nPriorSat=%d\n",nPriorSat)); |
| 106008 | 106008 | pc.plan.nOBSat = isSortingIndex(p, pProbe, iCur, &bRev); |
| 106009 | 106009 | WHERETRACE((" --> after isSortingIndex: bRev=%d nOBSat=%d\n", |
| 106010 | 106010 | bRev, pc.plan.nOBSat)); |
| 106011 | - if( nPriorSat<pc.plan.nOBSat || (pc.plan.wsFlags & WHERE_UNIQUE)!=0 ){ | |
| 106011 | + if( nPriorSat<pc.plan.nOBSat || (pc.plan.wsFlags & WHERE_ALL_UNIQUE)!=0 ){ | |
| 106012 | 106012 | pc.plan.wsFlags |= WHERE_ORDERED; |
| 106013 | 106013 | } |
| 106014 | 106014 | if( nOrderBy==pc.plan.nOBSat ){ |
| 106015 | 106015 | bSort = 0; |
| 106016 | 106016 | pc.plan.wsFlags |= WHERE_ROWID_RANGE|WHERE_COLUMN_RANGE; |
| 106017 | 106017 |
| --- src/sqlite3.c | |
| +++ src/sqlite3.c | |
| @@ -673,11 +673,11 @@ | |
| 673 | ** [sqlite3_libversion_number()], [sqlite3_sourceid()], |
| 674 | ** [sqlite_version()] and [sqlite_source_id()]. |
| 675 | */ |
| 676 | #define SQLITE_VERSION "3.7.16" |
| 677 | #define SQLITE_VERSION_NUMBER 3007016 |
| 678 | #define SQLITE_SOURCE_ID "2013-01-08 12:48:10 cda790280a52d65f98a45bacb9123367b159ac7c" |
| 679 | |
| 680 | /* |
| 681 | ** CAPI3REF: Run-Time Library Version Numbers |
| 682 | ** KEYWORDS: sqlite3_version, sqlite3_sourceid |
| 683 | ** |
| @@ -106006,11 +106006,11 @@ | |
| 106006 | int bRev = 2; |
| 106007 | WHERETRACE((" --> before isSortingIndex: nPriorSat=%d\n",nPriorSat)); |
| 106008 | pc.plan.nOBSat = isSortingIndex(p, pProbe, iCur, &bRev); |
| 106009 | WHERETRACE((" --> after isSortingIndex: bRev=%d nOBSat=%d\n", |
| 106010 | bRev, pc.plan.nOBSat)); |
| 106011 | if( nPriorSat<pc.plan.nOBSat || (pc.plan.wsFlags & WHERE_UNIQUE)!=0 ){ |
| 106012 | pc.plan.wsFlags |= WHERE_ORDERED; |
| 106013 | } |
| 106014 | if( nOrderBy==pc.plan.nOBSat ){ |
| 106015 | bSort = 0; |
| 106016 | pc.plan.wsFlags |= WHERE_ROWID_RANGE|WHERE_COLUMN_RANGE; |
| 106017 |
| --- src/sqlite3.c | |
| +++ src/sqlite3.c | |
| @@ -673,11 +673,11 @@ | |
| 673 | ** [sqlite3_libversion_number()], [sqlite3_sourceid()], |
| 674 | ** [sqlite_version()] and [sqlite_source_id()]. |
| 675 | */ |
| 676 | #define SQLITE_VERSION "3.7.16" |
| 677 | #define SQLITE_VERSION_NUMBER 3007016 |
| 678 | #define SQLITE_SOURCE_ID "2013-01-09 11:31:17 5774f2175ce621dfc4b6b93f7ee13fd66f3ec2b9" |
| 679 | |
| 680 | /* |
| 681 | ** CAPI3REF: Run-Time Library Version Numbers |
| 682 | ** KEYWORDS: sqlite3_version, sqlite3_sourceid |
| 683 | ** |
| @@ -106006,11 +106006,11 @@ | |
| 106006 | int bRev = 2; |
| 106007 | WHERETRACE((" --> before isSortingIndex: nPriorSat=%d\n",nPriorSat)); |
| 106008 | pc.plan.nOBSat = isSortingIndex(p, pProbe, iCur, &bRev); |
| 106009 | WHERETRACE((" --> after isSortingIndex: bRev=%d nOBSat=%d\n", |
| 106010 | bRev, pc.plan.nOBSat)); |
| 106011 | if( nPriorSat<pc.plan.nOBSat || (pc.plan.wsFlags & WHERE_ALL_UNIQUE)!=0 ){ |
| 106012 | pc.plan.wsFlags |= WHERE_ORDERED; |
| 106013 | } |
| 106014 | if( nOrderBy==pc.plan.nOBSat ){ |
| 106015 | bSort = 0; |
| 106016 | pc.plan.wsFlags |= WHERE_ROWID_RANGE|WHERE_COLUMN_RANGE; |
| 106017 |
+1
-1
| --- src/sqlite3.h | ||
| +++ src/sqlite3.h | ||
| @@ -107,11 +107,11 @@ | ||
| 107 | 107 | ** [sqlite3_libversion_number()], [sqlite3_sourceid()], |
| 108 | 108 | ** [sqlite_version()] and [sqlite_source_id()]. |
| 109 | 109 | */ |
| 110 | 110 | #define SQLITE_VERSION "3.7.16" |
| 111 | 111 | #define SQLITE_VERSION_NUMBER 3007016 |
| 112 | -#define SQLITE_SOURCE_ID "2013-01-08 12:48:10 cda790280a52d65f98a45bacb9123367b159ac7c" | |
| 112 | +#define SQLITE_SOURCE_ID "2013-01-09 11:31:17 5774f2175ce621dfc4b6b93f7ee13fd66f3ec2b9" | |
| 113 | 113 | |
| 114 | 114 | /* |
| 115 | 115 | ** CAPI3REF: Run-Time Library Version Numbers |
| 116 | 116 | ** KEYWORDS: sqlite3_version, sqlite3_sourceid |
| 117 | 117 | ** |
| 118 | 118 |
| --- src/sqlite3.h | |
| +++ src/sqlite3.h | |
| @@ -107,11 +107,11 @@ | |
| 107 | ** [sqlite3_libversion_number()], [sqlite3_sourceid()], |
| 108 | ** [sqlite_version()] and [sqlite_source_id()]. |
| 109 | */ |
| 110 | #define SQLITE_VERSION "3.7.16" |
| 111 | #define SQLITE_VERSION_NUMBER 3007016 |
| 112 | #define SQLITE_SOURCE_ID "2013-01-08 12:48:10 cda790280a52d65f98a45bacb9123367b159ac7c" |
| 113 | |
| 114 | /* |
| 115 | ** CAPI3REF: Run-Time Library Version Numbers |
| 116 | ** KEYWORDS: sqlite3_version, sqlite3_sourceid |
| 117 | ** |
| 118 |
| --- src/sqlite3.h | |
| +++ src/sqlite3.h | |
| @@ -107,11 +107,11 @@ | |
| 107 | ** [sqlite3_libversion_number()], [sqlite3_sourceid()], |
| 108 | ** [sqlite_version()] and [sqlite_source_id()]. |
| 109 | */ |
| 110 | #define SQLITE_VERSION "3.7.16" |
| 111 | #define SQLITE_VERSION_NUMBER 3007016 |
| 112 | #define SQLITE_SOURCE_ID "2013-01-09 11:31:17 5774f2175ce621dfc4b6b93f7ee13fd66f3ec2b9" |
| 113 | |
| 114 | /* |
| 115 | ** CAPI3REF: Run-Time Library Version Numbers |
| 116 | ** KEYWORDS: sqlite3_version, sqlite3_sourceid |
| 117 | ** |
| 118 |