/ 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 2c0b93553ebb00a7.

2016-01-19
16:06
Add further fts5 tests. 100% code coverage is finally restored. check-in: b914ece0 user: dan tags: trunk
2016-01-18
17:48
Add tests for fts5. Fix a crash that can occur in fts5 if the database content is corrupted. check-in: acaf4264 user: dan tags: trunk
13:18
Avoid unnecessary calls to memset() for a small performance improvement. check-in: 9e8c23ac user: drh tags: trunk
09:08
Add a debugging function to print human-readable versions of fts5 detail=none leaf pages. check-in: 8358af36 user: dan tags: trunk
00:46
Simplification of the VDBE bytecode for incremental blob I/O. check-in: d23849f6 user: drh tags: trunk
00:20
Fix a problem with SQLITE_TEST_REALLOC_STRESS. check-in: 0aaf3feb user: drh tags: trunk
2016-01-16
21:06
Add extra tests to cover untested branches in fts5. check-in: 61deab04 user: dan tags: trunk
20:50
Improvements to the way sqlite3VdbeAddOpList() works, resulting in a slightly smaller and faster binary. check-in: 88ceb588 user: drh tags: trunk
18:58
Add further tests for fts5. Fix some problems with detail=col mode and auxiliary functions. check-in: de77d602 user: dan tags: trunk
15:12
Use sqlite3VdbeAddOp4() rather than a separate sqlite3VdbeChangeP4() call, for a slightly smaller and faster binary. check-in: a4258cd4 user: drh tags: trunk
03:16
Fix a potential use-after-free problem when compiling with SQLITE_HAS_CODEC. check-in: 653ea15a user: drh tags: trunk
2016-01-15
21:55
Remove an unnecessary memset(). check-in: 689421a9 user: drh tags: trunk
19:54
Rationalize some code in fts5_storage.c. Add tests to cover recently added branches in fts5. check-in: 3b72df40 user: dan tags: trunk
16:11
Remove unnecessary de-initialization of the Parse object. check-in: 75ab30c5 user: drh tags: trunk
15:06
Work toward making the schema parsing logic simplier and more compact. check-in: c52ca2c0 user: drh tags: trunk
05:39
Fix a couple C99-isms in FTS5 that cause compile errors on MSVC. check-in: 584848d4 user: mistachkin tags: trunk
2016-01-14
22:19
Combine the xFunc and xStep pointers of the FuncDef object into a single pointer xSFunc. check-in: 0d1b3d7d user: drh tags: trunk
20:05
Add a test to verify that the fts3 and fts5 "unicode61" tokenizers are byte for byte compatible. check-in: 8ec83143 user: dan tags: trunk
19:32
Simplification to the ISO8610 parser in the imnplementation of date/time functions. check-in: b9159f42 user: drh tags: trunk
18:01
Minor adjustments to the MSVC makefile. check-in: e2cba1bb user: mistachkin tags: trunk
15:46
Merge the latest enhancements and fixes from trunk. check-in: fccc5f20 user: dan tags: begin-concurrent
15:03
Merge the latest enhancements and fixes from trunk. check-in: d85774e0 user: drh tags: apple-osx
14:48
Merge the latest fixes and enhancements from trunk. check-in: 007e5c6d user: drh tags: sessions
14:33
Yet another change to FTS5 trying to get it to merge successfully into sessions. check-in: 8dedff3b user: drh tags: trunk
14:29
Fix more compiler warnings in FTS5. check-in: f791fc70 user: drh tags: trunk
14:19
Fix another compiler warning in fts5 code. check-in: d17bc2c9 user: dan tags: trunk
14:15
Fix compiler warnings in fts5. check-in: 5a343cc0 user: dan tags: trunk
13:22
Fix harmless compiler warnings in RBU and add RBU to the autoconf and windows makefiles. check-in: fabe78c5 user: drh tags: trunk
12:23
Fix harmless compiler warnings in sqldiff.c. check-in: 74808a79 user: drh tags: trunk
01:56
Fix the build so that it works for SQLITE_OMIT_WAL again. check-in: d55a557b user: drh tags: trunk
00:01
Version 3.10.1 check-in: 254419c3 user: drh tags: release, version-3.10.1, branch-3.10
2016-01-13
21:23
Look for pthread_mutexattr_init() instead of pthread_create() in autoconf scripts, to work around issues with ASAN. check-in: 9c3a0dc2 user: drh tags: trunk
18:26
Version number to 3.10.1. check-in: 4660da25 user: drh tags: branch-3.10
18:25
Add documentation for new API functions to the comments in fts5.h. check-in: 14d296fa user: dan tags: trunk
18:21
Add the SQLITE_FCNTL_JOURNAL_POINTER file control. check-in: ea9ce228 user: drh tags: branch-3.10
18:12
Add the SQLITE_FCNTL_JOURNAL_POINTER file control. check-in: ad3daa54 user: drh tags: trunk
18:06
Add documentation for the SQLITE_FCNTL_JOURNAL_POINTER file-control. Closed-Leaf check-in: 807c5aee user: drh tags: file-control-journal
17:59
When the block sorting optimization is used in a scalar subquery, be sure to exit the loop as soon as the first valid output row is received. Fix for ticket [cb3aa0641d9a4]. check-in: 8b4f5080 user: drh tags: branch-3.10
17:50
When the block sorting optimization is used in a scalar subquery, be sure to exit the loop as soon as the first valid output row is received. Fix for ticket [cb3aa0641d9a4]. check-in: cdbb0947 user: drh tags: trunk
2016-01-12
19:45
Add the "detail" option to fts5. Used to reduce the amount of information stored in an fts5 index. check-in: a220e85f user: dan tags: trunk
19:37
Add the ".vfslist" command to the command-line shell. check-in: 5727562b user: drh tags: trunk
19:28
Improve performance of fts5 low level iterators. Closed-Leaf check-in: bc5118f4 user: dan tags: fts5-offsets
14:10
Fix a harmless use of an uninitialized variable following system errors in the multi-threaded sorter. check-in: 4bb2c1df user: drh tags: trunk
04:08
Remove an unused field from the MemPage object. check-in: 5fc0a4c1 user: drh tags: trunk
02:28
Make sure all bytes of the WAL file are initialized even if the checksums are not being computed until commit due to WAL overwrite. check-in: 1f44a9bd user: drh tags: trunk
02:00
Fix an uninitialized field in the Select object when SELECTTRACE is enabled. check-in: fc628516 user: drh tags: trunk
00:37
Various #ifdef enhancements for improved VxWorks support. check-in: 75cd41ff user: drh tags: trunk
2016-01-11
22:58
Performance optimization in the sqlite3VdbeChangeP4() routine of the code generator. check-in: 28bd8d5f user: drh tags: trunk
22:43
Fix duplicate test number in 'waloverwrite'. check-in: f5fb8268 user: mistachkin tags: trunk
18:30
Merge trunk with this branch. check-in: a73d245f user: dan tags: fts5-offsets
18:23
Add the fts5speed.tcl script to ext/fts5/tool/. check-in: 2c0b9355 user: dan tags: fts5-offsets
18:05
Performance optimization on the Column opcode. check-in: ecc98bef user: drh tags: trunk
17:30
Fix bugs in fts5 synonym processing for detail=col and other modes. check-in: 0e3c5454 user: dan tags: fts5-offsets
14:19
Performance optimization in sqlite3WalkExpr(). check-in: 2f8bd5fa user: drh tags: trunk
13:10
Merge recent enhancements, and especially the WAL overwrite change, from trunk. check-in: c4a858b2 user: drh tags: sessions
13:03
Import the version number change to 3.11.0. check-in: 132772d1 user: drh tags: apple-osx
12:52
Increase the version number to 3.11.0 due to the WAL overwrite enhancement. check-in: 8e807bfa user: drh tags: trunk
12:49
Merge enhancements from trunk, and in particular the WAL overwrite feature. check-in: 79125ec9 user: drh tags: apple-osx
12:13
If a single page is written to the wal file more than once, instead of appending the second and subsequent copy to the wal file, overwrite the first. Update: See the important bug fix at [f694e60a]! check-in: d493d4f1 user: dan tags: trunk
08:12
Add a test case to waloverwrite.test to check that savepoint rollback does not cause a problem. Closed-Leaf check-in: 87dae56c user: dan tags: wal-overwrite-frames
03:48
Slightly smaller and faster LIKE/GLOB comparison implementation. check-in: 5dddcc78 user: drh tags: trunk
00:52
Improved testability. check-in: e83d3a2a user: drh tags: wal-overwrite-frames
2016-01-09
23:55
All WAL frame overwrites even if there are active savepoints. This is safe because a ROLLBACK TO will cause all reverted pages to be rewritten to the WAL file prior to COMMIT. check-in: 99b31a6b user: drh tags: wal-overwrite-frames
18:57
If it is known that checksums will be recalculated on transaction commit, skip calculating checksums when appending frames to the wal file. When recalculating checksums, recalculate them starting with the first overwritten frame - not the first frame in the transaction. check-in: 16b34f25 user: dan tags: wal-overwrite-frames
16:39
If a single page is written to the wal file more than once, have each subsequent copy overwrite the original frame. check-in: 5d113aef user: dan tags: wal-overwrite-frames
2016-01-08
22:31
Typo fix in the previous commit. check-in: 52c16603 user: drh tags: trunk
22:18
More #ifdef fixes for the unix VFS. check-in: 122c111e user: drh tags: trunk
19:34
Fix the build for SQLITE_OMIT_SHARED_CACHE, which was broken, possibly by check-in [2d96aeba]. check-in: 3392f8fa user: drh tags: trunk
19:17
Fix a problem with #ifdefs on the system calls in the unix VFS that causes problems when compiling with SQLITE_OMIT_WAL. check-in: ceceea4c user: drh tags: trunk
17:28
Remove an obsolete #ifdef related to iOS support. check-in: e9a51d2a user: drh tags: trunk
17:21
Begin adding fts5 tests involving synonyms and detail=none/col tables. check-in: b3e6f15e user: dan tags: fts5-offsets
12:46
Reduce the number of calls to memset() in sqlite3DbMallocZero(). check-in: cede2bf8 user: drh tags: trunk
08:35
Fix test file vtabH.test so that it works with SQLITE_ENABLE_ICU builds. check-in: 19c1f448 user: dan tags: trunk
07:53
Fix fts5vocab.test so that it works with detail=none tables. check-in: d9135cc7 user: dan tags: fts5-offsets
02:27
Add the experimental SQLITE_FCNTL_JOURNAL_POINTER file control for obtaining the sqlite3_file pointer associated with a rollback journal or WAL file. check-in: a02ace9a user: drh tags: file-control-journal
2016-01-07
21:12
Omit performance tracking from the memsys5 memory allocator if neither SQLITE_DEBUG nor SQLITE_TEST are defined. check-in: af5c7714 user: drh tags: trunk
20:07
Update the fts5vocab module to work with detail=col and detail=none tables. check-in: eedd095d user: dan tags: fts5-offsets
17:19
Fix to cause BtShared.db to be set correctly on shared-cache connections in SQLITE_THREADSAFE=0 builds. Added assert()s to verify the correct setting of BtShared.db. check-in: 2d96aeba user: drh tags: trunk
17:09
Small performance and size optimization spotted while working on the shared-cache problem. check-in: 828958ff user: drh tags: trunk
16:43
Add some assert() statements to verify, where possible, that BtShared.db is set correctly. Closed-Leaf check-in: 359277e0 user: dan tags: shared-cache-fix
16:06
Have the vdbe layer call sqlite3BtreeEnter() on all b-trees in use from within sqlite3VdbeExec() even in SQLITE_THREADSAFE=0 builds. This ensures that BtShared.db is set correctly. check-in: d0214602 user: dan tags: shared-cache-fix
02:06
Add the "sqlite3 -sourceid" command in the TCL interface. Use that command and others to output additional information about the test configuration at the conclusion of a TCL test. check-in: 4f80440b user: drh tags: trunk
2016-01-06
20:50
Merge updates from trunk. check-in: 5cbab637 user: mistachkin tags: altShellFix
19:43
Fix a test script problem caused by a change in constraint handling within the core. check-in: 625695b3 user: dan tags: fts5-offsets
19:35
Merge latest trunk changes into this branch. check-in: e7dcd013 user: dan tags: fts5-offsets
18:53
Fix an fts5 problem involving detail=none, "ORDER BY rowid DESC" and deleted items. Also add tests to verify that the documented operator precedences are correct. check-in: 8d05cfd4 user: dan tags: fts5-offsets
15:54
Disable the --limit-mem option on fuzzcheck unless the SQLITE_ENABLE_MEMSYS5 or SQLITE_ENABLE_MEMSYS3 compile-time options are used. check-in: 55a11fd6 user: drh tags: trunk
15:49
Merge changes for version 3.10.0. check-in: e1d2ffc0 user: drh tags: begin-concurrent
15:14
Merge changes for version 3.10.0. check-in: fa4705c9 user: drh tags: sessions
14:35
Merge all version 3.10.0 updates. check-in: 77c28c2b user: drh tags: apple-osx
11:01
Version 3.10.0 check-in: fd0a50f0 user: drh tags: trunk, release, version-3.10.0
10:17
Fix a problem with the xPhraseFirstColumn() API in detail=col mode. Remove some unused test code from fts5ac.test. check-in: a4e55f73 user: dan tags: fts5-offsets
2016-01-05
21:04
Rationalize and extend some fts5 test code. Fix bugs revealed by the same. check-in: fd217fdb user: dan tags: fts5-offsets
03:39
Always use -DSQLITE_ENABLE_MEMSYS5 for fuzzcheck so that the --limit-mem option will work. check-in: a8556977 user: drh tags: trunk
03:39
Another attempt to get reuse of excess opcode array space working correctly on all architectures and platforms. check-in: 2f858374 user: drh tags: trunk
01:48
Permit the 'test_fs' test module to be compiled and used on MinGW. check-in: ac27f38e user: mistachkin tags: trunk
2016-01-04
23:43
Fix a corner case in the opcode-array reuse logic where the number of bytes of reusable space might be computed to be a negative number, due to unusual system alignment restrictions and rounding error. check-in: 1aa53014 user: drh tags: trunk
19:12
Fix an OOM handling problem in fts5 detail=none and detail=col modes. Also a bug in the xInst() API when used with detail=col and column filtering expressions. Update the matchinfo() test function so that 'b' is fast with detail=col tables. check-in: ee38f9df user: dan tags: fts5-offsets
19:02
Merge in last-minute patches for the 3.10.0 beta. check-in: c785cd78 user: drh tags: sessions
16:19
Update more fts5 tests to run in detail=none and detail=column modes as well as the default detail=full. check-in: 3fcf3b1e user: dan tags: fts5-offsets