/ Timeline
Login
SQLite training in Houston TX on 2019-11-05 (details)
Part of the 2019 Tcl Conference

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

100 check-ins occurring around 2247649ca215c062.

2016-07-06
18:42
Add the SQLITE_DBSTATUS_CACHE_USED_SHARED sqlite3_db_status() parameter. This option is similar to DBSTATUS_CACHE_USED, except that it divides memory used by shared caches evenly between all connections. check-in: 06cf2680 user: dan tags: trunk
18:12
Change the name of the SQLITE_DBSTATUS_PROPORTIONAL_CACHE_USED to SQLITE_DBSTATUS_CACHE_USED_SHARED. Closed-Leaf check-in: d58401ab user: dan tags: dbstatus-prop-cache-used
10:17
Fix a test script problem causing a test to fail if the ICU extension is enabled. check-in: 0c228f5d user: dan tags: trunk
10:12
Add the SQLITE_DBSTATUS_PROPORTIONAL_CACHE_USED sqlite3_db_status() parameter. check-in: 118321c8 user: dan tags: dbstatus-prop-cache-used
09:19
Fix a memory leak in recently added test code. check-in: 724e4cdc user: dan tags: trunk
08:32
Fix a typo in test program bc_test1.c. check-in: 2c61b7ab user: dan tags: begin-concurrent
2016-07-05
16:11
More fixes to Lemon so that it automatically resets its error counter at the end of a parse. check-in: 2683b375 user: drh tags: trunk
12:47
Attempt to reset the error count in the Lemon-generated parser after a parse failure. check-in: 91889fa3 user: drh tags: trunk
2016-07-04
11:47
Add the sqlite3rbu_state() API. Used to determine the current state (creating OAL, ready to move OAL, incremental-checkpoint, finished or error) of an RBU operation. check-in: 0357875f user: dan tags: trunk
11:34
Add the carray() virtual table as a loadable extension. check-in: d8bc6feb user: drh tags: trunk
2016-07-03
02:35
Change the name of the intarray() extension to carray() and give it an optional third parameter that specifies the datatype as one of 'int32', 'int64', 'double', or 'char*'. 'int32' is the default. Closed-Leaf check-in: a204ba99 user: drh tags: prototype-int-array
2016-07-02
20:57
Fix an off-by-one comparison in the intarray() virtual table. Get the intarray() virtual table tests working using the legacy makefile. check-in: 7c3d441f user: drh tags: prototype-int-array
20:51
Merge the alternative table-valued function RHS of IN operator implementation from trunk. check-in: 507fdbfb user: drh tags: prototype-int-array
12:33
Fix a problem in table-valued functions on the RHS of an IN operator that occurs following an OOM error. check-in: bead151e user: drh tags: trunk
12:08
Add support for table-valued functions on the RHS of an IN operator. check-in: ac6000f0 user: drh tags: trunk
2016-07-01
20:12
Fix the transitive constraint logic error that can result in a null pointer dereference. Fix for ticket [e8d439c77685eca6]. check-in: 228a7879 user: drh tags: trunk
19:48
Add test cases to the transitive constraint fix. Closed-Leaf check-in: c952af89 user: drh tags: planner-fix
12:39
Add the sqlite3rbu_state() API. Used to determine the current state (creating OAL, ready to move OAL, incremental-checkpoint, finished or error) of an RBU operation. Closed-Leaf check-in: 92e7df0f user: dan tags: rbu-state-api
2016-06-29
06:19
Add the ability to have a table-valued function on the RHS of an IN operator. check-in: ba1b441b user: drh tags: prototype-int-array
05:08
Another test case for the intarray($PTR,$N) virtual table. check-in: 06e1fab7 user: drh tags: prototype-int-array
05:00
Add a prototype intarray($PTR,$N) table valued function. check-in: 233b3338 user: drh tags: prototype-int-array
2016-06-28
22:27
Proposed fix for a problem in the query planner. check-in: a33d2356 user: drh tags: planner-fix
2016-06-26
04:06
Prevent the WhereLoop.rSetup cost estimate from going negative on complex queries. check-in: f8105085 user: drh tags: trunk
2016-06-25
11:43
Fix the handling of OP_Eq opcodes that compare a register against itself and that require an affinity change. check-in: 507014e4 user: drh tags: trunk
2016-06-24
06:23
Fix the ctime.test script so that it works with clang. check-in: 77e4f7a3 user: drh tags: trunk
02:50
Fix the Makefile.in to avoid unnecessary recompiles of sqlite3.c. check-in: 67c39e16 user: drh tags: trunk
02:21
Provide for a separate default page size for TEMP and transient database files and initialize that separate default page size to 1024 instead of 4096. Leaf check-in: a2778ae4 user: drh tags: temp-page-size
2016-06-23
16:48
Update the sqldiff utility so that if the --vtab switch is specified "rtree", "fts3", "fts4" and "fts5" tables are diff'd directly and the underlying real database tables ignored. Without this switch, all virtual tables are ignored and the diff is performed on the underlying real tables. check-in: b8671e94 user: dan tags: trunk
12:35
Fix the build for -DSQLITE_OMIT_VIRTUALTABLE check-in: 91113142 user: drh tags: trunk
2016-06-21
10:34
Update the sqldiff utility so that if the --vtab switch is specified "rtree", "fts3", "fts4" and "fts5" tables are diff'd directly and the underlying real database tables ignored. Without this switch, all virtual tables are ignored and the diff is performed on the underlying real tables. Closed-Leaf check-in: 5d0a9d4c user: dan tags: sqldiff-vtab-support
2016-06-20
17:25
For a table on the rhs of a LEFT JOIN operator, do not include terms like "IS NULL" from the WHERE clause in the cursor-hint. These may be false for rows that the cursor would otherwise visit, but true for a row of all NULL values generated by the LEFT JOIN. check-in: 913e5956 user: dan tags: trunk
17:22
Allow LIKE operators that appear in a WHERE clause to be included in the cursor-hint for a cursor on the rhs of a LEFT JOIN. Closed-Leaf check-in: 7455d932 user: dan tags: cursor-hints
2016-06-17
19:27
Include WHERE terms in the cursor-hint passed to a cursor opened for the rhs of a LEFT JOIN iff we can be sure that those terms will not evaluate to true if the LEFT JOIN generates a row of NULLs. check-in: 998095ab user: dan tags: cursor-hints
14:59
Fix a duplicate test name in cursorhint2.test. check-in: fcd12b69 user: dan tags: cursor-hints
14:47
Fix a typo in the cursorhint2.test script. check-in: c1a5a57c user: dan tags: cursor-hints
14:33
If a table is on the rhs of a LEFT JOIN, include only terms from the joins ON(...) clause in the cursor-hint passed via OP_CursorHint. check-in: 2a2346b0 user: dan tags: cursor-hints
13:01
Add the json_quote() function to the JSON1 extension. Closed-Leaf check-in: 2c3714ae user: drh tags: json_quote
2016-06-16
17:14
Add a missing OP_ColumnsUsed opcode to code for expressions like "? IN (SELECT ...)" in cases where expression can use an index that may contain NULL values. check-in: 0b1579ca user: dan tags: trunk
11:16
Fix a typo in a comment on the SrcList object. check-in: 48b555c4 user: drh tags: trunk
2016-06-15
10:21
Merge changes from trunk. check-in: 0f707d15 user: drh tags: apple-osx
2016-06-13
19:58
Fix RBU so that it builds with -DSQLITE_ENABLE_8_3_NAMES. Fix "PRAGMA compile_options" for SQLITE_ENABLE_8_3_NAMES such that it reports the numeric setting: "1" or "2". check-in: 0230ca17 user: drh tags: trunk
15:59
Fix the declaration of the table implemented by DBSTAT so that it uses correct datatypes. check-in: a1e1cdc5 user: drh tags: trunk
12:51
Fix an incorrect assert() in the btree logic. check-in: fcf6114b user: drh tags: trunk
12:34
Fix the "onecolumn" and "exists" methods of the TCL interface so that they work in combination with the "profile" callback. check-in: d362ba15 user: drh tags: trunk
2016-06-10
22:49
Enhance "PRAGMA table_info" to that it provides information about eponymous virtual tables. check-in: 53a1e5d5 user: drh tags: trunk
2016-06-08
18:07
Prefer to use partial indexes for full table scans when that is possible. check-in: fe187432 user: drh tags: trunk
14:04
Add the "dbhash.exe" utility program that computes a SHA1 hash over the invariant content of an SQLite database file. Free space in the file, the page size, auto_vacuum status, text encoding, and so forth do not change the hash. Only the content matters. check-in: f48a4ad3 user: drh tags: trunk
13:59
Fix an undersized buffer in the SHA1 implementation. Closed-Leaf check-in: fb276815 user: drh tags: dbhash
13:49
Fix the dbhash utility so that it ignores the root page number when hashing the sqlite_master table. Add new command-line options. Add the ability to hash multiple databases with a single command. check-in: 44f157e0 user: drh tags: dbhash
01:03
An initial attempt at a "dbhash" command-line utility. check-in: 2247649c user: drh tags: dbhash
2016-06-07
20:25
Fix the walcrash4.test test module so that it works on windows. check-in: 2091a4c9 user: drh tags: trunk
2016-06-06
20:36
In winFullPathname, translate '/X:' to 'X:' before doing anything else. check-in: e404ad70 user: mistachkin tags: trunk
20:27
Translate filenames of the form "/c:/*" into just "c:/*" on WinRT and Cygwin. (SQLite has long done this for Win32/WinNT.) check-in: f8470ffc user: drh tags: trunk
18:17
Fix lempar.c so that the shift-reduce optimization works for error processing. This is a Lemon issue only and has no impact on SQLite. check-in: 3665a2f5 user: drh tags: trunk
13:24
Initialize the yyerrcnt variable in the lemon parser template. This has no effect on SQLite itself. check-in: 45531654 user: drh tags: trunk
01:54
Small performance boost and size decrease in sqlite3BtreeMovetoUnpacked(). check-in: e106a77d user: drh tags: trunk
01:48
Small performance improvement in the LIKE function. check-in: 5fb0c354 user: drh tags: trunk
01:14
Btree interface refactoring: (1) The sqlite3BtreeKeySize() interface is renamed to sqlite3BtreeIntegerKey() and modified to work only for table btrees with a rowid. (2) The sqlite3BtreeDataSize() interface is renamed to sqlite3BtreePayloadSize() and modified to work with any btree. (3) The sqlite3BtreeDataFetch() and sqlite3BtreeKeyFetch() routines are combined into a single sqlite3BtreePayloadFetch() routine. The result of these changes is a smaller binary and fewer CPU cycles needed to run queries. check-in: 2d831074 user: drh tags: trunk
2016-06-04
21:05
Improved comment on cursorOwnsBtShared(). No changes to code. Closed-Leaf check-in: 5e269c2d user: drh tags: btree-refactor
20:58
Fix a C99-ism and a compiler warning for MSVC. check-in: aa53a36e user: drh tags: btree-refactor
20:37
Change the sqlite3BtreeKeySize() interface into sqlite3BtreeIntegerKey() and make it only work for table btrees. Change sqlite3BtreeDataSize() into sqlite3BtreePayloadSize() and make it work for all btrees. Combine sqlite3BtreeDataFetch() and sqlite3BtreeKeyFetch() into a single sqlite3BtreePayloadFetch() routine. These changes seem to make the b-tree interface more rational and they reduce both binary size and CPU usage. check-in: bef35e18 user: drh tags: btree-refactor
17:12
Allocate KeyInfo objects from lookaside if possible. check-in: b411107a user: drh tags: trunk
16:33
Fix up speedtest1.c so that it will compile and run on SQLite versions prior to 3.6.18 (circa 2009-09-11). check-in: 9583c0fb user: drh tags: trunk
13:57
Remove an unreachable branch in the UNIQUE constraint parsing. check-in: 313e990c user: drh tags: trunk
2016-06-03
18:59
The OR optimization is usable on virtual tables with LIKE, REGEXP and/or GLOB terms in the WHERE clause. check-in: fa3a89fc user: drh tags: trunk
18:44
Add support for virtual tables using a WITHOUT ROWID schema. This merge also includes enhancements to the CSV extension, which is used for testing of the new WITHOUT ROWID virtual table mechanism. check-in: aa7e9d0c user: drh tags: trunk
18:21
Fix a memory leak when a WITHOUT ROWID eponymous virtual table is used. Closed-Leaf check-in: 31b83a7d user: drh tags: without-rowid-vtab
17:27
Disallow access to the rowid column on WITHOUT ROWID virtual tables. check-in: d31c2597 user: drh tags: without-rowid-vtab
13:35
Enhance the sqlite3_load_extension() interface to permit extensions to return SQLITE_OK_LOAD_PERMANENTLY which will prevents unloading when the database connection closes. check-in: 5908aa4d user: drh tags: trunk
01:01
Performance optimizations on the CSV virtual table. Disallow WITHOUT ROWID virtual tables that have an xUpdate method, for now. check-in: 3134b326 user: drh tags: without-rowid-vtab
2016-06-02
23:13
Add the CSV extension to the test fixture. Fix a memory leak in the CSV extension. Add test cases for the CSV extension, including one that uses a WITHOUT ROWID virtual table participating in the OR optimization. check-in: 95f483e8 user: drh tags: without-rowid-vtab
17:44
Add the data= parameter to the CSV virtual table extension. check-in: 76919104 user: drh tags: without-rowid-vtab
16:22
Fix corner cases in the WITHOUT ROWID virtual table logic. check-in: a393bbb9 user: drh tags: without-rowid-vtab
2016-06-01
10:37
Fix an issue preventing RBU vacuum from working with virtual tables. check-in: 3bd85fa5 user: dan tags: trunk
05:02
Fix compilation issues with the VFS stat extension. check-in: f6e95652 user: mistachkin tags: trunk
2016-05-31
21:18
An experimental branch with code that allows virtual tables to be declared as WITHOUT ROWID tables. This might be useful for virtual tables that model external data sources that do not have a convenient way of computing a unique rowid. The current check-in almost works, but there are still serious issues. check-in: 49638f18 user: drh tags: without-rowid-vtab
18:44
Add the columns=N parameter to the CSV extension. check-in: 28ebeadd user: drh tags: trunk
18:08
Add the testflags parameter to the csv extension. check-in: b93fb2fe user: drh tags: trunk
16:22
Add the "csv" virtual table for reading CSV files, as an extension in the ext/misc/ subfolder. check-in: 00d3570c user: drh tags: trunk
2016-05-30
08:28
Fix an FTS5 problem (segfault or incorrect query results) with "... MATCH 'x OR y' ORDER BY rank" queries when either token 'x' or 'y' is completely absent from the dataset. check-in: 64ca1a83 user: dan tags: trunk
05:45
Minor tweaks to the bc_test1 test program. check-in: d0d0bab4 user: dan tags: begin-concurrent
2016-05-28
18:53
Experimental change to allow virtual tables to take advantage of LIKE, REGEXP and GLOB terms that are part of OR expressions within WHERE clauses. Closed-Leaf check-in: 242507b4 user: dan tags: vtab-experimental
17:45
Remove an unnecessary malloc from the vfsstat extension. check-in: 24f258c2 user: drh tags: trunk
17:23
Enhance the sqlite3_load_extension() interface to permit extensions to return SQLITE_OK_LOAD_PERMANENTLY which will prevent the extensions from unloading when the database connection closes. Closed-Leaf check-in: d3f99a5e user: drh tags: load-permanently
15:22
Enhance "PRAGMA compile_options" so that it shows the version of the compiler used to generate the executable, for common compilers. check-in: 6a0f2009 user: drh tags: trunk
15:09
Update the amalgamation-tarball configure script so that it can use header file "readline/readline.h" with library file "libedit". check-in: cbf72b04 user: dan tags: trunk
15:03
Enhance the sqlite3_load_extension() API so that the first parameter (the "db" parameter) can be NULL. An extension that is not associated with any database connection remains loaded for the life of the process. Closed-Leaf check-in: 3a461043 user: drh tags: persistent-extensions
14:53
Add the vfsstat.c loadable extension - a VFS shim that measures the amount of I/O, and an eponymous virtual table that is used to extract and view the measurements. check-in: 0987487d user: drh tags: trunk
00:13
Clang can define _MSC_VER in some circumstances; therefore, check for Clang first. Closed-Leaf check-in: 3f710bc3 user: mistachkin tags: ctimeCompiler
2016-05-27
21:13
Check for Clang before GCC. check-in: 7c2cd4b0 user: mistachkin tags: ctimeCompiler
20:30
Remove surplus quotation marks from the COMPILER= compile_options setting for Clang. check-in: 5c966f20 user: mistachkin tags: ctimeCompiler
19:34
Remove surplus quotation marks from the COMPILER= compile_options setting for GCC. check-in: 664c132d user: drh tags: ctimeCompiler
18:09
Add basic compiler information to the results of 'PRAGMA compile_options'. check-in: d734e2df user: mistachkin tags: ctimeCompiler
12:30
Improvements to WHERE-clause debug tracing. Show TK_MATCH expressions and show more details on WhereTerm traces. check-in: 71087c12 user: drh tags: trunk
04:10
Fix Lemon so that it actually works with -DYYSTACKDEPTH=0. check-in: a9be4c2d user: drh tags: trunk
01:07
Fix the Lemon-generated parser so that it compiles with -DYYSTACKDEPTH=0. It does compile now, but there are subtle issues still. check-in: 28d439f8 user: drh tags: trunk
2016-05-26
20:56
Add a new OP_SeekRowid opcode, that combines the functions of OP_MustBeInt and OP_NotExists. This makes the code slightly smaller and faster. check-in: ffe80a1b user: drh tags: trunk
20:52
Add further instrumentation to the bc_test1.c test app. check-in: 5528de4a user: dan tags: begin-concurrent
2016-05-25
18:53
Add the libvers.c tool in the tool/ subdirectory. check-in: 2a41f098 user: drh tags: trunk
2016-05-24
18:55
Enhance Lemon and the parser template so that it can once again build parsers that have no unreachable branches. check-in: 41fd46e2 user: drh tags: trunk