Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
200 most recent check-ins using file src/test7.c version 5612e9aecf
|
2024-04-02
| ||
| 18:48 | Fix typos in comments. Provided ".wheretrace" debugging output for the interstage heuristic module. Do omit automatic index loops in the interstage heuristic. (Leaf check-in: 357d9513d2 user: drh tags: branch-3.28) | |
| 18:31 | Fix table-valued functions so that they will work as the right table in a LEFT JOIN. Ticket [2ae0c599b735d59e] (check-in: 1f97086d62 user: drh tags: branch-3.28) | |
| 11:54 | Add a heuristic in between the two solver() passes of the query planner that tries to prevent a very slow query plan in cases where the output row count estimate is imprecise. (check-in: 74b247d958 user: drh tags: branch-3.28) | |
|
2023-11-29
| ||
| 16:26 | Fix a duplicate assert() caused by the second cherrypick in the previous check-in. (check-in: f10d4fc4a8 user: drh tags: branch-3.28) | |
| 16:07 | Remove Window objects from the corresponding Select.pWin list when they are deleted, as they are, for example, when the ORDER BY clause is optimized out. (check-in: f9c6e6a710 user: drh tags: branch-3.28) | |
|
2023-10-19
| ||
| 21:05 | Ensure that when an ephemeral cursor is reopened with a second invocation of to OP_OpenEphemeral, the sequence counter is reset and the cache marked as stale. Fix for [9cdc5c46]. (check-in: d4bfa8d21a user: drh tags: branch-3.28) | |
|
2023-09-15
| ||
| 20:04 | Drop support for the view-scan optimization as it was causing multiple performance regressions. In its place, reduce the estimated row count for DISTINCT subsqueries by a factor of 8. (check-in: 796a65fa61 user: drh tags: branch-3.28) | |
|
2023-02-26
| ||
| 11:52 | In the [/info/7c2d3406000dc8ac|omit-unused-subquery-columns optimization], be sure to remove the EP_Skip and EP_Unlikely flags from the result set expressions that get nulled-out. dbsqlfuzz bf1d3ed6e0e0dd8766027797d43db40c776d2b15. Also fix an incorrect ".selecttrace" code block. (check-in: 83a7f13edb user: drh tags: branch-3.28) | |
|
2023-02-16
| ||
| 21:01 | Fix an #ifdef that uses a different macro name from the main branch. (check-in: ad6ac5d3e8 user: drh tags: branch-3.28) | |
| 19:04 | Back-port omit-unused-subquery-column enhancements into the 3.28 branch. (check-in: 57a4e91f43 user: drh tags: branch-3.28) | |
| 14:29 | Do not compute result columns of subqueries that are never used. Make those columns NULL instead. This optimization potentially resolves the enhancement request described by [baa5bb76c35a124c|ticket baa5bb76c35a124c]. (check-in: 0163b697dd user: drh tags: branch-3.28) | |
| 01:29 | Do not compute unused result columns of subqueries. This optimization will potentially resolve the performance optimization request of [baa5bb76c35a124c|ticket baa5bb76c35a124c]. (Closed-Leaf check-in: 0c21b6a5f8 user: drh tags: branch-3.26) | |
| 01:21 | Update test cases so that they work with TCL 8.7 and later. (check-in: e9b762de0e user: drh tags: branch-3.26) | |
|
2023-02-15
| ||
| 13:00 | Update the configure script so that it contains the correct version number. (check-in: a7cbf30808 user: drh tags: branch-3.26) | |
|
2023-02-06
| ||
| 15:46 | Update test scripts speed1.test and speed1p.test so they may be run by testrunner.tcl. (check-in: e761d4b9c8 user: dan tags: trunk) | |
| 14:48 | Shorten the status line for testrunner.tcl so that it fits on an 80-character terminal. (check-in: b760a7307c user: drh tags: trunk) | |
| 14:16 | Fix error in the releasetest makefile target from the previous check-in. (check-in: e7fe287d79 user: drh tags: trunk) | |
| 14:11 | Update "releasetest" makefile targets to use testrunner.tcl. (check-in: 1b95676b05 user: drh tags: trunk) | |
| 14:01 | Add capability to override the JS API's internal use of console.log/debug/warn/error() with client-provided versions via the bootstrap-time config object. (check-in: c54f29d8e5 user: stephan tags: trunk) | |
| 13:36 | Fix a formatting problem in scanstatus2.test introduced by [81c118d9]. (check-in: 928ab40edb user: dan tags: trunk) | |
| 11:43 | Add the --fuzztest option to testrunner.tcl. Also, have it print whitespace over the top of the old report line before writing the new. (check-in: d83ce01fe1 user: dan tags: trunk) | |
| 11:02 | Fix problems with test scripts preventing them from running with SQLITE_DEFAULT_MEMSTATUS=0 builds. Or builds without SQLITE_ENABLE_STAT4. (check-in: c0fbc89ed2 user: dan tags: trunk) | |
| 10:47 | Fix some test scripts that were failing with SQLITE_OMIT_VIRTUALTABLE builds. (check-in: 81c118d90b user: dan tags: trunk) | |
|
2023-02-05
| ||
| 20:29 | Do not use a Bloom filter if any outer loop lacks STAT1 data, since without STAT1 data, the query planner cannot make an accurate determination of whether or not a Bloom filter will be useful. This fixes the problem reported by [forum:/forumpost/56de336385|forum post 56de336385]. (check-in: e6ab96bd0b user: drh tags: trunk) | |
| 17:40 | Add the "devtest" makefile target that runs both fuzztest and testrunner. (check-in: c81398c621 user: drh tags: trunk) | |
| 17:09 | In fuzzcheck, only show the description of each database if the -v option is specified. (check-in: 6a58179aaf user: drh tags: trunk) | |
| 00:47 | Restore a test for pBt NULL that was removed by [12a14711afa6cddb] but turned out to be necessary, as dbsqlfuzz quickly showed us. Test case added to TH3. (check-in: 647c89dd2f user: drh tags: trunk) | |
| 00:32 | Modify the status line output from testrunner so that each line overwrites the previous rather than scrolling. (check-in: ad4d28cd68 user: drh tags: trunk) | |
| 00:24 | Changes to the sqlite_dbpage virtual table to tag or remove unreachable branches. (check-in: 12a14711af user: drh tags: trunk) | |
|
2023-02-04
| ||
| 21:25 | Avoid running rbu tests under permutation "journaltest", which does not support wal. Fix some other test script problems. (check-in: 92f018698a user: dan tags: trunk) | |
| 20:53 | Add ALWAYS() and NEVER() macros to unreachable branchs in sqlite_dbpage. (check-in: db875cd6be user: drh tags: trunk) | |
| 20:07 | Remove an ALWAYS() that can be false in some very rare cases. dbsqlfuzz 2274a23c85a93b870f7eb12fe686073da01abc33 (check-in: a4eb0b0d83 user: drh tags: trunk) | |
| 19:01 | Updates to the testrunner.tcl script so that uses a separate sub-process for each test. And so that it runs the release test procedure currently handled by wapptest.tcl. (check-in: 4c3c587500 user: dan tags: trunk) | |
| 18:58 | Changes so that wapptest.tcl still works. (Closed-Leaf check-in: 7624de3a93 user: dan tags: testrunner) | |
| 18:50 | Update testrunner.tcl usage message. (check-in: b7c246bc3f user: dan tags: testrunner) | |
| 18:47 | Add testrunner.tcl "njob" and "status" commands. (check-in: 3869cd3d30 user: dan tags: testrunner) | |
| 14:23 | Better error message when trying to do an INSERT on an sqlite_dbpage virtual table. (check-in: a98e4908da user: drh tags: trunk) | |
|
2023-02-03
| ||
| 21:18 | Fixes for testrunner.tcl on windows. (check-in: b98e19fc41 user: dan tags: testrunner) | |
| 19:28 | Fix a problem where optimizing an fts5 table too often might cause it to become unreadable. (check-in: 35bed98141 user: dan tags: trunk) | |
| 18:47 | Have testrunner.tcl run various builds as part of the 'release' command. (check-in: ba2fae30a8 user: dan tags: testrunner) | |
| 14:57 | Attempt to fix harmless compiler warnings that reportedly appear in clang 15. (check-in: c045d76b90 user: drh tags: trunk) | |
| 12:03 | Improved detection of invalid command-line arguments to the showdb and showwal debugging utility programs. (check-in: 75cdaafc77 user: drh tags: trunk) | |
| 11:32 | Avoid using Tcl command [clock] in testrunner.tcl. (check-in: b2faf9289f user: dan tags: testrunner) | |
|
2023-02-02
| ||
| 20:27 | Instead of free()ing them, retain allocated page buffers on an internal per-connection reuse-list when a page-cache is reset. (check-in: 754f331614 user: dan tags: bedrock) | |
| 20:15 | Do not run test script pendingrace.test as part of the inmemory_journal permutation. (check-in: 69d934a1bf user: dan tags: testrunner) | |
| 19:41 | Add configuration data for osx and windows to testrunner_data.tcl (check-in: e45d34656a user: dan tags: testrunner) | |
| 16:30 | Improved and simplified logic for resolving the various aliases of the schema table. (check-in: 5c19491c36 user: drh tags: trunk) | |
| 15:28 | Resolve all possible aliases and variations of the schema table names. (check-in: e7a0112b23 user: drh tags: trunk) | |
| 14:27 | Merge latest enhancments into this branch from branch wal2. (Leaf check-in: 5a22010c35 user: dan tags: begin-concurrent-pnu-wal2) | |
| 14:21 | Merge trunk enhancements into this branch. (check-in: c9b0180203 user: dan tags: wal2) | |
| 06:17 | Remove automatic installation of JS-global S object for the sake of client libraries which embed this library, per [forum:9d4f722c6912799d|request in the forum]. (check-in: 9504f68af8 user: stephan tags: trunk) | |
|
2023-02-01
| ||
| 23:24 | Adjustments of assert() statement in STAT4 in order to give 100% MC/DC. (check-in: 55a26c67ed user: drh tags: trunk) | |
| 20:45 | New assert() statements to verify that sqlite3DeleteIndexSamples() is always called with non-NULL parameters. (check-in: 92c71fdd71 user: drh tags: trunk) | |
| 20:14 | Update testrunner.tcl to use a separate process for each test script. And to run some extra tests too. (check-in: d090948a69 user: dan tags: testrunner) | |
| 15:41 | Just because a CTE is used more than once, does not mean it should be tagged with M10d_Yes and thereby prohibited from participating in the query flattening optimization. See [forum:/forumpost/1d571c02963355ed|forum thread 1d571c02963]. (check-in: 66f29c403d user: drh tags: trunk) | |
| 14:17 | Fix a comment related to PENDING locks in os_unix.c. No code changes. (check-in: 6b3546c871 user: dan tags: trunk) | |
|
2023-01-31
| ||
| 20:43 | Fix a race condition during hot-journal rollback on unix that could theoretically cause spurious corruption errors. (check-in: e365dca4e5 user: dan tags: trunk) | |
| 20:21 | Fix a race condition during hot-journal rollback that could theoretically cause spurious corruption errors. (Closed-Leaf check-in: 20ea53ddf5 user: dan tags: pending-lock-race) | |
|
2023-01-30
| ||
| 20:44 | Additional tweaks to the enhancement at [609fbb94b8f01d67] to further reduce the cost estimate for constructing an automatic index on an ephemeral table, in order to resolve the performance problem described by [forum:/forumpost/1d571c0296|forum post 1d571c0296]. (check-in: bf1aae7a8c user: drh tags: trunk) | |
|
2023-01-29
| ||
| 06:01 | Two JS file renames which got inadvertently undone while setting up [9062b31174618c0e]. Cosmetic cleanups in ext/wasm/dist.make. (check-in: 0c2fde767f user: stephan tags: trunk) | |
| 05:09 | Correct the handling of the worker1 and promiser JS files in the face of the bundler-friendly changes. Those files require separate, bundler-friendly copies. (check-in: 9062b31174 user: stephan tags: trunk) | |
|
2023-01-28
| ||
| 21:06 | Do not assume that sub-queries that contain window functions are uncorrelated. (check-in: f27804484d user: dan tags: trunk) | |
| 21:01 | Show more details about the SrcItem.fg field in tree-trace output. (check-in: 3d05dddd0b user: drh tags: trunk) | |
| 17:37 | Fix a problem causing "PRAGMA quick_check" to return spurious corruption errors for a WITHOUT ROWID for which all columns are either virtual or part of the primary key, and for which the order of the columns in the primary key definition is different from the order in the table. (check-in: a7530f8971 user: dan tags: trunk) | |
| 16:37 | Update sqllimits1.test to account for the fact that if an odd value is specified as the length in bytes of a utf-16 string, it is truncated to the largest smaller even number. (check-in: 74508470c4 user: dan tags: trunk) | |
| 09:51 | Makefile doc touchups - no code/build changes. (check-in: 3458a481b9 user: stephan tags: trunk) | |
| 09:11 | Overhaul ext/wasm/GNUmakefile to consolidate what amounts to much copy/paste/slightly-edit duplication into a single function, called once per distinctive build mode (vanilla, ESM, bundler-friendly). (check-in: 168e5a9301 user: stephan tags: trunk) | |
| 05:09 | Enhance oo1.DB.exec() to simplify returning whole result sets. (check-in: 7b168ee2af user: stephan tags: trunk) | |
| 04:20 | Add JS bundler-friendly JS build. Minor test code cleanups. (check-in: 24d3a53dea user: stephan tags: trunk) | |
|
2023-01-27
| ||
| 23:10 | Fix compiler warning in base85.c. (check-in: bd9613fd63 user: drh tags: trunk) | |
| 20:25 | Update ext/wasm/README-dist.txt for the bundler-friendly build. (Closed-Leaf check-in: 6a5c4f6b19 user: stephan tags: js-bundler-friendly) | |
| 20:15 | Add an assert() to help static analyzers. (check-in: e446c8b4aa user: drh tags: trunk) | |
| 19:59 | Do not try to run rbu tests with builds that do not support rbu. (check-in: c74ad902e3 user: dan tags: trunk) | |
| 19:56 | Add a feature idea note to DB.exec(), derived from a forum discussion. (check-in: 792f43209c user: stephan tags: js-bundler-friendly) | |
| 17:19 | Cherrypick [3773934e91c20ca243] into trunk. (check-in: 50cf4300a6 user: stephan tags: trunk) | |
| 17:14 | Extract emcc version in JS build and use it to conditionally set build flags. Initially a workaround for [https://github.com/emscripten-core/emscripten/issues/18610|Emscripten ticket #18610] but may have other uses. (check-in: 3773934e91 user: stephan tags: js-bundler-friendly) | |
| 07:53 | Work around a JS null pointer deref which could be triggered from the dev console, but not (it seems) from client-side code. (check-in: eabb551b8b user: stephan tags: trunk) | |
| 05:37 | Merge trunk into wasi-patches branch. (check-in: 2ce89f5efc user: stephan tags: wasi-patches) | |
| 05:17 | Cherrypick [fa784101775b7|emscripten ticket #18609 workaround] into trunk. (check-in: 9a26fae545 user: stephan tags: trunk) | |
| 05:14 | Work around [https://github.com/emscripten-core/emscripten/issues/18609|upstream emscripten 3.1.31 ticket #18609]. (check-in: fa78410177 user: stephan tags: js-bundler-friendly) | |
| 03:18 | More work on creating a separate sqlite3.js build which is hopefully friendly to JS bundlers. (check-in: b7b896fb44 user: stephan tags: js-bundler-friendly) | |
| 02:21 | Resolve a nested if-block bug in ext/wasm/c-pp.c which caused output after a nested block to be unduly elided. Remove a kludge, added in the previous check-in, which worked around that bug. (check-in: 7a026a4b24 user: stephan tags: js-bundler-friendly) | |
| 01:33 | Beginnings of a bundler-friendly build of sqlite3.mjs. Not yet ready for downstream testing. (check-in: 4271bf5f41 user: stephan tags: js-bundler-friendly) | |
|
2023-01-26
| ||
| 20:08 | End-of-line whitespace cleanups and doc typo fixes. No code changes. (check-in: bdfd72a083 user: stephan tags: trunk) | |
| 18:16 | Have some RBU tests run as part of veryquick.test/testrunner.tcl. (check-in: f51406e3bf user: dan tags: trunk) | |
| 02:18 | Improved fix to allow sqlite3_vtab_in_first() to reliably return SQLITE_ERROR. (check-in: b25eec1c13 user: drh tags: trunk) | |
|
2023-01-25
| ||
| 21:28 | Fix a harmless compiler warning in FTS3. (check-in: 68d02d3c2a user: drh tags: trunk) | |
| 19:05 | Defer calling the destructor for the user data on a module until after the module has disconnected. [forum:/forumpost/b68391eb71fdff73|Forum post b68391eb71fdff73]. (check-in: 1ab122289f user: drh tags: trunk) | |
| 17:24 | Change the instrumentation messages on this branch so that they contain "v=7" instead of "v=6". (Leaf check-in: acea12d90f user: dan tags: schema-version-instr) | |
| 17:09 | Experimental patch to put page buffers on an internal per-connection list for reuse instead of free()ing them when the page-cache is reset. (check-in: 1e4cfd2f30 user: dan tags: schema-version-instr) | |
| 16:56 | Enhance the sqlite3_vtab_in_first() and sqlite3_vtab_in_next() interfaces so that they reliably return SQLITE_ERROR (and not SQLITE_MISUSE) if they are invoked on a parameter that did not have multi-value IN processing enabled via a prior call to sqlite3_vtab_in(). See [forum:/forumpost/a823d4a3d5f73def|forum thread a823d4a3d5f73def]. (check-in: 144326dc17 user: drh tags: trunk) | |
| 15:45 | Fix a problem with fts3 auxiliary functions and one or more NEAR expressions ORed together. (check-in: de4690a10a user: dan tags: trunk) | |
| 13:42 | Fix another problem with fts3/4 auxiliary functions and NEAR expressions that consist entirely of deferred tokens. (check-in: a8c91c132f user: dan tags: trunk) | |
|
2023-01-24
| ||
| 20:17 | Add scalar SQL function unhex(). (check-in: 890e9629a7 user: dan tags: trunk) | |
| 17:19 | Update unhex() to allow a second argument, specifying a set of characters that are permitted to appear between pairs of hexadecimal digits. (Closed-Leaf check-in: 66c8562690 user: dan tags: unhex-function) | |
| 11:24 | Fix a problem with using fts3 auxiliary functions with expressions like "E AND ...", where E is a NEAR expression that consists entirely of deferred tokens. (check-in: 39bfae4c46 user: dan tags: trunk) | |
|
2023-01-23
| ||
| 21:41 | Suppress a harmless compiler warning. [forum:forumpost/e3f72e9291189925|Forum post e3f72e9291189925]. The code was legal and correct. The revised code is actually less clear in its intent. But at least now there will (hopefully) be no warning. (check-in: 48bb7c8878 user: drh tags: trunk) | |
| 20:45 | Due to a coding error, check-in [8efd61e8518594e3] did not actually use just read transactions if the operation is read-only and the SQLITE_MAX_ATTACHED macro is set to 31 or more. This was due to a misuse of the writeMask field of Parse, pointed out by [forum:/forumpost/aa173c18d5|forum post aa173c18d5]. (check-in: 8760566893 user: drh tags: trunk) | |
| 16:16 | Add the missing CARRAY_BLOB macro to the carray.h extension header. (check-in: 10bf639cd1 user: drh tags: trunk) | |
| 14:11 | Add experimental user function unhex(). (check-in: dbe424b5db user: dan tags: unhex-function) | |
|
2023-01-22
| ||
| 21:54 | Give CLI .version a place in .help output. (check-in: 5f2dfdcc34 user: larrybr tags: trunk) | |
|
2023-01-21
| ||
| 16:53 | Minor API doc cleanups and JS code simplification. (check-in: f608a3a456 user: stephan tags: trunk) | |
| 12:18 | Merge trunk into wasi-patches branch. (check-in: 6fc20d75d4 user: stephan tags: wasi-patches) | |
| 00:59 | Fix a memory leak in the TCL test harness associated with carray. (check-in: 5a316f9fd9 user: drh tags: trunk) | |
| 00:19 | Fix harmless compiler warnings. (check-in: ded60f5b34 user: drh tags: trunk) | |
|
2023-01-20
| ||
| 21:00 | Extend the carray extension to allow the use of BLOB values to be bound as an array of "struct iovec" objects. (check-in: e117a03ca6 user: drh tags: trunk) | |
| 19:19 | Two branches associated with memdb are now always taken (I believe). Tag them with ALWAYS() to verify this. (check-in: 20b9b5aa4f user: drh tags: trunk) | |
| 17:50 | Ensure that the database encoding cannot be changed while there are statements running. And that the connection is left in a valid state after an obscure OOM within sqlite3_deserialize(). (check-in: a02da71f3a user: dan tags: trunk) | |
| 15:13 | Add tests for changing the database encoding via RESET_DATABASE/VACUUM. And test that it is not possible to trick another connection with this. (check-in: b869054acb user: dan tags: trunk) | |
| 13:34 | The json_group_array(), json_group_object(), and fts5_source_id() functions should all be deterministic and innocuous. (check-in: edcb83fa0d user: drh tags: trunk) | |
|
2023-01-19
| ||
| 21:05 | Add test logging around the pcache1FreePage() loop in pcache1TruncateUnsafe(). (check-in: a057f9cb2c user: dan tags: schema-version-instr) | |
| 18:16 | Fix numbering issue in and remove duplicate test from windowB.test. (check-in: fa10e561f5 user: dan tags: trunk) | |
|
2023-01-18
| ||
| 17:39 | Emit sqlite3-api.(m)js during the JS build process, which are the JS APIs without the Emscripten/wasm-loading parts. They are hypothetically useful for arbitrary build environments/toolchains but have notable caveats related to the wasm imports, as elaborated on in the makefile. (check-in: 966b55c513 user: stephan tags: trunk) | |
|
2023-01-17
| ||
| 19:34 | Fix another issue with very large compressed LSM databases. (check-in: d71154265a user: dan tags: trunk) | |
| 19:00 | Change an now unreachable testcase() into an assert(). (check-in: 517b2c4c4e user: drh tags: trunk) | |
| 18:40 | Fix harmless compiler warnings in the CLI. (check-in: 7cf282d307 user: drh tags: trunk) | |
| 15:46 | Update virtual tables json_each and json_tree so that adding "ORDER BY rowid" to a query does not require an external sort. (check-in: ce18f0ed68 user: dan tags: trunk) | |
| 13:33 | Add test cases to confirm that the schema parsing quirk in which an ON CONFLICT clause is accepted and ignored on table CHECK constraints but raises an error on column CHECK constraints. We want to continue supporting this harmless quirk to avoid breaking legacy applications and databases that accidentally use it. (check-in: 92b6a9cd0f user: drh tags: trunk) | |
|
2023-01-16
| ||
| 21:49 | Cause .clone to not trip over sequence table as reported at [forum:/forumpost/71ff9e6c4c|forum post 71ff9e6c4c]. (check-in: b44d04f7b0 user: larrybr tags: trunk) | |
| 20:33 | Another version of the debug-only logging on this branch. (check-in: 906caf8911 user: dan tags: schema-version-instr) | |
| 18:13 | In the CLI, create our own private version of strncpy() to work around false-positive compiler warnings from Alpine Linux. (check-in: 83f21285fe user: drh tags: trunk) | |
|
2023-01-14
| ||
| 19:53 | Omit the long-disused FTS1 and FTS2 implements from the active source tree. The code will persist forever in the source repository, but there is no point in carrying it around in the latest tarballs where it is never used. (check-in: 2bb50d5aed user: drh tags: trunk) | |
| 19:36 | Add OOM check, per tip at [forum:/forumpost/933479b2d5|forum post 933479b2d5] (Leaf check-in: c66c7734fe user: drh tags: branch-3.40) | |
| 19:27 | Add OOM check, per tip at [forum:/forumpost/933479b2d5|forum post 933479b2d5] (check-in: eda84dcffe user: larrybr tags: trunk) | |
| 19:09 | Doc-only fix, per [forum:/forumpost/0cfaf6876b|forum post 0cfaf6876b] (check-in: eac135fd6a user: larrybr tags: trunk) | |
|
2023-01-13
| ||
| 20:49 | Fix another lsm compression-mode bug. (check-in: f9fafc9413 user: dan tags: trunk) | |
| 19:32 | In expression nodes of type REGISTER with sub-type COLUMN, ensure that the iColumn field is set correctly, as otherwise the "IS NULL" operator might be incorrectly optimized. Fix for the problem described by [forum:/forumpost/d010a26798915b53|forum post d010a26798915b53]. (check-in: 76b440c588 user: drh tags: branch-3.40) | |
| 19:29 | In expression nodes of type REGISTER with sub-type COLUMN, ensure that the iColumn field is set correctly, as otherwise the "IS NULL" operator might be incorrectly optimized. Fix for the problem described by [forum:/forumpost/d010a26798915b53|forum post d010a26798915b53]. (check-in: 0819a1869a user: drh tags: trunk) | |
| 19:00 | Fix an error in debugging output discovered while working on the problem with RETURNING reported by [forum:/forumpost/d010a26798|forum post d010a26798]. (Leaf check-in: 3ae9127f15 user: drh tags: returning-is-null-fix) | |
| 18:20 | Add missing "const" on variables in recent RBU fixes. (check-in: 9b8dcd7905 user: drh tags: trunk) | |
| 15:54 | Enhance query planning so that it check for sqlite3_interrupt() calls and periodically invokes the progress handler callback (if any) during long query analyses. (check-in: bd8fa10e59 user: drh tags: trunk) | |
| 15:31 | Update documentation for sqlite3_progress_handler(). (Closed-Leaf check-in: 41b4c407b7 user: drh tags: progress-during-prepare) | |
| 11:31 | Remove an incorrect legacy assert(). (check-in: 3006b3b32f user: drh tags: progress-during-prepare) | |
|
2023-01-12
| ||
| 20:36 | Reduce the frequency of calls to sqlite3ProgressCheck(). (check-in: 795aca4a26 user: drh tags: progress-during-prepare) | |
| 19:51 | Fix sqlite3_prepare() so that it only invokes the progress handler on every N-th call to sqlite3ProgressCheck(), where N is the progress handler step count. Also fix faulty asserts exposed by the ability to interrupt in the middle of sqlite3_prepare(). (check-in: 0546165159 user: drh tags: progress-during-prepare) | |
| 19:43 | Merge latest trunk changes, including fixes for RBU pass-through mode, with this branch. (check-in: deb26d034b user: dan tags: reuse-schema) | |
| 19:28 | Do not attempt to run new test file rbupass.test if the "demo" VFS is not available. (check-in: c5d958eb94 user: dan tags: trunk) | |
| 19:11 | Avoid crashing when using an RBU VFS with a version 1 parent VFS. (check-in: d149772d18 user: dan tags: trunk) | |
| 17:13 | When deleting any old OAL file before starting an RBU update or vacuum, use the same VFS as will be used for the target database, even if this is not the system default. (check-in: 5a86c6cb1f user: dan tags: trunk) | |
| 15:44 | Fix a startup race condition that could occur if a wal file grows from 0 bytes while a BEGIN CONCURRENT transaction is running. Cherrypick of [c1feca4d]. (check-in: 2c14f3832e user: dan tags: begin-concurrent-pnu-wal2) | |
| 15:30 | Fix a startup race condition that could occur if a wal file grows from 0 bytes while a BEGIN CONCURRENT transaction is running. (check-in: c1feca4dda user: dan tags: begin-concurrent) | |
| 13:25 | Attempt to provide a mechanism to do early termination of long-running statement preparation by invoking the progress handler at strategic points during sqlite3_parpare(). This experiment shows that sqlite3_prepare() might leave the resulting prepared statement uninitialized following an interrupt. (check-in: 79636f2d80 user: drh tags: progress-during-prepare) | |
|
2023-01-11
| ||
| 22:45 | Merge trunk into wasi-patches branch and add missing yes/no result to the configure script's output for the --with-wasi-sdk=PATH test. (check-in: adc0ede0a4 user: stephan tags: wasi-patches) | |
| 20:52 | Fix duplicate semicolon in btreeInt.h. [forum:/forumpost/8db1711ca2|Forum post 8db1711ca2] (check-in: 7526c46632 user: drh tags: trunk) | |
| 17:59 | Fix a false-positive in the out-of-range jump detection logic that was added as part of RIGHT JOIN. (check-in: ab5bcb91cd user: drh tags: trunk) | |
| 17:50 | If OP_Rewind has P2 of zero, that is an assertion that the table is never empty. This fixes a false-positive in the out-of-subroutine jump detection logic added in version 3.39.0, and which was causing the assertion on the previous check-in. (Closed-Leaf check-in: 33fd9997eb user: drh tags: code-generator-20230111) | |
| 16:44 | Add an assert() to the byte-code engine that goes off if the OP_Halt opcode is invoked with SQLITE_INTERNAL. This causes the RIGHT JOIN error "Opcode jumps to ... which is outside the subroutine ..." to fail immediately, causing it to come more readily to tester's attention. There is at least one testcase in test/fuzzdata8.db that asserts due to this change. (check-in: b8f9944142 user: drh tags: code-generator-20230111) | |
| 16:25 | Fix problems with compressed LSM databases larger than 2GiB. (check-in: f884224578 user: dan tags: trunk) | |
| 16:17 | Improved progress-handler and interrupt detection during PRAGMA integrity_check. (check-in: 6db42780a9 user: drh tags: trunk) | |
| 16:02 | Fix another 64-bit offset problem in lsm. (Closed-Leaf check-in: 1f3d0bdc20 user: dan tags: lsm-compress-fixes) | |
| 00:27 | Add a new sqlite3_is_interrupted() interface that can be used by long-running app-defined functions and similar to see if they need to exit early due to an sqlite3_interrupt() call. (check-in: d030f34136 user: drh tags: trunk) | |
|
2023-01-10
| ||
| 19:57 | When computing the datatypes for columns in a view, use the same datatype name as the underlying table if such is available and is consistent with the computed affinity of the column. [forum:/forumpost/7fb1fe9dcf310ef5|Forum thread 7fb1fe9dcf310ef5]. (check-in: 497a98363f user: drh tags: trunk) | |
| 15:07 | Fix handling of unix paths that contain ".." components such that "/" is considered its own parent directory. [forum:/forumpost/caa46bd1f2f2a255|Forum thread caa46bd1f2f2a255]. (check-in: b829dd1b97 user: dan tags: trunk) | |
| 14:33 | Improvements to the SQLITE_DIRECTONLY documentation. (check-in: b277ba40a8 user: drh tags: trunk) | |
| 14:31 | Fix handling of unix paths that contain ".." components such that "/" is considered its own parent directory. (Closed-Leaf check-in: 3c6cadb396 user: dan tags: unix-path-fix) | |
|
2023-01-09
| ||
| 21:10 | Fix some problems with large, compressed, lsm databases. (check-in: 956e985ff9 user: dan tags: lsm-compress-fixes) | |
| 18:42 | Clarify help for .quit. (check-in: 8004a2b743 user: larrybr tags: trunk) | |
| 12:01 | Fix JSON functions so that they work correctly under PRAGMA trusted_schema. [forum:/forumpost/c88a671ad083d153|Forum thread c88a671ad083d153]. (check-in: 51a5d83c42 user: drh tags: trunk) | |
|
2023-01-07
| ||
| 22:28 | Doc-only update, sqlite3_preupdate_hook() return (check-in: 2da51d7e1b user: larrybr tags: trunk) | |
| 13:40 | Account for read-only connections on LSM databases with non-default block or page sizes. (check-in: 3a2075b089 user: dan tags: trunk) | |
|
2023-01-06
| ||
| 19:03 | Fix the threshold for logging "PRAGMA schema_version" slowness. (check-in: ca3854cb6f user: dan tags: schema-version-instr) | |
|
2023-01-05
| ||
| 19:48 | One more iteration of "PRAGMA schema_version" instrumentation. (check-in: 0d9081068e user: dan tags: schema-version-instr) | |
| 14:41 | Changes a testcase() into an assert() due to the [e58bba93717cd6ff] change. (check-in: a6251d7289 user: drh tags: trunk) | |
| 13:55 | Remove the unused sqlite3IsMemdb() routine, to avoid a harmless compiler warning. (check-in: 4f512a39af user: drh tags: branch-3.40) | |
| 13:41 | Fix a problem with applying integer affinity to a MEM_IntReal value. [forum:/forumpost/d270125fae|Forum post d270125fae]. (check-in: d28d9398a5 user: drh tags: branch-3.40) | |
| 13:35 | Fix a problem with applying integer affinity to a MEM_IntReal value. [forum:/forumpost/d270125fae|Forum post d270125fae]. (check-in: e58bba9371 user: dan tags: trunk) | |
| 01:32 | Increase the version number to 3.40.2. (check-in: 43375ef8a7 user: drh tags: branch-3.40) | |
| 01:29 | In the zipfile extension (which is not part of the SQLite amalgamation, but which is included in the CLI by default) ensure that fopen() is not invoked using a NULL filename. Fix for the issue reported by [forum:/forumpost/d1c96a9032e564f8|forum post d1c96a9032e564f8]. (check-in: e4de577757 user: drh tags: branch-3.40) | |
| 01:26 | In the zipfile extension (which is not part of the SQLite amalgamation, but which is included in the CLI by default) ensure that fopen() is not invoked using a NULL filename. Fix for the issue reported by [forum:/forumpost/d1c96a9032e564f8|forum post d1c96a9032e564f8]. (check-in: d32757ddf5 user: drh tags: trunk) | |
|
2023-01-04
| ||
| 18:32 | Adjustments to the tool/warnings.sh script to account for compiler differences. (check-in: 863c03bee1 user: drh tags: trunk) | |
| 17:46 | Ensure that LIMIT clauses may be passed through to virtual table implementations even if the WHERE clause uses operators that may only be optimized by virtual, not built-in, tables (!=, functions, MATCH etc.). (check-in: f38caab23b user: dan tags: trunk) | |
| 16:54 | Employ deliberate_fall_through macro to quiet some compilers. (check-in: 869635fb81 user: larrybr tags: trunk) | |
| 15:18 | Enhance PRAGMA integrity_check so that it verifies that the string values stored in indexes are byte-for-byte identical to the values in the table, and not just equivalent according to the collating sequence. dbsqlfuzz 686e2e205e0c0594d3fb524bea0c25e621d1a870. (check-in: 9302e4bfdc user: drh tags: trunk) | |
| 11:58 | Remove the unused "sqlite3StackAllocZero()" macro. (check-in: f0ca57207e user: drh tags: trunk) | |
| 11:57 | Elaborate on the open-in-read-only fallback behavior of the SQLITE_OPEN_READWRITE flag, per user request. Unrelated trailing EOL whitespace cleanups. (check-in: 1003144fc1 user: stephan tags: trunk) | |
| 03:14 | Remove the JS-side SQLITE_WASM_DEALLOC sanity check which triggers the problem mentioned in [688c5c13d156] and [ae0196d86ee8], for reasons covered in the code comments, per discussion in [forum:e5b20e1feb|forum post e5b20e1feb]. (check-in: 65ff3200c6 user: stephan tags: trunk) | |
|
2023-01-03
| ||
| 19:27 | Small performance increase in the symbol hash table. (check-in: a19597b4fd user: drh tags: trunk) | |
| 18:51 | Avoid an unnecessary call to strlen() in the sqlite3VdbeMemStringify() routine, for a performance increase and size reduction. (check-in: 284382d378 user: drh tags: trunk) | |
| 15:11 | Small performance improvement in the btreeOverwriteCell() routine. (check-in: df5ea47130 user: drh tags: trunk) | |
|
2023-01-02
| ||
| 20:52 | Add some docs explaining a particular piece of [ae0196d86ee8]. No code changes. (check-in: 7f96803c1c user: stephan tags: trunk) | |
| 20:07 | Another reformulation of SQLITE_WASM_DEALLOC to attempt to work around a Safari-specific quirk reported in [forum:e5b20e1feb|forum post e5b20e1feb]. (check-in: ae0196d86e user: stephan tags: trunk) | |
|
2023-01-01
| ||
| 12:22 | An alternative solution to mapping SQLITE_WASM_DEALLOC to the proper function pointer in JS, to account for a Safari-specific quirk reported in [forum:e5b20e1feb|forum post e5b20e1feb]. (check-in: 688c5c13d1 user: stephan tags: trunk) | |
|
2022-12-31
| ||
| 05:26 | Remove redundant assignment in kvvfs's decoding. (check-in: 2ffbf0c73c user: peter.d.reid tags: trunk) | |
| 05:19 | Avoid an infinite loop when an unexpected character is being decoded by kvvfs (check-in: 6909195f77 user: peter.d.reid tags: trunk) | |
|
2022-12-29
| ||
| 18:54 | A call to sqlite3_declare_vtab() should not cause DML/DDL authorization failures. (check-in: eed1e03072 user: drh tags: trunk) | |
|
2022-12-28
| ||
| 14:55 | Merge the 3.40.1 changes into the reuse-schema branch. (Leaf check-in: 126c68bd15 user: drh tags: reuse-schema-3.40) | |
| 14:03 | Version 3.40.1 (check-in: df5c253c0b user: drh tags: release, branch-3.40, version-3.40.1) | |
|
2022-12-27
| ||
| 22:46 | Add sqlite3changeset_new/old_js(), which work like sqlite3_preupdate_new/old_js() but on changesets. (check-in: e8afad630b user: stephan tags: trunk) | |
| 14:34 | Expose sqlite3_preupdate_hook() and friends to the JS API. (check-in: cc02783a12 user: stephan tags: trunk) | |
| 14:14 | Fix a broken assert() in fts5. (check-in: ff1d456161 user: dan tags: branch-3.40) | |
| 14:12 | Fix a faulty assert() in fts5. (check-in: 4acff807c6 user: dan tags: branch-3.40) | |
| 14:11 | Fix an assert() in fts5. Simplify memdb xLock/xUnlock some. (check-in: 43079c5246 user: dan tags: branch-3.40) | |
| 14:06 | Fix a missing 0 at the end of an integer literal in the MEMSYS5 fix. (check-in: e3bc10e8a8 user: drh tags: branch-3.40) | |
| 14:03 | Fix a missing 0 at the end of an integer literal in check-in [8da0f0c38a458c57] (check-in: e3776796f5 user: drh tags: trunk) | |
| 13:52 | Fix a broken assert() in fts5. (check-in: ff5a9b054f user: dan tags: trunk) | |
| 12:25 | Add links to module-symbols.html for newly-added APIs. (check-in: 335ef03eb9 user: stephan tags: trunk) | |
| 12:17 | Add two more tests to [f99f8e3ecfe20]. (check-in: 9cffccd335 user: stephan tags: trunk) | |
| 12:13 | Expose sqlite3_commit/rollback/update_hook() to JS API. (check-in: f99f8e3ecf user: stephan tags: trunk) | |
| 11:53 | Fix minor problems in test scripts where.test and recover1.test. (check-in: 64588bd5da user: dan tags: branch-3.40) | |
| 11:40 | Add an optional argument to oo1.DB.transaction() to specify an explicit BEGIN qualifier. (check-in: 507335c12b user: stephan tags: trunk) | |