This Day In History For 2023-11-02
1 Year Ago (more context)
|
2022-11-02
| ||
| 14:08 | Minor build cleanups and fix a harmless race condition in the OPFS part of tester1.js. (check-in: 70ee6ee014 user: stephan tags: trunk) | |
| 14:08 | Clarify documentation regarding the --recovery-db option to ".recover" and the magic 789 configuration option it is associated with. (check-in: f6fa0cffa9 user: drh tags: trunk) | |
| 13:09 | Minor improvements to API documentation in comments for the recovery extension. (check-in: ed1c3515ad user: drh tags: trunk) | |
| 11:53 | Add sqlite3_wasm_vfs_create_file() to replace Emscripten's FS.createDataFile() in a (mostly) VFS-agnostic way. Add a test for worker1's export (to bytearray) support. Re-add worker1 open-from-bytearray using sqlite3_wasm_vfs_create_file() but it's untested (requires a new interactive test app or maybe reconsideration). (check-in: b35e1225c9 user: stephan tags: trunk) | |
| 11:25 | Emcc seems confused by SQLITE_DEBUG, for reasons unknown. Use NDEBUG instead to simplify the #ifdef logic in sqlite3recover.c. (check-in: 2610779ac8 user: drh tags: trunk) | |
| 08:49 | Fix a symbol name typo which broke and exception-handling case in OPFS xOpen(). (check-in: 5bc83d5695 user: stephan tags: trunk) | |
| 08:10 | Fix a missing symbol in non-SQLITE_DEBUG builds. (check-in: 17cdcad627 user: stephan tags: trunk) | |
2 Years Ago (more context)
|
2021-11-02
| ||
| 22:26 | • Fixed ticket [5981a8c041]: Incorrect answer on a SeekScan query plus 6 other changes (artifact: fba198c9c3 user: drh) | |
| 22:24 | Correctly handle SeekScan on an IN operator of the middle term of an index when the right-most term is a range constraint. Fix for ticket [5981a8c041a3c2f3]. (check-in: aa24660e76 user: drh tags: trunk) | |
| 20:52 | Proposed fix for a problem associated with OP_SeekScan that results in an incorrect answer. See ticket [5981a8c041a3c2f3]. (Closed-Leaf check-in: 266e9cbada user: drh tags: seekscan-fix-20211102) | |
| 20:38 | • New ticket [5981a8c041] Incorrect answer on a SeekScan query. (artifact: 2d2d692312 user: drh) | |
| 17:55 | Ensure that ALTER TABLE RENAME recognizes OOM errors while parsing dependent triggers and handles them appropriately. dbsqlfuzz 53e245eee15d3f19639d773048aa955c30708785. (check-in: 1d9004cd01 user: drh tags: trunk) | |
| 14:01 | Fix a minor memory leak in the shell tool. Omit running fuzztest as part of the Device-One release test configuration, as it is now incompatible with SQLITE_OMIT_VIRTUALTABLE. (check-in: 4d70f27b7b user: dan tags: trunk) | |
| 11:24 | Add the --remove and --glob options to the .archive command in the CLI. (check-in: ea7b12cdf8 user: drh tags: trunk) | |
| 11:09 | Add #ifdef logic to os_unix.c so that it builds with SQLITE_OMIT_WAL defined. (check-in: 948c2cb2a2 user: dan tags: trunk) | |
| 10:54 | Fix a minor typo in a comment. (Closed-Leaf check-in: 06a5bf4348 user: drh tags: archive_remove) | |
| 10:47 | Add recent dbsqlfuzz cases to test/fuzzdata8.db. (check-in: 8c3f2536d2 user: drh tags: trunk) | |
| 07:32 | Fix a broken assert() in fts5 that could fail if the snippet() function were used with a query phrase containing 0 tokens on a detail=none or detail=col table. (check-in: 0a5b94b99c user: dan tags: trunk) | |
| 00:18 | Add globbing option to shell's .archive command. (check-in: 13fb74ac5e user: larrybr tags: archive_remove) | |
3 Years Ago (more context)
|
2020-11-02
| ||
| 00:40 | Fix an another OSS-Fuzz discovered assertion fault due to ALTER TABLE and strange triggers. (check-in: 6646d7898c user: drh tags: trunk) | |
4 Years Ago (more context)
|
2019-11-02
| ||
| 21:41 | • New ticket [623eff57e7] LEFT JOIN in view malfunctions with partial index on table. (artifact: 4a2769593b user: mrigger) | |
| 17:59 | Fix a problem in VIEW creation that was introduced by the generated columns feature. (check-in: 9c795c4d2b user: drh tags: trunk) | |
| 13:45 | "STORED" is not actually a keyword. The parser looks for STORED as an ordinary identifier. (check-in: 167cd574d6 user: drh tags: trunk) | |
| 13:33 | • Edit [17e9f65814264de9|17e9f65814]: Edit check-in comment. (artifact: 461928a455 user: drh) | |
| 13:33 | • Fixed ticket [a9efb42811]: Incorrect result for GLOB operator plus 6 other changes (artifact: 5ddca41605 user: drh) | |
| 13:32 | In sqlite3GenerateIndexKey(), do not attempt to reuse column values from the previous index if the current index is a partial index as the partial index test may have changed those values. Ticket [a9efb42811fa41ee] (check-in: 17e9f65814 user: drh tags: trunk) | |
| 08:22 | • New ticket [a9efb42811] Incorrect result for GLOB operator. (artifact: 003e557ef7 user: mrigger) | |
| 00:00 | Restore the on-line ".help" for the ".explain" command in the CLI. (check-in: 28b8f1036d user: drh tags: trunk) | |
5 Years Ago (more context)
|
2018-11-02
| ||
| 17:38 | Enhance triggers so that they can use table-valued-functions that exist in schemas outside of the schema in which the trigger is defined. (check-in: 1fa74930ab user: drh tags: trunk) | |
10 Years Ago (more context)
|
2013-11-02
| ||
| 22:29 | Improved Synopsis on register comparison operators. Fix a bug on the constraint check generator. (check-in: a7a18b65fa user: drh tags: omit-rowid) | |
| 22:09 | Many new test cases added, that mostly work. Currently 18 errors in without_rowid3.test. Also there is a hack marked by a /*FIXME*/ comment on at fkey.c:547 that needs fixing. (check-in: 39e32187b6 user: drh tags: omit-rowid) | |
| 19:34 | Change the "idx" name of the primary key index for WITHOUT ROWID tables in sqlite_statN statistics tables to be the name of the table rather than the fabricated index name (ex: sqlite_autoindex_xyz_1). This makes it consistent with sqlite_master table. (check-in: 4ee4d31063 user: drh tags: omit-rowid) | |
| 18:46 | Update the ANALYZE logic so that it works with WITHOUT ROWID tables. (check-in: 9075770e40 user: drh tags: omit-rowid) | |
| 14:37 | Store the root page of the PRIMARY KEY index for a WITHOUT ROWID table in the sqlite_master entry for the main table and omit the sqlite_master entry for the PRIMARY KEY. (check-in: b7544bb280 user: drh tags: omit-rowid) | |
| 11:43 | Import the sqlite3_analyzer fixes from trunk. (check-in: ac711459ff user: drh tags: omit-rowid) | |
| 11:34 | A pair of sqlite3_analyzer bug fixes: (1) quote strings in the SQL at the end of the output. (2) Fix test_stat.c so that it no longer misses some overflow pages on internal index pages. (check-in: 42a11e7464 user: drh tags: trunk) | |