Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
100 most recent check-ins that include changes to files matching 'test/*'
|
2025-07-02
| ||
| 20:46 | Merge in the exists-to-join optimization that has been modified to relax the requirement of having an indexed join constraint. (check-in: 1c1aef2b7f user: drh tags: empty-table-optimizations) | |
| 07:52 | Add test1.c tcl bindings for sqlite3_column_text/blob_v2(). Replace, essentially randomly, some of the v1 API calls in capi2.test and capi2.test with the v2 calls to ensure identical results. Add a couple new tests comparing results between v1 and v2. (check-in: a3ca0adbaf user: stephan tags: column-text-blob-v2) | |
|
2025-07-01
| ||
| 15:13 | Merge trunk fixes into the empty-table-optimizations branch. (Closed-Leaf check-in: 63306e447e user: drh tags: empty-table-optimizations) | |
| 12:49 | When attempting to optimize "expr AND false" to "false" and "expr IN ()" to "false", take care not to delete aggregate functions in the "expr" as doing so can change the meaning of the query. (check-in: 355c7902de user: drh tags: branch-3.50) | |
| 12:43 | When attempting to optimize "expr AND false" to "false" and "expr IN ()" to "false", take care not to delete aggregate functions in the "expr" as doing so can change the meaning of the query. See forum thread f4878de3e7. (check-in: 77397bd67d user: drh tags: trunk) | |
|
2025-06-28
| ||
| 14:36 | Merge all the latest trunk fixes and enhancements into the reuse-schema branch. (Leaf check-in: 6e1f97d99b user: drh tags: reuse-schema) | |
| 14:35 | Merge the 3.50.2 changes into the reuse-schema-3.50 branch. (Leaf check-in: b66f853a24 user: drh tags: reuse-schema-3.50) | |
| 14:30 | Merge the latest trunk fixes and enhancements into the bedrock branch. (Leaf check-in: a6f6fbe617 user: drh tags: bedrock) | |
| 14:24 | Merge the latest trunk enhancements into the wal2 branch. (Leaf check-in: e7867c3992 user: drh tags: wal2) | |
| 14:16 | Merge the latest trunk enhancements into the begin-concurrent branch. (Leaf check-in: 1ae8d60237 user: drh tags: begin-concurrent) | |
|
2025-06-24
| ||
| 18:27 | Similar fix to the previous check-in, but this time for sqlite3_preupdate_new(). (check-in: 9aaff764d5 user: drh tags: trunk) | |
| 15:58 | Range check the column index on the sqlite3_preupdate_old() interface and return SQLITE_MISUSE if too large. Forum post b617e49728. (check-in: 6a5701e6c7 user: drh tags: trunk) | |
|
2025-06-18
| ||
| 19:04 | Extend the pedantic enforcement of type in STRICT tables to cover VIRTUAL columns. (check-in: b734c74e55 user: drh tags: trunk) | |
| 16:17 | Enforce judgmental typing on STORED generated columns for STRICT tables. Forum post 6caf195248. (check-in: 5e9279bff0 user: drh tags: trunk) | |
|
2025-06-17
| ||
| 19:32 | Avoid writing frames with no checksums into the wal file if a savepoint is rolled back after dirty pages have already been spilled into the wal file. Also fix a corner case in the previous check-in on this branch. (check-in: c232fa2bfc user: drh tags: branch-3.50) | |
| 19:10 | Avoid writing frames with no checksums into the wal file if a savepoint is rolled back after dirty pages have already been spilled into the wal file. (check-in: 5973f9b9aa user: drh tags: trunk) | |
| 18:17 | Update walcksum.test so that it works with SQLITE_DEFAULT_AUTOVACUUM=1 builds. (Closed-Leaf check-in: 0da16f6c62 user: dan tags: forum-b490f726db-fix) | |
| 11:36 | Avoid writing frames with no checksums into the wal file if a savepoint is rolled back after dirty pages have already been spilled into the wal file. Possible fix for forum post b490f726db. (check-in: 3a3269fe8e user: dan tags: forum-b490f726db-fix) | |
|
2025-06-16
| ||
| 18:04 | Fix an issue going back to version 3.39.0 with transitive IS constraints in queries that make use of RIGHT JOIN. (check-in: 6c5f4c8af9 user: drh tags: branch-3.50) | |
| 17:36 | Fix an issue going back to version 3.39.0 with transitive IS constraints in queries that make use of RIGHT JOIN. Problem reported by forum post 68f29a2005. (check-in: 9441fff52c user: drh tags: trunk) | |
|
2025-06-13
| ||
| 11:08 | Further improvements to the EQP text for flex-search. (check-in: 40a83da503 user: drh tags: flex-search) | |
| 00:50 | Change the flex-search EQP message to be "SEARCH ... OR SCAN" as this seems less disruptive and more readable. (check-in: 680e278c3e user: drh tags: flex-search) | |
|
2025-06-12
| ||
| 19:02 | Preliminary code generation for flex-search. Add a no-op IfUseIndex opcode as a placeholder. (check-in: 521948c64f user: drh tags: flex-search) | |
| 13:40 | Merge latest trunk enhancements and fixes into the experimental flex-search branch. (check-in: 51c89c886f user: drh tags: flex-search) | |
| 13:27 | Have sqlite3_setlk_timeout() take the database handle mutex. This fixes an assert() failure that could occur if sqlite3_setlk_timeout() were called on a threadsafe handle. (check-in: 954efdd30d user: drh tags: branch-3.50) | |
| 07:35 | Have sqlite3_setlk_timeout() take the database handle mutex. This fixes an assert() failure that could occur if sqlite3_setlk_timeout() were called on a threadsafe handle. (check-in: a95d126e13 user: dan tags: trunk) | |
|
2025-06-11
| ||
| 00:05 | Fix the concat_ws() SQL function so that it includes empty strings in the concatenation. (check-in: e0ce6dab46 user: drh tags: branch-3.50) | |
| 00:01 | Fix the concat_ws() SQL function so that it includes empty strings in the concatenation. Forum post 52503ac21d. (check-in: 80a78987da user: drh tags: trunk) | |
|
2025-06-06
| ||
| 15:43 | Update the reuse-schema branch to the 3.50.1 patch release. (check-in: b5463d7560 user: drh tags: reuse-schema-3.50) | |
|
2025-06-05
| ||
| 11:57 | Fixes to ensure SQLITE_ENABLE_SETLK_TIMEOUT builds use a blocking lock and do not call xSleep() when (a) opening a snapshot transaction, and (b) when blocked by another process running recovery. (check-in: 8ac4525a2e user: drh tags: branch-3.50) | |
|
2025-06-03
| ||
| 17:46 | Relax query flattener constraint (3b) and thereby allow flattening the RHS of a LEFT JOIN even if the RHS contains a virtual table. This is a performance optimization that would not normally be found on a patch branch, but downstream needs it and does not want to wait on the next full release. (check-in: 916dde1f40 user: drh tags: branch-3.50) | |
| 14:19 | Merge latest changes from the wal2 branch into this branch. (check-in: 93740658c8 user: dan tags: bedrock) | |
| 14:15 | Merge latest trunk changes into this branch. (check-in: d685bc8ce3 user: dan tags: wal2) | |
|
2025-06-02
| ||
| 18:48 | Fixes to ensure SQLITE_ENABLE_SETLK_TIMEOUT builds use a blocking lock and do not call xSleep() when (a) opening a snapshot transaction, and (b) when blocked by another process running recovery. (check-in: 7f9c0cdd06 user: dan tags: trunk) | |
| 18:42 | Improve the accuracy of affinity and collating sequence analysis for NATURAL JOINs to the left of RIGHT JOINs where source tables are views or subqueries. (check-in: d6a8b1ea5c user: drh tags: branch-3.50) | |
| 18:37 | Fix os_win.c so that SQLITE_ENABLE_SETLK_TIMEOUT=2 builds work on windows. (Closed-Leaf check-in: 8efb95e0d4 user: dan tags: setlk-snapshot-fix) | |
| 18:34 | Improve the accuracy of affinity and collating sequence analysis for NATURAL JOINs to the left of RIGHT JOINs where source tables are views or subqueries. Initial problem report in forum post 829306db47. (check-in: f184d1d236 user: drh tags: trunk) | |
| 18:09 | Updates to new test cases to run with SQLITE_ENABLE_SETLK_TIMEOUT=2 builds. (check-in: c6d3e3542f user: dan tags: setlk-snapshot-fix) | |
| 17:44 | Merge trunk changes into this branch. (check-in: 7d27451804 user: dan tags: setlk-snapshot-fix) | |
|
2025-06-01
| ||
| 16:10 | Fix VACUUM so that it works even when ATTACH_WRITE is disabled. (check-in: 42494f85ac user: drh tags: trunk) | |
|
2025-05-31
| ||
| 20:51 | Enhance "box" and "column" mode formatting in the CLI to better deal with double-wide characters. (check-in: b0de22ed0a user: drh tags: trunk) | |
| 19:55 | Update a few test scripts so that they run on windows. (check-in: 14a18f4e3a user: dan tags: setlk-snapshot-fix) | |
| 18:46 | Cherrypick obscure (fuzzer-generated) RIGHT JOIN bug fixes from trunk. (check-in: a61da8169b user: drh tags: branch-3.50) | |
| 18:16 | Fix an affinity problem caused by a USING or NATURAL JOIN on the LHS of a FULL JOIN. Forum post 5028c785b6. (check-in: 8d393ca07f user: dan tags: trunk) | |
| 16:17 | Relax query flattener constraint (3b) and thereby allow flattening the RHS of a LEFT JOIN even if the RHS contains a virtual table. This was previously disallowed by [9dbae1df75219e2a] as a performance optimization. It turns out that the constraint causes performance issues, and we do not have a record of any performance issue that it solves. (check-in: 1ddaa92057 user: drh tags: trunk) | |
| 15:10 | Fix assert() statements in os_unix.c and os_win.c. Allow walsetlk_recover.test to run in non-SQLITE_ENABLE_SNAPSHOT builds. (check-in: 9f521ecda2 user: dan tags: setlk-snapshot-fix) | |
| 11:02 | tcl extension: UDFs may now 'break' to return an SQL NULL. Add the (eval -asdict) flag to use a dict, instead of an array, for the eval row data. (check-in: 413a626b5c user: stephan tags: trunk) | |
|
2025-05-30
| ||
| 22:58 | Follow-up to the previous: The same optimization suppression needs to happen if the left-hand side is coming from a LEFT JOIN. (check-in: cf5b37b3a3 user: drh tags: trunk) | |
| 20:52 | If blocking locks are enabled, avoid using the busy handler when blocked by another process running recovery. (check-in: a35236757a user: dan tags: setlk-snapshot-fix) | |
| 19:55 | When synthesizing an ON constraint from a USING or NATURAL, if the left-hand side is coming from a RIGHT JOIN, be sure to set the EP_CanBeNull flag so that the optimizer knows to check for NULL even if the column has a NOT NULL constraint. Fix for the problem reported by forum post 4fc70203b61 (check-in: 60adc78a22 user: drh tags: trunk) | |
| 18:23 | Avoid invoking the busy-handler if a blocking lock times out while attempting to open a snapshot transaction. (check-in: fe11f85fd3 user: dan tags: setlk-snapshot-fix) | |
| 16:22 | Merge trunk into tcl-cw branch. (Leaf check-in: 6747183c90 user: stephan tags: tcl-cw) | |
| 11:00 | Extend the fix for ticket 623eff57e76d45f6]so that it covers RIGHT JOIN in addition to LEFT JOIN. (check-in: cbd9aabaa5 user: drh tags: branch-3.50) | |
|
2025-05-29
| ||
| 18:44 | Extend the fix for ticket [623eff57e76d45f6] so that it covers RIGHT JOIN in addition to LEFT JOIN. Problem reported by forum post 2025-05-29T15:10:14Z. (check-in: 29b1e1b976 user: drh tags: trunk) | |
| 14:59 | Update the reuse-schema branch to version 3.50.0 (check-in: 4b1a38ff6b user: drh tags: reuse-schema) | |
| 14:59 | Update the bedrock branch to version 3.50.0 (check-in: 54b8888080 user: drh tags: bedrock) | |
| 14:47 | Bring the wal2 branch to to version 3.50.0. (check-in: 9f9f81ca9c user: drh tags: wal2) | |
| 14:40 | Bring the begin-concurrent branch up to version 3.50.0. (check-in: 436609fdb1 user: drh tags: begin-concurrent) | |
|
2025-05-26
| ||
| 17:29 | Fix a bug in the speedtest.tcl testing script that was introduced by [7e9845433ff26bdc] (check-in: e4ffa86aa6 user: drh tags: trunk) | |
| 16:17 | On OpenBSD, do not test fuzzcheck with ubsan as part of "make devtest". (check-in: a3dabd599c user: dan tags: trunk) | |
|
2025-05-24
| ||
| 20:20 | Change json_group_object() so that it ignores entries where the label is NULL. Forum post e5bd251fb5. (check-in: 28215d131c user: drh tags: trunk) | |
|
2025-05-23
| ||
| 14:52 | Add the --osmalloc option to the test/speedtest.tcl testing script. Adjust ./configure so that it does not check for malloc_usable_size(). (check-in: 7e9845433f user: drh tags: trunk) | |
|
2025-05-19
| ||
| 17:06 | Merge the latest trunk changes into the reuse-schema branch. (check-in: fc5edd557e user: drh tags: reuse-schema) | |
| 16:58 | Merge the latest trunk enhancements into the bedrock branch through the wal2 intermediary. (check-in: e7d6e993df user: drh tags: bedrock) | |
| 16:52 | Merge recent trunk changes into the wal2 branch. (check-in: 720d175478 user: drh tags: wal2) | |
| 16:45 | Merge the latest trunk changes into the begin-concurrent branch. (check-in: 9fec43d927 user: drh tags: begin-concurrent) | |
|
2025-05-17
| ||
| 17:15 | Merge trunk into this branch. (check-in: 58dd6d94e5 user: stephan tags: tcl-cw) | |
|
2025-05-13
| ||
| 18:58 | Adjust the strftime() test in test/date4.test to remove flags not supported in musl libc if that environment is detected. (check-in: fc254c1eb7 user: stephan tags: trunk) | |
|
2025-05-06
| ||
| 23:01 | Merge the latest trunk enhancements into the reuse-schema branch. (check-in: f98aa940b4 user: drh tags: reuse-schema) | |
| 21:45 | Merge the latest trunk enhancements into the bedrock branch. (check-in: 9d6517e7cc user: drh tags: bedrock) | |
| 21:38 | Merge the latest trunk changes into the wal2 branch. (check-in: b17f5beab8 user: drh tags: wal2) | |
| 21:26 | Merge all the latest trunk enhancements into the begin-concurrent branch. (check-in: 55a51ba58f user: drh tags: begin-concurrent) | |
| 17:56 | Add test cases for the NOT NULL/IS NULL optimization in CHECK constraints fix. (check-in: 6eb2939a60 user: dan tags: trunk) | |
|
2025-05-05
| ||
| 22:56 | Part 2 of 2(?) of adding the -asdict flag to the db eval command of the Tcl interface. This needs a critical review from seasoned Tcl C API users before merging can be considered (noting that it's not planned for inclusion until 3.51). (check-in: 5368647a1f user: stephan tags: tcl-cw) | |
| 17:13 | Flesh out the break-as-null test cases to better demonstrate how it compares to the default of returning an empty string. (check-in: ad1ae76ad1 user: stephan tags: tcl-cw) | |
| 16:49 | Allow Tcl-defined UDFs to 'break' to result in an SQL NULL, as per suggestion in forum post 585ebac2c48f1411. (check-in: 034211985d user: stephan tags: tcl-cw) | |
| 15:12 | Merge trunk into cygwin-fixes branch. 'make test' failure count = 1 (delete_db-1.3.0) both before and after the merge, (Leaf check-in: 7471088197 user: stephan tags: cygwin-fixes) | |
|
2025-04-30
| ||
| 12:48 | Fix an issue in Bloom filters on RHS subsqueries to IN operators. See forum post 792a09cb3d for a description of the problem. Also improve comments related to [baa83b460c677c21] which was origin of the problem. (check-in: cdef486e21 user: drh tags: trunk) | |
|
2025-04-29
| ||
| 14:23 | Add the "--fuzzdb FILENAME" to testrunner.tcl as an alternative to setting the FUZZDB environment variable (as that can be awkward to do on Windows). Further improvements to the testrunner.tcl documentation. (check-in: 6fb84156a2 user: drh tags: trunk) | |
| 11:35 | Update testrunner.tcl documentation. Fix typo in testrunner.tcl output. (check-in: ba8800b4ba user: drh tags: trunk) | |
| 10:41 | Improved --explain display of FUZZDB test plans in testrunner.tcl. (check-in: 42bdd7262e user: drh tags: trunk) | |
| 10:29 | Do not run FUZZDB on either Windows-Memdebug or Windows-Win32Heap. (check-in: 10d8401d59 user: drh tags: trunk) | |
| 01:37 | Make testrunner.tcl more restrictive about which configurations run fuzzcheck-asan and fuzzcheck-ubsan. (check-in: 785599394d user: drh tags: trunk) | |
|
2025-04-28
| ||
| 19:15 | Testrunner.tcl now runs fuzzcheck-asan and fuzzcheck-ubsan tests. (check-in: 3d8f3a2558 user: drh tags: trunk) | |
| 17:56 | If the FUZZDB environment variable is set when running testrunner.tcl and that env-var points to a fuzzcheck database, then suppliment the fuzzcheck tests with that extra database. (check-in: c08530dd6a user: drh tags: trunk) | |
| 16:28 | Enhance testrunner.tcl so that it does not build testfixture unnecessarily - if the pattern does not match any TCL test. (check-in: 896d767f1c user: drh tags: trunk) | |
| 16:17 | Fix testrunner.tcl so that it honors pattern matches in non-testfixture tests, such as fuzzcheck and sessionfuzz. (check-in: 81857474fe user: drh tags: trunk) | |
| 15:00 | Remove a stray blank line from the test/testrunner.tcl script. (check-in: 7d6005b0d1 user: drh tags: trunk) | |
|
2025-04-21
| ||
| 13:08 | Merge all the latest trunk enhancements into the reuse-schema branch. (check-in: b3a526a887 user: drh tags: reuse-schema) | |
| 13:02 | Merge all the latest trunk enhancements into the bedrock branch. (check-in: 3215186aa9 user: drh tags: bedrock) | |
| 12:56 | Merge the latest trunk enhancements into the wal2 branch. (check-in: c68d0d3530 user: drh tags: wal2) | |
| 12:41 | Merge all recent trunk enhancements into the begin-concurrent branch. (check-in: 2866119c75 user: drh tags: begin-concurrent) | |
|
2025-04-16
| ||
| 10:53 | Correctly handle the case of a multi-column UNIQUE constraint that contains the ROWID as one of it columns, and then the columns of that UNIQUE are used in a row-value IN operator as a WHERE clause constraint. (check-in: ba7d5bad32 user: drh tags: branch-3.49) | |
|
2025-04-15
| ||
| 21:59 | Correctly handle the case of a multi-column UNIQUE constraint that contains the ROWID as one of it columns, and then the columns of that UNIQUE are used in a row-value IN operator as a WHERE clause constraint. Reported by forum post b9647a113b. Problem introduced by [723f1be3d4a905a6], part of ticket [da78413751863]. (check-in: d22475b81c user: drh tags: trunk) | |
|
2025-04-14
| ||
| 19:43 | Improved estimate on the number of output rows in a recursive common table expression that uses the UNION operator. Follow-up to [f911f1c4977fbcae] and it's output row estimate changes associated with DISTINCT queries. (check-in: 92513f6bce user: drh tags: trunk) | |
|
2025-04-10
| ||
| 19:54 | Improved detection of run-time errors (ex: OOM errors) in speedtest1. (check-in: 0e5e0e2f55 user: drh tags: trunk) | |
| 19:39 | Provide new command-line options --hard-heap-limit and --soft-heap-limit for speedtest1. (check-in: 578e9fedea user: drh tags: trunk) | |
| 19:03 | Be sure that speedtest1 reports any errors that it encounters while running the speed tests. (check-in: 8c8b1a99bc user: drh tags: trunk) | |
| 15:01 | Fix an obscure problem allowing the propagate-constants optimization to improperly substitute a column of a sub-query with NONE affinity. Forum post 2025-04-08T14:18:45Z. (check-in: 979f384a93 user: dan tags: trunk) | |
| 14:53 | Fix an obscure problem allowing the propagate-constants optimization to improperly substitute a column of a sub-query with NONE affinity. (Closed-Leaf check-in: d82725dcae user: dan tags: forum-0109bca824) | |