This Day In History For 2021-03-16
1 Year Ago (more context)
|
2020-03-16
| ||
| 19:00 | • Closed ticket [618156e3f6]: clearSelect: Assertion `p->pWin==0' failed. plus 5 other changes (artifact: 5d2842adc3 user: dan) | |
| 18:52 | Fix handling of window functions in aggregate queries that have no GROUP BY clause. Also remove a faulty assert causing the error reported in [618156e3]. (check-in: 38e3dd389d user: dan tags: trunk) | |
| 17:35 | • New ticket [618156e3f6] clearSelect: Assertion `p->pWin==0' failed.. (artifact: d39dfc6c5c user: yongheng) | |
| 03:19 | • Fixed ticket [82b588d342]: Assertion `memIsValid(&r.aMemii)' failed. plus 6 other changes (artifact: f92b45354a user: drh) | |
| 03:07 | At the end of the right-hand table loop of a LEFT JOIN that uses an IN operator in the ON clause, put the OP_IfNoHope operator after the OP_IfNotOpen operator, not before, to avoid a (harmless) uninitialized register reference. Ticket [82b588d342d515d1] (check-in: 8b437b4726 user: drh tags: trunk) | |
2 Years Ago (more context)
|
2019-03-16
| ||
| 20:29 | Fix problems with RANGE windows and string, blob and NULL values. (check-in: cebe09e11c user: dan tags: window-functions) | |
| 10:15 | In order to identify the first row of each partition, check if the rowid in the ephemeral table is 1 instead of using a dedicated flag register. (check-in: f2d5f7a24c user: dan tags: window-functions) | |
3 Years Ago (more context)
|
2018-03-16
| ||
| 23:59 | Detect corruption in the form of the sqlite_sequence table pointing to the wrong type of btree. (check-in: 525deb7a67 user: drh tags: trunk) | |
| 23:54 | Win32 portability fixes to the 'fileio' extension. (check-in: 9d2b0f8b84 user: mistachkin tags: testFixes) | |
| 23:54 | Enable more 'zipfile' tests on Win32. (check-in: 49d2566c8e user: mistachkin tags: testFixes) | |
| 23:54 | Make a couple tests less sensitive to timing. (check-in: bc2af8e0aa user: mistachkin tags: testFixes) | |
| 23:53 | Fix a duplicate test number and cleanup a bit of Makefile whitespace. (check-in: 56d11c2509 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: d75e67654a 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: e13993cf83 user: drh tags: corrupt-schema) | |
| 19:58 | • Edit [5f779ff6b48ec97e|5f779ff6b4]: Move to branch corrupt-schema. (artifact: 80b9302bec user: drh) | |
| 19:10 | Fix a parsing issue associated with a corrupt sqlite_master table. (check-in: 5f779ff6b4 user: mistachkin tags: corrupt-schema) | |
| 18:46 | Avoid writing the sqlite_sequence table when it has not actually changed. (Closed-Leaf check-in: 3e3849a9d1 user: drh tags: autoinc-enhancement) | |
| 18:02 | Fix a problem with handling rebasing UPDATE changes for REPLACE conflict resolution. (check-in: f7bf71f1d4 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: 6cf8172d94 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: 1774f1c3ba user: dan tags: trunk) | |
4 Years Ago (more context)
|
2017-03-16
| ||
| 18:55 | If the user has not set it explicitly, set the "PRAGMA synchronous" setting to SQLITE_DEFAULT_SYNCHRONOUS when a database connection changes from wal to rollback journal mode. (check-in: 5c604479fd user: dan tags: trunk) | |
| 18:54 | Fix a typo causing the build to fail if SQLITE_DEFAULT_SYNCHRONOUS==SQLITE_DEFAULT_WAL_SYNCHRONOUS. (Closed-Leaf check-in: df39adeaa4 user: dan tags: default-synchronous-fix) | |
| 18:53 | • Edit [78030c0f52aa39fb|78030c0f52]: Move to branch default-synchronous-fix. (artifact: b32da8e13d user: dan) | |
| 18:14 | If the user has not set it explicitly, set the "PRAGMA synchronous" setting to SQLITE_DEFAULT_SYNCHRONOUS when a database connection changes from wal to rollback journal mode. (check-in: 78030c0f52 user: dan tags: default-synchronous-fix) | |
| 14:28 | Simplified OOM detection in the instr() SQL function. (check-in: 6d85eb5736 user: drh tags: trunk) | |
| 13:30 | Fix an uninitialized variable reference in the text generator for "PRAGMA vdbe_trace=ON" output. Problem discovered by OSS-Fuzz. (check-in: e3d487162d user: drh tags: trunk) | |
| 13:25 | • Edit [6e59e903e4e95661|6e59e903e4]: Edit check-in comment. (artifact: 8f0f466805 user: drh) | |
| 13:14 | Fix a problem in the "showdb" utility that prevents it from correctly decoding cells with no content beyond the record header. (check-in: eb7680a1c0 user: drh tags: trunk) | |
| 12:11 | Fix a crash that could follow an OOM condition in the instr() SQL function. Problem discovered by OSS-Fuzz. (check-in: 6e59e903e4 user: dan tags: trunk) | |
5 Years Ago (more context)
|
2016-03-16
| ||
| 21:29 | The prepared statements for some pragmas can now be reused without invoking an automatic reprepare. (check-in: 97b0e88cc7 user: drh tags: trunk) | |
| 20:53 | Merge the changes on the reusable-pragma branch into this one. (check-in: 6c4a17b963 user: dan tags: fts5-data-version) | |
| 20:44 | Some pragmas can be reused without an automatic reprepare. (Closed-Leaf check-in: db1ce7e13e user: drh tags: reusable-pragma) | |
| 20:05 | Fix a comment on the freelist_count and data_version pragmas. (check-in: 10a3e2a01d user: drh tags: trunk) | |
| 19:53 | Add a cast to an implict (size_t -> int) conversion in fts5_expr.c. (check-in: d9b5ff7aba user: dan tags: trunk) | |
| 19:48 | Have fts5 cache the decoded structure of fts5 indexes in memory. Use "PRAGMA data_version" to detect stale caches. (check-in: 33ef2210ef user: dan tags: fts5-data-version) | |
| 19:45 | Enhance Lemon so that it reorders the reduce rules such that rules without actions occur at the end and so that the first rule is number 0. This reduces the size of the jump table on the reduce switch, and helps the parser to run faster. (check-in: d5712f21ec user: drh tags: trunk) | |
| 19:34 | Merge the latest enhancements from trunk. (check-in: a7978ab6d2 user: drh tags: begin-concurrent) | |
| 19:10 | Avoid a few unnecessary fstat()s on journal files. (check-in: dbf8470591 user: drh tags: trunk) | |
| 18:26 | Fix the query planner so that it is able to use the integer primary key from an index as part of a multi-column constraint. (check-in: 96ea990942 user: drh tags: trunk) | |
| 01:16 | Merge all recent enhancements from trunk. (check-in: 6a7ee04b0d user: drh tags: sessions) | |
| 01:09 | Merge the SQLITE_OMIT_CODEC_FROM_TCL compile-time option from trunk. (check-in: 161d91e485 user: drh tags: apple-osx) | |
| 01:03 | Add the SQLITE_OMIT_CODEC_FROM_TCL compile-time option. (check-in: 45f7f0c80b user: drh tags: trunk) | |
| 00:36 | Rearrange some internal fields in the sqlite3_stmt object to avoid a harmless TSAN warning. (check-in: e0b116edd6 user: drh tags: trunk) | |
10 Years Ago (more context)
|
2011-03-16
| ||
| 19:59 | Add the sqlite3_preupdate_new() API, for retrieving the new.* values from within a pre-update callback. (check-in: 526545c49f user: dan tags: sessions) | |
| 18:54 | Additional interpretation of flags and constants in the VFS trace output. (check-in: 3e984195f1 user: drh tags: trunk) | |
| 17:05 | Add the -vfstrace option to the usage error message in the shell. (check-in: baca45c549 user: drh tags: trunk) | |
| 16:56 | Add the VFS-trace shim. (check-in: f49a9ef338 user: drh tags: trunk) | |
| 09:49 | Remove the sqlite3_transaction_hook() API. (check-in: b0015a1cfe user: dan tags: sessions) | |
15 Years Ago (more context)
|
2006-03-16
| ||
| 16:19 | Fix some compiler warnings. (CVS 3140) (check-in: 6c5175bc0f user: drh tags: trunk) | |
| 14:05 | Make provisions in the code to support Provisions to support caching of serialized statements in the SSE extension. (CVS 3139) (check-in: 5048fae042 user: drh tags: trunk) | |