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

2015-11-04
16:34
In releasetest.tcl, run larger test first if --jobs is greater than 1. Run smaller tests cases first if --jobs is 1. check-in: 3fece5d0 user: drh tags: trunk
13:03
Exclude cffault.test and symlink.test from the (incompatible) inmemory_journal permutation. check-in: 4f16e968 user: drh tags: trunk
2015-11-03
23:39
Increase the fuzzcheck timeout when running valgrind. check-in: a5816877 user: drh tags: trunk
19:13
In 'e_uri.test', make sure all created test database files get deleted. check-in: 40c4f4a6 user: mistachkin tags: trunk
15:39
In the releasetest.tcl script, add the --progress option to cause the start of each subprocess to be shown. Otherwise, revert to the old-style display. Improvements to the handling of the --buildonly option. check-in: d969792f user: drh tags: trunk
15:16
In the releasetest.tcl script, show the --jobs object on the command-line summary. Report the time of each "starting:" event. Do not show errors on a --dryrun. check-in: b7510777 user: drh tags: trunk
14:49
Update the releasetest.tcl script so that it can run multiple tests in parallel in separate processes. check-in: e3de8291 user: drh tags: trunk
06:23
Further enhancement and a bit of cleanup. Closed-Leaf check-in: 0d8b5978 user: mistachkin tags: mp-releasetest
02:47
Use the native name for the MSVC makefile as well. check-in: e457c615 user: mistachkin tags: mp-releasetest
2015-11-02
23:29
Attempt to centralize and simplify the MSVC handling. check-in: 4ae96d6d user: mistachkin tags: mp-releasetest
23:21
Fix the backcompat.test module so that it does not try to compare against itself on windows. check-in: f625bce8 user: drh tags: mp-releasetest
21:05
Get things working better on Windows with MSVC. check-in: 22cc3e6c user: mistachkin tags: mp-releasetest
20:52
Fix the --dryrun option on the releasetest.tcl script. check-in: e565e026 user: dan tags: mp-releasetest
20:28
Fix releasetest.tcl so that it does not choke if a test fails so badly that there is no log file. Add the --jobs switch to the usage message. check-in: 20e96f52 user: dan tags: mp-releasetest
20:24
Fix releasetest.tcl so that output lines are less than 80 characters wide. check-in: aef177fe user: dan tags: mp-releasetest
18:57
Merge all recent enhancements and fixes from trunk. check-in: 0546d1cd user: drh tags: sessions
18:32
Add the "--jobs N" option to the releasetest.tcl script to allow tests to be run in parallel by N processes. N defaults to 1. check-in: 3d29f912 user: dan tags: mp-releasetest
18:31
Version 3.9.2 check-in: bda77dda user: drh tags: release, branch-3.9, version-3.9.2
15:10
Merge latest trunk changes, including the follow-symlinks functionality and 3.9.2 bugfixes, into this branch. check-in: 447521d7 user: dan tags: apple-osx
15:08
On unix, if a file is opened via a symlink, create, read and write journal and wal files based on the name of the actual db file, not the symlink. check-in: 6d5ce3ed user: dan tags: trunk
11:19
When creating an automatic-index on a sub-query, add a unique integer to the end of each index key to ensure the entire key is unique. Fix for [8a2adec1]. check-in: c0c4b6b3 user: drh tags: branch-3.9
11:10
Aborted releaset of 3.9.2. check-in: c33a275b user: drh tags: branch-3.9
2015-11-01
21:42
Increase the version number to 3.9.2. check-in: 14bd4fbf user: drh tags: branch-3.9
21:35
If a table-constraint PRIMARY KEY lists a single column in single-quotes and that column has type INTEGER, then make that column an integer primary key, for historical compatibility. Fix for ticket [ac661962a2aeab3c331]. check-in: dab0e607 user: drh tags: branch-3.9
21:19
If a table-constraint PRIMARY KEY lists a single column in single-quotes and that column has type INTEGER, then make that column an integer primary key, for historical compatibility. Fix for ticket [ac661962a2aeab3c331]. check-in: db319a03 user: drh tags: trunk
2015-10-31
17:58
On unix, if a file is opened via a symlink, create, read and write journal and wal files based on the name of the actual db file, not the symlink. Closed-Leaf check-in: c7c81050 user: dan tags: follow-symlinks
2015-10-30
20:54
Add mutex operations to test code in test3.c to avoid triggering assert() failures in certain configurations. check-in: 9f19420b user: dan tags: trunk
17:17
Merge the sqlite3_db_cacheflush() enhancements and other changes from trunk. check-in: f2cde4cf user: drh tags: begin-concurrent
16:50
Merge all the latest enhancements from trunk. check-in: 395a153f user: drh tags: sessions
16:37
Merge the 3.10.0 version number update from trunk. check-in: 980d6207 user: drh tags: apple-osx
16:36
Increase the version number to 3.10.0, due to the addition of the sqlite3_db_cacheflush() interface. check-in: 7565b046 user: drh tags: trunk
16:23
Merge latest trunk changes, including sqlite3_db_cacheflush(), with this branch. check-in: 6e4306ef user: dan tags: apple-osx
16:14
Add new API function sqlite3_db_cacheflush(). check-in: ad80d307 user: dan tags: trunk
14:28
Return immediately if sqlite3PagerWrite() is called when the pager is in PAGER_ERROR state. Closed-Leaf check-in: a6695b00 user: dan tags: cacheflush
14:25
Add the --enable-editline option to various autoconf scripts. check-in: 866f0277 user: drh tags: trunk
09:13
Test that calling sqlite3_db_cacheflush() does not interfere with savepoints. check-in: 0e09e4a2 user: dan tags: cacheflush
2015-10-29
21:11
Do not attempt to flush the pages of an in-memory database to disk if sqlite3_db_cacheflush() is called. check-in: 9b79a390 user: dan tags: cacheflush
20:57
Add a test case that calls sqlite3_db_cacheflush() on an in-memory database. check-in: f0cdfb54 user: dan tags: cacheflush
18:16
Avoid automatically rolling back the transaction if an SQLITE_IOERR or SQLITE_FULL error occurs within sqlite3_db_cacheflush(). check-in: 370b5d52 user: dan tags: cacheflush
14:29
The optimization on this branch is logically incorrect. It changes the return value of "SELECT 0 OR 'xyzzy'" FROM 0 to 'xyzzy'. Closed-Leaf check-in: a0c08d26 user: drh tags: simplify-or-clause
13:48
Fix uses of ctype functions (ex: isspace()) on signed characters in test programs and in some obscure extensions. No changes to the core. check-in: 34eb6911 user: drh tags: trunk
12:27
Apply optimizations to simplify OR clauses that contain constant terms. check-in: d533e23f user: drh tags: simplify-or-clause
01:11
Enhance comments in the MSVC batch build tool. check-in: 2964ce25 user: mistachkin tags: trunk
2015-10-28
20:01
Make the internal sqlite3PExpr() interface responsive to the TKFLG_DONTFOLD flag on the operator parameter. check-in: b10ab59f user: drh tags: trunk
19:46
Add experimental API sqlite3_db_cacheflush(). check-in: 65b86dc1 user: dan tags: cacheflush
16:05
Factor out adding NOT expression nodes in the parser into a subroutine. check-in: 00185418 user: drh tags: trunk
2015-10-27
20:04
Have contentless and external content fts5 tables ignore "OR REPLACE" conflict handling. check-in: a85c2a47 user: dan tags: trunk
17:48
Fix problems with prefix queries in fts5. check-in: 3b5758c6 user: dan tags: trunk
13:35
Provide hints to the storage engine using the sqlite3BtreeCursorHint() interface when compiling with SQLITE_ENABLE_CURSOR_HINTS. check-in: 45d3539e user: drh tags: trunk
13:24
Split out sqlite3BtreeCursorHintFlags() from sqlite3BtreeCursorHint() the interface for improved performance. Closed-Leaf check-in: b3ec9a0d user: drh tags: cursor-hints
2015-10-26
20:50
Merge latest trunk changes, including the SQLITE_IOERR_AUTH error code, with this branch. check-in: bc195e1c user: dan tags: apple-osx
20:39
Add new extended error code SQLITE_IOERR_AUTH. check-in: b4e70dd0 user: dan tags: trunk
20:11
Merge the BTREE_FORDELETE enhancement with this branch. check-in: 20da0849 user: dan tags: cursor-hints
18:51
Merge in all trunk changes prior to the BTREE_FORDELETE enhancement. check-in: 53d5a4ad user: drh tags: cursor-hints
18:01
Capture BTREE_FORDELETE test cases that were mistakenly omitted from the previous merge. check-in: de697251 user: drh tags: trunk
17:50
Provide the BTREE_FORDELETE flag to sqlite3BtreeCursor() if the cursor will be used only for deletions and seeking. check-in: 871b1c78 user: drh tags: trunk
16:34
Fix an uninitialized variable problem in the test code added by the previous commit. Closed-Leaf check-in: 7849662e user: dan tags: btree-fordelete-flag
16:31
Test that the binary record "0x01 0x00" is interpreted by OP_Column as a vector of NULL (or default) values. check-in: 5bdc3c82 user: dan tags: btree-fordelete-flag
14:54
Fix a C99-ism and a harmless compiler warning. check-in: 138783b5 user: drh tags: trunk
14:41
When compiling with SQLITE_HAS_CODEC, honor the hexkey= query parameter on URI pathnames in sqlite3_open_v2(). check-in: e0ce3fc0 user: drh tags: trunk
12:55
Remove an unreachable branch in malloc.c. check-in: a36b7fe9 user: drh tags: trunk
2015-10-24
20:31
When creating an automatic-index on a sub-query, add a unique integer to the end of each index key to ensure the entire key is unique. Fix for [8a2adec1]. check-in: bfea226d user: dan tags: trunk
2015-10-23
11:50
Remove an unused #define from whereInt.h. Add comments describing the new sqlite3BtreeCursor() flags. check-in: 4c0ba8be user: dan tags: btree-fordelete-flag
2015-10-22
20:54
Modifications to pass a flag to internal routine sqlite3BtreeCursor() when a cursor that is used solely for deleting b-tree entries, or for obtaining the components of keys to delete from other b-trees, is opened. check-in: cdc92919 user: dan tags: btree-fordelete-flag
18:06
Alternate compiler warning fix for sqlite3StatusHighwater. check-in: 4315d202 user: mistachkin tags: trunk
2015-10-21
22:08
Fix harmless compiler warnings in FTS5. check-in: aa4e01ea user: mistachkin tags: trunk
22:07
Fix compilation of 'testfixture' with MSVC when the FTS5 and JSON1 extensions are enabled. check-in: e31aa97a user: mistachkin tags: trunk
20:56
Remove some branches made unreachable by recent changes from fts5. check-in: ae350bfb user: dan tags: trunk
20:07
Minor optimization for fts5 queries. check-in: 363b36d5 user: dan tags: trunk
08:26
Add extra debugging function to test_rbu.c. Enhance the documentation for sqlite3rbu_db() to define the validity of the returned database handles. check-in: b9c4aa52 user: dan tags: trunk
2015-10-20
23:40
Fix compiler warnings. Closed-Leaf check-in: 12e869bb user: mistachkin tags: noWarn
23:27
Fix harmless compiler warnings in FTS5. check-in: 0a903ec2 user: mistachkin tags: trunk
21:05
More optimizations for fts5 prefix queries. check-in: b8fb263e user: dan tags: trunk
19:55
Fix #line directives added to generated file fts5.c. check-in: 1f5f5804 user: dan tags: trunk
15:49
Initialize variables in the fts5 integrity-check code to avoid compiler warnings. check-in: e979e2cc user: dan tags: trunk
2015-10-19
20:49
Another optimization for fts5 prefix (and other) queries. check-in: 60a8bde0 user: dan tags: trunk
17:43
Another tweak to improve performance of fts5 prefix queries. check-in: 69be427c user: dan tags: trunk
15:59
Fix a problem in the fts5txt2db.tcl script causing it to fail when creating tables with more than 8 columns. check-in: 68ee426a user: dan tags: trunk
2015-10-17
20:34
Add tests to cover new branches added to the fts5 code by the previous commit. check-in: cf618334 user: dan tags: trunk
19:49
Handle equality and range constraints on the "term" column of fts5vocab tables. Also have the same module report columns using names instead of indexes. check-in: 6020d96a user: dan tags: trunk
01:00
Change the code generator for UPDATE to generate code in an order that might run more efficiently in many cases. Leaf check-in: c6239bf9 user: drh tags: improved-update
2015-10-16
23:55
Fix a comment in expr.c and add a CORRUPT_DB to an assert() in btree.c. check-in: 0df371d1 user: drh tags: trunk
20:55
Merge the 3.9.1 updates from trunk. check-in: bf866e6c user: drh tags: begin-concurrent
20:53
Merge recent enhancements from trunk. Version now 3.9.1. check-in: 26fa091d user: drh tags: cursor-hints
20:52
Merge the 3.9.1 changes. check-in: dd07688d user: drh tags: apple-osx
20:20
Merge the version 3.9.1 updates. check-in: 2bbb9595 user: drh tags: sessions
20:13
Enhancements to the MSVC makefile. check-in: 39e8a5d9 user: mistachkin tags: trunk
20:12
Merge the 3.9.1 changes into trunk. (This only updates the version number and configure script since all the other changes in 3.9.1 were cherrypicked from trunk.) check-in: eb231742 user: drh tags: trunk
17:31
Version 3.9.1 check-in: 767c1727 user: drh tags: release, branch-3.9, version-3.9.1
15:56
Cherrypick the json form-feed fix, and other #ifdef and build script changes to address minor issues that came to light after the 3.9.0 release. Update the version number to 3.9.1. No logic changes except for the form-feed bug-fix in json1 (ticket [57eec374ae1d0a1d4a]). check-in: 746fcd2f user: drh tags: branch-3.9
15:42
Fix the fuzzershell utility program so that it compiles with the amalgamation that includes JSON1 support. check-in: d6fc616e user: drh tags: trunk
15:35
Fix the JSON1 extension so that it does not depend on isdigit() and strtod() from the standard library when compiled into SQLite as part of the amalgamation. check-in: bc9a9a60 user: drh tags: trunk
15:16
Form-feed is not valid whitespace for json. Fix for ticket [57eec374ae1d0a1d] check-in: 28957d63 user: drh tags: trunk
14:54
Have the sqlite3VdbeSerialType() function go ahead and compute the serial length as well, since it is always needed. This avoids unnecessary calls to sqlite3VdbeSerialTypeLen(). check-in: 2ad72be1 user: drh tags: trunk
14:23
Use a lookup table to compute the content length for serial types less than 128, for a 1.2% performance improvement. check-in: 33957248 user: drh tags: trunk
13:50
Simplify the OP_Column logic slightly. One very small performance improvement added. check-in: 0114b45d user: drh tags: trunk
12:53
OP_Column optimization: Do not check for an oversize row header unless the row header size is larger than the content available on the local page. check-in: 8125b74c user: drh tags: trunk
12:39
Improved header comment on the tool/vdbe_profile.tcl script. No changes to code. check-in: b17ad8fc user: drh tags: trunk
03:34
Whenever two or more OP_Column opcodes on the same cursor occur in succession, try to reordering them so that the one that extracts the right-most column is first, so that it will warm up the row cache for all those that follow. This gives a small performance boost. Leaf check-in: 08e8f04d user: drh tags: reorder-column-opcodes
2015-10-15
21:30
Performance optimization for the OP_Column opcode. check-in: 076be547 user: drh tags: trunk