Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
415 events for the month beginning 2023-08-01
Following month ↑|
2023-08-31
| ||
| 19:35 | Export sqlite3_txn_state() to JNI. (check-in: d732f71d user: stephan tags: jni-client-data) | |
| 18:34 | Minor JNI cleanups. (check-in: 2e2bb841 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: 0d50d271 user: drh tags: branch-3.43) | |
| 18:08 | • Edit [c84d5602ac9bfb4f|c84d5602]: Edit check-in comment. (artifact: 0e0e8549 user: drh) | |
| 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: c84d5602 user: dan tags: trunk) | |
| 15:24 | Add convenience overloads of JNI sqlite3_table_column_metadata() to simplify usage. (check-in: faf4e6d3 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: 7c86aa34 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: 443ea20d 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: e7c11d34 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: d63d9ee3 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: 8b390d7e user: drh tags: wal2-3.43) | |
| 18:29 | • Edit [69a635958a4a1418|69a63595]: Edit check-in comment. (artifact: 0a07a8d4 user: drh) | |
| 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: db7cb6cb 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: 69a63595 user: drh tags: trunk) | |
| 17:41 | Remove another unreachable branch in the sqlite3_set_clientdata() logic. (check-in: 57e31e6b user: drh tags: db-client-data) | |
| 17:14 | Remove an unreachable branch, and improve documentation of sqlite3_set_clientdata(). (check-in: 565c68ad user: drh tags: db-client-data) | |
| 16:34 | Fix the AVG() and TOTAL() functions so that they work with infinities. (check-in: 9877c7c8 user: drh tags: bedrock-3.43) | |
| 16:24 | Fix the AVG() and TOTAL() functions so that they work with infinitites. (check-in: 988e5308 user: drh tags: wal2-3.43) | |
| 16:08 | Fix the AVG() and TOTAL() functions so that they work with infinitites. (check-in: 97e20716 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: 6df6f17c user: drh tags: trunk) | |
| 15:51 | Further tweaking in both SQLTesters. (check-in: 46b0eb98 user: stephan tags: trunk) | |
| 15:42 | Fix to the sqlite3_get_clientdata() interface. (check-in: 937cd176 user: drh tags: db-client-data) | |
| 15:20 | New experimental API for attaching client data to a database connection. (check-in: d542837f 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: 273d3b05 user: stephan tags: trunk) | |
| 13:07 | Add a JS implementation of Java's SQLTester. (check-in: b530792a user: stephan tags: trunk) | |
| 11:54 | Add a UI, of sorts, to the JS SQLTester. (Closed-Leaf check-in: 249e82b9 user: stephan tags: js-tester) | |
| 00:22 | Add a mechanism with which to import external SQLTester scripts into the JS testing tool. (check-in: bb08ba02 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: 7cef4a83 user: stephan tags: js-tester) | |
| 20:44 | More fleshing out of JS SQLTester. (check-in: 8c503dfb user: stephan tags: js-tester) | |
| 20:37 | Merge the latest branch-3.43 fixes into the bedrock branch. (check-in: 7e3e0075 user: drh tags: bedrock-3.43) | |
| 20:24 | Merge the branch-3.43 fixes into the wal2 branch. (check-in: 903e9974 user: drh tags: wal2-3.43) | |
| 20:19 | Fix a test case problem in wal2recover2.test. (check-in: 9e927eed 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: 5e798369 user: stephan tags: js-tester) | |
| 18:28 | New conversion letters added to strftime(): %e, %k, %I, %l, %R, %P, %p, %T, %u. (check-in: 058722b2 user: drh tags: trunk) | |
| 15:39 | Get the JS SQLTester command handlers in place sans those which have to run SQL. (check-in: d21b1217 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: 253fe4a4 user: drh tags: trunk) | |
| 15:24 | Add support for the CONCAT() and CONCAT_WS() SQL functions, modeled after the PostgreSQL behavior. (check-in: 0b434ca7 user: drh tags: trunk) | |
| 13:28 | Get the basic parsing pieces and command dispatching in place in the JS SQLTester. (check-in: 8fcc2a55 user: stephan tags: js-tester) | |
| 11:22 | Init bits of a port of Java's SQLTester to JS. Far from complete. (check-in: 60eec5ce 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: 00a8b3a2 user: dan tags: trunk) | |
| 00:10 | Remove some dead code. Add a skeleton SQLTester script for fts5. (check-in: 6c83e31f user: stephan tags: trunk) | |
|
2023-08-28
| ||
| 23:18 | Factor out a superfluous struct member. (check-in: 76d3911c user: stephan tags: trunk) | |
| 22:52 | Further minor internal JNI simplifications. (check-in: 1808d12e user: stephan tags: trunk) | |
| 21:27 | Improve threadability of the JNI collation-related bindings and add infrastructure for similar cases. (check-in: f02dad66 user: stephan tags: trunk) | |
| 20:21 | Correct JNI mapping of collations to be 1-db-to-many-collations. (check-in: b927b0f5 user: stephan tags: trunk) | |
| 20:14 | Updates to testrunner.tcl so that it runs fuzztest using multiple jobs. (check-in: ceeabe9f user: dan tags: trunk) | |
| 20:02 | Fix the "sdevtest" testrunner.tcl command so that it correctly enables asan on windows. (Closed-Leaf check-in: 64631923 user: dan tags: testrunner) | |
| 18:15 | Fixes for testrunner.tcl on windows. (check-in: 26ae0908 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: 448b9a57 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: ecf07a01 user: stephan tags: trunk) | |
| 16:05 | Update tool/mkctimec.tcl to account for [fe7365254d343e]. (check-in: 349aac7e user: stephan tags: trunk) | |
| 15:58 | Add support for the -DSQLITE_EXTRA_AUTOEXT=name compile-time option. forum thread 00829394c74a670f. (check-in: fe736525 user: drh tags: trunk) | |
| 14:59 | Duplicate code consolidation. (check-in: 71f23974 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: 54d2209d 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: f5274e00 user: stephan tags: trunk) | |
| 12:58 | • Edit [77d3dcd283595c52|77d3dcd2]: Edit check-in comment. (artifact: 864b901f user: drh) | |
| 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: 692266ab 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: 77d3dcd2 user: drh tags: trunk) | |
| 12:06 | Resolve a condition which could cause an is-interrupted db to call its progress callback. (check-in: a0d0f1aa user: stephan tags: trunk) | |
| 11:22 | Fix the valgrind permutation on this branch. (check-in: ccbf0676 user: dan tags: testrunner) | |
| 11:10 | Further JNI cleanups and javadoc additions. (check-in: c393b1c9 user: stephan tags: trunk) | |
| 07:28 | Lots of javadoc-related tweaks. (check-in: cfe06f90 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: 8a016006 user: stephan tags: trunk) | |
| 05:39 | Move the JNI annotations into the annotation subpackage. (check-in: e4dedf90 user: stephan tags: trunk) | |
| 05:15 | • Edit [49c24c29ec2c3ab5|49c24c29]: Mark "Closed" with note "Will be revisited in another form.". (artifact: 85549b2d user: stephan) | |
| 05:06 | Resolve a makefile bug which causes sqlite3-worker1-bundler-friendly.mjs to be built incorrectly. Reported in forum post a874e435cf4690c1. (check-in: 289d2a0e 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: 9d68c7ef 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: 401dd6ee user: stephan tags: trunk) | |
| 14:47 | Generic cleanups in Tester1.java. (check-in: fbc1b631 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: 29bd4a23 user: stephan tags: trunk) | |
| 11:28 | Correct the signature mismatch between JNI sqlite3_column/value_text16() and add related tests. (check-in: 77f6e70f 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: 3f9f7a9c 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: bae4d022 user: stephan tags: trunk) | |
| 08:10 | Factor out a superfluous JNI class. Doc and code style cleanups. (check-in: 0f37f271 user: stephan tags: trunk) | |
| 07:26 | JNI code reorgs and simplify the failing-alloc interface a bit. (check-in: deed5797 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: 1ff78582 user: stephan tags: trunk) | |
| 21:13 | Eliminate a superfluous JNI-internal middle-man class. (check-in: daede0f8 user: stephan tags: trunk) | |
| 21:05 | • Edit [7596ea7074e0ac73|7596ea70]: Move to branch testrunner. (artifact: d44756a1 user: dan) | |
| 21:04 | Updates to testrunner.tcl so that it runs "make fuzztest" using multiple jobs. (check-in: 7596ea70 user: dan tags: testrunner) | |
| 21:02 | Whether or not OOM is always fatal in JNI is now a compile-time option. (check-in: 320a34c0 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: 4252f56f user: stephan tags: trunk) | |
| 18:15 | Remove a bunch of commented-out debug output. (check-in: b4948848 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: 49d3be00 user: stephan tags: trunk) | |
| 17:36 | Two significant typo fixes for [1a30919bfbb686]. (check-in: 6a6ee6dd user: stephan tags: trunk) | |
| 17:30 | Bind sqlite3_db_handle() to JNI. (check-in: 1a30919b user: stephan tags: trunk) | |
| 16:55 | Correct a potential duplicate xDestroy() being triggered for Java-side collations. (check-in: 25331172 user: stephan tags: trunk) | |
| 16:29 | Recycle per-UDF JNI state. (check-in: cf406528 user: stephan tags: trunk) | |
| 14:55 | Code consolidation cleanups. (check-in: d6b5ecd2 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: cc3153ed user: stephan tags: trunk) | |
| 11:57 | JNI internal cleanups and docs. (check-in: b7b26bfb 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: c852f1eb 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: f2af7bbf user: stephan tags: trunk) | |
|
2023-08-25
| ||
| 16:43 | Move the 3 Java SQLFunction subclasses from inner classes to package scope. (check-in: 21fd47a6 user: stephan tags: trunk) | |
| 16:26 | Missed a straggler when renaming Java classes in [8ca528006533ac1]. Document threading limitations. (check-in: 5786b95f 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: 8ca52800 user: stephan tags: trunk) | |
| 13:23 | More Java API renaming for consistency. (check-in: 4e457778 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: 6b1c816f 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: 5a099caa 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: 17d56c02 user: dan tags: trunk) | |
| 04:27 | Only build in the JNI-side metrics tracking in SQLITE_DEBUG builds. (check-in: 646e7fc3 user: stephan tags: trunk) | |
| 04:02 | Javadoc and internal API cleanups. (check-in: 10a43cba 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: 76e62a38 user: stephan tags: trunk) | |
| 00:27 | javadoc additions. (check-in: bedf33d4 user: stephan tags: trunk) | |
|
2023-08-24
| ||
| 22:28 | Re-frame the incongruous SQLite3Jni.uncacheThread() API as sqlite3_java_uncache_thread(). (check-in: 7232b033 user: stephan tags: trunk) | |
| 21:45 | Update some outdated JNI docs and account for a function renamed earlier this evening. (check-in: 3f684ef5 user: stephan tags: trunk) | |
| 21:31 | Do not pre-allocate sqlite3_aggregate_context() for Java UDFs, as it unduly complicates UDF initialization. (check-in: e8308f0c user: stephan tags: trunk) | |
| 19:08 | Add doc/testrunner.md, for documenting the testrunner.tcl script. (check-in: 9c69a284 user: dan tags: trunk) | |
| 18:43 | More code legibility and style improvements in the JNI pieces. Start work on a javadoc build. (check-in: 62b404d6 user: stephan tags: trunk) | |
| 17:25 | Doc, code style, and legibility cleanups. (check-in: cf185bcd user: stephan tags: trunk) | |
| 15:42 | Doc style fixes. (check-in: 862f9828 user: stephan tags: trunk) | |
| 15:11 | Add a new non-goal to the JNI README.md. (check-in: 53000cda user: stephan tags: trunk) | |
| 14:49 | Merge the jni-threading branch into trunk, eliminating the JNI API's prior threading limitations. (check-in: 3739c8aa user: stephan tags: trunk) | |
| 14:43 | Merge into trunk improvements made to the wasm APIs which were too late for 3.43. (check-in: ac9da5c7 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: 1f46ba8d 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: b8f6a50a user: stephan tags: wasm-post-343) | |
| 13:42 | Fix a test case problem in wal2recover2.test. (check-in: 81361769 user: dan tags: bedrock) | |
| 13:32 | Version-3.43.0 for the reuse-schema branch. (check-in: 6f1bcd6a user: drh tags: reuse-schema) | |
| 13:31 | • Edit [e7b1ee1a999ced9a|e7b1ee1a]: Edit check-in comment. (artifact: f84ba8e5 user: drh) | |
| 13:26 | Version 3.43.0 for the bedrock branch. (check-in: e7b1ee1a user: drh tags: bedrock) | |
| 13:19 | Version 3.43.0 for the wal2 branch. (check-in: b5970fc4 user: drh tags: wal2) | |
| 13:17 | Version 3.43.0 for the begin-concurrent branch. (check-in: e67bf282 user: drh tags: begin-concurrent) | |
| 12:36 | Version 3.43.0 (check-in: 0f80b798 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: 3f5bec9a user: dan tags: trunk) | |
| 11:57 | Add more JNI docs, tests, and a handful of Java-side overloads. (check-in: d19a431f user: stephan tags: jni-threading) | |
|
2023-08-23
| ||
| 18:42 | Fix typo in the Lemon documentation. (check-in: 5daeb318 user: drh tags: trunk) | |
| 18:29 | More changes to documents for GitHub-style markdown. (check-in: f20f84ef 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: a25360c0 user: drh tags: trunk) | |
| 17:52 | JNI cleanups regarding building with certain features disabled. (check-in: a9e6d515 user: stephan tags: jni-threading) | |
| 17:15 | Remove unnecessary jclass-type struct members. (check-in: d67255f7 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: 49c24c29 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: 415447a3 user: stephan tags: jni-threading) | |
| 13:17 | Bind sqlite3_preupdate_hook() and friends to JNI. (check-in: d0c425b5 user: stephan tags: jni-threading) | |
| 12:53 | Minor adjustments to the wording about pull requests in the README.md file. (check-in: 6b2d68af user: drh tags: trunk) | |
| 10:36 | Bind a subset of sqlite3_config() to JNI: threading modes and sqllog. (check-in: fce8ecaf 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: bb9dcdaf user: drh tags: trunk) | |
| 09:05 | Numerous minor cleanups and code style conformance improvements. (check-in: 6c92d884 user: stephan tags: jni-threading) | |
| 00:17 | Improve C-side exception handling from Java-side UDF callbacks. (check-in: aebbc24a user: stephan tags: jni-threading) | |
|
2023-08-22
| ||
| 23:00 | Minor Tester1.java cleanups. (check-in: 70d93695 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: 56b2a077 user: stephan tags: jni-threading) | |
| 20:10 | More work on the JNI multi-threaded test runner. (check-in: 9a74ad71 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: 8b78b737 user: stephan tags: jni-threading) | |
| 17:51 | Correct JNI binding of sqlite3_shutdown() to clean up all cached JNIEnv objects. (check-in: 02e86869 user: stephan tags: jni-threading) | |
| 17:36 | JNI internal cleanups and correct two leaked db handles in test code. (check-in: f927a30b user: stephan tags: jni-threading) | |
| 16:44 | Fix a harmless memory leak in the sqldiff utility. (check-in: 724bc157 user: drh tags: trunk) | |
| 15:47 | Merge the trunk Makefile enhancements into the reuse-schema branch - especially the new "sdevtset" makefile target. (check-in: f55f5e9d 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: e209f56a 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: a449d650 user: dan tags: trunk) | |
| 13:41 | Update version number in autoconf/tea/configure.ac. (check-in: 055ae724 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: 7342bf57 user: stephan tags: jni-threading) | |
| 11:20 | Update autoconf/Makefile.msc (by running mkmsvcmin.tcl) to support the "ASAN=1" option. (check-in: 17028ba7 user: dan tags: trunk) | |
|
2023-08-21
| ||
| 23:45 | Minor JNI cleanups. (check-in: b88910aa user: stephan tags: jni-threading) | |
| 18:31 | Merge latest changes from the wal2 branch into this one. (check-in: 4d8df0c4 user: dan tags: bedrock) | |
| 18:25 | Fix problems related to structured-exception-handling on this branch. (check-in: d3d77e35 user: dan tags: bedrock) | |
| 18:03 | Merge the latest trunk enhancements into the begin-concurrent branch. (check-in: 76a99a2c user: drh tags: begin-concurrent) | |
| 18:02 | Merge latest trunk changes into this branch. (check-in: 135bf72c user: dan tags: wal2) | |
| 17:53 | Merge the latest trunk enhancements into the reuse-schema branch. (check-in: e94f09f1 user: drh tags: reuse-schema) | |
| 17:49 | Fix problems related to structured-exception-handling on this branch. (check-in: dd86c272 user: dan tags: begin-concurrent) | |
| 17:26 | Fix MSVC testfixture.exe builds. (check-in: 7004c902 user: dan tags: begin-concurrent) | |
| 16:14 | Fix an undefined integer overflow in fts5. (check-in: f5c50349 user: dan tags: trunk) | |
| 15:29 | ifdef adjustments so that SQLITE_OMIT_WAL works with SQLITE_USE_SEH. (check-in: 0462a261 user: drh tags: trunk) | |
| 14:40 | Fix another UBSAN inaccuracy in fuzzcheck. (check-in: a6fb9de8 user: drh tags: trunk) | |
| 14:28 | Address minor inaccuracies in fuzzcheck and RTREE found by UBSAN. (check-in: a64e6c2f user: drh tags: trunk) | |
|
2023-08-19
| ||
| 14:49 | JNI cleanups. (check-in: 0a841310 user: stephan tags: jni-threading) | |
| 12:34 | Merge trunk into jni-threading branch. (check-in: 8254479c user: stephan tags: jni-threading) | |
| 12:32 | JNI doc additions. (check-in: 0c7ac34f user: stephan tags: jni-threading) | |
| 11:52 | JNI test code cleanups. (check-in: e202b6e6 user: stephan tags: jni-threading) | |
| 11:26 | Minor JNI cleanups. (check-in: 1cecb9e0 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: bdbaf7a4 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: 2d955eef user: stephan tags: jni-threading) | |
| 08:12 | shell.c.in help text typo fix. No functional changes. (check-in: c3190332 user: stephan tags: trunk) | |
|
2023-08-18
| ||
| 15:39 | Rename the decimal_sci() function to decimal_exp(). Forum post fa027bb0ab. (check-in: c48f1be8 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: 925be753 user: dan tags: trunk) | |
| 14:41 | Improve exception handling in OpfsDb.importDb(). (check-in: a4eedd63 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: 9b1398c9 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: ec7eeb05 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: dd749e40 user: drh tags: trunk) | |
|
2023-08-17
| ||
| 22:04 | Remove some obsolete JNI-internal docs. (check-in: 00a2a373 user: stephan tags: jni-threading) | |
| 17:48 | Do not allow bound parameters in the ON CONFLICT clause of an UPSERT. dbsqlfuzz 9983e2c77634a8ccf33b5c91fa9982599de5f9e9 (check-in: 3c067093 user: drh tags: trunk) | |
| 16:59 | Fix an error in documentation comments in fts5.h. (check-in: 24d96bd6 user: dan tags: trunk) | |
| 16:49 | Add extra test to fts5synonym2.test. (check-in: 39ea11be user: dan tags: trunk) | |
| 16:06 | Add "Windows-Sanitize" configuration to "testrunner.tcl release" tests on windows. (check-in: e68b46dc user: dan tags: trunk) | |
| 15:14 | Have all test names in json101.test start with "json101". (check-in: af56d7b6 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: 3eaadaff 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: 91b91037 user: drh tags: trunk) | |
| 13:13 | Tighten up the JNI auto-ext handling. (check-in: c09c8d05 user: stephan tags: jni-threading) | |
| 12:44 | Minor internal JNI cleanups and fixes. (check-in: 0e9437de user: stephan tags: jni-threading) | |
| 10:49 | Remove the FIXME markers related to threading. Code style cleanups. (check-in: 154ab26d 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: 423e7727 user: stephan tags: extra-autoext) | |
|
2023-08-16
| ||
| 17:23 | Refinements to instructions on compiling for Windows. (check-in: d543c36c user: drh tags: trunk) | |
| 17:12 | Improved instructions on how to build SQLite on Windows 11 and similar. (check-in: 0f6b2b33 user: drh tags: trunk) | |
| 15:27 | Make sqlite3_stmt_explain() accessible to loadable extensions. (check-in: a237a31f user: drh tags: trunk) | |
| 15:10 | Mix the current process ID into the randomness used for generating temporary filenames on Windows. (check-in: 775a36ee user: drh tags: trunk) | |
| 14:19 | • Edit [6542ed3b9e028c44|6542ed3b]: Edit check-in comment. (artifact: e9afe949 user: dan) | |
| 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: 6542ed3b user: dan tags: trunk) | |
| 13:55 | Fix test script problem preventing veryquick.test from running. (check-in: e7388657 user: dan tags: trunk) | |
|
2023-08-15
| ||
| 21:44 | Cherrypick [00ac653562a6] to remove stray JNI debug output. No functional changes. (check-in: e12d70f3 user: stephan tags: trunk) | |
| 20:57 | Cherrypick [653ed92dc391] (went to wrong branch). Doc change only, no code changes. (check-in: 79a14457 user: stephan tags: trunk) | |
| 20:35 | • Changes to wiki page "ToDo" (artifact: 4e000975 user: stephan) | |
| 18:52 | Update testrunner.tcl to make it easier to add things like mdevtest. (check-in: a531b71c user: dan tags: trunk) | |
| 18:08 | Improve the portability of the src-verify.c tool on Windows. (check-in: 4068d94a user: drh tags: trunk) | |
| 14:53 | Fix problems in fts5 test code. (check-in: c16ed3b1 user: dan tags: trunk) | |
| 13:01 | Add note about the current threading limitation to ext/jni/README.md. No code changes. (check-in: 653ed92d user: stephan tags: wasm-post-343) | |
| 12:27 | Use a dodgy substitute if the INFINITY macro is not available. See forumpost 8e66e19bb9. (check-in: 4ae72c89 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: 84c268c3 user: drh tags: trunk) | |
| 10:57 | Fix an off-by-one error causing a buffer overread in test2.c. (check-in: e1edf95e user: dan tags: trunk) | |
| 09:26 | Minor reshaping of Tester1 moving towards making a multi-threaded run mode. (check-in: f104c14c user: stephan tags: jni-threading) | |
| 09:16 | Remove a piece of stray debug output. No functional changes. (check-in: 00ac6535 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: 85fd4f0e user: drh tags: trunk) | |
| 18:21 | Fix a problem in sqlite3_snapshot_recover() introduced by the [8a6b0c24937e855b] merge. (check-in: c2577eb0 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: 42994b95 user: stephan tags: jni-threading) | |
| 14:21 | Remove some obsolete, commented-out makefile code. No functional or build changes. (check-in: ea574cd5 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: 544de2da 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: c84ded0e user: stephan tags: jni-threading) | |
| 12:20 | Fix harmless compiler warnings reported by MSVC. (check-in: 391e21bb user: drh tags: trunk) | |
| 12:05 | Enable SEH be default in Windows builds. (check-in: faae792f user: drh tags: trunk) | |
| 08:28 | JNI-internal docs and removal of obsolete code. (check-in: b62d9325 user: stephan tags: jni-threading) | |
|
2023-08-13
| ||
| 20:58 | Internal API renaming for clarity's sake. (check-in: 911e4fc5 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: 8da97e0d user: stephan tags: jni-threading) | |
| 10:28 | Add some docs and metrics for the new mutex internals. (check-in: 33d1780b user: stephan tags: jni-threading) | |
| 10:22 | Remove SQLITE_DEBUG from JNI build. (check-in: 82f004cf user: stephan tags: trunk) | |
| 10:15 | • Edit [c64e6a52ac79164b|c64e6a52]: Edit check-in comment. (artifact: f0e55f8f user: stephan) | |
| 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. | |
| 07:03 | • Edit [fbf99a2423dd20e4|fbf99a24]: Move to branch jni-threading. (artifact: d3c08acf user: stephan) | |
|
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: fbf99a24 user: stephan tags: jni-threading) | |
| 21:39 | Merge the Java Native Interface (JNI) binding into trunk. (check-in: 48b13edc user: stephan tags: trunk) | |
| 21:08 | Update wasm's push-testing rule to exclude files which were recently removed from the build. (check-in: 0a6930a7 user: stephan tags: trunk) | |
| 20:50 | Correct JNI .jar rules to only include *.java/class files, not *.* (*~ files). (Closed-Leaf check-in: 1ba77540 user: stephan tags: jni) | |
| 19:58 | Fix the mdevtest target so that it works with msvc. (check-in: 01f49448 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: 408be98d user: dan tags: trunk) | |
| 18:23 | Have the mdevtest target support the OPTS variable on unix. (check-in: 940f58d9 user: dan tags: trunk) | |
| 17:36 | Add "mdevtest" target to makefiles. Equivalent to running "devtest" on both debug and non-debug builds. (check-in: af354fbc user: dan tags: trunk) | |
| 15:37 | More JNI docs. (check-in: 290028d3 user: stephan tags: jni) | |
| 15:09 | Further simplifications in the interface of the OutputPointer family of Java classes. (check-in: 962c3e0d user: stephan tags: jni) | |
| 12:16 | Merge the latest trunk enhancements into the reuse-schema branch. (check-in: d2b0ddcc user: drh tags: reuse-schema) | |
| 10:39 | Tweaks and docs for the OutputPointer family of Java classes. (check-in: 265c8fd0 user: stephan tags: jni) | |
| 10:27 | Bind sqlite3_db_status() to JNI. (check-in: b79477a0 user: stephan tags: jni) | |
| 10:06 | Bind sqlite3_status(64)() to JNI. (check-in: cefb6614 user: stephan tags: jni) | |
|
2023-08-11
| ||
| 22:40 | Modernize the sqlite3 shell man page a bit, per forum request. (check-in: 3bc0693c user: stephan tags: trunk) | |
| 21:25 | Add timing info to SQLTester. (check-in: b69b5fac user: stephan tags: jni) | |
| 21:24 | Merge trunk into jni branch. (check-in: 4f0aeeba 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: 101de670 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: cb3cf9ba 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: 331f2f3e 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: 00bfae9f 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: 8a6b0c24 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: 6c8538d8 user: stephan tags: jni) | |
| 18:31 | Fix a problem with handling savepoints in BEGIN CONCURRENT transactions. (check-in: ca422d00 user: dan tags: bedrock) | |
| 18:25 | Fix a problem with handling savepoints in BEGIN CONCURRENT transactions. (check-in: 4a5c0439 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: c7fb32d1 user: stephan tags: jni) | |
| 17:45 | Add a doc link for the new sqlite3_js_posix_create_file(). (check-in: 0d7aac45 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: da6eaf8d 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: f3647a3a user: stephan tags: trunk) | |
| 11:46 | Merge all the latest trunk enhancements into the bedrock branch. (check-in: 859932eb user: drh tags: bedrock) | |
| 11:40 | Merge the latest trunk enhancements into the wal2 branch. (check-in: fe1bf30c user: drh tags: wal2) | |
| 11:34 | Merge the latest trunk enhancements into the begin-concurrent branch. (check-in: 7cb2b4e3 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: 00bc9f1b user: drh tags: trunk) | |
| 11:24 | Fix bug in the test case for the previous check-in. (Closed-Leaf check-in: c5daae88 user: drh tags: legacy-json-valid) | |
| 11:23 | Update test scripts specific to this branch so that they work on windows. (check-in: f0ca13ed user: dan tags: wal2) | |
| 11:22 | • Edit [15c2eadbff8e732c|15c2eadb]: Move to branch legacy-json-valid. (artifact: 143855e5 user: drh) | |
| 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: 15c2eadb 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: afe190a9 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: 746894c3 user: stephan tags: jni) | |
| 21:20 | Add tests for structured-exception-handling and wal2. Fix a problem with the same. (Leaf check-in: 87242777 user: dan tags: wal2-shm-exceptions) | |
| 20:52 | Add a working dist zip file for the JNI bits. (check-in: d6a4d212 user: stephan tags: jni) | |
| 18:58 | Experimental merge of the wal-shm-exceptions and wal2 branches. (check-in: fd58c616 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: ff54e66a user: stephan tags: jni) | |
| 18:50 | New testcase() macro in the tokenizer, to better document its behavior. (check-in: b2fdac0b user: drh tags: trunk) | |
| 17:39 | Merge trunk into jni branch for the newly-relocated version-info tool. (check-in: cc8e8cba user: stephan tags: jni) | |
| 17:32 | Move ext/wasm/version-info.c to tool/ for re-use in build other dist bundles. (check-in: 4b0871fd user: stephan tags: trunk) | |
| 17:07 | Merge latest trunk changes into this branch. (Leaf check-in: 3ed89c34 user: dan tags: wal-shm-exceptions) | |
| 17:04 | Mark test script wal2big.test as "TESTRUNNER: slow". (check-in: ae7f3bcb user: dan tags: wal2) | |
| 17:03 | Merge latest trunk changes into this branch. (check-in: 72f7807b 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: 4d635f78 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: 99c0941f 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: 2952906c user: stephan tags: jni) | |
| 11:15 | Make test completion status more visible at a glance on modern terminals. (check-in: a4e96c30 user: stephan tags: jni) | |
| 11:04 | Disable REQUIRED_PROPERTIES handling in SQLTester, per /chat. Scripts with that directive are now skipped. (check-in: ddc534cb 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: dc323d38 user: stephan tags: jni) | |
| 10:44 | Add the current --testcase name to SQLTester --verbose output. (check-in: f8736740 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: 8dd08021 user: stephan tags: jni) | |
| 05:25 | Give DbException the option of closing the db to simplify error handling in one case. (check-in: 908c9a44 user: stephan tags: jni) | |
| 05:14 | Initial version of REQUIRED_PROPERTIES support for SQLTester, with TEMPSTORE_(FILE/MEM) and RECURSIVE_TRIGGERS options. (check-in: 48d16c9d user: stephan tags: jni) | |
| 04:24 | Generic cleanups and fixes in SQLTester. (check-in: fc5d3cc3 user: stephan tags: jni) | |
| 02:09 | Change the SQLite3Jni API annotations to use SOURCE retention (used only at compile-time). (check-in: 3c3fea6b 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: 2815d676 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: e461fdd5 user: stephan tags: jni) | |
| 01:05 | Merge trunk into jni branch. (check-in: 52fa6f78 user: stephan tags: jni) | |
| 01:03 | Treat all args to --glob as a single glob. (check-in: 4737bd34 user: stephan tags: jni) | |
| 00:58 | Remove --print's ability to read ahead. (check-in: 15cfee97 user: stephan tags: jni) | |
| 00:34 | Replace the SQLTester infrastructure with a line-oriented, non-regex-heavy parser. Add --column-names command. (check-in: 88863908 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: 0cf57e5b user: stephan tags: jni) | |
| 22:30 | Correct REQUIRED_PROPERTIES handling to not fail if there are no properties. (check-in: 7a19bef4 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: 4fa2ad33 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: 43534cd0 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: f937097e user: stephan tags: jni) | |
| 17:47 | Add an extra constraint to the test-script-interpreter.md spec. (check-in: 7a07863e user: drh tags: jni) | |
| 17:23 | SQLTester --result command: do not double-{}-wrap error messages and do not throw on db error. (check-in: f7be20f5 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: f15ecb68 user: stephan tags: jni) | |
| 16:56 | Tweak the SQLTester --verbose and double-verbose output a bit for legibility. (check-in: 46b79afa 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: 0770e846 user: stephan tags: jni) | |
| 16:03 | Update the definition of "special characters" for the SQLTester and correct the code to match it. (check-in: 217f6e0c 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: 4fcc8cb0 user: stephan tags: jni) | |
| 14:47 | Add a test for the --null command. (check-in: 83ac815d user: stephan tags: jni) | |
| 14:43 | Extend SQLTester glob support with '#'. (check-in: 756ef83f user: stephan tags: jni) | |
| 14:24 | Implement the SQLTester's result escaping rules. (check-in: 61bb9508 user: stephan tags: jni) | |
| 13:51 | Add --json and --json-block SQLTester commands. (check-in: 478129d9 user: stephan tags: jni) | |
| 13:16 | Add SQLTester --tableresult command. (check-in: 8c5b6d89 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: 5323e4fd user: stephan tags: jni) | |
| 11:10 | Document SQLTester's --print command and add some argument validation to it. (check-in: ab9c945b user: stephan tags: jni) | |
| 11:05 | Rework how SQLTester's Command objects are dispatched and how TestScript stores its command entries. (check-in: f929f1f7 user: stephan tags: jni) | |
| 09:56 | Some minor tweaks in SQLTester in prep for larger refactoring. (check-in: 1d93f93a 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: 4c0ec89d user: stephan tags: jni) | |
| 21:22 | Adapt JNI build to be buildable with or without SQLTester. (check-in: adae7d78 user: stephan tags: jni) | |
| 21:05 | Add SQLTester dup() and dup_count() UDFs. Correct arg handling of the --run command. (check-in: 0dba3073 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: bb832170 user: stephan tags: jni) | |
| 20:15 | If SQLTester now treats a no-args --result as comparing against an empty string. (check-in: 49005ca5 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: 4ba98ec0 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: 3e78d22d 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: aa6de539 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: 293f6191 user: drh tags: trunk) | |
| 14:58 | Correct the spacing output of multi-select SQL blocks for SQLTester --result. (check-in: 8d98645a 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: d2c99b96 user: drh tags: jni) | |
| 14:40 | A number of baby steps for SQLTester.java. It can now handle basic --result cases. (check-in: 0404f688 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: 3aa2b5a5 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: 94628f88 user: stephan tags: jni) | |
| 11:46 | Implement the new/open/close SQLTester commands. (check-in: dc823bf0 user: stephan tags: jni) | |
| 11:46 | Add a JNI-layer sqlite3.toString() for debugging. (check-in: 45669164 user: stephan tags: jni) | |
| 10:58 | Bind sqlite3_strlike/strglob() to JNI. (check-in: eb5440f7 user: stephan tags: jni) | |
| 09:45 | SQLTester: add print command and improve argument error reporting infrastructure. (check-in: 1b6e84f6 user: stephan tags: jni) | |
| 00:59 | Add missing license header. Minor cleanups in SQLTester. (check-in: 5be50fd5 user: stephan tags: jni) | |
| 00:37 | Rework SQLTester dispatching and add stub impls for several commmands. (check-in: 9e61af75 user: stephan tags: jni) | |
|
2023-08-07
| ||
| 23:59 | Add command dispatcher to SQLTester. (check-in: e0a06931 user: stephan tags: jni) | |
| 23:04 | SQLTester now ignores tests which contain constructs specified in the spec doc. (check-in: ecaeee65 user: stephan tags: jni) | |
| 22:32 | SQLTester can now split a test script into a series of individual commands. (check-in: d3d1accc user: stephan tags: jni) | |
| 22:02 | SQLTester can now read a script and strip it of all noise content. (check-in: 59bd3928 user: stephan tags: jni) | |
| 21:04 | Initial skeleton for adding an SQL-driven test script interpreter for the JNI bindings. (check-in: 2aa8f0ed 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: 27ff86e4 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: 16cd2161 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: 2d44720d 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: 9a494394 user: stephan tags: jni) | |
| 10:01 | JNI API renaming to better match the C API. (check-in: 6e0bd03d 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: 2ca064d8 user: stephan tags: trunk) | |
| 01:06 | Make sqlite3_stmt() Java ctor private - it's only constructed from JNI code. (check-in: ce82c42f user: stephan tags: jni) | |
| 00:29 | Minor internal cleanups and additional test metrics. (check-in: fa0a6b6e user: stephan tags: jni) | |
| 00:06 | Bind the auto-extension APIs to JNI. (check-in: 746a5fa0 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: 34da294a 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: 644999ca 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: 77a32d23 user: stephan tags: jni) | |
| 15:01 | Doc cleanups. (check-in: 5f56b007 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: 6119289d user: stephan tags: jni) | |
| 13:02 | JNI-internal cleanups and API renaming. Add a C-side java-string-to-utf8 conversion. (check-in: 672d8579 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: ebcfc237 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: 07dd082c 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: 586720fa user: stephan tags: jni) | |
|
2023-08-05
| ||
| 22:41 | Bind sqlite3_set_authorizer() to JNI. (check-in: e0fa0313 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: 9dd8b784 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: 7468f876 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: 7d4ac44e user: stephan tags: jni) | |
| 19:15 | Tiny doc typo fixes from forum post 31eb707250. No code changes. (check-in: 8ede5008 user: stephan tags: trunk) | |
| 12:48 | JNI internal refactoring and cleanups. (check-in: 7397973a 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: e4383737 user: stephan tags: jni) | |
| 04:30 | Add missing Fts5PhraseIter.java to the build. (check-in: 96281ad0 user: stephan tags: jni) | |
| 04:23 | Bind fts5_api::xCreateFunction() to JNI and demonstrate it with a test. (check-in: c653bf16 user: stephan tags: jni) | |
| 01:28 | Start adding fts5_api to JNI. (check-in: 14d18fe9 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: 23383c1d 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: a617ebf4 user: stephan tags: trunk) | |
| 15:38 | More work on the JNI binding of fts5 customization (still a long ways to go). (check-in: 1a246fd2 user: stephan tags: jni) | |
| 13:29 | Merge the json_remove() bug fix from trunk into the bedrock branch. (check-in: a8872aa5 user: drh tags: bedrock) | |
| 13:27 | Eliminate code duplication in the two JNI tester classes. (check-in: 63e7bbe3 user: stephan tags: jni) | |
| 13:24 | Merge the json_remove() bug fix from trunk into the wal2 branch. (check-in: e6c066ca 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: ba7a66db 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: b7a8428f user: stephan tags: jni) | |
| 12:44 | More work towards binding FTS5 customization to JNI. Add Fts*.java files missing from previous checkin. (check-in: 91263178 user: stephan tags: jni) | |
| 11:10 | Change comment on Fts5ExtensionApi.iVersion from "always set to 3" to "always set to 2". (check-in: b7de399c user: dan tags: trunk) | |
| 11:08 | Start including fts5 customization bits into JNI, but it's far from functional. (check-in: abaf5edd user: stephan tags: jni) | |
| 09:53 | Improve internal error handling in the JNI create_function() impl. (check-in: 2c88390f 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: 031c9a76 user: stephan tags: trunk) | |
| 08:41 | Part 2 of the fix from [a0f808363318c00fd1db78b]. (check-in: 5c310422 user: stephan tags: trunk) | |
| 08:39 | More work towards fts5 customzation in JS. (Leaf check-in: ce2a65d8 user: stephan tags: wasm-fts5) | |
|
2023-08-03
| ||
| 23:26 | Merge the latest trunk enhancements into the bedrock branch. (check-in: 877ffece user: drh tags: bedrock) | |
| 23:22 | Merge the latest trunk enhancements into the wal2 branch. (check-in: 6fa71e11 user: drh tags: wal2) | |
| 22:43 | Minor internal cleanups in the JS-side fts5 cleanup steps. (check-in: 2666f52e 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: f4b9743a 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: 795f2242 user: stephan tags: wasm-fts5) | |
| 20:02 | Part 2 of the fix from [a0f808363318c00fd1db78b]. (check-in: ce0674b1 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: a0f80836 user: stephan tags: wasm-fts5) | |
| 18:14 | Fix harmless scan-build warnings. (check-in: 65a8716d user: drh tags: trunk) | |
| 16:22 | Fix a discrepancy between sqlite3_values_to_js() and its API docs/intended behavior. (check-in: 7b85c68f user: stephan tags: trunk) | |
| 16:21 | More infrastructure towards binding FTS5 customization support to WASM. (check-in: 163e3e44 user: stephan tags: wasm-fts5) | |
| 16:02 | Fix a discrepancy between sqlite3_values_to_js() and its API docs/intended behavior. (check-in: 16658b3c user: stephan tags: wasm-fts5) | |
| 13:30 | Fix build problems associated with SQLITE_OMIT_WSD and SQLITE_OMIT_TRIGGER. (check-in: de031a5e 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: 976e39c6 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: 779d5dc8 user: drh tags: trunk) | |
| 10:36 | • Edit [86bb464f31b77ac7|86bb464f]: Mark "Closed". Edit check-in comment. (artifact: df5c5658 user: stephan) | |
| 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: 52c8b73a 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: 8e7a70b2 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: 306b269a user: stephan tags: jni) | |
| 17:20 | Internal doc additions in the JNI bits. (check-in: b5664364 user: stephan tags: jni) | |
| 16:06 | Performance optimization for JSON rendering logic. (check-in: ea0b9aec user: drh tags: trunk) | |
| 13:45 | Remove an unreachable branch in the ascii-to-floating-point conversion that was added by [e989a37ff9d5b52e]. (check-in: c4347e44 user: drh tags: trunk) | |
| 13:38 | Stricter enforcement of the idea that a MATERIALIZED common table expression is an optimization fence. (check-in: 354425f8 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: f068f105 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: 165b9bda 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: b7ef9796 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: aa769ee7 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: e989a37f user: drh tags: trunk) | |
| 16:41 | Filter the wasmfs-specific JS module result type check out of non-wasmfs builds. (check-in: ef7c1210 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: 6011bc26 user: stephan tags: trunk) | |
| 16:17 | Fix part 1 of 2 for /fiddle not running: build flags which were renamed during refactoring. (check-in: 214ffeef user: stephan tags: trunk) | |
| 11:03 | Fix an assert() in fts5_index.c that might fail when dealing with corrupt records. (check-in: aa55c83f user: dan tags: trunk) | |
| 10:19 | More docs for the Java side of the JNI bindings. (check-in: d8e9bcee user: stephan tags: jni) | |
| 09:44 | Internal exception-handling cleanups in the JNI bindings. (check-in: 057b1d4f user: stephan tags: jni) | |
| 08:48 | Minor JNI-related doc tweaks and code re-ordering. (check-in: b663b27e user: stephan tags: jni) | |
| 01:07 | Remove redundant comparison operator. (check-in: 01898432 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: 42916af9 user: drh tags: trunk) | |