This Day In History For 2022-01-14
1 Year Ago (more context)
|
2021-01-14
| ||
| 20:57 | Improvements to the min/max optimization. Fix for a performance regression introduced at [b8ba2f17f938c035] reported by forum post 4050026ab8 (check-in: 249a71cc68 user: drh tags: trunk) | |
| 20:50 | Allow the planner to convert an EXISTS(SELECT...) expression in a WHERE clause to the equivalent IN(...) expression in situations where this is possible and advantageous. (check-in: 9f90a88221 user: dan tags: exists-to-in) | |
| 00:53 | The early-out of the inner loop on the min/max optimization was overly aggressive for the cases where there is a join and outer loops contain IN operators. Fix this. Test case in TH3. (Closed-Leaf check-in: ccd3bae14b user: drh tags: minmax-opt-exp) | |
2 Years Ago (more context)
|
2020-01-14
| ||
| 16:50 | Fix the urifuncs.c extension (used for testing and debugging only) so that the sqlite3_filename_database() SQL function and its siblings correctly handle an invalid schema name passed in as the argument. (check-in: 3d7434a9d8 user: drh tags: trunk) | |
| 16:39 | Remove an ALWAYS on a branch for improved database corruption detection in btree.c:freeSpace(). Test case found by dbsqlfuzz. (check-in: 54bf048119 user: drh tags: trunk) | |
| 16:33 | Add the new noop_nd() debugging function to the noop.c extension. (check-in: 72911fb1b0 user: drh tags: trunk) | |
| 14:47 | • Edit [5b246b47aeadc25d|5b246b47ae]: Edit check-in comment. (artifact: 42fe000a4e user: drh) | |
| 13:24 | For the showdb utility program, more accurate detection of when the database is in autovacuum mode for the "pgidx" subcommand. (check-in: 9ce2192b81 user: drh tags: trunk) | |
| 13:13 | Fix a minor typo on a comment in the CLI implementation. (check-in: db4fb3503c user: drh tags: trunk) | |
| 00:52 | Improvements to sqlite3_open_v2() documentation. (check-in: 4c4fd62a09 user: drh tags: trunk) | |
3 Years Ago (more context)
|
2019-01-14
| ||
| 20:44 | Add scalar function "prefix_length()" to ext/misc/prefixes.c. (check-in: 0bf1550507 user: dan tags: trunk) | |
| 19:13 | Fix a problem causing some Tcl test cases to fail with errors like "expected: [<multiline-whitespace>], got: []". (check-in: 11b8a4cba7 user: dan tags: trunk) | |
| 16:16 | Add the "prefixes" table-valued function in the ext/misc folder. (check-in: f0fd2163fc user: drh tags: trunk) | |
| 15:35 | Fix a problem causing a crash if an fts5vocab table was created to query an fts3/4 FTS index. (check-in: 9cd64ce453 user: dan tags: trunk) | |
| 15:09 | Fix a problem with querying a corrupt fts3 database. (check-in: 65e50706a0 user: dan tags: trunk) | |
| 13:32 | When parsing a corrupt record using sqlite3VdbeRecordUnpack(), make sure that the resulting UnpackedRecord object is completely initialized, to avoid (harmless) MSAN warnings. (check-in: ddc3697efd user: drh tags: trunk) | |
| 11:56 | Have fts3 ignore empty sets of parenthesis if built with SQLITE_ENABLE_FTS3_PARENTHESIS. (check-in: c93c6b45a3 user: dan tags: trunk) | |
| 05:48 | Avoid reading off the front of a page buffer when balancing a corrupt btree page. (check-in: cb50509020 user: drh tags: trunk) | |
4 Years Ago (more context)
|
2018-01-14
| ||
| 20:12 | Avoid excess stack usage when a VALUES clause with lots of rows occurs within a scalar expression. This fixes a problem discovered by OSSFuzz. (check-in: a4fa0581ba user: drh tags: trunk) | |
10 Years Ago (more context)
|
2012-01-14
| ||
| 15:35 | • Fixed ticket [ff5be73dee]: Database corruption following power-loss in WAL mode plus 1 other change (artifact: 34016eef64 user: drh) | |
| 15:34 | • Fixed ticket [a1fa75cbdd]: Database corruption following unlucky application crash in WAL mode with "PRAGMA journal_size_limit" plus 1 other change (artifact: bc95ad9349 user: drh) | |
| 15:29 | • Edit [9799241f7de952c4|9799241f7d]: Mark "Closed". (artifact: 712e8abb72 user: drh) | |
| 15:29 | • Edit [d474195a997b9d94|d474195a99]: Mark "Closed". (artifact: b8063baa24 user: drh) | |
| 15:29 | • Edit [6191c5e45175f5c6|6191c5e451]: Mark "Closed". (artifact: 557f74ef22 user: drh) | |
| 15:28 | • Edit [638a39bbaa034a08|638a39bbaa]: Mark "Closed". (artifact: 8c7107d7c2 user: drh) | |
| 15:28 | • Edit [6492af76ea6585a1|6492af76ea]: Mark "Closed". (artifact: 3b59fefcdf user: drh) | |
| 14:13 | Merge the latest trunk changes into the apple-osx branch. (check-in: 2cc414cd14 user: drh tags: apple-osx) | |
| 13:50 | Update sessions branch with latest changes from trunk. (check-in: 01c84fd391 user: dan tags: sessions) | |
| 03:34 | Make sure the EXTERN macro is properly defined when building targets that require it (e.g. on MinGW). (check-in: 88ad2f23c5 user: mistachkin tags: trunk) | |
| 00:42 | In the multiplexor routine that determines the size of an overflow file, return 0 and leave the error code unchanges if there were prior errors. This prevents some I/O errors from going unreported in nx-devkit tests. (check-in: 6da0821a47 user: drh tags: trunk) | |
20 Years Ago (more context)
|
2002-01-14
| ||
| 09:28 | Fix warning messages in VC++. Patches from nicolas352001. (CVS 347) (check-in: f3038d218c user: drh tags: trunk) | |
| 03:00 | Version 2.2.2 (CVS 451) (check-in: 7da00a33fe user: drh tags: trunk) | |
| 02:56 | Fix a bug that could cause UPDATE to fail for a table that contains both an INTEGER PRIMARY KEY and an index. (CVS 346) (check-in: 96cd07a881 user: drh tags: trunk) | |