SQLite
Timeline
Not logged in

50 most recent timeline items

2017-11-24
16:55
[e3b6e220] Leaf: Enhance the configure script to detect zLib. (user: drh, tags: trunk)
2017-11-23
04:45
[b016c28f] Fix a problem in the omit-table-from-left-join optimization from check-in [0cd82ee9a8413cf] that was discovered by OSSFuzz. (user: drh, tags: trunk)
00:48 • Fixed ticket [ef931875]: Incorrect result due to the skip-ahead-distinct optimization plus 3 other changes (user: drh)
00:45
[b7595cf2] Completely disable the skip-ahead-distinct optimization for all but the inner-most loop of a DISTINCT join. Fix for ticket [ef9318757b152e3a26e9592] (user: drh, tags: trunk)
00:16 • Ticket [ef931875] Incorrect result due to the skip-ahead-distinct optimization status still Open with 6 other changes (user: drh)
2017-11-21
23:47
[a33f88ac] Leaf: An experimental optimization to DISTINCT that causes an immediate exit of the inner loop of a join following each output row if the inner loop does not contribute any columns to the result set. (user: drh, tags: distinct-early-out)
23:38
[2dcef5a9] Fix the skip-ahead-distinct optimization on joins for cases there the table in the inner loop of the join does not contribute any columns to the result set. Proposed fix for ticket [ef9318757b152e3a2] (user: drh, tags: trunk)
21:15
[17dd2f73] Fix typo in the Makefiles for MSVC. (user: mistachkin, tags: trunk)
21:14
[9cb47430] Fix compilation issue (C99-ism) in the shell seen with MSVC. (user: mistachkin, tags: trunk)
20:53
[0cd82ee9] Update the omit-table-from-left-join optimization so that it can omit tables from the middle of the join as well as the end. (user: dan, tags: trunk)
19:22
[618ca9fe] Closed-Leaf: Update the omit-table-from-left-join optimization so that it can omit tables from the middle of the join as well as the end. (user: dan, tags: left-join-optimization)
15:19 • New ticket [ef931875] Incorrect result due to the skip-ahead-distinct optimization. (user: drh)
2017-11-20
15:46
[7fdb1e2a] Fix a problem preventing the planner from identifying scans that visit at most one row in cases where that property is guaranteed by a unique, not-null, non-IPK column that is the leftmost in its table. (user: dan, tags: trunk)
15:45
[bff5dcfd] Closed-Leaf: Fix a typo in a test script on this branch. (user: dan, tags: left-join-omit-fix)
15:44 • Edit [299d7ca52fec32f0|299d7ca5]: Move to branch left-join-omit-fix. (user: dan)
14:40
[299d7ca5] Fix a problem preventing the planner from identifying scans that visit at most one row in cases where that property is guaranteed by a unique, not-null, non-IPK column that is the leftmost in its table. (user: dan, tags: left-join-omit-fix)
2017-11-18
18:07
[ee840a76] Enhance the log messages produced in some cases if database corruption is encountered by an SQLITE_DEBUG build. (user: dan, tags: trunk)
17:30
[23a31280] Closed-Leaf: Enhance the log messages produced in some cases if database corruption is encountered by an SQLITE_DEBUG build. (user: dan, tags: sqlite-corrupt-page)
2017-11-17
21:01
[723f1be3] Improved fix for ticket [da78413751863] that does not require disabling the query flattener as was done in [005d5b870625]. This also makes the code generator for vector IN operators a little easier to understand. (user: drh, tags: trunk)
20:22
[e2b3e335] Leaf: Add missing entry for SQLITE_IOERR_VNODE to the switch statement in sqlite3ErrName(). (user: dan, tags: apple-osx)
20:16
[97ab1efe] Add an 'extern "C"' wrapper to sqlite3_private.h. (user: dan, tags: apple-osx)
20:10
[32f5f461] Merge test script fixes from trunk into this branch. (user: dan, tags: apple-osx)
20:07
[c21406ab] Add some missing "finish_test" lines to the end of test scripts. (user: dan, tags: trunk)
17:32
[00c32831] New assert() statements in the rowvalue IN expression processing. (user: drh, tags: trunk)
15:02
[071cabd2] Clarification of comments on sqlite3FindInIndex(). No changes to code. (user: drh, tags: trunk)
13:23
[162c7543] Merge latest changes from trunk, including the temporary db/ATTACH/master-journal fix. (user: dan, tags: apple-osx)
13:21
[93e012a3] Do not count temporary databases that have been attached using ATTACH when figuring out if a master-journal file is required by a transaction. (user: dan, tags: trunk)
08:20
[355d1232] Closed-Leaf: Avoid creating a master journal if all or all but one of the databases in the transaction is a temp file. (user: dan, tags: master-journal-temp-files)
03:30 • Edit [5ffec5db33137251|5ffec5db]: Edit check-in comment. (user: drh)
2017-11-16
20:48
[5ffec5db] In the LSM extension, ensure that empty space on pages is zeroed before they are written to disk. This helps with compressed databases, and stops valgrind complaining about uninitialized bytes and write(). (user: dan, tags: trunk)
19:17
[85247880] Merge the latest changes, and the stmtvtab1.test fix, from trunk. (user: drh, tags: apple-osx)
19:04
[e0b5c058] Add a missing "finish_test" to the end of the stmtvtab1.test script. (user: drh, tags: trunk)
2017-11-15
19:14
[1ca3b8cc] Futher improvements to the .testctrl interface in the shell. (user: drh, tags: trunk)
17:07
[5d66219c] UI improvements on the .testctrl dot-command in the shell. (user: drh, tags: trunk)
16:29
[1a1a73b8] Leaf: Merge all the latest changes from trunk. (user: drh, tags: appendvfs)
2017-11-14
23:48
[3925facd] In the parse tree, combine LIMIT and OFFSET into a single expression rooted on a TK_LIMIT node, for a small code size reduction and performance increase, and a reduction in code complexity. (user: drh, tags: trunk)
21:06
[adf83060] Fix a typo that prevented successful builds on macs. (user: drh, tags: apple-osx)
20:36
[8c2a769c] Merge the patch that enables reading a read-only WAL-mode database, without any special query parameters, as long as the -shm and -wal files are on disk. (user: drh, tags: apple-osx)
20:06
[d90e5f34] Leaf: Merge changes from trunk. This fixes the SQLITE_ENABLE_UPDATE_DELETE_LIMIT functionality so that it works with views and WITHOUT ROWID tables. (user: dan, tags: begin-concurrent)
20:00
[1754faef] Merge all changes from trunk prior to the read-only WAL enhancement. (user: drh, tags: apple-osx)
19:34
[00ec95fc] Add the ability to read from read-only WAL-mode database files as long as the -wal and -shm files are present on disk. (user: drh, tags: trunk)
18:26
[b2679d3b] Leaf: Fix the SQLITE_ENABLE_UPDATE_DELETE_LIMIT functionality so that it works with views and WITHOUT ROWID tables. This is a modified cherrypick of [dae4a97a]. (user: dan, tags: branch-3.8.9)
17:07 • Edit [72be33f9c84de3ec|72be33f9]: Mark "Closed". (user: dan)
17:06
[dae4a97a] Fix the SQLITE_ENABLE_UPDATE_DELETE_LIMIT functionality so that it works with views and WITHOUT ROWID tables. (user: dan, tags: trunk)
03:42
[486949fc] Closed-Leaf: Improvement to a comment. No changes to code. (user: drh, tags: readonly-wal-recovery)
2017-11-13
05:51
[9c6b38b9] Remove some branches in walTryBeginRead() that were added by check-in [ce5d13c2de] but became unreachable with the addition of logic in check-in [18b26843] that enabled read-only clients to parse the WAL file into a heap-memory WAL-index, thus guaranteeing that the WAL-index header is always available. (user: drh, tags: readonly-wal-recovery)
2017-11-11
20:11
[13ec8a77] In wal.c: improved comments, new assert() and testcase() macros, and replace some magic numbers with appropriate symbolic constants. (user: drh, tags: readonly-wal-recovery)
13:30
[34638800] Further comment improvements in wal.c. No code changes. (user: drh, tags: readonly-wal-recovery)
2017-11-10
20:13
[72be33f9] Closed-Leaf: Omit some extra code from non-SQLITE_ENABLE_UPDATE_DELETE_LIMIT builds. (user: dan, tags: update-delete-limit-fix)
20:00
[d3c25740] Improved comments and variable names in the read-only WAL logic. (user: drh, tags: readonly-wal-recovery)