Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
314 check-ins for the month beginning 2023-10-01
Following month ↑|
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) | |
| 04:11 | 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. (check-in: 747b4e3a9e user: stephan tags: branch-3.43) | |
| 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
| ||
| 21:05 | Ensure that when an ephemeral cursor is reopened with a second invocation of to OP_OpenEphemeral, the sequence counter is reset and the cache marked as stale. Fix for [9cdc5c46]. (check-in: d4bfa8d21a user: drh tags: branch-3.28) | |
| 20:46 | Merge recent trunk enhancements into the jsonb branch. (check-in: f47a8d0a20 user: drh tags: jsonb) | |
| 20:17 | Increase the size of some variables associated with the PMA sorter in order to avoid any possibility of a signed integer overflow. (check-in: 72597cee00 user: drh tags: branch-3.43) | |
| 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:47 | Fix a JSON bug introduced 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. (check-in: 3161c2cdc9 user: drh tags: branch-3.43) | |
| 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:34 | Merge the version-3.43.2 changes into the begin-concurrent-3.43 branch. (Leaf check-in: f3fb30af03 user: drh tags: begin-concurrent-3.43) | |
| 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) | |
| 20:03 | Fix a problem with an fts5 secure-delete on a rowid/term pair that follows a legacy delete of the same pair. (Leaf check-in: f5913e7632 user: dan tags: branch-3.42) | |
| 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:34 | 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: 7dcd9cfedc user: drh tags: branch-3.43) | |
| 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:34 | Fix a bug in the mkautoconfamal.sh script so that the "snapshot-tarball" and "amalgamation-tarball" makefile targets work again when run from outside of the source tree. (check-in: 3a79cf25e3 user: drh tags: branch-3.43) | |
| 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) | |
| 13:55 | Merge the 3.43.2 release changed into the reuse-schema-3.43 branch. (Leaf check-in: 5fefa147ca user: drh tags: reuse-schema-3.43) | |
| 12:16 | Start adding tests for the second JNI layer. (check-in: 0177f4dfe8 user: stephan tags: trunk) | |
| 12:14 | Version 3.43.2 (check-in: 4310099cce user: drh tags: release, branch-3.43, version-3.43.2) | |
|
2023-10-09
| ||
| 22:50 | Use snprintf() in place of sprintf() in a debugging function in the CLI. (check-in: 88a118905b user: drh tags: branch-3.43) | |
| 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:59 | 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: dc8681c486 user: drh tags: branch-3.43) | |
| 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:12 | Change the TEA version number to 3.43.2 also. (check-in: 170ab8d102 user: drh tags: branch-3.43) | |
| 14:10 | Update the version number to 3.43.2. (check-in: 0bd1199bb3 user: drh tags: branch-3.43) | |
| 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:51 | Fix a potential UAF caused by JSON parser cache spill. (check-in: 5b09212ac0 user: drh tags: branch-3.43) | |
| 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:11 | 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. (check-in: 83846af5df user: drh tags: branch-3.43) | |
| 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:09 | Improved detection of corrupt databases in balance_nonroot(). dbsqlfuzz d1cf013c50a620b68c2a5bd240d29afd65e5f58e. (check-in: f4aa1bfc97 user: drh tags: branch-3.43) | |
| 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) | |