SQLite
Timeline
Not logged in

37 check-ins using file src/dbpage.c version 8db4c97f

2017-11-23
04:45
[b016c28f] Leaf: 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: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)
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)
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)
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)
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)
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)
2017-11-10
12:41
[3711ef23] Fix harmless compiler warning seen with MSVC. (user: mistachkin, tags: trunk)