Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
889 check-ins using file ext/wasm/GNUmakefile version 0e362f3fc0
|
2025-02-19
| ||
| 00:18 | Version 3.44.4 (Leaf check-in: f1e31fd996 user: drh tags: branch-3.44, version-3.44.4, patch-release) | |
|
2025-02-18
| ||
| 18:05 | Cherry pick recent fixes into branch-3.44. (check-in: 75bbd094db user: drh tags: branch-3.44) | |
|
2024-04-12
| ||
| 15:15 | Mark the BTree cell overflow cache as invalid whenever the rowid goes invalid. (check-in: 0ec6669c84 user: drh tags: branch-3.44) | |
|
2024-04-09
| ||
| 14:08 | Ignore CHECK constraints when qualifying the xfer optimization while running VACUUM. (check-in: 944d1b6eb3 user: drh tags: branch-3.44) | |
|
2024-04-05
| ||
| 14:13 | Check-in a9657c87c53c1922 is wrong: the IndexedExpr.bMaybeNullRow flag is required for virtual columns if they are part of an outer join. Add a test case to prove it. (check-in: 083b0f7e77 user: drh tags: branch-3.44) | |
| 11:28 | When compiling with SQLITE_ALLOW_ROWID_IN_VIEW, if the RETURNING clause of an UPDATE of a view specifies a rowid, then return NULL for the value of that rowid. This is version 3.44.3. (check-in: d38cfa6067 user: drh tags: branch-3.44, version-3.44.3) | |
|
2024-03-24
| ||
| 21:15 | Fix the xBestIndex method of the pragma virtual table so that it correctly gives a higher cost to plans where the schema hidden parameter is unconstrained. (check-in: d68fb8b5db user: drh tags: branch-3.44) | |
| 16:42 | Do not automatically assume that ROWID is NOT NULL when compiled with SQLITE_ALLOW_ROWID_IN_VIEW. dbsqlfuzz 31b38eeb63a4e1562de665078f52b7b47a7543cf (check-in: b5d2dce18f user: drh tags: branch-3.44) | |
|
2024-03-21
| ||
| 22:08 | Fix a assert() that is incorrect, though harmless. Also add a test case. (check-in: 57b0c98460 user: drh tags: branch-3.44) | |
|
2024-03-20
| ||
| 16:29 | Fix test cases for rtree and fts5. No changes to code. (check-in: 633dca9074 user: drh tags: branch-3.44) | |
| 16:04 | Have rtree avoid keeping a blob handle open following an error. (check-in: 1303716a11 user: drh tags: branch-3.44) | |
| 15:26 | Following a ROLLBACK that reverts changes to an RTREE, any pending queries against that same RTREE abort with code SQLITE_ABORT_ROLLBACK. dbsqlfuzz de7d17b72d0e842352c998dd86a47b7d0f707be9. (check-in: b26e5a500e user: drh tags: branch-3.44) | |
| 12:19 | Back port various minor patches (check-in: a1a5c427c2 user: drh tags: branch-3.44) | |
| 11:36 | Automatically disable the DISTINCT optimization during query planning if the ORDER BY clause exceeds 63 terms. dbsqlfuzz afd1d61fc27d14938a0d78a50970fa1e9fbfee58. (check-in: e8d5caef26 user: drh tags: branch-3.44) | |
| 11:30 | Ignore COLLATE operators when determining whether the result of a subexpression should be shallow-copied or deep-copied. (check-in: dd58d1178f user: drh tags: branch-3.44) | |
| 11:25 | Fix a harmless compiler warning in the randomjson.c extension. (check-in: a4c9351234 user: drh tags: branch-3.44) | |
| 11:24 | If a term of an ORDER BY or GROUP BY contains an aggregate function or column, then it is not an alias that needs to be resolved, so don't try to. This fixes a harmless assertion found by dbsqlfuzz. (check-in: e7ba2af5a1 user: drh tags: branch-3.44) | |
| 11:04 | Fix the SQLITE_ALLOW_ROWID_IN_VIEW bug-compatibility option so that it works again. Add the SQLITE_CONFIG_ROWID_IN_VIEW sqlite3_config() value to optionally disable the bug-compatibility mode at start-time. Enable testing of SQLITE_ALLOW_ROWID_IN_VIEW. (check-in: acc08353e2 user: drh tags: branch-3.44) | |
|
2024-03-19
| ||
| 10:46 | Fix a problem involving infinities int the Kahan-Babushka-Neumaier summation algorithm. (check-in: 0984e5cd25 user: drh tags: branch-3.44) | |
|
2024-03-08
| ||
| 14:16 | Silently ignore redundant ON CONFLICT clauses in an UPSERT. (check-in: e546d8c685 user: drh tags: branch-3.44) | |
|
2024-01-23
| ||
| 16:21 | In os_unix.c and os_win.c, do not allow xFetch() to return a pointer to a page buffer that is right at the end of the mapped region - if the database is corrupted in a specific way such a page buffer might be overread by several bytes. (check-in: 198a1daae0 user: drh tags: branch-3.44) | |
|
2023-12-22
| ||
| 15:42 | Update #ifdef checks in pager.c and util.c to account for [0462a2612d1fc1d0] to resolve the build problem reported in forum post 9819032aac. (check-in: 7374c2342e user: stephan tags: branch-3.44) | |
|
2023-12-19
| ||
| 13:00 | When unable to resolve an identifier, change the Expr node into TK_NULL rather than TK_COLUMN, to prevent any downstream misuse of the non-existent column. (check-in: 8f770d14d3 user: drh tags: branch-3.44) | |
|
2023-12-13
| ||
| 16:50 | Avoid invoking sqlite3ExprColUsage() on an unresolve column reference. (check-in: 6e0e2ee7c7 user: drh tags: branch-3.44) | |
|
2023-12-12
| ||
| 17:55 | Worker1 Promiser API: when multiple db connections are active then use the requested connection instead of always the first-opened connection. Bug reported in forum post 894c330e7f23b177. (check-in: 3874e5a328 user: stephan tags: branch-3.44) | |
|
2023-12-11
| ||
| 13:48 | Different fix for the fts5 COMMIT-following-OOM problem first fixed by [fba3129d]. This one does not cause problems if an fts5 table is renamed and then dropped within the same transaction. (check-in: 67da596d82 user: dan tags: branch-3.44) | |
|
2023-12-05
| ||
| 19:24 | Use extra assert() statement to silence harmless static analyzer warnings. (Closed-Leaf check-in: 174c2b2eef user: drh tags: jsonb) | |
| 18:28 | Miscellaneous comment cleanup and typo fixes. (check-in: 59446dc0bd user: drh tags: jsonb) | |
| 12:52 | Use strspn() to accelerate whitespace bypass in the JSON parser. (check-in: 843197df08 user: drh tags: jsonb) | |
| 12:22 | Small performance gain by unwinding the string literal delimiter search loop in the JSON parser by one more level. (check-in: 4c587feac1 user: drh tags: jsonb) | |
| 12:20 | Clean up the JSONB performance test script. (check-in: 905301075a user: drh tags: jsonb) | |
| 01:44 | Use an assert() to fix a harmless static analyzer warning. (check-in: a249ca657e user: drh tags: jsonb) | |
| 00:17 | Fix OOM and corrupt JSONB handling in json_patch(). (check-in: 1910feb0b7 user: drh tags: jsonb) | |
|
2023-12-04
| ||
| 23:12 | Rename the internal routine jsonMergePatchBlob() to just jsonMergePatch(). (check-in: ebf667b616 user: drh tags: jsonb) | |
| 19:32 | Fixes to error handling in json_array_length(). (check-in: aa85df2d26 user: drh tags: jsonb) | |
| 19:14 | Do not make the input JSONB editable in json_remove() if there are no PATH argument. (check-in: 66594544f3 user: drh tags: jsonb) | |
| 18:53 | Fix errors in rendering JSON5 escape sequences embedded in JSONB. (check-in: f1a51ae386 user: drh tags: jsonb) | |
| 17:40 | Continuing simplifications and code cleanup. (check-in: ddf92b5059 user: drh tags: jsonb) | |
| 16:01 | Remove reachable ALWAYS and NEVER macros. (check-in: f601de3eea user: drh tags: jsonb) | |
| 15:22 | Two new NEVER macros. (check-in: 52632c92cb user: drh tags: jsonb) | |
| 13:12 | Repair issues and inefficiencies found during testing. (check-in: ae973cb151 user: drh tags: jsonb) | |
| 01:14 | Better pre-scan size estimations for objects in the JSON parser resulting in fewer reallocations and memmove operations. (check-in: 526b27f908 user: drh tags: jsonb) | |
| 00:31 | Back off on the use of strlen() for situations where sqlite3_value_bytes() will work as well, for performance. (check-in: 79fb54fbb8 user: drh tags: jsonb) | |
|
2023-12-03
| ||
| 23:38 | Remove dead code. Improved reporting of errors in JSON inputs. (check-in: 2eaa738e6b user: drh tags: jsonb) | |
| 23:30 | Avoid problems when the path argument to json_tree() contains embedded U+0000 characters. (check-in: 9f055091af user: drh tags: jsonb) | |
| 20:11 | Ensure that OOM conditions in the generation of the "bad JSON path" error message result in an SQLITE_NOMEM error. (check-in: aa0e02b5c2 user: drh tags: jsonb) | |
| 19:59 | Enable incorrect JSONB to be rendered into text without hitting an assertion for a bad whitespace escape in a string. (check-in: 4d6a9a217d user: drh tags: jsonb) | |
| 19:32 | Partial hand-merge of shell.c.in (not buildable) (Leaf check-in: 62e90c9ba8 user: larrybr tags: cli_extension_wip) | |
| 11:54 | Do not let bad hexadecimal digits in malformed JSONB cause an assertion fault. (check-in: 8dec1ba1e5 user: drh tags: jsonb) | |
| 00:51 | Minor code changes for consistency and to simplify testing. (check-in: df272bd837 user: drh tags: jsonb) | |
|
2023-12-02
| ||
| 21:39 | Implement strict JSONB checking in the json_valid() function. (check-in: 0f26d38880 user: drh tags: jsonb) | |
| 20:37 | Fix harmless compiler warnings reported by MSVC. (check-in: 419652c0c8 user: drh tags: jsonb) | |
| 20:25 | Code and comment cleanup. Everything should work the same. (check-in: c640754df0 user: drh tags: jsonb) | |
| 18:17 | Fix harmless compiler warnings. Refactor some identifier names for clearer presentation. (check-in: 7e39415027 user: drh tags: jsonb) | |
| 18:04 | Take extra care to ensure that JSONB values that are in cache are actually owned by the JSON subsystem, and that ownership of such values is not handed back to the bytecode engine. (check-in: 1304534001 user: drh tags: jsonb) | |
| 16:11 | Protect a memcpy() against OOM conditions. (check-in: 26144d1c25 user: drh tags: jsonb) | |
| 15:59 | Do not allow a JsonParse object to be considered "editable" after an OOM. (check-in: c6bacf57bd user: drh tags: jsonb) | |
| 15:06 | Fix potential unsigned integer underflow in jsonAppendString(). (check-in: d2fba2cbdc user: drh tags: jsonb) | |
| 14:55 | Minor fix to the header comment on jsonXlateTextToBlob(). (check-in: c3677ba410 user: drh tags: jsonb) | |
| 14:16 | Performance optimization in jsonAppendString(). (check-in: fdf00e9623 user: drh tags: jsonb) | |
| 13:36 | Simplification and optimization of the JSON parser. (check-in: f5ec948511 user: drh tags: jsonb) | |
| 01:38 | Unroll a loop in the parser for a performance increase. (check-in: a6dc29e4d5 user: drh tags: jsonb) | |
| 01:06 | Fix harmless compiler warnings and enhance performance the parser. (check-in: 285633da6d user: drh tags: jsonb) | |
|
2023-12-01
| ||
| 22:01 | Performance optimization in the JSON parser. (check-in: 68d191f40e user: drh tags: jsonb) | |
| 20:09 | Different approach to querying a tokendata=1 table. Saves cpu and memory. (check-in: c523f40895 user: dan tags: fts5-token-data) | |
| 18:49 | JSON cache is now more effective. (check-in: 443a3f3a8e user: drh tags: jsonb) | |
| 18:46 | Fix up the JSON cache to work better. (Closed-Leaf check-in: 1fdbc39521 user: drh tags: jsonb-cache) | |
| 13:28 | Cache is working better, but does not preserve the hasJson5 flag. (check-in: a12add7ab9 user: drh tags: jsonb-cache) | |
| 12:57 | First attempt to get the JSON text-to-binary cache working. All test cases pass, but the cache seems not to help much. (check-in: 25ed295f30 user: drh tags: jsonb) | |
|
2023-11-30
| ||
| 23:36 | Remove all trace of JsonNode from the JSON implementation. The JSONB format is used as the internal binary encoding for searching and editing. (check-in: 11ebb5f712 user: drh tags: jsonb) | |
| 20:57 | Convert json_valid() over to using only JSONB as its internal format. (check-in: 7b5756fa6d user: drh tags: jsonb) | |
| 19:29 | Convert json_type() to use JSONB internally. (check-in: 83074835b9 user: drh tags: jsonb) | |
| 19:11 | Convert json_insert(), json_replace(), and json_set() over to using only JSONB internally. (check-in: 4e2083e86f user: drh tags: jsonb) | |
| 19:06 | Enhance json_set() and json_insert() so that they create missing substructure. (Closed-Leaf check-in: cc7a641ab5 user: drh tags: jsonb-insert) | |
| 16:17 | Simplification of the new JSON insert/set test cases. (check-in: 04c0d56443 user: drh tags: jsonb-insert) | |
| 16:16 | New JSON test cases showing insert or set with missing substructure. (check-in: 6802b6459d user: drh tags: trunk) | |
| 12:04 | New test cases for insert/set/replace with paths that indicate substructure that does not yet exist. (check-in: 146c717c51 user: drh tags: jsonb-insert) | |
| 10:00 | Update some OPFS-related help text in WASM tests. Minor cleanups in speedtest1-worker.js. (check-in: 263f6d3a77 user: stephan tags: trunk) | |
| 00:52 | Convert json_insert(), json_replace(), json_set() to use JSONB internally. Mostly working, but some corner cases are still not quite right. (check-in: 99c8f6bd5c user: drh tags: jsonb-insert) | |
|
2023-11-29
| ||
| 20:06 | Convert the json_error_position() routine to use only JSONB internally. (check-in: e7a8ba35bf user: drh tags: jsonb) | |
| 17:36 | The json_patch() function now operates exclusively on JSONB. This patch also includes improvements to JSONB debug printing routines. (check-in: fee19d0098 user: drh tags: jsonb) | |
| 16:22 | Fix signed integer overflow in fts5. (check-in: 60e46c7ec6 user: dan tags: fts5-token-data) | |
| 13:47 | In the recovery extension, if a payload size is unreasonably large, it is probably corrupt, so truncate it. (check-in: 988c3179e9 user: drh tags: trunk) | |
| 12:18 | Merge all the latest trunk enhancements into the jsonb branch. (check-in: 1a59fcab21 user: drh tags: jsonb) | |
| 02:53 | Increase the patch level to 3.44.3. (check-in: bb4d35e262 user: drh tags: branch-3.44) | |
| 02:50 | Reference count the Table passed into the OP_VCheck opcode. (check-in: 79e6496bb1 user: drh tags: branch-3.44) | |
| 02:45 | The assertion change at check-in [7946c79567b0ccd3] is insufficient to fix the problem of a Table object being deleted out from under the OP_VCheck opcode. We need to reference count the Table, which is accomplished here. (check-in: cad269d5e2 user: drh tags: trunk) | |
| 01:38 | Convert the json_array_length() function to use JSONB instead of JsonNodes. (check-in: 5ab790736d user: drh tags: jsonb) | |
|
2023-11-28
| ||
| 23:26 | Fix all known problems with JSONB json_extract(). (check-in: d5f48c57e9 user: drh tags: jsonb) | |
| 23:18 | Do not set the J subtype when the output is JSONB. (Closed-Leaf check-in: 4f106b64fe user: drh tags: jsonb-extract) | |
| 20:33 | Preserve flexibility in the format of the RHS of -> and ->> operators found in legacy. (check-in: 6231ec43ad user: drh tags: jsonb-extract) | |
| 20:25 | Attempt to get json_extract() working with pure JSONB only, and without the use of JsonNode. Mostly working, but there are some differences from legacy in corner cases. (check-in: 8c324af1ec user: drh tags: jsonb-extract) | |
| 19:43 | Merge latest trunk updates into this branch. (check-in: 554fc13f2c user: dan tags: fts5-token-data) | |
| 18:16 | The json_remove() function now uses only JSONB, never JsonNodes, internally. (check-in: b69786e746 user: drh tags: jsonb) | |
| 17:47 | Update this branch with latest changes from trunk. (check-in: bead0d8f5a user: dan tags: begin-concurrent) | |
| 17:32 | Update this branch with latest changes from trunk. (check-in: 7f1b61a3ea user: dan tags: wal2) | |
| 17:12 | In SQLITE_ENABLE_SETLK_TIMEOUT builds, use blocking locks in place of sleep() calls when opening a read-transaction. (check-in: 4c055b7a6e user: dan tags: trunk) | |
| 15:29 | Handle an SQLITE_BUSY_TIMEOUT error if one occurs while attempting a shared lock on a read-lock slot. (Closed-Leaf check-in: 5fbf3906d2 user: dan tags: blocking-dms-lock) | |
| 13:38 | Activate the ability of json_patch() to work on JSONB. (check-in: 11aba347ff user: drh tags: jsonb) | |
| 13:35 | All legacy tests are passing. (Closed-Leaf check-in: 2c436806b8 user: drh tags: jsonb-patch) | |
| 12:28 | The json_patch() code for JSONB compiles and works sometimes, but there are still issues. Incremental check-in. (check-in: e0099464a0 user: drh tags: jsonb-patch) | |
| 00:27 | More aggressive use of jsonBlobEdit(). Improvements to the MergePatch implementation sketch. (check-in: fbca9570fd user: drh tags: jsonb) | |
|
2023-11-27
| ||
| 23:46 | Add untested (#ifdefed-out) code for the MergePatch algorithm against JSONB. Add (and test) the jsonBlobEdit() routine that is needed by the new MergePatch. (check-in: 4d353387fc user: drh tags: jsonb) | |
| 20:37 | Have SQLITE_ENABLE_SETLK_TIMEOUT builds block when locking a read-lock slot. (check-in: f797baf47c user: dan tags: blocking-dms-lock) | |
| 19:22 | In SQLITE_ENABLE_SETLK_TIMEOUT builds, use blocking locks in place of sleep() when opening a read-transaction. (check-in: a51ef39998 user: dan tags: blocking-dms-lock) | |
| 17:13 | Enhance the (SQLITE_DEBUG-only) json_parse() routine so that it shows a decoding of JSONB when given a BLOB argument. (check-in: af26786856 user: drh tags: jsonb) | |
| 15:57 | Give the json_valid() function an optional second argument that determines what is meant by "valid". (check-in: a4e19ad43d user: drh tags: jsonb) | |
| 15:08 | Pickup stray oput?() calls that should have gone to stdout. Simplify console line reading, sacrificing speed (which does not matter then) for code size. (Leaf check-in: 8e20645cc2 user: larrybr tags: console-io-lib) | |
| 12:36 | Convert the json_tree() and json_each() virtual tables over to use JSONB has their internal representation. (check-in: ec18caa3f7 user: drh tags: jsonb) | |
| 12:30 | All tests passing. (Closed-Leaf check-in: b5a5660ca2 user: drh tags: jsonb-tree) | |
|
2023-11-26
| ||
| 00:56 | Fix corner-case error conditions. (check-in: ec23d34ab7 user: drh tags: jsonb-tree) | |
| 00:48 | Same results as the legacy JsonNode implementation on a small set of test cases. (check-in: c3da4b079a user: drh tags: jsonb-tree) | |
|
2023-11-25
| ||
| 23:00 | Remove unused elements from the json_tree() cursor. (check-in: 914a50117d user: drh tags: jsonb-tree) | |
| 20:59 | Remove the vestigal JsonNode logic from json_tree() and json_each(). (check-in: 66c2ab9ebb user: drh tags: jsonb-tree) | |
| 19:28 | Almost working. Path is still not exactly right when Root is defined on json_tree(). (check-in: 9225824691 user: drh tags: jsonb-tree) | |
| 18:11 | Generate the fullkey and path columns of json_tree(). (check-in: ffaa468ab8 user: drh tags: jsonb-tree) | |
| 13:40 | Handle the path argument to json_tree() and json_each(). (check-in: fded888469 user: drh tags: jsonb-tree) | |
|
2023-11-24
| ||
| 21:57 | Continuing work on json_tree() against a JSONB. (check-in: 3df891cb11 user: drh tags: jsonb-tree) | |
| 20:14 | Add the --buildonly and --dryrun options to testrunner.tcl. (check-in: a0c87ae9d3 user: dan tags: trunk) | |
| 18:44 | Incremental progress toward getting json_each() and json_tree() to work directly off of a JSONB blob. (check-in: f8cab41b3b user: drh tags: jsonb-tree) | |
| 18:33 | Allow a pattern to filter test scripts to be appended to testrunner.tcl "mdevtest", "sdevtest" and "release" commands. e.g. "tclsh test/testrunner.tcl sdevtest fts5%". (check-in: f8ea0b58b3 user: dan tags: trunk) | |
| 16:17 | Get all CLI print calls which went to stdout in 3.44.0 to do so again. (check-in: d65d9579ee user: larrybr tags: console-io-lib) | |
| 15:58 | Get all CLI print calls which went to stdout in 3.44.0 to continue going to stdout. (check-in: e9951ede18 user: larrybr tags: trunk) | |
| 14:25 | Fix jsonParseReset() to properly clear the JsonParse.aBlob element. (check-in: ab2644aacf user: drh tags: jsonb) | |
| 14:03 | Omit precompiled binaries from the source tree. (check-in: 7dbc2f496d user: drh tags: jsonb) | |
| 14:02 | Omit precompiled binaries from the source tree. (check-in: 3a8a75bfd2 user: drh tags: console-io-lib) | |
| 14:01 | Omit the precompiled binary from the source tree. (check-in: 4ff103d294 user: drh tags: trunk) | |
| 13:41 | Merge the latest trunk enhancements and fixes into the jsonb branch. (check-in: a838ebcbbd user: drh tags: jsonb) | |
| 13:30 | CLI .output/.once to not redirect ".timer on" results. (check-in: 626c4353f2 user: larrybr tags: console-io-lib) | |
| 13:26 | CLI .output/.once to not redirect ".timer on" results. (check-in: ce766ed51f user: larrybr tags: trunk) | |
| 12:48 | Merge 3.44.2 changes into the reuse-schema-3.44 sub-branch. (Leaf check-in: 2b9d5ff78f user: drh tags: reuse-schema-3.44) | |
| 12:42 | Merge 3.44.2 changes into the bedrock-3.44 sub-branch. (Leaf check-in: 1d9dfad077 user: drh tags: bedrock-3.44) | |
| 12:38 | Merge 3.44.2 changes into the wal2-3.44 sub-branch. (Leaf check-in: 0118e8c981 user: drh tags: wal2-3.44) | |
| 12:33 | Merge 3.44.2 changes into the begin-concurrent-3.44 sub-branch. (Leaf check-in: 6d97426fff user: drh tags: begin-concurrent-3.44) | |
| 11:41 | Version 3.44.2 (check-in: ebead0e723 user: drh tags: release, branch-3.44, version-3.44.2) | |
|
2023-11-23
| ||
| 12:12 | Another assertion fault fix, similar to [a9443dbfbe25e588]. (check-in: f796da626b user: drh tags: branch-3.44) | |
| 11:59 | Fix a incomplete assert() statement in sqlite3SubqueryColumnTypes(). (Closed-Leaf check-in: 844e05ed82 user: drh tags: mistake) | |
| 11:45 | Fix harmless compiler warnings in debugging code. (check-in: db40272c36 user: drh tags: branch-3.44) | |
| 11:29 | Fix an fts5 problem that could occur when mixing regular and secure delete operations on a single table. (check-in: 25fb5a540b user: drh tags: branch-3.44) | |
| 11:21 | Increase the version number to 3.44.2. (check-in: 73d3cb7909 user: drh tags: branch-3.44) | |
| 11:18 | Fix an fts5 problem that could occur when mixing regular and secure delete operations on a single table. (check-in: 8eb3f40021 user: dan tags: trunk) | |
| 07:10 | Fix output redirect bug reported in the forum. (check-in: 60bdd5c3d9 user: larrybr tags: console-io-lib) | |
| 07:08 | Fix output redirect bug reported in the forum. (check-in: ce542fee6f user: larrybr tags: trunk) | |
| 07:06 | Fix output redirect bug reported in the forum. (check-in: 2ab256bc0b user: larrybr tags: branch-3.44) | |
|
2023-11-22
| ||
| 22:59 | Minor doc fix in src/betreeInt.h, prompted by an email report. No code changes. (check-in: 30d49aaed2 user: stephan tags: trunk) | |
| 21:24 | For CLI build with unused function warnings on, #ifdef out a console I/O function, fPutbUtf8(). (check-in: da36f90d94 user: larrybr tags: trunk) | |
| 21:15 | Add documentation for new fts5 auxiliary function APIs. (check-in: 9be8969edd user: dan tags: fts5-token-data) | |
| 20:02 | Defer building xInstToken() hash-table until it is to be used. (check-in: 9b005085ff user: dan tags: fts5-token-data) | |
| 19:02 | Fix tokendata=1 and xInstToken() APIs for detail=none and detail=column tables. (check-in: 37b271c19d user: dan tags: fts5-token-data) | |
| 17:13 | Correct the URL for loading sqlite3-worker1-bundler-friendly.mjs from sqlite3-worker1-promiser-bundler-friendly.js, so that the promiser can be used in bundler-using environments. Problem reported via email. (check-in: b1128838f9 user: stephan tags: branch-3.44) | |
| 17:11 | Correct the URL for loading sqlite3-worker1-bundler-friendly.mjs from sqlite3-worker1-promiser-bundler-friendly.js, so that the promiser can be used in bundler-using environments. Problem reported via email. (check-in: 753a752189 user: stephan tags: trunk) | |
| 16:32 | Merge the 3.44.1 patches into a new sub-branch of reuse-schema. (check-in: 24fc47afbd user: drh tags: reuse-schema-3.44) | |
| 16:15 | Merge the version 3.44.1 patch into a new sub-branch of bedrock. (check-in: 84f4215716 user: drh tags: bedrock-3.44) | |
| 15:34 | Merge the 3.44.1 patches into a sub-branch of wal2. (check-in: 2672572cc3 user: drh tags: wal2-3.44) | |
| 15:29 | Merge the 3.44.1 patches into a new sub-branch of begin-concurrent. (check-in: 7a1a114baf user: drh tags: begin-concurrent-3.44) | |
| 14:18 | Version 3.44.1 (check-in: d295f48e8f user: drh tags: release, branch-3.44, version-3.44.1) | |
|
2023-11-21
| ||
| 22:36 | Inserts invalid JSONB should return "malformed JSON", not a json path error. (check-in: 306ee66fbd user: drh tags: jsonb) | |
| 20:13 | Direct editing of JSONB using json_insert() and json_set(). (check-in: fffb7a9538 user: drh tags: jsonb) | |
| 19:05 | Correct blob-to-text rendering in some corner cases. (check-in: 7822e0e59f user: drh tags: jsonb) | |
| 18:46 | Pickup minor stylistic changes related to console I/O and, for Windows builds, get fact of UTF-16 translation into the sign-on banner. (a straight cherry-pick) (check-in: d7a59e7946 user: larrybr tags: branch-3.44) | |
| 18:37 | Pickup minor changes related to console I/O. (check-in: 24774e77c7 user: larrybr tags: console-io-lib) | |
| 18:26 | Merge console I/O changes for Windows CLI. (check-in: 935a8a8ee7 user: larrybr tags: trunk) | |
| 18:23 | Fix the translation of JSON5 numeric values from BLOB into text. (check-in: 40c4fb441f user: drh tags: jsonb) | |
| 17:54 | Merge all recent trunk fixes and enhancements into the jsonb branch. (check-in: 6d78d50ed2 user: drh tags: jsonb) | |
| 17:51 | Make edits directly to the JSONB BLOB when the input to json_replace() is a JSONB. (check-in: d69c6acef5 user: drh tags: jsonb) | |
| 15:55 | Sync w/trunk as pre-merge-to-trunk sanity check. (check-in: 448d6a1182 user: larrybr tags: console-io-lib) | |
| 12:02 | Fix the trace3-4.4 test to be more rebust against timing quirks. (check-in: 8936daa082 user: drh tags: trunk) | |
|
2023-11-20
| ||
| 15:58 | Back out an incorrect change to the sqlite3ExprCompareSkip() function from long ago. (check-in: 89658abbcd user: drh tags: branch-3.44) | |
| 15:54 | Back out an incorrect change to the sqlite3ExprCompareSkip() function that was added way back on 2019-08-22 for [44578865fa7baf97|check-in 44578865fa7ba] and which was only today discovered to be incorrect by forum post 45ec3d9788. (check-in: f5b3eb0fc8 user: drh tags: trunk) | |
| 13:59 | Arrange to not compile unused console I/O function. (check-in: 184a0cd2e8 user: larrybr tags: branch-3.44) | |
| 13:12 | Convert an assert in OP_VCheck into a branch that aborts the opcode, as this can happen on some very obscure conditions, as discovered by dbsqlfuzz. (check-in: 0d5f68717c user: drh tags: branch-3.44) | |
| 13:06 | Convert an assert in OP_VCheck into a branch that aborts the opcode, as this can happen on some very obscure conditions, as discovered by dbsqlfuzz. Test case in TH3. (check-in: 7946c79567 user: drh tags: trunk) | |
| 12:00 | Cherry pick additional assert() fixes from trunk into the branch-3.44 branch. (check-in: 6d8a8b7002 user: drh tags: branch-3.44) | |
| 11:50 | Fix an assert() in fts5 that could be true following an OOM or IO error in contentless-delete mode. (check-in: 80a0bd7a69 user: drh tags: branch-3.44) | |
| 11:40 | Fix an assert() in fts5 that could be true following an OOM or IO error in contentless-delete mode. (check-in: 3fe89238c3 user: dan tags: trunk) | |
| 00:21 | Cherrypick shell1.test fix. (check-in: 91c888eddb user: larrybr tags: trunk) | |
| 00:20 | Cherrypick shell1.test fix. (check-in: 39e30c5f9c user: larrybr tags: console-io-lib) | |
|
2023-11-19
| ||
| 17:33 | Fix test 5.0 in shell1.test for Windows. (A double-quote wrapped single-quote needs no further treatment to be recognized as a single single-quote.) (check-in: aaa73400c4 user: larrybr tags: branch-3.44) | |
|
2023-11-18
| ||
| 22:10 | Merge changes to do Windows console I/O with UTF-16. (check-in: f782054e7c user: larrybr tags: branch-3.44) | |
| 20:24 | Correct conditional compilation issue seen with MSVC in the Win32 mutex subsystem. (check-in: 6c069c5d66 user: drh tags: branch-3.44) | |
| 18:36 | Correct conditional compilation issue seen with MSVC in the Win32 mutex subsystem. (check-in: 6f8f4bfe60 user: mistachkin tags: trunk) | |
| 17:20 | When ENABLE_SETLK is defined, avoid ever blocking on the lock mutex in os_unix.c when requesting an exclusive lock. (check-in: eb36d475e9 user: dan tags: trunk) | |
| 12:06 | Adjust an assert() in fts5WritePoslistData() so that it only applies if there have been no prior errors. dbsqlfuzz 25dca9b2568f67dc78a0e32ff280133fe71994bd. (check-in: 257cdbab90 user: drh tags: trunk) | |
| 11:23 | Another assertion fault fix, similar to [a9443dbfbe25e588]. dbsqlfuzz 2d9af4e94aca188e0092900eec711401c5d51687. (check-in: 3afaeac56d user: drh tags: trunk) | |
|
2023-11-17
| ||
| 19:01 | When SQLITE_ENABLE_SETLK_TIMEOUT is defined, use a separate mutex in os_unix.c for each shm locking slot. (check-in: 64691df980 user: dan tags: trunk) | |
| 17:55 | Add the new "run-fuzzcheck" target on the autoconf unix makefile. Requires that FUZZDB be set to the name of the fuzz-data database file. (check-in: 8fa3915dbf user: drh tags: trunk) | |
| 17:25 | Add an assert() to prove the sqlite3_prepare() always either returns SQLITE_OK or else leaves *ppStmt set to NULL. See forum post 70bb8576c6c084c2. (check-in: feadd40242 user: drh tags: trunk) | |
| 17:10 | When SQLITE_ENABLE_SETLK_TIMEOUT is defined, use a separate mutex in os_unix.c for each shm locking slot. (Closed-Leaf check-in: 4098df9652 user: dan tags: unix-setlk-timeout-mutexes) | |
| 17:03 | Merge the latest trunk enhancements and fixes into the jsonb branch. (check-in: 162f0509ef user: drh tags: jsonb) | |
| 12:22 | Fix harmless compiler warnings in debugging code. (check-in: ce6a75622e user: drh tags: trunk) | |
| 11:58 | Fix an incorrect assert() associated with ALTER TABLE where an unknown aggregate function contains an ORDER BY clause. dbsqlfuzz e0900262dadd5c78c2226ad6a435c7f0255be2cd. (check-in: a9443dbfbe user: drh tags: trunk) | |
|
2023-11-16
| ||
| 21:11 | When querying a tokendata=1 fts5 table, do not use a prefix cursor for the case where the term has only one variant. (check-in: d711c96ba8 user: dan tags: fts5-token-data) | |
| 20:50 | Cherrypick changes to simplify and make more rational how console I/O package features are selected. (Leaf check-in: b20c9f1785 user: larrybr tags: consio-3.44) | |
| 18:31 | Simplify and make more rational how console I/O package features are selected. (Motivated by Fiddle and other command-line utilities to soon use the package.) No substantive code-execution changes. (check-in: 1cde05877b user: larrybr tags: console-io-lib) | |
|
2023-11-15
| ||
| 20:32 | Both json_remove() jsonb_remove() work on pure JSONB as long as the input is JSONB. (check-in: 68d551730b user: drh tags: jsonb) | |
| 19:21 | Some simple test cases for JSONB direct remove. (check-in: 8cb4d2cbfc user: drh tags: jsonb) | |
| 19:19 | Changes so that if SQLITE_ENABLE_SETLK_TIMEOUT is defined as 2 instead of 1, all blocking locks are taken for a single millisecond and the default busy-handler invoked as normal. (check-in: 79e24ec3dd user: dan tags: trunk) | |
| 18:55 | jsonb_remove() now works without having to use a JsonNode parse, assuming that the input is JSONB. (check-in: 5207679e92 user: drh tags: jsonb) | |
| 18:47 | The jsonb_remove() routine now appears to be working. (Closed-Leaf check-in: e76d48137e user: drh tags: jsonb-remove) | |
| 16:54 | Get Fiddle build to succeed. (It runs, too, but not from changes here.) (check-in: 957ebaa2be user: larrybr tags: consio-3.44) | |
| 16:10 | Work toward getting jsonb_remove() to work directly on JSONB blobs. (check-in: a79ff8e58f user: drh tags: jsonb-remove) | |
| 15:20 | Changes to console I/O for Fiddle build, to always defer to C library (as before.) A WIP, pending testing with Fiddle build. (check-in: 45b8061e75 user: larrybr tags: consio-3.44) | |
| 14:09 | Improvements to the description of sqlite3_errmsg() and sqlite3_errstr(). (check-in: fe5cc4169c user: drh tags: trunk) | |
| 13:23 | Merge all the latest enhancements and fixes from trunk into the jsonb branch. (check-in: ba91408f4c user: drh tags: jsonb) | |
| 11:45 | Add implementation of xInstToken() API. (check-in: a34b26fe7f user: dan tags: fts5-token-data) | |
| 11:31 | Fix an exception misuse in test-opfs-vfs.js. (check-in: 9264955e6e user: stephan tags: trunk) | |
| 08:59 | JNI: add more wrapper1 Sqlite.Blob tests. (check-in: d63f6e1ffd user: stephan tags: trunk) | |
| 08:29 | JNI: clear out the sqlite3_context native pointer after calling UDF callbacks which do not have an argv (as was already done for those which have an argv). Add related tests and code commentary. (check-in: 138f40543b user: stephan tags: trunk) | |
| 06:28 | JNI doc updates. (check-in: 1b1f36a206 user: stephan tags: trunk) | |
| 06:10 | JNI: add the @Experimental annotation and mark all java.nio.ByteBuffer-related methods with it. (check-in: 0f4b223102 user: stephan tags: trunk) | |
| 05:08 | JNI test code cleanups. (check-in: 09142ac143 user: stephan tags: trunk) | |
| 04:55 | JNI: add CONFIG_LOG and CONFIG_SQLLOG support to wrapper1. Code-adjacent cleanups. (check-in: 83c49b9e71 user: stephan tags: trunk) | |
| 03:02 | JNI: apply an internal level of API indirection to avoid having to work with massively-mangled names for the various sqlite3_config() overloads. (check-in: 24f20663b1 user: stephan tags: trunk) | |
|
2023-11-14
| ||
| 16:53 | Add NEVER() to a branch made unreachable by [6f9eed826f5b3d1c]. (check-in: 26dcaa34e3 user: drh tags: trunk) | |
| 14:59 | JNI: reimplement Tester2.execSql() using the high-level API. (check-in: 3a69679e41 user: stephan tags: trunk) | |
| 14:50 | Fix another obscure problem with nested aggregates. dbsqlfuzz 04408efc51. This might be a better fix than the one at [4a587c3492faa994]. (check-in: 6f9eed826f user: dan tags: trunk) | |
| 14:38 | JNI: add Sqlite.Stmt.step(boolean) overload which returns the result code of sqlite3_step() unless passed true, in which case it throws for any result other than ROW or DONE. The intent is to simplify handling of LOCKED and BUSY errors. (check-in: f4f1cc201a user: stephan tags: trunk) | |
| 13:51 | Extra PRAGMA vdbe_addoptrace output showing when OP_Column gets translated into OP_Copy due to using a coroutine instead of a cursor. (check-in: eba180e779 user: drh tags: trunk) | |
| 05:33 | JNI: use ByteBuffer.limit() instead of ByteBuffer.capacity() when figuring out where the logical end of a ByteBuffer is, for reasons explained at length in new code comments. This is unfortunately slower but is the correct way to do it. (check-in: 51539419ed user: stephan tags: trunk) | |
| 04:59 | JNI: add sqlite3_blob_read_nio_buffer() and iron out the blob/ByteBuffer interface somewhat. (check-in: 7df317b448 user: stephan tags: trunk) | |
| 03:31 | Cherry-pick some assert()s to cover misuse of *Put*() from 500+ shell.c callers. (check-in: c1a53c28a4 user: larrybr tags: consio-3.44) | |
| 03:24 | Add a few asserts into *Put*() functions to catch calls that might cause an address fault. (check-in: 2341f9b6a4 user: larrybr tags: console-io-lib) | |
| 02:43 | JNI: change sqlite3_prepare_multi()'s exception-handling semantics to be more C-like and, to support that, add the package-private sqlite3_jni_db_error() method to set the db error state from package-level Java code. (check-in: 46656b3543 user: stephan tags: trunk) | |
| 01:33 | JNI: add sqlite3_blob_write() overload which accepts a java.nio.ByteBuffer. Cleanups in adjacent code. (check-in: ca32af8542 user: stephan tags: trunk) | |
|
2023-11-13
| ||
| 23:11 | JNI: add sqlite3_column_nio_buffer() and sqlite3_value_nio_buffer() using an only-slightly roundabout approach to creating properly-sized ByteBuffer objects. (check-in: efbc82b218 user: stephan tags: trunk) | |
| 18:35 | JNI: add sqlite3_result_nio_buffer() and tests. Discover that we cannot create sensible sqlite3_column_nio_buffer() or sqlite3_value_nio_buffer() counterparts because of ByteBuffer interface limitations. (check-in: 44b4df01ff user: stephan tags: trunk) | |
| 17:45 | Manual merge of branch-3.44 with 3 sources affected/created by console-io-lib changes. (check-in: 18ebcf117a user: larrybr tags: consio-3.44) | |
| 17:26 | Mistaken creation by a Fossil expert-to-be-maybe. (Leaf check-in: 2e3e98a4a7 user: larrybr tags: mistake) | |
| 15:59 | Cure many warnings from gcc, clang and CL.exe. (check-in: 29ea2a3aad user: larrybr tags: console-io-lib) | |
| 14:58 | JNI: add sqlite3_bind_nio_buffer() and initial tests for binding ByteBuffer objects as blobs on JVMs which have JNI support for nio buffers. (check-in: b10ce1ef82 user: stephan tags: trunk) | |
| 14:29 | Add new fts5 API xQueryToken(). (check-in: 828566392b user: dan tags: fts5-token-data) | |
| 13:01 | Fix var-intro after executable code departure from old C. (check-in: 08996f4fd5 user: larrybr tags: console-io-lib) | |
| 12:53 | Slight cleanup of length-limited strpbrk() replacement, and eliminate strpbrk() call. (check-in: 97e2c9621e user: larrybr tags: console-io-lib) | |
| 12:05 | Remove an incorrect ALWAYS() and NEVER(). (check-in: 94f6209386 user: drh tags: branch-3.44) | |
| 05:24 | Enhance console_io to permit emits limited in various ways, such as valid UTF-8, upto control chars, or with counted limits, all getting away from 0-termination as the sole limit. In CLI, use this capability to avoid certain emit-chars-singly procedures that were breaking up UTF-8 characters. This fixes broken json mode output (on Windows) and (maybe) C-literal-like emits. (check-in: 906c5c4082 user: larrybr tags: console-io-lib) | |
|
2023-11-12
| ||
| 19:57 | Add sqlite3_x86.exe unversioned binary. (check-in: a731cdddbb user: larrybr tags: console-io-lib) | |
| 03:58 | Use setOutputStream() to designate implicit output for oput{z,f}() emit functions, and use them extensively. (check-in: 7850fb98a1 user: larrybr tags: console-io-lib) | |
| 00:43 | Write BOM without fwrite(), using sputz() so that if it goes to the console, it is translated "properly". (check-in: 06ef96a823 user: larrybr tags: console-io-lib) | |
|
2023-11-11
| ||
| 22:53 | Remove SHELL_LEGACY_CONSOLE_IO PP symbol and code it made active. (It is in the repo if ever needed/wanted, but it is just inferior or dead code now.) (check-in: 27c5bf6563 user: larrybr tags: console-io-lib) | |
| 20:46 | Complete shell transition to using {f,o,e}put{f,z}() emit functions. (check-in: 923c6b8b3a user: larrybr tags: console-io-lib) | |
| 14:50 | JNI wrapper1: when checking for an out-of-bounds statement column index, perform the is-statement-finalized check before the range check so that the former exception trumps the latter. (check-in: 0832f9a8e9 user: stephan tags: trunk) | |
| 14:43 | Do not cache a statement's column count in the JNI wrapper1 API because an ALTER TABLE via another statement may invalidate it, as reported in forum post 6d80efd58d4591c7. (check-in: a6ab88e9a6 user: stephan tags: trunk) | |
| 13:09 | Fix malf with redirected input due to bad assumption that stdin is a console in the fgets() replacement. (check-in: 79d1f2c101 user: larrybr tags: console-io-lib) | |
| 06:20 | Pervasive changes to console_io.{c,h} in support of simplifying ubiquitous emit ops in shell, and to get better control of console streams that might be opened only via .read or .output commands. Changes to shell to use {s,o,e}put{f,z}(...) calls for initial testing, but this check-in has few such conversions so that most will be in a separate check-in. Many renames to better follow recent coding convention. This code seems to be working, but has not been tested on difficult platforms or with multiple console hosts yet. So it is a WIP. (check-in: 14762a004c user: larrybr tags: console-io-lib) | |
|
2023-11-10
| ||
| 21:03 | Fix another problem with mixed join types and the RIGHT JOIN strength-reduction optimization. (check-in: 8f01f8b260 user: drh tags: branch-3.44) | |
| 20:55 | Fix another problem with mixed join types and the RIGHT JOIN strength-reduction optimization. Forum post befdab472d. (check-in: f1eae19231 user: dan tags: trunk) | |
| 20:46 | Additional debugging information on the tree-dump of the BETWEEN operator. (check-in: aca31e49d1 user: drh tags: trunk) | |
| 20:35 | Remove an incorrect ALWAYS() that was inserted yesterday [1e039b6eb59c0001]. (check-in: 12885e298b user: drh tags: trunk) | |
| 18:59 | Merge recent trunk enhancements and fixes into the jsonb branch. (check-in: 091a5f058d user: drh tags: jsonb) | |
| 17:49 | Ensure 8-byte alignment of data structues in sqlite3_database_file_object(). This should have appeared on trunk originally and then be cherry-picked onto the branch. Oh well.... (check-in: ac39800bb2 user: drh tags: trunk) | |
| 16:29 | Remove a NEVER() from whereAddIndexedExpr() that is reachable if there is an unknown indexed function in the schema. (check-in: a976b7208f user: drh tags: trunk) | |
| 15:20 | Fix an obscure problem with the join-strength-reduction optimization that could occur when mixing LEFT and RIGHT joins in the same query. (check-in: dcf1c13781 user: drh tags: branch-3.44) | |
| 15:03 | Fix an obscure problem with the join-strength-reduction optimization that could occur when mixing LEFT and RIGHT joins in the same query. Forum post 7f74ce0bee and separately post d64f0abe723ac98e. The problem was introduced by check-in [d747afda5683ca5f]. (check-in: 530d10e93a user: dan tags: trunk) | |
| 15:01 | Expose the missing SQLITE_SUBTYPE to wasm. (check-in: 7bebfe20e7 user: stephan tags: branch-3.44) | |
| 15:00 | Expose the missing SQLITE_SUBTYPE to wasm. (check-in: ac9534b2ce user: stephan tags: trunk) | |
| 15:00 | Expose the missing SQLITE_SUBTYPE to JNI. (check-in: 0f92f4c90e user: stephan tags: trunk) | |
| 14:15 | Expose SQLITE_RESULT_SUBTYPE to JNI. (check-in: 3bf75875b8 user: stephan tags: trunk) | |
|
2023-11-09
| ||
| 18:41 | Ensure 8-byte alignment of data structues in sqlite3_database_file_object(). (check-in: 3cfcaafaff user: drh tags: branch-3.44) | |
| 17:55 | Expose SQLITE_RESULT_SUBTYPE to wasm. (check-in: fc03988650 user: stephan tags: branch-3.44) | |
| 17:53 | Expose SQLITE_RESULT_SUBTYPE to wasm. (check-in: 6d2fe9848b user: stephan tags: trunk) | |
| 17:42 | Add the SQLITE_RESULT_SUBTYPE flag for application-defined functions. Add the -DSQLITE_STRICT_SUBTYPE=1 compile-time option that raises an error if any function invokes sqlite3_result_subtype() without the SQLITE_RESULT_SUBTYPE flag. SQLITE_RESULT_SUBTYPE prevents an indexed value of that function from being used to replace an equivalent expression, since the indexed expression does not carry the subtype. (check-in: 65a9cfc466 user: drh tags: branch-3.44) | |
| 17:36 | Add the SQLITE_RESULT_SUBTYPE flag for application-defined functions. Add the -DSQLITE_STRICT_SUBTYPE=1 compile-time option that raises an error if any function invokes sqlite3_result_subtype() without the SQLITE_RESULT_SUBTYPE flag. SQLITE_RESULT_SUBTYPE prevents an indexed value of that function from being used to replace an equivalent expression, since the indexed expression does not carry the subtype. Fix for the problem described at forum post 68d284c86b082c3e. (check-in: ba789a7804 user: drh tags: trunk) | |
| 17:28 | Fix compilation issue seen with MSVC. (check-in: 0dfe790d81 user: mistachkin tags: trunk) | |
| 17:26 | Put an ALWAYS on an true branch. (Closed-Leaf check-in: 1e039b6eb5 user: drh tags: func-rw-subtype) | |
| 16:52 | Futher documentation refinements. (check-in: 311c2eba93 user: drh tags: func-rw-subtype) | |
| 15:01 | Fixes: (1) In the ->> function, instead of setting a subtype and clearing it, do not set it in the first place, as doing the set would trigger an error under SQLITE_STRICT_SUBTYPE. (2) Allow the SQLITE_STRICT_SUBTYPE through the property filter on sqlite3_create_function(). (check-in: 6195468b14 user: drh tags: func-rw-subtype) | |
| 13:00 | A .class file build dependencies fix in the JNI build. (check-in: 8cc3291516 user: stephan tags: trunk) | |
| 12:58 | Add the SQLITE_STRICT_SUBTYPE compile-time option. This change reveals that the current SQLITE_RESULT_SUBTYPE design does not work unless we tag the ->> operator with SQLITE_RESULT_SUBTYPE. But that will disable an important optimization. (check-in: e98a9a65dd user: drh tags: func-rw-subtype) | |
| 12:48 | Add some notes about the JNI pointer-passing approach and convert a couple of potential NullPointerExceptions into appropriate C result codes. Clarify that invocation of undefined behaviour from the Java API does not (due to the addition of defensive code) mean the same thing as it does in C (e.g. no NULL pointer dereferences). (check-in: 19c4778f45 user: stephan tags: trunk) | |
| 12:17 | Do not replace expressions that return subtypes with values taken from an index. (check-in: a35d13db09 user: drh tags: func-rw-subtype) | |
| 12:08 | Omit the new SQLITE_VALUE_SUBTYPE name. Stay with legacy SQLTIE_SUBTYPE. Add extra documentation to sqlite3_value_subtype() and sqlite3_result_subtype() indicating that the SQLITE_SUBTYPE and SQLITE_RESULT_SUBTYPE properties are required on functions that use those interfaces. (check-in: 563ad3be60 user: drh tags: func-rw-subtype) | |
| 12:01 | Two more JNI build fixes for Windows/MinGW, reported in forum post 4f949edc312d2a75. (check-in: a3f9c39086 user: stephan tags: trunk) | |
| 01:56 | JSON5 bug fix: Escape double-quotes that occur inside of single-quoted strings. (check-in: 6cc57bb2ce user: drh tags: branch-3.44) | |
| 01:54 | JSON5 bug fix: Escape double-quotes that occur inside of single-quoted strings. Forum post ddcad3e884. (check-in: 1c98d46d60 user: drh tags: trunk) | |
|
2023-11-08
| ||
| 21:38 | Make a distinction between functions that consume subtypes and functions that generate subtypes. (check-in: 48a92e3ad8 user: drh tags: func-rw-subtype) | |
| 18:08 | Do not cover expressions using an indexed expression if the indexed expression is a function that might set a subtype. (Closed-Leaf check-in: e908b26a99 user: drh tags: idx-expr-fix) | |
| 17:11 | Merge recent trunk enhancements into the jsonb branch, and especially the finer-grain characterization of JSON function properties. (check-in: 72393b003f user: drh tags: jsonb) | |
| 16:37 | More precise characterization of JSON functions. Indicate when functions might return JSON (subtype 'J') and when they make use of the function argument cache. (check-in: b2b62546c4 user: drh tags: trunk) | |
| 15:56 | Have the shell tool emit a warning if the user attempts to use ".scanstats vm" in a non-SQLITE_ENABLE_BYTECODE_VTAB build. (check-in: 3978c084a5 user: dan tags: trunk) | |
| 15:51 | Remove old files related to wapptest.tcl from test/ directory. (check-in: dd3e7b5bca user: dan tags: trunk) | |
| 15:49 | Avoid blocking as part of passive checkpoint operations, even if SQLITE_ENABLE_SETLK_TIMEOUT is defined. (check-in: e5ecc404ca user: dan tags: trunk) | |
| 15:34 | Remove an unused/invalid test from the wasm suite. (check-in: 916ae89874 user: stephan tags: trunk) | |
| 14:55 | Add declarations for new fts5 API functions. (check-in: b8a48cc18c user: dan tags: fts5-token-data) | |
| 12:56 | JNI build fixes for platforms where the jint type is not the same as int, as reported in forum post 9089d2049a. (check-in: b32b087327 user: stephan tags: trunk) | |
| 00:45 | Suppress harmless UBSAN warnings about memory overflow in OP_AddImm. The exact same machine code is generated by GCC. (check-in: b0594383b9 user: drh tags: trunk) | |
| 00:12 | Changes a no-op call to freeP4() into an assert(). (check-in: 32a7b1bd4d user: drh tags: trunk) | |
|
2023-11-07
| ||
| 20:56 | Add -DSQLITE_ENABLE_SETLK_TIMEOUT=1 to a release-test configuration. (check-in: cd3e38fb0f user: dan tags: trunk) | |
| 20:11 | Fix an assert() that could fail within calls to sqlite3_snapshot_open() in SQLITE_ENABLE_SETLK_TIMEOUT builds. (check-in: 84634bc268 user: dan tags: trunk) | |
| 19:39 | An attempt to work around compilation errors on MinGW reported in forum post 9089d2049a. (check-in: d5658a3ee4 user: stephan tags: trunk) | |
| 19:30 | Refactor MBCS/UTF-8 translation to avoid extra allocations, supporting non-formatted (faster) output. Some code cleanup. Wrap .system/.shell command exection with restoration of startup console mode and renewing mode setup. Changes to make legacy MBCS build work better (than legacy did, even with --no-utf8.) (check-in: d5e88fcde5 user: larrybr tags: console-io-lib) | |
| 19:15 | Update the documentation to the sqlite3_set_auxdata() and sqlite3_get_auxdata() routines to make it clear that they do not work as one might expect when they are called during query planning, instead of during query execution. The JSON routines misuse those interfaces, so add a special flag to JSON routines that prevents them from being invoked during query planning. (check-in: 36259009c5 user: drh tags: branch-3.44) | |
| 19:03 | Update the documentation to the sqlite3_set_auxdata() and sqlite3_get_auxdata() routines to make it clear that they do not work as one might expect when they are called during query planning, instead of during query execution. The JSON routines misuse those interfaces, so add a special flag to JSON routines that prevents them from being invoked during query planning. Fix for the problem in forum post a655ee159eca1ea5. (check-in: 796a23f9ee user: drh tags: trunk) | |
| 19:02 | Do not allow aggregate or window functions in UPDATE statements. (Leaf check-in: fce776ccce user: dan tags: no-aggregates-in-update) | |
| 17:15 | JNI: during static init record whether the current JVM supports JNI-level access to java.nio.ByteBuffer raw memory, and add sqlite3_jni_supports_nio() to query that. (check-in: fb8dbb77a4 user: stephan tags: trunk) | |
| 15:56 | Add Sqlite.prepareMulti() to JNI wrapper1, for preparing multiple statements from a single input. (check-in: e4670d68b5 user: stephan tags: trunk) | |
| 13:44 | Diverse minor cleanups in the JNI pieces. (check-in: 35233dd900 user: stephan tags: trunk) | |
| 13:22 | Flesh out [7a63b5b65a79] to be able to build JNI with or without SQLITE_ENABLE_COLUMN_METADATA. (check-in: fcee41b3d4 user: stephan tags: trunk) | |
| 02:41 | Get dependencies into make recipes. Get legacy console I/O (-DSHELL_LEGACY_CONSOLE_IO) working. Due to movement of MBCS/UTF-8 translation into traditional stream I/O simulacra, the input translation does not happen the same way. (It works the same, but fails differently and a bit better.) Added printf() and fputs() look-alikes, and made CLI use them. (check-in: 1721dc6a43 user: larrybr tags: console-io-lib) | |
|
2023-11-06
| ||
| 21:57 | Add -DSQLITE_ENABLE_COLUMN_METADATA to the JNI build, as per forum post 9205518c0568fdf0. Add tests for the functions that flag enables so that the build will fail if that flag is missing. (check-in: 7a63b5b65a user: stephan tags: trunk) | |
| 19:16 | Merge latest trunk into this branch. (check-in: 3a869cf1f8 user: dan tags: fts5-token-data) | |
| 19:08 | Update the srctree-check.tcl script and child script so that they can be run on a read-only source tree and so that if any inconsistencies are found, the script returns a non-zero exit code and thus halts the build. (check-in: a0cc7e8117 user: drh tags: branch-3.44) | |
| 19:01 | Fix an fts5 problem where a transaction consisting of (a) a DELETE on rowid X, (b) a prefix query, and (c) an INSERT on rowid X, could corrupt the index. (check-in: 34af510a56 user: drh tags: branch-3.44) | |
| 18:40 | Fix an fts5 problem where a transaction consisting of (a) a DELETE on rowid X, (b) a prefix query, and (c) an INSERT on rowid X, could corrupt the index. (check-in: c2058a045b user: dan tags: trunk) | |
| 16:32 | Merge trunk changes into this branch. (check-in: ac5570614e user: dan tags: fts5-token-data) | |
| 15:31 | Move console_io lib to its own subdirectory, etc/consio . (check-in: 1d0583f2eb user: larrybr tags: console-io-lib) | |
| 15:15 | Some renaming, warnings cured, and more coding convention conformance. (check-in: 58815f0ad2 user: larrybr tags: console-io-lib) | |
| 13:24 | Add an fputs() equivalent to console I/O lib, and use in CLI. (check-in: d661f90724 user: larrybr tags: console-io-lib) | |
| 03:09 | Cause CLI to use console_io library. (check-in: bf66a7c1d3 user: larrybr tags: console-io-lib) | |
| 00:15 | Make MSVC accept it, too. (Cannot use static const int as part of a constant expression?) (check-in: bb278d2496 user: larrybr tags: console-io-lib) | |
|
2023-11-05
| ||
| 23:55 | Make it buildable. Pull test program from testee. Zap stray fprintf(). (check-in: 2b850aca1e user: larrybr tags: console-io-lib) | |
| 19:42 | Input working. No line-editor provisions yet. (WIP, but suitable for testing.) (check-in: e8568b1d92 user: larrybr tags: console-io-lib) | |
| 04:20 | Add incremental blob I/O support to JNI wrapper1. (check-in: 7f1c76fe93 user: stephan tags: trunk) | |
| 03:37 | JNI wrapper1 normalizeSql() now throws UnsupportedOperationException, instead of returning null, if built without SQLITE_ENABLE_NORMALIZE. Remove SQLITE_PREPARE_NORMALIZE from the JNI interface because it's a legacy no-op. (check-in: d081a12669 user: stephan tags: trunk) | |
| 01:55 | Add authorizer support to JNI wrapper1. (check-in: 773f987386 user: stephan tags: trunk) | |
| 01:39 | Add progress-handler support to JNI wrapper1. Correct the return type of the extended_result_codes() JNI binding and expose it to wrapper1. (check-in: 6c0acfdce2 user: stephan tags: trunk) | |
| 01:21 | Setup, takedown, mode set and output working. No input yet. (WIP) (check-in: dfea85be1f user: larrybr tags: console-io-lib) | |
| 01:14 | Add update-hook support to JNI wrapper1. (check-in: 6c584cf271 user: stephan tags: trunk) | |
| 00:48 | Add commit/rollback hook support to JNI wrapper1. (check-in: ff3d44fe42 user: stephan tags: trunk) | |
| 00:02 | Add busy-handler support to JNI wrapper1. (check-in: dcf579ab2d user: stephan tags: trunk) | |
|
2023-11-04
| ||
| 23:37 | Bind collation and collation-needed to JNI wrapper1 and correct the callback return type for collation-needed callbacks in the lower-level JNI binding. (check-in: 0f67314068 user: stephan tags: trunk) | |
| 22:47 | Wrap the sqlite3_backup API in the JNI wrapper1 API. (check-in: 3ee6cc29d2 user: stephan tags: trunk) | |
| 21:51 | Reimplement auto-extensions in Java for use with the JNI wrapper1 API. (check-in: 14ed4c6453 user: stephan tags: trunk) | |
| 21:44 | Ensure that the YYYY-MM-DD input to date and time functions has been normalized prior to returning a result. Forum post 6bb476897e. (check-in: b692eb8ccb user: drh tags: trunk) | |
| 16:01 | Expose context_db_handle() to the JNI wrapper1 API and clean up some related tests. (check-in: c23123af7d user: stephan tags: trunk) | |
| 13:37 | Rework the JNI wrapper1 variants of status() and db_status() to be more Java-esque. (check-in: 40ad392067 user: stephan tags: trunk) | |
| 13:16 | Bind the bool-flag sqlite3_db_config() variants to the JNI wrapper1 API. (check-in: b5cdcb9279 user: stephan tags: trunk) | |
| 12:53 | Bind the trace API to the JNI wrapper1 API and add a way to map the native-level db/stmt types to their high-level counterparts (required for translating callbacks such as tracers). (check-in: 702910e0d1 user: stephan tags: trunk) | |
| 02:22 | Define interface between project command-line apps and a console I/O "library". (check-in: 64abef8314 user: larrybr tags: console-io-lib) | |
|
2023-11-03
| ||
| 18:45 | Back out the ALWAYS inserted late yesterday. The fuzzer discovered a counter-example. (check-in: 570635575c user: drh tags: trunk) | |
| 17:20 | Fix a case where adjacent tokens are handled incorrectly by the fts5 snippet() function. (check-in: 8f5e9c192f user: dan tags: trunk) | |
| 13:00 | Wrap more of the stmt API behind the JNI wrapper1 API. (check-in: 8fea23dc3a user: stephan tags: trunk) | |
| 12:09 | Enhance the JSONB lookup routine with logic to apply edits. The new logic is currently unused and hence untested but does not create any regressions. (check-in: b12110276f user: drh tags: jsonb) | |
| 11:53 | Bind the sqlite3_keyword_...() and sqlite3_compileoption_...() family of functions to the JNI wrapper1 API. (check-in: b27242414d user: stephan tags: trunk) | |
| 11:41 | Update the tool/srctree-check.tcl script so that it verifies that autoconf has been run following edits to VERSION. (check-in: 52ab3deba4 user: drh tags: trunk) | |
| 11:35 | Merge all the latest trunk fixes and enhancements into the jsonb branch. (check-in: b089bf4637 user: drh tags: jsonb) | |
| 10:15 | Update the version number to 3.45.0 to begin the next development cycle. (check-in: 15b618e92a user: drh tags: trunk) | |
|
2023-11-02
| ||
| 22:39 | Mark a branch made always-true by the penultimate check-in with ALWAYS(). (check-in: 268b5984a4 user: drh tags: trunk) | |
| 22:11 | In the previous check-in, use a u32 instead of an int, to make it easier to prove that the integer will never overflow. (check-in: 51002079e0 user: drh tags: trunk) | |
| 21:02 | Fix a spurious "misuse of aggregate function" error that could occur when an aggregate function was used within the FROM clause of a sub-select of the select that owns the aggregate. e.g. "SELECT (SELECT x FROM (SELECT sum(t1.a) AS x)) FROM t1". Forum post c9970a37ed. (check-in: 4470f657d2 user: dan tags: trunk) | |
| 18:22 | Add the "remove_diacritics" option to the fts5 trigram tokenizer. (check-in: 0d50172477 user: dan tags: trunk) | |
| 18:10 | Fix a problem with amalgamation builds on this branch. (Closed-Leaf check-in: 8f046c82c9 user: dan tags: fts5-trigram-diacritics) | |
| 18:08 | Merge latest JNI pieces into trunk. (check-in: e8c97faec3 user: stephan tags: trunk) | |
| 17:31 | Add the "remove_diacritics" option to the fts5 trigram tokenizer. (check-in: 83da80135b user: dan tags: fts5-trigram-diacritics) | |
| 13:10 | One more tweak to tool/srctree-check.tcl so that a complete build can be accomplished from a read-only source tree. (check-in: cba9f0601c user: drh tags: trunk) | |
| 12:05 | Update the srctree-check.tcl script and child script so that they can be run on a read-only source tree and so that if any inconsistencies are found, the script returns a non-zero exit code and thus halts the build. (check-in: 58eb5440d7 user: drh tags: trunk) | |
| 11:14 | Update the version number to 3.44.1 (check-in: 34f23c3d0d user: drh tags: branch-3.44) | |
| 11:08 | CLI to compile with older MSVC compiler. (check-in: c8bf4f7a6a user: drh tags: branch-3.44) | |
| 11:04 | CLI to compile with older MSVC compiler. (check-in: c89f75f8ee user: larrybr tags: trunk) | |
|
2023-11-01
| ||
| 20:09 | Remove some outdated JNI docs. (Closed-Leaf check-in: 52aef3d015 user: stephan tags: jni-post-3.44) | |
| 19:35 | Update the windows build documentation to provide the exact command used to build the DLLs that appear on the download page. (check-in: 3524a8914c user: drh tags: trunk) | |
| 14:33 | Fix testrunner.tcl so that it accepts a relative path as an argument to the --zipvfs switch. (check-in: c1ed7ed022 user: dan tags: trunk) | |
| 14:12 | Bring the jsonb branch up-to-date with version 3.44.0 changes. (check-in: a420a4f7ff user: drh tags: jsonb) | |
| 12:50 | Version 3.44.0 for the reuse-schema branch. (check-in: 30403ce26c user: drh tags: reuse-schema) | |
| 12:45 | Version 3.44.0 for the bedrock branch. (check-in: 827cf67fb3 user: drh tags: bedrock) | |
| 12:41 | Version 3.44.0 for the wal2 branch (check-in: 470152fd28 user: drh tags: wal2) | |
| 12:38 | Version 3.44.0 for the begin-concurrent branch. (check-in: 291d6b4403 user: drh tags: begin-concurrent) | |
| 11:23 | Version 3.44.0 (check-in: 17129ba1ff user: drh tags: trunk, release, major-release, version-3.44.0) | |
|
2023-10-31
| ||
| 17:40 | Fix harmless compiler warnings in test code. (check-in: d1895dd8f5 user: drh tags: trunk) | |
| 17:39 | Fix a problem with SQLITE_ENABLE_FTS5 builds of the non-amalgamation testfixture.exe in Makefile.msc. (check-in: 544091cc0f user: dan tags: trunk) | |
|
2023-10-30
| ||
| 23:20 | Remedy CLI non-UTF8 handling detection flaw noted in a forum post. (check-in: a4c7954b93 user: larrybr tags: trunk) | |
| 23:05 | Merge the latest 3.44.0 release candidate changes into the reuse-schema branch. (check-in: 28f9a55928 user: drh tags: reuse-schema) | |
| 23:04 | Remedy CLI non-UTF8 handling detection flaw noted in a forum post. (Leaf check-in: 2666b80d2c user: larrybr tags: win-utf8-io-split) | |
| 22:57 | Merge the latest 3.44.0 release candidate patches into the bedrock branch. (check-in: 956b03a462 user: drh tags: bedrock) | |
| 21:46 | Merge the latest 3.44.0 changes into wal2 branch. (check-in: 4f65ae2df0 user: drh tags: wal2) | |
| 21:39 | Merge the latest trunk changes into the begin-concurrent branch. (check-in: 9fa405eb5a user: drh tags: begin-concurrent) | |
| 20:35 | Update the autoconf/Makefile.msc so that it aligns with Makefile.msc. (check-in: c4f724de27 user: drh tags: trunk) | |
| 19:50 | Dodge a nuisance warning from MSVC in CLI use of Prepared Statement Scan Status. (Yes, C rules are fine.) (check-in: 166c96d91d user: larrybr tags: trunk) | |
| 19:03 | Add a cast to i64 for an integer in an sqlite3OsWrite() offset calculation. The cast is not strictly necessary, but it helps human readers see that the code is correct. (check-in: 7564ff1ba2 user: drh tags: trunk) | |
| 18:48 | Fix another comment typo. No code changes. (check-in: 3203256c02 user: drh tags: trunk) | |
| 18:17 | Add FTS5 to default Makefile.msc builds. And UNKNOWN_SQL_FUNCTION and STMT_SCANSTATUS to default Makefile.msc shell builds. (check-in: e41fde2fdb user: dan tags: trunk) | |
| 18:09 | Make the new sqlite3_get_clientdata() and sqlite3_set_clientdata() interfaces available to run-time loaded extensions. (check-in: 8fc9aa0f89 user: drh tags: trunk) | |
| 18:07 | Fix problems with previous commit on Makefile.msc. Also some win32-specific test failures in fts5misc.test. (Closed-Leaf check-in: 527f2237a6 user: dan tags: shell-build-changes) | |
| 17:56 | Fix typo in a comment. No code changes. (check-in: 424ef9550a user: drh tags: trunk) | |
| 17:13 | Add FTS5 to default Makefile.msc builds. And UNKNOWN_SQL_FUNCTION and STMT_SCANSTATUS to default Makefile.msc shell builds. (check-in: bf99ebba23 user: dan tags: shell-build-changes) | |
| 16:38 | Predicate Windows CLI UTF-8 console I/O on a runtime capability check rather than an OS version check. (check-in: 0058ea6a69 user: larrybr tags: trunk) | |
| 13:56 | Predicate Windows CLI UTF-8 console I/O on a runtime capability check rather than an OS version check. (check-in: f89d062f88 user: larrybr tags: win-utf8-io-split) | |
| 12:09 | With SQLITE_ENABLE_BLOCK_ATOMIC_WRITE enabled, if a transaction is committing and there is a new freelist page at the end of the database file which would cause the database file size to grow, ensure that page is written and the file size grows before the block-atomic-write commits. Fix for the problem identified by forum post 3bd8d497b2 (check-in: c9fdd6805d user: drh tags: trunk) | |
|
2023-10-29
| ||
| 20:05 | For Windows CLI, institute a version check to determine default MBCS or UTF-8 translation on console I/O. (Default to UTF-8 where known possible.) (check-in: ddc6ead645 user: larrybr tags: trunk) | |
| 19:55 | Simplify code slightly. Improve comments on added code and its use. (check-in: 046c842966 user: larrybr tags: win-utf8-io-split) | |
| 16:26 | Properly close a handle. Use a putatively effective runtime test for UTF-8 console I/O capability. (This makes the version test useful mainly for avoiding a warning that UTF-8 console I/O could not be setup.) (check-in: dc91eb9172 user: larrybr tags: win-utf8-io-split) | |
| 00:24 | Condition default UTF-8 console I/O for Windows builds on OS version 10 or more. This is to accomodate an IsValidCodePage() API which may happily report CP_UTF8 as a valid code page when the stock console cannot, in fact, do UTF-8 I/O. (check-in: 6b9b2a886f user: larrybr tags: win-utf8-io-split) | |
|
2023-10-28
| ||
| 16:19 | Limit the range of integer unix timestamps in date4.test, since some systems (RaspberryPI) cannot deal with timestamp values that exceed pow(2,31). (check-in: 765290663b user: drh tags: trunk) | |
| 11:53 | Update documentation for sqlite3_errmsg() to try to make it clear that if the schema of a database contains table names or similar with invalid UTF, then the error message generated by SQLite might also contain invalid UTF. No changes to code. (check-in: 33ba13c7c4 user: drh tags: trunk) | |
| 11:40 | Since SQLite considers NaN to be like NULL and NULL sorts before any integer, make sure the sqlite3IntFloatCompare() routine reports that the integer argument is larger if the floating-point argument is NaN. (check-in: de1cf31a34 user: drh tags: trunk) | |
| 03:56 | Merge trunk into jni-post-3.44 branch. (check-in: 9670eb2496 user: stephan tags: jni-post-3.44) | |
| 03:54 | Remove the SQLITE_MAX_ALLOCATION_SIZE flag (set to 536mb) from the WASM build because it can unduly limit db exports via sqlite3_serialize(), as reported in forum post 75524f7342c1ba45. It now defaults to whatever sqlite3.c uses, which is currently just shy of 2gb. (check-in: f6e1137919 user: stephan tags: trunk) | |
|
2023-10-27
| ||
| 23:02 | Add missing docs for the JS Worker1 export method, as pointed out in forum post 75524f7342. (check-in: a7b267bd11 user: stephan tags: jni-post-3.44) | |
| 21:44 | Fix cosmetic flaw in SQLITE_TXN_* doc. (no code change) (check-in: 72d7c18f80 user: larrybr tags: trunk) | |
| 21:05 | Export sqlite3_get_autocommit() to WASM and add tests for it. (check-in: 7cb6d3cd39 user: stephan tags: jni-post-3.44) | |
| 18:16 | Disable two rtree test cases for Linux-i686. We do not have that platform available for testing. The test cases work on all other 64-bit and 32-bit platforms that we have at hand. So there is no way for us to debug this problem. Better to disable the test. forum post ffcbf789b5386573. (check-in: fed4d6e90b user: drh tags: trunk) | |
| 17:40 | Add makefile targets for fuzzcheck-asan and fuzzcheck-ubsan. (check-in: 27fc14303a user: drh tags: trunk) | |
| 15:31 | Fix to Makefile.in so that the "tool-zip" target can be run from outside the source tree. (check-in: cd118da9db user: dan tags: trunk) | |
| 13:59 | Cleanup shell.c comments. Hide -utf8 option, as it is undocumented and accepted only for backward compatibility. No functional changes except for -help content. (check-in: 3a87995560 user: larrybr tags: trunk) | |
| 10:49 | Back out [2904fcbeebba9189], mostly. The page bitmap is needed even for a partial integrity_check in order to avoid an infinite loops while walking the database. (check-in: dd6e03b373 user: drh tags: trunk) | |
|
2023-10-26
| ||
| 18:41 | In CLI for Windows builds, do MBCS/UTF-8 translation independently for input and output. (And cure an MSVC warning.) (check-in: 80f0b6f9c7 user: larrybr tags: trunk) | |
| 18:24 | Handle utf8 mode restore better for redirected input or output. Move utf8 mode setup to before any invocation command processing. Sync w/trunk. (Leaf check-in: 59452e7c72 user: larrybr tags: win-utf8-io-split) | |
| 17:30 | Enhance the "tool-zip" makefile target on Windows so that it uses more universally available commands to build the ZIP archive. Fix other minor issues with that makefile target at the same time. (check-in: d2f2f91265 user: drh tags: trunk) | |
| 16:59 | Further enhancements to make sure the correct returnning trigger is run when there are nested INSERT RETURNING statements. (check-in: d83405e870 user: drh tags: trunk) | |
| 16:05 | Handle the case where a virtual table xBestIndex method called while coding a trigger fired by a top-level statement with a RETURNING clause prepares a statement that also contains a RETURNING clause. (check-in: ec6bffa3b0 user: dan tags: trunk) | |
| 15:12 | Ready for merge, but could use testing on some dusty old Windows machines. (check-in: 2022061562 user: larrybr tags: win-utf8-io-split) | |
| 12:59 | Deal with the case of a reentrant INSERT on a virtual table where the outer INSERT has a RETURNING clause but the inner does not. dbsqlfuzz 3ac9a1e33f676254e02c0f297263b0a7aeb0c1a5. Fault injected by [a2449bcc2c71d0f4], first appearing in release 3.40.1. (check-in: 8aba78e4db user: drh tags: trunk) | |
|
2023-10-25
| ||
| 20:44 | Cure a harmless MSVC warning. (no other changes) (check-in: 02234ef85e user: larrybr tags: win-utf8-io-split) | |
| 20:27 | In CLI for Windows builds, do MBCS/UTF-8 translation independently for input and output. (WIP) (check-in: 47b13e66e0 user: larrybr tags: win-utf8-io-split) | |
| 20:08 | Updates to the mktoolzip.tcl to work on win32. (Closed-Leaf check-in: 166b775bb5 user: dan tags: win32-mktoolzip) | |
| 19:06 | Fix harmless compiler warnings. (check-in: cc8efe0494 user: drh tags: trunk) | |
| 18:53 | Provide dummy parameter names in the prototype for the new xIntegrity method of the sqlite3_module object. (check-in: 131374d720 user: drh tags: trunk) | |
| 18:35 | Fix minor problems with the "showwal" utility program. Add a missing header to the zipfile.c extension. (check-in: 7b3f866e61 user: drh tags: trunk) | |
| 17:26 | Test module altermalloc3.test requires DQS_DDL to be turned on. (check-in: c4d02f4b07 user: drh tags: trunk) | |
| 15:30 | Add an ALWAYS on branch that was made always-true by the DISTINCT ORDER BY fix. (check-in: c29ebcb0be user: drh tags: trunk) | |
| 14:54 | When doing a DISTINCT aggregate that contains an ORDER BY, only the arguments to the aggregate need to be distinct, not the ORDER BY terms. (check-in: d2dbbdf719 user: drh tags: trunk) | |
| 12:58 | Fix the amalgamation generator so that when it is reporting the Fossil version number in the header comment of the amalgamation, it does not elide the first hex digit of the version hash. (check-in: cc66f526bd user: drh tags: trunk) | |
| 10:37 | Enhance the new xIntegrity method of the sqlite3_module object with new parameters that provide the name of the table being checked and a flag to indicate a "quick_check". Based on feedback in forum post 965c0d02ea. (check-in: bc8afa3f15 user: drh tags: trunk) | |
|
2023-10-24
| ||
| 19:56 | Implement check-in [477577120b897bf1] differently, so as not to disrupt non-standard build configuration. See forum post c11523ca2df50293. (check-in: 50448fe4fd user: drh tags: trunk) | |
| 19:05 | Fix a test case in fts3corrupt4.test by bypassing the fast-prng. (check-in: 540ce72b50 user: dan tags: bedrock) | |
| 17:45 | Test cases for COLLATE and NULLS FIRST/LAST in the ORDER BY for an aggregate function. (check-in: 641f928feb user: drh tags: trunk) | |
| 16:16 | New #ifdefs to fix certain compile-time options. (check-in: 688c6279ef user: drh tags: trunk) | |
| 16:06 | Fix a problem with the fts5 highlight() and snippet() functions when used with tokenizers like "trigram" that output overlapping tokens. Forum post 63735293ec. (check-in: e952db86fa user: dan tags: trunk) | |
| 15:53 | Fix a problem with the fts5 highlight() and snippet() functions when used with tokenizers like "trigram" that output overlapping tokens. Forum post 63735293ec. (Closed-Leaf check-in: d570aa02f7 user: dan tags: fts5-trigram-snippet-fix) | |
| 15:11 | Spelling improvements, in comments only (check-in: 9ee25eeaf1 user: larrybr tags: trunk) | |
| 15:07 | Spelling improvements, in comments only (check-in: 65bcc58378 user: larrybr tags: trunk) | |
| 11:06 | Fix various harmless scan-build warnings. (check-in: 54be9af446 user: drh tags: trunk) | |
| 09:57 | Fix a harmless compiler warning in the expert extension. (check-in: 0c4907ddf9 user: drh tags: trunk) | |
|
2023-10-23
| ||
| 23:34 | Fix a minor typo in the previous. (check-in: 9d388267e4 user: drh tags: trunk) | |
| 23:34 | Add notes on how to build a statically linked version of sqlite3_analyzer.exe. (check-in: 99ce9939c8 user: drh tags: trunk) | |
| 19:51 | Add the sqlite3res file to the Windows build of sqldiff.exe so that the resulting binary shows the SQLite icon. (check-in: c696a4963b user: drh tags: trunk) | |
| 19:27 | Merge the latest trunk enhancments into the reuse-schema branch. (check-in: 52262ac920 user: drh tags: reuse-schema) | |
| 16:08 | Merge latest changes from wal2 into this branch. (check-in: c9c9bc097a user: dan tags: bedrock) | |
| 16:00 | Merge latest trunk changes into this branch. (check-in: 3a6479d3f9 user: dan tags: wal2) | |
| 15:48 | Merge latest trunk changes into this branch. (check-in: c5ef898a79 user: dan tags: begin-concurrent) | |
| 15:30 | Avoid attempting to delete a file while it is open in test script sessionalter.test. (check-in: f20b4a96f7 user: dan tags: trunk) | |
| 15:24 | Revert an earlier change that considered passing a NULL callback to sqlite3_preupdate_hook() to be a misuse. This is required to clear the preupdate hook altogether. (check-in: 1bf6f0f3bb user: dan tags: trunk) | |
| 15:23 | New test cases for PRAGMA integrity_check against FTS4 and FTS5 tables. (check-in: 3950d20c3a user: drh tags: trunk) | |
| 14:24 | Fix mutex1.test to take into account that the prng mutex is not (as of [c84e4483cb4]) taken when writing a header to an in-memory journal. (check-in: c9e37417fc user: dan tags: trunk) | |
| 13:46 | Improved error messages for the xIntegrity method in FTS3/4 and FTS5. (check-in: df69abc082 user: drh tags: trunk) | |
| 12:16 | Fix sqlite3ExprDup() alignment assertions so that they work on 32-bit platforms. (check-in: 143f95efc7 user: drh tags: trunk) | |
| 11:41 | Temporarily disable the ext/expert/expert1-6.0 test, which does not work on my configurations. (check-in: a41b903d0f user: drh tags: trunk) | |
| 11:34 | Add an SQLITE_OMIT_VIRTUALTABLE block around the new vtab code in "PRAGMA integrity_check". (check-in: ab99eb2b6c user: dan tags: trunk) | |
| 11:18 | Add missing test file fts3fault3.test. Should have been part of [7f41d700]. (check-in: 92e64ab63a user: dan tags: trunk) | |
| 02:08 | Merge fixes for expert handling of UDFs and other UD-whatevers. (check-in: b5d7d07df5 user: larrybr tags: trunk) | |
| 02:06 | Add missing JNI sqlite3_result_subtype() binding. (check-in: ac920b5386 user: stephan tags: jni-post-3.44) | |
| 02:01 | Fix the shell1.test test so to align with the new behavior imposed by [bce807cd48763273] - that backslash escapes only work without quoted arguments in dot-commands of the CLI. (check-in: 0db82b4281 user: drh tags: trunk) | |
| 01:55 | Clear some picky warnings, sync w/trunk. (Closed-Leaf check-in: ee58425904 user: larrybr tags: expert-enhancement) | |
| 01:34 | Add many more high-level wrappers to the JNI wrapper1 API. Correct the JNI bindings of sqlite3_strglob/strlike() to compare as the core lib does if their glob argument is NULL and the other is not. (check-in: 55c4b1dc40 user: stephan tags: jni-post-3.44) | |
|
2023-10-22
| ||
| 23:44 | Fix [f5c01676fd281e93] so that it always preserves 8-byte alignment for Expr objects. Add new assert() statement to verify this. (check-in: 678a9728dc user: drh tags: trunk) | |
| 23:36 | Add high-level window function wrapper to the JNI wrapper1 interface. (check-in: a27e747123 user: stephan tags: jni-post-3.44) | |
| 17:27 | Do not do backslash escape processing on any unquoted strings in dot-commands in the CLI - on Windows or on posix-like systems either one. This brings the processing into alignment with the documentation, allows backslash-delimited filenames on Windows (as long as they are unquoted), and causes the CLI to work the same with regard to backslash escapes on both Windows and posix. (check-in: bce807cd48 user: drh tags: trunk) | |
| 14:25 | JNI: flesh out and simplify the APIs for binding and fetching arbitrary Java objects. (check-in: 89fecf1dd8 user: stephan tags: jni-post-3.44) | |
| 13:54 | JNI: add column-get bindings to the wrapper1 Stmt class and extend the AggregateFunction tests to ensure that the aggregate context is honored. (check-in: 60a0e82db2 user: stephan tags: jni-post-3.44) | |
| 13:09 | Add API_ARMOR to sqlite3_clear_bindings(). (check-in: f3fb4d345b user: stephan tags: jni-post-3.44) | |
| 12:43 | Add JNI wrapper1.SqliteStmt.bindXyz() APIs. (check-in: 54fce9bf04 user: stephan tags: jni-post-3.44) | |
| 12:33 | JNI: improve UB protections in sqlite3_bind_blob/text/text16(). (check-in: 5c8383210a user: stephan tags: trunk) | |
| 11:11 | Add missing ScalarFunction.java to JNI build. (check-in: b8258103fb user: stephan tags: trunk) | |
|
2023-10-21
| ||
| 22:31 | In the CLI, do not translate unquoted backslash escapes on dot-commands as that can damage filename arguments. (check-in: 4a0e2c6e17 user: drh tags: trunk) | |
| 20:34 | Remove a branch that cannot affect the outcome from FkNoAction processing in fkey.c. Replace it with an assert(). (check-in: 023a9dbe83 user: drh tags: trunk) | |
| 20:03 | Replace the patch at [5cb61c6788d7c017] with a better way to avoid failing PRAGMA integrity_check if a module implementation is not loaded, as the use of suppressErr can lead to problems. (check-in: be5737ee4f user: drh tags: trunk) | |
| 19:51 | Check-in contains stray edit. (Closed-Leaf check-in: cbea52e9ef user: drh tags: mistake) | |
| 18:12 | Fix a problem allowing a COMMIT following an OOM to cause fts3/4 corruption. (check-in: 7f41d7006d user: dan tags: trunk) | |
| 16:33 | Add the SQLITE_TESTCTRL_FK_NO_ACTION test control. Make it available in the CLI. Fix a minor problems with SQLITE_CHANGESETAPPLY_FKNOACTION in sessions. (check-in: 91b64c6a70 user: drh tags: trunk) | |
| 16:25 | Extra comment on the implementation of SQLITE_TESTCTRL_FK_NO_ACTION, warning about the need to reset the schema in order for the setting change to take full effect. (Closed-Leaf check-in: a50a333ae1 user: drh tags: fknoaction) | |
| 15:21 | Add missing "finish_test" to sessionnoact.test. (check-in: 9a1d37f547 user: dan tags: fknoaction) | |
| 15:04 | Fix a problem with SQLITE_CHANGESETAPPLY_FKNOACTION and the foreign-key-trigger-cache. (check-in: 95304ec6c9 user: dan tags: fknoaction) | |
| 12:54 | Add SQLITE_TESTCTRL_FK_NO_ACTION. (check-in: 563cf5f782 user: drh tags: fknoaction) | |
| 11:43 | Adjust an EXPLAIN QUERY PLAN output in scanstatus2.test to account for a different loop order taken due to the removal of the view-scan optimization. (check-in: 9deb8b6915 user: drh tags: trunk) | |
| 11:34 | Compress the content of the status line in testrunning.tcl so that all the same status information appears but with less punctuation and with "zero" values omitted, so that the status line will fit comfortably on an 80-column terminal window. (check-in: 9663513116 user: drh tags: trunk) | |
| 11:13 | Create the new string_agg(X,Y) aggregate function which is an alias for the two-argument group_concat(X,Y) function, for compatibility with SQL-Server and PostgreSQL. (check-in: a3b3df8a9e user: drh tags: trunk) | |
| 11:06 | Avoid an unnecessary malloc() for the page usage bitmap when running a partial integrity_check. (check-in: 2904fcbeeb user: drh tags: trunk) | |
| 11:00 | Fix a test case broken by the previous check-in. (Leaf check-in: 1e61864c3b user: drh tags: string_agg) | |
|
2023-10-20
| ||
| 20:19 | Add string_agg(X,Y) as an alias for group_concat(X,Y), for compatibility with SQLServer and PG. (check-in: b91c19bf26 user: drh tags: string_agg) | |
| 19:59 | Fix a problem allowing a COMMIT following an OOM to cause fts5 corruption. (check-in: fba3129d13 user: dan tags: trunk) | |
| 19:06 | Fix PRAGMA integrity_check so that it does not raise an error if the schema contains a CREATE VIRTUAL TABLE that does not have its module loaded. (check-in: 5cb61c6788 user: drh tags: trunk) | |
| 18:09 | Omit some redundant calls to strlen() used to find the size of Expr.u.zToken in sqliteExprDup(). This inefficiency was seen while working on the previous check-in, and I thought it best to fix it while it was fresh in mind. (check-in: b7a84eff5d user: drh tags: trunk) | |
| 17:15 | Improvements to the sqlite3ExprDup() logic for faster performance and better run-time error detection. This check-in fixes the 5x oversize memory allocation bug from [f371e4c0f8ea73ae] as well as all other known issues that result from handing the ORDER BY clause of an aggregate function off of the pLeft pointer of the Expr object. (check-in: f5c01676fd user: drh tags: trunk) | |
| 17:06 | Add the SQLITE_CHANGESETAPPLY_FKNOACTION flag to sqlite3session.h, for passing to sqlite3changeset_apply_v2() to cause all foreign key constraints to behave as if they were declared NO ACTION. (check-in: fc9f82ea08 user: dan tags: trunk) | |
| 15:47 | Simplifications and optimizations to the Expr object duplication logic. The 5x multiplier crutch from [f371e4c0f8ea73ae] is still present. More fixes are still needed. (check-in: 56142a7816 user: drh tags: trunk) | |
| 14:05 | Omit an unused constant from sessionfuzz.c to prevent a compiler warning. (check-in: a0cf7e24f9 user: drh tags: trunk) | |
| 12:23 | Correct the opfs-sahpool VFS's xGetLastError() method to return the previous error code, not 0, on success. (check-in: 95a1dde631 user: stephan tags: trunk) | |
| 11:44 | Merge trunk into the wasm-xGetLastError branch. (Leaf check-in: 48a9bd649d user: stephan tags: wasm-xGetLastError) | |
| 10:18 | Use sqlite3ParserAddCleanup() instead of calling sqlite3ExprListDelete() directly when disposing of an unused ORDER BY in an aggregate function, to avoid disrupting ALTER TABLE data structures. (check-in: d083e42086 user: drh tags: trunk) | |
|
2023-10-19
| ||
| 20:46 | Merge recent trunk enhancements into the jsonb branch. (check-in: f47a8d0a20 user: drh tags: jsonb) | |
| 20:06 | Remove a faulty assert() that was added just a few check-ins ago by [8b6fffb552c30f9c]. (check-in: 18e7c826f0 user: drh tags: trunk) | |
| 19:57 | For TK_ORDER expression nodes to always be full-size. (check-in: a5c73b46f4 user: drh tags: trunk) | |
| 19:19 | Fix an adverse interaction between the new aggregate ORDER BY logic and the expression compressor. Update 2023-10-20: Memory allocations were multiplied by a factor of 5 on line 1575 of expr.c. This was a debugging change that I neglected to remove prior to checking it. That change masks deeper problems that will be solved in later check-ins. (check-in: f371e4c0f8 user: drh tags: trunk) | |
| 19:08 | In the TreeView logic (used for debugging only) do not show unnecessary fields of the Window object when a function has a FILTER. (check-in: d2c6b82c34 user: drh tags: trunk) | |
| 18:23 | Fix an fts3 problem caused by reducing the page size using the undocumented "nodesize" option, then running an incremental-merge. (check-in: 2875dcb1ac user: dan tags: trunk) | |
| 18:07 | Simplify the Expr compression logic slightly by adding the new EP_FullSize property to expressions that are exceptions to the rule and should not be compressed. (check-in: d5ae82ec52 user: drh tags: trunk) | |
| 13:35 | Simplification to sqlite3GetVarint32() to avoid confusing gcov. (check-in: 89862c51ad user: drh tags: trunk) | |
| 13:00 | Fix an error in a debugging routine used inside of testcase(). Does not appear in production. Problem discovered by scan-build. (check-in: c6c9d7ed6d user: drh tags: trunk) | |
| 12:36 | New assert() statements to help verify correctness of the ORDER BY aggregate code. (check-in: 8b6fffb552 user: drh tags: trunk) | |
| 12:12 | Fix the sqlite3ReferencesSrcList() routine so that it recognizes columns in the ORDER BY clause of an aggregate. Fixes a problem with [634286828dad873d] discoverd by dbsqlfuzz. (check-in: 3d26f1aaa4 user: drh tags: trunk) | |
| 01:26 | Add support for ORDER BY on the argument list of aggregate functions. (check-in: 634286828d user: drh tags: trunk) | |
| 01:09 | Merge the latest changes from trunk. (Closed-Leaf check-in: d18bc40014 user: drh tags: agg-orderby) | |
| 00:25 | Fix a false-positive in run-time error checking. (check-in: cd63eec075 user: drh tags: trunk) | |
|
2023-10-18
| ||
| 23:48 | Changes for test coverage. (check-in: ddfa09c603 user: drh tags: agg-orderby) | |
| 22:53 | Test case for alter column that is used in the ORDER BY of an aggregate. (check-in: 648ddb3a8e user: drh tags: agg-orderby) | |
| 22:27 | Deal with an OOM condition while processing aggregate ORDER BYs. (check-in: b6d44427ec user: drh tags: agg-orderby) | |
| 22:03 | Make sure all terms of the ORDER BY within an aggregate go through aggregate analysis. Do not attach an aggregate ORDER BY to a window function. (check-in: 16f3805514 user: drh tags: agg-orderby) | |
| 19:44 | Basic test cases. (check-in: 6cccf86c36 user: drh tags: agg-orderby) | |
| 19:07 | Fix one minor error in order to get all legacy tests to pass. (check-in: 5a885139c4 user: drh tags: agg-orderby) | |
| 18:11 | ORDER BY on aggregates seem to work, at least for simple smoke tests. Lots more testing is needed though. Surely there are many bugs. (check-in: 64c12a835b user: drh tags: agg-orderby) | |
| 13:58 | Basic error checking. Resolve symbols in the aggregate ORDER BY expressions. (check-in: c83a53a574 user: drh tags: agg-orderby) | |
| 13:18 | Enhance the parser so that it can accept an ORDER BY clause on a function invocation. For this incremental check-in, the ORDER BY clause is currently ignored. (check-in: 3a98ff24bf user: drh tags: agg-orderby) | |
|
2023-10-17
| ||
| 23:35 | JS: replace one errant reference to 'self' with 'globalThis' and remove a separate dead-code 'self' reference. (check-in: da1a47932e user: stephan tags: trunk) | |
| 19:33 | Fix a harmless compiler warning about variant types for a pointer function. (check-in: 37ff0d8e7f user: drh tags: trunk) | |
| 18:59 | Make a new branch in the SqlExec opcode reachable by tests. (check-in: 023ad470b6 user: drh tags: trunk) | |
| 18:28 | Omit an unreachable branch when SQLITE_ENABLE_API_ARMOR is not defined. (check-in: 5f8b807b56 user: drh tags: trunk) | |
| 17:53 | Changes to sqlite3IntFloatCompare() in an attempt to better measure branch coverage in the face of aggressive compiler optimization. (check-in: 5781d043ff user: drh tags: trunk) | |
| 13:41 | Fix a JSON bug introduced by the optimization of [df099ad713011b67] and first appearing in 3.43.0. The problem occurs when doing a JSON_EXTRACT() on an array element that was added by JSON_SET() without first reparsing. Reported by forum post fc0e3f1e2a. (check-in: e5099c549a user: drh tags: trunk) | |
| 11:57 | Enhance the documentation of sqlite3_deserialize() to make it clear that the input database may not be in WAL mode. Forum post a7e272cee9ac469f (check-in: e754789971 user: drh tags: trunk) | |
| 10:47 | When an I/O or similar error occurs during a transaction with journal_mode=MEMORY, attempt to rollback before closing the journal, as all rollback information is forgotten when a memory rollback journal is closed. (check-in: 1d67f75de2 user: drh tags: trunk) | |
| 02:15 | Harden API_ARMOR checks for sqlite3_stmt_scanstatus_v2(). (check-in: d3f38e813b user: stephan tags: trunk) | |
|
2023-10-16
| ||
| 16:04 | JNI: add aggregate function support to the wrapper1 API. (check-in: 15b28b340a user: stephan tags: trunk) | |
| 14:31 | JNI: add scalar UDF support to the wrapper1 API. (check-in: a850535766 user: stephan tags: trunk) | |
| 13:04 | JNI: initial draft (untested - requires more infrastructure first) of a UDF argument/result-handling interface which completely hides the C-style API from the client. (check-in: 43b10a5cf9 user: stephan tags: trunk) | |
| 10:38 | JNI: cleanups in Tester2 and update the jar makefile target to account for [9fcdf96adca2]. (check-in: abc82bf4b8 user: stephan tags: trunk) | |
| 10:27 | JNI: move the C-style API parts into the capi subpackage and the higher-level wrapper into (tentatively) wrapper1, so that CApi.java can support multiple independent higher-level wrappers without name collisions, and CApi can be made public but have the option to be elided from wrapper-level javadocs for wrappers which do not wish to expose it. (check-in: 9fcdf96adc user: stephan tags: trunk) | |
| 08:10 | JNI: after calling a Java-side UDF, zero-out the pointer of the Java-side sqlite3_context and sqlite3_value array entries to avoid misbehavior if a client makes the mistake of holding a reference to one of those objects. (check-in: 9fc3104f76 user: stephan tags: trunk) | |
| 08:05 | JNI: do not expose SQLITE_OPEN_... flags which are specific to VFSes. (check-in: 2b4e53d8be user: stephan tags: trunk) | |
|
2023-10-15
| ||
| 13:36 | Change 3 instance of #if SQLITE_ENABLE_API_ARMOR to #ifdef for consistency with how it is normally used. (check-in: dd766eeb59 user: stephan tags: trunk) | |
| 13:32 | JNI: enable all optional components in the default build and fix a test broken by an option toggle. (check-in: 5586a9df58 user: stephan tags: trunk) | |
| 13:25 | Correct non-void return from sqlite3_preupdate_hook() when API_ARMOR is enabled. Broken by [6cb77503484e]. (check-in: 40f5906f48 user: stephan tags: trunk) | |
| 12:17 | Merge trunk into the wasm-xGetLastError branch. (check-in: 0239e374d2 user: stephan tags: wasm-xGetLastError) | |
| 12:11 | Add coverage of more functions to SQLITE_ENABLE_API_ARMOR builds. (check-in: 6cb7750348 user: stephan tags: trunk) | |
|
2023-10-14
| ||
| 20:44 | JNI: extend [baf220e78a46246c47] to include macro-generated sqlite3_value_...() bindings. (Closed-Leaf check-in: ad34b2542e user: stephan tags: api-armor-audit) | |
| 20:34 | JNI: make the sqlite3_value_...() family of bindings resistent to NULL arguments. (check-in: baf220e78a user: stephan tags: api-armor-audit) | |
| 20:24 | Do not allow an ALTER TABLE ADD COLUMN on a STRICT table if the added column contains a DEFAULT clause that would violate the type of the added column. (check-in: 75b075863e user: drh tags: trunk) | |
| 20:01 | Add API_ARMOR support to the scanstatus family of functions. (check-in: 2f3101f016 user: stephan tags: api-armor-audit) | |
| 17:14 | The rtreecheck() SQL function should not invoke BEGIN or COMMIT as this causes issues for statement transactions. (check-in: b7b2e30b57 user: drh tags: trunk) | |
| 16:57 | JNI: add a missing result code check to sqlite3_bind_value(stmt, null). (check-in: f1a357f42d user: stephan tags: api-armor-audit) | |
| 16:56 | JNI: add missing sqlite3_bind_value() and minor memory-safety-related cleanups. (check-in: 3900031763 user: stephan tags: api-armor-audit) | |
| 16:29 | Add API_ARMOR support to the sqlite3_result_...() family of functions and sqlite3_bind_zeroblob64(). (check-in: afabe3e35a user: stephan tags: api-armor-audit) | |
| 14:53 | More API_ARMOR additions. (check-in: 78ebf838f6 user: stephan tags: api-armor-audit) | |
| 13:24 | Add column name to API_ARMOR check in sqlite3_blob_open() to avoid a null-pointer deref. (check-in: 0114a6622a user: stephan tags: api-armor-audit) | |
| 12:45 | Revert [f6cd88e6b234] - the NULL callback case is perfectly legal. (check-in: 718ab67607 user: stephan tags: api-armor-audit) | |
| 12:40 | Bring JNI-side sqlite3_last_insert_rowid() and sqlite3_table_column_metadata() in line with the core's NULL handling. (check-in: c2afc1c2a2 user: stephan tags: api-armor-audit) | |
| 12:20 | Extend API_ARMOR checks on sqlite3_commit/rollback_hook() to include a check for the callback pointer. (check-in: f6cd88e6b2 user: stephan tags: api-armor-audit) | |
| 12:19 | Add missing JNI bindings for sqlite3_db_readonly() and sqlite3_db_name(). Code-adjacent tweaks for the API_ARMOR audit. (check-in: e5eace747a user: stephan tags: api-armor-audit) | |
| 10:54 | Bug fix in sqlite3_analyzer: for databases larger than 1GiB, take into account the lock-byte page when calculating the number of freelist pages. (check-in: 26a909cdd3 user: drh tags: trunk) | |
|
2023-10-13
| ||
| 22:19 | Earlier detection of a host of errors in CREATE TABLE, such the CREATE TABLE statement itself fails, rather than generating an error on the first attempted use of the created table. (check-in: 348fa7aaf7 user: drh tags: trunk) | |
| 19:41 | Apply the correct affinity to DEFAULT values that are TRUE or FALSE. (check-in: 4958db70c8 user: drh tags: trunk) | |
| 18:29 | Do not allow triggers on shadow tables under defensive mode. (check-in: 44b932ff16 user: drh tags: trunk) | |
| 15:59 | Fix an fts5 problem caused by a 'rebuild' followed by a DELETE in secure-delete mode. (check-in: 18be505c62 user: dan tags: trunk) | |
| 13:49 | Immediately fail a CREATE TABLE statement that attempts to create a table that has a generated column loop. Legacy allows the table to be created but the table would not be usable for anything. (check-in: 3237bf9641 user: drh tags: trunk) | |
| 12:57 | Actually prevent PRAGMA writable_schema=ON from being set in defensive mode, rather than just preventing it from functioning. (check-in: 2b574d9e7e user: drh tags: trunk) | |
| 12:48 | Round one of an audit for SQLITE_ENABLE_API_ARMOR for functions exposed by JNI and those functions missing armor, as reported in several forum posts. (check-in: 8c25c4b18a user: stephan tags: api-armor-audit) | |
| 01:39 | Avoid potential overflow in hex(). See forum post 7ac0c9c5ea. (check-in: 2e968114fd user: larrybr tags: trunk) | |
|
2023-10-12
| ||
| 20:51 | Make sure virtual tables have been connected before trying to invoke the xIntegrity method during PRAGMA integrity_check. (check-in: 4a4eccb681 user: drh tags: trunk) | |
| 19:46 | Fix a problem with an fts5 secure-delete on a rowid/term pair that follows a legacy delete of the same pair. (check-in: 579aea0c28 user: dan tags: trunk) | |
| 18:46 | Enable SQLITE_VTAB_INNOCUOUS for FTS3, FTS5, and RTREE. (check-in: f34c533b6c user: drh tags: trunk) | |
| 18:09 | Add test case for [29937081]. (check-in: d3b983edf7 user: dan tags: trunk) | |
| 17:47 | Merge fixes from trunk into the jsonb branch. (check-in: a760bd7bcc user: drh tags: jsonb) | |
| 17:41 | Make sure the journal file is closed when transitioning into MEMORY journal mode, to avoid an assertion fault in the new sqlite3_randomness() avoidance code added by [c84e4483cb44f827]. (check-in: 29937081a9 user: drh tags: trunk) | |
| 15:12 | CLI to check for rare prepare failures. See forum post 5be6395182. (check-in: 286d1e8012 user: larrybr tags: trunk) | |
|
2023-10-11
| ||
| 21:08 | Add the tokendata=1 option to ignore trailing token-data when querying an fts5 table. (check-in: 122935182a user: dan tags: fts5-token-data) | |
| 20:37 | Unconditionally force use of SQLITE_ENABLE_API_ARMOR in the WASM and JNI builds. Their corresponding test suites still work. (check-in: c11394b50d user: stephan tags: trunk) | |
| 17:24 | Fix the use of an uninitialized value that occurs when doing a json_insert() of a string value that contains embedded U+0000 characters. (check-in: d3c0cbb909 user: drh tags: trunk) | |
| 17:21 | Fix the use of an uninitialized value that occurs when doing a json_insert() of a string value that contains embedded U+0000 characters. (check-in: fc5ee9e51a user: drh tags: jsonb) | |
| 13:52 | Add (prepare, step, reset, finalize) parts of the JNI level-2 stmt wrapper and associated tests. (check-in: a7082f186f user: stephan tags: trunk) | |
| 13:34 | Simplification to sqlite3ApiExit(). Generates identical machine code, but easier for humans to read. (check-in: 793bbfa5af user: drh tags: trunk) | |
| 13:19 | Fix a missing zero-terminator on a string when processing JSON aggregates into JSONB. (check-in: fb81d570a3 user: drh tags: jsonb) | |
| 12:44 | Fix an issue that can arise when processing corrupt JSONB. (check-in: e50045c222 user: drh tags: jsonb) | |
| 12:21 | Improved robustness against corrupt JSONB. (check-in: 0fbda92bb0 user: drh tags: jsonb) | |
| 11:42 | Fix an assertion fault in json_patch() that can occur if the patch JSON is malformed JSONB. Report the malformed JSONB instead. (check-in: a72d54645c user: drh tags: jsonb) | |
|
2023-10-10
| ||
| 23:02 | Improved robustness in the decoding of JSON5 text escape sequences found in malformed JSONB. (check-in: 35e0108af2 user: drh tags: jsonb) | |
| 18:55 | Fix an off-by-one error in the changes from the previous check-in on the jsonb branch. (check-in: 216191b113 user: drh tags: jsonb) | |
| 18:42 | Improved robustness when translating corrupt JSONB into JSON text. (check-in: 0caa320d90 user: drh tags: jsonb) | |
| 18:32 | Fix a potential buffer overrun due to corrupt JSONB. (check-in: 5cbb861fc6 user: drh tags: jsonb) | |
| 18:04 | Fix bugs uncovered by the fuzzer. (check-in: c96eb7fb61 user: drh tags: jsonb) | |
| 17:34 | Merge the latest trunk enhancements into the jsonb branch. (check-in: f93f16c94d user: drh tags: jsonb) | |
| 15:33 | Fix a bug in the mkautoconfamal.sh script, introduced by check-in [3308fdda4b81c110] so that the "snapshot-tarball" and "amalgamation-tarball" makefile targets work again when run from outside of the source tree. (check-in: 65ccf5fef8 user: drh tags: trunk) | |
| 12:16 | Start adding tests for the second JNI layer. (check-in: 0177f4dfe8 user: stephan tags: trunk) | |
|
2023-10-09
| ||
| 22:45 | Use snprintf() in place of sprintf() in a debugging function in the CLI. (check-in: 5e5e4d2b49 user: drh tags: trunk) | |
| 18:33 | Systematize the names of some of the translation function in the JSON implementation. (check-in: db44bd1d62 user: drh tags: jsonb) | |
| 17:54 | Avoid calling sqlite3_randomness and taking the PRNG mutex when writing a journal header in "journal_mode=memory" mode. (check-in: c84e4483cb user: dan tags: trunk) | |
| 14:56 | Add a TCL script that does various verification checks on the source tree to make sure that generated code has been updated correctly. (check-in: 1f1a358af7 user: drh tags: trunk) | |
| 14:47 | Fix a compiler warning caused by the previous check-in. (check-in: 7e8768bf8b user: drh tags: trunk) | |
| 14:05 | Turn on SEH by default when building using MSVC. (check-in: f57e8275cf user: drh tags: trunk) | |
| 12:57 | Merge the latest trunk fixes and enhancements into the jsonb branch, and especially the JSON cache spill UAF fix. (check-in: 9422c24f4a user: drh tags: jsonb) | |
| 12:46 | Fix a potential UAF caused by JSON parser cache spill. Forum post b25edc1d46. (check-in: a163fecca9 user: drh tags: trunk) | |
| 12:45 | Flesh out the error state captured by SqliteException.java. Doc additions. (check-in: 5c5397ff15 user: stephan tags: trunk) | |
| 12:39 | Fix harmless compiler warning in the test module for sessions. (check-in: 3d5ec99397 user: drh tags: trunk) | |
| 12:10 | In the VDBE trace output (available under -DSQLITE_DEBUG only), identify register values that hold a refernce-counted string. (Closed-Leaf check-in: 53d5c50462 user: drh tags: mistake) | |
| 11:46 | Add JNI Sqlite and SqliteException classes. Add Tester2.java as the main test app for the high-level API. (check-in: 6acf52be7a user: stephan tags: trunk) | |
| 10:44 | Minor JNI doc and public/private cleanups. (check-in: c49d36ece2 user: stephan tags: trunk) | |
| 10:30 | Rename SQLite3Jni to CApi to (A) reduce name prefix collisions with incoming classes and (B) align with its counterpart in the JS build. Remove the Canonical annotation because (A) the new code separation will inherently make that distinction and (B) the line between truly canonical and semi-canonical (e.g. differing in signature overloads) is blurry enough that consistent use of that annocation is becoming an unnecessary burden. (check-in: ca216b4486 user: stephan tags: trunk) | |
|
2023-10-07
| ||
| 23:35 | Remove some unnecessary code. Report errors for invalid JSONB input on an extract. (check-in: cbea16c29e user: drh tags: jsonb) | |
| 19:46 | The return from sqlite3_value_blob() in jsonFuncArgMightBeBinary() might be a NULL pointer. Check for that case. (check-in: 7b52b266b0 user: drh tags: jsonb) | |
| 19:40 | Improved detection of malformed JSONB when parsing it into a JsonNode array. (check-in: ed99a78841 user: drh tags: jsonb) | |
| 19:05 | Fix the jsonbChangePayloadSize() routine so that it shifts the payload in order to always render the most compact encoding of the payload size. This is necessary as sometimes (as discovered by dbsqlfuzz) the payload size can grow significantly due to json_insert() or json_replace(). (check-in: 8d6d04ca97 user: drh tags: jsonb) | |
| 17:50 | Improvements to error messages returned when the ->> operator fails. (check-in: 2f3388f14c user: drh tags: jsonb) | |
| 17:29 | Fix a problem with sqlite3changegroup_schema() and patchsets. (check-in: c4ab4200dc user: dan tags: trunk) | |
| 16:32 | Add the sqlite3changegroup_schema() API. To allow changegroup objects to upgrade the schema of a changeset/patchset under some circumstances. (check-in: 03f9e50b15 user: dan tags: trunk) | |
| 16:07 | Fix a problem with the changes on this branch and tables that use an implicit primary key. (Closed-Leaf check-in: 1f9d10235f user: dan tags: session-alter) | |
| 11:37 | Merge the memory leak fix from trunk. (check-in: 358de1b09f user: drh tags: jsonb) | |
| 11:36 | Improved error messages from search on JSONB. (check-in: 96cfdc31e3 user: drh tags: jsonb) | |
| 09:13 | Report unknown JSONB element type when parsing JSONB into JsonNode. (check-in: 1f4d326825 user: drh tags: jsonb) | |
| 08:15 | Add a test case to prevent a regression of the leak fixed in the previous trunk check-in. (check-in: f99ff655d0 user: drh tags: trunk) | |
| 08:00 | Fix a resource leak: sqlite3_blob_reopen() was failing to invoke the xDel() distructor on a register when it sets that register to the new rowid. This was never a problem prior to the large-column cache of [771fe35074b50b8d] as that destructor was always a no-op. dbsqlfuzz cd96368deaece480fb94d42427dde053737a650e. (check-in: 545edd5ecf user: drh tags: trunk) | |
|
2023-10-06
| ||
| 23:02 | Correct handling of "raw" strings in JSON. This requires three test-case changes in TH3 to add double-quotes to the path outputs from json_tree(). The new behavior is correct, I believe. (check-in: ab2bf3e359 user: drh tags: jsonb) | |
| 22:16 | Improved error detection for JSONB inputs. (check-in: 6945e11aa4 user: drh tags: jsonb) | |
| 20:39 | Add missing source code comments and fix other issues with the new code on this branch. (check-in: df39fbe9ab user: dan tags: session-alter) | |
| 19:46 | Update this branch with latest changes from the trunk. (check-in: 897e926a5e user: dan tags: session-alter) | |
| 19:01 | Add tests for the sqlite3changegroup_schema() API. (check-in: 5dab481c10 user: dan tags: session-alter) | |
| 18:21 | Incremental improvements to the JSONB logic. (check-in: fe326829c2 user: drh tags: jsonb) | |
| 15:35 | Fixes to rendering JSON5 extensions encoded as JSONB. (check-in: 5a17e4479a user: drh tags: jsonb) | |
| 14:59 | Fix compiler warnings. (check-in: 5227add3c8 user: drh tags: jsonb) | |
| 14:52 | Improvements to error handling. (check-in: b41dd237fb user: drh tags: jsonb) | |
| 13:05 | Merge compiler warning fixes from trunk into the jsonb branch. (check-in: 6409d30791 user: drh tags: jsonb) | |
| 12:55 | Remove an unused parameter from the recomputeColumnsNotIndexed() routine in order to squash a harmless compiler warning. (check-in: 9bf4bfd680 user: drh tags: trunk) | |
| 12:51 | Ensure that all fields of static sqlite3_module objects are explicitly initialized, in order to hush-up nuisance compiler warnings. (check-in: f3b3d712d6 user: drh tags: trunk) | |
| 12:22 | Remove an unused static variable from shell.c.in in order to silence a harmless compiler warning. (check-in: 477577120b user: drh tags: trunk) | |
| 12:15 | Increase the size of some variables associated with the PMA sorter in order to avoid any possibility of a signed integer overflow. Chromium fuzzer issue 1489025. (check-in: dc3be3af47 user: drh tags: trunk) | |
| 00:06 | Improvements to coping with malformed JSONB. (check-in: 563cde404c user: drh tags: jsonb) | |
|
2023-10-05
| ||
| 23:05 | Better error detection when doing a lookup on a JSONB. (check-in: 6e8e0eedbf user: drh tags: jsonb) | |
| 22:52 | Improvements to comments. No changes to code. (check-in: ac74d78776 user: drh tags: jsonb) | |
| 20:17 | Turn an unreachable branch into an assert(). (check-in: 0f75199160 user: drh tags: jsonb) | |
| 19:09 | Add the sqlite3changegroup_schema() API. To allow changegroups to handle differences in schema created by ALTER TABLE ADD COLUMN. (check-in: 309deee2dd user: dan tags: session-alter) | |
| 18:33 | Fix the parsing of non-standard "Infinity" and "NaN" values from text into JSONB. (check-in: df1fbbeb83 user: drh tags: jsonb) | |
| 18:09 | Change the json_valid(X) routine to return true whenever X is a blob that could plausibly be a valid JSONB. (check-in: 425f0b85a6 user: drh tags: jsonb) | |
| 17:52 | Fix the text-to-JSONB parser so that it handles some JSON5 floating point literals correctly. (check-in: 564edb3b6d user: drh tags: jsonb) | |
| 16:33 | Slightly stricter testing for when a BLOB is valid JSONB: If the element is a null, true, or false, its payload size must be zero. (check-in: 487781be8a user: drh tags: jsonb) | |
| 15:05 | Fix a memory leak following a syntax error in jsonb(). (check-in: bf4b36eda8 user: drh tags: jsonb) | |
| 15:02 | Allow the PG-style syntax for the PATH operand on the right-hand side of the ->> and -> operators. (check-in: bae5071b08 user: drh tags: jsonb) | |
| 11:22 | Merge trunk enhancements into the jsonb branch. (check-in: be5907b648 user: drh tags: jsonb) | |
| 11:06 | Improved detection of corrupt databases in balance_nonroot(). dbsqlfuzz d1cf013c50a620b68c2a5bd240d29afd65e5f58e. (check-in: a2464bbb82 user: drh tags: trunk) | |
| 11:04 | Do not squelch exceptions from SAHPool VFS importDb() - rethrow them. Problem reported in forum post c80fc578809b80a3. (check-in: 325bcdea4a user: stephan tags: trunk) | |
| 10:35 | Remove a stray blank line from the beginning of btree.c. No functional code changes. (check-in: c89983dcfc user: drh tags: trunk) | |
|
2023-10-04
| ||
| 21:15 | Allow a session object to generate a changeset, even if columns were added to one of the tables using ALTER TABLE ADD COLUMN while the changeset was being collected. (check-in: a3f435eccf user: dan tags: session-alter) | |
| 12:49 | The Makefile distinguishes between tcl8.4 and tcl8.5. Some makefile targets require tcl8.5, but others (ex: "sqlite3.c", "shell.c", and "sqlite3") require only tcl8.4. (check-in: 770308db97 user: drh tags: trunk) | |
| 11:52 | Modify the main makefile so that it fails with an error if the tclsh found by ./configure is not tclsh 8.5 or later. Forum post 4380363682708ece. (check-in: 1765f3b5a0 user: drh tags: trunk) | |
| 11:04 | Hard fail the ./configure script if it is unable to find a working tclsh. Forum post 4380363682708ece. (Closed-Leaf check-in: 9f6402831b user: drh tags: error-no-tclsh) | |
|
2023-10-03
| ||
| 22:40 | Fix a memory leak in JSON group-aggregates when the output is JSONB. (check-in: 08e7db138b user: drh tags: jsonb) | |
| 21:54 | Fix a bug in the jsonReturnFromBlob() function that causes a positive result for a negative value for when a JSON integer is too large and needs to be converted into double. (check-in: dca684da0c user: drh tags: jsonb) | |
| 20:58 | Fix problems in the "json" output column of the json_tree() virtual table for the case when the input is JSONB. (check-in: fefa4475c4 user: drh tags: jsonb) | |
| 20:01 | Augment the jsonBlobChangePayloadSize() routine so that it tries to shift content in order to render the payload size in its minimal form. (Closed-Leaf check-in: 562e8e7b08 user: drh tags: jsonb-opt1) | |
| 19:37 | Improved handling of OOM while translating the JsonNode representing into the BLOB representation. (check-in: ef5956710b user: drh tags: jsonb) | |
| 19:06 | Fixes for fts5 expression parser module to allow embedded 0x00 bytes in tokens. (check-in: 342c8d0783 user: dan tags: fts5-token-data) | |
| 17:07 | Update fts5_decode() to allow for embedded 0x00 bytes in tokens. (check-in: e051120067 user: dan tags: fts5-token-data) | |
| 11:36 | Merge the latest trunk enhancements into the jsonb branch. (check-in: e6406a9865 user: drh tags: jsonb) | |
| 10:59 | Fix a problem in the JSONB parser that comes up following an OOM. (check-in: 355acfb188 user: drh tags: jsonb) | |
| 10:43 | Fix an issue with the use of jsonb_group_array() and jsonb_group_object() when used by window functions. (check-in: 808bd349ba user: drh tags: jsonb) | |
|
2023-10-02
| ||
| 23:56 | New test cases for JSONB. (check-in: 6d4aeff575 user: drh tags: jsonb) | |
| 20:16 | Fix jsonb_insert() so that it does not behave like jsonb_set(). New test cases added. (check-in: 54197149b8 user: drh tags: jsonb) | |
| 17:12 | JNI: when fetching text-or-blob/length pairs, fetch the text-or-blob first, then the length, as the API docs suggest. (check-in: e4f9d3946f user: stephan tags: trunk) | |
| 17:06 | Fix the length of the string in the new concat() and concat_ws() functions. (check-in: 3252432265 user: drh tags: trunk) | |
| 15:56 | Remove an ALWAYS() from a branch that can in fact be false following an OOM fault. (check-in: 3a1feb1c46 user: drh tags: trunk) | |
| 15:37 | Revisit the opfs-sahpool's handling of sqlite3_vfs::xGetLastError(). This impl seems to be in line with what the library internal expects but it requires more testing (via purposely-induced I/O errors) before merging. (check-in: c53fd21f68 user: stephan tags: wasm-xGetLastError) | |
| 14:51 | New test cases for JSONB. (check-in: d624c31e5c user: drh tags: jsonb) | |
| 14:44 | Pointer-casting-related fixes for JNI on 32-bit ARM (pi4 armv7l). (check-in: 54441039ae user: stephan tags: trunk) | |
| 13:35 | Allow json_replace() to accept JSONB arguments as the new value. (check-in: 95eb7b37fa user: drh tags: jsonb) | |
| 13:20 | Improvements to error handling for BLOB inputs on JSON. (check-in: 14f20ecbfa user: drh tags: jsonb) | |
| 12:40 | Gather forward references into a single place for the JSON code. Allow JSONB arguments to json_array() and json_object() and similar. (check-in: c352201b8c user: drh tags: jsonb) | |
|
2023-10-01
| ||
| 18:59 | Fix problems following OOM in JSONB parsing. (check-in: 0d8cd6b5fb user: drh tags: jsonb) | |
| 12:15 | Add JNI binding for sqlite3_normalized_sql(). (check-in: 2532e5662a user: stephan tags: trunk) | |
| 11:53 | Make JNI binding of sqlite3_value_frombind() return boolean instead of int and add tests for it. (check-in: 906e2ed3e9 user: stephan tags: trunk) | |
|
2023-09-30
| ||
| 18:13 | Changes so that fts5 can handle tokens with embedded '\0' bytes. (check-in: c027c092c4 user: dan tags: fts5-token-data) | |
| 17:08 | Fix JNI binding to compile without SQLITE_ENABLE_PREUPDATE_HOOK. Add build option to disable all optional ENABLE flags. (check-in: c04022b740 user: stephan tags: trunk) | |
| 16:50 | Restore the trunk version of sqlite3_user_data(). Fix the xColumn for virtual tables so that the sqlite3_context contains a valid but NULL user data pointer. (check-in: 15ffd932fe user: drh tags: jsonb) | |
| 16:19 | Make all SQLite3Jni methods which take a void-pointer-as-long-int argument explicitly package-private, as they're always for internal use only even if SQLite3Jni is eventually made public. (check-in: 5e387275f6 user: stephan tags: trunk) | |
| 14:48 | JNI: rename sqlite3_errmsg16() to sqlite3_errmsg(), as the 16 suffix is superfluous there. (check-in: df25b21689 user: stephan tags: trunk) | |
| 14:34 | Expose sqlite3_stmt_busy() to JNI. (check-in: 5733aa5fe3 user: stephan tags: trunk) | |
| 14:34 | Finish adding jsonb_ versions for all JSON routines that return JSON text. (check-in: 6daa7b6969 user: drh tags: jsonb) | |
| 13:13 | Correct an undefined-value deref in the JS bindings, triggered by passing invalid args and then tripping over an undefined value while trying to report that. Reported in forum post dd42df144651d779. (check-in: fd46325407 user: stephan tags: trunk) | |
| 10:59 | Make (almost) all SQLite3Jni.sqlite3_... members public but make the SQLite3Jni class package-private, which has the same foot-protection effect but makes it much simpler to patch SQLite3Jni to publicize the interface later. Remove some of the extraneous foot-shooting protection from indidivual functions, in lieu moving it to the still-pending higher-level interfaces. (check-in: 082b86683e user: stephan tags: trunk) | |
| 10:37 | Merge in and close jni-ptr-passing branch. The remaining pointer-passing adaptation can be done incrementally without affecting the interface. (check-in: 7927c42410 user: stephan tags: trunk) | |
| 10:31 | Make all native JNI sqlite3_...() bindings package-private as a foot-shooting protective measure (higher-level pre-native-call argument validation is largely pending). Move SQLTester.java and TesterFts5.java into the org.sqlite.jni package so that they can access the being-tested methods. (Leaf check-in: ec82f7251a user: stephan tags: jni-ptr-passing) | |
| 09:41 | More work towards the new pointer-passing mechanism in JNI, and code-adjacent cleanups. (check-in: 6c63987e89 user: stephan tags: jni-ptr-passing) | |
|
2023-09-29
| ||
| 22:37 | Update json_each() and json_tree() so that they work with JSONB inputs. (check-in: bb5e50ff56 user: drh tags: jsonb) | |
| 19:47 | The u.zJContent field of JsonNode for a string or label should NOT include the quotation mark delimiters. Ever. This is an inefficiency that really ought to be fixed on trunk, but that can wait until this branch lands. (check-in: 96f545f6f8 user: drh tags: jsonb) | |
| 16:37 | Additional refactoring and cleanup. (check-in: 45dd176087 user: drh tags: jsonb) | |
| 15:56 | Add test case to ensure the assert() removed by [f090af77] no longer fails. (check-in: 615ab71761 user: dan tags: trunk) | |
| 15:53 | Remove an incorrect assert(). (check-in: f090af775f user: drh tags: trunk) | |
| 15:18 | Bad edit (Closed-Leaf check-in: c794aeb374 user: drh tags: mistake) | |
| 12:45 | Improvements to comments and procedure names for clarity in the JSON implementation. (check-in: 9b620d813e user: drh tags: jsonb) | |
| 11:17 | Describe the JSONB encoding in a header comment to the json.c source file. (check-in: 1c0cba3461 user: drh tags: jsonb) | |
|
2023-09-28
| ||
| 20:34 | JNI: correct a NullPointerException triggered via SQLTester. (check-in: 0a873de76c user: stephan tags: jni-ptr-passing) | |
| 19:11 | Fix some minor memory issues so that all legacy tests now pass. (check-in: 1744bfc669 user: drh tags: jsonb) | |
| 18:23 | Allow the sqlite3_user_data() function to be invoked with a NULL argument or with an sqlite3_context pointer from a virtual table. It returns NULL in both cases. (check-in: 2f49687371 user: drh tags: jsonb) | |
| 17:41 | Merge trunk changes into the jsonb branch for the compiler warning fixes from two days ago. (check-in: cee113cc31 user: drh tags: jsonb) | |
| 17:27 | The json_extract() function now works on BLOBs without the need to translate into an array of JsonNode objects. This is much faster. (check-in: 5853065b7e user: drh tags: jsonb) | |
| 17:23 | Extract directly from BLOB is now complete and appears to work. (Closed-Leaf check-in: 3de58ec994 user: drh tags: jsonb-direct-extract) | |
| 17:07 | Miscellaneous bugs fixed. (check-in: 5c0815fa2e user: drh tags: jsonb-direct-extract) | |
| 15:56 | Improvements to json_extract() to better support JSONB. Still not 100% working. (check-in: 8c82576176 user: drh tags: jsonb-direct-extract) | |
| 15:00 | Clarify serialization API doc w.r.t. buffer validity and usage, instigated by forum post 8922e2ad2ad41205. No code changes. (check-in: b488b9fb71 user: larrybr tags: trunk) | |
| 11:19 | Adapted the JNI bindings for the sqlite3_value_...() and (pre)update hook APIs to the new pointer-passing mechanism. (check-in: 4182f0275d user: stephan tags: jni-ptr-passing) | |
| 10:50 | Convert the remaining macro-generated JNI bindings to the new pointer-passing mechanism. (check-in: 250fd6ae80 user: stephan tags: jni-ptr-passing) | |
| 10:27 | Convert the macro-generated JNI bindings which take a db pointer to the new pointer-passing mechanism. (check-in: 5f47fb77db user: stephan tags: jni-ptr-passing) | |
| 10:20 | Work toward getting json_extract() to operate directly on the BLOB, omitting the translation into a JsonNode array. (check-in: c1feba70f5 user: drh tags: jsonb-direct-extract) | |
|
2023-09-27
| ||
| 16:55 | Performance tests for JSONB added. (check-in: 7c1be8e361 user: drh tags: jsonb) | |
| 14:41 | Adapted JNI sqlite3_blob_...() and sqlite3_close...() to the new pointer-passing mechanism. (check-in: 0b22c8ef93 user: stephan tags: jni-ptr-passing) | |
| 11:01 | Adapt JNI sqlite3_bind_...() bindings to the new pointer-passing method and correct the mapping of sqlite3_bind_zeroblob64() to use zeroblob64() instead of zeroblob(). Related internal API renaming. (check-in: 980d559fff user: stephan tags: jni-ptr-passing) | |
| 10:29 | Add missing license headers to JNI annotation classes and extend the definition of @NotNull to include 0L as the equivalent of null to account for the current rework of how pointers are passed from Java to C. (check-in: bccdfeb9ef user: stephan tags: jni-ptr-passing) | |
| 09:58 | Rework the JNI sqlite3_backup APIs to the new pointer-passing approach. (check-in: 48aeb1e2cd user: stephan tags: jni-ptr-passing) | |
|
2023-09-26
| ||
| 21:37 | Start reworking JNI methods such that they pass void pointers from Java to C instead of passing their strongly-typed wrappers, as that is reportedly significantly faster than passing the wrapper objects to C and extracting the pointers there. There are still many, many functions left to rework for this. (check-in: 66c814dd47 user: stephan tags: jni-ptr-passing) | |
| 21:22 | Fix harmless compiler warnings in the testfixture testing utility. (check-in: 5a39a02d2d user: drh tags: trunk) | |
| 19:49 | JNI: implement AutoCloseable for the sqlite3 and sqlite3_stmt classes, and adjust a few tests to use it. Override Object.finalize() for sqlite3 class but not sqlite3_stmt (where it triggers a JVM crash for as-yet-unknown reasons). (check-in: b633d8bbdb user: stephan tags: trunk) | |
| 19:46 | Merge partial-index constant value fixes from trunk into the jsonb branch. (check-in: 700bdbd738 user: drh tags: jsonb) | |
| 19:38 | Fix yet another assert() in the partial-index constant value optimization. (check-in: f459d0806c user: drh tags: trunk) | |
| 19:30 | Add in many jsonb_xxxx() interfaces. Still uses the internal JsonNode representation for transformations and search, but it does at least conform to the desired API design. Largely untested. (check-in: e6045b4e1b user: drh tags: jsonb) | |
| 19:26 | Remove a NEVER() from a condition in the partial-index constant value optimization that can sometimes be true. (check-in: 63aea8c3e0 user: dan tags: trunk) | |
| 15:13 | Merge all the latest trunk enhancements into jsonb branch. (check-in: ac242c4d47 user: drh tags: jsonb) | |
| 14:57 | Remove unreachable code from the partial-index constant value optimization ([8d4160910d651246]). (check-in: 7ad38254c3 user: drh tags: trunk) | |
| 09:46 | Remove some outdated JNI docs. (check-in: 2ca5cbbb2a user: stephan tags: trunk) | |
| 07:43 | Minor JNI doc updates. No code changes. (check-in: 63687cc659 user: stephan tags: trunk) | |
|
2023-09-25
| ||
| 17:46 | In partial index scans, if the WHERE clause implies a constant value for a table column, replace occurences of that table column with the constant. This increases the likelihood of the partial index being a covering index. (check-in: 8d4160910d user: dan tags: trunk) | |
| 17:21 | Another very minor tweak to code on this branch to save cycles. (Closed-Leaf check-in: 2c805dc681 user: dan tags: partial-index-terms) | |
| 17:14 | When parsing JSON text into the BLOB format, only use node type JSONB_TEXTJ for an unquoted object label if the object label contains escape sequences. (check-in: a82ebbac3c user: drh tags: jsonb) | |
| 15:25 | Change the order of an if..else... in new code to make it slightly faster. (check-in: f80dc64483 user: dan tags: partial-index-terms) | |
| 14:20 | Enable -Wall for the compiler on --enable-debug builds. (check-in: 63a7b52139 user: drh tags: trunk) | |
| 13:23 | As a temporary measure, try to translate the BLOB JSON format into the legacy node format for processing. (check-in: 14f2e95a9e user: drh tags: jsonb) | |
| 11:12 | Fix a bad interaction between LEFT JOIN, bloom filters and partial indexes. (check-in: 5775f92b31 user: dan tags: partial-index-terms) | |
| 00:39 | Cause sqlite3_exper_new() to replicate UDFs and custom collations early enough to appear in virtual column expressions during schema copy. forum post e030aa4b3a (check-in: 8fc2c45558 user: larrybr tags: expert-enhancement) | |
|
2023-09-24
| ||
| 22:51 | Make expert changes acceptable to C89. (check-in: a4f03c22ec user: larrybr tags: expert-enhancement) | |
| 19:47 | Merge expert changes to accept UDFs and custom collations. (check-in: 8ead1b5ed6 user: larrybr tags: expert-enhancement) | |
| 19:38 | Add minimal exercise of expert acceptance of UDFs and custom collations. (Closed-Leaf check-in: 0f6bbb79cb user: larrybr tags: expert-udfs) | |
| 19:28 | Sync w/trunk prior to merge back. (check-in: 2d290854cd user: larrybr tags: expert-udfs) | |
| 19:13 | Resolve the JNI FTS5 test5() failure and remove some nearby dead code. (check-in: 5655c51f10 user: stephan tags: trunk) | |
| 19:00 | Give expert ability to deal with custom collations. (check-in: ac1dc1b6de user: larrybr tags: expert-udfs) | |
|
2023-09-23
| ||
| 21:31 | Add extra tests for changes on this branch. (check-in: cb45f5b070 user: dan tags: partial-index-terms) | |
| 19:25 | Avoid an error when parsing a schema that contains indexes with WHERE clauses containing unknown collation sequences. (check-in: d5dd39e37a user: dan tags: partial-index-terms) | |
| 18:52 | Fix a failing assert() caused by changes on this branch. (check-in: d0e21f20bd user: dan tags: partial-index-terms) | |
| 18:49 | Fix a harmless compiler warning. (check-in: 7c4210253b user: drh tags: partial-index-terms) | |
| 15:34 | Add extra tests for the fts5 xPhraseQuery API. (check-in: b5edea1631 user: dan tags: trunk) | |
| 06:50 | Resolve the JNI FTS5 test5() crash, caused by two unrelated typos in JNI callback signature strings. That test now fails with an expected-vs-got mismatch but no longer dies in the native code. (check-in: 0233f310bf user: stephan tags: trunk) | |
| 06:37 | Remove an invalid optimization from JNI code and add a missing check check for Java-side exception. (check-in: b8151f8797 user: stephan tags: trunk) | |
|
2023-09-22
| ||
| 20:21 | In partial index scans, if the WHERE clause implies a constant value for a table column, replace occurences of that table column with the constant. This increases the likelihood of the partial index being a covering index. (check-in: 66ed7abdfa user: dan tags: partial-index-terms) | |
| 16:20 | Fix minor parse-to-BLOB bugs. (check-in: 8b53b2e660 user: drh tags: jsonb) | |
| 14:33 | Add the ability to render a binary BLOB back into valid canonical JSON. (check-in: 0b70cb77a4 user: drh tags: jsonb) | |
| 14:20 | Give expert ability to deal with UDFs. (check-in: 3406b05b4f user: larrybr tags: expert-udfs) | |
| 12:16 | Begin adding code to render binary JSON back into text. Very incomplete. This is an incremental check-in. (check-in: b817dd865e user: drh tags: jsonb) | |
| 11:20 | Improvements to the JSON binary BLOB format design. (check-in: 2c89ae5d02 user: drh tags: jsonb) | |
|
2023-09-21
| ||
| 18:16 | Reorganize the code to put the new JSONB routines together, for easier editing. (check-in: dc23e783d4 user: drh tags: jsonb) | |
| 17:51 | Initial development code for an experimental binary BLOB encoding for JSON. (check-in: 8131b3c272 user: drh tags: jsonb) | |
|
2023-09-18
| ||
| 20:42 | Add extra tests for java Fts5ExtensionApi API. (check-in: f9d62b853c user: dan tags: trunk) | |
| 18:12 | Extra tests for java Fts5ExtensionApi interface. (check-in: c923893f36 user: dan tags: trunk) | |
|
2023-09-17
| ||
| 16:36 | Remove a NEVER() in btree.c that could actually be reached, with the approriate database corruption. (check-in: d1fd00e087 user: drh tags: trunk) | |
|
2023-09-16
| ||
| 18:18 | Fix resolution of "rowid" and similar identifiers in queries that use nested joins. (check-in: 37ec43d92b user: dan tags: trunk) | |
| 17:11 | Enable "OR IGNORE" support via SQLITE_VTAB_CONSTRAINT_SUPPORT for internal-content (not contentless or external-content) fts5 tables. (check-in: c362bde4f4 user: dan tags: trunk) | |
| 16:39 | Add a NEVER() to an unreachable branch. (Closed-Leaf check-in: 6b6eb38979 user: drh tags: nested-from-rowid-expansion) | |
| 16:23 | Fix minor code indentation inconsistencies. No function changes. (check-in: 05107a0ae1 user: drh tags: nested-from-rowid-expansion) | |
| 16:12 | Fix a harmless compiler warning. (check-in: 9e9ff4ca3a user: drh tags: nested-from-rowid-expansion) | |
| 14:42 | Further tests and assert() statements for the change on this branch. (check-in: 1c202d540a user: dan tags: nested-from-rowid-expansion) | |
|
2023-09-15
| ||
| 20:57 | Fix resolution of unqualified "rowid" identifiers in queries with nested joins. (check-in: bbcbd3d537 user: dan tags: nested-from-rowid-expansion) | |
| 20:28 | Simplifications and performance optimizations for the RTree extension. (check-in: 04a333f5fa user: drh tags: trunk) | |
| 19:51 | Drop support for the view-scan optimization (check-in [609fbb94b8f01d67]) as it was causing multiple performance regressions. In its place, reduce the estimated row count for DISTINCT subsqueries by a factor of 8. (check-in: f911f1c497 user: drh tags: trunk) | |
| 19:27 | Minor simplification to the DISTINCT output row count change. (Closed-Leaf check-in: 0738386d7c user: drh tags: rethink-viewscan) | |
| 19:00 | Do not reduce subquery output row count estimates due to DISTINCT until after the decision of whether or not to use an index for ORDER BY has been made. (check-in: 27390051e8 user: drh tags: rethink-viewscan) | |
| 18:36 | Allow expressions like "<tbl>.rowid" to refer to implicit rowid columns of tables in nested FROM clauses. (check-in: 59a1bbc69f user: dan tags: nested-from-rowid-expansion) | |
| 16:15 | Experimental: Assume that a DISTINCT clause on a subquery reduces the number of rows returned by that subquery by a factor of 8. (check-in: 5a940e47d5 user: drh tags: rethink-viewscan) | |
| 14:06 | The view-scan optimization was added to enhance the performance of one specific query, but it causes performance regressions on a host of others. Disable it (at least temporarily) in order to try to find an alternative way of fixing the one specific query that it was created to fix - an alternative way that does not cause performance problems for other unrelated queries. (check-in: d9625a9eaf user: drh tags: rethink-viewscan) | |
| 10:24 | Do not try to convert a double into an unsigned 64-bit integer, as that does not work on all platforms. A double can only be converted into a signed 64-bit integer. This is a fix for the problem reported in forum post 9f6db917e1c05d40. (check-in: ce33904641 user: drh tags: trunk) | |
|
2023-09-14
| ||
| 20:56 | Tests for java versions of Fts5ExtensionApi.xSetAuxdata() and xGetAuxdata(). (check-in: 858fa236f8 user: dan tags: trunk) | |
| 20:02 | JNI: move XTokenizeCallback interface out of the Fts5 object - that level of indirection is a holdover from when those classes were in the core package. (check-in: 385ec08570 user: stephan tags: trunk) | |
| 20:01 | Add a few more tests for Fts5ExtensionApi methods. (check-in: 4ce2a7e8ed user: dan tags: trunk) | |
| 17:42 | Add a test for the java version of Fts5ExtensionApi.xRowid(). (check-in: 227facf879 user: dan tags: trunk) | |
| 16:45 | According to forum post 9f6db917e1, older MSVC compilers are unable to convert a double directly into an unsigned long long int, but must first go through a signed long long int. Work around this by restricting the range of doubles that are converted into long long integers so that only the lower 63 bits are used. (Closed-Leaf check-in: 0ab05871ba user: drh tags: legacy-msvc-workaround) | |
| 16:02 | Document the use of OPFLAG_ISNOOP as the P2 argument on OP_Delete. No functional code changes. (check-in: d88f41b2cf user: drh tags: trunk) | |
| 14:05 | Avoid a segfault in test program showdb.c that could occur when analyzing a corrupt db. (check-in: 6bf3e90687 user: dan tags: trunk) | |
| 13:10 | Improve the sqlite3IntFloatCompare() routine so that it is testable. (check-in: bb221381fa user: drh tags: trunk) | |
| 10:46 | Do not set the global bUseLongDouble flag based purely on sizeof(long double) being more than 8. That is a necessary but not sufficient condition to use the long double routines. Instead, do a run-time test to verify that long double really does provide extra precision. (check-in: aa999d490b user: drh tags: trunk) | |
| 01:46 | Reduce the number of calls to sqlite3_mprintf() made by RTree. (Closed-Leaf check-in: f158b7d491 user: drh tags: rtree-performance) | |
|
2023-09-13
| ||
| 21:32 | JNI: enable the fts5-customization bits by default but elide them from the docs until it's clearer where they're headed. Unrelated minor doc tweaks. (check-in: 21adb1aef2 user: stephan tags: trunk) | |
| 20:35 | Improved comments on the hasHighPrecisionDouble() routine. No changes to the underlying code. (Closed-Leaf check-in: 810c635ce0 user: drh tags: runtime-longdouble-test) | |
| 20:06 | Determine at start time whether or not the underlying hardware supports high-precision long double computations. (check-in: 9a854b9196 user: drh tags: runtime-longdouble-test) | |
| 17:30 | Omit the Reinsert algorithm from RTree. This causes most benchmarks to run faster, at the expense of having a slightly less dense and hence larger index (example: 33 entries/node versus 34 entries/node). (check-in: b3049a1d3d user: drh tags: rtree-performance) | |
| 17:16 | Doc corrections for the previous checkin. (check-in: 9ea0a9f39d user: stephan tags: trunk) | |
| 17:11 | Add JNI sqlite3_prepare_multi(), based on feedback. (check-in: fa1c153472 user: stephan tags: trunk) | |
| 14:07 | Performance optimization to cellContains() in RTREE. (check-in: 43cde22bf3 user: drh tags: rtree-performance) | |
| 13:12 | In the ChooseLeaf algorithm of RTREE, do an initial pass through the cells of a node looking for solutions that involve no cell enlargement. Only look for the minimum cell enlargement if the enlargement is non-zero for all cells. This results in a performance improvement by reducing the number of calls to cellUnion(). (check-in: 59f0e239d1 user: drh tags: rtree-performance) | |
| 12:06 | Reduce the number of calls to cellArea() in the ChooseLeaf() algorithm of rtree. (check-in: c633fe6be0 user: drh tags: rtree-performance) | |
| 11:36 | Remove unused variable from the ChooseLeaf algorithm in r-tree. (check-in: fb2e4a8067 user: drh tags: rtree-performance) | |
| 11:24 | Replace an if() condition in fts5 that is always true with an assert(). (check-in: 2170312c8d user: dan tags: trunk) | |
|
2023-09-12
| ||
| 23:21 | CLI .import to accept EOF in lieu of record terminator on last field of CSV (with multiple field records), per RFC 4180. forum post 5b21c25bdfa (check-in: 6f7842f577 user: larrybr tags: trunk) | |
| 18:36 | Fix a use-after-free error in fts5 that could occur when querying the "rank" column immediately after another connection changes its definition. forum post a2dd636330. (check-in: cb54c2da52 user: dan tags: trunk) | |
| 17:49 | Clarify some metrics output in Tester1.java. (check-in: 4ae7199a82 user: stephan tags: trunk) | |
| 17:06 | Re-add the fts5 decls to sqlite3-jni.h, removed in a rebuild without fts5 enabled. Need a better solution for this problem. (check-in: 6f269790a0 user: stephan tags: trunk) | |
| 17:03 | Rename JNI sqlite3_errmsg() to sqlite3_errmsg16() for overall constency with the text()/text16() family of functions. (check-in: c4a8d8a571 user: stephan tags: trunk) | |
| 16:33 | JNI readme fix. (check-in: 7dde000efc user: stephan tags: trunk) | |
| 14:36 | 64-bit builds on Windows default to using UTF-8 output (as if the -utf8 command-line option had been specified.) 32-bit builds continue to use Windows code pages. There is also a new -no-utf8 command-line option to force the use of legacy code pages. (check-in: d8c7560e88 user: drh tags: trunk) | |
| 14:09 | Show the "(utf8)" tag on the CLI banner in Windows if in UTF8 mode. (Closed-Leaf check-in: 822699a4d9 user: drh tags: cli-utf8) | |
|
2023-09-11
| ||
| 20:09 | Add the -no-utf8 option to the Windows CLI to cause UTF-8 mode to be omitted. (check-in: 4cb799c690 user: drh tags: cli-utf8) | |
| 20:02 | Make the -utf8 option the default behavior in the CLI on Windows for 64-bit builds. (check-in: 8b3c306def user: drh tags: cli-utf8) | |
| 15:27 | Refuse to build amalgamation-tarball and snapshot-tarball if the TEA version number disagrees with ./VERSION. (check-in: 3308fdda4b user: drh tags: trunk) | |
| 15:20 | Merge in JNI's significant divergence since it adopted sqlite3_client_data(). (check-in: e8e07dbbea user: stephan tags: trunk) | |
| 14:55 | Add support for the sqlite3_get_clientdata() and sqlite3_set_clientdata() interfaces, to better support JNI. (check-in: 9806c0dd28 user: drh tags: trunk) | |
|
2023-09-10
| ||
| 10:56 | Roll back [84e38341aeab] because a direct pointer comparison is ill-advised when the client-data string is dynamically allocated. (Closed-Leaf check-in: 7b884832b7 user: stephan tags: db-client-data) | |
|
2023-09-09
| ||
| 17:53 | Remove out-of-date comment regarding use of Parse.pConstExpr. (check-in: 71548f72ad user: dan tags: trunk) | |
| 11:20 | In the JNI build, emit a reminder to not check in the javac-generated sqlite3-jni.h when FTS5 is disabled because changes in that feature flag result in unnecessary and large diffs in checked-in generated code. (Closed-Leaf check-in: caceb52fb5 user: stephan tags: jni-client-data) | |
| 07:52 | Disable FTS5 in the JNI build by default until it can be thoroughly tested. This is mainly so that the public-facing javadoc does not include it. (check-in: 6f25f02b70 user: stephan tags: jni-client-data) | |
|
2023-09-08
| ||
| 19:18 | Add extra tests for [4b60a1c3]. (check-in: 6357491bd1 user: dan tags: trunk) | |
| 18:34 | Fix a problem with fts5 secure-delete mode causing fts5 to corrupt its records. (check-in: 4b60a1c358 user: dan tags: trunk) | |
|
2023-09-07
| ||
| 17:54 | Add -DSQLITE_OMIT_LOOKASIDE=1 to the "Sanitize" configuration in testrunner_data.tcl. (check-in: a917ebf17b user: dan tags: trunk) | |
| 16:53 | Enhance the ./configure script and its associated Makefile.in so that the --with-linenoise=DIR argument cause the linenoise command-line editing library located in directory DIR to be linked with the sqlite3 CLI. (check-in: 6c7822b554 user: drh tags: trunk) | |
| 13:53 | Fix a buffer overread in the sessions extension that could occur when processing a corrupt changeset. (check-in: 0e4e7a05c4 user: dan tags: trunk) | |
| 13:48 | Fix a harmless compiler warning in the sqldiff.c utility. (check-in: e6390a6567 user: drh tags: trunk) | |
| 13:43 | Add the "tool-zip" makefile target with the intention of using it to build the "sqlite-tool-*.zip" deliverables. deliverables. (check-in: 06e4af492d user: drh tags: trunk) | |
| 02:13 | Fix a problem with the new xIntegrity method for virtual tables, and also fix a bad assert() in FTS3 that was found by the new xIntegrity method. (check-in: 52bbf44f2d user: drh tags: trunk) | |
|
2023-09-06
| ||
| 17:07 | Add documentation to sqlite3_get/set_clientdata() to make it clear that these are security-sensitive interfaces that should not be exposed to potential attackers. (check-in: 2837061d66 user: drh tags: db-client-data) | |
| 16:51 | Add the xIntegrity method to the sqlite3_module object, thus enabling PRAGMA integrity_check to operate on virtual tables. Make use of this new method in the FTS3/4, FTS5, and RTREE virtual tables. (check-in: 2f08e7d233 user: drh tags: trunk) | |
| 16:22 | Fix unreachable branches. (Closed-Leaf check-in: f00fc16394 user: drh tags: vtab-integrity-check) | |
| 14:00 | Change the xIntegrity virtual table method signature so that it returns an integer error code and writes the error message into a parameter. (check-in: f1d4024a8c user: drh tags: vtab-integrity-check) | |
| 12:52 | Add the xIntegrity method to the sqlite3_module object. Implement this method in RTREE, FTS3/4, and FTS5 so that "PRAGMA integrity_check" also verifies the correctness of shadow tables associated with those virtual tables. (check-in: 17bede8cde user: drh tags: vtab-integrity-check) | |
| 07:39 | Move Java-side FTS5 bits into the fts5 subpackage to (A) make it easy to optionally bundle it (or not) and (B) set a precedent for puting extension APIs in their own package. (check-in: 4c773e1f33 user: stephan tags: jni-client-data) | |
| 06:54 | Java FTS5 API renaming, for consistency. (check-in: 5e4cc9f386 user: stephan tags: jni-client-data) | |
|
2023-09-05
| ||
| 15:43 | Add debugging routines to check each page for corruption after it it is manipulated by the fts5 secure-delete code, and to log said page via sqlite3_log() if it is found to be corrupt. (Leaf check-in: da4b7385a0 user: dan tags: fts5-secure-delete-debug) | |
| 15:03 | Fix a few SQLITE_MISUSE returns so that they call sqlite3MisuseError(). (check-in: 93f74490fa user: drh tags: trunk) | |
|
2023-09-04
| ||
| 16:48 | Add tests for, and source code comments to, fts5. No changes to code. (check-in: b12afff4ef user: dan tags: trunk) | |
| 12:50 | Do not make assumptions about the byteorder of PowerPC processors. (check-in: 4a2498fed4 user: drh tags: trunk) | |
| 06:15 | In JNI routines which set an OutputPointer.value, always do so, even on error, for consistency. (check-in: d0df62f0af user: stephan tags: jni-client-data) | |
| 05:58 | Remove several unnececessary functions. (check-in: 84433c72b0 user: stephan tags: jni-client-data) | |
| 05:34 | Move an internal utility class out of the public Java API. (check-in: 8e1ae3197a user: stephan tags: jni-client-data) | |
| 04:23 | Expose sqlite3_bind_parameter_name() to JNI. Extend the definition of null for the @NotNull annotation, to consider closed/finalized Java-side handles wrapping C-side resources as null for its purposes. (check-in: fc34e2bfa4 user: stephan tags: jni-client-data) | |
|
2023-09-03
| ||
| 15:01 | In mksqlite3c.tcl, pass EXTRA_SRC files through verbatim instead of applying the post-processing needed for sqlite's own source files. (check-in: 44f3d7d054 user: stephan tags: extra-src) | |
| 14:41 | Add the missing sqlite3_blob_read() to [9a9945c405cf]. Elaborate on the definition of the @NotNull annotation. (check-in: 85952b4a52 user: stephan tags: jni-client-data) | |
| 14:13 | Expose the sqlite3_blob_...() APIs to JNI. (check-in: 9a9945c405 user: stephan tags: jni-client-data) | |
| 12:46 | Expose sqlite3_system_errno() to JNI. (check-in: bac54da29c user: stephan tags: jni-client-data) | |
| 12:32 | Expose sqlite3_stmt_status() to JNI. (check-in: d266acc23e user: stephan tags: jni-client-data) | |
| 12:17 | Expose sqlite3_randomness() to JNI. (check-in: de96922421 user: stephan tags: jni-client-data) | |
| 11:58 | Expose sqlite3_get/set_auxdata() to JNI. (check-in: 0de3271717 user: stephan tags: jni-client-data) | |
| 11:16 | Expose sqlite3_get_autocommit() to JNI. (check-in: 67391c6588 user: stephan tags: jni-client-data) | |
| 11:08 | Remove some unnecessary code. (check-in: c7f9bbbbf0 user: stephan tags: jni-client-data) | |
| 10:36 | Add a couple more sqlite3_backup tests. (check-in: 5c2cf89d2c user: stephan tags: jni-client-data) | |
| 10:23 | Export the sqlite3_backup_...() APIs to JNI. (check-in: 865a3df5d5 user: stephan tags: jni-client-data) | |
| 09:28 | Export the sqlite3_keyword_...() family of functions to JNI. (check-in: bd554db391 user: stephan tags: jni-client-data) | |
|
2023-09-02
| ||
| 21:55 | Also add support for EXTRA_SRC in the Makefile for MSVC. (check-in: bfc18ef432 user: mistachkin tags: extra-src) | |
| 19:35 | Performance optimization to the OP_MakeRecord opcode. (check-in: 2aef9af3dd user: drh tags: trunk) | |
| 14:36 | Add sqlite3_config(SQLITE_CONFIG_LOG) support to Java and correct clearing of SQLITE_CONFIG_SQLLOG. Correct missing names in propagated UDF exception messages. (check-in: 652e2e8210 user: stephan tags: jni-client-data) | |
| 12:53 | Expose sqlite3_complete() to JNI. Slightly widen the definition of "canonical" for the purposes of the @Canonical annotation. Add a few new tests. (check-in: a59fe0cd95 user: stephan tags: jni-client-data) | |
| 11:26 | Duplicate code consolidation. (check-in: a1872ae959 user: stephan tags: jni-client-data) | |
| 10:18 | Remove a superfluous level of indirection in the JNI internals. (check-in: 8dca6f7660 user: stephan tags: jni-client-data) | |
| 08:51 | Further JNI cleanups. (check-in: 30e38173c3 user: stephan tags: jni-client-data) | |
| 08:04 | Optimize sqlite3_get/set_clientdata() for the presumably common case of a static string pointer. (check-in: 84e38341ae user: stephan tags: db-client-data) | |
| 05:37 | Add EXTRA_SRC build var. If set, it is treated like a list of files, each of which gets appended verbatim to sqlite3.c. The intent is to enable easily extending the amalgamation. Requested in/around forum post 3fcc655f0ac0efe8. (check-in: 934b843398 user: stephan tags: extra-src) | |
|
2023-09-01
| ||
| 17:51 | Add a timer to the JS SQLTester app to warn if it appears that loading the module has failed, which is commonly caused by the test scripts not being compiled. (check-in: f9c1f9cad1 user: stephan tags: jni-client-data) | |
| 16:28 | Correct a Tester1.java test which inadvertently created a spurious db file in the current dir. Unrelated minor cleanups. (check-in: 016bbdadbf user: stephan tags: jni-client-data) | |
| 14:20 | Make the JNI-internal metrics opt-in rather than opt-out so client builds won't have them by default. Unrelated doc tweaks. (check-in: aa72d25a22 user: stephan tags: jni-client-data) | |
| 13:27 | Make JNI interfaces of sqlite3_column/value_text() match the C ones better. Internal JNI cleanups and simplifications. (check-in: eb24f97253 user: stephan tags: jni-client-data) | |
| 11:10 | Second half of [1c532e80]. (check-in: 8ca1d815a5 user: stephan tags: trunk) | |
| 11:05 | In the OPFS VFS' importDb() methods, overwrite the header bytes 18 and 19 with 1 instead of 0. Both seem to work, but 1 is correct. (check-in: 1c532e807b user: stephan tags: trunk) | |
| 10:37 | Remove some newly-dead code. (check-in: dc0fa76b39 user: stephan tags: jni-client-data) | |
| 10:32 | Expose sqlite3_limit() to JNI and remove the all SQLITE_ macros from the Java interface which are not exposed via sqlite3.h (SQLITE_MAX_... and SQLITE_THREADSAFE_...). (check-in: 5fe5b0a585 user: stephan tags: jni-client-data) | |
| 09:43 | JNI build improvements. Rename a Java class. Get the jar target working again. (check-in: d086b7844c user: stephan tags: jni-client-data) | |
| 06:50 | Expose sqlite3_stmt_explain(), sqlite3_stmt_isexplain(), and sqlite3_stmt_readonly() to JNI. Remove a mutex lock made superfluous by sqlite3_client_data(). (check-in: 208b786afe user: stephan tags: jni-client-data) | |
|
2023-08-31
| ||
| 19:35 | Export sqlite3_txn_state() to JNI. (check-in: d732f71d0a user: stephan tags: jni-client-data) | |
| 18:34 | Minor JNI cleanups. (check-in: 2e2bb841ef user: stephan tags: jni-client-data) | |
| 18:00 | Do not disable unused columns in a UNION ALL sub-query if any component of the sub-query is DISTINCT. Problem introduced by [7c2d3406000dc8ac] and reported by forum post aeae62275ebbf584. (check-in: c84d5602ac user: dan tags: trunk) | |
| 15:24 | Add convenience overloads of JNI sqlite3_table_column_metadata() to simplify usage. (check-in: faf4e6d398 user: stephan tags: jni-client-data) | |
| 14:57 | Export sqlite3_(db_)free_memory() and sqlite3_table_column_metadata() to JNI. Further internals renaming for consistency and legibility. (check-in: 7c86aa3400 user: stephan tags: jni-client-data) | |
|
2023-08-30
| ||
| 18:51 | Use mutexes to make sqlite3_set_clientdata() and sqlite3_get_clientdata() threadsafe. (check-in: 443ea20ddb user: drh tags: db-client-data) | |
| 18:45 | Replace JNI's per-db-instance state tracking with the new sqlite3_set/get_clientdata(). (check-in: e7c11d34ee user: stephan tags: db-client-data) | |
| 18:19 | Fix a bug in json_array_length() introduced in version 3.43.0 by check-in [df099ad713011b67]. If the JSON input comes from json_remove(), the removed array entries are still counted as part of the array length. Bug report in forum post 0560d5e482. (check-in: 69a635958a user: drh tags: trunk) | |
| 17:41 | Remove another unreachable branch in the sqlite3_set_clientdata() logic. (check-in: 57e31e6b10 user: drh tags: db-client-data) | |
| 17:14 | Remove an unreachable branch, and improve documentation of sqlite3_set_clientdata(). (check-in: 565c68adee user: drh tags: db-client-data) | |
| 16:03 | Fix the AVG() and TOTAL() functions (after the SUM() fix of [77d3dcd283595c52]) so that they work with infinitites. Fixes a bug introduced by check-in. [c63e26e705f5e967]. Bug reported by forum post 8960fb40cc. (check-in: 6df6f17ccb user: drh tags: trunk) | |
| 15:51 | Further tweaking in both SQLTesters. (check-in: 46b0eb98e7 user: stephan tags: trunk) | |
| 15:42 | Fix to the sqlite3_get_clientdata() interface. (check-in: 937cd1762b user: drh tags: db-client-data) | |
| 15:20 | New experimental API for attaching client data to a database connection. (check-in: d542837fdb user: drh tags: db-client-data) | |
| 14:20 | When a JS SQLTester script throws, report the exception details back to the UI regardless of whether it's fatal. (check-in: 273d3b05f6 user: stephan tags: trunk) | |
| 13:07 | Add a JS implementation of Java's SQLTester. (check-in: b530792a51 user: stephan tags: trunk) | |
| 11:54 | Add a UI, of sorts, to the JS SQLTester. (Closed-Leaf check-in: 249e82b991 user: stephan tags: js-tester) | |
| 00:22 | Add a mechanism with which to import external SQLTester scripts into the JS testing tool. (check-in: bb08ba020c user: stephan tags: js-tester) | |
|
2023-08-29
| ||
| 21:30 | Add directives support to JS SQLTester comparable to the Java impl. This brings the two to feature parity. (check-in: 7cef4a8300 user: stephan tags: js-tester) | |
| 20:44 | More fleshing out of JS SQLTester. (check-in: 8c503dfb9f user: stephan tags: js-tester) | |
| 20:01 | JS SQLTestRunner can now run the Java impl's core-most sanity tests, missing only support for directives. (check-in: 5e79836937 user: stephan tags: js-tester) | |
| 18:28 | New conversion letters added to strftime(): %e, %k, %I, %l, %R, %P, %p, %T, %u. (check-in: 058722b2d0 user: drh tags: trunk) | |
| 15:39 | Get the JS SQLTester command handlers in place sans those which have to run SQL. (check-in: d21b121796 user: stephan tags: js-tester) | |
| 15:38 | Change the version number to 3.44.0 to begin the next development cycle. (Should have done this a few check-ins ago.) (check-in: 253fe4a45d user: drh tags: trunk) | |
| 15:24 | Add support for the CONCAT() and CONCAT_WS() SQL functions, modeled after the PostgreSQL behavior. (check-in: 0b434ca7aa user: drh tags: trunk) | |
| 13:28 | Get the basic parsing pieces and command dispatching in place in the JS SQLTester. (check-in: 8fcc2a553c user: stephan tags: js-tester) | |
| 11:22 | Init bits of a port of Java's SQLTester to JS. Far from complete. (check-in: 60eec5ceda user: stephan tags: js-tester) | |
| 10:50 | Change a variable from "int" to "i64" to make it easier to prove that it cannot overflow. (check-in: 00a8b3a263 user: dan tags: trunk) | |
| 00:10 | Remove some dead code. Add a skeleton SQLTester script for fts5. (check-in: 6c83e31fa9 user: stephan tags: trunk) | |
|
2023-08-28
| ||
| 23:18 | Factor out a superfluous struct member. (check-in: 76d3911c37 user: stephan tags: trunk) | |
| 22:52 | Further minor internal JNI simplifications. (check-in: 1808d12ee0 user: stephan tags: trunk) | |
| 21:27 | Improve threadability of the JNI collation-related bindings and add infrastructure for similar cases. (check-in: f02dad66b9 user: stephan tags: trunk) | |
| 20:21 | Correct JNI mapping of collations to be 1-db-to-many-collations. (check-in: b927b0f5a6 user: stephan tags: trunk) | |
| 20:14 | Updates to testrunner.tcl so that it runs fuzztest using multiple jobs. (check-in: ceeabe9f8b user: dan tags: trunk) | |
| 16:22 | Remove a pair of what are arguably unnecessary mutex locks (and often hit). More JNI-internal cleanups. (check-in: ecf07a0144 user: stephan tags: trunk) | |
| 16:05 | Update tool/mkctimec.tcl to account for [fe7365254d343e]. (check-in: 349aac7e8d user: stephan tags: trunk) | |
| 15:58 | Add support for the -DSQLITE_EXTRA_AUTOEXT=name compile-time option. forum thread 00829394c74a670f. (check-in: fe7365254d user: drh tags: trunk) | |
| 14:59 | Duplicate code consolidation. (check-in: 71f239747c user: stephan tags: trunk) | |
| 13:18 | Move a metrics counter so that it can be used to indirectly witness the race condition fix from [f5274e00f17d58e0] by recording varying final values for that metric across consecutive multi-threaded test runs. (check-in: 54d2209d24 user: stephan tags: trunk) | |
| 13:06 | Resolve a JNI-side race condition. Removed a now-extraneous struct member. Internal API renaming for consistency. (check-in: f5274e00f1 user: stephan tags: trunk) | |
| 12:20 | Fix an issue with infinity handling by the SUM() function that goes back to the extended-precision SUM() enhancement of check-in [c63e26e705f5e967]. Problem reported by forum post 1c06ddcacc86032a. (check-in: 77d3dcd283 user: drh tags: trunk) | |
| 12:06 | Resolve a condition which could cause an is-interrupted db to call its progress callback. (check-in: a0d0f1aafc user: stephan tags: trunk) | |
| 11:10 | Further JNI cleanups and javadoc additions. (check-in: c393b1c9f5 user: stephan tags: trunk) | |
| 07:28 | Lots of javadoc-related tweaks. (check-in: cfe06f90e2 user: stephan tags: trunk) | |
| 05:48 | Correct a package renaming bug in the previous check-in and start applying the @Canonical annotation to functions to distinguish canonical API functions and Java-specific APIs. (check-in: 8a01600680 user: stephan tags: trunk) | |
| 05:39 | Move the JNI annotations into the annotation subpackage. (check-in: e4dedf90a9 user: stephan tags: trunk) | |
| 04:59 | Resolve a makefile bug which causes sqlite3-worker1-bundler-friendly.mjs to be built incorrectly. Reported in forum post a874e435cf4690c1. (check-in: 9d68c7ef10 user: stephan tags: trunk) | |