/ 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 7aaf8772274422f5.

2011-04-01
17:53
Change analyze7.test so that it works without SQLITE_ENABLE_STAT2 defined. check-in: 9415201c user: dan tags: trunk
16:50
When simulating an error in the close() system call, close the file descriptor anyway. Otherwise long running tests leak too many file-descriptors and crash. check-in: 81ddbf43 user: dan tags: trunk
15:43
Merge latest trunk changes. check-in: d184cf00 user: dan tags: sessions
15:30
If the sessions module is being built as part of the amalgamation, do not try to include sqliteInt.h and vdbeInt.h. check-in: f87bfe6e user: dan tags: sessions
15:15
Ensure that it is not possible to add a column to a system table using ALTER TABLE. check-in: d9707ef8 user: dan tags: trunk
14:26
Merge the ANALYZE-index enhancement into trunk. check-in: 7e237aea user: drh tags: trunk
14:22
Removed dependency on sqliteInt.h so that multiplex VFS shim can be compiled as loadable module. Closed-Leaf check-in: 718f1ad7 user: shaneh tags: multiplex-enhancements
14:04
Test cases for ANALYZE-index. Closed-Leaf check-in: 365896cb user: drh tags: analyze-idx
13:29
Move a variable declaration inside an #ifdef to avoid a compiler warning. check-in: 7a6d05df user: drh tags: trunk
11:56
In os_unix.c, do not return SQLITE_BUSY to SQLite following an error in fcntl(F_UNLCK), regardless of the value of errno. check-in: ff6dfe6e user: dan tags: trunk
09:04
Fix some problems in os_unix.c when compiled with ENABLE_LOCKING_STYLE on OSX. Also some minor issues with test scripts. check-in: 8088031b user: dan tags: trunk
02:26
Fix two compiler errors associated with non-standard compile-time options. check-in: e3bf2d5c user: drh tags: trunk
01:38
Fix a compiler warning and an unreachable branch. Restore 100% branch test coverage. check-in: 4dc148bb user: drh tags: trunk
2011-03-31
18:36
Provide hints to the btree layer Next and Previous primitives to let them know if they can be no-ops if the underlying index is unique. check-in: a5aae174 user: drh tags: branch-3.7.2
15:11
Enable/disable support. check-in: b3c6d9aa user: shaneh tags: multiplex-enhancements
13:14
Add tests and fixes for SELECT multiplex_control(op, val); check-in: fee9734c user: shaneh tags: multiplex-enhancements
05:31
Additional test cases; Round chunk size up to a multiple of max page size; check-in: 36e364a3 user: shaneh tags: multiplex-enhancements
02:03
Change the ANALYZE command so that it will accept an index name as its argument and only reanalyze that one index. A quick smoke-test works. Need to study the implications to the query planner and test corner cases. check-in: c8f9edd9 user: drh tags: analyze-idx
2011-03-30
21:04
Add the SQLITE_ENABLE_PREUPDATE_HOOK compile-time option. check-in: 66345214 user: drh tags: sessions
21:03
Updates to multiplex.test script; misc. bug fixes; check-in: c41ff235 user: shaneh tags: multiplex-enhancements
19:08
Further tests for os_unix.c. check-in: a84f7711 user: dan tags: trunk
17:25
Disable the truncate optimization if there is a preupdate hook. check-in: d051694e user: drh tags: sessions
17:07
Add documentation to the sqlite3_preupdate_hook() interface and its relatives. check-in: 8180f288 user: drh tags: sessions
14:54
Do not generate sqlite_stat1 entries for empty tables when running ANALYZE. Ticket [83ea97620bd31016451] check-in: 3a27af5b user: drh tags: trunk
02:03
Merge in all the latest changes from trunk. check-in: b11d941e user: drh tags: sessions
01:43
Move to an O(NlogN) algorithm for the priority queue. An insertion sort was way too slow. check-in: 7958cbba user: drh tags: word-fuzzer
2011-03-29
23:41
Add support for rowid. check-in: 2cf4158f user: drh tags: word-fuzzer
18:28
Add tests to syscall.test and sysfault.test. check-in: 3d2de011 user: dan tags: trunk
18:21
The first simple test-case appears to be working now. check-in: dd41155b user: drh tags: word-fuzzer
15:40
Fix a problem whereby following an IO error in CommitPhaseTwo() of a multi-file transaction the b-tree layer could be left in TRANS_WRITE state, causing problems later on. check-in: dbe569a0 user: dan tags: trunk
15:00
If the keyword "unordered" appears at the end of the SQLITE_STAT1.STAT column for an index, then use that index for equality lookups only, never for range queries or sorting. Closed-Leaf check-in: 3b964155 user: drh tags: unordered-index-hack
14:08
Further improvements to the fuzzer. It still is not quite working. Pausing to work on other things.... check-in: 5f2f2fce user: drh tags: word-fuzzer
10:04
Fix a problem in the unix VFS implementation of xNextSystemCall(). Also some typos that prevent compilation when HAVE_POSIX_FALLOCATE is defined. check-in: bc6cce81 user: dan tags: trunk
05:06
In-progress changes - do not use; Removed prefix support; Added file control interface to enable/disable and adjust chunk size; added app-def function for same; check-in: bc02d0c1 user: shaneh tags: multiplex-enhancements
01:47
Fix the documentation for the sqlite3_column_*_name() functions to describe that the information can be invalidated when a prepared statement is reprepared by the first invocation of an sqlite3_step() for a particular execution cycle. check-in: 7270f80a user: drh tags: trunk
2011-03-28
19:10
Add test infrastructure (and some tests) to inject faults into os_unix.c using the new xSetSystemCall interface. check-in: 0e1d20df user: dan tags: trunk
2011-03-26
19:04
Added most of the logic. Simple test runs without segfaulting but does not give the correct answer. check-in: fb4c31ea user: drh tags: word-fuzzer
15:05
Skeleton code for the word-fuzzer virtual table. check-in: ea3a4ee1 user: drh tags: word-fuzzer
2011-03-25
19:06
Improve coverage of session module a bit more. check-in: 4255a9f6 user: dan tags: sessions
10:52
Improve coverage of session module code. check-in: 666123c8 user: dan tags: sessions
2011-03-24
17:43
Minor change to sqlite3Utf8Read() to make consistent with READ_UTF8() usage and avoid implementation defined usages of <<. Added some additional UTF-8 test cases. check-in: 7173b392 user: shaneh tags: trunk
17:37
Fix problem with tableapi.test on Windows. check-in: 69fe0c87 user: shaneh tags: trunk
16:53
Fix handling of schema changes mid-session. check-in: 76d2d2ad user: dan tags: sessions
16:04
Fix handling of schema mismatches in sqlite3session.c so that it matches the docs in sqlite3session.h. check-in: 506a0d7a user: dan tags: sessions
11:22
Store primary key definitions for modified tables in changesets. Add the sqlite3changeset_pk() API to extract this data from a changeset iterator. check-in: 54298ee5 user: dan tags: sessions
01:34
The changes to fix [f7b4edece25c9948] mean that the schema is always loaded whenever a prepared statement is running. This means that a couple of branches can be eliminated and one operand of OP_ParseSchema can be removed. check-in: b6e268fc user: drh tags: trunk
2011-03-23
22:54
Fix a signed/unsigned comparison compiler warning. check-in: c81da6f9 user: drh tags: trunk
22:51
Update the test_vfstrace.c shim to conform to the new VFS interface for xSetSystemCall and xGetSystemCall. check-in: ad4dc7b9 user: drh tags: trunk
22:48
Merge in all the latest changes from the trunk, and especially the interface changes to the SystemCall methods of the VFS. check-in: 9c3a6e47 user: drh tags: sessions
22:02
Change the xSetSyscall methods of the VFS so that they do not cast object pointers into function pointers. Fix other unrelated compiler warnings. check-in: e059152a user: drh tags: trunk
18:22
Increase the upper bound on SQLITE_MAX_ATTACHED from 30 to 62. check-in: 7aaf8772 user: drh tags: trunk
17:10
Fix a bug in fts4 to do with matchinfo and deferred tokens. check-in: 30d42dc6 user: dan tags: trunk
16:03
Add the "indirect flag" to the changeset blob format. Also the sqlite3session_indirect() API. check-in: 1feaf2d3 user: dan tags: sessions
11:16
In the shell, make sure the ".log" command has at least one argument. check-in: 1ed5e361 user: drh tags: trunk
10:52
Fix a numbering issue in rtree6.test. Add a couple of extra tests. check-in: 0b7668a7 user: dan tags: trunk
10:38
Change the rtree module to support queries with multiple comparison operators (i.e. > or <) of the same type on a single column. check-in: 387b55aa user: dan tags: trunk
2011-03-22
18:45
Add API function sqlite3_preupdate_depth(), for determining the depth of the trigger stack from within a pre-update callback. check-in: bdea7089 user: dan tags: sessions
16:54
Fix a crash that can follow an OOM when "all tables" are registered with a session module. check-in: 183c236e user: dan tags: sessions
15:21
If a NULL pointer is passed to sqlite3session_attach() in place of a table name, attach all database tables to the session object. check-in: e9037e4e user: dan tags: sessions
12:08
Add OOM tests and related fixes for the session module. check-in: 06048a68 user: dan tags: sessions
02:03
Fix a couple typos for consistency in sessions documentation. check-in: 510198f1 user: shaneh tags: sessions
2011-03-21
19:41
Remove some unreachable code in sqlite3session.c. Add test cases. check-in: 39cdfa53 user: dan tags: sessions
17:17
Merge in the sqlite3_db_config() enhancements for enabling and disabling FKs and triggers from trunk. check-in: 2b3c8b9d user: drh tags: sessions
17:15
Add the ability to enable and disable foreign key constraints and triggers using calls to sqlite3_db_config(). check-in: 09e167f9 user: drh tags: trunk
16:17
Add start of fault-injection tests for session module. Fix some bugs related to the same. check-in: 32e95164 user: dan tags: sessions
11:55
Clarify handling of NULL values in PK columns in sqlite3session.h. Add tests and fixes for the same. check-in: aed42730 user: dan tags: sessions
11:03
Fix session module problems with real (floating point) values. check-in: a192d04f user: dan tags: sessions
07:23
Fix some typos in sqlite3session.h. check-in: 0853e530 user: dan tags: sessions
2011-03-20
11:20
Documentation format updates to sqlite3session.h. check-in: f227f602 user: dan tags: sessions
2011-03-19
19:19
Fix a problem involving session objects and attached databases. check-in: ad91d300 user: dan tags: sessions
18:46
Fix a bug in changeset generation code. check-in: 825df75b user: dan tags: sessions
17:07
Move session1.test from test/ to ext/session/. check-in: c4436a93 user: dan tags: sessions
16:26
Fix a problem with resizing a hash table in sqlite3session.c. check-in: 6e5907e1 user: dan tags: sessions
15:37
Fix some bugs in sqlite3changeset_apply(). check-in: 7250318d user: dan tags: sessions
08:38
Fix a problem with INTEGER PRIMARY KEY columns and the pre-update hook. check-in: 24d4d5dd user: dan tags: sessions
02:37
Merge the fix to ticket [f7b4edece25c99485] into the sessions branch. check-in: 1b736ac2 user: drh tags: sessions
02:04
Add a test case to verify that ticket [f7b4edece25c994857] is fixed. check-in: eedbcf0a user: drh tags: trunk
2011-03-18
21:55
Add a generation counter to the Schema object and enhance OP_VerifySchema to also check the Schema generation. Fix for ticket [f7b4edece25c99]. check-in: 36c04dd1 user: drh tags: trunk
18:03
Hold the database mutex for the duration of an sqlite3changeset_apply() call. Also for the duration of all sqlite3session_xxx() calls. check-in: c615c38c user: dan tags: sessions
16:47
Fixes for compiler warnings. Minor code cleanup. check-in: 9604d130 user: drh tags: sessions
16:13
Further improvements to documentation in sqlite3session.h. check-in: 07019bb9 user: dan tags: sessions
15:13
Fix a memory allocation issues in the preupdate hook so that the hook.test script runs clean in valgrind. check-in: bd94f4c8 user: drh tags: sessions
13:05
Update comments in sqlite3session.h. More to come. check-in: e73e9082 user: dan tags: sessions
12:35
Merge all the latest trunk enhancements into the sessions branch. check-in: 94fd5bb6 user: drh tags: sessions
2011-03-17
19:20
Change to the session module to use user-defined primary keys instead of rowids when collecting changes. check-in: 6614cfcb user: dan tags: sessions
16:45
Update the implementation of ".testctrl" in the command-line shell to use a look-up table rather than a long sequence of if-elses. Shorten source code lines of shell.c to 80 characters or less. check-in: 54bacb95 user: drh tags: trunk
01:58
Comment enhancement to better explain the logic in the "x IS NULL" optimization. check-in: 869f8947 user: drh tags: trunk
01:53
Backport the "x IS NULL" query planner enhancement of [2353176811f] to the 3.7.2 branch. check-in: 68daf20d user: drh tags: branch-3.7.2
01:34
Enhances to the query planner such that "x IS NULL" constraints take the STAT2 statistics into account, just like "x=VALUE" constraints. check-in: 23531768 user: drh tags: trunk
2011-03-16
19:59
Add the sqlite3_preupdate_new() API, for retrieving the new.* values from within a pre-update callback. check-in: 526545c4 user: dan tags: sessions
18:54
Additional interpretation of flags and constants in the VFS trace output. check-in: 3e984195 user: drh tags: trunk
17:05
Add the -vfstrace option to the usage error message in the shell. check-in: baca45c5 user: drh tags: trunk
16:56
Add the VFS-trace shim. check-in: f49a9ef3 user: drh tags: trunk
09:49
Remove the sqlite3_transaction_hook() API. check-in: b0015a1c user: dan tags: sessions
2011-03-15
19:08
Make the "unix-excl" VFS work exactly like "unix" if the database file is read-only. check-in: d9846834 user: drh tags: trunk
18:35
Fix an out-of-order variable declaration in shell.c. check-in: 72570846 user: drh tags: trunk
16:37
Fix some bugs and other code issues in the session module. check-in: f2930840 user: dan tags: sessions
04:45
Allow multiplex file names to be preceeded by prefix of the form ":multiplex:chunksize:maxchunks:" Still work to be done, though it compiles and prefixes are ignored. check-in: cfa4a2f7 user: shaneh tags: multiplex-enhancements
02:55
Fix cut-and-paste typo in debugging print statement in winMutexTry(). check-in: def98fd2 user: shaneh tags: trunk
2011-03-14
19:49
Fix handling of return values from the conflict handler. Document the conflict handler arguments and return codes in sqlite3session.h. check-in: cbbb274e user: dan tags: sessions