/ Timeline
Login

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

100 check-ins occurring around d00b71ecf857bc6d.

2018-03-31
16:31
Fix an assertion failure triggered by a SELECT with a compound sub-query that contains an incorrectly placed ORDER BY clause. This problem is just an assert() failure - non-DEBUG builds are not affected. Problem found by OSSFuzz. check-in: 823779d3 user: dan tags: trunk
2018-03-30
20:42
Update and add further detail to README-server-edition.html. check-in: 337a0b67 user: dan tags: server-process-edition
16:34
Fix a bug in the spellfix extension causing it to compute suboptimal answers. The problem was introduced by check-in [afd6fbc01052ccfc9]. check-in: 3bf28fd9 user: drh tags: trunk
15:59
Fix an off-by-one error in the dist3 algorithm of the spellfix extension. check-in: 5c34af7b user: drh tags: trunk
2018-03-29
16:54
Another change to test file zipfile.test to help it run on systems without "unzip". check-in: b6252feb user: dan tags: trunk
16:39
Fix a test script bug causing zipfile.test to fail on systems that do not have the "unzip" program installed. check-in: d99022a5 user: dan tags: trunk
13:47
Modify the sqlite3OsFileControl() interface to detect unopened sqlite3_file objects and return SQLITE_NOTFOUND. check-in: 1fc72b70 user: drh tags: trunk
11:02
Update memdb1.test so that it works with SQLITE_DEFAULT_AUTOVACUUM builds. check-in: d67f1c7d user: dan tags: trunk
2018-03-28
22:08
Fix a harmless compiler warning in the kvtest.exe program. check-in: d48972cf user: drh tags: trunk
21:45
Fix a harmless compiler warning. check-in: f0d12354 user: drh tags: trunk
20:29
Add -DSQLITE_ENABLE_DESERIALIZE to the "Device-Two" configuration in releasetest.tcl. check-in: 765a014d user: dan tags: trunk
15:56
Remove tab characters. No logical changes to code. check-in: eb29b336 user: drh tags: trunk
15:41
Update this branch with latest trunk changes. check-in: df52e89f user: dan tags: server-process-edition
15:06
Minor comment changes. check-in: d282f064 user: drh tags: trunk
2018-03-27
22:58
Fix a typo in the README file for ICU. No code changes. check-in: 79c4383b user: drh tags: trunk
15:13
The push-down optimization was being too aggressive such that it sometimes generated incorrect results. Reinstate the restriction (4) (with qualifications) that was removed by check-ins [b5d3dd8cb0b1e4] and [dd568c27b1d765]. check-in: f08c1731 user: drh tags: trunk
13:57
Provide the ability for the VFS to do a blocking wait on locks if compiled with SQLITE_ENABLE_SETLK_TIMEOUT. check-in: e7dff982 user: drh tags: trunk
2018-03-26
21:05
Do not inject OOM errors on SQLITE_FCNTL_LOCK_TIMEOUT calls as an OOM is not possible in that context. Closed-Leaf check-in: 5474e560 user: drh tags: lowlevel-lock-timeout
20:43
Avoid a race condition that might cause a busy_timeout to last longer than it should. check-in: b8196056 user: drh tags: lowlevel-lock-timeout
17:56
Fix a typo preventing test script avtrans.test from running in auto-vacuum mode. check-in: c7473bdb user: dan tags: trunk
17:40
Add infrastructure to support for using F_SETLKW with a timeout on system that support that functionality. Requires SQLITE_ENABLE_SETLK_TIMEOUT. check-in: 2e54a743 user: drh tags: lowlevel-lock-timeout
16:37
Refactor some internal object element names used by the busy handler, to simplify analysis. check-in: 6c40c557 user: drh tags: trunk
2018-03-24
23:16
Fix a couple issues in the 'session' module tests. check-in: ccf734f7 user: mistachkin tags: trunk
20:06
Fix harmless compiler warning seen with MSVC. check-in: e9508ab1 user: mistachkin tags: trunk
18:01
Add testcase() macros and improve comments in the LEFT JOIN strength reduction optimization. check-in: 56134577 user: drh tags: trunk
15:47
Yet another fault in the sqlite3ExprImpliesNotNull() routine, causing errors in the LEFT JOIN strength reduction optimization of check-in [dd568c27b1d76563]. check-in: e88cf3d4 user: drh tags: trunk
15:08
Fix a test script problem causing shell1.test to fail with -DSQLITE_OMIT_VIRTUAL_TABLE builds. check-in: 2e06906e user: dan tags: trunk
13:24
Bug fix in the LEFT JOIN strength reduction optimization of check-in [dd568c27b1d76563]. The sqlite3ExprImpliesNotNull() routine was mistakenly assuming that a CASE expression must always be NULL if contained any reference to a variable that was NULL. check-in: cf171abe user: drh tags: trunk
00:19
Prepend linkage macros to the sqlite3rebaser interfaces. check-in: c64e8f37 user: drh tags: trunk
2018-03-23
17:36
Fix typos in sqlite3session.h preventing documentation webpages from being generated. Also mark all new sessions functions (those related to rebasing) as experimental. check-in: de974235 user: dan tags: trunk
16:31
Fix minor problems with passing NULL pointers to memcmp() and memcpy() found by -fsanitize=undefined. check-in: 0b06ce6d user: dan tags: trunk
16:08
Fix the -readonly option on the CLI so that it actually works. check-in: 0477fb3f user: drh tags: trunk
14:56
Add some more tests for the IS TRUE / IS FALSE operators. check-in: 9fe5bebe user: mistachkin tags: trunk
14:50
Fix typo in a comment used for documentation. No changes to code. check-in: 49974d3b user: drh tags: trunk
14:24
Enhance .schema in shell to enable matching patterns with literal underscores. check-in: 98e3f524 user: mistachkin tags: trunk
13:18
Fix an error in the CLI in the previous ([0249d9aecf69948]) check-in. Only the pattern to sqlite3_strlike() need to be escaped. check-in: 71d5f6e6 user: drh tags: trunk
12:59
Fix the ANALYZE command so that it will process tables whose names begin with "sqlite" as long as they do not being with "sqlite_". check-in: 0249d9ae user: drh tags: trunk
00:31
Fix harmless compiler warnings seen with MSVC. check-in: 2f2be1b1 user: mistachkin tags: trunk
2018-03-22
20:35
Add APIs to the sessions module for "rebasing" changesets. check-in: 509506c7 user: dan tags: trunk
20:11
Remove some unused code from sqlite3rebaser_rebase(). Closed-Leaf check-in: 07cc955e user: dan tags: sessions-rebase
19:52
Fix another problem with rebasing updates against multiple remote changes. check-in: c8e7b5a0 user: dan tags: sessions-rebase
17:17
Fix an RBU problem causing errors when updating tables with default collation sequences that require quoting (e.g. COLLATE "ICU_root-u-kn-on"). Cherrypick of [eb4f452e]. check-in: 5dd61e1c user: dan tags: branch-3.22
17:13
Fix an RBU problem causing errors when updating tables with default collation sequences that require quoting (e.g. COLLATE "ICU_root-u-kn-on"). check-in: eb4f452e user: dan tags: trunk
17:02
Fix a test script problem causing rbuvacuum.test to fail when run along with other tests. check-in: 901cb3b6 user: dan tags: trunk
14:07
Add tests to ensure that patchsets are handled correctly by the session rebase APIs. check-in: 0e45baae user: dan tags: sessions-rebase
12:00
Add the left join strength reduction optimization. Enhance the push-down optimization so that it works with many LEFT JOINs. check-in: dd568c27 user: drh tags: trunk
11:28
Add the --valid-sql option to the optfuzz test program. check-in: a8dfeec7 user: drh tags: trunk
11:15
Remove some unused code from the sessions module. check-in: a09518ab user: dan tags: sessions-rebase
2018-03-21
20:21
Get the optfuzz program working. check-in: 21346bbc user: drh tags: trunk
20:13
Merge latest trunk changes into this branch. check-in: d00b71ec user: dan tags: sessions-rebase
19:46
Fix some documentation and other issues with the code on this branch. check-in: a9ec6862 user: dan tags: sessions-rebase
19:25
Add the optfuzz.c program for verifying the query planner using a fuzzer. This is an initial code check-in. check-in: 3fb21251 user: drh tags: trunk
17:29
Fix rebasing of UPDATE changes against a set of remote changesets that feature both OMIT and REPLACE conflict resolution on different fields of the same row. check-in: d8bc3fdb user: dan tags: sessions-rebase
01:59
Relax LEFT-JOIN restrictions on the push-down optimization. Closed-Leaf check-in: b5d3dd8c user: drh tags: join-strength-reduction
2018-03-20
22:52
Do a more thorough job of cleaning traces of the strength-reduced LEFT JOIN. check-in: 08833dda user: drh tags: join-strength-reduction
21:16
If terms of the WHERE clause require that the right table in a LEFT JOIN not be a null row, then simplify the LEFT JOIN into an ordinary JOIN. check-in: 5b7abecc user: drh tags: join-strength-reduction
20:27
Add further tests and documentation for the sessions rebase feature. check-in: 7475a363 user: dan tags: sessions-rebase
19:02
Fix incorrect testcase labels on two cases in join5.test. No changes to code. check-in: 4661ac81 user: drh tags: trunk
18:08
Improvements to the HAVING-to-WHERE optimization. The code uses less space and less CPU, and there is now ".selecttrace" output. check-in: 5ad668d4 user: drh tags: trunk
16:56
For 'zipfile', detect attempts to cause a duplicate entry via UPDATE. Also, fix handling of 'UPDATE OR REPLACE' statements run on zipfile virtual tables. Win32 portability fixes to the 'fileio' extension. Miscellaneous test fixes. check-in: b36caeca user: mistachkin tags: trunk
14:00
Merge all recent trunk enchancements, and especially the autoincrement write reduction fix. check-in: 25790049 user: drh tags: begin-concurrent-pnu
13:54
Remove debugging puts from concurrrent3.test. check-in: 13b49756 user: drh tags: begin-concurrent
13:52
Merge all recent enhancements from trunk. check-in: b0c2f760 user: drh tags: begin-concurrent
13:44
Avoid unnecessary write to the sqlite_sequence table when an insert is done into an autoincrement table with an application-specified rowid that is less than the maximum. check-in: ec7addc8 user: drh tags: trunk
13:26
Add the ability to disable the push-down optimization using the 0x1000 bit of SQLITE_TESTCTRL_OPTIMIZATIONS. Also some documentation fixes and an enhancement to ".eqp full" in the CLI. check-in: ae34edb7 user: drh tags: trunk
13:26
Fix handling of "UPDATE OR REPLACE" statements run on zipfile virtual tables. Closed-Leaf check-in: 9a5ef341 user: dan tags: testFixes
13:00
Remove a debugging statement accidently left in check-in [eddc35f3057e59fd] Closed-Leaf check-in: 85a31557 user: drh tags: push-down-disable
12:12
Add a test case for the fix on this branch. check-in: 7834cf6c user: dan tags: testFixes
12:04
In the CLI, avoid extra .selecttrace and .wheretrace output when in ".eqp full" mode. check-in: 427bbf31 user: drh tags: push-down-disable
11:58
Closer reading of the sqlite3_db_config() documentation show that it is subtly incorrect. This check-in fixes the problem. No code changes. check-in: 44d90e7f user: drh tags: push-down-disable
11:51
Fix a minor formatting issue on the sqlite3_db_config() documentation. No changes to code. check-in: 8a439a6d user: drh tags: push-down-disable
11:24
Add the ability to disable the push-down optimization using the 0x1000 bit of SQLITE_TESTCTRL_OPTIMIZATIONS. check-in: eddc35f3 user: drh tags: push-down-disable
2018-03-19
22:28
Minor improvements to ".selecttrace". No changes to non-debug code. check-in: 03e541f6 user: drh tags: trunk
19:05
Enhance the command-line completion extension to return the names of triggers and views along with the names of tables. check-in: 10e32204 user: drh tags: trunk
16:59
Show symbolic SELECT names in EXPLAIN QUERY PLAN output when compiling with SQLITE_ENABLE_SELECTTRACE. Leaf check-in: 16c22ff8 user: drh tags: EQP-improvements
16:09
In the compile_options pragma, show the actual value of the SQLITE_ENABLE_CEROD compile-time option, if it exists. check-in: 1ec339fd user: drh tags: trunk
16:06
Improved ".selecttrace" output formatting. No changes in non-debug code. check-in: 30704d2a user: drh tags: trunk
2018-03-17
16:26
Do not use sqlite3_column_decltype() in the CLI if it is compiled with SQLITE_OMIT_DECLTYPE. check-in: 442e816b user: drh tags: trunk
02:13
For 'zipfile', detect attempts to cause a duplicate entry via UPDATE. check-in: cf78a882 user: mistachkin tags: testFixes
00:44
Another Win32 portability fix for the 'zipfile' tests. check-in: 9f604418 user: mistachkin tags: testFixes
2018-03-16
23:59
Detect corruption in the form of the sqlite_sequence table pointing to the wrong type of btree. check-in: 525deb7a user: drh tags: trunk
23:54
Win32 portability fixes to the 'fileio' extension. check-in: 9d2b0f8b user: mistachkin tags: testFixes
23:54
Enable more 'zipfile' tests on Win32. check-in: 49d2566c user: mistachkin tags: testFixes
23:54
Make a couple tests less sensitive to timing. check-in: bc2af8e0 user: mistachkin tags: testFixes
23:53
Fix a duplicate test number and cleanup a bit of Makefile whitespace. check-in: 56d11c25 user: mistachkin tags: testFixes
20:23
Detect databases whose schema is corrupted using a CREATE TABLE AS statement and issue an appropriate error message. check-in: d75e6765 user: drh tags: trunk
20:15
Better error message text when the schema is corrupted by a CREATE TABLE AS entry. Closed-Leaf check-in: e13993cf user: drh tags: corrupt-schema
19:10
Fix a parsing issue associated with a corrupt sqlite_master table. check-in: 5f779ff6 user: mistachkin tags: corrupt-schema
18:46
Avoid writing the sqlite_sequence table when it has not actually changed. Closed-Leaf check-in: 3e3849a9 user: drh tags: autoinc-enhancement
18:02
Fix a problem with handling rebasing UPDATE changes for REPLACE conflict resolution. check-in: f7bf71f1 user: dan tags: sessions-rebase
07:49
Fix a problem in test script thread001.test causing a spurious "-1 files were left open" error when run separately. Cherrypick of [1774f1c3b]. check-in: 6cf8172d user: dan tags: branch-3.19
07:48
Fix a problem in test script thread001.test causing a spurious "-1 files were left open" error when run separately. check-in: 1774f1c3 user: dan tags: trunk
2018-03-15
19:25
Add simple tests for the sessions module rebase API. check-in: cf0d1abb user: dan tags: sessions-rebase
17:46
Fix a typo in a comment used to generate documentation. No code changes. check-in: f1784aff user: drh tags: trunk
15:09
Fix an issue with the fsdir() table-valued function not resetting correctly after each pass of a join. check-in: 7ce4e71c user: drh tags: trunk
05:25
Draft fix for an fsdir() issue reported via the mailing list. Closed-Leaf check-in: 48641010 user: mistachkin tags: fsDirFix
2018-03-14
21:06
Add largely untested APIs for rebasing changesets. check-in: 39915b68 user: dan tags: sessions-rebase
17:17
Merge the latest enhancements from trunk. check-in: a658f80c user: drh tags: apple-osx
15:25
Add the SQLITE_DBSTATUS_CACHE_SPILL option to sqlite3_db_status(). check-in: 48a06eb0 user: drh tags: trunk
15:06
Disable one of the test cases from check-in [21ecbce1378f3cc4] when API_ARMOR is not enabled. check-in: 8fb23d42 user: drh tags: trunk