Fossil SCM

Update the built-in SQLite to version 3.27.1.

drh 2019-02-08 13:28 trunk
Commit cf6682b1e15c63899d4a65f9aad1e7d2c5f6b80709ef4004be95f73ba4ae52c7
2 files changed +13 -8 +3 -3
+13 -8
--- src/sqlite3.c
+++ src/sqlite3.c
@@ -1,8 +1,8 @@
11
/******************************************************************************
22
** This file is an amalgamation of many separate C source files from SQLite
3
-** version 3.27.0. By combining all the individual C code files into this
3
+** version 3.27.1. By combining all the individual C code files into this
44
** single large file, the entire code can be compiled as a single translation
55
** unit. This allows many compilers to do optimizations that would not be
66
** possible if the files were compiled separately. Performance improvements
77
** of 5% or more are commonly seen when SQLite is compiled as a single
88
** translation unit.
@@ -1160,13 +1160,13 @@
11601160
**
11611161
** See also: [sqlite3_libversion()],
11621162
** [sqlite3_libversion_number()], [sqlite3_sourceid()],
11631163
** [sqlite_version()] and [sqlite_source_id()].
11641164
*/
1165
-#define SQLITE_VERSION "3.27.0"
1166
-#define SQLITE_VERSION_NUMBER 3027000
1167
-#define SQLITE_SOURCE_ID "2019-02-07 17:02:52 97744701c3bd414e6c9d7182639d8c2ce7cf124c4fce625071ae65658ac61713"
1165
+#define SQLITE_VERSION "3.27.1"
1166
+#define SQLITE_VERSION_NUMBER 3027001
1167
+#define SQLITE_SOURCE_ID "2019-02-08 13:17:39 0eca3dd3d38b31c92b49ca2d311128b74584714d9e7de895b1a6286ef959a1dd"
11681168
11691169
/*
11701170
** CAPI3REF: Run-Time Library Version Numbers
11711171
** KEYWORDS: sqlite3_version sqlite3_sourceid
11721172
**
@@ -137599,12 +137599,17 @@
137599137599
** Do not do this for the RHS of a LEFT JOIN. This is because the
137600137600
** expression may be evaluated after OP_NullRow has been executed on
137601137601
** the cursor. In this case it is important to do the full evaluation,
137602137602
** as the result of the expression may not be NULL, even if all table
137603137603
** column values are. https://www.sqlite.org/src/info/7fa8049685b50b5a
137604
+ **
137605
+ ** Also, do not do this when processing one index an a multi-index
137606
+ ** OR clause, since the transformation will become invalid once we
137607
+ ** move forward to the next index.
137608
+ ** https://sqlite.org/src/info/4e8e4857d32d401f
137604137609
*/
137605
- if( pLevel->iLeftJoin==0 ){
137610
+ if( pLevel->iLeftJoin==0 && (pWInfo->wctrlFlags & WHERE_OR_SUBCLAUSE)==0 ){
137606137611
whereIndexExprTrans(pIdx, iCur, iIdxCur, pWInfo);
137607137612
}
137608137613
137609137614
/* Record the instruction used to terminate the loop. */
137610137615
if( pLoop->wsFlags & WHERE_ONEROW ){
@@ -217069,11 +217074,11 @@
217069217074
int nArg, /* Number of args */
217070217075
sqlite3_value **apUnused /* Function arguments */
217071217076
){
217072217077
assert( nArg==0 );
217073217078
UNUSED_PARAM2(nArg, apUnused);
217074
- sqlite3_result_text(pCtx, "fts5: 2019-02-07 17:02:52 97744701c3bd414e6c9d7182639d8c2ce7cf124c4fce625071ae65658ac61713", -1, SQLITE_TRANSIENT);
217079
+ sqlite3_result_text(pCtx, "fts5: 2019-02-08 13:17:39 0eca3dd3d38b31c92b49ca2d311128b74584714d9e7de895b1a6286ef959a1dd", -1, SQLITE_TRANSIENT);
217075217080
}
217076217081
217077217082
/*
217078217083
** Return true if zName is the extension on one of the shadow tables used
217079217084
** by this module.
@@ -221833,12 +221838,12 @@
221833221838
}
221834221839
#endif /* SQLITE_CORE */
221835221840
#endif /* !defined(SQLITE_CORE) || defined(SQLITE_ENABLE_STMTVTAB) */
221836221841
221837221842
/************** End of stmt.c ************************************************/
221838
-#if __LINE__!=221838
221843
+#if __LINE__!=221843
221839221844
#undef SQLITE_SOURCE_ID
221840
-#define SQLITE_SOURCE_ID "2019-02-07 17:02:52 97744701c3bd414e6c9d7182639d8c2ce7cf124c4fce625071ae65658ac6alt2"
221845
+#define SQLITE_SOURCE_ID "2019-02-08 13:17:39 0eca3dd3d38b31c92b49ca2d311128b74584714d9e7de895b1a6286ef959alt2"
221841221846
#endif
221842221847
/* Return the source-id for this library */
221843221848
SQLITE_API const char *sqlite3_sourceid(void){ return SQLITE_SOURCE_ID; }
221844221849
/************************** End of sqlite3.c ******************************/
221845221850
--- src/sqlite3.c
+++ src/sqlite3.c
@@ -1,8 +1,8 @@
1 /******************************************************************************
2 ** This file is an amalgamation of many separate C source files from SQLite
3 ** version 3.27.0. By combining all the individual C code files into this
4 ** single large file, the entire code can be compiled as a single translation
5 ** unit. This allows many compilers to do optimizations that would not be
6 ** possible if the files were compiled separately. Performance improvements
7 ** of 5% or more are commonly seen when SQLite is compiled as a single
8 ** translation unit.
@@ -1160,13 +1160,13 @@
1160 **
1161 ** See also: [sqlite3_libversion()],
1162 ** [sqlite3_libversion_number()], [sqlite3_sourceid()],
1163 ** [sqlite_version()] and [sqlite_source_id()].
1164 */
1165 #define SQLITE_VERSION "3.27.0"
1166 #define SQLITE_VERSION_NUMBER 3027000
1167 #define SQLITE_SOURCE_ID "2019-02-07 17:02:52 97744701c3bd414e6c9d7182639d8c2ce7cf124c4fce625071ae65658ac61713"
1168
1169 /*
1170 ** CAPI3REF: Run-Time Library Version Numbers
1171 ** KEYWORDS: sqlite3_version sqlite3_sourceid
1172 **
@@ -137599,12 +137599,17 @@
137599 ** Do not do this for the RHS of a LEFT JOIN. This is because the
137600 ** expression may be evaluated after OP_NullRow has been executed on
137601 ** the cursor. In this case it is important to do the full evaluation,
137602 ** as the result of the expression may not be NULL, even if all table
137603 ** column values are. https://www.sqlite.org/src/info/7fa8049685b50b5a
 
 
 
 
 
137604 */
137605 if( pLevel->iLeftJoin==0 ){
137606 whereIndexExprTrans(pIdx, iCur, iIdxCur, pWInfo);
137607 }
137608
137609 /* Record the instruction used to terminate the loop. */
137610 if( pLoop->wsFlags & WHERE_ONEROW ){
@@ -217069,11 +217074,11 @@
217069 int nArg, /* Number of args */
217070 sqlite3_value **apUnused /* Function arguments */
217071 ){
217072 assert( nArg==0 );
217073 UNUSED_PARAM2(nArg, apUnused);
217074 sqlite3_result_text(pCtx, "fts5: 2019-02-07 17:02:52 97744701c3bd414e6c9d7182639d8c2ce7cf124c4fce625071ae65658ac61713", -1, SQLITE_TRANSIENT);
217075 }
217076
217077 /*
217078 ** Return true if zName is the extension on one of the shadow tables used
217079 ** by this module.
@@ -221833,12 +221838,12 @@
221833 }
221834 #endif /* SQLITE_CORE */
221835 #endif /* !defined(SQLITE_CORE) || defined(SQLITE_ENABLE_STMTVTAB) */
221836
221837 /************** End of stmt.c ************************************************/
221838 #if __LINE__!=221838
221839 #undef SQLITE_SOURCE_ID
221840 #define SQLITE_SOURCE_ID "2019-02-07 17:02:52 97744701c3bd414e6c9d7182639d8c2ce7cf124c4fce625071ae65658ac6alt2"
221841 #endif
221842 /* Return the source-id for this library */
221843 SQLITE_API const char *sqlite3_sourceid(void){ return SQLITE_SOURCE_ID; }
221844 /************************** End of sqlite3.c ******************************/
221845
--- src/sqlite3.c
+++ src/sqlite3.c
@@ -1,8 +1,8 @@
1 /******************************************************************************
2 ** This file is an amalgamation of many separate C source files from SQLite
3 ** version 3.27.1. By combining all the individual C code files into this
4 ** single large file, the entire code can be compiled as a single translation
5 ** unit. This allows many compilers to do optimizations that would not be
6 ** possible if the files were compiled separately. Performance improvements
7 ** of 5% or more are commonly seen when SQLite is compiled as a single
8 ** translation unit.
@@ -1160,13 +1160,13 @@
1160 **
1161 ** See also: [sqlite3_libversion()],
1162 ** [sqlite3_libversion_number()], [sqlite3_sourceid()],
1163 ** [sqlite_version()] and [sqlite_source_id()].
1164 */
1165 #define SQLITE_VERSION "3.27.1"
1166 #define SQLITE_VERSION_NUMBER 3027001
1167 #define SQLITE_SOURCE_ID "2019-02-08 13:17:39 0eca3dd3d38b31c92b49ca2d311128b74584714d9e7de895b1a6286ef959a1dd"
1168
1169 /*
1170 ** CAPI3REF: Run-Time Library Version Numbers
1171 ** KEYWORDS: sqlite3_version sqlite3_sourceid
1172 **
@@ -137599,12 +137599,17 @@
137599 ** Do not do this for the RHS of a LEFT JOIN. This is because the
137600 ** expression may be evaluated after OP_NullRow has been executed on
137601 ** the cursor. In this case it is important to do the full evaluation,
137602 ** as the result of the expression may not be NULL, even if all table
137603 ** column values are. https://www.sqlite.org/src/info/7fa8049685b50b5a
137604 **
137605 ** Also, do not do this when processing one index an a multi-index
137606 ** OR clause, since the transformation will become invalid once we
137607 ** move forward to the next index.
137608 ** https://sqlite.org/src/info/4e8e4857d32d401f
137609 */
137610 if( pLevel->iLeftJoin==0 && (pWInfo->wctrlFlags & WHERE_OR_SUBCLAUSE)==0 ){
137611 whereIndexExprTrans(pIdx, iCur, iIdxCur, pWInfo);
137612 }
137613
137614 /* Record the instruction used to terminate the loop. */
137615 if( pLoop->wsFlags & WHERE_ONEROW ){
@@ -217069,11 +217074,11 @@
217074 int nArg, /* Number of args */
217075 sqlite3_value **apUnused /* Function arguments */
217076 ){
217077 assert( nArg==0 );
217078 UNUSED_PARAM2(nArg, apUnused);
217079 sqlite3_result_text(pCtx, "fts5: 2019-02-08 13:17:39 0eca3dd3d38b31c92b49ca2d311128b74584714d9e7de895b1a6286ef959a1dd", -1, SQLITE_TRANSIENT);
217080 }
217081
217082 /*
217083 ** Return true if zName is the extension on one of the shadow tables used
217084 ** by this module.
@@ -221833,12 +221838,12 @@
221838 }
221839 #endif /* SQLITE_CORE */
221840 #endif /* !defined(SQLITE_CORE) || defined(SQLITE_ENABLE_STMTVTAB) */
221841
221842 /************** End of stmt.c ************************************************/
221843 #if __LINE__!=221843
221844 #undef SQLITE_SOURCE_ID
221845 #define SQLITE_SOURCE_ID "2019-02-08 13:17:39 0eca3dd3d38b31c92b49ca2d311128b74584714d9e7de895b1a6286ef959alt2"
221846 #endif
221847 /* Return the source-id for this library */
221848 SQLITE_API const char *sqlite3_sourceid(void){ return SQLITE_SOURCE_ID; }
221849 /************************** End of sqlite3.c ******************************/
221850
+3 -3
--- src/sqlite3.h
+++ src/sqlite3.h
@@ -121,13 +121,13 @@
121121
**
122122
** See also: [sqlite3_libversion()],
123123
** [sqlite3_libversion_number()], [sqlite3_sourceid()],
124124
** [sqlite_version()] and [sqlite_source_id()].
125125
*/
126
-#define SQLITE_VERSION "3.27.0"
127
-#define SQLITE_VERSION_NUMBER 3027000
128
-#define SQLITE_SOURCE_ID "2019-02-07 17:02:52 97744701c3bd414e6c9d7182639d8c2ce7cf124c4fce625071ae65658ac61713"
126
+#define SQLITE_VERSION "3.27.1"
127
+#define SQLITE_VERSION_NUMBER 3027001
128
+#define SQLITE_SOURCE_ID "2019-02-08 13:17:39 0eca3dd3d38b31c92b49ca2d311128b74584714d9e7de895b1a6286ef959a1dd"
129129
130130
/*
131131
** CAPI3REF: Run-Time Library Version Numbers
132132
** KEYWORDS: sqlite3_version sqlite3_sourceid
133133
**
134134
--- src/sqlite3.h
+++ src/sqlite3.h
@@ -121,13 +121,13 @@
121 **
122 ** See also: [sqlite3_libversion()],
123 ** [sqlite3_libversion_number()], [sqlite3_sourceid()],
124 ** [sqlite_version()] and [sqlite_source_id()].
125 */
126 #define SQLITE_VERSION "3.27.0"
127 #define SQLITE_VERSION_NUMBER 3027000
128 #define SQLITE_SOURCE_ID "2019-02-07 17:02:52 97744701c3bd414e6c9d7182639d8c2ce7cf124c4fce625071ae65658ac61713"
129
130 /*
131 ** CAPI3REF: Run-Time Library Version Numbers
132 ** KEYWORDS: sqlite3_version sqlite3_sourceid
133 **
134
--- src/sqlite3.h
+++ src/sqlite3.h
@@ -121,13 +121,13 @@
121 **
122 ** See also: [sqlite3_libversion()],
123 ** [sqlite3_libversion_number()], [sqlite3_sourceid()],
124 ** [sqlite_version()] and [sqlite_source_id()].
125 */
126 #define SQLITE_VERSION "3.27.1"
127 #define SQLITE_VERSION_NUMBER 3027001
128 #define SQLITE_SOURCE_ID "2019-02-08 13:17:39 0eca3dd3d38b31c92b49ca2d311128b74584714d9e7de895b1a6286ef959a1dd"
129
130 /*
131 ** CAPI3REF: Run-Time Library Version Numbers
132 ** KEYWORDS: sqlite3_version sqlite3_sourceid
133 **
134

Keyboard Shortcuts

Open search /
Next entry (timeline) j
Previous entry (timeline) k
Open focused entry Enter
Show this help ?
Toggle theme Top nav button