This Day In History For 2024-10-31
1 Year Ago (more context)
|
2023-10-31
| ||
| 17:40 | Fix harmless compiler warnings in test code. (check-in: d1895dd8f5 user: drh tags: trunk) | |
| 17:39 | Fix a problem with SQLITE_ENABLE_FTS5 builds of the non-amalgamation testfixture.exe in Makefile.msc. (check-in: 544091cc0f user: dan tags: trunk) | |
2 Years Ago (more context)
|
2022-10-31
| ||
| 18:11 | Make the UPDATE method of the sqlite_dbpage virtual table rebust against OOM errors. Forum post bbcf0dd6ca. Test case in TH3. (Leaf check-in: 852f2c9583 user: drh tags: branch-3.39) | |
| 18:04 | Extra OOM check in shell_error_context() of the CLI. forum post 5708841db0. (check-in: d6893183c2 user: drh tags: branch-3.39) | |
| 18:01 | Make the UPDATE method of the sqlite_dbpage virtual table rebust against OOM errors. Forum post bbcf0dd6ca. Test case in TH3. (check-in: d15c9a4a32 user: drh tags: trunk) | |
| 13:50 | Worker1: use a list, rather than a single slot, to manage the default db link so that we can keep the least-recently-opened db as the default. Re-introduce worker1.export() but do not yet expose it until an equivalent import() (or open() option) is implemented. (check-in: c7750c101d user: stephan tags: trunk) | |
| 13:24 | • New ticket [57c47526c3] Incorrect answer when flattening a UNION ALL compound. (artifact: 8ff47cd8d2 user: drh) | |
| 11:53 | Internal tweaks to the OPFS VFS result codes. (check-in: 32e1a2d2eb user: stephan tags: trunk) | |
| 11:41 | • Edit [646fe2ce871d583f|646fe2ce87]: Mark "Closed". Edit check-in comment. (artifact: 9bcbab0c85 user: stephan) | |
| 11:09 | Add oo1.DB.exec() 'returnValue' option, which specifies what exec() should return. Defaults to the db object and enables direct return of the result rows array or a list of the individual SQL statements. Other code-adjacent internal cleanups. (check-in: 69d36a6aa5 user: stephan tags: trunk) | |
| 10:53 | Avoid a segfault that could occur when running the recover API on a database handle with memory-mapping enabled. (check-in: e02c697281 user: dan tags: trunk) | |
| 01:22 | Extra OOM check in shell_error_context() of the CLI. forum post 5708841db0. (check-in: cb12ac5de1 user: drh tags: trunk) | |
4 Years Ago (more context)
|
2020-10-31
| ||
| 18:58 | Add the -tabs command-line option to the CLI. (check-in: 7d01e84dc4 user: drh tags: trunk) | |
| 16:33 | Update the ALTER TABLE command to correctly handle UPDATE ... FROM statements within trigger programs. (check-in: 3e6af89040 user: dan tags: trunk) | |
5 Years Ago (more context)
|
2019-10-31
| ||
| 20:58 | • Ticket [b9befa4b83] Segfault in table with generated column and foreign key status still Fixed with 3 other changes (artifact: 59afd142ac user: drh) | |
| 20:54 | • Fixed ticket [b9befa4b83]. (artifact: af534faa92 user: drh) | |
| 20:54 | Correctly generate pre-UPDATE content for virtual columns that are used by foreign key constraints. Ticket [b9befa4b83a660cc] (check-in: 40d3282ec2 user: drh tags: trunk) | |
| 20:02 | • New ticket [b9befa4b83] Segfault in table with generated column and foreign key. (artifact: 99d2ef1d78 user: mrigger) | |
| 17:13 | Add a few simple TCL test cases for generated columns. (Full test coverage of the generated column logic is provided separately by TH3.) (check-in: acedb5c7f7 user: drh tags: trunk) | |
| 13:16 | • Fixed ticket [1d2a8efc6c]: VACUUM on table with generated column that uses TYPEOF results in an error plus 6 other changes (artifact: 6088e62985 user: drh) | |
| 13:16 | Ignore differences in Expr.op2 in sqlite3ExprCompare() in cases where it does not matter. Ticket [1d2a8efc6c3a595a]. (check-in: 329820673a user: drh tags: trunk) | |
| 12:30 | Enhance the TreeView logic to show information about Expr.op2 for FUNCTION and COLUMN nodes. (check-in: aceeaf9e28 user: drh tags: trunk) | |
| 09:42 | • New ticket [1d2a8efc6c] VACUUM on table with generated column that uses TYPEOF results in an error. (artifact: c4ece77a79 user: mrigger) | |
10 Years Ago (more context)
|
2014-10-31
| ||
| 20:11 | Add the experimental sqlite3_stmt_scanstatus() API. (check-in: 6a9bab34ae user: dan tags: scanstatus) | |
| 15:20 | Merge all recent trunk enhancements into the apple-osx branch. (check-in: fef8430f12 user: drh tags: apple-osx) | |
| 14:53 | Merge recent trunk enhancements, and in particular the improvements to the b-tree balancing logic, into the sessions branch. (check-in: 28b044a512 user: drh tags: sessions) | |
| 14:46 | Change the command-line shell man-page to use the ".tr" troff directive instead of ".cc" for escaping the initial "." characters in the ".help" output. (check-in: 67f0d469da user: drh tags: trunk) | |
| 14:26 | Simplify the logic in the cell redistribution loop of balance_nonroot(). Enhance and clarify comments and add assert() statements for additional verification of correctness. (check-in: a07078b600 user: drh tags: trunk) | |
| 12:22 | Simplify the math slightly, and reduce by one the number of loop iterations, for the loop in balance_nonroot() that moves cells between pages. (check-in: 2e838db82e user: drh tags: trunk) | |
| 10:31 | Add the "varint.c" utility program in the tool directory. (check-in: ea5d56be5f user: drh tags: trunk) | |
| 02:51 | Remove an unnecessary branch from balance_nonroot(). (check-in: 9fc7c88e3f user: drh tags: trunk) | |
| 00:05 | In the balance_nonroot() routine, protect the values in aPgno[] array from change during the page sort, so that aPgno[] can be used to avoid unnecessary pointer-map updates for auto_vacuum databases. (check-in: 69c3924fe8 user: drh tags: trunk) | |
20 Years Ago (more context)
|
2004-10-31
| ||
| 16:25 | Add code to create/update the btree 'pointer-map' for auto-vacuum mode. (CVS 2035) (check-in: bebd967f36 user: danielk1977 tags: trunk) | |
| 02:22 | Insert #ifdefs that can optionally remove features at compiletime resulting in a database engine with a smaller footprint. (CVS 2034) (check-in: be661acfa8 user: drh tags: trunk) | |