This Day In History For 2025-06-14
1 Year Ago (more context)
|
2024-06-14
| ||
| 23:13 | Do not omit the ORDER BY clause from a recursive CTE just because the query that contains the CTE also contains an ORDER BY clause. Plus other changes imported from the recursive-cte-orderby-fix branch. (check-in: 13242289c5 user: drh tags: trunk) | |
| 20:42 | • Edit [0bcbde7c54f67451|0bcbde7c54]: Mark "Closed" with note "Dead-end experiment.". (artifact: 7e1009d9b7 user: stephan) | |
| 19:27 | Fix harmless comment typo. (check-in: ca06380233 user: drh tags: recursive-cte-orderby-fix) | |
| 18:33 | Improvement to treeview.c: Show the DESC and BIGNULL flags when printing out ExprList objects. (check-in: e87966cf63 user: drh tags: recursive-cte-orderby-fix) | |
| 18:06 | Add tests for the change on this branch. (check-in: ae19ff9ba8 user: dan tags: exists-to-join) | |
| 17:16 | Do not omit the ORDER BY clause from a recursive CTE just because the outer query that uses the CTE also contains an ORDER BY clause. (check-in: 5e700f2cc2 user: drh tags: recursive-cte-orderby-fix) | |
2 Years Ago (more context)
|
2023-06-14
| ||
| 13:45 | Add SQLITE_DBCONFIG_RANDOM_SCANORDER. This option causes unconstrained table and index scan to happen in a random order, in order to help detect under-constrained queries in applications. Closed because this feature does not add any new capabilities that are not already available with SQLITE_DBCONFIG_REVERSE_SCANORDER, but it does make the behavior non-deterministic, and hence more difficult to test. (Closed-Leaf check-in: 330219863c user: drh tags: random-scanorder) | |
| 12:19 | Work around what appears to be a GCC 32-bit optimization problem in the computeHMS() routine of the date/time logic. (check-in: aebdbcbebf user: drh tags: trunk) | |
3 Years Ago (more context)
|
2022-06-14
| ||
| 22:21 | Fix the OP_NullRow opcode so that it works even if it applied to an ephemeral cursor that has not yet been created. (check-in: 0e925654c2 user: drh tags: trunk) | |
| 21:34 | Add missing SQLITE_FCNTL_SIZE_HINT call to a path taken during transaction rollback. (check-in: 6c3266c1b4 user: dan tags: trunk) | |
| 19:12 | Attempt to enhance fuzzcheck to do some simple invariant testing on queries. This is an incremental check-in for a work-in-progress. (check-in: ce2d780163 user: drh tags: query-invariant-tests) | |
4 Years Ago (more context)
|
2021-06-14
| ||
| 20:49 | Fix typos in testcase() macros from check-in [c09d90eec2a49b94]. (check-in: d4d9869c30 user: drh tags: trunk) | |
| 20:41 | In the authorizer, use SQLITE_DROP_INDEX, not SQLITE_DROP_TEMP_INDEX when dropping an index in an attached database. (check-in: e5a5acd600 user: drh tags: trunk) | |
| 20:08 | Fix an ALTER TABLE problem with handling infinite loops of CTEs in the database schema. (check-in: c09d90eec2 user: dan tags: trunk) | |
| 14:52 | Fix a test script problem in corruptN.test. (check-in: 3ddfe9ae55 user: dan tags: trunk) | |
| 14:35 | Update this branch with latest changes from trunk. (check-in: f21a53fb41 user: dan tags: reuse-schema) | |
| 14:25 | Update this branch with latest changes from wal2. (check-in: 0ab899012c user: dan tags: begin-concurrent-pnu-wal2) | |
| 14:12 | Update this branch with latest changes from trunk. (check-in: b38c2b8bc4 user: dan tags: wal2) | |
| 14:01 | Update this branch with latest changes from begin-concurrent-pnu. (check-in: a485d1a1b8 user: dan tags: begin-concurrent-report) | |
| 14:00 | An index on the expression "likely(X)" should store the true value of X, even if X is a real number with no fractional part. The optimization of storing some REAL indexed values as INT (see [10d851353c2abead]) should be omitted for index columns that are expressions. Forum post 3b940c437a. (check-in: 791473bc66 user: drh tags: trunk) | |
| 13:49 | Update this branch with latest changes from trunk. (check-in: 74b42754d0 user: dan tags: begin-concurrent-pnu) | |
| 12:23 | Update this branch with latest trunk changes. (check-in: d81996340a user: dan tags: begin-concurrent) | |
| 11:20 | Avoid allocating oversized column names in the sqllimit1.test module. (check-in: 7068f1f69b user: drh tags: trunk) | |
5 Years Ago (more context)
|
2020-06-14
| ||
| 20:14 | • New ticket [8f157e8010] Heap Buffer Overflow in multiSelectOrderBy. (artifact: 5a6a79fc6c user: yongheng) | |
| 13:42 | • Fixed ticket [9fb26d37ce]: Assertion `flags3==pIn3->flags' failed. plus 6 other changes (artifact: ea0dfdf786 user: drh) | |
| 13:40 | Check-in [1d4f86201dab9a22] changed a testcase() to an assert() because we didn't know how to reach that condition any more. But YongHeng's fuzzer found a way. So now we change it back. Ticket [9fb26d37cefaba40]. (check-in: 90b1169d1b user: drh tags: trunk) | |
| 03:57 | • New ticket [9fb26d37ce] Assertion `flags3==pIn3->flags' failed.. (artifact: 5c0fa89b79 user: yongheng) | |
15 Years Ago (more context)
|
2010-06-14
| ||
| 18:06 | Fix an error in the walfault.test script introduced by the previous check-in. (check-in: a2b9374fc6 user: drh tags: trunk) | |
| 18:01 | Move the xShmMap method to in between xShmLock and xShmBarrier, since it seems to fit in there logically. (check-in: 58dfd83d8b user: drh tags: trunk) | |
| 17:09 | Merge the experimental shared-memory mmap-by-chunk changes into the trunk. (check-in: f295e7ed5f user: drh tags: trunk) | |
| 16:16 | Add the new xShmMap (formerly xShmPage) to os_win.c. (check-in: 13e7a82422 user: dan tags: experimental) | |
| 14:07 | Remove xShmGet/Size/Release from the sqlite3_vfs structure. Change the name of xShmPage to xShmMap. Remove some code that is now unused from os_unix.c and some of the test VFS implementations. (check-in: fc0cabc15c user: dan tags: experimental) | |
| 11:49 | Update some comments in wal.c. No code changes. (check-in: 1ce9c92bff user: dan tags: experimental) | |
| 11:18 | Change the interface to internal function walGetHash() to make it easier to follow. (check-in: 5e8e2e978e user: dan tags: experimental) | |
| 10:30 | Add the xShmPage method to the "crash" vfs in test6.c. (check-in: 1008f53644 user: dan tags: experimental) | |
| 07:53 | Add some fault-injection tests to improve coverage. (check-in: 37b26d125f user: dan tags: experimental) | |
20 Years Ago (more context)
|
2005-06-14
| ||
| 17:47 | Fix an NDEBUG versus SQLITE_DEBUG confusion issue. (CVS 2516) (check-in: 833c016023 user: drh tags: trunk) | |
| 16:04 | Provide the SQLITE_FILE_HEADER command-line option for changing the text that appears at the beginning of databases. (CVS 2515) (check-in: 3d7ee5b92d user: drh tags: trunk) | |
| 02:24 | Fix a bug in the default busy handler for systems that lack usleep(). Ticket #1284. (CVS 2514) (check-in: a42cb81d11 user: drh tags: trunk) | |
| 02:12 | Do not record existance the sqlite_sequence table until it is actually created. Ticket #1283. (CVS 2513) (check-in: 95256d953c user: drh tags: trunk) | |