This Day In History For 2022-01-12
1 Year Ago (more context)
|
2021-01-12
| ||
| 20:16 | Lexer and grammar rules for a RETURNING clause on DELETE/INSERT/UPDATE. Actually making this work, though, will involve a lot more code which will likely slow down processing for the common case where there is no RETURNING clause. Furthermore, RETURNING seems to be of limited usefulness and it is not standard SQL. So we abandon it here. These experimental changes are parked in a branch as an historical reference. If circumstances changes, we might take up the cause again some day. (check-in: abf8da8156 user: drh tags: returning) | |
| 16:26 | Merge the ParseCleanup enhancement to trunk. (check-in: 35824c1bcb user: drh tags: trunk) | |
| 15:30 | Fix a potential use-after-free following an OOM in sqlite3ParserAddCleanup() and add a mechanism to detect situations where this might occur in the future. (Closed-Leaf check-in: 38ef8ab983 user: drh tags: parse-cleanup) | |
| 14:23 | Rerun autoconf. (check-in: 8f3ab5da4c user: drh tags: trunk) | |
| 14:19 | Fix for the top-level configure script so that it works with tcl 8.7. (check-in: 4810f814ff user: dan tags: trunk) | |
| 02:27 | • Edit [affa2b7b316941b8|affa2b7b31]: Move to branch parse-cleanup. Edit check-in comment. (artifact: 411971520e user: drh) | |
2 Years Ago (more context)
|
2020-01-12
| ||
| 22:38 | Better than removing the incorrect assert() is to change it into a testcase() together with a comment indicating where an appropriate test case can be found, and the ticket that provoked the change. Ticket [614b25314c766238] (check-in: 3e3c60d812 user: drh tags: trunk) | |
| 22:25 | Change the zipfile virtual table so that the xBestIndex method gives a reasonable cost estimate even if no filename is specified. The missing filename error continues to be raised in the xFilter method. Meanwhile, the more reasonable cost estimate avoids unnecessary wierdness in the query planner. (check-in: 0e468aa6de user: drh tags: trunk) | |
| 22:20 | • Fixed ticket [614b25314c]: Assertion (pTabItem0.fg.jointype & JT_LEFT)==0 || ExprHasProperty(pOrExpr, EP_FromJoin) failed plus 5 other changes (artifact: 6def3b4465 user: drh) | |
| 22:20 | Remove an incorrect assert(). Fix for ticket [614b25314c766238] (check-in: 6a999c5aa0 user: drh tags: trunk) | |
| 21:51 | • New ticket [614b25314c] Assertion (pTabItem0.fg.jointype & JT_LEFT)==0 || ExprHasProperty(pOrExpr, EP_FromJoin) failed. (artifact: 5e9929959e user: yongheng) | |
| 20:47 | • Edit [3d23a275ab5d7d50|3d23a275ab]: Edit check-in comment. (artifact: d4a65be118 user: drh) | |
3 Years Ago (more context)
|
2019-01-12
| ||
| 21:30 | Prevent unsigned 32-bit integer overflow from leading to a buffer overread inside of an assert(). The problem fixed here is no reachable in production code. (check-in: 0f850a25d6 user: drh tags: trunk) | |
| 20:55 | Fix another problem with handling corrupt records in fts5_decode(). (check-in: 726e398b9d user: dan tags: trunk) | |
| 17:28 | • Changes to wiki page "branch/begin-concurrent-pnu-wal2" (artifact: 8d6de4b360 user: drh) | |
| 16:19 | Fix an off-by-one error on a Goto in the code generator, that only causes problems for a REPLACE on an INTEGER PRIMARY KEY in non-debug builds. Test case in TH3. (check-in: e35eb8776e user: drh tags: trunk) | |
| 14:58 | Fix a problem with corrupt database handling in the fts3 matchinfo() function. (check-in: 703646b1b5 user: dan tags: trunk) | |
| 00:45 | Improved detection of shadow table corruption in the fts5_decode() SQL function. (check-in: b74e5f3f30 user: drh tags: trunk) | |
| 00:12 | Improved shadow table corruption detection in the matchinfo() function of FTS3. (check-in: 567be3bb1e user: drh tags: trunk) | |
| 00:07 | Indicate that the database may be corrupt in the fts3corrupt4.test test script. (check-in: 473626d557 user: drh tags: trunk) | |
4 Years Ago (more context)
|
2018-01-12
| ||
| 23:38 | Add the sqlite3_value_nochange() API, usable from within the xUpdate method of a virtual table to discover whether or not a column was unchanged at the SQL level. (check-in: dec3ea4e4e user: drh tags: trunk) | |
| 23:18 | Improved comments. Slightly tighter implementation, but no big changes. (Closed-Leaf check-in: a1b3f28569 user: drh tags: sqlite3_value_nochange) | |
| 21:00 | Add the experimental sqlite3_value_nochange() interface usable by xUpdate methods of virtual tables to see if a column has actually changed values. (check-in: 8b7be15ece user: drh tags: sqlite3_value_nochange) | |
| 19:33 | Simplification to the implementation of OP_Insert. (check-in: 6acbdba59e user: drh tags: trunk) | |
| 19:20 | Fix error handling in sqlite3session_diff() when it is invoked for table "sqlite_stat1". (check-in: 874285e477 user: dan tags: trunk) | |
| 18:46 | Avoid an unnecessary branch when not using pre-update hooks. (check-in: ec96707eb3 user: drh tags: trunk) | |
| 18:03 | Fix obsolete comments. No changes to code. (check-in: ec39c99bea user: drh tags: trunk) | |
| 17:25 | Include changes made to the sqlite_stat1 table in changesets generated by the sessions module. sqlite_stat1 entries in such changesets are ignored by legacy clients. (check-in: 2064233533 user: dan tags: trunk) | |
| 16:44 | Experimental change to include changes made to the sqlite_stat1 table in changesets generated by the sessions module. sqlite_stat1 entries in such changesets are ignored by legacy clients. (Closed-Leaf check-in: bd46c44296 user: dan tags: sessions-stat1) | |
| 14:34 | Always use utimes() instead of utimensat() since the latter is not available even on some recent unix systems. (check-in: 30ed7a4b64 user: drh tags: trunk) | |
| 12:02 | Add a test to ensure that the sqlite3changeset_apply() function ignores tables that do not have the expected primary keys. (check-in: bf2daf0627 user: dan tags: trunk) | |
| 00:30 | Enable the one-pass optimization for DELETE and UPDATE on RTree. This is parked in a branch because is seems to make no measureable performance difference. (Leaf check-in: 8b8314cb9b user: drh tags: rtree-one-pass) | |
5 Years Ago (more context)
|
2017-01-12
| ||
| 23:37 | Attempt to detect physical sector sizes on Windows Vista and higher. (check-in: 6e388423c4 user: mistachkin tags: winSectorSize) | |
| 19:10 | Remove a branch that is probably unreachable, and which adds no value. (check-in: 9acc72381c user: drh tags: trunk) | |
| 16:21 | Fix harmless compiler warnings in the UPDATE code generator. (check-in: 385db26667 user: drh tags: trunk) | |
| 16:14 | Remove an unnecessary corruption test from the btree balancer. If corruption is present, it will be found harmlessly by later tests. (check-in: bddf39562d user: drh tags: trunk) | |
| 15:19 | Test case macros to show that the previous check-in is well tested. (Leaf check-in: bd8b977abb user: drh tags: extra-testcase-macros) | |
| 15:11 | Improved detection of cells that extend into the reserved space at the end of the page while adjusting overflow page pointers during autovacuum. (check-in: 8097712c9c user: drh tags: trunk) | |
| 11:52 | Remove invalid test case from cursorhints2.test (check-in: 163cc1b2f7 user: drh tags: trunk) | |
| 11:50 | Make sure Tcl_AppendResult() always has a NULL-pointer argument at the end. (check-in: c07aef6f90 user: drh tags: trunk) | |
10 Years Ago (more context)
|
2012-01-12
| ||
| 16:41 | Fix issues in test cases so that they work with DEFAULT_AUTOVACUUM defined. And with a small default cache-size. (check-in: a298465c39 user: dan tags: trunk) | |
| 15:05 | Fix typos in a testcase() macro introduced by the previous commit. (check-in: 0467742fd6 user: dan tags: trunk) | |
| 14:25 | Remove some assert() statements that can fail with corrupt databases. (check-in: 7654ae71bd user: dan tags: trunk) | |
15 Years Ago (more context)
|
2007-01-12
| ||
| 23:43 | Fix a bug in sqlite3_prepare_v2() introduced by checkin (3578) and reported on the mailing list. (CVS 3592) (check-in: 8724847036 user: drh tags: trunk) | |
| 23:09 | Fix a bug in lemon. The code in which the error appears might well be unreachable. The changes does not effect the code that is generated for the SQLite parser. Ticket #2164. (CVS 3591) (check-in: f4ee5d83e1 user: drh tags: trunk) | |