This Day In History For 2025-06-23
2 Years Ago (more context)
|
2023-06-23
| ||
| 11:10 | Add support for the octet_length() SQL function, with low-level optimizations that avoid loading large string content from disk when the argument to octet_length() is a table column. (check-in: fa5f77862c user: drh tags: trunk) | |
3 Years Ago (more context)
|
2022-06-23
| ||
| 22:43 | New test cases for query flattening with LEFT JOIN. (Closed-Leaf check-in: 27f68e4732 user: drh tags: flatten-left-join) | |
| 20:56 | Reintroduce flattener constraint (3c), but this time make it apply only if the outer query holds a GROUP BY, not if the outer query is an aggregate. (check-in: 641dfb9182 user: drh tags: flatten-left-join) | |
| 15:15 | Add back the ability to flatten a LEFT JOIN subquery - previously removed due to ticket [cad1ab4cb7b0fc344]. (check-in: f8fe936ad4 user: drh tags: flatten-left-join) | |
| 12:36 | Minor correction to a comment. No code changes. (check-in: 5fa00959eb user: drh tags: trunk) | |
4 Years Ago (more context)
|
2021-06-23
| ||
| 17:41 | Make conditional nature of sqlite3_normalized_sql() better known. (check-in: 0e0ece7111 user: larrybr tags: trunk) | |
| 16:07 | Fully incorporate *_changes64() API improvement. (check-in: 6699a2f6be user: larrybr tags: trunk) | |
| 11:39 | Show CROSS JOINs in the TreeView debuggingn output. (check-in: 72e09b6c9b user: drh tags: trunk) | |
| 11:12 | Fix a problem handling ORDER BY terms of the form "ORDER BY likely(<integer>)" within window frames. (check-in: 710f75b98b user: dan tags: trunk) | |
5 Years Ago (more context)
|
2020-06-23
| ||
| 20:03 | Enhance the --testset option on speedtest1 so that it can accept a comma-separated list of test modules to run in order. (check-in: 780e8aaa23 user: drh tags: trunk) | |
| 17:57 | Try to remove end-of-line whitespace when building the amalgamation. (check-in: be3e7814e4 user: drh tags: trunk) | |
| 15:29 | Fix a harmless compiler warning. (Closed-Leaf check-in: e1416c8b06 user: drh tags: decimal) | |
| 14:44 | Avoid unnecessary normalization in decimal_sum(). Trim excess trailing zeros off the result of decimal_mul(). (check-in: 0294ce071c user: drh tags: decimal) | |
10 Years Ago (more context)
|
2015-06-23
| ||
| 23:31 | Mark some branches as unreachable after the recent change that recognizes mismatch result set sizes on compound SELECT statements sooner. (check-in: c8d1f305b6 user: drh tags: trunk) | |
| 21:35 | Testability improvement. (Closed-Leaf check-in: eed6a33145 user: drh tags: btree-opt2) | |
| 18:47 | Improve test coverage of fts5. (check-in: df5ccea80e user: dan tags: fts5) | |
| 18:24 | Multiple overflow cells are always adjacent and sequential. Exploit this invariant for a small size reduction and performance increase and add assert()s to prove the invariant. (check-in: f77f2f48f4 user: drh tags: btree-opt2) | |
| 17:09 | Faster loading of cell pointers into the b.apCell array in balance_nonroot. (check-in: fda89b0512 user: drh tags: btree-opt2) | |
| 16:00 | Avoid unnecessary cachedCellSize() calls in the cell partition adjustment phase of balance_nonroot(). (check-in: 6319ee1256 user: drh tags: btree-opt2) | |
| 15:36 | Change pageInsertArray() and pageFreeArray() so that they use the CellArray object and compute cell sizes as needed, resulting in smaller and faster code. (check-in: f7f4181811 user: drh tags: btree-opt2) | |
| 15:06 | Merge latest trunk changes with this branch. Add tests for columnsize=0. (check-in: ef44c71a22 user: dan tags: fts5) | |
| 14:49 | Improvements to the way balance_nonroot() constructs the b.apCell array of pointers to cells. (check-in: ee44bb25b2 user: drh tags: btree-opt2) | |
| 13:02 | Merge the compound SELECT operator fix from trunk. (check-in: a7be554f4b user: drh tags: btree-opt2) | |
| 12:19 | Test that the left and right sides of a compound SELECT operator have the same number of expressions in the expanded expression list before beginning to generate code. (check-in: 4df852ce26 user: dan tags: trunk) | |
| 02:37 | Avoid computing cell sizes in balance_nonroot() until they are really needed. This gives an overall 1.7% performance gain for about 1000 extra bytes of code space. (check-in: 43844537e8 user: drh tags: btree-opt2) | |
15 Years Ago (more context)
|
2010-06-23
| ||
| 22:00 | Fix and/or improve comments in wal.c. No code changes. (check-in: ee9991be08 user: drh tags: trunk) | |
| 19:27 | Add test case for SQLITE_FULL errors to pagerfault.test. Remove a NEVER macro in pager.c that this hits. (check-in: 3e9680c4c1 user: dan tags: trunk) | |
| 17:59 | Include the SOURCE_ID value in the log messages output for corruption, misuse, and CANTOPEN errors. (check-in: 1727a81fed user: drh tags: trunk) | |
| 17:58 | Adjust the shared-memory locking range to account for the new version number values in the wal-index header. (check-in: a6dc0df304 user: drh tags: trunk) | |
| 15:55 | Add a version number to the wal-index header. If SQLite encounters a version number in either the wal or wal-index files that it does not understand, the operation is abandoned and SQLITE_CANTOPEN returned. (check-in: 8d0f8a7f70 user: dan tags: trunk) | |
| 15:18 | Fix the xCurrentTimeInt64 interface on windows. It was off by a factor of 10. (check-in: 51ef43b9f7 user: drh tags: trunk) | |
| 15:04 | Simplifications to the pager_delmaster() implementation. (check-in: 8bfbdec647 user: drh tags: trunk) | |
20 Years Ago (more context)
|
2005-06-23
| ||
| 03:15 | Make sure the String8 opcode always has a non-null P3 argument in the foreign_key_list pragma. Ticket #1297. (CVS 2525) (check-in: bcf62dc7a1 user: drh tags: trunk) | |
25 Years Ago (more context)
|
2000-06-23
| ||
| 19:16 | Begin writing the VDBE tutorial (CVS 107) (check-in: 79ce59cf79 user: drh tags: trunk) | |
| 17:02 | :-) (CVS 1699) (check-in: e970079cc1 user: drh tags: trunk) | |
| 17:02 | :-) (CVS 106) (check-in: d825931dea user: drh tags: trunk) | |