/ 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 65fa1164f035d270.

2010-11-19
23:50
Merge all the latest changes from the trunk into the apple-osx branch. check-in: c8bc057c user: drh tags: apple-osx
18:51
Merge the checkpoint_fullfsync pragma and the superlock demonstration into the checkpoint-v2 experimental branch. Closed-Leaf check-in: ebf74015 user: drh tags: blocking-checkpoint
18:48
Add tests for "PRAGMA checkpoint_fullfsync". check-in: 765aa1b8 user: dan tags: trunk
18:36
Merge in the superlock demonstration changes. check-in: 570e79a8 user: drh tags: trunk
18:23
Add the checkpoint_fullfsync pragma which enables F_FULLFSYNC on checkpoint operations only, not during ordinary commit fsyncs. check-in: a0698673 user: drh tags: trunk
18:20
Add file test_superlock.c with example code for obtaining an exclusive lock on either rollback or wal mode databases. Closed-Leaf check-in: 1a3e7417 user: dan tags: superlock
14:37
Add the SQLITE_FCNTL_FILE_POINTER verb to sqlite3_file_control(). check-in: 4425b064 user: drh tags: superlock
09:58
Add file test/tt3_checkpoint.c that adds a multi-threaded test for blocking checkpoints to threadtest3. check-in: 648dd157 user: dan tags: blocking-checkpoint
07:17
Add extra test cases for blocking checkpoints. check-in: ac348ae2 user: dan tags: blocking-checkpoint
04:22
Lemon: Fixed compiler warning on Visual C++. Closed-Leaf check-in: 892c5f37 user: icculus tags: lemon-update-2010
04:19
Lemon: correcting previous win32 access() fix.    The previous fix caused link errors when compiled as C++. check-in: bd03d333 user: icculus tags: lemon-update-2010
03:55
Lemon: Patched to compile with Visual Studio. check-in: 0b945101 user: icculus tags: lemon-update-2010
2010-11-18
19:28
Fixes for SQLITE_BUSY handling in blocking checkpoint code. check-in: 4c663a4d user: dan tags: blocking-checkpoint
16:59
Merge with latest trunk fix. check-in: a8910e89 user: dan tags: blocking-checkpoint
16:58
Ensure tcl is using utf-8 as the system encoding when running capi3e.test. check-in: 0a95589f user: dan tags: trunk
16:32
Merge with latest trunk changes. check-in: e376480f user: dan tags: blocking-checkpoint
16:14
Update test cases to account for the change in the previous commit. check-in: ae089ec8 user: dan tags: blocking-checkpoint
15:44
Added some tests to check that umlaut characters are supported in filenames. check-in: c36f275d user: shaneh tags: trunk
13:52
Restrict the scope of the fts3ExprCost() subroutine inside of FTS3. check-in: 76681870 user: drh tags: trunk
13:47
Fix compiler warnings. check-in: 6c4f1d5c user: drh tags: trunk
12:31
Prevent a possible segfault when the sqlite3_value_numeric_type() interface is misused to try to determine the numeric type of the NULL value returned from sqlite3_column_value() with an invalid column number. check-in: 501b743b user: drh tags: trunk
12:11
Modify the interface to the blocking wal-checkpoint functionality. check-in: 72787c01 user: dan tags: blocking-checkpoint
2010-11-17
02:02
Restrict the scope of the sqlite3_stmt_readonly() interface to a specific subset of prepared statement types. check-in: 919b06c3 user: drh tags: trunk
2010-11-16
23:10
Adding the sqlite3_stmt_readonly() interface. check-in: fd5b2f23 user: drh tags: trunk
18:56
Add experimental command "PRAGMA wal_blocking_checkpoint", which uses the busy-handler to block until all readers have finished in order to ensure the next writer will be able to wrap around to the start of the log file. check-in: 7e3fc2c8 user: dan tags: blocking-checkpoint
02:49
Use the estimated number of rows computed for subqueries in the cost computations for outer queries. check-in: 56bbc539 user: drh tags: trunk
2010-11-15
21:50
Change the EQP output for the min/max optimization from "SCAN" to "SEARCH". Other changes in where.c in support of full branch coverage testing. check-in: d52b5939 user: drh tags: trunk
16:29
Fix the EQP logic so that it correctly reports OOM errors while formatting "detail" text. check-in: 136c2ac2 user: drh tags: trunk
16:12
Change some test cases to account for the new EXPLAIN QUERY PLAN output. check-in: 88a854e1 user: dan tags: trunk
14:51
Test some example code from documentation page eqp.html. check-in: 547bc2c2 user: dan tags: trunk
14:44
Merge the EXPLAIN QUERY PLAN changes from experimental into trunk. check-in: ce27bf38 user: drh tags: trunk
11:35
Minor additions to vacuum.test. check-in: a397ed16 user: dan tags: trunk
2010-11-13
16:42
Change the EXPLAIN QUERY PLAN output to use "USING INDEX" instead of "BY INDEX", and to use "SEARCH" instead of "SCAN" for loops that are not full-table scans. Closed-Leaf check-in: 6611b76b user: dan tags: experimental
2010-11-12
17:41
Add EXPLAIN QUERY PLAN test cases to check that the examples in the documentation work. check-in: 85fdad85 user: dan tags: experimental
15:49
Change the test_multiplex.c code to use wrapper functions for all sqlite3_vfs methods (instead of copying function pointers from the underlying vfs into the multiplex vfs). This is required to work with test_osinst.c. check-in: 1244ef9f user: dan tags: trunk
15:36
Reduce the number of branches that need to be tested in the explainIndexRange() function of where.c. check-in: 6fdae9a6 user: drh tags: experimental
2010-11-11
17:48
Use "COMPOUND" instead of "COMPOSITE" in the EXPLAIN QUERY PLAN output to describe UNION, UNION ALL, EXCEPT and INTERSECT operations. check-in: 28643b85 user: dan tags: experimental
16:46
Add a row of EXPLAIN QUERY PLAN output for each composite select operation (UNION, EXCEPT etc.) in the query. check-in: 00fb8468 user: dan tags: experimental
11:43
Fix a bug in the EXPLAIN QUERY PLAN code. check-in: 7ae06895 user: dan tags: experimental
10:36
Modifications to test cases to account for new EXPLAIN QUERY PLAN output. check-in: 30904ef8 user: dan tags: experimental
2010-11-09
20:33
Fix an assert that fired incorrectly when PRAGMA omit_readlock was set. check-in: e0687582 user: shaneh tags: trunk
20:08
Add "PRAGMA checkpoint_fullfsync". Similar to "PRAGMA fullfsync", but enables full fsyncs only during checkpoint operations. Update: This change was added to the trunk by check-in [a069867301de3ca2e17] Closed-Leaf check-in: 756589ad user: dan tags: apple-osx-exp
17:49
Merge with latest trunk changes. check-in: 4b5c93bc user: dan tags: experimental
17:35
Add missing comments and fix other issues with routines used by new EQP features. check-in: 925f35c5 user: dan tags: experimental
14:49
Further enhancements and fixes for explain query plan. check-in: 73c93f5a user: dan tags: experimental
01:53
Back out the prior attempt to enable full-fsync for WAL and attempt the same thing using a completely different approach. check-in: f59949fa user: drh tags: apple-osx-exp
00:47
Experimental changes to test defaulting to fullfsync for WAL mode check-in: 77b343cf user: adam tags: apple-osx-exp
00:43
Integrated proxy locking file support for WAL journal mode and double free fix check-in: fd4d38fa user: adam tags: apple-osx
2010-11-08
19:16
Changes to the multiplex VFS to optionally (compiler define) allow the "chunk extension" to overwrite the right-most chars of the filename instead of simply being appended. check-in: 07da0a0b user: shaneh tags: trunk
19:01
Experimental changes to EXPLAIN QUERY PLAN. check-in: f4747eb8 user: dan tags: experimental
2010-11-05
20:50
Fix to xTruncate and more journal mode tests for the multiplex VFS. check-in: 65fa1164 user: shaneh tags: trunk
18:07
Fix os_unix.c so that it works with the test_multiplex module. check-in: 72ba3e36 user: dan tags: trunk
17:51
More tests and added support for xDelete in multiplex VFS. check-in: f2004b44 user: shaneh tags: trunk
03:58
Additional error checking and tests for multiplex VFS. check-in: 1ab9a592 user: shaneh tags: trunk
03:43
Additional tests and commenting for the multiplex VFS. check-in: 8ed944ba user: shaneh tags: trunk
00:04
Update the configure script for version 3.7.4. check-in: 18a73795 user: drh tags: trunk
00:01
Merge the multiplexer VFS demo into the trunk. check-in: 1635d927 user: drh tags: trunk
00:00
Fix the Makefile.in so that it works with the multiplexer VFS. Closed-Leaf check-in: 54e2efb6 user: drh tags: experimental
2010-11-04
21:14
Back out an unintended change to permutations.test. check-in: 57fe3535 user: drh tags: experimental
21:13
Another change for testing on Windows. check-in: 2625886b user: shaneh tags: experimental
21:03
Fix the main.mk makefile to include test_multiplex.c for testfixture. check-in: c27c5118 user: drh tags: experimental
20:50
First attempt at a sharding VFS to split large DBs. check-in: dd4dc8a4 user: shaneh tags: experimental
20:47
Fix icon size so it's really 32x32. check-in: 62c494f6 user: shaneh tags: experimental
20:46
Updates for Windows. check-in: cc9d9a12 user: shaneh tags: experimental
04:47
Include the print_pager_state() function only if SQLITE_DEBUG is defined. check-in: 3104f17e user: dan tags: trunk
2010-11-02
17:41
Changes to allow FTS4 tables to be created without the underlying %_docsize table (in order to save space). check-in: 31989b18 user: dan tags: trunk
15:26
Add evidence marks for the sqlite3_blob_reopen() interface. Fix compiler warnings in test1.c. Fix incorrect evidence marks on e_select.tcl. check-in: 3771faa8 user: drh tags: trunk
2010-11-01
18:45
Add test cases to restore coverage of pager.c and wal.c. check-in: 6cae5529 user: dan tags: trunk
17:38
If a database file with the WAL flag set is opened in exclusive-locking mode, use heap memory to store the wal-index instead of shared-memory. check-in: 8dd5c691 user: dan tags: trunk
14:34
Change the version number to 3.7.4. check-in: db64843b user: drh tags: trunk
05:54
Fix a broken test case in exclusive.test. check-in: 582db832 user: dan tags: trunk
05:42
Changes to test scripts so that they work with SQLITE_ENABLE_ICU. check-in: 465c819f user: dan tags: trunk
2010-10-31
22:47
Fix a test module comment typo reported on the mailing list. check-in: 87eb1f04 user: drh tags: trunk
22:42
Fix a typo in a comment inserted by the amalgamation builder. Typo reported on the mailing list. check-in: 6a6bb6ce user: drh tags: trunk
2010-10-30
15:21
Test cases and minor changes to make fts3 more robust in the face of a corrupt database. check-in: b7702905 user: dan tags: trunk
2010-10-29
18:45
Add extra test cases and changes to fts3 to avoid crashing on a corrupt database. check-in: 252f0e45 user: dan tags: trunk
2010-10-28
15:52
Add new "dynamic_triggers" test case to threadtest3.c. check-in: a4691563 user: dan tags: trunk
15:49
This was suppose to go on "trunk" but got committed to the wrong branch. Add new "dynamic_triggers" test case to threadtest3.c. Closed-Leaf check-in: d9e588ef user: dan tags: mistake
11:31
Enforce the MAX_EXPR_DEPTH limit while building expression trees during SQL parsing. check-in: 2625eee0 user: dan tags: trunk
2010-10-27
19:23
Add tail recursion to the sqlite3ExprDelete() routine in order to keep down stack space usage for really, really large expressions. Later: The tail recursion is dangerous since the recursion might happen after the expression has been freed. check-in: 7324c7f2 user: drh tags: mistake
19:08
Avoid trying to allocate a negative number of bytes of memory in the test wrapper for sqlite3_blob_read(). check-in: 739b5d9a user: dan tags: trunk
18:10
Merge experimental fts3/fts4 changes with trunk. check-in: 988164cf user: dan tags: trunk
16:52
Fix a buffer overread in fts3 that can occur if the database is corrupt. Closed-Leaf check-in: 84194c41 user: dan tags: experimental
15:36
Fix a memory leak in the update_hook method of the TCL interface. check-in: 1d17e3dc user: drh tags: trunk
10:55
In fts4, store the total number of bytes of for all records in the table in the %_stat table. check-in: 941647d1 user: dan tags: experimental
2010-10-26
18:42
Structural coverage tests for vdbeblob.c. Including experimental new API sqlite3_blob_reopen(). check-in: 97c6b261 user: dan tags: experimental
11:56
Add missing header comments for changes related to the experimental sqlite3_blob_reopen() API. check-in: d1cc5c93 user: dan tags: experimental
07:14
More coverage tests for fts3.c. check-in: 7a2f2864 user: dan tags: experimental
2010-10-25
19:01
Further improvements to coverage of fts3.c. Fixes for bugs revealed by the same. check-in: 918b6092 user: dan tags: experimental
12:47
Test coverage improvements for fts3.c. check-in: a8b1d998 user: dan tags: experimental
09:01
Add test for matchinfo when a phrase includes some common tokens. check-in: 80a54ebc user: dan tags: experimental
2010-10-23
19:07
Fixes for the matchinfo() function related to FTS4 common token handling. check-in: deb80eac user: dan tags: experimental
2010-10-22
19:03
Add new test file fts3defer2.test. check-in: 5a4d5bfc user: dan tags: experimental
16:44
Add missing comments and fix compiler warnings in new FTS3/4 code. Other minor fixes too. check-in: 1c9c70fe user: dan tags: experimental
13:55
Prevent an assert from failing when opening a zero-length database file with an apparently hot journal with locking_mode=exclusive set. check-in: f000ac1e user: dan tags: trunk
2010-10-21
22:58
Make sure the estimated row count for ephemeral tables is initialized so that automatic indices can be used on those tables. check-in: d30f7b2d user: drh tags: trunk
15:49
Merge trunk changes into experimental branch. check-in: fd1e5cad user: dan tags: experimental
15:12
Fix some segfaults that could occur in obscure circumstances where error messages contained characters that could be mistaken for printf format specifiers. check-in: f91471e7 user: dan tags: trunk
12:34
Fix a typo-bug that prevented --disable-amalgamation from working in Makefile.in. Also fix an overly long line in Makfile.in. check-in: 2c3c4ba0 user: drh tags: trunk
03:13
Add new WHERETRACE macros for better diagnostics of the query planner. Added a new test case for the performance regression fixed by the previous check-in. check-in: 1e0db997 user: drh tags: trunk