50 most recent check-ins
|
2026-07-22
| ||
| 14:16 | Fix an error handling case in #base64. (leaf check-in: f8c408f662 ... user: stephan tags: trunk) | |
| 14:06 | Add (#base64 -f filename) support to the preprocessor and slightly simplify the wasm embedding with it. Fix a bug in the preprocessor's @token@ call expansion when the length of the configured @ is greater than 1 byte. (check-in: 1e90bedec9 ... user: stephan tags: trunk) | |
| 12:55 | Do not cache the results of getenv() in the temporary filename generation logic as that might result in a UAF if an environment variable value is modified using setenv() or similar. (check-in: cefd5807d8 ... user: drh tags: trunk) | |
| 11:24 |
Improvements to the unix temporary filename generator so that it continues
to work even after SQLITE_TMPDIR or TMPDIR environment variables are
changed by the application. | |
|
2026-07-21
| ||
| 23:54 | Remove an unnecessary munmap() from the unix interface. (check-in: 5fc1ede8b2 ... user: drh tags: trunk) | |
| 20:56 | Random makefile doc updates. No functional changes. (check-in: 014ef252c7 ... user: stephan tags: trunk) | |
| 20:45 | Update some Tcl tests to work with filcc. Many changes still to come. (leaf check-in: 5504814bab ... user: dan tags: tcl-tests-filcc) | |
| 20:18 | Random minor doc and formatting cleanups in the wasm makefile generator. (check-in: a24064919b ... user: stephan tags: trunk) | |
| 19:12 | Restructure an errant goto which only accidentally never broke anything. Add some debug output to mkwasmbuilds.c. (check-in: 0ca4e748e1 ... user: stephan tags: trunk) | |
| 16:58 | The base64.wasm=1 flag to ext/wasm/GNUmakefile tells it to embed each resulting WASM file directly in its counterpart JS file base64-encoded. This is roughly 20% larger and saves a network request but is overall less efficient so will not be the new default. It may be interesting for custom builds, in particular for server-side node.js. (check-in: 7a06190b71 ... user: stephan tags: trunk) | |
| 16:43 | Document the origin of the input size limit for #base64. No functional changes. (closed check-in: 696988aac3 ... user: stephan tags: wasm-base64) | |
| 16:29 | Simplify the previous checkin by removing an extraneous local var. (check-in: 6382d8336e ... user: stephan tags: wasm-base64) | |
| 16:23 | Fix the corner case of feeding #base64 empty input. (check-in: 999d201971 ... user: stephan tags: wasm-base64) | |
| 16:12 | Consolidate a duplicated code block and ensure that the new filtering of the final JS files makes them read/write so that rebuilds without a clean between them work. (check-in: 8b013184e4 ... user: stephan tags: wasm-base64) | |
| 16:04 | Add support for (make base64.wasm=1), which embeds sqlite3.wasm into its corresponding JS file as base64. A very expensive calculator which was fed the resulting file sizes assures me that the two-file approach is, in the aggregate, more efficient both in terms of overall network bandwidth (+~20% bigger for base64) and client-side memory usage (streaming vs non-streaming wasm compilation), so we'll shelve this as an interesting experiment or maybe for use by custom builds. (check-in: a167aee751 ... user: stephan tags: wasm-base64) | |
| 13:28 | This embeds sqlite3.wasm into sqlite3.js/mjs as base64 but is applied globally - it still needs to be made configurable. (check-in: 0467a0f826 ... user: stephan tags: wasm-base64) | |
| 12:57 | An initial attempt at embedding sqlite3.wasm into sqlite3.js using base64. This produces a chicken-egg situation in the build because the input file where the blob belongs is injested by emscripten (which generates the wasm file from which that blob is to be generated), so it does not work as-is but is being set aside for later. We'll need to add a second preprocessing step which uses a different #directive delimiter to keep it hidden inside the first pass, then squeeze the wasm file in through ... (check-in: 538199cf62 ... user: stephan tags: wasm-base64) | |
| 10:44 | Latest upstream ext/wasm/libcmpp.c, primarily to make it filcc-legal (only the final chunk in the diff - the rest is minor changes accumulated since the last update). (check-in: 06f3bbc5bd ... user: stephan tags: trunk) | |
|
2026-07-20
| ||
| 21:03 | Improve performance and robustness of internal routine jsonBlobExpand(). (check-in: 099af17c6f ... user: drh tags: trunk) | |
| 20:23 | Add tests to verify that the problem reported by forum post 2026-07-20T18:27:00Z is only a problem on branch-3.53, not on this branch. (check-in: 6384b4b872 ... user: dan tags: trunk) | |
| 20:15 | Ensure that a hot journal is rolled back in the case where a process or system crash results in a corrupt super-journal record where the magic and length values are correct but the super-journal name and checksum fields are both zeroed. Forum post 2026-07-20T18:27:00Z. (leaf check-in: bf70dadc2d ... user: dan tags: branch-3.53) | |
| 20:03 | Improved detection and reporting of deliberate misinformation in the sqlite_schema table. (check-in: 760af4e455 ... user: drh tags: trunk) | |
| 19:17 | Remove an incorrect ALWAYS() macro from the implementation of the internal exprNodeCanReturnSubtype() routine so that it works with zero-argument deterministic functions like pi(). (check-in: a2511c6223 ... user: drh tags: trunk) | |
| 17:53 | Ensure that a write with REPLACE conflict resolution on an integer primary key column is handled after any IGNORE or FAIL conflicts, even if there is also an explicit "ON CONFLICT" clause unrelated to the IPK. Forum post 2026-07--17T09:30:42Z. Also fix a problem whereby a trigger fired by REPLACE conflict resolution might cause a UNIQUE conflict violation to be committed to the database. Forum post 2026-07-18T09:45:24Z. (check-in: 8f0ad8f33f ... user: dan tags: trunk) | |
| 16:45 | Additional test cases. (closed check-in: 3ae4f953de ... user: drh tags: do-nothing-replace-bug) | |
| 14:37 | Move the new test cases for this branch into a new *.test file. (check-in: 7bdce4ec3b ... user: drh tags: do-nothing-replace-bug) | |
| 13:20 | Experimental "PRAGMA auto_strict=ON;" automatically appends the STRICT modifier to all new CREATE TABLE statements. Proof of concept only. I suspect that this is a bad idea. (leaf check-in: 6432fea8b4 ... user: drh tags: auto-strict) | |
| 11:50 | Performance improvement in the sqlite3_initialize() interface. (check-in: 4ad701b085 ... user: drh tags: trunk) | |
|
2026-07-19
| ||
| 19:49 | Fix boundary cases of rowid lookup using very large floating point values - values near the minimum and maximum 64-bit signed integer. Forum 2026-07-19T07:31:46Z. (check-in: 987ba5a3dc ... user: drh tags: trunk) | |
| 12:56 | Latest upstream jimsh0.c for minor portability improvements and cleanups. (check-in: 436cf63e94 ... user: stephan tags: trunk) | |
|
2026-07-18
| ||
| 19:49 | Test case fixes due to the previous. (check-in: 9236658232 ... user: drh tags: do-nothing-replace-bug) | |
| 19:31 | After a DELETE trigger is fired by REPLACE conflict handling, retest all UNIQUE constraints to ensure that the row being inserted or updated does not conflict with one written by the DELETE trigger. Abort the statement if it does. Possible fix for forum post 2026-07-18T03:35:48Z. (check-in: e2ab286bb7 ... user: dan tags: do-nothing-replace-bug) | |
| 17:47 | Disqualify the count-of-view optimization if the view is really a correlated subquery. Forum post 2026-07-18T10:23:43Z. (check-in: bb65c3adcd ... user: drh tags: trunk) | |
| 13:34 | Update tcl test command "optimization_control" to support the "count-of-view" optimization. (check-in: b14c3f8fec ... user: dan tags: trunk) | |
| 09:04 | Enhancements to new test cases, for improved readability. (check-in: 053e0d1f01 ... user: drh tags: do-nothing-replace-bug) | |
| 08:46 | Add test cases from Forum Post 2026-07-18T03:35:48Z. New test cases are currently failing, as new or alternative fixes are needed for the original problem. (check-in: 49b67b7da6 ... user: drh tags: do-nothing-replace-bug) | |
|
2026-07-17
| ||
| 23:35 | Ensure that a write with REPLACE conflict resolution on an integer primary key column is handled after any IGNORE or FAIL conflicts, even if there is also an explicit "ON CONFLICT" clause unrelated to the IPK. (closed check-in: faf41f98ea ... user: drh tags: mistake) | |
| 23:29 | Ensure that a write with REPLACE conflict resolution on an integer primary key column is handled after any IGNORE or FAIL conflicts, even if there is also an explicit "ON CONFLICT" clause unrelated to the IPK. (closed check-in: 433edc4626 ... user: drh tags: mistake) | |
| 23:25 | Additional test cases (check-in: da16fe363e ... user: drh tags: do-nothing-replace-bug) | |
| 16:26 | Ensure that a write with REPLACE conflict resolution on an integer primary key column is handled after any IGNORE or FAIL conflicts, even if there is also an explicit "ON CONFLICT" clause unrelated to the IPK. Forum post 2026-07-17T09:30:42Z. (check-in: 1875249ab3 ... user: dan tags: do-nothing-replace-bug) | |
| 00:27 | Add the SQLITE_SHELL_EDITION compile-time option, which if set to a date number of the form YYYYMMDD will try to configure the defaults to be similar to the latest release at or prior to that date. (check-in: 1d84dc151b ... user: drh tags: branch-3.53) | |
|
2026-07-16
| ||
| 23:55 | Add the SQLITE_SHELL_EDITION compile-time option, which if set to a date number of the form YYYYMMDD will try to configure the defaults to be similar to the latest release at or prior to that date. (check-in: 6924895d2c ... user: drh tags: trunk) | |
| 13:17 | Relax the restrictions on reordering tables in vtab queries that occur to the right of a LEFT or CROSS JOIN but are not actually the RHS of said join. (check-in: 9062c79fc2 ... user: dan tags: trunk) | |
|
2026-07-15
| ||
| 19:19 | Relax the restrictions on reordering tables in vtab queries that occur to the right of a LEFT or CROSS JOIN but are not actually the RHS of said join. (closed check-in: 7df34b446e ... user: dan tags: vtab-outer-joins) | |
|
2026-07-14
| ||
| 17:02 | Adjust QRF to generate lower-case HTML output with the SQLITE_STYLE_Html style setting. (check-in: 4be8630e05 ... user: drh tags: trunk) | |
| 14:52 | Remove harmless "breakpoint" command inserted by the previous check-in (check-in: 5a4b0b81de ... user: drh tags: trunk) | |
| 14:30 | Update some test cases in fts5corrupt3.test and fts5corruptB.test to account for recent updates to database and record corruption detection. (check-in: a508bb8f88 ... user: drh tags: branch-3.53) | |
| 11:46 | Update some test cases in fts5corrupt3.test and fts5corruptB.test to account for recent updates to database and record corruption detection. (check-in: a48f4cf312 ... user: dan tags: trunk) | |
| 10:31 | Safer conversion from double to 64-bit integer in two places. (check-in: a210f6f939 ... user: drh tags: branch-3.53) | |
|
2026-07-13
| ||
| 14:52 | Add assert()s and a testcase() to and fix and improve comments in the percentSort() routine. (check-in: be673351eb ... user: drh tags: trunk) | |
