/ 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 3d076094ce411bff.

2016-03-31
21:16
Enhance the query planner so that IS and IS NULL operators are able to drive an index on a LEFT OUTER JOIN. check-in: f1e6bb95 user: drh tags: branch-3.9
20:40
Enhance the query planner so that IS and IS NULL operators are able to drive an index on a LEFT OUTER JOIN. check-in: c648539b user: drh tags: trunk
15:08
Add another OOM test to this branch. Closed-Leaf check-in: 49763fc3 user: dan tags: session-retry
10:50
Add further tests for the code on this branch. Fix a problem in OOM handling. check-in: 195f3340 user: dan tags: session-retry
02:44
Enhanced comments describing the sessions file format. No changes to code. check-in: 84dc41e2 user: drh tags: session-retry
00:45
Fix the return code in sessionRetryConstraints(). check-in: ea917c14 user: drh tags: session-retry
2016-03-30
21:19
Have the sqlite3session_apply() function and its streaming equivalent retry any operations that failed with SQLITE_CONSTRAINT after all other operations on the same table have been attempted. New code is largely untested. check-in: 1085911a user: dan tags: session-retry
16:23
Updates for the MSVC makefiles. check-in: 7cf0cab7 user: mistachkin tags: trunk
16:22
Fix typo in comment. No changes to code. check-in: 64d75cbe user: mistachkin tags: trunk
15:30
Simplifications and clarification to update callback handling in the OP_Delete and OP_Insert opcodes. check-in: 47887ef8 user: drh tags: trunk
14:26
Increase the version number to 3.13.0 on account of the new session extension. check-in: e9bcd5ac user: drh tags: trunk
14:17
Remove a redundant test for disabling RESTRICT with defer_foreign_keys=ON. check-in: 9cdf813c user: drh tags: trunk
13:43
Incorporate the sessions extension and the SQLITE_ENABLE_PREUPDATE_HOOK compile-time option. check-in: 4af7a90f user: drh tags: trunk
12:56
Avoid compiler warnings and excess opcodes when SQLITE_ENABLE_PREUPDATE_HOOK is not used. Fix the EXPLAIN output for P4_TABLE opcodes. Closed-Leaf check-in: 5ab46d76 user: drh tags: sessions
12:20
Improvements to the performance testing program "speedtest1.c" and the shell script that invokes it. check-in: e4bee561 user: drh tags: trunk
2016-03-29
21:19
Fix some code and test coverage issues in fts5_index.c. Leaf check-in: 7635c680 user: dan tags: fts5
10:36
Merge 3.12.0 changes. check-in: d7381eff user: drh tags: begin-concurrent
10:30
Merge 3.12.0 changes. check-in: eef55744 user: drh tags: apple-osx
10:19
Merge changes for 3.12.0. check-in: ed22eb65 user: drh tags: sessions
10:14
Version 3.12.0 check-in: e9bb4cf4 user: drh tags: trunk, release, version-3.12.0
2016-03-28
20:13
Add further tests for savepoint rollback. Fix various code issues and add missing comments in fts5_index.c. check-in: a805c6f7 user: dan tags: fts5
15:06
Integrate the vcreate-stmt branch into this one. check-in: 06039d90 user: dan tags: fts5
14:57
Open a statement transaction for "CREATE VIRTUAL TABLE" statements in order to ensure that if the xCreate() call fails, changes made to the sqlite_master and possibly other tables are rolled back. Closed-Leaf check-in: d0a3853b user: dan tags: vcreate-stmt
11:01
Fix the multiplexor so that it does not assume that the xGetLastError method is non-NULL in the child VFS. check-in: f6a88ccc user: drh tags: trunk
2016-03-26
20:11
Fix a problem with OOM handling when setting an fts5 configuration option. check-in: 53b80a6d user: dan tags: fts5
15:36
More changes to the shellN.test scripts to get them working on all variations of Windows. check-in: 8213c2f5 user: drh tags: trunk
14:41
Remove the catchcmd_collapse_space procedure in tester.tcl - no longer needed. check-in: 3bd499d3 user: drh tags: trunk
13:26
Update shell1.test tests to deal with backslash escaping in TCL on Windows-style pathnames. check-in: 219a251e user: drh tags: trunk
2016-03-25
20:10
Do not run the shell3.test module under mingw because of mingw's dodgy command-line parsing. check-in: a7c080a9 user: drh tags: trunk
17:19
In the Win32 VFS, avoid trying to use rand_s() on Windows CE. check-in: 183350fa user: mistachkin tags: trunk
17:09
Add the catchcmd_collapse_space command and use it to help make shell testing more robust against TCL space escapes. check-in: 93caabb6 user: drh tags: trunk
12:10
Fix two instances of undefined behavior in the C code - both harmless for all current compilers. check-in: 99fd194c user: drh tags: trunk
2016-03-24
20:55
Make test cases in shell1.test robust against TCL deciding to quote strings using lots of backslashes. check-in: 817e93f4 user: drh tags: trunk
20:36
Prevent negative values of SQLITE_DEFAULT_CACHE_SIZE from making SQLITE_WIN32_HEAP_INIT_SIZE negative. check-in: e0737f52 user: mistachkin tags: trunk
15:32
Larger margins for one memsubsys1 range check when running with a non-zero reserved-bytes value. check-in: 6db1d1fb user: drh tags: trunk
15:09
Fix some test scripts so that they work with various permutations. check-in: f4d234b5 user: dan tags: trunk
14:34
Merge the beta changes into sessions. check-in: beb5ea14 user: drh tags: sessions
2016-03-23
17:54
Avoid calling realloc() with a zero size in fuzzcheck.c. check-in: a1fd1469 user: drh tags: trunk
16:32
Fix "ifcapable" tests in capi3.test and capi3c.test so that the tests work with more build configurations. check-in: 3fa88f68 user: dan tags: trunk
15:53
Remove an unused local variable from FTS5. check-in: 0ed693c2 user: drh tags: trunk
15:04
Explicitly limit the size of fts5 tokens to 32768 bytes. check-in: 70fc69ee user: dan tags: trunk
13:46
Update a requirement mark. No changes to code. check-in: 41298464 user: drh tags: trunk
2016-03-22
20:05
The sqlite3_column_decltype() routine should return NULL, not an empty string, if the column has no declared type. check-in: 605eba4a user: drh tags: trunk
15:26
Fix harmless compiler warning for MSVC. check-in: 142cd359 user: mistachkin tags: trunk
15:25
Fix a harmless compiler warning. check-in: 5ace870d user: drh tags: trunk
15:01
Fix some errors in fts5 test scripts. check-in: e1ab2d37 user: dan tags: trunk
14:37
Create the "uptr" typedef (the same as uintptr_t when available) and use it to cast pointers before comparison. check-in: 2484cc0c user: drh tags: trunk
14:10
Avoid the possibility of integer overflow on a pointer comparison test for corruption in the database file. check-in: ff1b1ac3 user: drh tags: trunk
2016-03-21
22:28
Fix harmless compiler warnings. check-in: 25d776e4 user: drh tags: trunk
16:25
Add tests to ensure that fts5 is now deterministic. check-in: 3d076094 user: dan tags: trunk
16:19
Skip recently added test cases in nolock.test when running in the inmemory_journal permutation. check-in: a1dcf7af user: drh tags: trunk
16:06
Remove an unreachable branch from the unlink verification logic in the UNIX VFS. check-in: 4dc30cce user: drh tags: trunk
15:54
Merge all recent changes from trunk. check-in: 8ee7d346 user: drh tags: begin-concurrent
15:32
Merge 3.12.0 beta changes from trunk. check-in: 3296a0ce user: drh tags: sessions
15:30
Have fts5 cache the structure of its index in main memory. Use "PRAGMA data_version" to figure out when this cache should be invalidated. check-in: 902f2217 user: dan tags: trunk
15:18
Rearrange code so that tests pass whether SQLITE_DEBUG is defined or not. Closed-Leaf check-in: 89296a46 user: dan tags: fts5-data-version
14:52
Merge the sqlite3_system_errno() change from trunk. check-in: 063f1b37 user: drh tags: apple-osx
14:46
Add the sqlite3_system_errno() interface. check-in: 4bd12b57 user: drh tags: trunk
12:28
Make sure system errors that occur durign sqlite3_step() are captured for use by sqlite3_system_errno(). Closed-Leaf check-in: b4a1114f user: drh tags: sqlite_system_errno
11:57
Improved comments. No logical changes to code. check-in: a6b6c6c4 user: drh tags: sqlite_system_errno
11:38
Do a better job of capturing all system errno values regardless of when they occur. check-in: 7d49998d user: drh tags: sqlite_system_errno
10:49
Merge updates from trunk. check-in: 86ab8643 user: drh tags: sqlite_system_errno
09:56
Change the way fts5 internally allocates segment ids in order to eliminated non-determinism from the module. check-in: d6e2637d user: dan tags: trunk
00:38
Change the Vdbe.aMem array so that it is zero-based instead of one-based. check-in: c39081e8 user: drh tags: trunk
00:30
Remove an unreachable branch. Improvements to comments. Closed-Leaf check-in: c5677ecd user: drh tags: zero-base-aMem
2016-03-19
23:32
Change the Vdbe.aMem array so that it is zero-based instead of one-based. check-in: e07b0c47 user: drh tags: zero-base-aMem
18:11
Fix exclusive.test so that it works with -DSQLITE_TEMP_STORE=3. check-in: d7852c63 user: dan tags: trunk
18:00
Updates to the Lemon documentation. check-in: f0953414 user: drh tags: trunk
17:48
Add the sqlite3rbu_bp_progress() API to the RBU extension. Used to obtain the percentage progress of an RBU update. check-in: 209e31c7 user: dan tags: trunk
17:09
Fix a problem detecting invalid values in the rbu_control column of an rbu database table. Closed-Leaf check-in: a1132dd9 user: dan tags: rbu-percent-progress
16:21
Update the sqldiff tool so that it generates an rbu_count table. check-in: 1f7afb6e user: dan tags: rbu-percent-progress
15:34
Merge latest trunk changes, including fixes to test script rbudiff.test, into this branch. check-in: 734fc68f user: dan tags: rbu-percent-progress
15:13
Fix another problem in test script rbudiff.test. check-in: 41c29c12 user: dan tags: trunk
14:53
Fix test scripts sqldiff.test and rbudiff.test so that they work with the --testdir option. check-in: 1ffe3cde user: dan tags: trunk
14:47
Add test file fts5multiclient.test. check-in: 7832466f user: dan tags: fts5-data-version
00:40
Fix a VDBE register allocation bug exposed by recent enhancements to PRAGMA integrity_check. check-in: c73b5b9c user: drh tags: apple-osx
00:35
Fix a register allocation bug in the VDBE code generator for PRAGMA integrity_check; check-in: 88439a86 user: drh tags: trunk
2016-03-18
20:12
Add further tests for sqlite3rbu_bp_progress(). Fix a problem in handling WITHOUT ROWID tables in the same. check-in: 65e02368 user: dan tags: rbu-percent-progress
18:56
Change the name of the new API on this branch to "sqlite3_bp_progress". Add tests and documentation for the same. check-in: 1a1b69e8 user: dan tags: rbu-percent-progress
11:03
Test case tweaks to better support the Apple configuration options. check-in: cb0ffe84 user: drh tags: apple-osx
10:29
Add tests for the changes on this branch. Fix a problem with calls to the new progress indicator API made after an rbu update has been resumed. check-in: bf823217 user: dan tags: rbu-percent-progress
00:58
Merge recent enhancements from trunk. check-in: ec052b4f user: drh tags: apple-osx
00:39
Fix FTS5 so that it works with SQLITE_OMIT_AUTORESET. check-in: b199637d user: drh tags: trunk
00:19
Fix more test-case errors in the Apple configuration. check-in: 6631e1e6 user: drh tags: trunk
2016-03-17
23:56
Fix some test cases so that they work under the Apple configuration. check-in: 399c6076 user: drh tags: trunk
23:16
Fix harmless compiler warnings that arise with -DSQLITE_OMIT_LOAD_EXTENSION check-in: 65ba2f0b user: drh tags: trunk
23:00
Changes to releasetest.tcl: Rename the "OS-X" configuration to "Apple". Bring the "Apple" configuration up to date. Allow the use of "if:os=..." arguments in a configuration. Run the Apple configuration on Linux in addition to on Macs, but without -DSQLITE_ENABLE_LOCKING_STYLE. check-in: beb2a80b user: drh tags: trunk
21:06
Add an API to indicate the percentage progress of an rbu update. check-in: ffc58d2c user: dan tags: rbu-percent-progress
19:28
Change the xGetLastError() method on the windows VFS so that it continues to format an error message (if requested) but returns the system error code, rather than an SQLite status code. check-in: 1602f6b5 user: drh tags: sqlite_system_errno
19:07
A more compact implementation of the code generator for the IS and IS NOT operators. check-in: 8607e3ac user: drh tags: trunk
18:41
An alternative method of encoding the wildcard in "SELECT *". This is an experiment. Closed-Leaf check-in: 41335d88 user: drh tags: select-wildcard
17:23
Simple test cases for sqlite3_system_errno() check-in: 185bc864 user: drh tags: sqlite_system_errno
16:01
Experimental implementation of the sqlite3_system_errno() interface. check-in: 6782c87b user: drh tags: sqlite_system_errno
12:39
Fix some OOM-handling issues in the fts5 changes on this branch. check-in: 020a0bda user: dan tags: fts5-data-version
2016-03-16
21:29
The prepared statements for some pragmas can now be reused without invoking an automatic reprepare. check-in: 97b0e88c user: drh tags: trunk
20:53
Merge the changes on the reusable-pragma branch into this one. check-in: 6c4a17b9 user: dan tags: fts5-data-version
20:44
Some pragmas can be reused without an automatic reprepare. Closed-Leaf check-in: db1ce7e1 user: drh tags: reusable-pragma
20:05
Fix a comment on the freelist_count and data_version pragmas. check-in: 10a3e2a0 user: drh tags: trunk
19:53
Add a cast to an implict (size_t -> int) conversion in fts5_expr.c. check-in: d9b5ff7a user: dan tags: trunk
19:48
Have fts5 cache the decoded structure of fts5 indexes in memory. Use "PRAGMA data_version" to detect stale caches. check-in: 33ef2210 user: dan tags: fts5-data-version