Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
54 events for the month beginning 2017-11-01 by user drh
Following month ↑|
2017-11-28
| ||
| 02:47 | Add the "PRAGMA table_ipk(TABLE)" command for evaluation purposes. (Leaf check-in: 2494132a user: drh tags: pragma-table-ipk) | |
| 00:52 | Update tests to deal with SQLITE_FAST_SECURE_DELETE. (check-in: e6b89304 user: drh tags: trunk) | |
|
2017-11-26
| ||
| 02:14 | Fix an CSV output quoting problem in the command-line shell on Windows. (check-in: 6500cdbd user: drh tags: trunk) | |
| 00:49 | • Fixed ticket [d4beea16]: DELETE with a LIMIT does not work for WITHOUT ROWID tables plus 5 other changes (artifact: e11d4c75 user: drh) | |
|
2017-11-24
| ||
| 16:55 | Enhance the configure script to detect zLib. (check-in: e3b6e220 user: drh tags: trunk) | |
|
2017-11-23
| ||
| 04:45 | Fix a problem in the omit-table-from-left-join optimization from check-in [0cd82ee9a8413cf] that was discovered by OSSFuzz. (check-in: b016c28f user: drh tags: trunk) | |
| 00:48 | • Fixed ticket [ef931875]: Incorrect result due to the skip-ahead-distinct optimization plus 3 other changes (artifact: 8331c214 user: drh) | |
| 00:45 | Completely disable the skip-ahead-distinct optimization for all but the inner-most loop of a DISTINCT join. Fix for ticket [ef9318757b152e3a26e9592] (check-in: b7595cf2 user: drh tags: trunk) | |
| 00:16 | • Ticket [ef931875] Incorrect result due to the skip-ahead-distinct optimization status still Open with 6 other changes (artifact: 0dfce830 user: drh) | |
|
2017-11-21
| ||
| 23:47 | 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. (Leaf check-in: a33f88ac user: drh tags: distinct-early-out) | |
| 23:38 | 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] (check-in: 2dcef5a9 user: drh tags: trunk) | |
| 15:19 | • New ticket [ef931875] Incorrect result due to the skip-ahead-distinct optimization. (artifact: 00f210e1 user: drh) | |
|
2017-11-17
| ||
| 21:01 | 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. (check-in: 723f1be3 user: drh tags: trunk) | |
| 17:32 | New assert() statements in the rowvalue IN expression processing. (check-in: 00c32831 user: drh tags: trunk) | |
| 15:02 | Clarification of comments on sqlite3FindInIndex(). No changes to code. (check-in: 071cabd2 user: drh tags: trunk) | |
| 03:30 | • Edit [5ffec5db33137251|5ffec5db]: Edit check-in comment. (artifact: 371e29f1 user: drh) | |
|
2017-11-16
| ||
| 19:17 | Merge the latest changes, and the stmtvtab1.test fix, from trunk. (check-in: 85247880 user: drh tags: apple-osx) | |
| 19:04 | Add a missing "finish_test" to the end of the stmtvtab1.test script. (check-in: e0b5c058 user: drh tags: trunk) | |
|
2017-11-15
| ||
| 19:14 | Futher improvements to the .testctrl interface in the shell. (check-in: 1ca3b8cc user: drh tags: trunk) | |
| 17:07 | UI improvements on the .testctrl dot-command in the shell. (check-in: 5d66219c user: drh tags: trunk) | |
| 16:29 | Merge all the latest changes from trunk. (check-in: 1a1a73b8 user: drh tags: appendvfs) | |
|
2017-11-14
| ||
| 23:48 | 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. (check-in: 3925facd user: drh tags: trunk) | |
| 21:06 | Fix a typo that prevented successful builds on macs. (check-in: adf83060 user: drh tags: apple-osx) | |
| 20:36 | 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. (check-in: 8c2a769c user: drh tags: apple-osx) | |
| 20:00 | Merge all changes from trunk prior to the read-only WAL enhancement. (check-in: 1754faef user: drh tags: apple-osx) | |
| 19:34 | Add the ability to read from read-only WAL-mode database files as long as the -wal and -shm files are present on disk. (check-in: 00ec95fc user: drh tags: trunk) | |
| 03:42 | Improvement to a comment. No changes to code. (Closed-Leaf check-in: 486949fc user: drh tags: readonly-wal-recovery) | |
|
2017-11-13
| ||
| 05:51 | 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. (check-in: 9c6b38b9 user: drh tags: readonly-wal-recovery) | |
|
2017-11-11
| ||
| 20:11 | In wal.c: improved comments, new assert() and testcase() macros, and replace some magic numbers with appropriate symbolic constants. (check-in: 13ec8a77 user: drh tags: readonly-wal-recovery) | |
| 13:30 | Further comment improvements in wal.c. No code changes. (check-in: 34638800 user: drh tags: readonly-wal-recovery) | |
|
2017-11-10
| ||
| 20:00 | Improved comments and variable names in the read-only WAL logic. (check-in: d3c25740 user: drh tags: readonly-wal-recovery) | |
|
2017-11-09
| ||
| 04:13 | Disallow ORDER BY and LIMIT on UPDATE and DELETE of views and WITHOUT ROWID tables. This is a temporary fix for ticket [d4beea1633f1b88f] until a better solution can be found. (check-in: 30aa941f user: drh tags: branch-3.8.9) | |
| 03:55 | Disallow ORDER BY and LIMIT on UPDATE and DELETE of views and WITHOUT ROWID tables. This is a temporary fix for ticket [d4beea1633f1b88f] until a better solution can be found. (check-in: 62fe56b5 user: drh tags: trunk) | |
|
2017-11-08
| ||
| 22:39 | • New ticket [d4beea16] DELETE with a LIMIT does not work for WITHOUT ROWID tables. (artifact: ae6f207a user: drh) | |
| 19:26 | Extra comments on the sqlite3OsShmMap() call in walBeginUnlocked(). No changes to code. (check-in: 033ee92b user: drh tags: readonly-wal-recovery) | |
| 17:51 | Turns out that SQLITE_READONLY_CANTLOCK is an historical name that must be preserved. So make a new SQLITE_READLOCK_CANTINIT name instead. (check-in: 04974a8b user: drh tags: readonly-wal-recovery) | |
| 17:32 | Change the name of SQLITE_READONLY_CANTLOCK to SQLITE_READONLY_CANTINIT. (check-in: 6d7f94fa user: drh tags: readonly-wal-recovery) | |
| 02:50 | Improved comments used for documentation of sqlite3_vfs. No changes to code. (check-in: db8f22d0 user: drh tags: trunk) | |
|
2017-11-07
| ||
| 16:54 | Add the --trace option to the sqlite3_checker utility program. (check-in: dc217b7c user: drh tags: trunk) | |
| 16:23 | Enhance the checkindex.c virtual table so that it will output the index_name and after_key parameters. Also add a new diagnostic output column named scanner_sql which shows the SQL statement used to implement the current index scan. (check-in: 32e2520c user: drh tags: trunk) | |
|
2017-11-06
| ||
| 09:34 | Fix a harmless compiler warning from Xcode 9.1. (check-in: 66d98310 user: drh tags: trunk) | |
|
2017-11-03
| ||
| 08:46 | The extensions functions in spellfix are all deterministic. (check-in: 29ec855e user: drh tags: trunk) | |
|
2017-11-01
| ||
| 19:58 | Fix harmless compiler warnings in sqlite3_checker.exe (check-in: 491f867b user: drh tags: trunk) | |
| 19:50 | Make sure the JSON1 extension is available to sqlite3_checker.exe (check-in: a946a8ed user: drh tags: trunk) | |
| 19:44 | Add the checkindex.c extension and the sqlite3_checker utility program used for doing live validation of large databases. (check-in: 0c5d18a0 user: drh tags: trunk) | |
| 19:30 | Fix the SQLITE_NoopUpdate #define so that it occurs under the correct conditions. (check-in: bdf791f9 user: drh tags: begin-concurrent-pnu) | |
| 19:22 | Adjust page numbers in the ext/repair/test/checkfreelist01.test module due to the fact that the pending-byte page is no longer shifted down to a low-numbered page but is in its rightful place. (Closed-Leaf check-in: c1641aff user: drh tags: checkindex) | |
| 18:48 | The "PRAGMA noop_update" command now requires SQLITE_ENABLE_NOOP_UPDATE and no longer requires SQLITE_DEBUG. (check-in: 81baf67c user: drh tags: begin-concurrent-pnu) | |
| 18:31 | Add the "sqlite3_imposter DB SCHEMA ROOT SQL" command to sqlite3_checker. Use it to fix the checkindex01.test module. There are still errors reported by the checkfreelist01.test module. (check-in: 0593a2ba user: drh tags: checkindex) | |
| 18:05 | Move the test scripts for checkfreelist and checkindex over into the ext/repair/test directory. Run them now using the sqlite3_checker utility with the --test option. Some tests are currently failing due to an incomplete port. This is an incremental check-in. (check-in: 17f8d5e1 user: drh tags: checkindex) | |
| 13:09 | Minor cleanup in checkindex.c. Add progress displays when checking a single index in the top-level TCL script for sqlite3_checker. (check-in: 3ca31cc3 user: drh tags: checkindex) | |
| 01:05 | When sqlite3_checker finds a problem, show the row key as part of the error message, not the row index number. (check-in: 6ffe917d user: drh tags: checkindex) | |
| 01:01 | Actually perform index checks when running sqlite3_checker (check-in: 54530020 user: drh tags: checkindex) | |
| 00:10 | Begin putting functionality into the sqlite3_checker binary. (check-in: e82e883b user: drh tags: checkindex) | |