This Day In History For 2025-05-18
1 Year Ago (more context)
2024-05-18
| ||
20:00 | Fix the definition of sqlite3_vtab_distinct() such that return codes 2 and 3 mean that all rows must be distinct over "colUsed" which is a superset of "aOrderBy". Also, disallow return codes 2 and 3 if the rowid of the virtual table is accessed. (check-in: 922731ce98 user: drh tags: vtab-distinct-fix) | |
15:21 | JS error message and doc typos reported in the forum. No code changes. (check-in: 1a073f9acf user: stephan tags: trunk) | |
2 Years Ago (more context)
2023-05-18
| ||
23:42 | CLI resmanage use to 100% by commands, 84% by LOC. WIP (check-in: 48f81d8fc6 user: larrybr tags: cli_extension) | |
23:28 | Fix incorrect b-tree root page reports from the enhanced PRAGMA integrity_check output introduced in version 3.42.0. (check-in: 0a0b7a2d31 user: drh tags: branch-3.42) | |
23:25 | Fix incorrect b-tree root page reports from the enhanced PRAGMA integrity_check output introduced in version 3.42.0. (check-in: 9b538f6253 user: drh tags: trunk) | |
23:17 | • Edit [81b1bce719813cab|81b1bce719]: Move to branch mistake. Mark "Closed". Edit check-in comment. (artifact: ced1e8eebe user: drh) | |
23:16 | Incorrect fix. (Closed-Leaf check-in: 81b1bce719 user: drh tags: mistake) | |
3 Years Ago (more context)
2022-05-18
| ||
23:40 | #if out the '.load' command in WASM builds. Several UI layout tweaks. (check-in: 67d98297f0 user: stephan tags: fiddle) | |
22:58 | In wasm builds, ifdef out shell commands which require file I/O, pipes, or which trigger an exit() (.quit and .exit). Documented some of the quirks and limitations of the C/WASM crossover. Keep the JS code from calling into the C code after an exit() has been triggered. (check-in: bee436e62a user: stephan tags: fiddle) | |
21:18 | Improved handling/reporting of conditions which trigger an exit() from native code, e.g. calling the '.read' command. Added a Help button which simply submits the '.help' command. Added commented-out variants of various -Ox flags to simplify experimenting with them. (check-in: bf06ddf412 user: stephan tags: fiddle) | |
20:44 | Experimental code to provide a SIZE_HINT when writing the -wal file. (Leaf check-in: 3b29080dbf user: drh tags: wal-size-hint) | |
18:10 | Code style fixes: s/char const/const char/. (check-in: 9bf042b2eb user: stephan tags: fiddle) | |
17:40 | The fiddle input/output areas now stretch and shrink as needed to account for their available space. (check-in: 4eec05457f user: stephan tags: fiddle) | |
17:22 | Increased default size of the fiddle output area, changed the .nullvalue default in the input area, and minor CSS tweaks. (check-in: 281aaae731 user: stephan tags: fiddle) | |
17:14 | Initial version of an sqlfiddle-style application using a WASM build of the sqlite3 shell. (check-in: af9c21c9e0 user: stephan tags: fiddle) | |
4 Years Ago (more context)
2021-05-18
| ||
19:10 | In the MULTI-INDEX OR query plan, code for sub-expressions can sometimes be generated twice. But for some subqueries, generating code off of the same tree twice causes problems. So now MULTI-INDEX OR makes a copy of the sub-expressions it uses to avoid code-generating them more than once. dbsqlfuzz 9ebd2140e7206ff724e665f172faea28af801635. (check-in: 4a55f72542 user: drh tags: trunk) | |
12:36 | Improved comments on the generated opcodes.h file. (check-in: f2a17f1fad user: drh tags: trunk) | |
00:52 | Add a CORRUPT_DB term to an assert() added earlier today. (check-in: 304739d238 user: drh tags: trunk) | |
5 Years Ago (more context)
2020-05-18
| ||
19:55 | Merge latest trunk changes into this branch. (check-in: 5dc355ccf6 user: dan tags: begin-concurrent-pnu-wal2) | |
19:11 | Bring the reuse-schema branch up to date with the latest trunk changes. (check-in: d8ea0cb69d user: drh tags: reuse-schema) | |
18:46 | • Edit [507f972e91ffdc8d|507f972e91]: Edit check-in comment. (artifact: 917cfb735c user: drh) | |
18:15 | • Edit [9d068e1ef04e84c0|9d068e1ef0]: Edit check-in comment. (artifact: 92e5f44512 user: drh) | |
18:02 | Add vdbevtab.lo to build of libsqlite3.lib in Makefile.msc. (check-in: f64d054b79 user: dan tags: trunk) | |
17:18 | Merge latest trunk changes into this branch. (check-in: 16b1eca922 user: dan tags: wal2) | |
16:19 | Merge recent changes from trunk. (check-in: c69f030b1e user: drh tags: begin-concurrent-pnu) | |
15:41 | Merge latest trunk changes into this branch. (check-in: 9e4a7b3ed8 user: dan tags: begin-concurrent) | |
10 Years Ago (more context)
2015-05-18
| ||
20:34 | Improve test coverage of fts5_storage.c. (check-in: 4dfe2e5871 user: dan tags: fts5) | |
18:24 | Fix a bug in test script fts5fault4.test. (check-in: a508059305 user: dan tags: fts5) | |
18:03 | Add a test for an untested branch in fts5_expr.c. (check-in: ce08206b5c user: dan tags: fts5) | |
17:50 | Improve test coverage of fts5_config.c. (check-in: 47dbfadb99 user: dan tags: fts5) | |
12:28 | Transitive constraints should only work if operands have compatible affinities and collating sequences. (check-in: 5df4056448 user: drh tags: trunk) | |
12:18 | Use an ALWAY() on conditionals in the transitive constraint logic that are always true as far as we know. (Closed-Leaf check-in: 204e567f68 user: drh tags: transitive-constraints) | |
11:34 | Refinements to the determination of when an A==B term is an equivalence. Add test cases. (check-in: 6bfaf525ca user: drh tags: transitive-constraints) | |
04:24 | Make a hard copy of the results of a subquery lest the result of the subquery be referenced after a change to the table that generated the subquery result. (check-in: 9c0d80907b user: drh tags: trunk) | |
15 Years Ago (more context)
2010-05-18
| ||
23:29 | Update the wal-index hash format so that hash-table space is reused following a rollback, thus preventing hash table overflows. Add assert()s to verify that hash tables do not overfill. Further refactoring of the wal-index code. (check-in: ada9a8c7b6 user: drh tags: trunk) | |
18:01 | Refactoring of the WalIterator implementation. (check-in: b5b60fdcc5 user: drh tags: trunk) | |
13:27 | Mark the shared-memory in the WAL implementation as volatile. (check-in: 0a6787908e user: drh tags: trunk) | |
12:56 | Comment clarifications in wal.c. (check-in: a029be1017 user: drh tags: trunk) | |
12:37 | Keep additional state information in the pager in an effort to reduce the number of SQLITE_FCNTL_SIZE_HINTs. (Note: This change was found to make no performance difference and so has been moved onto a side branch. Use the parent check-in instead of this one.) (Closed-Leaf check-in: 97d88a86e4 user: drh tags: branch-3.6.1-exp) | |