Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
635 check-ins using file test/fuzzcheck.c version 30475c820d
|
2023-02-05
| ||
| 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 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 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 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 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 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 post b68391eb71fdff73. (check-in: 1ab122289f user: drh tags: trunk) | |
| 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 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 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 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
| ||
| 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 post 71ff9e6c4c. (check-in: b44d04f7b0 user: larrybr tags: trunk) | |
| 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 post 933479b2d5 (Leaf check-in: c66c7734fe user: drh tags: branch-3.40) | |
| 19:27 | Add OOM check, per tip at forum post 933479b2d5 (check-in: eda84dcffe user: larrybr tags: trunk) | |
| 19:09 | Doc-only fix, per 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 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 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 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 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 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 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 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-05
| ||
| 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 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 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 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 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 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 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 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, version-3.40.1, branch-3.40) | |
|
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) | |
|
2022-12-26
| ||
| 17:15 | Expose the auto-extension API to JS and reorganize some nearby code. (check-in: 52b229d11d user: stephan tags: trunk) | |
| 17:09 | Fix an unsafe use of sqlite3_mprintf() in sqlite3_overload_function() identified by forum post: https://sqlite.org/forum/forumpost/95b338860d. (check-in: a315222619 user: drh tags: branch-3.40) | |
| 17:02 | Prevent the sessions rebaser from generating changesets containing UPDATE records for which non-PK fields are present in the old.* but not the new.* record. Also update the changeset iterator to work around such changesets. (check-in: 629dbe2543 user: drh tags: branch-3.40) | |
| 16:54 | In the unix backend, when implementing the defenses against small file descriptors, delete a file just created if it was opened with O_EXCL|O_CREAT so that it can be created again the next time through the loop. Fix for the problem described by forum post 699af709ab3a8ccf. (check-in: 174acf3284 user: drh tags: branch-3.40) | |
| 16:45 | Fix an over-zealous assert() reported by Yong Heng. (check-in: 1e9dbb5a1b user: drh tags: branch-3.40) | |
| 16:24 | Ensure the RETURNING clause is honoured when a row of a temp table is updated by an ON CONFLICT clause. (check-in: ac9568cf87 user: drh tags: branch-3.40) | |
| 16:12 | Add the SQLITE_FCNTL_RESET_CACHE verb. Use it to ensure that the page cache is purged before and after a the recovery extension is run. (check-in: 71dd920f92 user: drh tags: branch-3.40) | |
| 16:03 | Fix corner cases in UTF8 handling in the REGEXP extension. Forum post 3ffe058b04. (check-in: 93e68b3983 user: drh tags: branch-3.40) | |
| 15:55 | Fix a off-by-one error in code generation that comes up when doing a DISTINCT query against a virtual table with an OR term in the WHERE clause and where the ORDER BY clause has 64 or more references to the result set. Forum post dfe8084751. The error is harmless in production builds, but might cause an assertion fault in a debugging build. (check-in: cbcd7d9be5 user: drh tags: branch-3.40) | |
| 15:44 | Fix safe mode authorizer callback to reject disallowed UDFs. Reported at Forum post 07beac8056151b2f. (check-in: 70964b8a1c user: drh tags: branch-3.40) | |
| 15:21 | Fix an infinite loop in the MEMSYS5 auxiliary memory allocator that occurs for memory allocations between 500MiB and 1GiB in size. Error introduced by check-in [949133231f8f751a]. The problem only affects builds that include the SQLITE_ENABLE_MEMSYS5 compile-time option. (check-in: c10d40ca68 user: drh tags: branch-3.40) | |
| 15:14 | Fix an infinite loop in the MEMSYS5 auxiliary memory allocator that occurs for memory allocations between 500MiB and 1GB in size. Error introduced by check-in [949133231f8f751a]. The problem only affects builds that include the SQLITE_ENABLE_MEMSYS5 compile-time option. (check-in: 8da0f0c38a user: drh tags: trunk) | |
| 15:08 | Document sqlite3.capi.sqlite3_prepare_v3() as accepting an ArrayBuffer and ensure that it can. (check-in: ae3ae92ec4 user: stephan tags: trunk) | |
| 14:55 | Correct some internal-use JS docs and update the 'string:flexible' type conversion to accept an ArrayBuffer (as it was recently documented to). (check-in: eff5d3bec2 user: stephan tags: trunk) | |
| 14:25 | Only add an on-db-close cleanup entry for collations if adding the collation succeeds and xCompare is-a JS function. (check-in: 18a5480f1e user: stephan tags: trunk) | |
| 13:45 | Extend [0e69b2c379e618] to support uninstalling stale JS-to-WASM function pointers added on behalf of UDFs. (check-in: 7a46e629dc user: stephan tags: trunk) | |
| 13:00 | Add JS infrastructure which enables sqlite3.capi.sqlite3_close_v2() to clean up stale JS-to-WASM collation function conversions installed on behalf of a given db handle. The same for UDF mappings is TODO. (check-in: 0e69b2c379 user: stephan tags: trunk) | |
| 11:13 | Reimplement sqlite3.capi.sqlite3_close_v2() and sqlite3session_delete() as a hand-written bindings so that they can attempt to clean up certain (potentially) FuncPtrAdapter-installed functions before closing. Correct the create-function family of JS-to-function-pointer automated conversions to include the UDF's arity as part of the mapping's key so that (un)binding a UDF to different functions for different arities works (and add tests confirming it). Correct a broken doc link in module-symbols.html. (check-in: 60b262ef0f user: stephan tags: trunk) | |
| 01:44 | Grammar fixup in comment re SQLITE_TRACE_PROFILE trace event. (check-in: b6dc80cbf6 user: larrybr tags: trunk) | |
|
2022-12-25
| ||
| 23:54 | module-symbols.html: add some missing links to C-side API docs for recently-added JS counterparts. (check-in: 7d4f4e96f3 user: stephan tags: trunk) | |
| 23:45 | Update JS worker #1 API and related tests for recent API changes. (check-in: d797e183e9 user: stephan tags: trunk) | |
| 22:55 | Rename the new wasm.irSizeof() to sizeofIR() because that seems clearer. (check-in: 49a83ca3ba user: stephan tags: trunk) | |
| 22:49 | Minor internal API doc correction and extend a test for oo1.DB.selectValues(). (check-in: b7295b1ca7 user: stephan tags: trunk) | |
| 22:44 | Add sqlite3.oo1.DB.selectValues(). Correct a logic error which could cause DB.selectValue(), DB.selectArray(), and DB.selectObject() to fail to finalize a statement if a call to bind() failed. Add more session API tests. (check-in: 6adc8a1014 user: stephan tags: trunk) | |
| 20:25 | Merge wasm-session-api branch into trunk, adding the session API to the JS/WASM components. (check-in: dfb8b651fa user: stephan tags: trunk) | |
| 20:22 | Add basic session API JS tests. (Closed-Leaf check-in: 64e032602c user: stephan tags: wasm-session-api) | |
| 20:05 | Add sqlite3.wasm.irSizeof() and extend certain allocation functions to make use of it. (check-in: 1cbc7b1875 user: stephan tags: wasm-session-api) | |
| 17:12 | Add tests confirming that JS sqlite3_exec()'s SQL argument participates in the 'string:flexible' type conversion. (check-in: 926d0c61a3 user: stephan tags: trunk) | |
| 17:09 | Replace the "manual" implementation of sqlite3.capi.sqlite3_exec() with a briefer "automated" one via the [7f9ace1b11a67] feature addition. Minor code-adjacent internal cleanups. (check-in: 4888957baf user: stephan tags: trunk) | |
| 16:20 | Remove duplicated JS binding of sqlite3changeset_apply_v2(). (check-in: 2e8336b6e1 user: stephan tags: wasm-session-api) | |
| 15:28 | Add the address of the associated db handle to the sqlite3_trace_v2() output originating from sqlite3.oo1.DB's trace flag. (check-in: 0a36568c5a user: stephan tags: wasm-session-api) | |
| 15:14 | Update the session-related JS bindings to account for today's internal API changes. (check-in: be63944d41 user: stephan tags: wasm-session-api) | |
| 14:13 | Merge trunk into wasm-session-api branch. (check-in: 7f8f1acd82 user: stephan tags: wasm-session-api) | |
| 14:04 | Add missing sqlite3_context_db_handle() JS binding. Reimplement sqlite3_set_authorizer() and sqlite3_set_auxdata() JS bindings to take advantage of [7f9ace1b11a67]. Teach FuncPtrAdapter to emit a console.warn() message if it is invoked after the library is bootstrapped, the goal being to inform users that it's an internal API and should not be invoked from client-side code. (check-in: 8e3d4f6294 user: stephan tags: trunk) | |
| 12:51 | Enhance sqlite3.wasm.xWrap.FuncPtrAdapter to be able to handle sqlite3_create_function() and friends and reimplement those bindings to use this feature (this will also simplify certain session API bindings). Interal API changes only with no client-side breakage. (check-in: 7f9ace1b11 user: stephan tags: trunk) | |
| 10:22 | Simplify the signature for JS functions, as opposed to function pointers, passed to sqlite3_exec(), eliminating the superfluous initial two arguments. Update related tests to demonstrate both function-passing approaches. (check-in: e7cc70cdda user: stephan tags: trunk) | |
|
2022-12-24
| ||
| 15:34 | Incorporate wasi-sdk RANLIB configure script patch from the VMware OCTO team. (check-in: 478fe96ee7 user: stephan tags: wasi-patches) | |
| 15:31 | Merge trunk into wasi-patches branch. (check-in: 52f40ab12e user: stephan tags: wasi-patches) | |
| 15:28 | Replace JS-side use of SQLITE_TRANSIENT with the new SQLITE_WASM_DEALLOC, reducing the amount allocation/copying required by sqlite3_bind_blob/text() and sqlite3_result_blob/text(). Remove the 'experimental' log message from the virtual table tests. (check-in: ffe2999a91 user: stephan tags: trunk) | |
| 14:16 | Extend oo1.Stmt.bind() to accept ArrayBuffer instances to bind as blobs. (check-in: f76bd30137 user: stephan tags: trunk) | |
| 13:46 | Add a test for the (failure) case of client-level code calling the oo1.Stmt constructor directly. (check-in: 6a37874db0 user: stephan tags: trunk) | |
| 11:16 | oo1.DB.exec() rowMode="$columnName": a minor optimization and a preemtive fix for a hypothetical corner-case bug. (check-in: 0b2df22bd9 user: stephan tags: trunk) | |
| 01:59 | If sqlite3.oo1.DB.exec()'s callback returns a literal false, stop step()ing over results as if the end of the result set had been reached. Unrelated minor code-adjacent cleanups. (check-in: 33a58c8ece user: stephan tags: trunk) | |
|
2022-12-23
| ||
| 23:46 | Reimplement JS's sqlite3_bind_text/blob() with hand-written bindings to permit more flexible inputs. Add automated JS-to-C function conversion to sqlite3_busy_handler(). sqlite3.wasm.xWrap()'s '*' argument conversion no longer treats JS strings as C-strings: those conversions require explicit opt-in via the 'string' converter (or equivalent). (check-in: 96ba44946b user: stephan tags: trunk) | |
| 21:23 | Merge trunk into wasm-session-api branch. (check-in: 6cdb036d8e user: stephan tags: wasm-session-api) | |
| 21:10 | Internal JS cleanups. Correct part of [ac136925a645] to account for the eTextRep flag being able to hold flags other than the encoding. (check-in: 1dfc03ab1e user: stephan tags: trunk) | |
| 19:33 | Merge trunk into wasm-session-api branch. (check-in: f1decc831f user: stephan tags: wasm-session-api) | |
| 19:16 | Consolidate/unify how the JS bindings of the create_function/collation family of functions react to a non-UTF8 encoding: they now treat a falsy value as SQLITE_UTF8 and fail with SQLITE_FORMAT for an invalid encoding. (check-in: deffe6fb21 user: stephan tags: trunk) | |
| 19:11 | Add base64() and base85() to shell sources for the non-configured makefiles, too. (check-in: ac136925a6 user: larrybr tags: trunk) | |
| 19:04 | Add base64() and base85() text/blob conversions to the CLI. (check-in: 4bc98a2d95 user: larrybr tags: trunk) | |
| 18:38 | Explicitly omit threading and extension loading from the ext/wasm/c-pp binary build to avoid a link error on some systems. (check-in: 5d9a14715c user: stephan tags: trunk) | |
| 18:25 | Add SQLITE_ENABLE_MATH_FUNCTIONS to the list of feature flags in sqlite3-wasm.c. (check-in: 58503cd148 user: stephan tags: trunk) | |
| 18:19 | Cherry-pick [c4dab53b8ea3401abd] for sqlite3.wasm.xWrap() optimizations. (check-in: 9b97412d3a user: stephan tags: trunk) | |
| 18:14 | Internal cleanups and minor speed optimizations in the sqlite3.wasm.xWrap() infrastructure. (check-in: c4dab53b8e user: stephan tags: wasm-session-api) | |
| 14:49 | Fix lots of harmless, nuisance compiler warnings, mostly unused parameter warnings in extensions. (check-in: c14bbe1606 user: drh tags: trunk) | |
| 14:11 | Add sqlite3.capi JS bindings for the sqlite3session_...(), sqlite3changeset_...() and sqlite3changegroup_...() APIs, noting that they are completely untested. Aside from missing tests, these bindings reveal a slight string-argument-type shortcoming in the callback function pointer "reverse binding" which should ideally be resolved before publishing them. (check-in: 0a39172ee1 user: stephan tags: wasm-session-api) | |
| 11:46 | Additional fixes for yet more completely harmless compiler warnings. (check-in: 7d3772f0bd user: drh tags: trunk) | |
| 11:46 | Initial pieces for binding the session API to JS. Far from complete. See forum post 210e36a1e3 for the discussion. (check-in: cd8c100808 user: stephan tags: wasm-session-api) | |
| 11:32 | Squelch a new (and, in this case, harmless) compiler warning. (check-in: a02e19dd6c user: stephan tags: trunk) | |
|
2022-12-22
| ||
| 21:32 | Asserts added to ensure that the iCompare variable in the bytecode engine is correctly initialized before it is used. (check-in: 7b5900a111 user: drh tags: trunk) | |
| 19:12 | Avoid having to reinitialize Vdbe.pResultRow upon each call to sqlite3_step() for a small size reduction and performance increase. (check-in: 6a00d67f59 user: drh tags: trunk) | |
| 18:44 | Rename the Vdbe.pResultSet field to pResultRow in order to better distinguish it from other variables with similar names. (check-in: 1fd6211ef7 user: drh tags: trunk) | |
| 18:35 | Small performance optimization associated with shared cache in the byte-code engine. (check-in: 3181331c1c user: drh tags: trunk) | |
| 17:36 | Small performance optimization on the OP_Insert opcode. (check-in: 781fdcb9ce user: drh tags: trunk) | |
| 10:53 | sessionfuzz.c: use lt/gt brackets instead of double-quotes when #including zlib.h, as reported in forum post 91a104bd65. (check-in: 7d7780c350 user: stephan tags: trunk) | |
|
2022-12-21
| ||
| 21:01 | Merge the latest trunk enhancements into the reuse-schema branch. (check-in: 1bfae9b3c6 user: drh tags: reuse-schema) | |
| 20:43 | Merge the latest trunk enhancements into the begin-concurrent-pnu-wal2 branch. (check-in: bcab19d21b user: drh tags: begin-concurrent-pnu-wal2) | |
| 20:28 | Merge the latest trunk enhancements into the wal2 branch. (check-in: 21ebd4cfcf user: drh tags: wal2) | |
| 20:17 | Merge the latest trunk enhancements into the begin-concurrent-report branch. (Leaf check-in: 397fb07bb4 user: drh tags: begin-concurrent-report) | |
| 20:07 | Update the begin-concurrent branch with the latest enhancements on trunk. (check-in: 0c198aee53 user: drh tags: begin-concurrent) | |
| 19:11 | More efficient implementation of large precisions on the "%c" format for the built-in printf(). This is an effort to avoid a reported timeout on a (ridiculous) query generated by OSSFuzz. (check-in: 371f9b8838 user: drh tags: trunk) | |
| 18:28 | Sync w/trunk prior to branch-purpose changes. (Leaf check-in: ae8f623f74 user: larrybr tags: extension_opts) | |
| 14:13 | Ensure that the expression of a virtual column really is an expression and not just a reference to another column, as a real expression is necessary for the indexed expression coverage optimization to work properly. Forum thread 07b36e3899a9ae21. (check-in: 40549bacb3 user: drh tags: trunk) | |
| 12:18 | New WHERETRACE entries for adding and removing objects from the Parse.pIdxEpr list as part of indexed expression coverage. Debug and testing changes only - no affect on production builds. (check-in: 4dc438a951 user: drh tags: trunk) | |
|
2022-12-20
| ||
| 15:22 | Add about 150 new fuzzer cases to test/fuzzdata8.db. (check-in: a8d8d9cd65 user: drh tags: trunk) | |
| 15:02 | Add ALWAYS() to always-true branches in the locking logic of the memdb VFS. (check-in: 01fa760212 user: drh tags: trunk) | |
| 14:02 | Improvement to the dbsqlfuzz fix of [f113eebdbe68246f]. (check-in: 79d62956f2 user: drh tags: trunk) | |
| 01:48 | Do not use indexed expressions to replace the expression being indexed on a RIGHT JOIN as that leads to problems, as shown by dbsqlfuzz a644e70d7683a7ca59c71861a153c1dccf8850b9. (check-in: f113eebdbe user: drh tags: trunk) | |
|
2022-12-19
| ||
| 20:14 | Fix a faulty assert() in fts5. (check-in: 569018170b user: dan tags: trunk) | |
| 19:04 | Remove an unused variable. (check-in: 5c4d94147d user: drh tags: trunk) | |
| 14:46 | Minor sed script tweak in the wasm GNUmakefile for BSD portability, as reported in forum post 4a97813fcbd4f63e. (check-in: 49efcf6d9f user: stephan tags: trunk) | |
| 14:43 | Update test-opfs-vfs.js to account for recent API changes. Reported in forum post 4a97813fcbd4f63e. (check-in: 2a63674636 user: stephan tags: trunk) | |
| 14:06 | Fix an assert() in fts5. Simplify memdb xLock/xUnlock some. (check-in: 7fe158aa80 user: dan tags: trunk) | |
| 12:25 | Fix a minor problem with the printAggInfo() routine (used on during debugging). (check-in: c8329967f3 user: drh tags: trunk) | |
|
2022-12-18
| ||
| 12:00 | JS namespace updates in ext/wasm/api/README.md. (check-in: ca59e736b1 user: stephan tags: trunk) | |
|
2022-12-17
| ||
| 22:10 | Fix an unnecessarily restrictive assert() in the aggregate logic. dbsqlfuzz 699bee2aa26c5dc84afabf6894685c316d936485 (check-in: 8cc0af81ad user: drh tags: trunk) | |
| 19:56 | Remove slew of inadvertant tabs in favor of spaces. (check-in: 0aa6da69e1 user: larrybr tags: trunk) | |
| 12:49 | Add NEVER/ALWAYS to branches that have become unreachable due to recent enhancements. (check-in: b4281db4e4 user: drh tags: trunk) | |
| 11:14 | Update wasmfs.make to get WASMFS building again, but changes made to OPFS-over-WASMFS since we last tested it have made it incompatible with how we used it. It can now only be used from worker threads, eliminating the one benefit it had over the sqlite3_vfs OPFS implementation. Remove/amend references to WASMFS in the docs and remove all WASMFS-specific test app links from index.html. (check-in: 32dc98c800 user: stephan tags: trunk) | |
|
2022-12-16
| ||
| 18:32 | Disallow some of the query invariant tests on SQL statements that contain a GROUP BY since output terms that are no covered by the GROUP BY are indeterminant. (check-in: 28ba1fec45 user: drh tags: trunk) | |
| 13:04 | Expose a JS-friendly subset of sqlite3_config() to JS, with the notable caveats that (1) setting up the JS bindings requires starting the library, making sqlite3_config() illegal to call and (2) calling sqlite3_shutdown() in order to make it legal to call sqlite3_config() may undo certain JS-side library initialization. Move sqlite3_(de)serialize() into the int64-mode-only bindings because of their int64 args. (check-in: 62e0c931ac user: stephan tags: trunk) | |
| 12:07 | In the fuzzer invariant checker, do not add new WHERE clause terms that make use of an ambiguous column name. (check-in: d5b46541c3 user: drh tags: trunk) | |
| 11:33 | Add a test confirming that exceptions are not passed through C-space if a JS-side sqlite3_set_authorizer() callback throws. (check-in: 5a77c2c7aa user: stephan tags: trunk) | |
| 11:13 | Add sqlite3_set_authorizer() support and related tests to JS. (check-in: 551b848894 user: stephan tags: trunk) | |
|
2022-12-15
| ||
| 20:03 | Create a new affinity called FLEXNUM that works like NUMERIC except that it never tries to convert integer to real or real to integer. The affinity is only used internally - it is not possible to create a table column with this affinity. This affinity is used on subqueries and views that are built off of a compound SELECT and where the datatype is controlled by a CAST expression. dbsqlfuzz c9ee6f9a0a8b8fefb02cf69de2a8b67ca39525c8 (check-in: 44135d6ea8 user: drh tags: trunk) | |
| 18:56 | Fix an incompatibility between the Tcl interface and the "memdb" vfs by allowing memdb to accept filenames that begin with '\' characters. (check-in: bd537f2057 user: dan tags: trunk) | |
| 18:50 | Added a couple missing 'not part of the public API' tags on functions in sqlite3-wasm.c. No code changes. (check-in: eb27feecea user: stephan tags: trunk) | |
| 15:37 | Omit the columnTypeImpl() function from the build when SQLITE_OMIT_DECLTYPE is defined, because it is no longer used in that case. (check-in: 751e344f4c user: drh tags: trunk) | |
| 13:45 | Fix harmless compiler warnings. (check-in: ddb260cc52 user: drh tags: trunk) | |
| 11:39 | Update a test case in scanstatus2.test to account for recent planner enhancements. (check-in: 53e07dc6b6 user: dan tags: trunk) | |
| 11:31 | Fix an unsafe use of sqlite3_mprintf() in sqlite3_overload_function() identified by forum post: https://sqlite.org/forum/forumpost/95b338860d. (check-in: 9fa2b94c2e user: dan tags: trunk) | |
| 02:28 | Internal refactoring of how sqlite3.wasm.xWrap() handles JS-to-C function pointer conversions, to enable similar conversions to be added more easily. (check-in: 10cfe3fae6 user: stephan tags: trunk) | |
| 02:26 | Remove an unnecessary/obsolete Emscripten-specific export. (check-in: fa278022af user: stephan tags: trunk) | |
|
2022-12-14
| ||
| 23:53 | Fix minor problems in the new sqlite3ExprDataType() function. (check-in: c1d5261b22 user: drh tags: trunk) | |
| 18:34 | Adjust the query planner to be more aggressive about using co-routines rather than materializing subqueries and views. Implementation of enhancement request [73ebbb3a3d1a7bd3]. (check-in: 0b58d1b354 user: drh tags: trunk) | |
| 18:06 | Rename the new peek/pokeF32() and peek/pokeF64() to peek/poke32f() and peek/poke64f() for consistency with related APIs and because they're easier on both the eyes and the fingers. (check-in: cc86f03ed6 user: stephan tags: trunk) | |
| 17:52 | Merge all the latest trunk enhancements into the coroutines-exp2 enhancement branch. (Closed-Leaf check-in: ea278438b7 user: drh tags: coroutines-exp2) | |
| 17:46 | Rework the code that computes the datatypes and affinities for subqueries and views. If the subquery/view is constructed from a compound SELECT where the affinity varies across arms of the compound, set the affinity for the corresponding column in the constructed view to be BLOB so that it is allowed to take on any data type. (check-in: 27655c9353 user: drh tags: trunk) | |
| 16:40 | Slight reformulation of some test code to test multi-arg wasm.peek() call form. (check-in: 349bb28f61 user: stephan tags: trunk) | |
| 14:41 | If the SELECT that implements a subquery or a VIEW or a CREATE TABLE AS is a compound with different result datatypes on two or more arms of the compound, then the overall column type becomes BLOB (ANY). (Closed-Leaf check-in: 6ebb178c6b user: drh tags: refactor-subquery-types) | |
| 14:40 | Use the new peek/poke() variants throughout tester1.js. (check-in: ef7b783552 user: stephan tags: trunk) | |
| 14:28 | Add convenience variants of sqlite3.wasm.peek/poke() for each numeric type to help reduce errors related to typos in the final argument (type-name strings). If wasm.xWrap.FuncPtrAdapter is called as a function, instead of a constructor, it now behaves as if it were called as a constructor (previously it threw an exception). (check-in: 14e3fc01b9 user: stephan tags: trunk) | |
| 09:06 | Back out the part of the change in [88a05141c28e5ff1] that adds affinity to the materialization of a view, as the affinity can be undefined for a compound query. This passes all TCL tests, but shows failures in the TH3 tests derived from forum post 6f842bc5b2dadcb2, presumably because the WHERE clause of the query uses constraints of the form "source_crs_code='8675'" instead of "source_crs_code=8675". Perhaps further changes on this branch should reimplement affinity on joins in cases where the affinity is unambiguous. (check-in: fe5a77bcc4 user: drh tags: refactor-subquery-types) | |
| 08:12 | Add a test to demonstrate/verify which object acts as "this" in a oo1.DB.exec() callback. (check-in: 8fc4b3f10f user: stephan tags: trunk) | |
| 08:01 | A micro-optimization in sqlite3.oo1.DB.exec(). Changed the rowMode option of that method to only accept $X instead of $X, @X, and :X, as the extra options are entirely superfluous and may lead to confusion. (check-in: 82a6c7fdf5 user: stephan tags: trunk) | |
|
2022-12-13
| ||
| 19:52 | Fix a comment in ext/session/test_session.c. (check-in: bd814af14b user: dan tags: trunk) | |
| 19:40 | Prevent the sessions rebaser from generating changesets containing UPDATE records for which non-PK fields are present in the old.* but not the new.* record. Also update the changeset iterator to work around such changesets. (check-in: f9cd23dffb user: dan tags: trunk) | |
| 16:59 | Remove an unused variable from sqlite3SubqueryColumnTypes(). (check-in: c6e3ff3969 user: drh tags: refactor-subquery-types) | |
| 16:55 | Use standard datatype names for the column datatypes in views and subqueries. (check-in: baf2c24133 user: drh tags: refactor-subquery-types) | |
| 15:54 | Refactor the sqlite3SelectAddColumnTypeAndCollation() routine. Improved comments. Now called sqlite3SubqueryColumnTypes(). (check-in: 4dfb1b450b user: drh tags: refactor-subquery-types) | |
| 14:59 | Add extra test cases for applying sessions module changesets to databases that have been modified using "ALTER TABLE .. ADD COLUMN". (check-in: a7b404f21f user: dan tags: trunk) | |
| 13:33 | Slightly faster implementation of sqlite3ExprAffinity(). (check-in: 01cf3278c9 user: drh tags: trunk) | |
| 10:54 | Document the role of the sqlite3.client JS API property. (check-in: 5f11f1c7d5 user: stephan tags: trunk) | |
| 08:25 | Extend the sqlite3.wasm function pointer argument converter to be able to handle the "two-layered context" of sqlite3_create_collation() and friends and make use of FuncPtrAdapter to perform JS-to-WASM function conversion for them. (check-in: 0a60b7215e user: stephan tags: trunk) | |
| 00:51 | Merge recent trunk changes into the coroutine-exp2 branch. (check-in: c43f433bca user: drh tags: coroutines-exp2) | |
|
2022-12-12
| ||
| 21:22 | Further fix for ticket [57c47526c34f01e8]. If a subquery has a result set column of the form "CAST(expr AS NUMERIC)" do not give that column NUMERIC affinity. NUMERIC affinity always goes to an integer if able, but a CAST to numeric is a no-op if the input is a number. So the two are not equivalent. (check-in: f0325359d5 user: drh tags: trunk) | |
| 18:58 | If a subquery has a result column of the form "CAST(... AS NUMERIC)" then give that column no affinity rather than NUMERIC affinity. This is because casting to numeric preserves real values that could be integers but numeric affinity does not. By using no affinity on the column, we make the behavior consistent if the subquery is implemented as a co-routine or is materialized. (Closed-Leaf check-in: ece07d091c user: drh tags: cast-to-numeric) | |
| 18:42 | Revert part of [9386d6f63468] because the new automatic function pointer binding cannot properly track per-context function mappings when the context is more complex than a single context-type pointer. e.g. it is fine for sqlite3_trace_v2() but it breaks down with sqlite3_create_collation() because that one needs to use the collation name as part of the context key and we cannot sensibly do so with the current code. (check-in: 6cd21b7907 user: stephan tags: trunk) | |
| 17:33 | Add new logging code SQLITE_NOTICE_RBU and use it when logging for the spurious error that RBU injects into SQLite as part of applying an update. (check-in: cd881d3515 user: dan tags: trunk) | |
| 14:31 | Move JS-to-C binding signatures from sqlite3-api-prologue.js to sqlite3-api-glue.js to allow for use of the new/experimental sqlite3.wasm.xWrap() feature which automatically binds JS functions to WASM/C as needed, which simplifies creation of bindings which take C function pointers. Reimplement sqlite3_exec(), sqlite3_create_collation(), sqlite3_progress_handler() to use this new feature. (check-in: 9386d6f634 user: stephan tags: trunk) | |
| 11:38 | ext/wasm/module-symbols.html: for C APIs which have extended JS-side semantics, link to the JS-side API docs instead of the C docs. (check-in: d557015208 user: stephan tags: trunk) | |
| 11:22 | ext/wasm/module-symbols.html: add a hyperlink to the API docs for each exported sqlite3_...() function. (check-in: 01d3a9bba3 user: stephan tags: trunk) | |
| 08:16 | Rework the internals of how argument/result types are converted to/from wasm in prep for attempting to support automated conversions of function pointer argument types. (check-in: 58052d8285 user: stephan tags: trunk) | |
| 07:52 | Add sqlite3.mjs to the new 'quick' wasm build for the sake of the snapshot build. (check-in: 5a3f2224c3 user: stephan tags: trunk) | |
| 07:31 | Expose sqlite3_txn_state() to wasm. (check-in: f6f3397a46 user: stephan tags: trunk) | |
| 07:27 | Expose a number of infrequently-used sqlite3_...() functions to wasm whose absences were noticed while documenting. (check-in: 3144e7c0b8 user: stephan tags: trunk) | |
|
2022-12-11
| ||
| 07:53 | Minor build tweaks in ext/wasm to create a faster-running build for the common dev-mode cases. No code changes. (check-in: 6a61b14a6c user: stephan tags: trunk) | |
|
2022-12-10
| ||
| 19:22 | Ensure that the types and collation sequences of a view are taken from the leftmost component of compound SELECTs, even when column names are explicitly provided for the view. Fix for ticket [679ed6a282a97c51] (check-in: 6f0bf89269 user: dan tags: trunk) | |
| 17:54 | Ensure that the types and collation sequences of a view are taken from the leftmost component of compound SELECTs, even when column names are explicitly provided for the view. Possible fix for [679ed6a2]. (Closed-Leaf check-in: b0e49aa81a user: dan tags: tkt-679ed6a2) | |
| 17:45 | Remove -flto from wasm build flags, as it increases build time and doesn't seem to have a measurable benefit. (check-in: 35a88747eb user: stephan tags: trunk) | |
| 17:20 | Correct wasm heap corruption introduced in test code added in [e144fd5c88fa4] which led to unpredictable failures. (check-in: 6c1e07e385 user: stephan tags: trunk) | |
| 15:41 | Remove two incorrect calls to structType.dipose() which prematurely freed objects in use by the virtual table test/demo code. (check-in: 060eb28489 user: stephan tags: trunk) | |
| 15:13 | Expose sqlite3_column_value() to WASM and add sqlite3_column_js(). (check-in: 7783aa4af1 user: stephan tags: trunk) | |
| 12:06 | Rerun autoconf using version 2.69 to minimize configure script differences with trunk. (check-in: b633428394 user: drh tags: wasi-patches) | |
| 10:24 | Refactor the internal JS routines for converting UDF results and errors to JS into public APIs. (check-in: 35d1d63c7d user: stephan tags: trunk) | |
| 07:02 | Imply configure flag --disable-shared when --with-wasi-sdk is active because libtool is running gcc for linking the shared lib, which cannot work in a wasi build. (check-in: 9253ba43c0 user: stephan tags: wasi-patches) | |
| 06:44 | Add --with-wasi-sdk=DIR flag to configure.ac. This mode compiles but fails to link the DLL because libtool is apparently hard-coded to gcc for the DLL. (check-in: 39c9f44151 user: stephan tags: wasi-patches) | |
| 05:52 | Run configure.ac through autoupdate, as required by autoconf for rebuilding configure. These (many) changes were made entirely by the autotools, except that some whitespace-only changes were reverted by hand to reduce noise, and are a preliminary step to adding a new flag to configure.ac. (check-in: 2be2d5d428 user: stephan tags: wasi-patches) | |
| 05:00 | Merge trunk into wasi-patches branch. (check-in: 13dade955d user: stephan tags: wasi-patches) | |
|
2022-12-09
| ||
| 18:26 | Remove the SQLITE_PREPARE_SAFEOPT flag. The name is obsolete and it is at the wrong level. Instead use the SF_UpdateFrom flags on the Select object. (check-in: 78723a9a7e user: drh tags: coroutines-exp2) | |
| 17:33 | Do not allow OOM faults in EQP messages associated with automatic indexes on co-routines to go unreported. (check-in: d125d5afdf user: drh tags: coroutines-exp2) | |
| 15:26 | Export sqlite3_result_subtype() and sqlite3_value_dup/free/subtype() to WASM. (check-in: 4600a7bbdc user: stephan tags: trunk) | |
| 15:12 | Expose sqlite3_value_frombind/nochange/numeric_type() to WASM. Add a flag to sqlite3_value_to_js() to cause it to return undefined, instead of throwing, if no conversion can be found. (check-in: de8fc4bf34 user: stephan tags: trunk) | |
| 14:46 | Refactor the sqlite3_value-to-JS conversion from an internal detail to sqlite3.capi.sqlite3_value_to_js() for use with routines like sqlite3_module::xFilter(). (check-in: f6dbf280f9 user: stephan tags: trunk) | |
| 13:49 | Fix typo in the SQLITE_DBCONFIG_LOOKASIDE documentation. (check-in: c6e7582aea user: drh tags: trunk) | |
| 12:12 | Remove some unused sqlite3_status() codes from the JS API. Add custom JS wrappers for sqlite3_create_collation/_v2() which accept JS functions (plus tests). Expand the argument options for sqlite3_wasm_db_error() to enable it to translate exception objects to C-level errors. (check-in: 073a2f1eb0 user: stephan tags: trunk) | |
| 09:23 | Rename the oft-used, verbose sqlite3.wasm.get/setMemValue() and get/setPtrValue() to peek/poke() and peek/pokePtr(). The old names are retained as aliases just in case any client code actually uses them, but they are now deprecated. (check-in: ad0a8139b0 user: stephan tags: trunk) | |
| 08:44 | Micro-optimization in the oft-activated JS-to-WASM arguments conversion step. (check-in: ee47e9b83c user: stephan tags: trunk) | |
| 07:17 | Correct a test bug which broke the previous checkin's wasm tests in higher optimization levels. Test bug - it should not have worked in -O0 mode. (check-in: f07141b750 user: stephan tags: trunk) | |
| 05:47 | Export sqlite3_status() and sqlite3_stmt_status() to wasm. Expand the arg/return semantics of wasm.get/setPtrValue() and get/setMemValue() to simplify handling of multiple pointers. Edit: tests pass when built with -O0 but fail with -Oz. Moving to branch to work out the breakage. Edit: it was a test bug - one too many levels of pointer indirection. It shouldn't have worked in low-optimization mode. (check-in: e144fd5c88 user: stephan tags: trunk) | |
| 02:23 | JS API doc updates. (check-in: 4f80fd3b8d user: stephan tags: trunk) | |
| 02:12 | Expose sqlite3_table_column_metadata() to wasm. (check-in: c31eb509e5 user: stephan tags: trunk) | |
| 01:49 | Expose sqlite3_db_status() and sqlite3_db_config() to wasm, noting that the latter requires several internal wrappers to account for the various varidic forms (C varargs cannot be bound to wasm). (check-in: d575366891 user: stephan tags: trunk) | |
| 00:50 | Reorganization and renaming in the new VFS/vtab JS pieces. (check-in: 1c2dda177a user: stephan tags: trunk) | |
|
2022-12-08
| ||
| 21:05 | Support ".scanstats est" to enable including planner estimates in query profiles. (check-in: 0fe71287c9 user: dan tags: trunk) | |
| 18:18 | Further docs and minor cleanups in the JS virtual table helper. (check-in: c31e7488ac user: stephan tags: trunk) | |
| 17:07 | Ease-of-use/legibility improvements in the virtual table JS helpers. (check-in: 54c7ad7e08 user: stephan tags: trunk) | |
| 16:47 | Improved comments on the new co-routine logic. Fix a C++-ism in the code. Update test cases to accommodate the more aggressive use of co-routines. (check-in: 9243e850ae user: drh tags: coroutines-exp2) | |
| 15:00 | Initial support for virtual tables implemented in JavaScript. (check-in: a1454744c7 user: stephan tags: trunk) | |
| 13:56 | Do not use a co-routine on a subquery that is participating in a self-join. (check-in: ea4306a03c user: drh tags: coroutines-exp2) | |
| 12:51 | Describe the SQLITE_DBCONFIG_RESET_DATABASE flag's policy regarding virtual tables, per /chat discussion. (check-in: 53dcb81b02 user: stephan tags: trunk) | |
| 10:06 | More work on the JS vtable tests. (Closed-Leaf check-in: 51e3c3b569 user: stephan tags: wasm-vtab) | |
| 09:06 | Got JS non-eponymous vtable working thanks to a hint from Dan. (check-in: 750719b498 user: stephan tags: wasm-vtab) | |
| 04:19 | Remove some dead JS code and tweak some docs. (check-in: 0ee495452c user: stephan tags: wasm-vtab) | |
|
2022-12-07
| ||
| 21:19 | Merge the latest fixes and enhancements from trunk into the coroutines-exp2 branch. (check-in: 1c5f41986f user: drh tags: coroutines-exp2) | |
| 20:09 | Reduce the overhead of SQLITE_ENABLE_STMT_SCANSTATUS some. (check-in: 212927e97e user: dan tags: trunk) | |
| 19:51 | Fix harmless compiler warning in the dynamic continuation prompt of the CLI. (check-in: 68947b0a11 user: drh tags: trunk) | |
| 19:29 | Omit CLI use of pragma_table_xinfo when it is not defined in the build. (check-in: 976c23520f user: larrybr tags: trunk) | |
| 17:29 | Have sqlite3_stmt_scanstatus() report cycle, loop and row counts separately for creating an automatic index and using that automatic index. (check-in: 3bc9df82ea user: dan tags: trunk) | |
| 16:58 | Streamline and improve testing of the locking in the memdb VFS. Follow-on to [15f0be8a640e7bfa]. (check-in: d71a08375a user: drh tags: trunk) | |
| 07:22 | Work on an alternate (slightly simpler) approach to binding JS vtabs. Non-eponymous vtabs are not working, for reasons as yet unknown. (check-in: 6a0fefb93b user: stephan tags: wasm-vtab) | |
| 03:42 | Add addOnDispose() method to Jaccwabyt and code-adjacent minor internal cleanups. (check-in: 6a2723fe3f user: stephan tags: wasm-vtab) | |
| 00:14 | Fix a (harmless) off-by-one error in code generation that comes up when doing a DISTINCT query against a virtual table with an OR term in the WHERE clause and where the ORDER BY clause has 64 or more references to the result set. Forum post dfe8084751. NB: The bug is "harmless" in the sense that no harm comes of it in a production build. However, an assertion fault might occur in a debugging build given some really wonky SQL inputs without this fix. (check-in: 04af7ef770 user: drh tags: trunk) | |
|
2022-12-06
| ||
| 19:32 | Enhance CLI .sha3sum to warn of text fields that are not to-blob-to-text reversible. (check-in: bbde0f36d0 user: larrybr tags: trunk) | |
| 19:25 | Merge from trunk prepratory to branch end. (Closed-Leaf check-in: 1d01f8483a user: larrybr tags: sha3sum_text_validation) | |
| 19:20 | Avoid several -Wall warnings in textfixture build. (check-in: 03ae8680e4 user: larrybr tags: trunk) | |
| 18:48 | For CLI .sha3sum, emit warning to stderr for any invalidly encoded text fields. (check-in: 8e833ecc81 user: larrybr tags: sha3sum_text_validation) | |
| 18:48 | Have sqlite3_stmt_scanstatus_v2() return an NCYCLE value for all loops, not just virtual tables ones. The value returned is the sum of the NCYCLE counts for the various opcodes that move or read data from the table or index cursor associated with the loop. (check-in: 9499b2f51e user: dan tags: trunk) | |
| 17:59 | Clear a few more -Wall warnings and simplify dynaprompt feature keep/omit macros. (check-in: 540e895d87 user: larrybr tags: trunk) | |
| 15:24 | Simplified experimental changes to promote the use of co-routines. Less cruft than the coroutines-exp1 branch, but still does not work. Checked in as a work-in-progress. (check-in: e2318a30bf user: drh tags: coroutines-exp2) | |
| 15:11 | Fix compiler warnings in the new dynamic continuation prompt logic of the CLI. (check-in: 0d80500d35 user: drh tags: trunk) | |
| 13:12 | In the unix backend, when implementing the defenses against small file descriptors, delete a file just created if it was opened with O_EXCL|O_CREAT so that it can be created again the next time through the loop. Fix for the problem described by forum post 699af709ab3a8ccf. (check-in: c0cfe0582a user: drh tags: trunk) | |
| 11:41 | Support an SQLITE_SCANSTAT_NCYCLE statistic for "CO-ROUTINE" elements. (check-in: d3f6a207fd user: dan tags: trunk) | |
| 11:21 | JS vtables: add infrastructure related to accessing and modifying sqlite3_index_info. (check-in: 0d77c34803 user: stephan tags: wasm-vtab) | |
| 09:49 | Remove deprecated symbol sqlite3.opfs.OpfsDb, which was renamed to sqlite3.oo1.OpfsDb on 2022-11-29. (check-in: 0ce51bed65 user: stephan tags: wasm-vtab) | |
| 08:46 | Rename wasm.cstringToJs() to wasm.cstrToJs() for consistency with other wasm.cstr... APIs. (check-in: cbf483ea0b user: stephan tags: wasm-vtab) | |
| 08:39 | Add wasm.cArgvToJs() to support sqlite3_module::xConnect(). (check-in: c3ebdccf94 user: stephan tags: wasm-vtab) | |
| 08:21 | Minor internal JS code/docs cleanups. (check-in: 21331bdd36 user: stephan tags: wasm-vtab) | |
| 06:21 | Merge trunk into wasm-vtab branch. (check-in: d106edb956 user: stephan tags: wasm-vtab) | |
| 06:16 | Minor test tweaks. (check-in: f902f3b2c7 user: stephan tags: wasm-vtab) | |
| 06:09 | Add a demonstration sqlite3_vtab/module implemented in JS, based on ext/misc/templatevtab.c. Add oo1.selectArrays() and selectObjects(). (check-in: 60482c97e0 user: stephan tags: wasm-vtab) | |
| 05:31 | Add optional feature: A CLI continuation prompt which reflects open lexemes and parens, similarly to PG shell. (check-in: f41f18b1c3 user: larrybr tags: trunk) | |
| 05:09 | Add optional feature: A CLI continuation prompt which reflects open lexemes and parens, similarly to PG shell. (Leaf check-in: dac2ddc287 user: larrybr tags: dynamic_prompt) | |
| 00:54 | Highly experimental (and non-working) changes aimed at increasing the number of occasions where a subquery can be implemented using a co-routine rather than being materialized. This is just saving work in progress. (Closed-Leaf check-in: e7d323c16e user: drh tags: coroutines-exp1) | |
|
2022-12-05
| ||
| 19:16 | Enhance the sqlite3_stmt_scanstatus() API and add sqlite3_stmt_scanstatus_v2(). For creation of enhanced query performance reports. (check-in: 4893b4e3ea user: dan tags: trunk) | |
| 18:52 | Update comments in sqlite.h.in to account for sqlite3_stmt_scanstatus_v2(). (Closed-Leaf check-in: 009462f234 user: dan tags: scanstatus_v2) | |
| 18:26 | Merge latest trunk changes. (check-in: 1a72777b12 user: dan tags: scanstatus_v2) | |
| 18:19 | Add loops and rows counters to "USE TEMP B-TREE FOR ORDER BY" records. Also fix the sqliteHwtime() function so that it returns a 64-bit value. (check-in: 41a0e05e8c user: dan tags: scanstatus_v2) | |
| 15:05 | Remove two features of jaccwabyt which were fundamentally flawed, along with approx. 250 lines of unit tests which heavily relied on them. Thankfully, none of the sqlite3.js-level code used those bits. (check-in: a190abc307 user: stephan tags: wasm-vtab) | |
| 14:32 | Jaccwabyt (JS) doc updates. (check-in: a329a809b5 user: stephan tags: wasm-vtab) | |
| 14:23 | Fix a problem in the memdb vfs xLock() function allowing clients to upgrade to EXCLUSIVE locks when other connections are holding SHARED. (check-in: d18cce37b5 user: drh tags: branch-3.40) | |
| 14:20 | Regenerate the configure script so that it includes the correct patch number. (check-in: e2ae2ea195 user: drh tags: branch-3.40) | |
| 14:20 | Add test case that should have been part of previous commit. (check-in: dc7dd2d3e5 user: dan tags: trunk) | |
| 14:13 | Expose sqlite3_get/set_auxdata() to wasm. Minor test app CSS tweaks. (check-in: 44659ad32a user: stephan tags: wasm-vtab) | |
| 14:12 | Fix a problem in the memdb vfs xLock() function allowing clients to upgrade to EXCLUSIVE locks when other connections are holding SHARED. Forum post 5adb92e2baca3678. (check-in: 15f0be8a64 user: dan tags: trunk) | |
| 13:33 | Export collation-related APIs and strncmp()/strnicmp() to wasm. (check-in: c3c56d9b94 user: stephan tags: wasm-vtab) | |
| 13:12 | Export sqlite3_vtab_collation() to wasm. Rename 'flexible-string' JS argument adapter to 'string:flexible' for consistency. (check-in: 15f8042fdd user: stephan tags: wasm-vtab) | |
| 13:07 | Remove SQLITE_EXPERIMENTAL tag from sqlite3_vtab_collation() and fix a related doc typo. (check-in: 35d670b359 user: stephan tags: trunk) | |
| 11:54 | Rename 'static-string' argument adapter to 'string:static'. Replace JS unit tests which were lost via editing a generated copy of tester1.js instead of the original tester1.c-pp.js input file. (check-in: 9d81d51d5a user: stephan tags: wasm-vtab) | |
| 11:30 | Export sqlite3_bind/value/result_pointer() to wasm. Add 'static-string' argument converter to support the lifetime requirements of bind/result_pointer()'s string argument. Correct an endless loop in wasm.cstrlen() when passed a non-C-string argument. (check-in: a94552434a user: stephan tags: wasm-vtab) | |
| 10:50 | Remove obsolete "experimental" comments on the virtual-table interface documentation in sqlite.h.in. (check-in: 28fc32abdc user: drh tags: trunk) | |
| 07:51 | More work on the JS side of the virtual table APIs. (check-in: cb9881ec00 user: stephan tags: wasm-vtab) | |
| 05:45 | Remove some dead code. Improve some error checks and comments. (check-in: 6712fbe46a user: stephan tags: wasm-vtab) | |
| 05:30 | Initial infrastructure for adding virtual table/table-valued function support to WASM. (check-in: c202d7a039 user: stephan tags: wasm-vtab) | |
| 02:52 | Improved query planner cost estimates. Fix for ticket [e8b674241947eb3b]. (check-in: 1b779afa3e user: drh tags: trunk) | |
| 02:42 | Use the smaller estimated row size for searching IPK tables, but use the original larger row size estimate for scanning, since the leaves can have large rows. (Closed-Leaf check-in: df3818997b user: drh tags: qp-tuning) | |
|
2022-12-04
| ||
| 23:20 | Fix safe mode authorizer callback to reject disallowed UDFs. Reported at Forum post 07beac8056151b2f. (check-in: cefc032473 user: larrybr tags: trunk) | |
| 08:16 | Export sqlite3_result_zeroblob/zeroblob64() to wasm. (check-in: a60e56627f user: stephan tags: trunk) | |
|
2022-12-03
| ||
| 21:24 | Enhance SQLITE_SCANSTAT_NCYCLE so that it reports on virtual tables. (check-in: 622d8eb372 user: dan tags: scanstatus_v2) | |
| 19:04 | Increase the nominal row size for IPK index lookups slightly, for better balance. (check-in: 1a61c500ad user: drh tags: qp-tuning) | |
| 18:21 | Add TOTAL rows to the output generated by tool/vdbe_profile.tcl. (check-in: 9800586393 user: drh tags: qp-tuning) | |
| 18:16 | Add CYCLES scanstat measurement to "USE TEMP B-TREE FOR ORDER BY" lines. (check-in: 365011ae8b user: dan tags: scanstatus_v2) | |
| 17:23 | Add a test case to show that ticket [e8b674241947eb3b] has been fixed. (check-in: e20de6d450 user: drh tags: qp-tuning) | |
| 17:19 | Make conglomerateur help with extension packaging. Otherwise a WIP check-in. (check-in: c4214d8d3c user: larrybr tags: extension_opts) | |
| 17:09 | Further improvements to the estimated cost of sorting. Take into account the number of columns to be sorted. (check-in: f3290cf83b user: drh tags: qp-tuning) | |
| 16:09 | Cause CLI .sha3sum to warn of text fields that do not survive CAST(CAST(t as BLOB) AS TEXT) due to invalid UTF encoding. (check-in: 123f2a0785 user: larrybr tags: sha3sum_text_validation) | |
| 15:41 | Correct a memory leak in tester1.js. (check-in: e42b052dd7 user: stephan tags: trunk) | |
| 14:58 | sqlite3.wasm.allocFromTypedArray() now optionally accepts an ArrayBuffer as its argument. (check-in: 75a1a796f8 user: stephan tags: trunk) | |
| 13:10 | Rename wasm.xWrap.resultAdapter() X:free entries to X:dealloc for consistency with wasm.dealloc(). Add an undocumented feature to replace wasm.alloc/dealloc/realloc() with the C-standard allocators (after an allocator misuse led down a several-hour rabbit hole trying to discover a mis-free() violation). Related test updates. (check-in: d9807656f8 user: stephan tags: trunk) | |
| 13:05 | Doc typo fix for SQLITE_MAX_ALLOCATION_SIZE in malloc.c. No code changes. (check-in: ed1ed21221 user: stephan tags: trunk) | |
| 11:51 | Move kvvfs xRead()/xWrite() buffer from function-local stack memory to heap memory to accommodate changes in emsdk 3.1.27. (check-in: f1da32410c user: stephan tags: trunk) | |
| 11:16 | JavaScript: add sqlite3.wasm.realloc(), sqlite3.capi.SQLITE_MAX_ALLOCATION_SIZE, and related tests. (check-in: eeb84ba5de user: stephan tags: trunk) | |
| 03:06 | wasm build: rename the path to the wasm docs checkout, for clarity and consistency. (check-in: b820db3236 user: stephan tags: trunk) | |
| 02:42 | wasm snapshot and doc-related build automation tweaks. (check-in: 13eb1abd06 user: stephan tags: trunk) | |
| 01:59 | Rework the oo1.DB's distinct-per-VFS post-open() step to accept either a batch of SQL or a callback function. Increase OPFS's busy timeout to 10s. (check-in: 9feefe253a user: stephan tags: trunk) | |
| 00:52 | Tuning the query planner by adjusting the weights that predict the relative performance of sorting and index lookup. (check-in: 9f2806da4d user: drh tags: qp-tuning) | |
|
2022-12-02
| ||
| 20:32 | Enhance the sqlite3_stmt_scanstatus() API and add sqlite3_stmt_scanstatus_v2(). For creation of easier to read query performance reports. (check-in: 5580083364 user: dan tags: scanstatus_v2) | |
| 18:56 | Minor internal tweaks to the OPFS VFS. Resolve a missing result code which lead to a null deref in xFileSize(). (check-in: 57dd593ef0 user: stephan tags: trunk) | |
| 18:06 | OPFS VFS: translate createSyncAccessHandle() exceptions which appear to be locking violations to SQLITE_BUSY. This seems to improve concurrency considerably even with a reduced retry count of 5 (was 6). (check-in: 0d36021d10 user: stephan tags: trunk) | |
| 17:52 | For the sqlite3_bind and sqlite3_result interfaces for UTF16 strings, round the number of bytes down to the next even number, to avoid creating a UTF16 string that is an odd number of bytes. Forum post 411199488d065f83. (check-in: b57e3c3db0 user: drh tags: trunk) | |
| 15:31 | Use sqlite3_result_int64() instead of sqlite3_result_int() when returning potentially large values from the DBSTAT virtual table, to avoid integer overflows in the result. Forum post ada2ab044f. (check-in: 5652154a8c user: drh tags: trunk) | |
| 11:35 | Minor touchups to the JS test index page and test server push rules. (check-in: 0881f3e923 user: stephan tags: trunk) | |
| 10:43 | wasm builds: explicitly set a default stack size because emsdk 3.1.27 reduced it from 4MB to only 64kb, leading to memory corruption when kvvfs is used (it requires at least twice that for I/O). (check-in: 758112460f user: stephan tags: trunk) | |
| 09:23 | wasm: after building snapshot zip file, emit instructions for pushing it to the test server. (check-in: 9615c77919 user: stephan tags: trunk) | |
| 08:51 | Correct the problem which triggered the rollback in [7eec635562f6]: an incorrect default db page size (not a multiple of 512 bytes). (check-in: e06e490c24 user: stephan tags: trunk) | |
| 08:38 | Roll back the SQLITE_DEFAULT_PAGE_SIZE part of [c260895faacb34] because kvvfs does not work at all with a page size of 8kb. (check-in: 7eec635562 user: stephan tags: trunk) | |
| 08:29 | sqlite3-wasm.c: code legibility and coding style tweaks. Increase SQLITE_DEFAULT_PAGE_SIZE from 4k to 8k, as that improves OPFS speedtest1 performance by roughly 12%. (check-in: c260895faa user: stephan tags: trunk) | |
| 07:14 | Expand JS tests for db export/import and document reason it cannot currently work with kvvfs. Fix a minor JS build dependencies bug. Update page title with PASS/FAIL prefix for tester1.js to improve overview when launching multiple test tabs. Add ability of tester1 should-run-test predicates to report why a given test is disabled. (check-in: 75f610d3a4 user: stephan tags: trunk) | |
| 03:37 | Remove extraneous/unused sqlite3.oo1.version object. Add httpd makefile target. (check-in: 8e4d30ac03 user: stephan tags: trunk) | |
| 03:35 | Experimental branch for more flexible selection of extensions and localization of details of incorporation by host. A WIP for now. (check-in: 98be19ba83 user: larrybr tags: extension_opts) | |
|
2022-12-01
| ||
| 15:22 | sqlite3_js_create_file() now accepts an ArrayBuffer data source. Add test for OPFS-based export/re-import. The (sqlite3*) argument converter now optionally accepts sqlite3.oo1.DB instances. (check-in: 14a84b67fb user: stephan tags: trunk) | |
| 04:45 | Reformulate and simplify some JS tests related to the previous checkin. (check-in: 9ea2d3dcf7 user: stephan tags: trunk) | |
| 03:55 | Expand "sqlite3_vfs*" JS-to-WASM function argument conversions to accept VFS names (JS strings) and capi.sqlite3_vfs instances. Implement sqlite3_js_vfs_create_file() to facilitate creation of file-upload features which store the file in VFS-specific storage (where possible, e.g. "unix" and "opfs" VFSes). Correct an argument type check in the SQLite3Error and WasmAllocError constructors. (check-in: e1009b16d3 user: stephan tags: trunk) | |
|
2022-11-30
| ||
| 21:18 | Add a testcase() macro to verify that the case of a NOT NULL error message hitting the string length limit. (check-in: 91f50964c1 user: drh tags: trunk) | |
| 20:22 | Fix an over-zealous assert() reported by Yong Heng. (check-in: 6ee61f8ced user: drh tags: trunk) | |
| 19:11 | Attempt to rationalize the bits associated with ".wheretrace". Provide a decoder key in sqliteInt.h for what each bit is intended to do. (check-in: 8ec361695a user: drh tags: trunk) | |
| 18:21 | Rename some JS files from X.js to X.c-pp.js to keep the maintainer, and downstream build customizers, aware that those files contain constructs specific to the c-pp preprocessor and will not run as-is in JS. (check-in: 2eade7c7b1 user: stephan tags: trunk) | |
| 13:44 | Always use nanosleep() (instead of usleep() or sleep) if the _POSIX_C_SOURCE macro says it should be available. See Fossil Forum post ab2e2593ae307946 for driver behind this enhancement. (check-in: 6620c57b9d user: drh tags: trunk) | |
| 11:50 | Install sqlite3_malloc/sqlite3_free() as the JS-side WASM allocator (as opposed to replacing C-level's malloc()/free() with them). All tests work and this eliminates the potential for allocator discrepancies when using the (de)serialize APIs. (check-in: 95c78f6b46 user: stephan tags: trunk) | |
| 10:05 | Merge trunk into wasi-patches branch. (check-in: 64cf34a855 user: stephan tags: wasi-patches) | |
| 08:37 | Simplify how the OPFS VFS async proxy copies initial state sent to it from the synchronous side of the connection. Make the lock-wait time a multiple of the wait-loop timeout interval. (check-in: eddafafffa user: stephan tags: trunk) | |
| 07:48 | OPFS VFS: remove an invalid TODO and fix a property name typo which caused xCheckReservedLock() to always report false. (check-in: 3b037caa2f user: stephan tags: trunk) | |
| 07:17 | Rename some OPFS JS files. Prevent JS bindings of sqlite3_uri_...() from performing JS-to-C-string argument conversion on their first argument, as doing so is specifically illegal. (check-in: 79832808de user: stephan tags: trunk) | |
| 05:27 | Refactor a significant chunk of the OPFS sqlite3_vfs init code into sqlite3.VfsHelper, and internal-use-only API encapsulating code relevant to creating new VFSes in JS. Intended to assist in pending experimentation with an alternative OPFS VFS. (check-in: e25d7b080a user: stephan tags: trunk) | |
| 03:08 | Doc and logging text tweaks in the OPFS async proxy and test app. (check-in: 7ce8608e22 user: stephan tags: trunk) | |
|
2022-11-29
| ||
| 18:28 | sqlite3.oo1.OpfsDb: default to journal_mode=persist, as current tests show it to be marginally faster than truncate/delete in Chrome v109. Also increase default busy_timeout from 2 seconds to 3, admittedly on a whim. (check-in: d0c8fa30a3 user: stephan tags: trunk) | |
| 18:00 | OPFS speedtest1: hide a currently-broken/to-fix WASMFS-build link. (check-in: cde95d382f user: stephan tags: trunk) | |
| 17:52 | Change the handling of hwtime.h to make it easier to compile performance measurement builds that make use of hwtime.h. This should not affect productions builds. (check-in: f64a224244 user: drh tags: trunk) | |
| 11:28 | Fix legacy build system main.mk to include basexx.c in testfixture builds. (check-in: 8c9200b7e1 user: dan tags: trunk) | |
| 06:56 | Rename one instance of opfs.OpfsDb to oo1.OpfsDb, as per [0c5c51f4fb04]. (check-in: 75b04c9b30 user: stephan tags: trunk) | |
| 06:09 | Minor internal cleanups and docs in the OPFS sqlite3_vfs. (check-in: 61799b05ff user: stephan tags: trunk) | |
| 05:25 | Internal restructuring of the OPFS sqlite3_vfs in order to facilitate certain experimentation and improve error reporting/hints if it cannot be activated. Deprecate the name sqlite3.opfs.OpfsDb, preferring sqlite3.oo1.OpfsDb for consistency with JsStorageDb and any future DB subclasses. (check-in: 0c5c51f4fb user: stephan tags: trunk) | |
| 02:23 | Add an explicit warning about the current API-instability of the sqlite3.opfs namespace, which may need to be eliminated based on re-thinking of how the OPFS sqlite3_vfs is registered. Comment changes only - no code. (check-in: 0cb2fd1417 user: stephan tags: trunk) | |
|
2022-11-28
| ||
| 21:17 | Check-in [8d5b76593d82b3a5] contained an error that was causing some obscure error codes to be lost. Fixed here. (check-in: 46cdd3637d user: drh tags: trunk) | |
| 21:09 | Get ext/misc/basexx.c into the testfixture.exe build for MSC. (check-in: bb2c5d088e user: larrybr tags: trunk) | |
| 20:08 | Fix harmless compiler warnings. (check-in: 8d5b76593d user: drh tags: trunk) | |
| 19:42 | Implementation of enhancement request [695a1a53dea6b240]: The query planner has improved awareness of when indexes on expressions are covering and adjusts their costs accordingly. (check-in: e3474d79b2 user: drh tags: trunk) | |
| 18:41 | Add the SQLITE_FCNTL_RESET_CACHE verb. Use it to ensure that the page cache is purged before and after a the recovery extension is run. (check-in: 6db0bc4bc0 user: dan tags: trunk) | |
| 18:17 | Test cases added derived from the enhancment ticket. (Leaf check-in: c022c0152a user: drh tags: covering-indexed-expr) | |
| 16:11 | Merge trunk changes into covering-index-expr branch. (check-in: 89d775ada3 user: drh tags: covering-indexed-expr) | |
| 15:23 | Rework the covering index checking routine, whereIsCoveringIndex(), so that it can return a "maybe" result for aggregate queries where we are not exactly sure. The index is scored as if it is covering, but the main table is still opened. (check-in: b8eec42143 user: drh tags: covering-indexed-expr) | |
| 14:51 | Add (optional) base64 and base85 UDF extensions. (check-in: b44ab10c49 user: larrybr tags: trunk) | |
| 14:11 | Sync w/trunk, zap surplus space. (Closed-Leaf check-in: b8345630a2 user: larrybr tags: base_convert) | |
| 13:47 | Ensure the RETURNING clause is honoured when a row of a temp table is updated by an ON CONFLICT clause. (check-in: a2449bcc2c user: dan tags: trunk) | |
| 02:28 | Conform CLI .trace arg handling to its help. (check-in: 31546ea320 user: larrybr tags: trunk) | |
|
2022-11-27
| ||
| 00:57 | Document an OPFS API change in Chrome v108 which does not break our code but does change several formerly async methods to synchronous. No code changes. (check-in: e9dd87e28a user: stephan tags: trunk) | |
|
2022-11-26
| ||
| 20:52 | Better reporting of when the WHERE clause analysis thinks that an index is covering. (check-in: 17ebcf316b user: drh tags: covering-indexed-expr) | |
| 20:48 | Show which AggInfo.aCol an Expr node represents in the tree trace debugging logic. Does not affect production builds. (check-in: b8076f4dc5 user: drh tags: trunk) | |
| 20:13 | Merge trunk fixes into the covering-indexed-expr branch. (check-in: 9ac67ff968 user: drh tags: covering-indexed-expr) | |
| 20:12 | Fix an incorrect assertion-fault in the "TREETRACE" debugging logic on select.c. The problem does not affect production builds. (check-in: f11bb42292 user: drh tags: trunk) | |
| 15:24 | OPFS VFS: add the opfs-unlock-asap=1 URI flag which tells the VFS to release implicit locks ASAP instead of during VFS idle time. This improves concurrency notably in the test app but brings a significant performance penalty in speedtest1 (roughly 4x slowdown). This is not the final word in OPFS concurrency, but gets us a step further. (check-in: 9542f9ce9e user: stephan tags: trunk) | |
| 14:19 | Experimental changes to help the query planner detect when an expression index is coverting. Works somewhat, but there are tests that fail. (check-in: 968c189bcf user: drh tags: covering-indexed-expr) | |
|
2022-11-25
| ||
| 17:05 | Relax restriction (8) on the push-down optimization so that it only applies if one or more columns uses a collating sequence other than BINARY. See forum post 3824ced748baa808 and check-in [346a3b12b861ce7b]. (check-in: adbca3448e user: drh tags: trunk) | |
| 16:32 | Fix #ifdefs so that restrictions (8) and (9) of the push-down optimization are still enforced even if compiled with SQLITE_OMIT_WINDOWFUNC. This fixes a bug introduced by check-in [346a3b12b861ce7b]. (check-in: 09e1e42e0f user: drh tags: trunk) | |
| 16:10 | Improve the query planner such that it is able to make use of indexed expressions within an aggregate query with GROUP BY. This implements enhancement request [99378177930f87bd]. (check-in: b9190d3da7 user: drh tags: trunk) | |
| 15:52 | Add restriction (9) to the push-down optimization: If the subquery is a compound then all arms of the compound must have the same affinity. dbsqlfuzz 3a548de406a50e896c1bf7142692d35d339d697f. (check-in: 1ad41840c5 user: drh tags: trunk) | |
| 13:26 | Remove a redundant assert() statement. (Closed-Leaf check-in: e3e1b453dc user: drh tags: agg-with-indexed-expr) | |
| 13:15 | Improve the robustness of the updateAccumulator() routine against OOM. (check-in: d2844f577b user: drh tags: agg-with-indexed-expr) | |
| 13:08 | Improved comments. Add assert()s to verify that the AggInfo structure is unchanged after registers have been assigned. (check-in: 5200b84195 user: drh tags: agg-with-indexed-expr) | |
|
2022-11-24
| ||
| 23:35 | Correctly deal with IF-NULL-ROW operators when dealing with indexed expressions in aggregates. (check-in: 939cb47025 user: drh tags: agg-with-indexed-expr) | |
| 20:11 | Speed up base85() conversions and sync w/trunk. (check-in: 17b823500a user: larrybr tags: base_convert) | |
| 19:02 | Take care not to try to add comments to a TK_AGG_COLUMN opcode that does not have an associated Table object because it is a reference to an indexed expression. (check-in: 5fc23863e4 user: drh tags: agg-with-indexed-expr) | |
| 18:45 | Change a NEVER() into an assert(). (check-in: a0fd44f4e5 user: drh tags: agg-with-indexed-expr) | |
| 17:58 | Fix a test case in fts3expr4.test to account for different locales. (check-in: a2b6883ac2 user: dan tags: trunk) | |
| 17:53 | More work on the OPFS concurrency testing app. (Closed-Leaf check-in: c0458caca3 user: stephan tags: opfs-unlock-asap) | |
| 16:03 | JS documentation cleanups. No code changes. (check-in: 18e89a436d user: stephan tags: trunk) | |
| 15:32 | Update multiplex3.test to account for the fact that the multiplexor xDelete method may return an error even if it manages to delete the first chunk of a file. (check-in: 1a7f325473 user: dan tags: trunk) | |
| 15:04 | Add NEVER() and ALWAYS() macros on branches that are believed to be unreachable. (check-in: 3a901e88c8 user: drh tags: agg-with-indexed-expr) | |
| 13:19 | New test cases. Fix the logic so that it works for GROUP BY aggregates that do not require sorting. (check-in: ef6ebe7922 user: drh tags: agg-with-indexed-expr) | |
| 02:59 | Speed up base64 conversions, and add test with more data for the baseNN conversion to grind. (check-in: 6c84ae4ba8 user: larrybr tags: base_convert) | |
| 02:35 | Add sqlite3.oo1.DB.prototype.checkRc() and tests for both that method and its class-level counterpart. (check-in: f7eaa6ba21 user: stephan tags: trunk) | |
| 01:41 | Merge the latest trunk changes into the agg-with-indexed-expr branch to simplify diffs. (check-in: 38c3d3f1ed user: drh tags: agg-with-indexed-expr) | |
| 01:40 | Add explanatory comment to the new optimization. And add a test case. (check-in: e6c20f61de user: drh tags: agg-with-indexed-expr) | |
|
2022-11-23
| ||
| 21:09 | Minor JS doc updates. (check-in: 27efd63ad7 user: stephan tags: trunk) | |
| 21:03 | Add optional zSchema argument to sqlite3_js_db_export(). (check-in: 9c23644b1e user: stephan tags: trunk) | |
| 20:49 | OPFS concurrency test: add a URL flag to enable/disable unlock-asap mode. (check-in: 1c1bf22ead user: stephan tags: opfs-unlock-asap) | |
| 19:03 | Add an experimental OPFS VFS-specific URI flag, opfs-unlock-asap, which tells the VFS to release implicit locks ASAP. This permits higher concurrency but hurts performance considerably. This may or may not be obsoleted by other concurrency-related experimentation. (check-in: d23c917013 user: stephan tags: opfs-unlock-asap) | |
| 18:51 | Aggregates with GROUP BY now make use of expressions on indexes. This code works and gets the correct answer for the test case in the ticket. Lots more testing and documentation is needed, however. (check-in: 8dcf9f2031 user: drh tags: agg-with-indexed-expr) | |
| 17:56 | This attempt at modifying AggInfo to make use of indexed expressions does not work. It gets an incorrect answer for the test case shown in the ticket. (check-in: 84c06023f4 user: drh tags: agg-with-indexed-expr) | |
| 16:39 | Initial infrastructure for adding a mode to the OPFS VFS which causes implicit locks to be released ASAP, which increases concurrency at the cost of performance. (check-in: c5b7a9715a user: stephan tags: opfs-unlock-asap) | |
| 16:08 | Update Makefile.in to include new target "sqlite3r.c". For generating "sqlite3r.c" and "sqlite3r.h", versions of the amalgamation that include the recover extension. To build the shell tool against these files, add -DSQLITE_HAVE_SQLITE3R. (check-in: 5f135575b9 user: dan tags: trunk) | |
| 15:52 | Remove a bit of over-cleverness which breaks loading of sqlite3.js in some main-thread cases. Broken by [96f76e7616]. (check-in: 220cc4c639 user: stephan tags: trunk) | |
| 15:33 | OPFS concurrency tester: ensure that the work interval timer does not overlap with the work time. (check-in: 8f2076553b user: stephan tags: trunk) | |
| 14:13 | Further foundation prep work prior to starting to flesh-out the optimizeAggregateUseOfIndexedExpr() routine. (check-in: 23145fe999 user: drh tags: agg-with-indexed-expr) | |
|
2022-11-22
| ||
| 22:46 | Add more baseNN tests, get oversize error trapping working, and sync w/trunk (check-in: 03819e9368 user: larrybr tags: base_convert) | |
| 20:58 | Merge enhancements and fixes from trunk. (check-in: f8932e04d4 user: drh tags: agg-with-indexed-expr) | |
| 20:37 | Add the stub function: optimizeAggregateUsingIndexedExpr(). The hope is that we can fill this in with a routine that does useful optimizations. (check-in: d85bb724fd user: drh tags: agg-with-indexed-expr) | |
| 20:04 | Avoid naming collision between the sha1 and shathree extensions. (check-in: 9ec923b5dc user: mistachkin tags: trunk) | |
| 19:56 | Include the treetrace bitmap comment accidentally omitted from the previous check-in. (check-in: db07471c53 user: drh tags: trunk) | |
| 19:51 | Merge trunk fixes and enhancements into the agg-with-indexed-expr branch. (check-in: 070634781a user: drh tags: agg-with-indexed-expr) | |
| 19:49 | Rename the SELECTTRACE macro to TREETRACE, so that is corresponds to the new CLI command. Renumber all of the bits in the bitmask used to enable various kinds of tracing, and add a trace bitmap decoder in sqliteInt.h. Changes to debugging logic only. No (intentional) changes to production code. (check-in: 8036445a36 user: drh tags: trunk) | |
| 19:12 | Sync w/trunk. Ready for merge to trunk. (check-in: ff67460e1a user: larrybr tags: base_convert) | |
| 19:04 | Add test/basexx1.test to test is_base85(t), base85(x) and base64(x). Sync w/trunk. (check-in: 4e43345477 user: larrybr tags: base_convert) | |
| 18:24 | Fix the error message in the CLI for "no such VFS". Forum post 1217fdd6b3. (check-in: b344f33d16 user: drh tags: branch-3.40) | |
| 18:24 | Fix the error message in the CLI for "no such VFS". Forum post 1217fdd6b3. (check-in: 861af465fd user: drh tags: trunk) | |
| 16:12 | Add Makefile.in targets for sqlite3r.c and sqlite3r.h, versions of the amalgamation that include the recover extension. (Closed-Leaf check-in: 59a837cfc7 user: dan tags: make-sqlite3r.c) | |
| 15:48 | Bump the version number to 3.40.1. (check-in: d0ca348b25 user: drh tags: branch-3.40) | |
| 15:47 | Fix last function pointer in sqlite3Apis init. Reported at forum post eba0faa96d. (check-in: b3795d28fe user: drh tags: branch-3.40) | |
| 15:43 | Since the memory registers used by the columns and functions of an AggInfo object are sequential, it is not neecessary to remember each register separately. We can simply remember the first one and do the math when others are needed. (check-in: dc5bd34963 user: drh tags: agg-with-indexed-expr) | |
| 15:41 | Fix last function pointer in sqlite3Apis init. Reported at forum post eba0faa96d. (check-in: 6d5dc9eed5 user: larrybr tags: trunk) | |
| 14:31 | Omit the unnecessary AggInfo.mnReg field. (check-in: d79c58ef08 user: drh tags: agg-with-indexed-expr) | |
| 14:10 | Factor out the allocation of registers for aggregates into a separate subroutine. (check-in: 4475799d5b user: drh tags: agg-with-indexed-expr) | |
| 13:33 | This is the first in what is anticipated to be a long sequence of incremental changes aimed at improving aggregate query processing, and in particular helping aggregate queries take better advantage of indexes on expression. The end goal is to resolve ticket [99378177930f87bd], though it remains to be seen whether or not I can get there with this approach. (check-in: cba837eae9 user: drh tags: agg-with-indexed-expr) | |
| 12:47 | Convert an ALWAYS() in sqlite3DbSpanDup() into an assert(), for a performance increase and size reduction. (check-in: 21e80a2973 user: drh tags: trunk) | |
|
2022-11-21
| ||
| 17:40 | Split out the debugging code that dumps an AggInfo object into a separate subroutine called printAggInfo() so that it can be invoked interactively during debugging. No changes to production code. (check-in: dc33cfbede user: drh tags: trunk) | |
| 16:40 | Change the name of the Parse.pIdxExpr field to pIdxEpr so that the name is distinct from all other identifiers in the code and thus less confusing. (check-in: a2962d0187 user: drh tags: trunk) | |
| 16:03 | Merge trunk into wasi-patches branch to clean up the diff view. (check-in: 95de6742d3 user: stephan tags: wasi-patches) | |
| 16:00 | OPFS contention test: give each worker a distinct recognizable name instead of a random one. (check-in: 5f564bf7de user: stephan tags: trunk) | |
| 15:55 | Performance optimization and size reduction in insertCell() by omitting the "pRC" argument and instead returning the result code as an integer. (check-in: bee94d1bb0 user: drh tags: trunk) | |
| 14:13 | Performance optimization to sqlite3BtreeInsert(). (check-in: b8976ebfe0 user: drh tags: trunk) | |
| 13:35 | Small performance improvement in sqlite3BtreeTransferRow(). (check-in: dab959ea3e user: drh tags: trunk) | |
| 06:07 | Add new JS tests dir to those pushed to the test server. (check-in: 07182dca9f user: stephan tags: trunk) | |
| 05:18 | More tweaking of OPFS concurrency measures and the related test app. (check-in: a8d4da1501 user: stephan tags: trunk) | |
| 04:12 | Resolve missing SQLITE_LOCKED result code which triggered a new (since last checkin) exception in the OPFS VFS. Improve output of the OPFS contention tester app. (check-in: 2debbbca33 user: stephan tags: trunk) | |
| 03:50 | Add test app for experimenting with multi-worker OPFS concurrency. Tweak OPFS VFS to significantly improve the otherwise "unfortunate" concurrency situation. (check-in: 96f76e7616 user: stephan tags: trunk) | |
| 02:18 | Get clean builds for MS tools. Add build examples for extension glommer (basexx.c) Make sure extensions build for dynamic load and built into shell. (check-in: da940d507e user: larrybr tags: base_convert) | |
| 00:11 | Fix a base64 decode bug. Provide for convenient inclusion of extension(s) built into the CLI, to simplify testing and for its own sake. Improve comments. Cure collision between base64.c and base85.c when both are in the same translation unit. (check-in: 07543d23a9 user: larrybr tags: base_convert) | |
|
2022-11-20
| ||
| 15:30 | Remove check for WASM_WASI macro when detecting wasi compilation mode, as that macro is project-specific. Rely only on __wasi__ (exposed by clang) to detect wasi compilation mode. (check-in: d469ac0c44 user: stephan tags: wasi-patches) | |
| 05:47 | js dist: account for a file rename in the previous checkin. (check-in: 469f9011a8 user: stephan tags: trunk) | |
| 05:36 | Further minor cleanups in the JS build related to vanilla vs ESM. (check-in: 100a596800 user: stephan tags: trunk) | |
| 04:14 | Remove an obsolete reference to WASMFS from ext/wasm/index.html. (check-in: 51ff681864 user: stephan tags: trunk) | |
| 04:14 | Generic cleanups and doc additions in the wasm build files. (check-in: d10f385e36 user: stephan tags: trunk) | |
| 04:13 | Add 'snapshot' target to create distinctly-named snapshot builds of the wasm deliverables zip file. (check-in: f7620aa09e user: stephan tags: trunk) | |
| 01:15 | Minor cleanups in the ESM-related preprocessor filtering. (check-in: 205884a273 user: stephan tags: trunk) | |
|
2022-11-19
| ||
| 20:10 | New assert()s confirm that BTREE_PREFORMAT must be the same value as OPFLAG_PREFORMAT. (check-in: f40bf2c642 user: drh tags: trunk) | |
| 19:37 | Performance optimization in sqlite3BtreeInsert(). (check-in: 9776fa3175 user: drh tags: trunk) | |
| 18:43 | Performance improvement and size reduction in balance_nonroot(). (check-in: 715bc81eb8 user: drh tags: trunk) | |
| 18:17 | Small performance improvement and size reduction in btree. (check-in: daa07149c0 user: drh tags: trunk) | |
| 16:16 | Get tester1.js working via an ES6 worker module and add that variant to the dist zipfile. (check-in: 90480586f1 user: stephan tags: trunk) | |
| 15:03 | Elide a wasi-incompatible shell.c block in SQLITE_WASI builds. (check-in: 9b8b15a779 user: stephan tags: wasi-patches) | |
| 14:18 | Improved comments on the pageFreeArray() routine of btree.c. No changes to code. (check-in: 0c2adc6d35 user: drh tags: trunk) | |
| 13:09 | Streamline the decodeFlags() routine in btree.c for a small performance increase. (check-in: 4cb285210b user: drh tags: trunk) | |
| 07:44 | Default to SQLITE_THREADSAFE=0 and SQLITE_OMIT_LOAD_EXTENSION for wasi builds. (check-in: 382ba3b284 user: stephan tags: wasi-patches) | |
| 07:39 | Account for lack of mmap(), getpid(), and shared memory APIs in wasi. (check-in: 80ff026fb4 user: stephan tags: wasi-patches) | |
| 07:17 | Preliminary patches to get sqlite3.c building as-is in WASI environments. (check-in: 19c04d71bf user: stephan tags: wasi-patches) | |
| 05:26 | Add build of sqlite3.mjs (ES6 module), add a test app for it, and include it in the dist build. (check-in: 2e783670e1 user: stephan tags: trunk) | |
| 02:58 | Integrate a custom preprocessor to the JS build process to facilitate creation of both vanilla JS and ES6 Module builds from the same source files. There is still some build-level reworking pending to make an ESM build a first-class deliverable. (check-in: 10c723d96d user: stephan tags: trunk) | |
| 02:51 | More work towards creation of a ES6 JS module. (Closed-Leaf check-in: 6b826e700f user: stephan tags: js-cpp) | |
| 02:39 | New extensions for base85 and base64 conversion UDFs (check-in: 5cc1fe1ddc user: larrybr tags: base_convert) | |
| 02:32 | Create new branch named "base_convert" (check-in: 0cbf55407a user: larrybr tags: base_convert) | |
| 00:22 | Small performance optimization in btree.c. (check-in: f710cce135 user: drh tags: trunk) | |
| 00:08 | Databases created using sqlite3_deserialize() should report their filename as an empty string, not as "x". Fix for ticket [53043c9793715f08]. (check-in: ff494449ef user: drh tags: trunk) | |
|
2022-11-18
| ||
| 17:57 | Update the version number to 3.41.0 to begin the next development cycle. (check-in: 5c669f5f39 user: drh tags: trunk) | |
| 17:50 | Add the SQLITE_DBCONFIG_LENIENT_JSON configuration option. Modify the built-in JSON routines such that when this setting is active, arguments that that ought to be JSON but still give a reasonable result (ex: NULL) rather than raising an error. (Leaf check-in: 186db57d26 user: drh tags: lenient-json) | |
| 15:22 | shell.c.in: on non-Windows platforms, check for $XDG_CONFIG_HOME/sqlite3/sqliterc before ~/.sqliterc, per request in forum post 7a16582b1e403c81. (check-in: 17065d095d user: stephan tags: trunk) | |
| 02:29 | Replace use of cpp with the fit-to-purpose c-pp to avoid cpp's C-centric/JS-unfriendly quirks. (check-in: 49d70f071e user: stephan tags: js-cpp) | |
|
2022-11-17
| ||
| 19:24 | Fix corner cases in UTF8 handling in the REGEXP extension. Forum post 3ffe058b04. (check-in: abb18f61c5 user: drh tags: trunk) | |
| 15:21 | Merge trunk into js-cpp branch. (check-in: e047b33d1f user: stephan tags: js-cpp) | |
| 14:40 | Use the log10() and log2() functions from the standard C library to implement the equivalent SQL functions, in the hope that this will prevent reported precision problems. See forum post cfceb1230bdcfd84 and the surrounding thread. (check-in: 7c572d02e6 user: drh tags: trunk) | |
| 13:58 | Split out the documentation for sqlite3_value_encoding() into its own page and make it clear that this interface is intended for testing and debugging only. Forum thread c9f445453da950ad. Comment changes only - no changes to code. (check-in: 9048a766ff user: drh tags: trunk) | |
| 01:24 | Raise an error if an attempt is made to compile the CLI with the SQLITE_OMIT_COMPLETE option, since sqlite3_complete() really is necessary for the CLI to operate sanely. (check-in: a119a9e2ad user: drh tags: trunk) | |
|
2022-11-16
| ||
| 21:52 | Change a self.X JS reference to X to account for a symbol resolution discrepancy between vanilla JS and ES6 modules, as explained in forum post 801d8f77e5115141. (check-in: 0590de4da1 user: stephan tags: trunk) | |
| 21:39 | wasm build: include FTS5 instead of FTS4, per /chat and HN discussions. (check-in: 85c3f2ac5a user: stephan tags: trunk) | |
| 19:57 | Fix harmless typo in comment, reported by Debian in Fossil https://fossil-scm.org/forum/forumpost/15f7327318. (check-in: 5689f0d9ad user: drh tags: trunk) | |
| 19:53 | Avoid returning SQLITE_SCHEMA if the first query run on a connection is "SELECT nosuchcolumn" or similar. Forum post c1798f77ef (check-in: 3dc4f75d77 user: drh tags: trunk) | |
| 16:14 | Merge version 3.40.0 into the reuse-schema branch. (check-in: 2aec00a729 user: drh tags: reuse-schema) | |
| 16:11 | Merge the 3.40.0 release into the begin-concurrent-pnu-wal2 branch. (check-in: a090de41be user: drh tags: begin-concurrent-pnu-wal2) | |
| 16:05 | Merge the 3.40.0 release changes into the begin-concurrent-report branch. (check-in: 9fc6241017 user: drh tags: begin-concurrent-report) | |
| 16:00 | Merge the 3.40.0 release into the wal2 branch. (check-in: 2df915ef04 user: drh tags: wal2) | |
| 15:59 | Merge 3.40.0 into the begin-concurrent branch. (check-in: a06d57ee9e user: drh tags: begin-concurrent) | |
| 12:10 | Version 3.40.0 (check-in: 89c459e766 user: drh tags: trunk, release, major-release, version-3.40.0) | |
|
2022-11-14
| ||
| 19:42 | Previous change to the fake_big_file command in the test harness was not correct. This one should fix the problem. (check-in: 6ee57a2e4e user: drh tags: trunk) | |
| 18:57 | Change the fake_big_file test command so that it fails for files larger than 2MB on Windows, as we have observed that Window10 will sometimes bluescreen when operating on very large sparse files. (check-in: d39ffd2aba user: drh tags: trunk) | |
| 17:48 | Avoid running bigsort.test with SQLITE_DEBUG builds. The assert() statements added in [7c96a56] make it too slow. (check-in: fa68dd8928 user: dan tags: trunk) | |
| 13:41 | Merge the 3.40.0 rc1 changes into the reuse-schema branch. (check-in: 886788b61e user: drh tags: reuse-schema) | |
| 13:18 | Merge the 3.40.0 rc1 changes into the begin-concurrent-pnu-wal2 branch. (check-in: b0e2b9aa2c user: drh tags: begin-concurrent-pnu-wal2) | |
| 13:10 | Merge the 3.40.0 rc1 changes into the wal2 branch. (check-in: a5a610a650 user: drh tags: wal2) | |
| 12:54 | Merge the 3.40.0 rc1 changes into the begin-concurrent-report branch. (check-in: 4d3f2531a9 user: drh tags: begin-concurrent-report) | |
| 12:44 | Merge 3.40.0 rc1 into the begin-concurrent branch. (check-in: 5ba588e7eb user: drh tags: begin-concurrent) | |
|
2022-11-13
| ||
| 19:29 | Remove some outdated code comments. No code changes. (check-in: 80ff592a9d user: stephan tags: trunk) | |
|
2022-11-12
| ||
| 17:17 | Disable the ability to change the schema_version cookie when SQLITE_DBCONFIG_DEFENSIVE mode is enabled. This is a security enhancement inspired by the question in forum post 2b9cc3dae1f1e5f6. (check-in: 1d81381e8f user: drh tags: trunk) | |
|
2022-11-10
| ||
| 23:10 | Remove unnecessary tabs in the ChaCha20 implementation. Forum post 0cdce5db8c. (check-in: b7179efbdb user: drh tags: trunk) | |
| 19:19 | Avoid returning SQLITE_SCHEMA if the first query run on a connection is "SELECT nosuchcolumn" or similar. Forum post c1798f77ef (Closed-Leaf check-in: d31c019fd6 user: dan tags: schema-error-fix) | |
| 13:22 | Automatically relinquish implicitly-acquired OPFS file locks during VFS idle time in an attempt to help alleviate cross-tab locking contention like that described in forum post 58a377083cd24a. (check-in: 8daf24ff73 user: stephan tags: trunk) | |
| 13:14 | Rework automatically acquired OPFS locks to be released during idle time. This eliminates the performance hit reported in [46304ba057707c]. (Closed-Leaf check-in: a7fe91afca user: stephan tags: opfs-lock-without-xlock) | |
| 11:35 | OPFS: if an op which needs a lock is called when no lock has been obtained, automatically lock it at the start of the op and unlock it at the end of that op. This is an attempt to alleviate the cross-tab contention described in forum post 58a377083cd24a but it increases speedtest1 run time by approximately 4x. Perhaps auto-lock can be combined with the older idle-time-based auto-unlock to unlock such locks (but not those from xLock()) to improve this? (check-in: 46304ba057 user: stephan tags: opfs-lock-without-xlock) | |
|
2022-11-09
| ||
| 11:17 | Better handle an error in the fts5 integrity-check code. dbsqlfuzz e87c62f9b67ea21aebdc36ab71cab7cc3eda8dc3. (check-in: ae43e97087 user: dan tags: trunk) | |
| 11:02 | Additional defense against corrupt database files in dbdata.c. (check-in: 2e70d1e5c9 user: drh tags: trunk) | |
| 10:17 | Increase the precision of the nData parameter to the dbdataValue() routine inside the sqlite_dbdata virtual table, to avoid the possibility of integer overflow. (check-in: 295447b44f user: drh tags: trunk) | |
|
2022-11-08
| ||
| 20:04 | Fix a problem with URI formatting in calls to sqlite3rbu_vacuum(zDb, NULL) causing problems on win32. First reported here <https://sqlite.org/forum/forumpost/a7ae915a9d>. (check-in: 77ccc8ea8a user: dan tags: trunk) | |
| 19:36 | Do not attempt to run test script dbpagefault.test with SQLITE_OMIT_VIRTUALTABLE builds. (check-in: 901918c486 user: dan tags: trunk) | |
| 15:49 | Fix a problem in main.mk preventing the amalgamation-testfixture target from building. (check-in: ccf00a0e22 user: dan tags: trunk) | |
|
2022-11-07
| ||
| 19:40 | Further improvements to the handling of the u32 and u16 typedefs in the shell.c source file. (check-in: 55a19677d7 user: drh tags: trunk) | |
| 18:36 | Improve the ability of mkshellc.tcl to remove redundant typedefs from the generated shell.c code. This is needed to get shell.c to build on older C compilers. (check-in: 3645585f37 user: drh tags: trunk) | |
| 18:09 | Update this branch to match latest trunk changes. (check-in: 833f6374cc user: dan tags: reuse-schema) | |
| 18:00 | Add the sqlite3rbu_rename_handler() API. To override the default routine that RBU uses to rename files. (check-in: ebbb1f88e7 user: dan tags: trunk) | |
| 17:21 | Minor doc updates in speed-check.sh. No code changes. (check-in: d2ed4116fb user: stephan tags: trunk) | |
| 15:23 | Fix an obsolete comment. (check-in: e377c0a1ef user: drh tags: trunk) | |
| 15:01 | Fix typo in comment. (check-in: c3b94d7d46 user: drh tags: trunk) | |
| 13:06 | Add sqlite3.wasm.alloc.impl() as a "public back door" into the low-level non-throwing allocator. Correct sqlite3.WasmAllocError constructor to behave like its usages expect it to and add tests for that. (check-in: cea8bf9a14 user: stephan tags: trunk) | |
| 12:21 | Fix requirements marks so that they match documentation corrections. (check-in: 10d6189d23 user: drh tags: trunk) | |
| 12:12 | Minor wasm doc touchups. No code changes. (check-in: 2c44836891 user: stephan tags: trunk) | |
| 11:19 | Fix the documentation regarding negative length parameters for sqlite3_result_text() interfaces, to point out that the length parameter to sqlite3_result_text64() cannot be negative. Forum post cf1d043b07. Comment/documentation change only. (check-in: 8016507651 user: drh tags: trunk) | |
| 11:05 | Make sure that the recoverStrlen() function (used internally by the new recovery extension) is 64-bit safe. (check-in: ea30a6bfc4 user: drh tags: trunk) | |
|
2022-11-06
| ||
| 17:19 | The recoverAssertMutexHeld() function is for testing and verification only and should be a harmless no-op for production builds. [forum/forumpost/b4f2c7d402|Forum post b4f2c7d402]. (check-in: d75504710c user: drh tags: trunk) | |
| 13:12 | shell.c.in: on non-Windows platforms, check for $XDG_CONFIG_HOME/sqlite3/sqliterc before ~/.sqliterc, per request in forum post 7a16582b1e403c81. (Closed-Leaf check-in: 49c6e438a8 user: stephan tags: sqliterc-xdg-config) | |
|
2022-11-05
| ||
| 19:26 | Update test file dbpagefault.test to account for the restriction on using SQLITE_VTAB_DIRECTONLY virtual tables from within triggers. (check-in: 2b68fc8aa3 user: dan tags: trunk) | |
| 17:52 | Fix harmless compiler warnings. (check-in: fe44e7ef53 user: drh tags: reuse-schema) | |
| 15:31 | Merge the latest trunk enhancements into the reuse-schema branch. (check-in: 224eaf2622 user: drh tags: reuse-schema) | |
|
2022-11-04
| ||
| 19:09 | Merge the latest trunk enhancements into the begin-concurrent-pnu-wal2 branch. (check-in: aa2e247b58 user: drh tags: begin-concurrent-pnu-wal2) | |
| 18:58 | Merge the latest trunk enhancements into the wal2 branch. (check-in: ca63a1bee1 user: drh tags: wal2) | |
| 18:47 | Merge the latest trunk enhancements into the begin-concurrent-report branch. (check-in: d8568a848a user: drh tags: begin-concurrent-report) | |
| 18:33 | Merge the latest trunk enhancements into the begin-concurrent branch. (check-in: b361ee983c user: drh tags: begin-concurrent) | |
| 18:32 | Tweaks to recover module test scripts to work with various permutations. (check-in: 454c61e818 user: dan tags: trunk) | |
| 17:07 | Another test case fix for auto-vacuum builds. (check-in: c1c47eff48 user: dan tags: trunk) | |
| 16:39 | Fixes to recover module test scripts so that they may be used with SQLITE_DEFAULT_AUTOVACUUM and SQLITE_SECURE_DELETE builds. (check-in: 0e5597ce53 user: dan tags: trunk) | |
| 15:17 | Fix Tcl tests so that they again build and run with SQLITE_OMIT_VIRTUALTABLE defined. (check-in: 06a9dbea40 user: dan tags: trunk) | |
| 12:59 | Remove an unimportant testcase() macro that is no longer reachable due to the improvement in corruption detection. (check-in: cd7e3568a9 user: drh tags: trunk) | |
| 11:59 | Add another test case for the OP_Found fix. (check-in: 6cdd64a445 user: dan tags: trunk) | |
| 11:54 | Enhance the ability of the OP_Found and similar opcodes to detect truncated index records and report SQLITE_CORRUPT. dbsqlfuzz 2b12f90aeff8e081706c7e9b58834f04869f446c. Test cases in TH3. (check-in: 059a09da2c user: drh tags: trunk) | |
| 09:02 | Correct sqlite3-wasm.c's SQLITE_DEFAULT_CACHE_SIZE (it's measured in kb, not bytes). (check-in: 479ad980df user: stephan tags: trunk) | |
|
2022-11-03
| ||
| 22:51 | Add experimental esm target to ext/wasm/GNUmakefile to tell emcc to generate sqlite3.mjs (ES6 module) instead of sqlite3.js. Related to discussion at ed4596cf8496a39b. (check-in: e55d8eba83 user: stephan tags: trunk) | |
| 22:14 | Experimentally use clang's C preprocessor to filter #ifdef's out of the generated sqlite3-api.js, the goal being to see if we can feasibly use cpp to include ES6 module-specific code in the main code base and conditionally filter it out. (check-in: 718a6d371e user: stephan tags: js-cpp) | |
| 21:21 | Globally replace '' with "" for empty JS strings to please C preprocessor. (check-in: e92e1f42be user: stephan tags: trunk) | |
| 21:08 | Experimental changes that try to identify indexes as covering when they contain expressions which do cover all data uses. This check-in does not work, because the AggInfo object might still refer to individual columns. The purpose of this check-in is to preserve the idea. I might come back to it later. (Leaf check-in: 018914a5a1 user: drh tags: indexed-expr-exp) | |
|
2022-11-02
| ||
| 14:08 | Minor build cleanups and fix a harmless race condition in the OPFS part of tester1.js. (check-in: 70ee6ee014 user: stephan tags: trunk) | |
| 14:08 | Clarify documentation regarding the --recovery-db option to ".recover" and the magic 789 configuration option it is associated with. (check-in: f6fa0cffa9 user: drh tags: trunk) | |