This Day In History For 2025-08-20
1 Year Ago (more context)
|
2024-08-20
| ||
| 23:11 | Refactor the SrcItem object to move fields associated with subqueries out into a separate object named Subquery. This reduces the size of the SrcItem object by about 1/3rd and provides improved performance. (check-in: 484bcd75bc user: drh tags: trunk) | |
| 22:44 | Fix a name resolution issue with CTEs. (Leaf check-in: 4fa8235dd5 user: drh tags: srcitem-opt) | |
| 22:05 | Fix minor comment issues. (check-in: c1bbed19f4 user: drh tags: srcitem-opt) | |
| 20:01 | Remove unreachable code. (check-in: 17699329aa user: drh tags: srcitem-opt) | |
| 19:09 | Tighter checking of access constraints on union members in SrcItem. Improved invariant checking. (check-in: fd72d3400a user: drh tags: srcitem-opt) | |
| 17:41 | Fix some stray SrcItem field name fixes. (check-in: bc5f5ce59e user: drh tags: srcitem-opt) | |
| 17:24 | Fix a memory leak so that now all dev tests (including TH3) are passing. (check-in: 3995c45fff user: drh tags: srcitem-opt) | |
| 16:50 | Memory issues fixes so that mdevtest now passes. (check-in: b249516f6a user: drh tags: srcitem-opt) | |
| 14:16 | When the database encoding is UTF-16LE and the GLOB optimization is used, it is ok to use the range search over an index, but it is not ok to disable the actual GLOB function call. (check-in: db917d50fd user: drh tags: branch-3.46) | |
| 14:12 | When the database encoding is UTF-16LE and the GLOB optimization is used, it is ok to use the range search over an index, but it is not ok to disable the actual GLOB function call. (check-in: 3399698376 user: drh tags: trunk) | |
| 12:15 | The LIKE/GLOB optimization restricts its attention to the pattern prefix that is all ASCII. (check-in: 5815f13263 user: drh tags: branch-3.46) | |
| 12:09 | Fix for the UTF-16LE problem reporte by forum post dc7e1b7527e84343. Because of the unexpected ordering of characters using the default collation (memcmp() order) in UTF-16LE, the LIKE/GLOB optimization restricts its attention to the pattern prefix that is all ASCII, which is the common case. (check-in: a5797ebdea user: drh tags: trunk) | |
3 Years Ago (more context)
|
2022-08-20
| ||
| 19:45 | Merge the test case for dbsqlfuzz 18fe4e257be7fa3ecfb0424ab7427e41e97ef9e3 assertion fault, which is fixed with the previous check-in. (check-in: 2d13ec086e user: drh tags: trunk) | |
| 19:33 | Enhance the enforcement of SQLITE_VTAB_DIRECTONLY so that it applies to DML statements within triggers. Do not allow DML stratements against virtual tables within triggers unless either the virtual table is SQLITE_VTAB_INNOCUOUS or PRAGMA trusted_schema is ON. (check-in: 9433ea4070 user: drh tags: trunk) | |
4 Years Ago (more context)
|
2021-08-20
| ||
| 19:51 | Improvement to error handling in Lemon. No impact on SQLite. Forum post 2f468f43cbc48d7f (check-in: 18cc2f8574 user: drh tags: trunk) | |
| 18:18 | Use VVA_ONLY() instead of TESTONLY() in SEH macros so that the build works for coverage testing. (check-in: 9e9d5b566d user: drh tags: wal-shm-exceptions) | |
| 17:23 | Add missing SEH_INJECT_FAULT macros. (check-in: 27e9bdb3a9 user: dan tags: wal-shm-exceptions) | |
| 16:19 | Add some assert() statements and fix small issues with code on this branch. (check-in: bd9b373b17 user: dan tags: wal-shm-exceptions) | |
| 15:44 | Support for STRICT tables. A table with the STRICT option only allows a few core datatypes on columns and enforces those types rigidly. Also, PRIMARY KEY columns must be NOT NULL. (check-in: f9c1d3441b user: drh tags: trunk) | |
| 11:50 | Fix a problem on this branch causing checkpoints that do not proceed because they can't get the CHECKPOINT lock to return incorrect output values. (check-in: 5a98820c3d user: dan tags: wal-shm-exceptions) | |
| 08:05 | Improved error messages for the SQLITE_CONSTRAINT_DATATYPE error. (Closed-Leaf check-in: 39abca0147 user: drh tags: strict-tables) | |
| 01:12 | Do not allow the xfer-optimization to move the content of an ordinary table into a strict table. (check-in: 1ed1b594d3 user: drh tags: strict-tables) | |
5 Years Ago (more context)
|
2020-08-20
| ||
| 16:25 | Fix a crash that could occur in SQLITE_MAX_EXPR_DEPTH=0 builds when processing SQL containing syntax errors. (check-in: 5f58dd3a19 user: dan tags: trunk) | |
| 11:03 | Avoid a buffer overrun in test code that could occur if certain test functions were passed a hex-string containing an odd number of digits. (check-in: 3c5e63c22f user: dan tags: trunk) | |
10 Years Ago (more context)
|
2015-08-20
| ||
| 23:54 | Merge recent trunk enhancements, include table-valued functions. (check-in: e9196d5666 user: drh tags: sessions) | |
| 23:45 | Merge recent enhancements from trunk, including table-valued expressions. (check-in: b9927c876c user: drh tags: cursor-hints) | |
| 23:39 | Merge the latest changes from trunk, including the table-valued function implementation. (check-in: 10c444322f user: drh tags: json) | |
| 23:33 | Compiler-warning fixes in the sqldiff.exe utility. (check-in: 64d13339d4 user: drh tags: trunk) | |
| 23:28 | Fix a couple C99-isms that cause compile errors on MSVC. (check-in: bc577fe6cb user: drh tags: trunk) | |
| 23:21 | Fix corner-case memory management issues in table-valued functions. Change virtual table handling so that if xDestroy is missing the table is eponymous only even if xCreate is present. (check-in: 774e6a14b1 user: drh tags: trunk) | |
| 21:14 | Skip calling the virtual table xDestroy method when it is null. (check-in: b73ad305a6 user: mistachkin tags: trunk) | |
| 21:09 | Fix compiler warnings in the sqldiff tool seen with MSVC. (Closed-Leaf check-in: 072279d458 user: mistachkin tags: msvcWarn) | |
| 20:25 | Fix a problem causing corruption when an UNLOCKED transaction is rolled back. (check-in: 7c36147846 user: dan tags: begin-concurrent) | |
| 20:21 | Fix stray variable declaration for C89. (check-in: 17eb7f18cb user: mistachkin tags: trunk) | |
| 20:13 | Correctly handle empty function argument lists on table-valued functions. (check-in: a7acc7878b user: drh tags: trunk) | |
| 19:55 | Add support for table-valued functions in the FROM clause implemented as virtual tables. (check-in: 9b718b06b1 user: drh tags: trunk) | |
| 18:28 | Prevent the series.c extension from loading on older versions of SQLite that do not support xCreate==NULL. (Closed-Leaf check-in: 3efc79427e user: drh tags: table-valued-functions) | |
| 17:18 | Make SQLITE_BUSY_SNAPSHOT and SQLITE_BUSY_RECOVERY retryable, just as a plain SQLITE_BUSY is. (check-in: fd13dd950d user: drh tags: trunk) | |
| 16:16 | Fix a typo in series.c. (check-in: 23db7f50f1 user: dan tags: table-valued-functions) | |
15 Years Ago (more context)
|
2010-08-20
| ||
| 15:32 | Do not allow a backup to change the page size if a codec is in use. (check-in: 5523ecd322 user: drh tags: trunk) | |
| 12:43 | Fix typo in backcompat.test. (check-in: 6a0cbb272c user: dan tags: trunk) | |
| 12:34 | Merge leaf created by accident. (check-in: 1f680cb375 user: dan tags: trunk) | |
| 12:31 | Avoid assuming that the user has "." in their path when running multi-process tests. (check-in: daa5d461b9 user: dan tags: trunk) | |
| 10:28 | Do not attempt run backwards compatibility tests if no historical "testfixture" binaries are available. (check-in: 40e11aabc7 user: drh tags: trunk) | |
| 09:53 | Disable the MEMSYS2 auxiliary routines if MEMSYS2 is changed to an alternative memory allocator using SQLITE_CONFIG_MALLOC. (check-in: 541dd3b870 user: drh tags: trunk) | |
| 09:14 | Fix the sqlite3_release_memory() interface so that it does not attempt to free SQLITE_CONFIG_PAGECACHE memory. (check-in: 0426cd62d5 user: drh tags: trunk) | |
20 Years Ago (more context)
|
2005-08-20
| ||
| 13:47 | More test coverage improvements. (CVS 2605) (check-in: e559e810a5 user: drh tags: trunk) | |
| 03:03 | Increased test coverage. Some malloc tests now fail though this is believed to be an instrumentation problem not a real error. (CVS 2604) (check-in: f786f37a5e user: drh tags: trunk) | |
25 Years Ago (more context)
|
2000-08-20
| ||
| 11:42 | bug fix in lemon (CVS 136) (check-in: 6f4c080739 user: drh tags: trunk) | |