This Day In History For 2025-07-01
2 Years Ago (more context)
2023-07-01
| ||
20:21 | This check-in adds the use of "long double" to sqlite3FpDecode() which when run on x86 using a compiler that translates "long double" into binary80, causes all legacy tests to pass. But on a system where "long double" is just an alias for "double", some of the tests are still failing. (check-in: ce06982f88 user: drh tags: fp-to-decimal-refactor) | |
18:33 | Reinstate the fpdecode() SQL function for testing, but only when compiled with SQLITE_DEBUG. (check-in: 07eab52e08 user: drh tags: fp-to-decimal-refactor) | |
17:56 | Improved rounding policy. (check-in: 6f1122e942 user: drh tags: fp-to-decimal-refactor) | |
15:23 | Improved response to Infinity and NaN. Remove the termporary fpdecode() function. (check-in: 76ab8ae809 user: drh tags: fp-to-decimal-refactor) | |
14:03 | Progress towards fixing corner-case floating-point formatting issues. (check-in: 1138b8d16e user: drh tags: fp-to-decimal-refactor) | |
3 Years Ago (more context)
2022-07-01
| ||
21:59 | • Edit [566b7842ee286ed8|566b7842ee]: Edit check-in comment. (artifact: 70db2cc897 user: drh) | |
21:03 | Do not attempt the OP_Count optimization on queries with HAVING clauses. This fixes a problem exposed by [2cf373b10c9bc4cb]. (check-in: 566b7842ee user: dan tags: trunk) | |
19:42 | Performance improvement in resolveP2Values(). Save over 1 million CPU cycles by omitting the loop termination condition and exiting when the OP_Init (always the first opcode in any VDBE program) is encountered. (check-in: bb179140c8 user: drh tags: trunk) | |
12:45 | • Edit [bf34eddb66fdb56f|bf34eddb66]: Move to branch mistake. Mark "Closed". Edit check-in comment. (artifact: deb8832de0 user: drh) | |
12:09 | In the sqlite_stmt virtual table, add two ALWAYS() macros on branches that have been come always true due to the [84a91c255e3d7772] optimization. REVISED: Dbsqlfuzz found a case where the ALWAYS() is false. (Closed-Leaf check-in: bf34eddb66 user: drh tags: mistake) | |
4 Years Ago (more context)
2021-07-01
| ||
18:26 | • Edit [d4097364c511709b|d4097364c5]: Edit check-in comment. (artifact: 7578befba7 user: drh) | |
18:19 | Allow unqualified "rowid" references to be used in join queries, provided that only one of the source objects has a rowid. Forum post ab5b077c32636e49 (check-in: d4097364c5 user: dan tags: trunk) | |
16:57 | Import the updated nmakehlp.c file used by the TCL Extension Architecture (TEA) builds in the amalgamation tarballs. Forum post 5a5001f20a. (check-in: 595bf95bf8 user: drh tags: trunk) | |
5 Years Ago (more context)
2020-07-01
| ||
16:19 | Ensure that the "PRAGMA schema_version" command causes the schema to be reparsed and reloaded. (check-in: 27d4a9a7b5 user: drh tags: trunk) | |
14:07 | Fix a problem with VM code generated for some aggregate SELECT statements that feature min()/max() aggregates both with and without FILTER clauses. (check-in: 2094da753f user: dan tags: trunk) | |
10 Years Ago (more context)
2015-07-01
| ||
19:59 | Avoid create a stack from in sqlite3BackupUpdate() in the common case where the first argument is NULL. (check-in: 2a897b9e94 user: drh tags: trunk) | |
17:54 | • Edit [1c52212369692ca7|1c52212369]: Mark "Closed". (artifact: 432da9c5b0 user: drh) | |
17:53 | Simplification of PRAGMA integrity_check logic. Make sure that the depth of the right-most subtree is correct. Size reduction and performance increase, with no change in output. (check-in: 550705fcb6 user: drh tags: trunk) | |
17:13 | Rework the PRAGMA integrity_check logic. Simplify the checkTreePage() routine and clean up the error messages generated. (Closed-Leaf check-in: 1c52212369 user: drh tags: integrity-check-refactor) | |
04:08 | Fix some harmless compiler warnings. (check-in: 307195c870 user: drh tags: trunk) | |
01:31 | Change integrity_check to analyze the cells of a page in reverse order, as this will tend to insert the cells into the analysis heap in increasing order by address, which is the most efficient way to load a min-heap. (check-in: 59ad912c4c user: drh tags: trunk) | |
15 Years Ago (more context)
2010-07-01
| ||
19:45 | If you delete a database file but not its *-wal file, then open the database (thus creating a new empty database file) the *-wal file is automatically deleted. (check-in: 95c69dfbdd user: drh tags: trunk) | |
19:01 | Add tests to pager1.test and pagerfault.test. (check-in: c6e7595092 user: dan tags: trunk) | |
15:09 | Add pager test cases. Change a condition in pager.c to NEVER(). (check-in: a8f6341d3b user: dan tags: trunk) | |
20 Years Ago (more context)
2005-07-01
| ||
11:38 | Fix typos in comments. No changes to code. (CVS 2535) (check-in: d3b03495a4 user: drh tags: trunk) | |