Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
1004 check-ins using file ext/misc/series.c version dde5ba69cb
|
2024-01-12
| ||
| 16:33 | Fix a usan complaint about signed integer overflow. (Leaf check-in: 16aa729774 user: drh tags: branch-3.43) | |
| 15:38 | Fix a signed integer overflow usan complaint in fts5. This is fixed on trunk by [a76a636b23], but that is a large commit that adds new features. (check-in: 4b2d02f260 user: dan tags: branch-3.43) | |
|
2023-12-15
| ||
| 21:39 | 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. (check-in: 122cd0bada user: drh tags: branch-3.43) | |
|
2023-11-10
| ||
| 13:13 | Fix a potential UAF caused by JSON parser cache spill. (Leaf check-in: ce3fc4fc23 user: drh tags: bedrock-3.43) | |
|
2023-10-28
| ||
| 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) | |
|
2023-10-19
| ||
| 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) | |
|
2023-10-17
| ||
| 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) | |
|
2023-10-14
| ||
| 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) | |
|
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) | |
| 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) | |
|
2023-10-10
| ||
| 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) | |
| 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: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) | |
| 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: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) | |
| 12:51 | Fix a potential UAF caused by JSON parser cache spill. (check-in: 5b09212ac0 user: drh tags: branch-3.43) | |
|
2023-10-07
| ||
| 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) | |
|
2023-10-06
| ||
| 19:01 | Add tests for the sqlite3changegroup_schema() API. (check-in: 5dab481c10 user: dan tags: session-alter) | |
| 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) | |
|
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:16 | 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: 1545f0f735 user: stephan tags: branch-3.43) | |
| 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:27 | 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. (check-in: 4ce5a03e74 user: drh tags: branch-3.43) | |
| 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) | |
| 23:11 | Fix a use-after-free error in fts5 that could occur when querying the "rank" column immediately after another connection changes its definition. (check-in: dfc42411e6 user: drh tags: branch-3.43) | |
| 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:35 | Remove a harmlessly unused variable from FTS5. (check-in: 958d62c777 user: drh tags: branch-3.43) | |
| 15:28 | Refuse to build amalgamation-tarball and snapshot-tarball if the TEA version number disagrees with ./VERSION. (check-in: ad5cc3758b user: drh tags: branch-3.43) | |
| 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) | |
| 15:04 | Fix the TEA version number to be 3.43.1 (check-in: e00f1fedc9 user: drh tags: branch-3.43) | |
| 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) | |
| 13:06 | Merge version 3.43.1 into the reuse-schema-3.43 subbranch. (check-in: d96586b51b user: drh tags: reuse-schema-3.43) | |
| 12:01 | Version 3.43.1 (check-in: 2d3a40c05c user: drh tags: release, branch-3.43, version-3.43.1) | |
|
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) | |
| 15:30 | Merge post-3.43.0 wal2 fixes into the bedrock-3.43 branch. (check-in: 48ecf390da user: drh tags: bedrock-3.43) | |
| 15:22 | Merge post-3.43.0 wal2 fixes into the wal2-3.43 sub-branch. (Leaf check-in: f82b1a0bde user: drh tags: wal2-3.43) | |
| 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
| ||
| 20:24 | Merge candidate patches for version 3.43.1 into the reuse-schema-3.43 branch. (check-in: c94be4600d user: drh tags: reuse-schema-3.43) | |
| 20:19 | Merge the latest candidate patches for 3.43.1 into the bedrock-3.43 branch. (check-in: 4cefd16e6d user: drh tags: bedrock-3.43) | |
| 20:14 | Merge the latest 3.43.1 candidate patches into the wal2-3.43 branch. (check-in: b4491c9fbb user: drh tags: wal2-3.43) | |
| 20:09 | Merge patches queued for version 3.43.1 into the begin-concurrent-3.43 branch. (check-in: c786798506 user: drh tags: begin-concurrent-3.43) | |
| 19:35 | Fix a problem with fts5 secure-delete mode causing fts5 to corrupt its records. (check-in: fb24ca17fa user: drh tags: branch-3.43) | |
| 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) | |
| 16:49 | Fix a sanitizer runtime error in wal2 code (that (1 << 31) cannot be represented as an int). (check-in: 79a920c036 user: dan tags: wal2) | |
| 16:07 | Fix an apparently harmless buffer-overrun that could occur on this branch when committing multi-file transactions in wal2 mode. (check-in: ffe043ba06 user: dan tags: bedrock) | |
| 16:05 | Fix an apparently harmless buffer-overrun that could occur on this branch when committing multi-file transactions in wal2 mode. (check-in: dde9fcbde1 user: dan tags: wal2) | |
|
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) | |
| 16:36 | 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. (Closed-Leaf check-in: 9c4e4928b1 user: drh tags: wrong-branch) | |
| 14:10 | Fix a bad assert() in FTS3. (check-in: 61d2074c69 user: drh tags: branch-3.43) | |
| 14:04 | Fix a buffer overread in the sessions extension that could occur when processing a corrupt changeset. (check-in: 6009c871a4 user: drh tags: branch-3.43) | |
| 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) | |
| 11:48 | Version number to 3.43.1. (check-in: fdfe4d60b3 user: drh tags: branch-3.43) | |
| 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
| ||
| 22:07 | Eliminate a redundant NK_DbAboutToClose notification. (Leaf check-in: eccffaa7ca user: larrybr tags: cli_extension) | |
| 22:00 | Issue NK_DbAboutToClose notifications for any shell DB about to be closed, whether presently visible in ShellExState or not. (check-in: 8e6e54e48c user: larrybr tags: cli_extension) | |
| 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:30 | In the OPFS VFS' importDb() methods, overwrite the header bytes 18 and 19 with 1 instead of 0. Correct a potentially leaked/unclosed SharedAccessHandle when importDb() throws. (check-in: 6795a6107b user: stephan tags: branch-3.43) | |
| 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:26 | Do not disable unused columns in a UNION ALL sub-query if any component of the sub-query is DISTINCT. (check-in: 0d50d27197 user: drh tags: branch-3.43) | |
| 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:38 | Fix the json_array_length() function so that it gives the correct result even when its JSON input comes from json_remove(). (check-in: d63d9ee3b7 user: drh tags: bedrock-3.43) | |
| 18:34 | Fix the json_array_length() routine so that it reports the correct answer even if its JSON input comes from the output of json_remove(). (check-in: 8b390d7ee0 user: drh tags: wal2-3.43) | |
| 18:27 | Fix a bug in json_array_length() introduced in version 3.43.0 If the JSON input comes from json_remove(), the removed array entries are still counted as part of the array length. (check-in: db7cb6cb73 user: drh tags: branch-3.43) | |
| 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:34 | Fix the AVG() and TOTAL() functions so that they work with infinities. (check-in: 9877c7c838 user: drh tags: bedrock-3.43) | |
| 16:24 | Fix the AVG() and TOTAL() functions so that they work with infinitites. (check-in: 988e5308b6 user: drh tags: wal2-3.43) | |
| 16:08 | Fix the AVG() and TOTAL() functions so that they work with infinitites. (check-in: 97e20716c7 user: drh tags: branch-3.43) | |
| 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:37 | Merge the latest branch-3.43 fixes into the bedrock branch. (check-in: 7e3e007583 user: drh tags: bedrock-3.43) | |
| 20:24 | Merge the branch-3.43 fixes into the wal2 branch. (check-in: 903e997457 user: drh tags: wal2-3.43) | |
| 20:19 | Fix a test case problem in wal2recover2.test. (check-in: 9e927eed2d user: drh tags: wal2) | |
| 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) | |
| 20:02 | Fix the "sdevtest" testrunner.tcl command so that it correctly enables asan on windows. (Closed-Leaf check-in: 6463192369 user: dan tags: testrunner) | |
| 18:15 | Fixes for testrunner.tcl on windows. (check-in: 26ae090889 user: dan tags: testrunner) | |
| 16:28 | Another fix for valgrind permutation. Remove the "copydir" table column - just add a [cp] or [copy] command to the test script where this functionality is required. (check-in: 448b9a575e user: dan tags: testrunner) | |
| 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:57 | 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: 692266abd1 user: drh tags: branch-3.43) | |
| 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:22 | Fix the valgrind permutation on this branch. (check-in: ccbf06760e user: dan tags: testrunner) | |
| 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) | |
| 05:06 | Resolve a makefile bug which causes sqlite3-worker1-bundler-friendly.mjs to be built incorrectly. Reported in forum post a874e435cf4690c1. (check-in: 289d2a0e64 user: stephan tags: branch-3.43) | |
| 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) | |
|
2023-08-27
| ||
| 15:15 | Reimplement JNI's sqlite3_value_text() as a native instead of a Java-side proxy. Unrelated minor simplifications. (check-in: 401dd6ee28 user: stephan tags: trunk) | |
| 14:47 | Generic cleanups in Tester1.java. (check-in: fbc1b6310b user: stephan tags: trunk) | |
| 13:43 | Remove JNI sqlite3_column_java_object(), as the protection rules of sqlite3_values makes it impossible to implement safely. Add JNI sqlite3_bind_java_object(). (check-in: 29bd4a23a4 user: stephan tags: trunk) | |
| 11:28 | Correct the signature mismatch between JNI sqlite3_column/value_text16() and add related tests. (check-in: 77f6e70f17 user: stephan tags: trunk) | |
| 10:40 | Make JNI sqlite3_trace_v2() thread-safe. Re-add a piece removed in [bae4d022aad9b] to work around a JVM crash which is unpredictably triggered by its substitute. Fix the THREADMODE=0 JNI build. Further internal API simplifications. (check-in: 3f9f7a9cb0 user: stephan tags: trunk) | |
| 09:12 | Factor out an unnecessary struct member. JNI sqlite3_shutdown() now frees up the various object-recycling bins. Doc touchups. (check-in: bae4d022aa user: stephan tags: trunk) | |
| 08:10 | Factor out a superfluous JNI class. Doc and code style cleanups. (check-in: 0f37f27148 user: stephan tags: trunk) | |
| 07:26 | JNI code reorgs and simplify the failing-alloc interface a bit. (check-in: deed5797de user: stephan tags: trunk) | |
|
2023-08-26
| ||
| 22:34 | Apply the JNI OOM checks to memory returned by JDK APIs, as distinct from our APIs. (check-in: 1ff78582bf user: stephan tags: trunk) | |
| 21:13 | Eliminate a superfluous JNI-internal middle-man class. (check-in: daede0f801 user: stephan tags: trunk) | |
| 21:04 | Updates to testrunner.tcl so that it runs "make fuzztest" using multiple jobs. (check-in: 7596ea7074 user: dan tags: testrunner) | |
| 21:02 | Whether or not OOM is always fatal in JNI is now a compile-time option. (check-in: 320a34c080 user: stephan tags: trunk) | |
| 19:34 | Correct a string length misuse in JNI sqlite3_result_error() in an OOM case. Unrelated minor JNI cleanups. (check-in: 4252f56f3d user: stephan tags: trunk) | |
| 18:15 | Remove a bunch of commented-out debug output. (check-in: b49488481e user: stephan tags: trunk) | |
| 18:01 | Re-order some out-of-order JNI APIs. Correct JNI sqlite3_open_v2() behavior in a particular OOM condition. (check-in: 49d3be002c user: stephan tags: trunk) | |
| 17:36 | Two significant typo fixes for [1a30919bfbb686]. (check-in: 6a6ee6dd54 user: stephan tags: trunk) | |
| 17:30 | Bind sqlite3_db_handle() to JNI. (check-in: 1a30919bfb user: stephan tags: trunk) | |
| 16:55 | Correct a potential duplicate xDestroy() being triggered for Java-side collations. (check-in: 25331172f7 user: stephan tags: trunk) | |
| 16:29 | Recycle per-UDF JNI state. (check-in: cf406528eb user: stephan tags: trunk) | |
| 14:55 | Code consolidation cleanups. (check-in: d6b5ecd287 user: stephan tags: trunk) | |
| 12:19 | Add -sqllog flag to the JNI 'tests' target because it hits APIs which are otherwise not tested. (check-in: cc3153ed34 user: stephan tags: trunk) | |
| 11:57 | JNI internal cleanups and docs. (check-in: b7b26bfb4f user: stephan tags: trunk) | |
| 10:51 | Remove the Java BusyHandler.xDestroy() method - it should not have had one. Eliminate the last of the potentially-significant MUTF-8 cases. (check-in: c852f1ebbd user: stephan tags: trunk) | |
| 10:20 | Improve threading support for all types of JNI-side callback hooks, making them safe to invoke if another thread is busy replacing them. (check-in: f2af7bbf49 user: stephan tags: trunk) | |
|
2023-08-25
| ||
| 16:43 | Move the 3 Java SQLFunction subclasses from inner classes to package scope. (check-in: 21fd47a68d user: stephan tags: trunk) | |
| 16:26 | Missed a straggler when renaming Java classes in [8ca528006533ac1]. Document threading limitations. (check-in: 5786b95f5d user: stephan tags: trunk) | |
| 14:17 | Hopefully the last major API rename in the JNI bits: rename all lower_camel_case classes which do not have direct counterparts in the C API to UpperCamelCase, as that's more idiomatic. Java types which reflect C-style types are unaffected. (check-in: 8ca5280065 user: stephan tags: trunk) | |
| 13:23 | More Java API renaming for consistency. (check-in: 4e457778de user: stephan tags: trunk) | |
| 12:29 | Re-enable SQLITE_THREADSAFE=0 in the JNI build and add multitest target which builds and runs the tests in all 3 threading modes. (check-in: 6b1c816f6a user: stephan tags: trunk) | |
| 11:32 | Code restructuring. Force SQLITE_THREADSAFE in JNI builds for the time being, as threadsafe==0 leads to as-yet-mysterious JNI-level reference errors. (check-in: 5a099caa2c user: stephan tags: trunk) | |
| 11:06 | Remove incorrect (but harmless) dependency on source code file "sessionfuzz-data1.db" from main.mk and Makefile.in. (check-in: 17d56c0207 user: dan tags: trunk) | |
| 04:27 | Only build in the JNI-side metrics tracking in SQLITE_DEBUG builds. (check-in: 646e7fc3b5 user: stephan tags: trunk) | |
| 04:02 | Javadoc and internal API cleanups. (check-in: 10a43cba9b user: stephan tags: trunk) | |
| 02:57 | Replace all of the JNI XyzHook/Handler classes with snake_cased ones which follow unified naming conventions to make them easier to apply. (check-in: 76e62a3812 user: stephan tags: trunk) | |
| 00:27 | javadoc additions. (check-in: bedf33d403 user: stephan tags: trunk) | |
|
2023-08-24
| ||
| 22:28 | Re-frame the incongruous SQLite3Jni.uncacheThread() API as sqlite3_java_uncache_thread(). (check-in: 7232b03395 user: stephan tags: trunk) | |
| 21:45 | Update some outdated JNI docs and account for a function renamed earlier this evening. (check-in: 3f684ef501 user: stephan tags: trunk) | |
| 21:31 | Do not pre-allocate sqlite3_aggregate_context() for Java UDFs, as it unduly complicates UDF initialization. (check-in: e8308f0c6e user: stephan tags: trunk) | |
| 19:08 | Add doc/testrunner.md, for documenting the testrunner.tcl script. (check-in: 9c69a28401 user: dan tags: trunk) | |
| 18:43 | More code legibility and style improvements in the JNI pieces. Start work on a javadoc build. (check-in: 62b404d62f user: stephan tags: trunk) | |
| 17:25 | Doc, code style, and legibility cleanups. (check-in: cf185bcd25 user: stephan tags: trunk) | |
| 15:42 | Doc style fixes. (check-in: 862f9828e0 user: stephan tags: trunk) | |
| 15:11 | Add a new non-goal to the JNI README.md. (check-in: 53000cdae9 user: stephan tags: trunk) | |
| 14:49 | Merge the jni-threading branch into trunk, eliminating the JNI API's prior threading limitations. (check-in: 3739c8aa70 user: stephan tags: trunk) | |
| 14:43 | Merge into trunk improvements made to the wasm APIs which were too late for 3.43. (check-in: ac9da5c79a user: stephan tags: trunk) | |
| 14:31 | Correct JNI layer's misuse of an sqlite3-internal error-reporting API (no mutex held). Style cleanups. Eliminate lookups of per-thread state by approximately 85% across the test suite. (Closed-Leaf check-in: 1f46ba8d3b user: stephan tags: jni-threading) | |
| 14:17 | Ensure that db mutex is held when using sqlite3ErrorWithMessage() to avoid a potential assertion in debug builds. (Closed-Leaf check-in: b8f6a50a4b user: stephan tags: wasm-post-343) | |
| 13:42 | Fix a test case problem in wal2recover2.test. (check-in: 81361769e1 user: dan tags: bedrock) | |
| 13:32 | Version-3.43.0 for the reuse-schema branch. (check-in: 6f1bcd6a1a user: drh tags: reuse-schema) | |
| 13:26 | Version 3.43.0 for the bedrock branch. (check-in: e7b1ee1a99 user: drh tags: bedrock) | |
| 13:19 | Version 3.43.0 for the wal2 branch. (check-in: b5970fc459 user: drh tags: wal2) | |
| 13:17 | Version 3.43.0 for the begin-concurrent branch. (check-in: e67bf28245 user: drh tags: begin-concurrent) | |
| 12:36 | Version 3.43.0 (check-in: 0f80b798b3 user: drh tags: trunk, release, major-release, version-3.43.0) | |
| 12:01 | Change a variable name in fts5FlushOneHash() to avoid shadowing another. (check-in: 3f5bec9a68 user: dan tags: trunk) | |
| 11:57 | Add more JNI docs, tests, and a handful of Java-side overloads. (check-in: d19a431fac user: stephan tags: jni-threading) | |
|
2023-08-23
| ||
| 18:42 | Fix typo in the Lemon documentation. (check-in: 5daeb318c0 user: drh tags: trunk) | |
| 18:29 | More changes to documents for GitHub-style markdown. (check-in: f20f84ef71 user: drh tags: trunk) | |
| 18:26 | Fix the Markdown in the compile-for-windows.md document so that it works on GitHub. Improved header text in README.md. (check-in: a25360c020 user: drh tags: trunk) | |
| 17:52 | JNI cleanups regarding building with certain features disabled. (check-in: a9e6d5158b user: stephan tags: jni-threading) | |
| 17:15 | Remove unnecessary jclass-type struct members. (check-in: d67255f725 user: stephan tags: jni-threading) | |
| 16:41 | Some thinking-out-loud about how to implement vtabs in Java. In no way complete. (Closed-Leaf check-in: 49c24c29ec user: stephan tags: jni-vtab) | |
| 13:36 | Add a note to the JNI README explaining why the Java API has callback names like xFunc() and xPreUpdate(). (check-in: 415447a310 user: stephan tags: jni-threading) | |
| 13:17 | Bind sqlite3_preupdate_hook() and friends to JNI. (check-in: d0c425b5c1 user: stephan tags: jni-threading) | |
| 12:53 | Minor adjustments to the wording about pull requests in the README.md file. (check-in: 6b2d68afd8 user: drh tags: trunk) | |
| 10:36 | Bind a subset of sqlite3_config() to JNI: threading modes and sqllog. (check-in: fce8ecaf7f user: stephan tags: jni-threading) | |
| 10:20 | The pageOnDirtyList() assertion is too slow even for debugging builds, for some corner cases. It makes the query appear to hang. So make it an EXPENSIVE_ASSERT instead. (check-in: bb9dcdaf32 user: drh tags: trunk) | |
| 09:05 | Numerous minor cleanups and code style conformance improvements. (check-in: 6c92d88492 user: stephan tags: jni-threading) | |
| 00:17 | Improve C-side exception handling from Java-side UDF callbacks. (check-in: aebbc24afb user: stephan tags: jni-threading) | |
|
2023-08-22
| ||
| 23:00 | Minor Tester1.java cleanups. (check-in: 70d936953b user: stephan tags: jni-threading) | |
| 22:13 | Fix Tester1 so that exceptions triggered via threads are not silently ignored. Disable auto-extension tests in multi-thread mode because concurrent threads rightfully interfere with that. (check-in: 56b2a077ac user: stephan tags: jni-threading) | |
| 20:10 | More work on the JNI multi-threaded test runner. (check-in: 9a74ad716b user: stephan tags: jni-threading) | |
| 18:36 | Disassociate JNI db handles from the thread that created them, as it's no longer relevant. (check-in: 8b78b737e6 user: stephan tags: jni-threading) | |
| 17:51 | Correct JNI binding of sqlite3_shutdown() to clean up all cached JNIEnv objects. (check-in: 02e868690f user: stephan tags: jni-threading) | |
| 17:36 | JNI internal cleanups and correct two leaked db handles in test code. (check-in: f927a30b5b user: stephan tags: jni-threading) | |
| 16:44 | Fix a harmless memory leak in the sqldiff utility. (check-in: 724bc15701 user: drh tags: trunk) | |
| 15:47 | Merge the trunk Makefile enhancements into the reuse-schema branch - especially the new "sdevtset" makefile target. (check-in: f55f5e9dff user: drh tags: reuse-schema) | |
| 15:30 | Move the JNI per-thread cache of NativePointerHolder refs into global space. This allows better-targeted mutex locks and incidentally eliminates the lagginess and post-run hangs in Tester1's multi-thread mode (presumably caused by deadlocks). (check-in: e209f56a97 user: stephan tags: jni-threading) | |
| 15:19 | Add makefile target "sdevtest" - like "mdevtest" except asan and usan enabled for the non-debug test. (check-in: a449d650cd user: dan tags: trunk) | |
| 13:41 | Update version number in autoconf/tea/configure.ac. (check-in: 055ae724ff user: dan tags: trunk) | |
| 11:34 | Move most of the per-JNIEnv global Java class refs into the global state, saving a bit of per-thread overhead. (check-in: 7342bf5787 user: stephan tags: jni-threading) | |
| 11:20 | Update autoconf/Makefile.msc (by running mkmsvcmin.tcl) to support the "ASAN=1" option. (check-in: 17028ba7a9 user: dan tags: trunk) | |
|
2023-08-21
| ||
| 23:45 | Minor JNI cleanups. (check-in: b88910aaaa user: stephan tags: jni-threading) | |
| 18:31 | Merge latest changes from the wal2 branch into this one. (check-in: 4d8df0c426 user: dan tags: bedrock) | |
| 18:25 | Fix problems related to structured-exception-handling on this branch. (check-in: d3d77e35ea user: dan tags: bedrock) | |
| 18:03 | Merge the latest trunk enhancements into the begin-concurrent branch. (check-in: 76a99a2c40 user: drh tags: begin-concurrent) | |
| 18:02 | Merge latest trunk changes into this branch. (check-in: 135bf72c6b user: dan tags: wal2) | |
| 17:53 | Merge the latest trunk enhancements into the reuse-schema branch. (check-in: e94f09f188 user: drh tags: reuse-schema) | |
| 17:49 | Fix problems related to structured-exception-handling on this branch. (check-in: dd86c2729b user: dan tags: begin-concurrent) | |
| 17:26 | Fix MSVC testfixture.exe builds. (check-in: 7004c9027e user: dan tags: begin-concurrent) | |
| 16:14 | Fix an undefined integer overflow in fts5. (check-in: f5c50349b1 user: dan tags: trunk) | |
| 15:29 | ifdef adjustments so that SQLITE_OMIT_WAL works with SQLITE_USE_SEH. (check-in: 0462a2612d user: drh tags: trunk) | |
| 14:40 | Fix another UBSAN inaccuracy in fuzzcheck. (check-in: a6fb9de8f8 user: drh tags: trunk) | |
| 14:28 | Address minor inaccuracies in fuzzcheck and RTREE found by UBSAN. (check-in: a64e6c2fd8 user: drh tags: trunk) | |
|
2023-08-19
| ||
| 14:49 | JNI cleanups. (check-in: 0a84131008 user: stephan tags: jni-threading) | |
| 12:34 | Merge trunk into jni-threading branch. (check-in: 8254479c6f user: stephan tags: jni-threading) | |
| 12:32 | JNI doc additions. (check-in: 0c7ac34f30 user: stephan tags: jni-threading) | |
| 11:52 | JNI test code cleanups. (check-in: e202b6e69d user: stephan tags: jni-threading) | |
| 11:26 | Minor JNI cleanups. (check-in: 1cecb9e038 user: stephan tags: jni-threading) | |
| 10:43 | Add multi-thread run mode to JNI Tester1. It works but hangs on exit sometimes for Java reasons as yet not understood. (check-in: bdbaf7a453 user: stephan tags: jni-threading) | |
| 08:22 | Replace JNI::NewStringUTF() for the remaining cases where output may be incompatible with MUTF-8. It is now only used when we know the output to be plain ASCII. (check-in: 2d955eef25 user: stephan tags: jni-threading) | |
| 08:12 | shell.c.in help text typo fix. No functional changes. (check-in: c319033276 user: stephan tags: trunk) | |
|
2023-08-18
| ||
| 15:39 | Rename the decimal_sci() function to decimal_exp(). Forum post fa027bb0ab. (check-in: c48f1be8cc user: drh tags: trunk) | |
| 15:17 | Avoid running test case sort2.2.3 under address-sanitizer. It runs out of memory on some 32-bit platforms. (check-in: 925be75399 user: dan tags: trunk) | |
| 14:41 | Improve exception handling in OpfsDb.importDb(). (check-in: a4eedd63b5 user: stephan tags: wasm-post-343) | |
| 14:16 | Extend the importDb() method of both OPFS VFSes to (A) support reading in an async streaming fashion via a callback and (B) automatically disable WAL mode in the imported db. (check-in: 9b1398c96a user: stephan tags: wasm-post-343) | |
| 12:15 | Enhance the CLI and the fuzzcheck utility programs to report whether they are compiled as 32-bit or 64-bit for things like the --version option. (check-in: ec7eeb055b user: drh tags: trunk) | |
| 11:36 | Enhance the notes on compiling for Windows11 to explain how to do 32-bit builds on a 64-bit system. (check-in: dd749e4042 user: drh tags: trunk) | |
|
2023-08-17
| ||
| 22:04 | Remove some obsolete JNI-internal docs. (check-in: 00a2a3736a user: stephan tags: jni-threading) | |
| 17:48 | Do not allow bound parameters in the ON CONFLICT clause of an UPSERT. dbsqlfuzz 9983e2c77634a8ccf33b5c91fa9982599de5f9e9 (check-in: 3c06709335 user: drh tags: trunk) | |
| 16:59 | Fix an error in documentation comments in fts5.h. (check-in: 24d96bd65d user: dan tags: trunk) | |
| 16:49 | Add extra test to fts5synonym2.test. (check-in: 39ea11be3b user: dan tags: trunk) | |
| 16:06 | Add "Windows-Sanitize" configuration to "testrunner.tcl release" tests on windows. (check-in: e68b46dc6a user: dan tags: trunk) | |
| 15:14 | Have all test names in json101.test start with "json101". (check-in: af56d7b6b9 user: dan tags: trunk) | |
| 15:11 | Enable address sanitizer in Makefile.msc by adding the ASAN=1 argument on the nmake command line. (check-in: 3eaadaff85 user: drh tags: trunk) | |
| 14:19 | Fix a possible UAF in SEH if an exception occurs at an inopportune moment during WAL processing. (check-in: 91b91037e3 user: drh tags: trunk) | |
| 13:13 | Tighten up the JNI auto-ext handling. (check-in: c09c8d05a2 user: stephan tags: jni-threading) | |
| 12:44 | Minor internal JNI cleanups and fixes. (check-in: 0e9437de02 user: stephan tags: jni-threading) | |
| 10:49 | Remove the FIXME markers related to threading. Code style cleanups. (check-in: 154ab26dc6 user: stephan tags: jni-threading) | |
| 09:49 | Add SQLITE_EXTRA_AUTOEXT, similar to SQLITE_EXTRA_INIT but adds a builtin auto-extension provided by the client. Suggestion from forum post 00829394c74a670f. (Closed-Leaf check-in: 423e77277a user: stephan tags: extra-autoext) | |
|
2023-08-16
| ||
| 17:23 | Refinements to instructions on compiling for Windows. (check-in: d543c36c35 user: drh tags: trunk) | |
| 17:12 | Improved instructions on how to build SQLite on Windows 11 and similar. (check-in: 0f6b2b3373 user: drh tags: trunk) | |
| 15:27 | Make sqlite3_stmt_explain() accessible to loadable extensions. (check-in: a237a31ff4 user: drh tags: trunk) | |
| 15:10 | Mix the current process ID into the randomness used for generating temporary filenames on Windows. (check-in: 775a36ee09 user: drh tags: trunk) | |
| 14:18 | Update testrunner.tcl to use environment variable %NUMBER_OF_PROCESSORS% when running under tclsh on windows. Also modify the internal database schema used by testrunner.tcl to be compatible with old versions of SQLite. (check-in: 6542ed3b9e user: dan tags: trunk) | |
| 13:55 | Fix test script problem preventing veryquick.test from running. (check-in: e738865740 user: dan tags: trunk) | |
|
2023-08-15
| ||
| 21:44 | Cherrypick [00ac653562a6] to remove stray JNI debug output. No functional changes. (check-in: e12d70f38c user: stephan tags: trunk) | |
| 20:57 | Cherrypick [653ed92dc391] (went to wrong branch). Doc change only, no code changes. (check-in: 79a14457f0 user: stephan tags: trunk) | |
| 18:52 | Update testrunner.tcl to make it easier to add things like mdevtest. (check-in: a531b71c4f user: dan tags: trunk) | |
| 18:08 | Improve the portability of the src-verify.c tool on Windows. (check-in: 4068d94acd user: drh tags: trunk) | |
| 14:53 | Fix problems in fts5 test code. (check-in: c16ed3b1cc user: dan tags: trunk) | |
| 13:01 | Add note about the current threading limitation to ext/jni/README.md. No code changes. (check-in: 653ed92dc3 user: stephan tags: wasm-post-343) | |
| 12:27 | Use a dodgy substitute if the INFINITY macro is not available. See forumpost 8e66e19bb9. (check-in: 4ae72c8967 user: drh tags: trunk) | |
| 11:58 | Fix the PRAGMA case_sensitive_like command so that the LIKE function continues to be innocuous after the PRAGMA. Forum post 925dc9f67804c540. (check-in: 84c268c34c user: drh tags: trunk) | |
| 10:57 | Fix an off-by-one error causing a buffer overread in test2.c. (check-in: e1edf95ecc user: dan tags: trunk) | |
| 09:26 | Minor reshaping of Tester1 moving towards making a multi-threaded run mode. (check-in: f104c14c26 user: stephan tags: jni-threading) | |
| 09:16 | Remove a piece of stray debug output. No functional changes. (check-in: 00ac653562 user: stephan tags: wasm-post-343) | |
|
2023-08-14
| ||
| 19:10 | Fix the autoconf makefile for the CLI such that it disables double-quoted strings by default, as all other builds of the CLI do. forum post 9794b6aaa5. (check-in: 85fd4f0ef4 user: drh tags: trunk) | |
| 18:21 | Fix a problem in sqlite3_snapshot_recover() introduced by the [8a6b0c24937e855b] merge. (check-in: c2577eb0a4 user: dan tags: trunk) | |
| 17:12 | Bring handling of the Java auto-ext handler more in line with the core in terms of locking and mutability during traversal. This removes the explicit synchronous requirement from the Java open() and auto-ext bindings. (check-in: 42994b952e user: stephan tags: jni-threading) | |
| 14:21 | Remove some obsolete, commented-out makefile code. No functional or build changes. (check-in: ea574cd5de user: stephan tags: wasm-post-343) | |
| 13:33 | Change the name of the ".binary" command in the CLI to ".crnl". The sense of the setting is inverted. The original ".binary" still works for backwards compatibility but is now undocumented. ".crnl" is also undocumented on machines where it is a no-op (all machines other than Windows). forum thread 8bd0b0fbdbc12477 (check-in: 544de2da09 user: drh tags: trunk) | |
| 13:27 | More work on the JNI-specific mutexes. Rework the NativePointerHolder cache lookup to be slightly simpler and O(1) instead of O(N). (check-in: c84ded0e59 user: stephan tags: jni-threading) | |
| 12:20 | Fix harmless compiler warnings reported by MSVC. (check-in: 391e21bb6e user: drh tags: trunk) | |
| 12:05 | Enable SEH be default in Windows builds. (check-in: faae792fd5 user: drh tags: trunk) | |
| 08:28 | JNI-internal docs and removal of obsolete code. (check-in: b62d93258b user: stephan tags: jni-threading) | |
|
2023-08-13
| ||
| 20:58 | Internal API renaming for clarity's sake. (check-in: 911e4fc5aa user: stephan tags: jni-threading) | |
| 12:40 | Add a mutex for auto-extensions, tied in to the open() process since that's the route into auto-extensions. (check-in: 8da97e0db4 user: stephan tags: jni-threading) | |
| 10:28 | Add some docs and metrics for the new mutex internals. (check-in: 33d1780b43 user: stephan tags: jni-threading) | |
| 10:22 | Remove SQLITE_DEBUG from JNI build. (check-in: 82f004cf74 user: stephan tags: trunk) | |
| 09:53 |
An initial attempt at protecting the JNI global state via mutexes at the C level instead of relying on Java's synchronized keyword. | |
|
2023-08-12
| ||
| 23:47 | Bind sqlite3_interrupt() and sqlite3_is_interrupted() to JNI but with caveats regarding mutexing of the JNIEnv cache. Add a loud warning to the JNI 'dist' target that it should be built with JDK8 (a.k.a. Java 1.8) for compatibility reasons. (check-in: fbf99a2423 user: stephan tags: jni-threading) | |
| 21:39 | Merge the Java Native Interface (JNI) binding into trunk. (check-in: 48b13edcec user: stephan tags: trunk) | |
| 21:08 | Update wasm's push-testing rule to exclude files which were recently removed from the build. (check-in: 0a6930a7ff user: stephan tags: trunk) | |
| 20:50 | Correct JNI .jar rules to only include *.java/class files, not *.* (*~ files). (Closed-Leaf check-in: 1ba7754045 user: stephan tags: jni) | |
| 19:58 | Fix the mdevtest target so that it works with msvc. (check-in: 01f49448cd user: dan tags: trunk) | |
| 19:25 | Fix testrunner.tcl so that it restarts itself using [testfixture] if its current interpreter does not support [package require sqlite3]. (check-in: 408be98ddd user: dan tags: trunk) | |
| 18:23 | Have the mdevtest target support the OPTS variable on unix. (check-in: 940f58d9b9 user: dan tags: trunk) | |
| 17:36 | Add "mdevtest" target to makefiles. Equivalent to running "devtest" on both debug and non-debug builds. (check-in: af354fbc0b user: dan tags: trunk) | |
| 15:37 | More JNI docs. (check-in: 290028d3ca user: stephan tags: jni) | |
| 15:09 | Further simplifications in the interface of the OutputPointer family of Java classes. (check-in: 962c3e0de2 user: stephan tags: jni) | |
| 12:16 | Merge the latest trunk enhancements into the reuse-schema branch. (check-in: d2b0ddcc75 user: drh tags: reuse-schema) | |
| 10:39 | Tweaks and docs for the OutputPointer family of Java classes. (check-in: 265c8fd0d4 user: stephan tags: jni) | |
| 10:27 | Bind sqlite3_db_status() to JNI. (check-in: b79477a0af user: stephan tags: jni) | |
| 10:06 | Bind sqlite3_status(64)() to JNI. (check-in: cefb6614e6 user: stephan tags: jni) | |
|
2023-08-11
| ||
| 22:40 | Modernize the sqlite3 shell man page a bit, per forum request. (check-in: 3bc0693c46 user: stephan tags: trunk) | |
| 21:25 | Add timing info to SQLTester. (check-in: b69b5facbf user: stephan tags: jni) | |
| 21:24 | Merge trunk into jni branch. (check-in: 4f0aeeba02 user: stephan tags: jni) | |
| 20:32 | Fix a makefile deps problem which caused ext/jni build to fail if sqlite3.c/h were not created beforehand. (check-in: 101de67077 user: stephan tags: jni) | |
| 19:38 | Merge latest trunk changes, including support for handling of structured-exceptions in MSVC builds, with this branch. (check-in: cb3cf9bab0 user: dan tags: begin-concurrent) | |
| 19:36 | Merge latest wal2 changes, including support for handling of structured-exceptions in MSVC builds, with this branch. (check-in: 331f2f3e5d user: dan tags: bedrock) | |
| 19:33 | Merge latest trunk changes, including support for handling of structured-exceptions in MSVC builds, with this branch. (check-in: 00bfae9ffa user: dan tags: wal2) | |
| 19:31 | If SQLITE_USE_SEH is defined, handle structured-exceptions thrown by MSVC builds if the *-shm file mapping is accessed after it becomes invalid for some reason. (check-in: 8a6b0c2493 user: dan tags: trunk) | |
| 18:59 | Minor SQLTester test tweaks and have 'make tester' include the out-of-tree tests if they are found. (check-in: 6c8538d834 user: stephan tags: jni) | |
| 18:31 | Fix a problem with handling savepoints in BEGIN CONCURRENT transactions. (check-in: ca422d00d7 user: dan tags: bedrock) | |
| 18:25 | Fix a problem with handling savepoints in BEGIN CONCURRENT transactions. (check-in: 4a5c0439ae user: dan tags: begin-concurrent) | |
| 18:04 | Bind sqlite3_sql() and sqlite3_expanded_sql() to JNI. Start marking C-side functions which would need explicit mutex support if we remove 'synchronized' from their Java entry points (but there are many more left to mark). (check-in: c7fb32d1ef user: stephan tags: jni) | |
| 17:45 | Add a doc link for the new sqlite3_js_posix_create_file(). (check-in: 0d7aac45b8 user: stephan tags: trunk) | |
| 17:38 | Add sqlite3.capi.sqlite3_js_posix_create_file() and oo1.OpfsDb.importDb() as alternatives for the newly-deprecated sqlite3_js_vfs_create_file(). (check-in: da6eaf8d82 user: stephan tags: trunk) | |
| 14:31 | Deprecate sqlite3_js_vfs_create_file() because, it was discovered today, its out-of-scope use of the sqlite3_vfs, sqlite3_file, and sqlite3_io_methods APIs triggers unresolvable assertions in the core when built with SQLITE_DEBUG. (check-in: f3647a3ac8 user: stephan tags: trunk) | |
| 11:46 | Merge all the latest trunk enhancements into the bedrock branch. (check-in: 859932ebce user: drh tags: bedrock) | |
| 11:40 | Merge the latest trunk enhancements into the wal2 branch. (check-in: fe1bf30ca0 user: drh tags: wal2) | |
| 11:34 | Merge the latest trunk enhancements into the begin-concurrent branch. (check-in: 7cb2b4e35f user: drh tags: begin-concurrent) | |
| 11:30 | Provide the -DSQLITE_LEGACY_JSON_VALID compile-time option to restore the (incorrect) legacy behavior of json_valid(NULL). (check-in: 00bc9f1b57 user: drh tags: trunk) | |
| 11:24 | Fix bug in the test case for the previous check-in. (Closed-Leaf check-in: c5daae8861 user: drh tags: legacy-json-valid) | |
| 11:23 | Update test scripts specific to this branch so that they work on windows. (check-in: f0ca13edad user: dan tags: wal2) | |
| 11:12 | Up until version 3.42.0, there was a bug in json_valid() such that it would return False (0) for a NULL input. That bug is fixed in 3.42.0. This check-in adds a compile-time option -DSQLITE_LEGACY_JSON_VALID that restores the old buggy behavior for applications that depend on it. (check-in: 15c2eadbff user: drh tags: legacy-json-valid) | |
|
2023-08-10
| ||
| 21:50 | Mark _all_ JNI binding funcs as synchronized so that Java can lock them and protect our global-state access. The alternative is writing a mountain of C-side code to do the same thing. (check-in: afe190a940 user: stephan tags: jni) | |
| 21:29 | Work around jdk8 and jdk19 mangling the C name of sqlite3_db_config() differently. Correct the variadic arg handling of the JNI-side subset of sqlite3_db_config() options. (check-in: 746894c3c0 user: stephan tags: jni) | |
| 21:20 | Add tests for structured-exception-handling and wal2. Fix a problem with the same. (Leaf check-in: 87242777ec user: dan tags: wal2-shm-exceptions) | |
| 20:52 | Add a working dist zip file for the JNI bits. (check-in: d6a4d212ce user: stephan tags: jni) | |
| 18:58 | Experimental merge of the wal-shm-exceptions and wal2 branches. (check-in: fd58c61624 user: dan tags: wal2-shm-exceptions) | |
| 18:57 | Initial pass at 'make dist' rules for the JNI bundle, but they still need a bare-bones, posix-make-compatible makefile to include in the bundle. (check-in: ff54e66a4d user: stephan tags: jni) | |
| 18:50 | New testcase() macro in the tokenizer, to better document its behavior. (check-in: b2fdac0b15 user: drh tags: trunk) | |
| 17:39 | Merge trunk into jni branch for the newly-relocated version-info tool. (check-in: cc8e8cba67 user: stephan tags: jni) | |
| 17:32 | Move ext/wasm/version-info.c to tool/ for re-use in build other dist bundles. (check-in: 4b0871fd36 user: stephan tags: trunk) | |
| 17:07 | Merge latest trunk changes into this branch. (Leaf check-in: 3ed89c344f user: dan tags: wal-shm-exceptions) | |
| 17:04 | Mark test script wal2big.test as "TESTRUNNER: slow". (check-in: ae7f3bcb5b user: dan tags: wal2) | |
| 17:03 | Merge latest trunk changes into this branch. (check-in: 72f7807b34 user: dan tags: wal2) | |
| 16:42 | Add SQLTester --keep-going flag to allow it to continue to the next script after an error. (check-in: 4d635f781b user: stephan tags: jni) | |
| 13:10 | Document that auto-extensions registered via JNI will fail if they open a db (to avoid triggering an endless loop in the auto-extensions). Discover the hard way that JDKv19 creates different mangled JNI names for some functions than JDKv8. Start reformatting much of the JNI API decls in prep for making them even longer. (check-in: 99c0941f1c user: stephan tags: jni) | |
| 12:36 | Resolve two assertions in the auto-extension JNI which were triggered via new SQLTester infrastructure. Move SQLTester's db-init SQL injection into an auto-extension. (check-in: 2952906c30 user: stephan tags: jni) | |
| 11:15 | Make test completion status more visible at a glance on modern terminals. (check-in: a4e96c306c user: stephan tags: jni) | |
| 11:04 | Disable REQUIRED_PROPERTIES handling in SQLTester, per /chat. Scripts with that directive are now skipped. (check-in: ddc534cb25 user: stephan tags: jni) | |
| 10:58 | Add a visual indicator (emoji) to TestScript verbose messages, dependent on the message's level of verbosity. (check-in: dc323d3894 user: stephan tags: jni) | |
| 10:44 | Add the current --testcase name to SQLTester --verbose output. (check-in: f87367402b user: stephan tags: jni) | |
| 10:34 | More SQLTester docs. Add --verbosity command to help zoom in on script areas while debugging. Spice up test-start/end output with some emoji. (check-in: 8dd0802149 user: stephan tags: jni) | |
| 05:25 | Give DbException the option of closing the db to simplify error handling in one case. (check-in: 908c9a4450 user: stephan tags: jni) | |
| 05:14 | Initial version of REQUIRED_PROPERTIES support for SQLTester, with TEMPSTORE_(FILE/MEM) and RECURSIVE_TRIGGERS options. (check-in: 48d16c9d2f user: stephan tags: jni) | |
| 04:24 | Generic cleanups and fixes in SQLTester. (check-in: fc5d3cc30d user: stephan tags: jni) | |
| 02:09 | Change the SQLite3Jni API annotations to use SOURCE retention (used only at compile-time). (check-in: 3c3fea6bf2 user: stephan tags: jni) | |
| 01:44 | Move all of the SQLTester code into a single file, since it's only got 1 public class. Remove 'public' from many methods which don't need it. Add more documentation to it. (check-in: 2815d67695 user: stephan tags: jni) | |
| 01:19 | Defer static JNI-side init of SQLTester until main() is called so that its auto-extensions do not leak over to clients of the main library. (check-in: e461fdd53b user: stephan tags: jni) | |
| 01:05 | Merge trunk into jni branch. (check-in: 52fa6f7841 user: stephan tags: jni) | |
| 01:03 | Treat all args to --glob as a single glob. (check-in: 4737bd3457 user: stephan tags: jni) | |
| 00:58 | Remove --print's ability to read ahead. (check-in: 15cfee972b user: stephan tags: jni) | |
| 00:34 | Replace the SQLTester infrastructure with a line-oriented, non-regex-heavy parser. Add --column-names command. (check-in: 88863908ee user: stephan tags: jni) | |
|
2023-08-09
| ||
| 23:47 | Port the SQLTester 'v1' commands to the 'v2' evaluation bits. Still TODO is swapping out v1 with these separate impls. (check-in: 0cf57e5b0f user: stephan tags: jni) | |
| 22:30 | Correct REQUIRED_PROPERTIES handling to not fail if there are no properties. (check-in: 7a19bef4f5 user: stephan tags: jni) | |
| 22:18 | More for the SQLTester rework. Can read input and dispatch commands, but only --print is currently implemented. (check-in: 4fa2ad33ed user: stephan tags: jni) | |
| 19:51 | Initial sketches of a line-by-line parser for SQLTester to overcome its compatibility shortcomings. Far from complete. (check-in: 43534cd042 user: stephan tags: jni) | |
| 18:25 | Adapt TestScript to skip REQUIRED_PROPERTIES, per [7a07863e082664da], and improve a couple of adject reasons-for-skipping messages. (check-in: f937097e9b user: stephan tags: jni) | |
| 17:47 | Add an extra constraint to the test-script-interpreter.md spec. (check-in: 7a07863e08 user: drh tags: jni) | |
| 17:23 | SQLTester --result command: do not double-{}-wrap error messages and do not throw on db error. (check-in: f7be20f5a6 user: stephan tags: jni) | |
| 17:04 | Move the test command body's trim() back into the TestScript class (to simplify Command-level code) but do it after double-verbose has had the chance to emit it as-is (so that debug output is not mangled by the trim). (check-in: f15ecb68f7 user: stephan tags: jni) | |
| 16:56 | Tweak the SQLTester --verbose and double-verbose output a bit for legibility. (check-in: 46b79afaaf user: stephan tags: jni) | |
| 16:29 | Strip --oom commands from SQLTester input since (A) we can't currently do anything with them and (B) they can appear as body content of --testcase commands and the current parser cannot deal with that. If --verbose is provided once, emit the name and args of each command as it's run. If --verbose is used twice or more, also emit the command's body text, if any. (check-in: 0770e8467d user: stephan tags: jni) | |
| 16:03 | Update the definition of "special characters" for the SQLTester and correct the code to match it. (check-in: 217f6e0c9c user: stephan tags: jni) | |
| 15:46 | Extend TestScript to be able to report why it should be skipped. Expand the test-skipping rules to account for the current spec doc. Add the {} empty-string case to the spec doc. (check-in: 4fcc8cb0cc user: stephan tags: jni) | |
| 14:47 | Add a test for the --null command. (check-in: 83ac815deb user: stephan tags: jni) | |
| 14:43 | Extend SQLTester glob support with '#'. (check-in: 756ef83f45 user: stephan tags: jni) | |
| 14:24 | Implement the SQLTester's result escaping rules. (check-in: 61bb950873 user: stephan tags: jni) | |
| 13:51 | Add --json and --json-block SQLTester commands. (check-in: 478129d901 user: stephan tags: jni) | |
| 13:16 | Add SQLTester --tableresult command. (check-in: 8c5b6d893d user: stephan tags: jni) | |
| 12:05 | Clean up the SQLTester output a bit by using the module name, instead of filename, where appropriate. (check-in: 5323e4fd25 user: stephan tags: jni) | |
| 11:10 | Document SQLTester's --print command and add some argument validation to it. (check-in: ab9c945bb0 user: stephan tags: jni) | |
| 11:05 | Rework how SQLTester's Command objects are dispatched and how TestScript stores its command entries. (check-in: f929f1f7f7 user: stephan tags: jni) | |
| 09:56 | Some minor tweaks in SQLTester in prep for larger refactoring. (check-in: 1d93f93ac9 user: stephan tags: jni) | |
|
2023-08-08
| ||
| 22:10 | Remove the current-statement tracking from the JNI internals because it will break down in the face of client-side mixed-mode native/java code, e.g. in cases like SQLTester. This makes tracing of sqlite3_stmt a micron slower but also reliably correct. (check-in: 4c0ec89dca user: stephan tags: jni) | |
| 21:22 | Adapt JNI build to be buildable with or without SQLTester. (check-in: adae7d7869 user: stephan tags: jni) | |
| 21:05 | Add SQLTester dup() and dup_count() UDFs. Correct arg handling of the --run command. (check-in: 0dba3073f4 user: stephan tags: jni) | |
| 20:41 | Correct --result arg count check and add infrastructure to let us add custom C-side behavior to SQLTester via an auto extension. (check-in: bb8321702e user: stephan tags: jni) | |
| 20:15 | If SQLTester now treats a no-args --result as comparing against an empty string. (check-in: 49005ca5cc user: stephan tags: jni) | |
| 20:02 | Add glob/notglob commands to SQLTester and complete the interrupted-midway impls of the strglob() and strlike() JNI bindings. (check-in: 4ba98ec0bf user: stephan tags: jni) | |
| 19:20 | When SQLTester hits an unknown command, emit a warning and skip the rest of that script instead of aborting the whole run, per /chat discussion. Reduce verbosity a bit. (check-in: 3e78d22d04 user: stephan tags: jni) | |
| 17:36 | Minor cleanups in sqlite3Int.h. By reordering some fields in the Parse object, it packs more tightly and uses less memory and less CPU to initialize. (check-in: aa6de539c0 user: drh tags: trunk) | |
| 16:53 | Fix an issue in the amalgamation generator in which it was not correctly expanding the SQLite version in the header comment. (check-in: 293f6191e9 user: drh tags: trunk) | |
| 14:58 | Correct the spacing output of multi-select SQL blocks for SQLTester --result. (check-in: 8d98645a9e user: stephan tags: jni) | |
| 14:49 | Updates to the test script interpreter spec: Rather than failing immediately upon encountering an incompatibility, simply abandon the rest of that particular input file. (check-in: d2c99b96f4 user: drh tags: jni) | |
| 14:40 | A number of baby steps for SQLTester.java. It can now handle basic --result cases. (check-in: 0404f688f6 user: stephan tags: jni) | |
| 14:25 | Add a few words of clarification on how the SQLite Test Script Interpreter should be initialized to start each test script. (check-in: 3aa2b5a5ca user: drh tags: jni) | |
| 13:05 | Correct JNI sqlite3_prepare() to emit a null stmt handle when the C counterpart succeeds but results in a NULL pointer. (check-in: 94628f88b5 user: stephan tags: jni) | |
| 11:46 | Implement the new/open/close SQLTester commands. (check-in: dc823bf00f user: stephan tags: jni) | |
| 11:46 | Add a JNI-layer sqlite3.toString() for debugging. (check-in: 456691649a user: stephan tags: jni) | |
| 10:58 | Bind sqlite3_strlike/strglob() to JNI. (check-in: eb5440f71b user: stephan tags: jni) | |
| 09:45 | SQLTester: add print command and improve argument error reporting infrastructure. (check-in: 1b6e84f6aa user: stephan tags: jni) | |
| 00:59 | Add missing license header. Minor cleanups in SQLTester. (check-in: 5be50fd588 user: stephan tags: jni) | |
| 00:37 | Rework SQLTester dispatching and add stub impls for several commmands. (check-in: 9e61af75ac user: stephan tags: jni) | |
|
2023-08-07
| ||
| 23:59 | Add command dispatcher to SQLTester. (check-in: e0a06931e9 user: stephan tags: jni) | |
| 23:04 | SQLTester now ignores tests which contain constructs specified in the spec doc. (check-in: ecaeee652a user: stephan tags: jni) | |
| 22:32 | SQLTester can now split a test script into a series of individual commands. (check-in: d3d1accc8b user: stephan tags: jni) | |
| 22:02 | SQLTester can now read a script and strip it of all noise content. (check-in: 59bd392817 user: stephan tags: jni) | |
| 21:04 | Initial skeleton for adding an SQL-driven test script interpreter for the JNI bindings. (check-in: 2aa8f0edec user: stephan tags: jni) | |
| 17:09 | Enhance sqlite3_vtab_nochange() so that it works with "UPDATE ... FROM ..." statements. Use this to allow some updates on fts5 contentless-delete tables. (check-in: 27ff86e4d8 user: dan tags: trunk) | |
| 16:15 | Changes so that sqlite3_vtab_nochange() works with "UPDATE ... FROM...". Use this to allow UPDATE on a contentless fts5 table if new values are supplied for all indexed columns. (Closed-Leaf check-in: 16cd2161e3 user: dan tags: fts5-contentless-delete) | |
| 11:18 | When converting a Java exception to a db error message, use Throwable.toString() instead of getMessage() so that the exception type's name is included. More internal API renaming for consistency. (check-in: 2d44720d06 user: stephan tags: jni) | |
| 10:59 | Lots of JNI internal API renaming, for consistency, and moving-around of utility functions. Make it safe for more callback types to throw. (check-in: 9a494394b9 user: stephan tags: jni) | |
| 10:01 | JNI API renaming to better match the C API. (check-in: 6e0bd03d0b user: stephan tags: jni) | |
| 09:44 | Rename fts5_api pContext parameters to pUserData, per /chat discussion. This is a cosmetic change made to reduce confusion between those parameters and the two other context-type parameters in that API. (check-in: 2ca064d8eb user: stephan tags: trunk) | |
| 01:06 | Make sqlite3_stmt() Java ctor private - it's only constructed from JNI code. (check-in: ce82c42f15 user: stephan tags: jni) | |
| 00:29 | Minor internal cleanups and additional test metrics. (check-in: fa0a6b6e8e user: stephan tags: jni) | |
| 00:06 | Bind the auto-extension APIs to JNI. (check-in: 746a5fa079 user: stephan tags: jni) | |
|
2023-08-06
| ||
| 22:09 | Rework the sqlite3_open(_v2)() order of operations so that pending auto-extension support can get ahold of the open-time Java state despite the Java/C (sqlite3*) binding not having yet been established. (check-in: 34da294ab5 user: stephan tags: jni) | |
| 21:29 | Completely rework how the JNI sqlite3_open(_v2) and sqlite3_prepare(_vN)() bindings deal with output pointers to give the JNI side full control over the origin of db and stmt handles (necessary for solving chicken/egg situations in auto-extensions and prepare-time trace). Lots of adjacent internal API renaming. (check-in: 644999caff user: stephan tags: jni) | |
| 20:01 | Start adding JNI-side support for auto extensions, but hit a brick wall which requires slightly awkward semantics changes in the JNI bindings for sqlite3_open(_v2)() to resolve, so stash this #if'd out for the time being. (check-in: 77a32d238e user: stephan tags: jni) | |
| 15:01 | Doc cleanups. (check-in: 5f56b00770 user: stephan tags: jni) | |
| 14:19 | Bind sqlite3_config() to JNI for call variants taking (int,int*) and (int,const char *) variadic arguments. (check-in: 6119289da8 user: stephan tags: jni) | |
| 13:02 | JNI-internal cleanups and API renaming. Add a C-side java-string-to-utf8 conversion. (check-in: 672d85795d user: stephan tags: jni) | |
| 11:05 | Remove doc outdated warning about sqlite3_trace_v2() JNI binding being incompatible with MUTF-8. Use new to-string capability to simplify Fts5ExtensionApi::xColumnText() JNI binding. (check-in: ebcfc2379b user: stephan tags: jni) | |
| 10:49 | Add a way to convert from standard UTF-8 to a Java string (JNI lacks this capability). (check-in: 07dd082c9e user: stephan tags: jni) | |
| 10:14 | Bind sqlite3_db_filename() and (closely related) (A) add many more docs about the UTF-8/MUTF-8 discrepancy (B) start adding internals to enable us to perform the standard-UTF-8-to-Java conversion from C. (check-in: 586720fa71 user: stephan tags: jni) | |
|
2023-08-05
| ||
| 22:41 | Bind sqlite3_set_authorizer() to JNI. (check-in: e0fa031359 user: stephan tags: jni) | |
| 21:35 | Refactor the per-JNIEnv cache from a fixed-size static array to a linked list of dynamically-allocated entries. Uncache all per-db state (which is necessarily JNIEnv-specific) when the corresponding JNIEnv is uncached. (check-in: 9dd8b78419 user: stephan tags: jni) | |
| 20:19 | Add SQLite3Jni.uncacheJniEnv(), a way for Java threads to clear their thread-specific cached state from the JNI bindings when they're about to terminate (or are otherwise done using the library). (check-in: 7468f8761b user: stephan tags: jni) | |
| 19:20 | In the JNI docs, note that the sizeof SQLITE_TRANSIENT and SQLITE_STATIC should ideally be the same as the platform's pointer size. (check-in: 7d4ac44ec4 user: stephan tags: jni) | |
| 19:15 | Tiny doc typo fixes from forum post 31eb707250. No code changes. (check-in: 8ede50082e user: stephan tags: trunk) | |
| 12:48 | JNI internal refactoring and cleanups. (check-in: 7397973a2f user: stephan tags: jni) | |
| 11:16 | Bind Fts5ExtensionApi::xUserData() to JNI and extend xCreateFunction() to accept that argument. In test code, use assert() instead of exceptions if assert() is enabled so that test failures (exceptions) thrown via callbacks do not get suppressed (which they otherwise necessarily are to avoid crashing the host app). (check-in: e438373776 user: stephan tags: jni) | |
| 04:30 | Add missing Fts5PhraseIter.java to the build. (check-in: 96281ad0d5 user: stephan tags: jni) | |
| 04:23 | Bind fts5_api::xCreateFunction() to JNI and demonstrate it with a test. (check-in: c653bf16cb user: stephan tags: jni) | |
| 01:28 | Start adding fts5_api to JNI. (check-in: 14d18fe983 user: stephan tags: jni) | |
| 00:40 | Bind the remaining Fts5ExtensionApi methods to JNI, noting that all are completely untested because the higher-level bits needed to do so are still missing. (check-in: 23383c1dfd user: stephan tags: jni) | |
|
2023-08-04
| ||
| 16:01 | In the opfs-sahpool VFS's importDb() and exportFile() methods, throw if the actually-wrote/read amounts differ from the expected-to-write/read amounts, per feedback in forum post a4122e986f. (check-in: a617ebf4e5 user: stephan tags: trunk) | |
| 15:38 | More work on the JNI binding of fts5 customization (still a long ways to go). (check-in: 1a246fd216 user: stephan tags: jni) | |
| 13:29 | Merge the json_remove() bug fix from trunk into the bedrock branch. (check-in: a8872aa588 user: drh tags: bedrock) | |
| 13:27 | Eliminate code duplication in the two JNI tester classes. (check-in: 63e7bbe3d5 user: stephan tags: jni) | |
| 13:24 | Merge the json_remove() bug fix from trunk into the wal2 branch. (check-in: e6c066cae4 user: drh tags: wal2) | |
| 13:19 | Fix a bug in the jsonLookup() routine used to search JSON. Bug was introduced by the recent (unreleased) JSON caching enhancements check-in [a4c1af616e672a0d] merged into trunk at [df099ad713011b67]. (check-in: ba7a66db13 user: drh tags: trunk) | |
| 13:03 | FTS-related JNI refactoring. Move FTS-specific tests into their own class and dynamically load it, if possible, from the main test app. (check-in: b7a8428fcd user: stephan tags: jni) | |
| 12:44 | More work towards binding FTS5 customization to JNI. Add Fts*.java files missing from previous checkin. (check-in: 91263178f4 user: stephan tags: jni) | |
| 11:10 | Change comment on Fts5ExtensionApi.iVersion from "always set to 3" to "always set to 2". (check-in: b7de399c27 user: dan tags: trunk) | |
| 11:08 | Start including fts5 customization bits into JNI, but it's far from functional. (check-in: abaf5edd04 user: stephan tags: jni) | |
| 09:53 | Improve internal error handling in the JNI create_function() impl. (check-in: 2c88390faa user: stephan tags: jni) | |
| 08:45 | Resolve the timing/ordering issue of a JS-to-WASM-converted xDestroy() function being uninstalled from WASM right before the underlying native call tries to call it. This has been a long-unnoticed bug which appears only when removing such functions or replacing them. (check-in: 031c9a76b6 user: stephan tags: trunk) | |
| 08:41 | Part 2 of the fix from [a0f808363318c00fd1db78b]. (check-in: 5c3104228d user: stephan tags: trunk) | |
| 08:39 | More work towards fts5 customzation in JS. (Leaf check-in: ce2a65d80f user: stephan tags: wasm-fts5) | |
|
2023-08-03
| ||
| 23:26 | Merge the latest trunk enhancements into the bedrock branch. (check-in: 877ffece05 user: drh tags: bedrock) | |
| 23:22 | Merge the latest trunk enhancements into the wal2 branch. (check-in: 6fa71e1119 user: drh tags: wal2) | |
| 22:43 | Minor internal cleanups in the JS-side fts5 cleanup steps. (check-in: 2666f52e88 user: stephan tags: wasm-fts5) | |
| 21:14 | Retain all xDestroy method WASM proxies created for fts5_api::xCreateFunction() until the db is closed, then free them all at once. (check-in: f4b9743abd user: stephan tags: wasm-fts5) | |
| 20:45 | Rework the fts5 db-close cleanup to avoid that fts5 internally calls a just-unbound-from-wasm xDestroy() method. There is still work to do here to cover the case of fts5 functions being replaced (in which all xDestroy methods have to be retained until the db is closed). (check-in: 795f22421b user: stephan tags: wasm-fts5) | |
| 20:02 | Part 2 of the fix from [a0f808363318c00fd1db78b]. (check-in: ce0674b192 user: stephan tags: wasm-fts5) | |
| 18:46 | Resolve the timing/ordering issue of a JS-to-WASM-converted xDestroy() function being uninstalled from WASM right before the underlying native call tries to call it. This has been a long-unnoticed bug which appears only when removing such functions or replacing then. (check-in: a0f8083633 user: stephan tags: wasm-fts5) | |
| 18:14 | Fix harmless scan-build warnings. (check-in: 65a8716d8a user: drh tags: trunk) | |
| 16:22 | Fix a discrepancy between sqlite3_values_to_js() and its API docs/intended behavior. (check-in: 7b85c68fe2 user: stephan tags: trunk) | |
| 16:21 | More infrastructure towards binding FTS5 customization support to WASM. (check-in: 163e3e44b1 user: stephan tags: wasm-fts5) | |
| 16:02 | Fix a discrepancy between sqlite3_values_to_js() and its API docs/intended behavior. (check-in: 16658b3c64 user: stephan tags: wasm-fts5) | |
| 13:30 | Fix build problems associated with SQLITE_OMIT_WSD and SQLITE_OMIT_TRIGGER. (check-in: de031a5ec8 user: drh tags: trunk) | |
| 13:07 | Fix a test case whose value changes under the no_optimization permutation due to the recent change to add the ability for SQLITE_TESTCTRL_OPTIMIZATION to disable one-pass. (check-in: 976e39c632 user: drh tags: trunk) | |
| 12:41 | Unix builds now assume the presence of nanosleep() in the standard library. The -DHAVE_NANOSLEEP=0 compile-time option can be used to build on systems (if any still exist) where this is not the case. (check-in: 779d5dc879 user: drh tags: trunk) | |
| 07:20 | Initial work on exposing the FTS5 APIs to wasm, per request in the forum. This builds and loads the structs into JS but is completely untested. (check-in: 52c8b73ae3 user: stephan tags: wasm-fts5) | |
|
2023-08-02
| ||
| 18:20 | If a query has an ORDER BY clause that only refers to result columns of the left-most table and the left most table is a MATERIALIZED common table expresion, then attempt to push the ORDER BY clause down into the subquery. (Leaf check-in: 8e7a70b2bb user: drh tags: order-by-push-down) | |
| 17:29 | More JNI-internal docs. Correct handling of a Java exception if a trace callback throws. (check-in: 306b269a01 user: stephan tags: jni) | |
| 17:20 | Internal doc additions in the JNI bits. (check-in: b56643644e user: stephan tags: jni) | |
| 16:06 | Performance optimization for JSON rendering logic. (check-in: ea0b9aecba user: drh tags: trunk) | |
| 13:45 | Remove an unreachable branch in the ascii-to-floating-point conversion that was added by [e989a37ff9d5b52e]. (check-in: c4347e4400 user: drh tags: trunk) | |
| 13:38 | Stricter enforcement of the idea that a MATERIALIZED common table expression is an optimization fence. (check-in: 354425f8d9 user: drh tags: trunk) | |
| 13:29 | Remove a condition from query flattening that is now taken care of by the caller. Factor out the reverse_unordered_selects processing from the main loop of sqlite3WhereBegin() for performance. (Closed-Leaf check-in: f068f105fb user: drh tags: materialize-order-by) | |
| 12:39 | Simplify the select.c logic that enforces the optimization fence around a MATERIALIZED common table expression. Do not allow the reverse_unordered_selects setting to affect a fenced CTE that itself has an ORDER BY clause. (check-in: 165b9bda24 user: drh tags: materialize-order-by) | |
| 11:06 | Never flatten a CTE that is labeled MATERIALIZED. This is really something of a bug fix because the documentation says that a MATERIALIZED CTE is an optimization barrier. (check-in: b7ef9796f5 user: drh tags: materialize-order-by) | |
| 00:09 | When a query is inside an AS MATERIALIZED CTE, do not attempt the omit-ORDER-BY optimization. If the developer specifies MATERIALIZED, that means he wants the sort to actually happen. (check-in: aa769ee747 user: drh tags: materialize-order-by) | |
|
2023-08-01
| ||
| 19:10 | Avoid ASAN warnings when converting over-sized long double values into double. (check-in: e989a37ff9 user: drh tags: trunk) | |
| 16:41 | Filter the wasmfs-specific JS module result type check out of non-wasmfs builds. (check-in: ef7c121049 user: stephan tags: trunk) | |
| 16:38 | Fix part 2 of 2 for /fiddle: a make deps problem which caused fiddle to load but fail to run when sqlite3.c was missing. (check-in: 6011bc2676 user: stephan tags: trunk) | |
| 16:17 | Fix part 1 of 2 for /fiddle not running: build flags which were renamed during refactoring. (check-in: 214ffeeff7 user: stephan tags: trunk) | |
| 11:03 | Fix an assert() in fts5_index.c that might fail when dealing with corrupt records. (check-in: aa55c83f35 user: dan tags: trunk) | |
| 10:19 | More docs for the Java side of the JNI bindings. (check-in: d8e9bcee96 user: stephan tags: jni) | |
| 09:44 | Internal exception-handling cleanups in the JNI bindings. (check-in: 057b1d4f6f user: stephan tags: jni) | |
| 08:48 | Minor JNI-related doc tweaks and code re-ordering. (check-in: b663b27e42 user: stephan tags: jni) | |
| 01:07 | Remove redundant comparison operator. (check-in: 0189843298 user: drh tags: trunk) | |
| 00:34 | Restore part of the UPDATE one-pass optimization that was removed by check-in [2c56b984a0bd3be5]: only disable one-pass if the WHERE clause contains a subquery. Allow subqueries in the SET expressions. Fix for performance problem reported by forum post 8ab195fd44e75ed0. (check-in: 42916af9fc user: drh tags: trunk) | |
|
2023-07-31
| ||
| 22:03 | Restrict the new column cache to table-btree, which is the common case anyhow. That way, writes to indexes do not need to clear the column cache. (check-in: 659284ab0e user: drh tags: trunk) | |
| 20:02 | The original column-cache implementation from check-in [ab1edcc7fedcf279] (merged to trunk at [771fe35074b50b8d]) is unsound. This check-in fixes the issue. Had to give back a little performance, the optimization is still a overall win. (check-in: ec95e970fb user: drh tags: trunk) | |
| 17:39 | Add bit to sqlite3_test_control(SQLITE_TESTCTRL_OPTIMIZATIONS) that will disable the one-pass optimizating in DELETE and UPDATE. (check-in: 22f6dd5cd3 user: drh tags: trunk) | |
| 17:20 | Improved debug tracking of the Parse.nQueryLoop value. (check-in: 4a8a17498e user: drh tags: trunk) | |
| 13:52 | Experimentally change the JNI sqlite3_trace_v2() callback type to have more convenient access to the current Java-side sqlite3_stmt at the cost of some uncomfortably fiddly current-statement tracking in the JNI layer. Subject to change. (check-in: 459db332af user: stephan tags: jni) | |
| 12:10 | Add some JNI-internal metrics, accessible via passing -v when running Tester1.java. Document an OpenJDK bug which leads to incorrect -Xlint:jni warnings. (check-in: a5d68a6b64 user: stephan tags: jni) | |
| 10:55 | Correct a mis-cast in the JNI wrapper which just happened to accidentally work. Update JNI binding of sqlite3_context_db_handle() to return the bound-at-open() db instance instead of a new/temp proxy object. (check-in: 9faca5d9ed user: stephan tags: jni) | |
| 10:42 | Add another test for JNI-bound scalar UDFs. (check-in: 8b322d92e2 user: stephan tags: jni) | |
| 10:22 | Update some internal docs for the past two checkins. Add a way to dump out some debug info about the current JNI environment. (check-in: ac9b8bb1e6 user: stephan tags: jni) | |
| 10:08 | Refactor the busy-handler-specific JNI hook type to use the generic hook type. (check-in: d9efdc6dd2 user: stephan tags: jni) | |
| 09:45 | Refactor the collation-specific JNI hook type to use the generic hook type. (check-in: 02c1d3b650 user: stephan tags: jni) | |
| 09:28 | Internal JNI doc tweaks. (check-in: f4aa2c8288 user: stephan tags: jni) | |
| 07:15 | Consolidate triplicated xDestroy()-calling code. Remove some unnecessary casts. (check-in: 24c0763d0e user: stephan tags: jni) | |
|
2023-07-30
| ||
| 18:41 | Internal JNI API renaming. (check-in: fcfc070673 user: stephan tags: jni) | |
| 17:24 | Internal JNI refactoring towards consolidating support for callbacks with and without finalizers. (check-in: 120983a570 user: stephan tags: jni) | |
| 13:47 | Mark the Java wrapper classes of the C-native types as 'final' (cannot be subclassed). (check-in: 4fd3d93623 user: stephan tags: jni) | |
| 13:30 | Minor tweaks and optimizations in the JNI bindings. (check-in: 41fb5898f1 user: stephan tags: jni) | |
| 11:36 | Bind sqlite3_collation_needed() to JNI. Related adjacent cleanups and fixes. (check-in: 16ff167691 user: stephan tags: jni) | |
| 10:47 | Internal JNI refacoring to support the pending sqlite3_collation_needed() callback. Correct a bug in the linked-list handling of PerDbStateJni which triggered an assert(). (check-in: 7ac6614e69 user: stephan tags: jni) | |
| 09:45 | Incremental checkin to minimize the diff while narrowing in on an assertion caused by refactoring. (check-in: 2d7a91b139 user: stephan tags: jni) | |
| 08:12 | Consolidate some warnings for java callbacks which must not throw but do. (check-in: 5e592ed2df user: stephan tags: jni) | |
| 07:44 | Bind sqlite3_update_hook() to JNI. (check-in: a5bbaa9017 user: stephan tags: jni) | |
| 06:44 | Bind sqlite3_rollback_hook() to JNI. (check-in: 5f8ee44098 user: stephan tags: jni) | |
| 06:00 | Add commit hook failure to JNI tests. (check-in: be4459b495 user: stephan tags: jni) | |
| 05:50 | Bind sqlite3_commit_hook() to JNI. (check-in: c687297fca user: stephan tags: jni) | |
| 04:31 | Bind sqlite3_progress_handler() to JNI. Add some metrics to Tester1.java. (check-in: 437ecfe8ab user: stephan tags: jni) | |
| 03:54 | Add tests for SAHPoolUtil.exportFile() and importDb(). (check-in: 4aa88b8fb1 user: stephan tags: trunk) | |
|
2023-07-29
| ||
| 22:58 | Do not try to add MEM_Term to an MEM_Static string either. (check-in: 8920dcef1f user: drh tags: trunk) | |
| 21:22 | Do not try to apply MEM_Term to a MEM_Ephem strings. (check-in: 2a378a6678 user: drh tags: trunk) | |
| 20:13 | Fix a buffer overread in the fts5_structure virtual table (test code). (check-in: b837aff79c user: dan tags: trunk) | |
| 17:05 | Simplification to the sqlite3_stmt_explain() implementation. (check-in: dd5eb4c7f7 user: drh tags: trunk) | |
| 15:53 | SAHPoolUtil.importDb() now accepts either a byte array or ArrayBuffer. (check-in: 3848f04e54 user: stephan tags: trunk) | |
| 15:31 | Enhancements to the new sqlite3_stmt_explain() interface implementation and documentation. (check-in: dc98ac6b6d user: drh tags: trunk) | |
|
2023-07-28
| ||
| 21:38 | Fix doc error noted in the forum and a misspelling. (check-in: 6b79cc7dd0 user: larrybr tags: trunk) | |
| 20:59 | Do not allow the same JSON parse to be input to both arguments to the json_patch() routine. (check-in: 8e781c6742 user: drh tags: trunk) | |
| 19:07 | Merge the latest trunk enhancements into the wal-shm-exceptions branch. (check-in: c44fb4d065 user: drh tags: wal-shm-exceptions) | |
| 19:00 | Merge the latest trunk enhancements into the reuse-schema branch. (check-in: b8731493bf user: drh tags: reuse-schema) | |
| 18:52 | Merge the latest trunk enhancements into the bedrock branch. (check-in: 1d6ded3234 user: drh tags: bedrock) | |
| 18:47 | Merge the latest trunk enhancements into the wal2 branch. (check-in: c1fa1cb5e0 user: drh tags: wal2) | |
| 18:44 | Internal JNI binding docs. (check-in: 991c66197e user: stephan tags: jni) | |
| 18:43 | Merge the latest trunk enhancements into the begin-concurrent branch. (check-in: 7407dda8b4 user: drh tags: begin-concurrent) | |
| 18:37 | Add the sqlite3_stmt_explain() API. (check-in: 0443c0ef85 user: drh tags: trunk) | |
| 18:02 | Fix an incorrect file path in ext/jni/README.md (check-in: bcefa2df56 user: stephan tags: jni) | |
| 16:12 | Minor tweaks to the JSON performance measurement documentation. (check-in: 0bed957e46 user: drh tags: trunk) | |
| 15:58 | Fix minor typos in the JNI README.md file. (check-in: e21cf2e8f1 user: drh tags: jni) | |
| 14:20 | Enhancements to the JSON performance testing scripts and instructions to cover the recent optimizations involving updates to large JSON strings that indexed. (check-in: f9213289d0 user: drh tags: trunk) | |
| 13:52 | JSON performance improvements: (1) Add a cache for large string values on OP_Column to avoid having to extract the string multiple times. (2) Internal JSON caching improvements. (check-in: 771fe35074 user: drh tags: trunk) | |
| 12:59 | A failed attempt to add a new sqlite3_result_zeroterminated() interface that is a hint to SQLite that a TEXT result does have a zero terminator. The idea is to avoid unnecessary copying of TEXT values. This seems like an unnecessary complication at the moment, but maybe I'll return to this later. Note that this check-in does not work - it is a proof of concept only. (Closed-Leaf check-in: a0de01108c user: drh tags: sqlite3_result_zeroterminated) | |
| 11:52 | Correct a recently-introduced falsehood in ext/wasm/README.md regarding ssh port forwarding. (check-in: 2a3f3a9cf2 user: stephan tags: trunk) | |
| 11:30 | Mark an unreachable branch as ALWAYS(). (Closed-Leaf check-in: 8fd06d1151 user: drh tags: json-opt) | |
| 10:37 | Minor java cleanups recommended by a modern IDE. (check-in: f92a9bbabe user: stephan tags: jni) | |
| 10:01 | Add Java tests which ensure that xFinal() is called with no aggregate context when the result set is empty. (check-in: 7ac8c66a6b user: stephan tags: jni) | |
| 09:54 | Tweaks to the Java-side UDF docs. (check-in: 48e0079d8d user: stephan tags: jni) | |
| 09:25 | More Java docs about making use of the aggregate context. Change the JNI mapping to set the sqlite3_context::aggregateContext member directly, instead of via a superflous setter, because that way is faster. (check-in: 7af0cb998f user: stephan tags: jni) | |
| 01:51 | More docs and cleanups related to the aggregate UDF state. Correct the OOM check to behave properly if xFinal() is called without a matching xStep(), xValue(), or xInverse(). (check-in: ff53f1ccdc user: stephan tags: jni) | |
| 01:19 | Add an OOM check to the previous check-in. Minor internal API renaming. (check-in: 6b56e4d62b user: stephan tags: jni) | |
| 01:12 | Add support making use of sqlite3_aggregate_context() (in a roundabout way) from Java to accumulate state within aggregate and window UDFs. (check-in: 6405749847 user: stephan tags: jni) | |
| 00:54 | Remove some unnecessary and incorrect code that was mistakenly added in the previous check-in. (check-in: d3f458dcc3 user: drh tags: json-opt) | |
|
2023-07-27
| ||
| 23:51 | Switch to using jsonParseCached() for json_patch(). (check-in: 2ed9c59e6a user: drh tags: json-opt) | |
| 22:53 | Reformulate jni tests to not require the -ea jvm flag to enable assert(). (check-in: dc356667a8 user: stephan tags: jni) | |
| 22:42 | Add locking test for BusyHandler and clear up new -Xlint:jni warnings introduced by the busy-handler binding. (check-in: 7dcde2bfce user: stephan tags: jni) | |
| 22:05 | Bind sqlite3_busy_handler(). Correct mapping of pointers for, and cleanup of, JNI-level per-db state. (check-in: 524747796a user: stephan tags: jni) | |
| 20:32 | Replace some www: interwiki references in the JNI readme with their full URLs to make the doc more portable. (check-in: 63ce0c9bdd user: stephan tags: jni) | |
| 20:28 | If the input JSON to a json function that uses cache comes from an RCStr value, then use that RCStr value in the parse rather than making a copy. (check-in: 509ae9c147 user: drh tags: json-opt) | |
| 20:12 | Merge trunk into jni branch for compiler warning fixes. (check-in: 0514fd340a user: stephan tags: jni) | |
| 20:08 | Fix a couple of compiler warnings in fts5_index.c. (check-in: bf71faa2a1 user: dan tags: trunk) | |
| 20:02 | Initial check-in of JNI (Java Native Interface) bindings for the core C API. (check-in: b5374b9ef5 user: stephan tags: jni) | |
| 19:39 | The OP_Column opcode caches large column values coming from overflow pages. (check-in: ab1edcc7fe user: drh tags: json-opt) | |
| 19:13 | Add the contentless_delete=1 option to fts5. For creating contentless tables that support DELETE and REPLACE statements. (check-in: d66b182d2b user: dan tags: trunk) | |
| 18:19 | Merge trunk enhancements into the json-opt branch. (check-in: 5739a16ad2 user: drh tags: json-opt) | |
| 17:50 | Dynamically determine whether the wasm.xWrap() argc check can be applied, depending on how the wasm environment exposes its exports. (check-in: fd59226b34 user: stephan tags: trunk) | |
| 15:00 | Dynamically determine whether the wasm.xWrap() argc check workaround for JSPI is necessary, instead of baking it in to JSPI builds. (Edit: closing jspi branch. Introducing JSPI would require making parts of the C API wrapper async.) (Closed-Leaf check-in: 86bb464f31 user: stephan tags: jspi) | |
| 01:38 | Accommodate a breaking change in emcc 3.1.44. (check-in: 2c5dd34199 user: stephan tags: trunk) | |
| 01:35 | Accommodate a breaking change in emcc 3.1.44. (check-in: 4ce3860300 user: stephan tags: jspi) | |
| 00:21 | Fix a performance regression in JSON associated with generating small snippets of JSON from a larger JSON string. See forum thread 15d6bd9cd37202a7. (check-in: 837f2907e1 user: drh tags: trunk) | |
|
2023-07-26
| ||
| 23:22 | Reduce the number of memory allocations when parsing JSON. (check-in: 9edd671621 user: drh tags: trunk) | |
| 21:53 | Minor changes to make coverage testing easier. (check-in: ec8b43382e user: drh tags: trunk) | |
| 19:22 | Change a switch() case to default for coverage. (check-in: 04f497074b user: drh tags: trunk) | |
| 19:11 | Make sure jsonReplaceNode() always leaves the JsonParse in a consistent state even if an error is encountered. (check-in: 01d52232dd user: drh tags: trunk) | |
| 18:34 | Add a comment describing the contents of the ExceptionInformation[] array for win32 EXCEPTION_IN_PAGE_ERROR exceptions. No changes to code. (check-in: 8e20354242 user: dan tags: wal-shm-exceptions) | |
| 18:13 | Make sure jsonReplaceNode() always leaves the JsonParse in a consistent state even if an error is encountered. (Closed-Leaf check-in: 29c7b1cbc4 user: drh tags: mistake) | |
| 18:11 | Initial experimentation with getting JSPI (JavaScript Promise Integration) support working. It builds, but requires disabling func argument count validation checks on sqlite3.wasm.xWrap()-processed exports and it crashes cryptically in wasm when the tests are run. (check-in: 5b178f92f5 user: stephan tags: jspi) | |
| 17:51 | Add the ".scanstats vm" command to the shell tool. For profiling VM code in SQLITE_ENABLE_STMT_SCANSTATUS builds. (check-in: 0cbec3990d user: dan tags: trunk) | |
| 16:41 | Improve the output when ".scanstats vm" is enabled. (Closed-Leaf check-in: 7df08fd35e user: dan tags: scanstatus-exp) | |
| 14:18 | Improved caching and reuse of JSON parses. (check-in: df099ad713 user: drh tags: trunk) | |
| 13:17 | Change the debugging "json_parse(X)" function so that it shows a more complete description of the JsonParse object on standard output and returns the mimified JSON. Former behavior was to return the text of a decode of the aNode array. (check-in: 1bf85d4e38 user: drh tags: json-opt) | |
| 11:53 | More comment improvements in json.c. Do not run jsonLookup() following an OOM error. (check-in: cd5fda8c2e user: drh tags: json-opt) | |
| 11:43 | Improved comments and other cleanup for the changes on this branch. (check-in: bac953a80d user: drh tags: json-opt) | |
| 11:41 | Remove the batch SQL runner from the JS build's 'all' target, as it's long-since unused and adds noticable build time. Add makefile comments about JSPI. (check-in: b8f708e35d user: stephan tags: trunk) | |
| 11:11 | Add SAHPoolUtil.getFileNames() method, and tests for it, per forum feedback. Add a test to demonstrate that two SAH pools can coexist so long as they have different names. (check-in: 72dc3f8c32 user: stephan tags: trunk) | |
| 11:00 | Fix jsonForceRCStr() to also add the NULL terminator. (check-in: 134b01f37f user: drh tags: json-opt) | |
| 07:57 | Reformulate [907dfc4a7aa1] using awk instead of sed for better cross-platform portability. (check-in: 82ff7cc6a4 user: stephan tags: trunk) | |
| 01:15 | Merge the latest trunk fixes into the json-opt branch. (check-in: ef4e1664d1 user: drh tags: json-opt) | |
| 01:12 | Add the concept of an RCStr string - a "Reference Counted String". Use these to keep track of big JSON strings that might need to be used in multiple places at the same time with different lifetimes. Add two different JSON string values to each parse - one with and one without changes. The net result is a large reduction in the number of parses that occur when doing an UPDATE of a indexed JSON field using json_replace() or similar. (check-in: a4c1af616e user: drh tags: json-opt) | |
| 01:05 | Extend the enhancement to json_set() and json_replace(). Clean up cruft. (Closed-Leaf check-in: 2dbb22c75e user: drh tags: json-opt-rcstr) | |
| 00:48 | Add the JsonParse.zAlt field to old revised JSON text after a change. Demonstrate that this elminates the need for reparsing after a change by using it in the json_remove() function. This is an incremental check-in containing lots of cruft. (check-in: f930b139d6 user: drh tags: json-opt-rcstr) | |
|
2023-07-25
| ||
| 20:26 | Clarify ownership of the various objects involved in parsing JSON. (check-in: afe02a398a user: drh tags: json-opt-rcstr) | |
| 18:28 | Incremental improvements to JSON parsing - trying to fold in the RCStr object. (check-in: 4cb15d934a user: drh tags: json-opt-rcstr) | |
| 17:54 | Fix a harmless "set-but-not-used" compiler warning in sqlite3session.c. (check-in: 54b3c43fdf user: dan tags: trunk) | |
| 17:11 | Merge trunk changes into this branch. (Closed-Leaf check-in: 719973d7f5 user: dan tags: fts5-contentless-delete) | |
| 16:48 | Add extra test for 'deletemerge'. (check-in: bc33cff420 user: dan tags: fts5-contentless-delete) | |
| 15:48 | Change the name of the fts5 'delete-automerge' option to 'deletemerge'. And add tests for it. (check-in: 1079300db2 user: dan tags: fts5-contentless-delete) | |
| 15:43 | Fix a minor problem with error reporting in JSON. (check-in: c456e4a899 user: drh tags: json-opt-rcstr) | |
| 15:08 | Create the new RCStr class of strings and try to use them for JSON storage. (check-in: c1b8725089 user: drh tags: json-opt-rcstr) | |
| 13:53 | Further tests for 'delete-automerge'. (check-in: ca26c7a37a user: dan tags: fts5-contentless-delete) | |
| 12:26 | Reformulate a (sed -i) construct in ext/wasm/GNUmakefile to account for Mac's sed -i being different than GNU's. (check-in: 907dfc4a7a user: stephan tags: trunk) | |
| 00:13 | First attempt to cache modified JSON parses. Does not work. This is an incremental check-in. (Leaf check-in: 075eb09a4f user: drh tags: json-opt-wcache1) | |
|
2023-07-24
| ||
| 23:27 | It is an error to try to insert a BLOB value into JSON. (check-in: 28c6e964b1 user: drh tags: json-opt) | |
| 22:45 | Clean up some #defines in json. (check-in: 327fff501e user: drh tags: json-opt) | |
| 22:34 | Rework the JSON parse structure to facilitate better caching. Passes all tests. (check-in: ecdcb1ded7 user: drh tags: json-opt) | |
| 19:13 | Add the fts5 'delete-automerge' integer option. A level is eligible for auto-merging if it has a greater than or equal percentage of its entries deleted by tombstones than the 'delete-automerge' option. Default value is 10. (check-in: b314be66b9 user: dan tags: fts5-contentless-delete) | |
| 17:59 | Incremental progress toward improved caching of parsed JSON. (check-in: f2c0638846 user: drh tags: json-opt) | |
| 15:41 | Resolve an ES6 module export construct which is incompatible with node.js, as reported in forum post b9680fa9ad. (check-in: 80927c3913 user: stephan tags: trunk) | |
| 13:30 | Merge the latest trunk enhancements into the reuse-schema branch. (check-in: e0e7b01e27 user: drh tags: reuse-schema) | |
| 13:24 | Merge the latest trunk enhancements into the bedrock branch. (check-in: a6f3443994 user: drh tags: bedrock) | |
| 13:20 | Merge the latest trunk enhancements into the wal2 branch. (check-in: b2e56f62ad user: drh tags: wal2) | |
| 13:15 | Merge the latest trunk enhancements into the begin-concurrent branch. (check-in: 967be041ea user: drh tags: begin-concurrent) | |
| 12:59 | Update the latest trunk enhancements into the wal-shm-exceptions branch. (check-in: 3187ee3f69 user: drh tags: wal-shm-exceptions) | |
| 12:37 | Merge the latest trunk enhancements into the json-opt branch. (check-in: 00bfc4918b user: drh tags: json-opt) | |
|
2023-07-23
| ||
| 22:14 | When writing the filename header in a opfs-sahpool file, ensure that all remaining bytes in that part of the header are zeroed out to avoid the downstream problems reported in forum post d50ec48a293988a5. (check-in: c1b080e393 user: stephan tags: trunk) | |
|
2023-07-22
| ||
| 19:57 | Add the opfs-sahpool sqlite3_vfs implementation to JS, offering an alternative to the other OPFS VFS (with tradeoffs). (check-in: d2e602cda4 user: stephan tags: trunk) | |
| 19:47 | Integrate contentless delete with auto-merge. (check-in: 85c1589ab1 user: dan tags: fts5-contentless-delete) | |
| 16:37 | Do not read past the end of a text buffer looking for a zero terminator, as that space might not be initialized. If the buffer is owned, just set the null terminator. This is a better fix for the OSSFuzz-detected use-of-initialized-value problem. (check-in: 931bccb0cc user: drh tags: trunk) | |
| 15:21 | Fix a harmless use-of-initialized-value warning from OSSFuzz that results from recent large string optmizations. (check-in: 1a6b3dd1c4 user: drh tags: trunk) | |
|
2023-07-21
| ||
| 22:28 | Performance enhancements for queries using very large string values. (check-in: 3661b9cd98 user: drh tags: trunk) | |
| 22:22 | Mark an unreachable branch as NEVER(). (Leaf check-in: 414a4d660c user: drh tags: big-function-text) | |
| 21:10 | Fix fts5 incremental optimization so that it too can handle an index that consists of a single segment with one or more tombstone hash pages. (check-in: e61c9b083f user: dan tags: fts5-contentless-delete) | |
| 19:33 | Ensure the fts5 'optimize' command correctly rewrites any index that consists of a single segment and one or more tombstone hash pages. (check-in: f4926006b3 user: dan tags: fts5-contentless-delete) | |
| 19:17 | Fix harmless compiler warning introduced by the previous check-in. (check-in: 06f829e9e5 user: drh tags: big-function-text) | |
| 18:38 | Avoid a potentially large strlen() in sqlite3DecOrHexToI64(). (check-in: 5413b02bb6 user: drh tags: big-function-text) | |
| 18:09 | Further improvements to large string handling in relation to JSON. (check-in: 1e5df0aa3d user: drh tags: big-function-text) | |
| 15:07 | Fix harmless compiler warning about signed/unsigned comparison. (check-in: 75cc3c89ee user: drh tags: big-function-text) | |
| 15:01 | Multiple optimizations that try to preserve or infer the zero-terminated property of TEXT values. Avoid unnecessary copying of text values destined to become function parameters. All changes help improve performance of doing UPDATEs on large JSON values that are indexed multiple ways. (check-in: d0278cdedf user: drh tags: big-function-text) | |
| 11:09 | More infrastructure changes towards improving JSON cache performance. Incremental check-in. (check-in: 1955e66cfc user: drh tags: json-opt) | |
| 10:51 | Minor internal cleanups in the opfs-sahpool VFS. (Closed-Leaf check-in: 74ad31e290 user: stephan tags: opfs-sahpool) | |
| 09:10 | Internal cleanups in the async part of the JS library bootstrap phase. (check-in: b6d57ab637 user: stephan tags: opfs-sahpool) | |
|
2023-07-20
| ||
| 23:25 | Minor internal cleanups in JS code. (check-in: 21a2ca9fc4 user: stephan tags: opfs-sahpool) | |
| 20:29 | Fix some divide-by-zero errors that could occur when handling corrupt tombstone hash records. (check-in: 7567ca0676 user: dan tags: fts5-contentless-delete) | |
| 20:09 | Avoid an infinite loop that could be entered when dealing with corrupt fts5 tombstone hash pages. (check-in: 69ce2ce035 user: dan tags: fts5-contentless-delete) | |
| 17:45 | Experimental framework upon which to build a better JSON parse structure that supports cached of modified JSON. All of these changes are tentative and subject to change or removal. Incremental check-in. (check-in: e384163a47 user: drh tags: json-opt) | |
| 16:07 | Add tests and fixes for the new code on this branch. (check-in: 5aac50e92e user: dan tags: fts5-contentless-delete) | |
| 09:06 | Filter the OPFS VFSes out of the sqlite3-node.mjs build. Add another level of subdirectory to the sahpool to later enable transparent support of client-provided files under the VFS's root dir. Rework the awkward sahpool-via-oo1 mapping. (check-in: 080a4d0aba user: stephan tags: opfs-sahpool) | |
|
2023-07-19
| ||
| 23:02 | Performance enhancements to the JSON parser and code generator. (check-in: 0a745897d6 user: drh tags: trunk) | |
| 20:23 | Revise the new JSON parser performance test to make the test run 25 times longer, and thus provide a more repeatable number. (check-in: bee9e403ae user: drh tags: trunk) | |
| 19:23 | Describe JSON parser performance testing procedure in test/json/README.md (check-in: c47056e158 user: drh tags: trunk) | |
| 18:47 | Fix various issues with code added to this branch. (check-in: 8d09011fa2 user: dan tags: fts5-contentless-delete) | |
| 17:47 | More internal refactoring and docs for opfs-sahpool. (check-in: 64ccf6177a user: stephan tags: opfs-sahpool) | |
| 17:46 | Update the development-over-ssh docs for the wasm build. (check-in: 500109bd0a user: stephan tags: opfs-sahpool) | |
| 17:24 | Further improvement to JSON parser performance. (check-in: 144c8ccf6e user: drh tags: json-opt) | |
| 15:06 | Further performance enhancements to JSON parsing and rendering. Total performance gain for large JSONs so far on this branch is about 11%. (check-in: adb4d6b007 user: drh tags: json-opt) | |
| 13:50 | Performance optimization for parsing large JSONs that contain lots of text. (check-in: c9fbe0185c user: drh tags: json-opt) | |
| 13:31 | Major restructuring of opfs-sahpool to improve maintainability and hopefully make it easier to reuse these pieces in the upcoming JSPI-based VFS experiment. (check-in: 534481cd0c user: stephan tags: opfs-sahpool) | |
| 12:52 | Enhance the JSON parser cache such that it is able to extract lines from the cache and use them for writing, though they then have to be evicted from the cache. This was an experiment in trying to reduce the amount of parsing needed for a big UPDATE, but it does not seem to help any. Retained for reference only. (Closed-Leaf check-in: 2e6fbebc41 user: drh tags: json-write-cache) | |
| 11:33 | Appearance and legibility improvements for tester1.js. (check-in: 4fd3ed1b64 user: stephan tags: opfs-sahpool) | |
| 10:17 | Merge the latest trunk enhancements into the sqlite3_stmt_explain branch. (Closed-Leaf check-in: 06eae046c1 user: drh tags: sqlite3_stmt_explain) | |
| 09:52 | Two minor improvements to sum(), one of which was inspired by forum post af5be98dbc. (check-in: a0d3e7571a user: drh tags: trunk) | |
| 08:18 | Internal refactoring in opfs-sahpool. Move OPFS tests to the end of tester1.c-cpp.js. (check-in: 6bd5a7413d user: stephan tags: opfs-sahpool) | |
|
2023-07-18
| ||
| 21:06 | Do not use the viewscan optimization on a query that has only a single loop, as the cost adjustments can cause problems for outer queries. Proposed fix for the performance regression reported by forum post 64d36440e473516c. (check-in: 76152ad2ff user: drh tags: trunk) | |
| 20:41 | Improved ".wheretrace" for the VIEWSCAN optimization. (check-in: 27057ea76b user: drh tags: trunk) | |
| 19:52 | Fix various problems with fts5 contentless_delete=1 tables. (check-in: 0d005112b8 user: dan tags: fts5-contentless-delete) | |
| 19:47 | More opfs-sahpool tests. (check-in: 60713fa9c4 user: stephan tags: opfs-sahpool) | |
| 19:27 | Fix a shadowed var in opfs-sahpool and add more tests. (check-in: 9c8a73aff0 user: stephan tags: opfs-sahpool) | |
| 18:52 | Further refactoring of opfs-sahpool and start integrating it into tester1.c-pp.js. (check-in: 91c7892349 user: stephan tags: opfs-sahpool) | |
| 17:43 | Merge the FTS5 memory leak fix from trunk. (check-in: fb65cb73d7 user: drh tags: fts5-contentless-delete) | |
| 17:29 | Enhance the sqlite3_stmt_explain() interface so that avoids unnecessary reprepare operations. (check-in: 050f773add user: drh tags: sqlite3_stmt_explain) | |
| 16:29 | Fix memory leak in fts5 introduced by [def41225]. (check-in: 4dcad2db74 user: dan tags: trunk) | |
| 16:24 | Major restructuring of the opfs-sahpool bits to better support multiple instances per app (each sandboxed from each other). Eliminate the pesky promise resolution race condition when two such instances are loaded in parallel. (check-in: 95e5fa498f user: stephan tags: opfs-sahpool) | |
| 15:06 | Experimental (untested, non-working) changes that try reduce the number of reprepares generated by sqlite3_stmt_explain(). I think I see an easier way to do this now, so I'm parking this experiment on a branch to pursue the new idea. (Closed-Leaf check-in: c2fba6a632 user: drh tags: sqlite3-stmt-explain-opt1) | |
| 13:55 | Merge trunk changes with this branch. (check-in: 5f66eb4e26 user: dan tags: fts5-contentless-delete) | |
| 13:55 | Fix a buffer overrun in fts5 that could occur in 'secure-delete' mode when dealing with corrupt database records. (check-in: def41225b2 user: dan tags: trunk) | |
| 12:09 | Refactor opfs-sahpool to support multiple instances, each with a separate VFS name and directory. (check-in: d036eaf6ac user: stephan tags: opfs-sahpool) | |
|
2023-07-17
| ||
| 18:40 | Fix cases where a row is inserted into a contentless_delete=1 fts5 table and then deleted within the same transaction. (check-in: d928856a22 user: dan tags: fts5-contentless-delete) | |
| 17:59 | Do not allow the 'delete' command to be used on contentless_delete=1 fts5 tables. (check-in: cc694b8340 user: dan tags: fts5-contentless-delete) | |
| 11:47 | Merge trunk changes into this branch. (check-in: c4fb2f2ea0 user: dan tags: fts5-contentless-delete) | |
| 07:43 | Another -DSQLITE_TEMP_STORE=3 to 2 change for the wasm build. (check-in: 5ad8f9987c user: stephan tags: opfs-sahpool) | |
| 07:14 | sahpool vfs: rename defaultCapacity to initialCapacity, per feedback. (check-in: 2c9c95d087 user: stephan tags: opfs-sahpool) | |
| 07:13 | Change wasm build's -DSQLITE_TEMP_STORE=3 to -DSQLITE_TEMP_STORE=2, primarily so that clients can optionally shift temp files from memory to OPFS storage. (check-in: 764430e804 user: stephan tags: opfs-sahpool) | |
|
2023-07-16
| ||
| 21:07 | Remove an extraneous JS script import. (check-in: 5a205b2591 user: stephan tags: opfs-sahpool) | |
| 20:42 | Add sqlite3-vfs-opfs-sahpool.js to ext/wasm/api/README.md. (check-in: 58d0520104 user: stephan tags: opfs-sahpool) | |
| 20:20 | Minor doc tweaks. (check-in: 0cb0d7a9e7 user: stephan tags: opfs-sahpool) | |
| 19:29 | Correct a missing assignment. Minor doc additions. (check-in: 1c4957d0ef user: stephan tags: opfs-sahpool) | |
| 19:20 | Doc tweaks only, no code changes. (check-in: 044c28dffd user: stephan tags: opfs-sahpool) | |
| 17:51 | Add a way to remove the opfs-sahpool's persistent state from OPFS or unlink() an individual file. Doc cleanups. (check-in: 80982daac3 user: stephan tags: opfs-sahpool) | |
| 16:52 | Move SAH pool configuration options from the library-level config to a config passed to the VFS install routine. Extend and document the PoolUtil object. (check-in: d2ed99556f user: stephan tags: opfs-sahpool) | |
| 14:07 | speedtest1.js: only install opfs-sahpool if it's provided via --vfs flag, to avoid locking errors in concurrent speedtest1 tabs with other VFSes. Add opfs-sahpool reserveMinimumCapacity(). (check-in: aa94c8abfb user: stephan tags: opfs-sahpool) | |
| 12:02 | During "opfs" VFS init, check for URL param opfs-disable and, if set, do not install the VFS. Added per forum suggestion to provide a way to help rule out misinteraction between the "opfs" and "opfs-sahpool" VFSes. (check-in: 29905b7a75 user: stephan tags: opfs-sahpool) | |
| 11:49 | Micro-optimizations in opfs-sahpool. (check-in: 52f23db948 user: stephan tags: opfs-sahpool) | |
| 10:02 | Redefine what the opfs-sahpool installation promise resolves to. Fix addCapacity(). Add utility methods to import/export files. (check-in: 809c6f4de3 user: stephan tags: opfs-sahpool) | |
|
2023-07-15
| ||
| 21:08 | Minor cleanups in the opfs-sahpool VFS. (check-in: 279e090709 user: stephan tags: opfs-sahpool) | |
| 19:08 | Correct opfs-sahpool VFS after the pebkac involving the previous speedtest1 runs. Make that VFS explicitly opt-in to avoid certain unfortunate locking situations. (check-in: 41bf1fe31f user: stephan tags: opfs-sahpool) | |
| 18:57 | Store large tombstone hash tables in multiple database records. Ensure the same hash tables handle rowid 0. (check-in: 4410e60d0c user: dan tags: fts5-contentless-delete) | |
| 16:48 | Add the experimental sqlite3_stmt_explain(S,E) interface. (check-in: 5683743ddf user: drh tags: sqlite3_stmt_explain) | |
| 16:30 | speedtest1 JS: only add --memdb flag by default if no --vfs is provided. (check-in: 676ffe6280 user: stephan tags: opfs-sahpool) | |
| 11:37 | Rename opfs-sahpool removeCapacity() to reduceCapacity(). (check-in: fff68e9f25 user: stephan tags: opfs-sahpool) | |
| 11:23 | opfs-sahpool VFS now seems to work, in that it runs fine (and blazingly fast) in speedtest1. Add sqlite3.config options for the high-level configurable parts of opfs-sahpool. (check-in: 5d92d5f4d8 user: stephan tags: opfs-sahpool) | |
| 01:02 | More work on porting the sahpool bits. Revert to random backing-store names because it works better with the capacity-reduction algorithm. (check-in: b4e005fd38 user: stephan tags: opfs-sahpool) | |
|
2023-07-14
| ||
| 23:02 | Switch opfs-sahpool to use deterministic backing-store file names. Delay VFS registration until after the pool's files are all opened. Fail vfs init if the client's OPFS API has an async FileSystemSyncAccessHandle.close() method (indicating that it's outdated). (check-in: 7c6697eded user: stephan tags: opfs-sahpool) | |
| 21:48 | Integrate the opfs-sahpool VFS into the JS build and get it loading (but it's still far from functional). (check-in: ef96e6b586 user: stephan tags: opfs-sahpool) | |
| 21:17 | Initial sketches for an alternate OPFS VFS which uses a pool of pre-opened SyncAccessHandles to bypass the need for a dedicated I/O worker and the COOP/COEP HTTP response headers. Currently completely non-functional. (check-in: a93de9f2a5 user: stephan tags: opfs-sahpool) | |
| 21:06 | Minor internal cleanups in the OPFS VFS. (check-in: 984d491eb3 user: stephan tags: trunk) | |
| 12:21 | Minor wasm build cleanups. (check-in: 816b503f09 user: stephan tags: trunk) | |
|
2023-07-13
| ||
| 18:35 | Reintroduce WASMFS+OPFS support, albeit as a separate (less portable) WASM build. (check-in: 7e4c594e95 user: stephan tags: trunk) | |
| 18:13 | Minor cleanups related to reintroducing wasmfs support. (Closed-Leaf check-in: 6918a927b5 user: stephan tags: wasmfs-2023) | |
| 17:27 | More work on the wasmfs build and its test apps. (check-in: 953b855719 user: stephan tags: wasmfs-2023) | |
| 16:33 | Get speedtest1 wasmfs variant running again. (check-in: 0f77e031da user: stephan tags: wasmfs-2023) | |
| 14:49 | Fix an off-by-one error in tests for cells overflowing the end of pages. The error is completely harmless for the default page cache, but might cause false-positive SQLITE_CORRUPT errors in systems that use an application-defined page caches that pack pages tightly together in memory. (check-in: ce6793e954 user: drh tags: trunk) | |
| 14:08 | Significant surgery on the wasm build on the way to incorporating wasmfs as a first-class build option. (check-in: 215c37fce3 user: stephan tags: wasmfs-2023) | |
| 10:41 | More work on the wasmfs build. Resolve the inconsistent argument type passed to sqlite3InitModule() in such builds. (check-in: 4850a9e2d2 user: stephan tags: wasmfs-2023) | |
| 04:54 | Minor cleanups in the wasmfs build. (check-in: f64477f210 user: stephan tags: wasmfs-2023) | |
| 04:26 | Get wasmfs build and its bare-bones test app working again, albeit currently in ES6 mode only. (check-in: 647761ed42 user: stephan tags: wasmfs-2023) | |
| 03:46 | Replace 'self' with 'globalThis' in some JS test code. (check-in: 53eeffc9b1 user: stephan tags: trunk) | |
| 01:51 | JS: change the default OPFS VFS journal mode from PERSIST to DELETE, as DELETE is faster in current browsers. (check-in: a061a43e36 user: stephan tags: trunk) | |
| 01:48 | Remove obsolete ext/wasm/api/sqlite3-wasi.h. (check-in: f661a6e0c1 user: stephan tags: trunk) | |
|
2023-07-12
| ||
| 20:24 | Avoid a case of an infinite loop in fts5 when dealing with corrupt records. (check-in: 0e801f11cd user: dan tags: fts5-contentless-delete) | |
| 19:34 | Fix a crash that may occur when handling corrupt records in contentless_delete=1 mode. (check-in: 74d7610a8e user: dan tags: fts5-contentless-delete) | |
| 18:38 | Get access to SQL functions and virtual tables used for debugging and analysis of FTS5 using SQLITE_FTS5_DEBUG and without the need for SQLITE_TEST. (check-in: 383de8e225 user: drh tags: fts5-contentless-delete) | |
| 09:30 | Internal JS doc fix. (check-in: 7c5ea02205 user: stephan tags: trunk) | |
| 09:16 | Correct handling of the speedtest1 --without-rowid flag in the HTML front-end to speedtest1.wasm. Reduce default speedtest1-with-OPFS workload size in ext/wasm/index.html to speed up manual testing. (check-in: 2daba2cdd3 user: stephan tags: trunk) | |
|
2023-07-11
| ||
| 20:57 | Have contentless_delete=1 tables support REPLACE statements. (check-in: 2f553a660e user: dan tags: fts5-contentless-delete) | |
| 20:19 | Have contentless_delete=1 tables support regular DELETE statements, instead of just the special INSERT syntax. (check-in: fffb861690 user: dan tags: fts5-contentless-delete) | |
| 19:54 | Reduce divergence between branches: trunk and wal-shm-exceptions. (check-in: d38ed6b1fc user: drh tags: trunk) | |
| 18:55 | Use a hash-table instead of a flat list to store tombstone rowids. (check-in: 948267b066 user: dan tags: fts5-contentless-delete) | |
| 15:52 | Get fault injection for testing working correctly. Other code clean-up. (check-in: ff492277ed user: drh tags: wal-shm-exceptions) | |
|
2023-07-10
| ||
| 20:44 | Begin adding support for deleting rows from contentless fts5 tables. (check-in: e513bea84d user: dan tags: fts5-contentless-delete) | |
| 19:21 | Minor style changes to the previous MSVC makefile changes on this branch. (check-in: 4c950872c8 user: mistachkin tags: wal-shm-exceptions) | |
| 19:13 | Compile for SEH if the USE_SEH=1 option is specified on the nmake command line. (check-in: 0e67a82f6c user: drh tags: wal-shm-exceptions) | |
| 18:16 | Fix a warning. Unclear yet if the code is correct this way or not. (check-in: 2df4fd76ef user: drh tags: wal-shm-exceptions) | |
| 18:05 | Merge the latest trunk enhancements into the wal-shm-exceptions branch. (check-in: f655d08d01 user: drh tags: wal-shm-exceptions) | |
|
2023-07-08
| ||
| 19:28 | Merge the latest trunk enhancements into the reuse-schema branch. (check-in: 7a9cb6f4f4 user: drh tags: reuse-schema) | |
| 19:16 | Merge the latest trunk enhancements into the bedrock branch. (check-in: 35bfb5bfee user: drh tags: bedrock) | |
| 19:09 | Merge all the latest trunk enhancements into the wal2 branch. (check-in: f07936535f user: drh tags: wal2) | |
| 19:00 | Merge the latest trunk enhancements into the begin-concurrent branch. (check-in: 3d0823c48e user: drh tags: begin-concurrent) | |
| 17:42 | Always use the "LL" suffix on 64-bit integer literals. (check-in: 07d95ed60f user: drh tags: trunk) | |
| 14:27 | Fix harmless scan-build warnings. (check-in: beab3c9863 user: drh tags: trunk) | |
|
2023-07-07
| ||
| 18:49 | Omit the use of memmove() in sqlite3FpDecode() in an attempt to avoid spurious warnings from valgrind. Also makes the code slightly smaller and faster. (check-in: b409943af0 user: drh tags: trunk) | |
| 16:58 | Proof of concept for a new sqlite3_function_needed() interface. (Leaf check-in: cd67edc032 user: drh tags: need-function) | |
| 12:18 | For the "Valgrind" test scenario, set LONGDOUBLE_TYPE=double as valgrind does not correctly emulated extended precision on x64. (check-in: d3532eaed1 user: drh tags: trunk) | |
| 12:08 | Add option 2 to SQLITE_TESTCTRL_USELONGDOUBLE to move the setting to its defaults. Enhance the CLI and testfixture to make use of this value. Base the default on sizeof(LONGDOUBLE_TYPE) rather than on sizeof(long double). (check-in: 64e6bd1c25 user: drh tags: trunk) | |
|
2023-07-06
| ||
| 20:34 | Improved handling of integer inputs to the new sum() implementation. (check-in: 31561c63bd user: drh tags: trunk) | |
| 18:29 | A more precise implementation of sqlite3RealToI64(). (check-in: 8813317cb5 user: drh tags: trunk) | |
| 17:55 | Merge all recent trunk enhancements into the wal-shm-exceptions branch. (check-in: e59cea2d85 user: drh tags: wal-shm-exceptions) | |
| 17:14 | Fix octet_length() test cases so that they work when the database encoding is utf16. (check-in: ad2e39626e user: drh tags: trunk) | |
| 15:44 | Use the Kahan-Babushka-Neumaier algorithm to improve the accuracy of sum(). (check-in: c63e26e705 user: drh tags: trunk) | |
| 14:45 | Fix minor inaccuracies in the new sum() algorithm. (Closed-Leaf check-in: e3f7a960c9 user: drh tags: kahan-babuska-neumaier-summation) | |
| 13:19 | Experimental attempt to boost the accuracy of sum() using the Kahan-Babuska-Neumaier algorithm. (check-in: ebc5edd3b1 user: drh tags: kahan-babuska-neumaier-summation) | |
| 00:55 | Use "volatile" isntead of "#pragma" to get floating point calculations working correctly when compiling with GCC for x86 machines. (check-in: 9427f42687 user: drh tags: trunk) | |
|
2023-07-05
| ||
| 22:05 | This is alternative work-around for the x86 float-point problem that uses "volatile" rather than compile-specific #pragmas. (Closed-Leaf check-in: 1d972a690f user: drh tags: fix-dekker-with-volatile) | |
| 19:56 | Improved comments on the work-around to the GCC x86 floating point wonkiness. (check-in: 7b4c16731e user: drh tags: trunk) | |
| 18:59 | Work around for an apparent GCC bug. See forum post ee7278611394034c for details. (check-in: 5d9e936480 user: drh tags: trunk) | |
| 15:34 | Make the order of operations explicit for the error term of Dekker double-precision multiply. (check-in: 28f57b34e6 user: drh tags: trunk) | |
| 14:42 | Simplification of the dekkerMul2() subroutine. (check-in: bfe6432a46 user: drh tags: trunk) | |
| 12:00 | Add the ieee754_inc(r,N) function to the ieee754.c extension. (check-in: 9a36f26945 user: drh tags: trunk) | |
|
2023-07-03
| ||
| 18:32 | Enhance the sqlite3AtoF() function so that it can operate with or without long double and provides accurate results in both cases. (check-in: fd987508d5 user: drh tags: trunk) | |
| 18:18 | Enhance sqlite3AtoF() so that it honors the USELONGDOUBLE test-control. Enable the test/atof1.test module on non-intel platforms. (Closed-Leaf check-in: b7850fd480 user: drh tags: fp-to-decimal-refactor) | |
| 15:30 | Store the fp-speed-1.c test program used to measure relative performance of SQLite versus the standard library, in the test/ directory. A header comment explains how to use it. (check-in: eaff376277 user: drh tags: trunk) | |
| 15:11 | Add the --nolongdouble option to speedtest1.c. (check-in: 6bf6018a00 user: drh tags: trunk) | |
| 15:03 | Improved precision of binary-to-decimal conversion of floating-point values on all systems but especially non-x86 systems that lake extended precision hardward floating point. (check-in: 32befb224b user: drh tags: trunk) | |
| 14:56 | Whether or not to use the long-double floating point conversion technique is now a test-control setting. (check-in: 02ae6caff1 user: drh tags: fp-to-decimal-refactor) | |
| 12:58 | New test cases for floating-point conversions. (check-in: 9435ed76cd user: drh tags: fp-to-decimal-refactor) | |
| 11:44 | Use Dekker double-precision floating point to do the value normalization step in sqlite3FpDecode() for systems on which "long double" is 8 bytes or less. (check-in: 51f492b440 user: drh tags: fp-to-decimal-refactor) | |
| 11:39 | Final clean-up of the idea of using Dekker double-precision floating computations to improve accuracy. (Closed-Leaf check-in: 40285d6310 user: drh tags: fp-to-decimal-branch1) | |
| 10:35 | Squeeze as many bits as we can out of normalization. (check-in: 25d1ad6df1 user: drh tags: fp-to-decimal-branch1) | |
| 10:18 | Faster Dekker multiplication that removes the restriction on input magnitude. (check-in: 2994caf588 user: drh tags: fp-to-decimal-branch1) | |
| 10:00 | Fix one constant in the normalization logic. Improved error output from atof1.test. (check-in: d3c4880710 user: drh tags: fp-to-decimal-branch1) | |
| 09:07 | Replace the dodgy error estimating logic in the previous check-in with full-up Dekker double-double multiplication, and this idea works much better. There are still a few inaccuracies, but it is much closer. (check-in: 4fa6938dac user: drh tags: fp-to-decimal-branch1) | |
| 00:51 | The fptest(X) routine used for exploring another idea for improving fp-to-decimal conversion without the use of long double. (Leaf check-in: d9a883d7d8 user: drh tags: fp-to-decimal-branch2) | |
| 00:40 | An idea for improving accuracy of fp-to-decimal conversion for systems that do not have "long double". Does not quite work. Retained only for documentation purposes. (check-in: 7022433338 user: drh tags: fp-to-decimal-branch1) | |
|
2023-07-01
| ||
| 20:21 | This check-in adds the use of "long double" to sqlite3FpDecode() which when run on x86 using a compiler that translates "long double" into binary80, causes all legacy tests to pass. But on a system where "long double" is just an alias for "double", some of the tests are still failing. (check-in: ce06982f88 user: drh tags: fp-to-decimal-refactor) | |
| 18:33 | Reinstate the fpdecode() SQL function for testing, but only when compiled with SQLITE_DEBUG. (check-in: 07eab52e08 user: drh tags: fp-to-decimal-refactor) | |
| 17:56 | Improved rounding policy. (check-in: 6f1122e942 user: drh tags: fp-to-decimal-refactor) | |
| 15:23 | Improved response to Infinity and NaN. Remove the termporary fpdecode() function. (check-in: 76ab8ae809 user: drh tags: fp-to-decimal-refactor) | |
| 14:03 | Progress towards fixing corner-case floating-point formatting issues. (check-in: 1138b8d16e user: drh tags: fp-to-decimal-refactor) | |
|
2023-06-30
| ||
| 23:42 | Fix an issue with the "+" attribute in printf(). (check-in: bdfd1eb1d7 user: drh tags: fp-to-decimal-refactor) | |
| 23:18 | Begin cutting over sqlite3FpDecode() into printf(). The code in this check-in gets a lot right, but there are still some formatting discrepencies. (check-in: c134d423e7 user: drh tags: fp-to-decimal-refactor) | |
| 19:41 | Add decimal rounding to the sqlite3FpDecode() routine. (check-in: 27871140ca user: drh tags: fp-to-decimal-refactor) | |
| 19:14 | Add experimental ".scanstats vm" command to the shell tool. (check-in: e727640fb5 user: dan tags: scanstatus-exp) | |
| 19:13 | Fix an error in the previous commit on this branch. (check-in: 47c11ca90f user: dan tags: scanstatus-exp) | |
| 18:59 | Add the "nexec" and "ncycle" columns to the bytecode virtual table. For accessing counters collected when SQLITE_DBCONFIG_STMT_SCANSTATUS is enabled. (check-in: f7b163a319 user: dan tags: scanstatus-exp) | |
| 18:35 | Experiments with a new algorithm for converting ieee-754 binary64 numbers into decimal. (check-in: e923405e44 user: drh tags: fp-to-decimal-refactor) | |
| 18:31 | Add support for sqlite3_stmt_scanstatus_v2() profiling of GROUP BY clauses that use a temp b-tree, and for sub-queries implemented as co-routines. (check-in: 7afad1f759 user: dan tags: trunk) | |
| 18:23 | Improve support for sqlite3_stmt_scanstatus_v2() profiling of sub-queries implemented as co-routines. (Closed-Leaf check-in: 4e8718dc35 user: dan tags: scanstatus-exp) | |
| 17:14 | Add support for sqlite3_stmt_scanstatus_v2() profiling of GROUP BY clauses that use a temp b-tree. (check-in: 796eadcc50 user: dan tags: scanstatus-exp) | |
| 16:16 | Add extra debugging code for sqlite3_stmt_scanstatus_v2() to test1.c. (check-in: f936f10140 user: dan tags: trunk) | |
| 14:01 | Completely unwind the enhanced precision sum() from [a915f15a916af698] so as not to offend UBSAN and OSS-Fuzz. (check-in: 85be05b66e user: drh tags: trunk) | |
| 12:59 | Omit the doubleToReal() function in vdbemem.c. Use the equivalent sqlite3RealToI64() function in its place. (check-in: 625820e8eb user: drh tags: trunk) | |
| 11:51 | Make the sum() function less precise and slower in order to avoid harmless signed integer overflow UBSAN warnings from OSS-Fuzz. (check-in: 1be0646a2c user: drh tags: trunk) | |
|
2023-06-29
| ||
| 23:03 | Cleanup and commenting of the new DECIMAL extension code. No functional changes. (check-in: 5124481663 user: drh tags: trunk) | |
| 20:28 | Enhancements to the DECIMAL extension: (1) If the argument to decimal(X) is a floating point value (or an 8-byte blob), the floating point value is expanded into its exact decimal representation. (2) Function decimal_sci(X) works the same except it returns the result in scientific notation. (3) New function decimal_pow2(N) returns the full decimal expansion of the N-th integer power of 2. (check-in: 8baf8c10ae user: drh tags: trunk) | |
| 17:58 | Sync w/trunk (check-in: fe9aa2e9c1 user: larrybr tags: cli_extension) | |
| 17:48 | Fix harmless compiler warnings about unused function arguments. (check-in: 24927c1377 user: drh tags: trunk) | |
| 17:36 | Improve the range of floating-point numbers that can be handled as integers for numeric-to-text conversion. (check-in: 41580ba452 user: drh tags: trunk) | |
| 17:26 | Further refine the dtostr() testing function in the CLI so that it takes an optional second parameter which is the number of significant digits to display. (check-in: 2f9d4444aa user: drh tags: trunk) | |
| 16:48 | Change the (undocumented) dtostr() SQL function in the CLI so that it only shows the first 26 significant digits - 10 more digits than are available in a 64-bit double. (check-in: d758859f6a user: drh tags: trunk) | |
| 14:49 | Add the decimal_sci(X) function to the Decimal extension for showing a decimal value in scientific notation: +D.DDDDDe+DD (check-in: 61d4923913 user: drh tags: trunk) | |
| 12:14 | CLI enhancements to facilitate SQLite core testing: (1) Add built-in functions strtod() and dtostr() that convert text to floating point and back using C-library routines. (2) Do not disable all of ".testctrl" without --unsafe-testing, but only those subcommands of .testctrl that are actually dangerous. (check-in: 669996a8dd user: drh tags: trunk) | |
|
2023-06-28
| ||
| 12:02 | Enhance the SUM() aggregate (and related AVG() and TOTAL()) so that the running sum is accurate to about 100 bits. (check-in: a915f15a91 user: drh tags: trunk) | |
| 11:46 | Improved accuracy of floating-point conversion constants as suggested by forum post 598d32f6135c41c1. (check-in: 4943e8a181 user: drh tags: trunk) | |
|
2023-06-26
| ||
| 19:57 | Simple test cases for the enhanced SUM() function. (Closed-Leaf check-in: c66ef2440e user: drh tags: extended-precision-fp) | |
| 19:35 | Use ideas from T. J. Dekker in "A Floating-Point Technique for Extending the Available Precision" (1971-07-26) to enhance the accuracy of the SUM() aggregate function in cases where input magnitudes vary wildly. (check-in: 439fc00fee user: drh tags: extended-precision-fp) | |
| 17:08 | Fix CLI .sha3sum error message for keyword identifiers, reported in forum post 7cbe081746dd. (check-in: 9d7813ddcf user: larrybr tags: trunk) | |
| 07:05 | Replace some JS 'self' references with 'globalThis', as reported via the npm subproject. (check-in: d4e66dfc2e user: stephan tags: trunk) | |
|
2023-06-25
| ||
| 20:23 | Fix typo in the README.md file. (check-in: 6d435d1dac user: drh tags: trunk) | |
|
2023-06-23
| ||
| 11:10 | Add support for the octet_length() SQL function, with low-level optimizations that avoid loading large string content from disk when the argument to octet_length() is a table column. (check-in: fa5f77862c user: drh tags: trunk) | |
|
2023-06-22
| ||
| 21:19 | Optimize the argument to the octet_length() function so that it does not attempt to read content from disk. (Closed-Leaf check-in: 8b8ea4e3f5 user: drh tags: octet_length) | |
| 15:26 | basic test cases for octet_length(). (check-in: 034a5fe2a0 user: drh tags: octet_length) | |
| 14:50 | Merge the latest trunk enhancements into the reuse-schema branch. (check-in: 905c6c9ddb user: drh tags: reuse-schema) | |
| 14:40 | Merge the latest trunk enhancements into the bedrock branch. (check-in: 0551b79b17 user: drh tags: bedrock) | |
| 14:20 | Merge the latest trunk enhancements into the wal2 branch. (check-in: 80ac494f73 user: drh tags: wal2) | |
| 13:28 | Merge recent trunk enhancements into the begin-concurrent branch. (check-in: 5bd26fea6a user: drh tags: begin-concurrent) | |
| 13:01 | Merge recent trunk enhancements into the octet_length branch. (check-in: d35c214811 user: drh tags: octet_length) | |
| 01:03 | Simplification to the getAndInitPage() routine that results in improved performance. (check-in: 2e9734c233 user: drh tags: trunk) | |
|
2023-06-21
| ||
| 21:47 | Improved comment on the getAndInitPage() in btree.c. No code changes. (check-in: dc468cfdb8 user: drh tags: trunk) | |
| 18:12 | This is a failed attempt to optimize the usage of the page cache in sqlite3BtreeIndexMoveto() by deferring calls to sqlite3PagerUnref() for child pages of the btree until we are sure those pages will not be reused. The code does not work in two senses: (1) Many tests still fail. (2) The performance gain is less than 2 million cycles and does not seem worth the extra risk and complication. (Closed-Leaf check-in: 84731a1fd2 user: drh tags: pcache-opt) | |
| 14:48 | Sync w/trunk (for CLI -cachetrace) (check-in: a61f937701 user: larrybr tags: cli_extension) | |
| 14:11 | Add the --pcachetrace option to the CLI. (check-in: 61dfa92b44 user: drh tags: trunk) | |
|
2023-06-20
| ||
| 17:45 | Omit unnecessary calls to table locking routines in the common case when there is no shared cache. (check-in: f94f3021cd user: drh tags: trunk) | |
| 16:26 | Avoid unnecessary calls to sqlite3DeleteTable() with NULL pointers. (check-in: 4a35f39199 user: drh tags: trunk) | |
| 15:48 | Avoid unnecessary calls to sqlite3CodeRowTrigger(). (check-in: 27c174dbd0 user: drh tags: trunk) | |
| 11:46 | Performance optimization in sqlite3VdbeAddOp4Int(). (check-in: 456a24324b user: drh tags: trunk) | |
|
2023-06-19
| ||
| 23:27 | Avoid unnecessary NULL pointer checks on calls to sqlite3WalkExpr(). (check-in: 73d86a12fb user: drh tags: trunk) | |
| 20:54 | Small performance improvement and size reduction by recognizing that no SQL keywords have less than 2 characters. (check-in: 6b3d25b798 user: drh tags: trunk) | |
| 13:09 | Fix large integer constants so that they work on older C compilers. (check-in: 3c94f87806 user: drh tags: trunk) | |