This Day In History For 2025-07-03
1 Year Ago (more context)
|
2024-07-03
| ||
| 20:30 | When constructing an ephermeral table to use as the right-hand side of an IN operator, also construct a Bloom filter to speed membership testing. (Leaf check-in: 0bb306eb70 user: dan tags: bedrock-3.45-in-bloom) | |
| 20:19 | When constructing an ephermeral table to use as the right-hand side of an IN operator, also construct a Bloom filter to speed membership testing. (check-in: baa83b460c user: drh tags: trunk) | |
| 20:10 | Show the creation of IN-operator Bloom filters in the EXPLAIN QUERY PLAN output. (Closed-Leaf check-in: c10a1b99d4 user: drh tags: in-bloom) | |
| 18:56 | Add a new sqlite3FaultSim() call to OP_NotFound to use for testing purposes. (check-in: 84fd275bfd user: drh tags: in-bloom) | |
| 17:51 | Use a Bloom filter to improve performance of IN operators when the RHS of the IN operator is a subquery. (check-in: 1933496539 user: drh tags: in-bloom) | |
2 Years Ago (more context)
|
2023-07-03
| ||
| 18:32 | Enhance the sqlite3AtoF() function so that it can operate with or without long double and provides accurate results in both cases. (check-in: fd987508d5 user: drh tags: trunk) | |
| 18:18 | Enhance sqlite3AtoF() so that it honors the USELONGDOUBLE test-control. Enable the test/atof1.test module on non-intel platforms. (Closed-Leaf check-in: b7850fd480 user: drh tags: fp-to-decimal-refactor) | |
| 15:30 | Store the fp-speed-1.c test program used to measure relative performance of SQLite versus the standard library, in the test/ directory. A header comment explains how to use it. (check-in: eaff376277 user: drh tags: trunk) | |
| 15:11 | Add the --nolongdouble option to speedtest1.c. (check-in: 6bf6018a00 user: drh tags: trunk) | |
| 15:03 | Improved precision of binary-to-decimal conversion of floating-point values on all systems but especially non-x86 systems that lake extended precision hardward floating point. (check-in: 32befb224b user: drh tags: trunk) | |
| 14:56 | Whether or not to use the long-double floating point conversion technique is now a test-control setting. (check-in: 02ae6caff1 user: drh tags: fp-to-decimal-refactor) | |
| 12:58 | New test cases for floating-point conversions. (check-in: 9435ed76cd user: drh tags: fp-to-decimal-refactor) | |
| 11:44 | Use Dekker double-precision floating point to do the value normalization step in sqlite3FpDecode() for systems on which "long double" is 8 bytes or less. (check-in: 51f492b440 user: drh tags: fp-to-decimal-refactor) | |
| 11:39 | Final clean-up of the idea of using Dekker double-precision floating computations to improve accuracy. (Closed-Leaf check-in: 40285d6310 user: drh tags: fp-to-decimal-branch1) | |
| 10:35 | Squeeze as many bits as we can out of normalization. (check-in: 25d1ad6df1 user: drh tags: fp-to-decimal-branch1) | |
| 10:18 | Faster Dekker multiplication that removes the restriction on input magnitude. (check-in: 2994caf588 user: drh tags: fp-to-decimal-branch1) | |
| 10:00 | Fix one constant in the normalization logic. Improved error output from atof1.test. (check-in: d3c4880710 user: drh tags: fp-to-decimal-branch1) | |
| 09:07 | Replace the dodgy error estimating logic in the previous check-in with full-up Dekker double-double multiplication, and this idea works much better. There are still a few inaccuracies, but it is much closer. (check-in: 4fa6938dac user: drh tags: fp-to-decimal-branch1) | |
| 00:51 | The fptest(X) routine used for exploring another idea for improving fp-to-decimal conversion without the use of long double. (Leaf check-in: d9a883d7d8 user: drh tags: fp-to-decimal-branch2) | |
| 00:40 | An idea for improving accuracy of fp-to-decimal conversion for systems that do not have "long double". Does not quite work. Retained only for documentation purposes. (check-in: 7022433338 user: drh tags: fp-to-decimal-branch1) | |
3 Years Ago (more context)
|
2022-07-03
| ||
| 18:12 | Enhance the REGEXP extension so that the end-of-input indicate ("$") is allowed to occur on one branch of an OR ("|"). Forum post 0107d5d40dd273e2, second issue. (check-in: 3c04d21e6c user: drh tags: trunk) | |
| 14:32 | Fix the initial-prefix optimization for the REGEXP extension such that it works even if the prefix contains characters that require a 3-byte UTF8 encoding. This should fix the problem reported by forum post 96692f8ba5. (check-in: 7a32ccccef user: drh tags: branch-3.39) | |
| 14:25 | Fix the initial-prefix optimization for the REGEXP extension such that it works even if the prefix contains characters that require a 3-byte UTF8 encoding. This should fix the problem reported by forum post 96692f8ba5. (check-in: c94595a6e1 user: drh tags: trunk) | |
| 11:16 | Improved comment on sqlite3VdbeSwap(). No changes to code. (check-in: 6a8e4fb72a user: drh tags: trunk) | |
| 11:12 | Remove debugging code that has always been commented out. Cosmetic change. (check-in: b54064170c user: drh tags: trunk) | |
4 Years Ago (more context)
|
2021-07-03
| ||
| 19:20 | Create infrastructure for dynamic shell extension. (check-in: 5e7e0d4ef8 user: larrybr tags: cli_extension) | |
| 18:57 | Fix a (harmless) typo in a comment. No code changes. (check-in: d2b9b8daa3 user: drh tags: trunk) | |
| 02:55 | In the PRAGMA foreign_key_check, ensure that sufficient registers are allocated for the virtual machine, even if one or more foreign keys reuses the same column multiple times and has more columns than the table it is part of. Forum post a6b0c05277. (check-in: 68db1ff9c4 user: drh tags: trunk) | |
5 Years Ago (more context)
|
2020-07-03
| ||
| 21:24 | Fix the line-number of error messages coming out of the ".import" command when the --skip option is used. (check-in: e0a8b11dfd user: drh tags: trunk) | |
| 21:18 | Fix a compiler warning about an unused procedure in the parser. (check-in: b27bb4fe38 user: drh tags: trunk) | |
| 18:07 | Update the lemon documentation to match recent enhancements. (check-in: ca7630a577 user: drh tags: trunk) | |
| 17:24 | If the amalgamation is built using OPT_FEATURE_FLAGS = -DSQLITE_UDL_CAPABLE_PARSER then it can be compiled with or without the -DSQLITE_ENABLE_UPDATE_DELETE_LIMIT option and it works either way. (check-in: 1f96a29dd8 user: drh tags: trunk) | |
| 15:41 | In lemon, add "%if" and "%else" and allow boolean expressions as the argument to "%if", "%ifdef", and "%ifndef". (check-in: 951d22b72f user: drh tags: trunk) | |
| 12:32 | Fix the pragma_foreign_key_check virtual table so that it accepts arguments. (check-in: 07f849dee3 user: drh tags: trunk) | |
| 12:15 | Fix a problem with "PRAGMA foreign_key_check" where if a table in one schema appears to have foreign key constraints against another table in a different schema, the pragma will try to check the constraints even though they do not apply because they are in different schemas. (check-in: 81bc4b65ae user: drh tags: trunk) | |
10 Years Ago (more context)
|
2015-07-03
| ||
| 23:29 | Correction to check-in [1025873fdf], tighten up the number of static test mutexes. (check-in: 4e515897af user: mistachkin tags: trunk) | |
| 23:12 | Update clean target in MSVC makefile. (check-in: e6c03e7201 user: mistachkin tags: trunk) | |
| 23:11 | Enhance mutex testing to include APP and VFS static mutexes. (check-in: 1025873fdf user: mistachkin tags: trunk) | |
| 21:38 | Add static mutexes for use by the built-in / third-party VFSs and use the built-in VFS mutex where appropriate. (check-in: b202e2a1d7 user: mistachkin tags: trunk) | |
| 20:47 | Rework the Fts5MultiSegIter structure a bit to make it more efficient. (check-in: 0778825d0e user: dan tags: trunk) | |
| 19:13 | Speed up eof checks on fts5 cursors. (check-in: 3df4af5d8c user: dan tags: trunk) | |
| 17:54 | Enable use of the __builtin_bswap32() only with GCC 4.3 and higher. (check-in: 030f60a7ba user: mistachkin tags: trunk) | |
| 17:14 | Avoid freeing the array of instance matches each time the fts5 xNext() method is called. (check-in: b9b0c1e50d user: dan tags: trunk) | |
| 14:34 | New command-line options for speedtest1: --multithread, --nomemstat, --serialized, and --singlethread (check-in: 2b7567229e user: drh tags: trunk) | |
15 Years Ago (more context)
|
2010-07-03
| ||
| 19:08 | Do not run the memsubsys1.test script under the memsubsys1 permutation. (check-in: 3a1a8c77a5 user: dan tags: trunk) | |
| 17:13 | Remove the unused xRename() method from the sqlite3_vfs object. Add better documentation on the xCurrentTimeInt64() method. (check-in: 51ec0e5432 user: drh tags: trunk) | |
| 16:37 | Further changes to test scripts so that the "inmemory_journal" permutation works. (check-in: 50f2f7dfd6 user: dan tags: trunk) | |
| 15:47 | • Edit [48bf309391c32e78|48bf309391]: Edit check-in comment. Timestamp 2010-07-03 12:31:35. (artifact: 23434fad00 user: drh) | |
| 14:39 | • Edit [7cbe175a69738499|7cbe175a69]: Edit check-in comment. Timestamp 2010-07-03 12:26:33. (artifact: 7b4ab8775d user: drh) | |
| 14:19 | • Edit [708338773919fa02|7083387739]: Change branch background color to "#c0c0c0". Timestamp 2010-07-02 17:05:03. (artifact: 1030d2c62b user: drh) | |
| 13:59 | Fix a bug in the permutations.test script. (check-in: 3b20ad03be user: dan tags: trunk) | |
| 13:50 | Fix an assert in pager.c. And various test cases that fail with the in-memory journal permutation. (check-in: 622378dbe3 user: dan tags: trunk) | |
| 13:49 | • Edit [78fc35ff4b01d4a5|78fc35ff4b]: Mark "Closed". Timestamp 2010-07-03 13:45:53. (artifact: fe9e48c190 user: drh) | |
| 13:49 | • Edit [7cbe175a69738499|7cbe175a69]: Edit check-in comment. Timestamp 2010-07-03 12:26:33. (artifact: bf07509033 user: drh) | |
| 13:45 | Fix an assert in pager.c. And various test cases that fail with the in-memory journal permutation. (Closed-Leaf check-in: 78fc35ff4b user: dan tags: mistake) | |
| 12:31 | Cherry-pick the correct changes out of the recent "mistake" branch while omitting the bugs. (check-in: 48bf309391 user: drh tags: trunk) | |
| 12:29 | • Edit [708338773919fa02|7083387739]: Change branch background color to "#ffc0d0". Move to branch mistake. Timestamp 2010-07-02 17:05:03. (artifact: 554049e270 user: drh) | |
| 12:26 | Remove dead code from the pager. (check-in: 7cbe175a69 user: drh tags: mistake) | |
| 12:00 | Print the SQLite source_id() string when running speed tests. (check-in: 6d7640edcd user: drh tags: mistake) | |
| 10:00 | Fix an assert() in pager.c added by the previous commit. And various problems with test scripts in autovacuum and in-memory journal mode. (check-in: 62a1010177 user: dan tags: mistake) | |
| 08:01 | Do not attempt to open a WAL file for an in-memory or temporary database. Even if the database header suggests that it is a WAL database. (check-in: 0fd8092436 user: dan tags: mistake) | |
| 05:56 | Change code in OP_Rewind to avoid a valgrind warning following an error in the btree layer. This change does not fix any bug, just a warning. (check-in: 4f62dbcfc9 user: dan tags: mistake) | |
| 01:44 | Fix a buffer overrun in the where.c. Problem detected by valgrind. (check-in: 15bb623306 user: drh tags: mistake) | |