/ 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 93e0be2bbf16d66d.

2011-06-17
16:04
Add a missing declaration to fts3Int.h. check-in: 3bfd4466 user: dan tags: trunk
15:57
Fix a few more issues with the nmake makefile. check-in: a117005f user: shaneh tags: trunk
15:55
Update walro.test script for Windows. check-in: d6443f8e user: shaneh tags: trunk
15:54
Force almagamation gen scripts to use unix line endings for consistency across platforms. check-in: a4adc7f7 user: shaneh tags: trunk
07:22
More updates to the nmake makefile. check-in: 55bb56d3 user: shaneh tags: trunk
07:07
Add Microsoft nmake compatible makefile; update a few test cases for Windows. check-in: a7590af6 user: shaneh tags: trunk
2011-06-16
16:06
Fix a problem with NEAR queries executed inside a transaction that writes the FTS table. check-in: 051c756c user: dan tags: trunk
00:54
Changes to #ifdefs so that the build goes correctly if the only FTS macro defined is SQLITE_ENABLE_FTS4. check-in: a0b43a32 user: drh tags: trunk
2011-06-15
23:34
Fix the multiplex.test module so that it works with the inmemory_journal permutation. check-in: 03d9480f user: drh tags: trunk
19:18
Further tweaks to the wal7.test test case. check-in: 177e2d72 user: drh tags: trunk
17:04
Add a couple of pointer type casts to test file test_quota.c. check-in: 0df061b0 user: dan tags: trunk
16:07
Fix the wal7.test script so that it works even if secure_delete is engaged. check-in: 68fb7a54 user: drh tags: trunk
13:11
Merge the improved incremental doclist loading test from the broken-build branch (which is now fixed) into trunk. check-in: f9750870 user: drh tags: trunk
13:02
Fix so that the TCL test harness works even if SQLITE_ENABLE_FTS is omitted. Closed-Leaf check-in: 63ebcb52 user: drh tags: broken-build
12:43
Fix a couple of compiler warnings. check-in: 3899f3b9 user: drh tags: broken-build
08:30
Add an interface to better test incremental loading of doclists by FTS4. Also some tests for this and term prefix queries. check-in: 7a381313 user: dan tags: broken-build
2011-06-14
14:18
Fix a memory leak that can follow an OOM error in a user-function that uses sqlite3_set_auxdata(). check-in: 0185c4b6 user: dan tags: trunk
11:50
Merge fts3-prefix-search branch with trunk. check-in: b1f9c1e0 user: dan tags: trunk
11:32
Add a couple of extra tests. Closed-Leaf check-in: aefd46df user: dan tags: fts3-prefix-search
09:00
Fix another bug caused by NEAR/matchinfo/order=DESC interaction. check-in: 04907fba user: dan tags: fts3-prefix-search
07:22
Merge recent trunk changes into fts3-prefix-search branch. check-in: 135ce30f user: dan tags: fts3-prefix-search
07:14
Remove unused parameters from internal fts3 function. check-in: 06de3f2c user: dan tags: fts3-prefix-search
2011-06-13
18:21
Update trace2.test to account for new FTS queries. check-in: 2c201292 user: dan tags: fts3-prefix-search
17:00
Add tests for deferred tokens to fts3auto.test. Fix a problem with OR queries and deferred tokens. check-in: b9fb69e5 user: dan tags: fts3-prefix-search
13:48
Changes to fts3auto.test to test OR, AND and NOT operations. check-in: e4ab6cdb user: dan tags: fts3-prefix-search
12:19
Use only unsigned values in the implementatin of LIKE and GLOB so that values won't overflow to negative when dealing with malformed UTF8. check-in: 77f01578 user: drh tags: trunk
09:11
Fix a bug exposed by combining matchinfo(), NEAR and "ORDER BY rowid DESC". check-in: 5f6b87f4 user: dan tags: fts3-prefix-search
2011-06-10
18:33
When updating a field that requires foreign key constraints be checked, ensure that the indexes and tables are consistent when the FK logic is run. Otherwise, it may detect the inconsistency and report database corruption. check-in: 2b3d9996 user: dan tags: trunk
16:33
Fix minor problems with foreign key constraints where the parent table is the same as the child table. check-in: 442d8d8b user: dan tags: trunk
2011-06-09
17:53
Fix a line in pcache1.c where a global data structure is accessed without using the GLOBAL() macro. This causes a subtle malfunction on test systems that use SQLITE_OMIT_WSD. check-in: b11b2e1f user: dan tags: trunk
10:48
Fix problems to do with using both OR and NEAR operators in a single expression. check-in: 4e8dd19e user: dan tags: fts3-prefix-search
2011-06-08
18:39
Fix various issues to do with deferred tokens, NEAR expressions and matchinfo(). check-in: 3972a787 user: dan tags: fts3-prefix-search
2011-06-07
18:35
Have NEAR queries use incremental merging. Fix issues surrounding the deferred token optimization. check-in: 9d10a684 user: dan tags: fts3-prefix-search
18:31
Fix a comment type on the description of the Schema object. check-in: 095cd9a6 user: drh tags: trunk
2011-06-06
18:14
Merge the latest trunk changes into the fts3-prefix-search branch. check-in: 567dd843 user: drh tags: fts3-prefix-search
14:51
Modify fts3rnd.test to run tests for both "ORDER BY docid ASC" and "ORDER BY docid DESC" with both order=ASC and order=DESC FTS tables. Fixes for some bugs found. check-in: 89f2f482 user: dan tags: fts3-prefix-search
13:38
Add assert() statements to verify that u16 pointers associated with the enhancement in [897f56a158] are always 2-byte aligned. check-in: 98ccfa93 user: drh tags: trunk
06:55
Clean up the code for processing FTS4 options a bit. check-in: 0425138a user: dan tags: fts3-prefix-search
2011-06-04
20:13
Remove some unreachable code. check-in: 650e1a79 user: dan tags: fts3-prefix-search
20:04
Allow the "order=DESC" and "order=ASC" parameters in FTS4 "CREATE VIRTUAL TABLE" statements. Tables created with "order=DESC" store all doclists in descending order, which allows optimizations normally applied to "ORDER BY docid ASC" queries to be used with "ORDER BY docid DESC" queries instead. check-in: f6a0193f user: dan tags: fts3-prefix-search
01:43
Performance improvement to the btree search routine. check-in: 65db822f user: drh tags: trunk
2011-06-03
23:28
Performance improvements on memory copies inside of btree by moving 2 bytes at a time instead of just 1 byte at a time. check-in: 897f56a1 user: drh tags: trunk
21:34
Performance enhancement to the blob-literal tokenizer. check-in: 61aa2031 user: drh tags: trunk
20:11
Create and use a function especially for adding the ParseSchema opcode. This gives a small reduction in code and a small performance increase. check-in: 957b2ab6 user: drh tags: trunk
18:00
FTS changes: Remove unreachable code. Fix bugs. When processing a large doclist incrementally, read from disk incrementally too. check-in: a4c7e282 user: dan tags: fts3-prefix-search
17:50
Factor an "if" out of a loop in balance_nonroot() for about a 1% performance increase. check-in: 1bd72d0c user: drh tags: trunk
14:19
Hush some harmless compiler warnings in the URI parsing logic. check-in: 0206bc6f user: drh tags: trunk
13:28
Include more detailed version information in the command-line shell output. check-in: 049c3c42 user: drh tags: trunk
13:06
Add shell scripts used for testing compiler warnings (tool/warnings.sh), for verifying that the library exports the correct symbols (tool/symbols.sh), and to demonstrate building a full-featured command-line shell (tool/build-shell.sh). check-in: 3aca9a92 user: drh tags: trunk
13:02
Fix the build when using SQLITE_OMIT_PRAGMA. check-in: 051f4635 user: drh tags: trunk
12:15
Fix an #ifdef of SQLITE_OMIT_VIRTUALTABLE that had an extra "_" character. check-in: 93e0be2b user: drh tags: trunk
2011-06-02
19:57
Changes to improve performance and support LIMIT clauses on fts3 tables. This branch is unstable for now. check-in: 28149a78 user: dan tags: fts3-prefix-search
17:24
Fix a faulty assert() in the WAL-mode logic for read-only shared memory. check-in: a13cfe61 user: drh tags: trunk
15:48
Add a missing check for out-of-memory in the lemon code generator. check-in: efb20b9d user: drh tags: trunk
13:07
Merge the latest trunk changes, including the read-only shared memory enhancement, into the apple-osx branch. check-in: ce5f95de user: drh tags: apple-osx
13:04
Merge the read-only shared memory branch into trunk. After this merge, an unprivileged process can open WAL-mode databases owned by another user as long as a database connection with write permission exists on the database file and if the readonly_shm=1 URI query parameter is supplied. check-in: 19084a66 user: drh tags: trunk
2011-06-01
20:13
Make use of the sqlite3GetBoolean() interface for more robust processing of the readonly_shm query parameter inside of unixShmMap(). Closed-Leaf check-in: 1f930d7e user: drh tags: wal-readonly
20:01
Simplify the wal-readonly branch so that it does not require changes to anything other than os_unix.c and wal.c and a couple of new error codes. check-in: d6b4709d user: drh tags: wal-readonly
19:44
Pull the latest trunk changes into the wal-readonly branch. check-in: 0b63b713 user: drh tags: wal-readonly
19:16
Avoid unnecessary duplication of SQL parameter names. check-in: e704e869 user: drh tags: trunk
18:15
Refactor the SQL parameter processing so that parameter names for values that are optimized out of the prepare statement are not forgotten. check-in: b3aaf715 user: drh tags: trunk
11:26
Toward version 3.7.5.1. This check-in updates the version number and also patches the pager so that it never spills cache while in WAL mode. The latter patch fixes ticket [2d1a5c67dfc23] and also prevents excessive WAL file sizes if the pager cache starts thrashing. A few test cases fail. Leaf check-in: 2e5a912a user: drh tags: branch-3.7.5
2011-05-31
17:08
Merge the latest trunk changes into the wal-readonly branch. check-in: 2c6b5a28 user: drh tags: wal-readonly
16:50
Fix a problem in the sqlite3TestErrorName() function (used only for testing) that appears to have originated from a bad merge. check-in: a0ae314c user: drh tags: trunk
11:56
Update the documentation to state that any parameter that is optimized out of a prepared statement becomes an anonymous parameter for which sqlite3_bind_parameter_name() returns NULL. check-in: 701b8a23 user: drh tags: trunk
2011-05-30
23:42
Minor performance improvements. check-in: f9950c6a user: drh tags: trunk
15:06
Update evidence marks on the URI filename tests to conform to the latest documentation. check-in: 1bab03c4 user: drh tags: trunk
14:35
Make sure the P5 argument to the OP_VUpdate opcode is always set to a valid conflict resolution code. check-in: e3350dbd user: drh tags: trunk
13:39
Merge the latest trunk changes into the sessions branch. check-in: 832886b1 user: drh tags: sessions
2011-05-28
19:24
Fix a "#ifdef" from check-in [03f7d36a8a] that should have been "#ifndef". check-in: edb865c3 user: drh tags: trunk
15:57
Minor changes made while planning a larger change. check-in: 84097a4c user: dan tags: fts3-prefix-search
15:53
Print a log message on each cache spill if compiled with SQLITE_LOG_CACHE_SPILL. check-in: 5f15579f user: drh tags: trunk
2011-05-26
14:19
Changes to work with SQLITE_OMIT_VIRTUAL_TABLE. check-in: 03f7d36a user: drh tags: trunk
2011-05-25
23:18
Fix some minor and harmless compiler warnings. check-in: a4755e70 user: drh tags: trunk
20:25
Ignore malloc failures within the WAL file truncation attempt for journal_size_limit. check-in: dd19105a user: drh tags: trunk
19:17
If a prefix index of size N is not present, use a prefix index of size N+1 along with the terms index for queries for prefixes of length N. check-in: cc83991c user: dan tags: fts3-prefix-search
18:47
Merge trunk changes into experimental fts3-prefix-search branch. check-in: f0f0a03d user: dan tags: fts3-prefix-search
18:46
Fix a case where a malloc() error could lead to mismatched virtual-table xBegin/xCommit/xRollback callbacks. check-in: d807304a user: dan tags: trunk
18:34
Change fts4 so that the prefix= parameter is passes a comma-separated list of integers. For each integer N, a separate index of all prefixes of length N bytes is created. check-in: be59bf49 user: dan tags: fts3-prefix-search
15:54
Fix a compiler warning. check-in: 6df99e52 user: drh tags: trunk
01:16
Changes to savepoint in virtual tables for simpler and more consistent operation. check-in: 92f26a8b user: drh tags: trunk
2011-05-24
18:49
If the fts4 option prefix=1 is specified, have the fts4 module maintain an index of prefixes as well as terms. check-in: b5bdc639 user: dan tags: fts3-prefix-search
15:36
Do not invoke the xRollbackTo or xRelease methods of a virtual table without having first invoked an appropriate xSavepoint method. Add assert() statements to FTS3/4 to verify that this is happening in all cases. check-in: 651ef242 user: drh tags: trunk
00:35
Make sure the savepoint index is correct one calls to sqlite3VtabSavepoint with SAVEPOINT_BEGIN. check-in: a9d09566 user: drh tags: trunk
2011-05-23
18:37
Minor cleanups to the header comments on various test_*.c file, to make the suitable for programmer-level documentation. check-in: a65d043a user: drh tags: trunk
2011-05-20
20:42
Adjustments to documentation hyperlinks to accommodate the new VFS documentation. check-in: 139a8f53 user: drh tags: trunk
13:26
Add a big comment to the top of test_vfstrace.c to explain how to compile and use that module. check-in: a6a0fefb user: drh tags: trunk
01:50
Fix the URI test script so that it works even if there is a subdirectory named "test". check-in: 2018d4e1 user: drh tags: trunk
01:49
Mark an unreachable branch in the recent WAL problem as unreachable. check-in: 3e8a29ff user: drh tags: trunk
2011-05-19
13:26
Version 3.7.6.3. check-in: ed1da510 user: drh tags: release, branch-3.7.6, version-3.7.6.3
07:53
Add another test for [2d1a5c67df]. check-in: 97fcd9e8 user: dan tags: trunk
02:48
Merge all the latest trunk changes into the sessions branch, especially the disappearing WAL transaction fix. check-in: 5b1b536c user: drh tags: sessions
02:34
Bring the apple-wal-readonly branch up to date with the latest changes in apple-osx, and especially the fix for disappearing WAL transactions. Leaf check-in: 57912327 user: drh tags: apple-wal-readonly
01:51
Pull all the latest trunk changes, and especially the fix for WAL cache spills causing transactions to disappear, into the apple-osx branch. check-in: 8d1a6bb0 user: drh tags: apple-osx
01:46
Backport the [67bf1c9a88] fix for vanishing WAL transactions due to small cache spillage. Ticket [2d1a5c67dfc236]. Also bump the version number to 3.7.6.3 in preparation for patch release. check-in: e4d0f7ac user: drh tags: branch-3.7.6
01:21
When committing a WAL transaction, make sure at least one page is written to the WAL file so that the WAL subsystem will have a page on which to set the commit flag. Ticket [2d1a5c67dfc236]. check-in: 67bf1c9a user: drh tags: trunk
2011-05-18
17:15
Enable URI filenames in the command-line shell. Add a check to the beginning of the shell to make sure it is compiled with the same SQLite source and header. check-in: de58cb28 user: drh tags: trunk
03:02
Make sure the multiplexor shim uses a full pathname for temp file that it creates. check-in: 186d7ff1 user: drh tags: trunk
02:41
Remove unreachable branches from the 8.3 filename logic. check-in: 4f7e7b44 user: drh tags: trunk
02:22
Update multiplex VFS to handle empty filenames which can occur for during vacuuming (temp file names.) check-in: a0749860 user: shaneh tags: trunk