Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
261 check-ins using file src/vdbe.c version 0c7cb1b934
|
2023-01-05
| ||
| 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) | |
|
2022-12-28
| ||
| 14:03 | Version 3.40.1 (check-in: df5c253c0b user: drh tags: release, version-3.40.1, branch-3.40) | |
|
2022-12-27
| ||
| 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) | |
| 11:53 | Fix minor problems in test scripts where.test and recover1.test. (check-in: 64588bd5da user: dan tags: branch-3.40) | |
|
2022-12-26
| ||
| 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) | |
|
2022-12-05
| ||
| 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) | |
|
2022-11-22
| ||
| 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) | |
| 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) | |
|
2022-11-21
| ||
| 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) | |
|
2022-11-19
| ||
| 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) | |
| 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) | |
|
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: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) | |
|
2022-11-04
| ||
| 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) | |
| 13:09 | Minor improvements to API documentation in comments for the recovery extension. (check-in: ed1c3515ad user: drh tags: trunk) | |
| 11:53 | Add sqlite3_wasm_vfs_create_file() to replace Emscripten's FS.createDataFile() in a (mostly) VFS-agnostic way. Add a test for worker1's export (to bytearray) support. Re-add worker1 open-from-bytearray using sqlite3_wasm_vfs_create_file() but it's untested (requires a new interactive test app or maybe reconsideration). (check-in: b35e1225c9 user: stephan tags: trunk) | |
| 11:25 | Emcc seems confused by SQLITE_DEBUG, for reasons unknown. Use NDEBUG instead to simplify the #ifdef logic in sqlite3recover.c. (check-in: 2610779ac8 user: drh tags: trunk) | |
| 08:49 | Fix a symbol name typo which broke and exception-handling case in OPFS xOpen(). (check-in: 5bc83d5695 user: stephan tags: trunk) | |
| 08:10 | Fix a missing symbol in non-SQLITE_DEBUG builds. (check-in: 17cdcad627 user: stephan tags: trunk) | |
|
2022-11-01
| ||
| 21:42 | Fix a harmless compiler warning. (check-in: 663a89164f user: drh tags: trunk) | |
| 19:35 | Instead of (const char*), use a special type - sqlite3_filename - as the filename argument passed to VFS method xOpen(). (check-in: 90df04e5a2 user: dan tags: trunk) | |
| 18:56 | Fix harmless compiler warnings. (Closed-Leaf check-in: de829770aa user: drh tags: sqlite3_filename) | |
| 17:43 | Instead of (const char*), use a special type - sqlite3_filename - as the filename argument passed to VFS method xOpen(). (check-in: bd1fe4de8a user: dan tags: sqlite3_filename) | |
| 14:13 | Fix compilation errors in the recover API seen with MSVC. (check-in: 78d17c4fed user: mistachkin tags: trunk) | |
| 13:12 | Fix a #ifdef involving SQLITE_OS_KV that was adding code unnecessarily. (check-in: b6c1b6e4a3 user: drh tags: trunk) | |
| 12:10 | Enforce affinity on materialized tables for subqueries and views. Also, do not allow UNION ALL flattening if the affinity of a result column varies between different arms of the compound. This is a fix for ticket [57c47526c34f01e8]. (check-in: 88a05141c2 user: drh tags: trunk) | |
| 12:01 | Improvements to comments. Change the "optimization_control" TCL command in the test harness so that it returns the new optimization mask, for verification. (Closed-Leaf check-in: a3a500127d user: drh tags: tkt-57c47526) | |
| 11:09 | Minor internal cleanups in the js pieces. (check-in: 271391b4e3 user: stephan tags: trunk) | |
| 07:49 | Significant cleanups and expansion of the sqlite3.opfs utilities. Add oo1.DB.dbVfsName(). Add VFS name to worker1:open's arguments and result. (check-in: 86a341d7e0 user: stephan tags: trunk) | |
| 01:07 | Do not flatten a UNION ALL subquery where the column affinities do not match on all arms. Force that subquery to be materialized. (check-in: 1b8a128832 user: drh tags: tkt-57c47526) | |
| 00:52 | Enforce column affinity on the materialization of a subquery or view. (check-in: b6692de374 user: drh tags: tkt-57c47526) | |
|
2022-10-31
| ||
| 18:01 | Make the UPDATE method of the sqlite_dbpage virtual table rebust against OOM errors. Forum post bbcf0dd6ca. Test case in TH3. (check-in: d15c9a4a32 user: drh tags: trunk) | |
| 13:50 | Worker1: use a list, rather than a single slot, to manage the default db link so that we can keep the least-recently-opened db as the default. Re-introduce worker1.export() but do not yet expose it until an equivalent import() (or open() option) is implemented. (check-in: c7750c101d user: stephan tags: trunk) | |
| 11:53 | Internal tweaks to the OPFS VFS result codes. (check-in: 32e1a2d2eb user: stephan tags: trunk) | |
| 11:09 | Add oo1.DB.exec() 'returnValue' option, which specifies what exec() should return. Defaults to the db object and enables direct return of the result rows array or a list of the individual SQL statements. Other code-adjacent internal cleanups. (check-in: 69d36a6aa5 user: stephan tags: trunk) | |
| 10:53 | Avoid a segfault that could occur when running the recover API on a database handle with memory-mapping enabled. (check-in: e02c697281 user: dan tags: trunk) | |
| 01:22 | Extra OOM check in shell_error_context() of the CLI. forum post 5708841db0. (check-in: cb12ac5de1 user: drh tags: trunk) | |
|
2022-10-30
| ||
| 11:39 | Add oo1.DB.selectArray() and selectObject(). (check-in: 7660db2a2e user: stephan tags: trunk) | |
| 11:22 | Refactoring towards being able to distinguish locking-related errors from non-locking errors in OPFS VFS operations. On a branch because it's not yet clear whether this is a misuse of the SQLITE_IOERR_... codes. Edit: indeed, this is a misuse of the result codes. (Closed-Leaf check-in: 646fe2ce87 user: stephan tags: opfs-locking-result-codes) | |
| 10:24 | Adjust automatic OPFS locking retries such that they will wait up to a total of 3 seconds spanning 4 attempts. (check-in: bbce49d81a user: stephan tags: trunk) | |
| 09:47 | Minor WASM build cleanups. Enable custom Module.instantiateWasm() when not in WASMFS mode (where it doesn't work). Add sqlite3.debugModule URL param to enable some module-init-time debugging output. (check-in: 50f678846a user: stephan tags: trunk) | |
| 08:39 | Reduce wasm module's starting memory from 128mb to 16mb. The latter value is needed only for WASMFS-based batch-runner.js, as WASMFS builds cannot be configured for dynamic memory growth without a tremendous performance hit. (check-in: ed9d93c487 user: stephan tags: trunk) | |
| 07:01 | Minor updates to the Windows batch tools. (check-in: b42f56205f user: mistachkin tags: trunk) | |
|
2022-10-29
| ||
| 12:31 | Update ext/wasm/README.md for recent developments. (check-in: c76ec31ebf user: stephan tags: trunk) | |
| 10:14 | More styling of module-symbols.html. (check-in: a36f42a836 user: stephan tags: trunk) | |
| 09:45 | Expand and document the wasm doc-update make rules. Extend the dist rules to fail more readily if there's a problem. (check-in: 362ec11ec0 user: stephan tags: trunk) | |
| 07:54 | Move the sqlite3.capi.wasm namespace to sqlite3.wasm. This causes a tiny bit of naming confusion with the sqlite3.wasm *file*, but seems to make more sense than having it as a sub-namespace of capi. (check-in: 3f16eb18d6 user: stephan tags: trunk) | |
|
2022-10-28
| ||
| 18:52 | Fix harmless compiler warnings in testing code. (check-in: 2f53612388 user: drh tags: trunk) | |
| 18:35 | Add sqlite3recover() support to fuzzcheck. (check-in: e65c5bdc5b user: drh tags: trunk) | |
| 14:33 | Remove sqlite3_interrupt() from the WASM build, as it is essentially impossible to employ in JS's threading model. (check-in: e853875900 user: stephan tags: trunk) | |
| 11:40 | Add ext/wasm/module-symbols.html. Adjacent minor JS touchups. (check-in: 24f12e681e user: stephan tags: trunk) | |
| 10:36 | Minor sqlite3.oo1 API reorg prompted by documenting. (check-in: 55237924ca user: stephan tags: trunk) | |
|
2022-10-27
| ||
| 23:17 | Fix a minor problem with sqlite_dbdata. (check-in: 58c2e49279 user: drh tags: trunk) | |
| 20:27 | Fix another crash in the recover extension triggered by a corrupt database. (check-in: d125377378 user: dan tags: trunk) | |
| 19:06 | Fix another problem to do with recovering from in-memory databases. (check-in: 5a7bfd4a21 user: dan tags: trunk) | |
| 19:02 | Ensure that the VFS wrapper in the recover extension does not attempt to invoke undefined methods on the underlying VFS. (check-in: 347c575108 user: dan tags: trunk) | |
| 18:35 | Fix an assert() failure in the recover extension triggered by a zero value as the first page-number in an overflow page chain. (check-in: 44c0874c33 user: dan tags: trunk) | |
| 18:20 | In the CLI, ensure that input to utf8_width_print is not NULL, or if it is, change it to an empty string. For for the problem reported by forum post 2961cf13eec61876. (check-in: 9ecc9d25ea user: drh tags: trunk) | |
| 18:19 | Change the name of the ".recover" command option "--freelist-corrupt" to "--ignore-freelist". (check-in: afce8443ac user: dan tags: trunk) | |
| 14:41 | speedtest1.html: when vfs==kvvfs, increase --size from 2 to 4, as enabled by [a4d40f6346e7]. --size 5 is 4.96mb out of (supposedly) 5mb, which works but is a bit too close to the edge. (check-in: a608d584a8 user: stephan tags: trunk) | |
| 14:28 | Automatically set temp_store=MEMORY if the VFS is kvvfs. (check-in: a4d40f6346 user: drh tags: trunk) | |
| 14:00 | Do not accept a NULL pointer for the filename in KVVFS. (check-in: fdecbd3b5b user: drh tags: trunk) | |
| 12:46 | The kvvfs VFS should remember the page size when writing to the database. (check-in: fc5503c8ac user: drh tags: trunk) | |
| 11:32 | Re-enable the .recovery and .dbinfo commands in shell.c.in in the fiddle build, as those were fixed by [3d20d77a3511] and [cd0aa27d1732]. (check-in: ba3a7a4a99 user: stephan tags: trunk) | |
| 11:25 | Do not use sqlite3_result_text16() in the recover extension if SQLITE_OMIT_UTF16 is defined. (check-in: 3d20d77a35 user: dan tags: trunk) | |
| 11:12 | Fix a problem with running ".recover" on an in-memory database. (check-in: 87b4cca2b8 user: dan tags: trunk) | |
| 10:51 | Do not use sqlite3_mutex_xxx() functions in sqlite3recover.c when built with SQLITE_THREADSAFE=0. (check-in: cd0aa27d17 user: dan tags: trunk) | |
| 03:57 | Minor doc typo fixes. (check-in: ed8d3f25a4 user: stephan tags: trunk) | |
| 03:56 | Restructure and simplify the feature-detection #defines of the recovery support in shell.c.in and disable it when building fiddle because it uses features we elide from the wasm build (e.g. utf16), leading to link errors. (check-in: ddd10c05c5 user: stephan tags: trunk) | |
| 03:03 | Expose sqlite3_randomness() to WASM and add a custom binding for it which can populate a JS byte array. Add WhWasmUtil.isPtr(). (check-in: 333e67076b user: stephan tags: trunk) | |
|
2022-10-26
| ||
| 21:14 | Disable the push-down optimization for sub-queries that are INTERSECT, UNION or EXCEPT compounds. dbsqlfuzz a34f455c91ad75a0cf8cd9476841903f42930a7a. This corrects an issue that was introduce 12 days earlier by [ed14863dd72e35fa]. (check-in: 346a3b12b8 user: dan tags: trunk) | |
| 20:12 | Remove an unused variable from the recovery extension. (check-in: a029dddff4 user: drh tags: trunk) | |
| 18:41 | Add the "recover" extension in ext/recover/, for salvaging data from corrupt databases. (check-in: a820792548 user: dan tags: trunk) | |
| 18:29 | Remove an undefined left-shift operation from the recover extension. (Leaf check-in: a67082357a user: dan tags: recover-extension) | |
| 18:22 | Merge further changes from trunk, including fix to dbdata.c. (check-in: bcf6b48d52 user: dan tags: recover-extension) | |
| 18:04 | Make the shell .recover command and the dbdata.c module more robust in the face of corrupted databases. (check-in: 4eef562a00 user: dan tags: trunk) | |
| 15:40 | Correct misuse of localhost-mode-only symbol S in fiddle-worker.js, which should fix the outage reported in forum post 67d985ac0bbe407f. (check-in: 3b5aa50c22 user: stephan tags: trunk) | |
| 15:34 | Corrected link to fiddle in ext/wasm/index.html (broken by [3d7b4f36b7dd]). (check-in: 6efa0bae16 user: stephan tags: trunk) | |
| 11:27 | Replace the newly-removed oo1.DB.getFilename() with DB.dbFilename() with the hope that the distinction from the dbInstance.filename property is clearer. (check-in: 0b80543d75 user: stephan tags: trunk) | |
| 11:12 | Remove oo1.DB.hasFilename() and getFilename(), as they are unnecessary. (check-in: 75c546b982 user: stephan tags: trunk) | |
| 11:11 | Remove the sqlite3StdTypeMap global constant that was made obsolete by [aa6e908619624867]. (check-in: 3dfdfb3f12 user: drh tags: trunk) | |
| 06:05 | Add --download-version flag to ext/wasm/version-info.c and correct dist target's output version format to match. (check-in: 6f2a40d06d user: stephan tags: trunk) | |
|
2022-10-25
| ||
| 16:57 | Add doc page link to the wasm dist README.txt. (check-in: c2380668d9 user: stephan tags: trunk) | |
| 16:04 | Correct -O level for fiddle build when built from the top-most directory (-Os instead of -O0). (check-in: ff4fc29c38 user: stephan tags: trunk) | |
| 15:59 | Rename fiddle.html to index.html and move fiddle push-to-server rules from GNUmakefile into fiddle.make. (check-in: 3d7b4f36b7 user: stephan tags: trunk) | |
| 15:38 | speedtest1: use the current (or default) vfs->xDelete method to unlink the db. This is specifically necessary when running the opfs vfs in a wasm build of speedtest1. This worked without this fix until recently because the affected test code was performing similar acrobatics in its stead. (check-in: d3c830bd37 user: stephan tags: trunk) | |
| 13:44 | Enhance the sqlite3_strglob() and sqlite3_strlike() interfaces so that they will do sensible things with NULL string pointers. This is an extra layer of defense against bugs such as reported by forum post 730b554179. (check-in: 8ba9c884bd user: drh tags: trunk) | |
| 13:42 | Make the ".dump" command of the CLI more robust against malformed databases. See forum post 730b554179. (check-in: 0573edfb9e user: drh tags: trunk) | |
| 11:05 | Merge latest trunk changes with this branch. (check-in: 757e3f5859 user: dan tags: recover-extension) | |
| 08:41 | Minor doc tweaks in the JS GNUmakefile. (check-in: 9c8df130b8 user: stephan tags: trunk) | |
| 08:15 | Remove persistence from the 'reverse log order?' checkbox in tester1.js to eliminate an inconsistency between the main-thread and worker-thread modes (the latter having no option for persistence of that setting). (check-in: ecf906b07f user: stephan tags: trunk) | |
| 08:06 | Minor cleanups and doc improvements in the OPFS sqlite3_vfs proxy. (check-in: 48645f7bca user: stephan tags: trunk) | |
|
2022-10-24
| ||
| 21:58 | This check-in attempts to make the SrcItem object smaller by combining the zDatabase and pSchema fields into a single union. It mostly works, but there are some issues, and the performance savings is minimal. So it is side-tracked onto this dead-end branch. (Closed-Leaf check-in: 80fbb30f28 user: drh tags: failed-opt-attempt) | |
| 18:42 | Fix typo in comment. (check-in: f65c95658f user: drh tags: trunk) | |
| 18:33 | Add a comment to a previously undescribed member of the Walker union. (check-in: 69d704224e user: drh tags: trunk) | |
| 15:51 | Use the same "PRAGMA synchronous" setting for the output of a "VACUUM INTO" as are configured for the database being vacuumed. (check-in: 86cb21ca12 user: dan tags: trunk) | |
| 13:20 | Improve the ability of the query planner to recognize covering indexes even on tables with more than 63 columns and where the index is over columns beyond the 63rd column. (check-in: f058773e41 user: drh tags: trunk) | |
| 12:38 | Update the fuzzinvariant logic in fuzzcheck to the latest code from dbsqlfuzz. (check-in: 739ad58476 user: drh tags: trunk) | |
| 11:10 | Fix built-in documentation for the ".mode qbox" command in the CLI. (check-in: 3d7ea33be1 user: drh tags: trunk) | |
| 11:02 | Test cases for covering indexes on wide tables. (Closed-Leaf check-in: 64c3777eb3 user: drh tags: covering-index-enh) | |
|
2022-10-23
| ||
| 20:09 | The wide-table covering index detection must take into account aggregate queries. (check-in: 9ac73f83c5 user: drh tags: covering-index-enh) | |
|
2022-10-22
| ||
| 23:09 | More frequently send the complete SELECT statement into sqlite3WhereBegin() so that it can more accurately determine index coverage. (check-in: f6d09c5a0d user: drh tags: covering-index-enh) | |
| 20:13 | Enhance the query planner with the ability to discern when an index is covering even when it indexes columns well beyond the 63rd column. (check-in: 1390417be4 user: drh tags: covering-index-enh) | |
| 14:16 | This branch attempts to improve the detection of covering indexes. This first check-in merely improves a parameter name to sqlite3WhereBegin() to be more descriptive of what it contains, and ensures that a subroutine is not inlines so that sqlite3WhereBegin() runs slightly faster. (check-in: cadf5f6bb1 user: drh tags: covering-index-enh) | |
| 13:49 | Clarification on the meaning of SrcList and SrcItem and especially the SrcItem.colUsed and Index.colNotIdxed fields. Comment changes only - no changes to code. (check-in: d96f6cc847 user: drh tags: trunk) | |
|
2022-10-21
| ||
| 20:12 | Begin transitioning the fixed-length (64-bit) bitmap used to keep track of the subset of columns of a table that are used by a query into a more general structure that can work with wide tables. Experimental. (Closed-Leaf check-in: 5dd7858820 user: drh tags: column-set) | |
| 17:48 | Add SQLITE_DQS to the compileoptions_used list, per request in forum post 8b1060122b. Force DQS=0 in sqlite3-wasm.c. (check-in: fcd9e0dbe3 user: stephan tags: trunk) | |
| 17:37 | Macro name typo fix in OS_KV builds. (check-in: 9cf1142b0c user: stephan tags: trunk) | |
| 17:18 | Ensure that the RtreeCell object in rtreeUpdate has all bytes initialized. (check-in: 1e38742bde user: drh tags: trunk) | |
| 06:58 | Add kvvfs tests to tester1.js. Fix a scopedAlloc() misuse in oo1.DB ctor caused by refactoring earlier this morning (and caught by these new tests). (check-in: 8e0f001ab7 user: stephan tags: trunk) | |
| 06:26 | Add timing info and OPFS sanity tests to tester1.js (check-in: 99915b0076 user: stephan tags: trunk) | |
| 05:27 | Expose sqlite3_vfs_unregister() to WASM and unregister kvvfs in Worker threads to avoid its unintended use there (in contexts other than local/sessionStorage). Correct registration of window functions, extend oo1.DB.createFunction() to support window functions, and add window function tests to tester1.js. Correct an incorrect 1-arg handling case for DB.exec(). Add per-test assertion counts to tester1.js. (check-in: f07ce15479 user: stephan tags: trunk) | |
|
2022-10-20
| ||
| 23:48 | Make semantics for UDF xFinal() result handling and error reporting handling more flexible. (check-in: 89f3e1982e user: stephan tags: trunk) | |
| 21:28 | Add more JS tests. Flesh out the aggregate UDF tests to use sqlite3_aggregate_context() so that they can each be used multiple times in the same statement. Add sqlite3_js_aggregate_context() convenience helper. (check-in: 9d034ef5e1 user: stephan tags: trunk) | |
| 18:58 | Apply magic.txt correction and addition reported in forum post 2d2366a04a0385. (check-in: 9bf26e2aa3 user: stephan tags: trunk) | |
| 18:31 | Rename sqlite3_web_... to sqlite3_js_... Document the worker1.close.unlink option. Fix unlink usage in speedtest1.html. Minor JS build cleanups. (check-in: ac9af71b72 user: stephan tags: trunk) | |
| 16:30 | Add a bit to the optimization disabling mask for the indexed expression optimization. (check-in: 56df1482ab user: drh tags: trunk) | |
| 16:22 | Add test case for previous commit. (check-in: 535867a9c8 user: dan tags: trunk) | |
| 16:12 | Only enable the bMaybeNullRow flag on IndexedExpr for an index on an expression, not on a virtual column. But do enable it for the right operand of a right join. (check-in: a9657c87c5 user: drh tags: trunk) | |
| 13:36 | The generalized indexed expression optimization of [2435112867fbd7b6] makes the prior [a47efb7c8520a011] enhancement from 2017 obsolete. This check-in removes the older optimization. (check-in: 56442c9bdd user: drh tags: trunk) | |
| 10:46 | Fix minor problems in test1.c test code. (check-in: 6e545e2b84 user: dan tags: trunk) | |
| 05:14 | Rework sqlite3_wasm_vfs_unlink(), add sqlite3_wasm_db_vfs(), update some docs. (check-in: cdd46858f0 user: stephan tags: trunk) | |
| 04:00 | Minor internal JS cleanups. (check-in: 818ef0b5c9 user: stephan tags: trunk) | |
|
2022-10-19
| ||
| 18:04 | In the CLI, never use strcmp() or strncmp() directly. Instead use wrapper functions cli_strcmp() and cli_strncmp() that work correctly even if the input is a NULL pointer. Forum post 142b868da7560d0b. (check-in: 7450a561f8 user: drh tags: trunk) | |
| 18:03 | Move file /ext/misc/dbdata.c to the /ext/recover/ directory. (check-in: f6d5ac807e user: dan tags: recover-extension) | |
| 11:58 | Fix references to "SrcList_item" in comments as that object has since [bfd5bf2c73110fcb] (2021-02-21) been called "SrcItem". Comment changes only. No changes to code. (check-in: e3648a07f5 user: drh tags: trunk) | |
| 10:56 | If a query uses an index where one or more of the columns of the index is an expression or a virtual column, and if the corresponding expression is used elsewhere in the query, then strive to read the value of the expression out of the index, rather than recomputing it. This is the "Indexed Expression Optimizations". (check-in: 2435112867 user: drh tags: trunk) | |
| 07:51 | Update the wasm/js 'push' rule to account for this morning's changes. (check-in: c4a0f745fb user: stephan tags: trunk) | |
| 07:34 | Rename several demo/test files and include more of them in the end-user dist archive. (check-in: 9c85835f6f user: stephan tags: trunk) | |
| 06:14 | Minor wasm/js build tweaks. (check-in: bcbee1ec01 user: stephan tags: trunk) | |
| 06:06 | Update the dist rules for this evening's js/wasm build changes and include an index.html specifically for the subset of apps included in the dist archive. (check-in: a0ef0f32e9 user: stephan tags: trunk) | |
| 04:44 | Apply considerable acrobatics to get the JS/WASM deliverables building to and loadable from a directory other than the one which contains the app-level code. Requires an only-slightly-leaky abstraction of passing a URL argument when loading sqlite3.js but provides much greater flexibility in where the JS/WASM files are located. (check-in: 6d468dab9e user: stephan tags: trunk) | |
| 01:07 | Considerable wasm/js build cleanups and reworking. Remove wasmfs builds from the end-user deliverables and disable the wasmfs build by default, per /chat discussion, as it doubles our deliverable count for only marginal gain. Attempt to move the sqlite3.js/wasm files into subdirectories but rediscovered that that breaks loading in Worker mode because URI resolution of the wasm files differs depending on whether the main script is loaded from a script tag or a Worker. (check-in: 5b23e0675e user: stephan tags: trunk) | |
|
2022-10-18
| ||
| 22:37 | If a virtual column whose value is constant gets indexed, do not include that column in the IndexedExpr list. dbsqlfuzz 59ac17a99b9a5c4930ee71cc153c9428a0c0e794 (Closed-Leaf check-in: c21eb903f0 user: drh tags: index-expr-opt) | |
| 20:36 | More work on the JS end-user deliverables. Add tool/stripccomments.c to support that. (check-in: 2156f0744a user: stephan tags: trunk) | |
| 20:27 | Improved byte-code comments for the OP_Column opcodes used by the indexed expression optimization. (check-in: bf6d837fdd user: drh tags: index-expr-opt) | |
| 16:47 | Fix the indexed expression resolver for generated columns so that it picks the correct table in a self-join. (check-in: 54c3eb085a user: drh tags: index-expr-opt) | |
| 16:32 | Merge recent trunk fixes into the index-expr-opt branch. (check-in: 6198ab4b87 user: drh tags: index-expr-opt) | |
| 15:02 | Add new test file windowE.test, to test the window functions modules response to an inconsistent collation sequence. (check-in: 740a2eb092 user: dan tags: trunk) | |
| 13:27 | Correct sort order for serial-type 10 entries in the database file. This is a continuation of [4fb77e96fa89a23a]. (check-in: 904b54625d user: drh tags: trunk) | |
| 11:28 | Merge trunk fixes into the index-expr-opt branch. (check-in: c7b9cc645b user: drh tags: index-expr-opt) | |
| 10:27 | Fix sqlite3VdbeRecordCompareWithSkip() so that it sorts the internal-use serial-type of 10 together with NULLs. dbsqlfuzz 5ff35e9d49a5fcca5051e23960ff2f483a538bab (check-in: 4fb77e96fa user: drh tags: trunk) | |
|
2022-10-17
| ||
| 17:36 | Add ext/wasm/README-dist.txt, intended to have been in the previous checkin. (check-in: c9080b6505 user: stephan tags: trunk) | |
| 17:34 | Initial draft of archive generation for the wasm/js deliverables. (check-in: f6cee114c7 user: stephan tags: trunk) | |
| 16:47 | Repair version-info.c after a local mishap caused all of the intended edits from [36e197cb3d0c]/[e9b407a4d0a0] to get deleted before checkin. Simplify version-info build (only requires sqlite3.h, not the library). (check-in: 6e511df500 user: stephan tags: trunk) | |
| 16:31 | Merge trunk changes into the index-expr-opt branch. (check-in: a1485ce6c8 user: drh tags: index-expr-opt) | |
| 16:09 | Fix a potential call to strlen() with a null argument in the command-line shell following an OOM error. forum post 9c4f2ebe22. (check-in: b6413a6dff user: drh tags: trunk) | |
| 15:53 | Missing file-rename for the previous checkin. (check-in: e9b407a4d0 user: stephan tags: trunk) | |
| 15:52 | Rework ext/wasm/version-info.c to make it more useful for the upcoming dist build rules. (check-in: 36e197cb3d user: stephan tags: trunk) | |
| 14:46 | Improved comments and function names. No logic changes. (check-in: 8f460b3b15 user: drh tags: index-expr-opt) | |
| 14:30 | Get the indexed expression optimization working for virtual generated columns. (check-in: 8a510cb088 user: drh tags: index-expr-opt) | |
| 14:29 | Merge trunk enhancements into index-expr-opt branch. (check-in: 56ef97e64e user: drh tags: index-expr-opt) | |
| 10:15 | Make use of alloca() in wherePathSolver() when SQLITE_USE_ALLOCA is defined. (check-in: 4575247152 user: drh tags: trunk) | |
| 09:56 | Remove a use of alloca() that does more harm than good. (check-in: 2ab3cf4d71 user: drh tags: trunk) | |
|
2022-10-16
| ||
| 23:33 | Typo fix. (check-in: 650126c92a user: stephan tags: trunk) | |
| 18:57 | Minor tweak to get bring an edge case of oo1.DB.createFunction() into aggreement with its docs. (check-in: 8d59ccd9f3 user: stephan tags: trunk) | |
| 18:50 | Add aggregate function support to sqlite3.oo1.DB.createFunction(). Change signature of the options object used by that function so that the callback property names match those of the corresponding C APIs. (check-in: a7db6e4b50 user: stephan tags: trunk) | |
| 16:38 | JS: add build-time-generated version info to the sqlite3.version object. Remove some stray debug output from tester1.js. (check-in: b5f462c2d8 user: stephan tags: trunk) | |
| 15:38 | Add a top-level license and build-time version info header to generated sqlite3*.js. Correct a broken link in ext/wasm/index.html. (check-in: 0f1a06e8e3 user: stephan tags: trunk) | |
|
2022-10-15
| ||
| 19:18 | Exclude slow test recovercorrupt.test from veryquick.test. (check-in: ff9a733532 user: dan tags: recover-extension) | |
| 18:26 | Add missing comments and fix other code issues. (check-in: 8ed4e4a80d user: dan tags: recover-extension) | |
| 15:39 | Merge latest trunk changes. (check-in: 42255ead8e user: dan tags: recover-extension) | |
| 12:01 | Enable the index-on-expression optimization even when the expression is used as an argument to an aggregate function. (check-in: 462b3c7f39 user: drh tags: index-expr-opt) | |
| 11:27 | Only extract an expression from an index when the index is not a null row in an outer join. (check-in: 08b033c737 user: drh tags: index-expr-opt) | |
|
2022-10-14
| ||
| 19:56 | Merge fixes from trunk. (check-in: 1cb65f36c3 user: drh tags: index-expr-opt) | |
| 19:30 | Fix a problem with using the push-down optimization on compound SELECTs where component SELECTs use different collation sequences. dbsqlfuzz 11516f050100243e5a845f5a2b48a90ed2efaf2e. This problem appears to go all the way back to the beginning of the push-down optimization in check-in 6df18e949d367629 in SQLite 3.8.11. (check-in: ed14863dd7 user: dan tags: trunk) | |
| 19:21 | Add missing initializer from the extension loader. Fix for check-in [d6d449978245b4fa]. (check-in: 565d74c36f user: drh tags: trunk) | |
| 15:52 | Generic minor cleanups and docs in the OPFS async proxy. (check-in: a4423ca234 user: stephan tags: trunk) | |
| 15:10 | Fix a problem in the LIKE and GLOB operators that may occur when the character immediately following a "%" or "*" wildcard is U+80. Reported by forum post 61bf7ccbdf. (check-in: 2da677c45b user: dan tags: trunk) | |
| 13:26 | Remove a resolved TODO comment. (check-in: 32fd4ac382 user: stephan tags: trunk) | |
| 02:00 | Cancel IndexExpr objects when they go out of scope. (check-in: 0963519371 user: drh tags: index-expr-opt) | |
|
2022-10-13
| ||
| 21:08 | This experimental branch attempts to use columns for an index-on-expression in place of the expression that is being indexed. This particular check-in mostly works, but there are still issues. (check-in: 2e8d4fd4cf user: drh tags: index-expr-opt) | |
| 16:48 | Move the rest of testing1.js into tester1.js and eliminate the dependency on jaccwabyt_test.c. Extend the list of default config-related #defines in sqlite3-wasm.c and reorganize them for maintainability. (check-in: 4e2a8aff2d user: stephan tags: trunk) | |
| 15:09 | Optimize the IS NULL and IS NOT NULL operators so that they avoid loading large strings or blobs off of disk if all it needs to know is whether or not the string or blob is NULL. (check-in: cb94350185 user: drh tags: trunk) | |