]> git.ipfire.org Git - thirdparty/sqlite.git/log
thirdparty/sqlite.git
3 months agoFix harmless display bug in previous check-in. Add the -noinit command-line
drh [Fri, 14 Nov 2025 19:04:23 +0000 (19:04 +0000)] 
Fix harmless display bug in previous check-in.  Add the -noinit command-line
option to bypass reading the ~/.sqliterc file.

FossilOrigin-Name: 229650a01dcd9cc4b39526d661106e9c3eb2f90ca7fbed8adc6e6fe85ef3fdaa

3 months agoAdd the --tag and --list options to the ".mode" command.
drh [Fri, 14 Nov 2025 18:41:21 +0000 (18:41 +0000)] 
Add the --tag and --list options to the ".mode" command.

FossilOrigin-Name: 9daf98c2f449688b7463b71dfa926cb4ae96d8c7ee34946df2172bb37f7c5616

3 months agoAdd the --once option to the .mode command. Improvements to help text.
drh [Fri, 14 Nov 2025 17:11:06 +0000 (17:11 +0000)] 
Add the --once option to the .mode command.  Improvements to help text.

FossilOrigin-Name: 253980122a35f787423aaeedbec12ec94b31768f245fe1c1fcc7e08911855c60

3 months agoFix harmless compiler warnings. Incorporate "USAGE:" comments on dot-command
drh [Fri, 14 Nov 2025 14:59:43 +0000 (14:59 +0000)] 
Fix harmless compiler warnings.  Incorporate "USAGE:" comments on dot-command
implementations into the CLI ".help" command output.

FossilOrigin-Name: 046bfab4a01e8a7cc58d1bdf0756c90ba354562d79e5453c08202daf648e76a6

3 months agoFix various bugs and compiler warnings. All tests now passing on linux, mac,
drh [Fri, 14 Nov 2025 13:07:45 +0000 (13:07 +0000)] 
Fix various bugs and compiler warnings.  All tests now passing on linux, mac,
and windows.  More testing needed, though.

FossilOrigin-Name: 2220cb70c2f1ee30dcdf917a20feacdfcb3789433d0645fea626fd4c5cf0d099

3 months agoMerge compiler-warning fix from trunk into the qrf branch.
drh [Fri, 14 Nov 2025 11:06:27 +0000 (11:06 +0000)] 
Merge compiler-warning fix from trunk into the qrf branch.

FossilOrigin-Name: 6ffab43ca32230975e79d91080dfa2e80a4c21deef31ab86455581af18a399cd

3 months agoFix a harmless compiler warning in testing code.
drh [Fri, 14 Nov 2025 11:02:49 +0000 (11:02 +0000)] 
Fix a harmless compiler warning in testing code.

FossilOrigin-Name: 5252a2e629e1adb61169d32ca6458c6decd1ec562f358bb9d0b448a2f0243c56

3 months agoFix a memory error in the .schema command.
drh [Fri, 14 Nov 2025 10:42:29 +0000 (10:42 +0000)] 
Fix a memory error in the .schema command.

FossilOrigin-Name: 3300ed34b5a3598c46cdc4bdf1e9e81818a5029585ae917424f64c11c718bfa8

3 months agoSuppress a harmless compiler warning.
drh [Fri, 14 Nov 2025 03:26:48 +0000 (03:26 +0000)] 
Suppress a harmless compiler warning.

FossilOrigin-Name: 89cf1de7b6abff567c70d52a415eea6deb52fc13c3008c1266a77b61e3711217

3 months agoMerge all the latest trunk enhancements into the qrf branch.
drh [Fri, 14 Nov 2025 02:27:58 +0000 (02:27 +0000)] 
Merge all the latest trunk enhancements into the qrf branch.

FossilOrigin-Name: 97b06e58ed128a1d60b89437ddf0ad80df528b8dbfdb6a7637374fc1ab4ddb10

3 months agoImprovements to --titles handling in the .mode command. Fix shell1 test
drh [Fri, 14 Nov 2025 02:22:39 +0000 (02:22 +0000)] 
Improvements to --titles handling in the .mode command.  Fix shell1 test
cases having to do with quoting of NULL values in "tcl" mode.

FossilOrigin-Name: 0fef770bd654b8ba8011b0bb610128058e75e8444f86c51e7ea59a6f2625a3fc

3 months agoA better fix for the issue with RETURNING triggers on eponymous virtual tables and...
dan [Thu, 13 Nov 2025 20:37:09 +0000 (20:37 +0000)] 
A better fix for the issue with RETURNING triggers on eponymous virtual tables and SQLITE_SCHEMA errors first addressed by [45d820ca22].

FossilOrigin-Name: bf399992cb98e5d5f002a90b521328d5c2f113ebab8601653452d78222077bde

3 months agoAdd an OOM test case for the issue with dropping RETURNING triggers when the schema...
dan [Thu, 13 Nov 2025 18:02:22 +0000 (18:02 +0000)] 
Add an OOM test case for the issue with dropping RETURNING triggers when the schema is reset while preparing a statement that uses an eponymous vtab.

FossilOrigin-Name: dc569288dd63754269e14be7a9937c882531685a3e9caec25f86ec8c01eb9583

3 months agoAdd better test case for the issue with dropping RETURNING triggers when the schema...
dan [Thu, 13 Nov 2025 17:42:55 +0000 (17:42 +0000)] 
Add better test case for the issue with dropping RETURNING triggers when the schema is reset while preparing a statement.

FossilOrigin-Name: 6a9fdde109865b23888f099d066721404e8b853f3dacd55ce08c8bbda2491ec3

3 months agoGeneric makefile cleanups and doc updates.
stephan [Thu, 13 Nov 2025 17:37:40 +0000 (17:37 +0000)] 
Generic makefile cleanups and doc updates.

FossilOrigin-Name: e8b34b4178be621102dac165b716283055fad90b3edc2394f56a24f9f0149448

3 months agoInternal doc fix (renamed file).
stephan [Thu, 13 Nov 2025 16:38:45 +0000 (16:38 +0000)] 
Internal doc fix (renamed file).

FossilOrigin-Name: cb8fb01fe19ba3af536a662aed894b2b0eb2463c8d34c644c498234fd82122f3

3 months agoJS code reformatting and doc updates. No functional changes.
stephan [Thu, 13 Nov 2025 15:33:44 +0000 (15:33 +0000)] 
JS code reformatting and doc updates. No functional changes.

FossilOrigin-Name: c566c653e4f55afa0660e819ed5b1fd96cb9b24bc78c333adcd8825331a9dd26

3 months agoAdd the #include -raw flag to ext/wasm/c-pp-lite.c to support a pending feature.
stephan [Thu, 13 Nov 2025 14:47:41 +0000 (14:47 +0000)] 
Add the #include -raw flag to ext/wasm/c-pp-lite.c to support a pending feature.

FossilOrigin-Name: 42c30c314969c0f2573bbe36615683ac19a7ba4e30004c7080873459096caaf5

3 months agoGet --screenwidth auto working on linux and windows.
drh [Thu, 13 Nov 2025 11:52:34 +0000 (11:52 +0000)] 
Get --screenwidth auto working on linux and windows.

FossilOrigin-Name: 48a91f2067005f7f186484354be07384dd76bcfff8427c17579f6e32201e3742

3 months agoFix a problem in the EXISTS-to-JOIN optimization ([e33da6d5dc964db8]) so
drh [Thu, 13 Nov 2025 11:36:48 +0000 (11:36 +0000)] 
Fix a problem in the EXISTS-to-JOIN optimization ([e33da6d5dc964db8]) so
that it works with nested WHERE and EXISTS statements.
[forum:/forumpost/0704c3c41e49631b|Forum post 0704c3c41e4]

FossilOrigin-Name: d1e901eddc25175174d0706238ae0c33bfa5569e0c2ba4f1164b7a9600203442

3 months agomkwasmbuilds.c doc updates. Merge in the parts of [8611cf643b] which are not contentious.
stephan [Thu, 13 Nov 2025 09:03:48 +0000 (09:03 +0000)] 
mkwasmbuilds.c doc updates. Merge in the parts of [8611cf643b] which are not contentious.

FossilOrigin-Name: cb0f0e22241aae65938b4bc7a1b809088466a17cee80344f66ee889a76c422c1

3 months agoTeach c-pp to export its argv as a #define list so that we can embed it in the genera...
stephan [Thu, 13 Nov 2025 08:26:11 +0000 (08:26 +0000)] 
Teach c-pp to export its argv as a #define list so that we can embed it in the generates files.

FossilOrigin-Name: 42f95ea71e5e7e927685de3a6da2ede38abe7cabdd1fc71b9a14bebe9f54a65e

3 months agoDoc typo fix reported in [forum:00e49e9aa1|forum post 00e49e9aa1].
stephan [Thu, 13 Nov 2025 07:07:28 +0000 (07:07 +0000)] 
Doc typo fix reported in [forum:00e49e9aa1|forum post 00e49e9aa1].

FossilOrigin-Name: 36cd33f634a45900f6e52ba07aa20242a5f2b29c7cbe19be968c52ffef34fcde

3 months agoMinor doc correction and a JS error message tweak.
stephan [Thu, 13 Nov 2025 06:49:12 +0000 (06:49 +0000)] 
Minor doc correction and a JS error message tweak.

FossilOrigin-Name: c4ae21c89e5fd40eefd4916df6c6a6c4e27075a434a9d47576d3fcfbc7720588

3 months agoImplement the --titles option to the .mode command.
drh [Wed, 12 Nov 2025 20:50:08 +0000 (20:50 +0000)] 
Implement the --titles option to the .mode command.

FossilOrigin-Name: cc25643ebc516db0799406797e9961a2af574875ae9639178b722dbc280c96ad

3 months agoMore details on the format of the QRF_STYLE_Json and QRF_STYLE_JOBject.
drh [Wed, 12 Nov 2025 19:03:05 +0000 (19:03 +0000)] 
More details on the format of the QRF_STYLE_Json and QRF_STYLE_JOBject.

FossilOrigin-Name: 2b22321df9c2f51e4b0ab9e4da859c58bb3f194ad69c22b9d32b35831740f9dd

3 months agoContinuing code cleanup. Various minor bug fixes. All legacy tests now
drh [Wed, 12 Nov 2025 18:54:09 +0000 (18:54 +0000)] 
Continuing code cleanup.  Various minor bug fixes.  All legacy tests now
pass.  All planned features for ".mode" are implemented, at least at the
interface level, though some features are still no-ops.

FossilOrigin-Name: e5a81711d0076b447e5bd3206bc04d755a6229b9f4926f42260fcd01ecf3e5a2

3 months agoClarify that 'pikchr' is not a typo.
stephan [Wed, 12 Nov 2025 17:25:17 +0000 (17:25 +0000)] 
Clarify that 'pikchr' is not a typo.

FossilOrigin-Name: d7bb2ee6ec23c266c887fb2aeb77b0b17cd8f1429564d341537f57c5478410e2

3 months agoAdd a new direct CLI testing script in test/modeA.clitest to demonstration
drh [Wed, 12 Nov 2025 13:46:11 +0000 (13:46 +0000)] 
Add a new direct CLI testing script in test/modeA.clitest to demonstration
that can be done.  Rig this this to be run by test/shellB.test during normal
testing.

FossilOrigin-Name: 3107ebb9e1602fe5bed644c6f69426bebf307772e581b17a8fa3e50bd522e566

3 months agoRename QRF_STYLE_JsonLine to QRF_STYLE_JObject. Add new convenience modes
drh [Wed, 12 Nov 2025 12:44:02 +0000 (12:44 +0000)] 
Rename QRF_STYLE_JsonLine to QRF_STYLE_JObject.  Add new convenience modes
to the CLI and generally refactor and improve the ".mode" command.  Some
tests are failing, mostly due to changes in error message output and similar.

FossilOrigin-Name: 4c8109682e3a224fd8e015e73a9c1c7b6d56ad747d7ca7bc387bb92e1c98f731

3 months agoMinor refactoring of some field names in the sqlite3_qrf_spec object, to try
drh [Tue, 11 Nov 2025 18:07:42 +0000 (18:07 +0000)] 
Minor refactoring of some field names in the sqlite3_qrf_spec object, to try
to make the names more intuitive, memorable, and succinct.

FossilOrigin-Name: 3450bc7eecb717abedbaeb56dc824e14eb35ed30322fe3dd3b4b1cbd5fd14c60

3 months agoMove the ".output" command into a separate subroutine. Enhance .output so
drh [Tue, 11 Nov 2025 14:08:50 +0000 (14:08 +0000)] 
Move the ".output" command into a separate subroutine.  Enhance .output so
that it is able to capture output in a sqlite3_str object, then compare that
captured output we patterns to accomplish tests.

FossilOrigin-Name: ddd167044753f5215624fc9ee0e3657836c528f23a6a3e262401fd1b64cdbb21

3 months agoFactor the code for ".mode" out of do_meta_command() and into its own
drh [Tue, 11 Nov 2025 00:44:25 +0000 (00:44 +0000)] 
Factor the code for ".mode" out of do_meta_command() and into its own
subroutine, to show how the new infrastructure makes this easy.  We need
to do the same for all the dot-commands.  At the same time, add the
-textjsonb option to .mode.

FossilOrigin-Name: b48aa054df488747a7db56faf1cd0da42e322edff60650b9187448e58eb12def

3 months agoBug fixes. All tests are now passing.
drh [Tue, 11 Nov 2025 00:21:26 +0000 (00:21 +0000)] 
Bug fixes.  All tests are now passing.

FossilOrigin-Name: a0fc99a3bdd12f9ac69511c1aea2bd9a3d5de593d44b4a732cfc8f48e0931c76

3 months agoRevamp the internal data structures that the CLI uses for tracking and
drh [Mon, 10 Nov 2025 23:40:40 +0000 (23:40 +0000)] 
Revamp the internal data structures that the CLI uses for tracking and
managing the display mode.  This is an incremental check-in.  The code
compiles and runs, but not all tests are passing.

FossilOrigin-Name: 8cc581e53c2ab15bd311e082048b7c57b03a754d25c0b4beead08a3362ac1c7a

3 months agoKeep explicit NULL values in QRF_STYLE_Json output.
drh [Mon, 10 Nov 2025 22:05:42 +0000 (22:05 +0000)] 
Keep explicit NULL values in QRF_STYLE_Json output.

FossilOrigin-Name: cb07f3d441b0b2a3ebdfaa9456891a9c8e33fa07b967532a9edfaf6ff3163cb0

3 months agoMerge all the latest trunk improvements into the qrf branch.
drh [Mon, 10 Nov 2025 20:11:36 +0000 (20:11 +0000)] 
Merge all the latest trunk improvements into the qrf branch.

FossilOrigin-Name: 1fc2298edc67cbaf1963ed858a36cab15f670c00779ace6b63bdd266b0dbaaf2

3 months agoImproved concurrency for "make devtest" by splitting fuzzdata1.db and
drh [Mon, 10 Nov 2025 20:01:39 +0000 (20:01 +0000)] 
Improved concurrency for "make devtest" by splitting fuzzdata1.db and
fuzzdata2.db into slices for asan and ubsan testing.

FossilOrigin-Name: 2c31176607f02a73cf2626cda2dd0711ae74bdf0b4520d4c84ff299c860e419e

3 months agoAvoid dropping RETURNING triggers when the schema is reset while preparing a statement.
dan [Mon, 10 Nov 2025 19:11:15 +0000 (19:11 +0000)] 
Avoid dropping RETURNING triggers when the schema is reset while preparing a statement.

FossilOrigin-Name: 45d820ca227eb1ade4dda498b0f94b2c5df4bab3fc5fcdd517ee125a43d16f4d

3 months agoImproved argument parsing and error message infrastructure for
drh [Mon, 10 Nov 2025 18:39:33 +0000 (18:39 +0000)] 
Improved argument parsing and error message infrastructure for
dot-commands in the CLI.

FossilOrigin-Name: 23d5d09db8eae33b250cb8c86b6e6790fc9d5a62ca16df77d8aa881405da66fa

3 months agoAvoid dropping RETURNING triggers when the schema is reset while preparing a statement. returning-fix
dan [Mon, 10 Nov 2025 17:37:59 +0000 (17:37 +0000)] 
Avoid dropping RETURNING triggers when the schema is reset while preparing a statement.

FossilOrigin-Name: e26bcef7522a6f6ee8d55fa30e7fe06419566cf4e8c2df0c33c92a4c89f58c05

3 months agoThe ".www" command is now handled by QRF. So at this point, QRF handles
drh [Mon, 10 Nov 2025 15:56:18 +0000 (15:56 +0000)] 
The ".www" command is now handled by QRF.  So at this point, QRF handles
all query result formatting in the CLI and the legacy formatter has been
removed from the code.

FossilOrigin-Name: 35d4c7151e63c3f105a11dddc853666ae19cfca190204847a42f2b2a5641e95d

3 months agoRewrite the ".schema" and ".fullschema" commands in the CLI so as to
drh [Mon, 10 Nov 2025 15:01:57 +0000 (15:01 +0000)] 
Rewrite the ".schema" and ".fullschema" commands in the CLI so as to
eliminate the need for MODE_Pretty and MODE_Semi.

FossilOrigin-Name: 0eb0410f725eed44973cf8712ab2d24c16fb5cbb249b5780f8fe5d41b2193d79

3 months agoAdd the bTextNull field to sqlite3_qrf_spec. Use QRF to implement "tcl"
drh [Mon, 10 Nov 2025 12:32:04 +0000 (12:32 +0000)] 
Add the bTextNull field to sqlite3_qrf_spec.  Use QRF to implement "tcl"
mode in the CLI.

FossilOrigin-Name: 2ba92320db3c16c3c91e29ea935ae92da546261f25846d242bd2dd27e0b7e032

3 months agoFix a missing va_end() call in the intckMprintf() function of the
drh [Mon, 10 Nov 2025 11:05:36 +0000 (11:05 +0000)] 
Fix a missing va_end() call in the intckMprintf() function of the
incremental integrity-check extension.

FossilOrigin-Name: 62ad2350e368dc337ba2d0fb6847d07c40a6f79520dd6414d22b5b54983b0b12

3 months agoA more compact fix for the problem first fixed by [5f5a736f88].
dan [Mon, 10 Nov 2025 11:00:41 +0000 (11:00 +0000)] 
A more compact fix for the problem first fixed by [5f5a736f88].

FossilOrigin-Name: 7a644178c8d289ca18631844b2d73b32fddc72afcc80906633dd38c14eba2ca9

3 months agoHave sqlite3_set_errmsg() return SQLITE_MISUSE if a NULL db handle is passed to it...
dan [Mon, 10 Nov 2025 10:47:29 +0000 (10:47 +0000)] 
Have sqlite3_set_errmsg() return SQLITE_MISUSE if a NULL db handle is passed to it, as documented.

FossilOrigin-Name: 5f5a736f88bc9bc6c9c83d2cbfd74c0b5357d7417d9993d34a78f0b7317ff796

3 months agoMerge all the latest trunk fixes, and especially the fix for the ".www"
drh [Mon, 10 Nov 2025 10:46:55 +0000 (10:46 +0000)] 
Merge all the latest trunk fixes, and especially the fix for the ".www"
command in the CLI, into the qrf branch.

FossilOrigin-Name: 07a5523cf27fd7c1d8fbc5cde80cb45fadef49317ca59fec9f8e42b2839c3e19

3 months agoReworking of JS internals to support binding of nested C structs (like sqlite3_index_...
stephan [Mon, 10 Nov 2025 07:41:54 +0000 (07:41 +0000)] 
Reworking of JS internals to support binding of nested C structs (like sqlite3_index_constraint and friends) and allow some of the automated JS/C conversions to be plugged in at the struct-binding level, simplifying how struct members, in particular function pointers, can be used from JS.

FossilOrigin-Name: bb4fd5b789cebf2b224c29023fea3e620a86fb36730c36c0d85d9f35880bf643

3 months agoFix the ".www" command of the CLI so that it works on unix systems with
drh [Mon, 10 Nov 2025 01:46:06 +0000 (01:46 +0000)] 
Fix the ".www" command of the CLI so that it works on unix systems with
newer web browsers that do not allow access to files in /tmp.

FossilOrigin-Name: 2f918c14bac28c567cc854b3d41dcdd59191a118bb5fdea9373945fe860161f5

3 months agoFixes to autoExplain
drh [Mon, 10 Nov 2025 00:18:36 +0000 (00:18 +0000)] 
Fixes to autoExplain

FossilOrigin-Name: 38e4171697057437fc9f70f8734c7f557b91da47804ff10b3d2481802377222f

3 months agoEnforce mxRowHeight in columnar layouts. Code clean-up. Minimum column with
drh [Sun, 9 Nov 2025 17:25:23 +0000 (17:25 +0000)] 
Enforce mxRowHeight in columnar layouts.  Code clean-up.  Minimum column with
is 2 if there is wrapping, in case there are double-wide characters.

FossilOrigin-Name: 0ee8fc00af4c82da0d597c65dd3d8590c71ea78d8f4a29653bbb21668c6c530d

3 months agoMinor doc typo fix reported in [forum:939d5864df|forum post 939d5864df].
stephan [Sun, 9 Nov 2025 07:11:15 +0000 (07:11 +0000)] 
Minor doc typo fix reported in [forum:939d5864df|forum post 939d5864df].

FossilOrigin-Name: a1f9c977b83fab11c54710070dbedfaea47195050946db74075bdd3ade97a4c8

3 months agoCLI shell: ensure that .dump propagates its error code on error. Problem reported...
stephan [Sun, 9 Nov 2025 06:51:32 +0000 (06:51 +0000)] 
CLI shell: ensure that .dump propagates its error code on error. Problem reported in [forum:a4f3873b0a8503cc|forum post a4f3873b0a].

FossilOrigin-Name: 850b92b6347187d702736bf5a574b9b4a49854a33799875f24fc75c50a6bf908

3 months agoIn sqlite3.wasm.allocFromTypedArray(), swap the order of the allocation and the acces...
stephan [Sun, 9 Nov 2025 06:32:10 +0000 (06:32 +0000)] 
In sqlite3.wasm.allocFromTypedArray(), swap the order of the allocation and the access to the heap view object to work around an obscure issue when allocating huge blobs. The heap view object could previously become stale via the following allocation if the underlying WebAssembly.Memory object needed to grow. Essentially a realloc()-moves-the-pointer situation but it only comes up with huge allocations under the right circumstances and would trigger a JS exception (as opposed to corrupting the WASM heap). Problem reported in [forum:05b77273be104532|forum post 05b77273be104532].

FossilOrigin-Name: 0f712b6b0516dc151d3bcbb63497661c82e11eae368e639bbdf197e1b3467195

3 months agoFixes for harmless static analyzer warnings.
drh [Sun, 9 Nov 2025 00:37:29 +0000 (00:37 +0000)] 
Fixes for harmless static analyzer warnings.

FossilOrigin-Name: 37bd136ae842c8f8110c10b0834c804a8af133ce0caff492f37bd567a56ac6c6

3 months agoRemove several more hundred lines of dead code from shell.c.in.
drh [Sun, 9 Nov 2025 00:01:48 +0000 (00:01 +0000)] 
Remove several more hundred lines of dead code from shell.c.in.

FossilOrigin-Name: 9de3e1d3fb0b2127e983aa455cda2f38646891da65eb9ac39bb5b00d8488f52f

3 months agoRemove about a thousand lines of dead code from shell.c.in.
drh [Sat, 8 Nov 2025 23:35:57 +0000 (23:35 +0000)] 
Remove about a thousand lines of dead code from shell.c.in.

FossilOrigin-Name: efbcc7decd5347e3460cc3ed62720c8c3932225dfdf92293a990c51895450906

3 months agoName changes. QRF_TEXT_Off becomes QRF_TEXT_Plain. mxTotalWidth becomes
drh [Sat, 8 Nov 2025 22:46:29 +0000 (22:46 +0000)] 
Name changes.  QRF_TEXT_Off becomes QRF_TEXT_Plain.  mxTotalWidth becomes
nScreenWidth.

FossilOrigin-Name: 871567e377e976e0bb191d466019d1d4abe126f2da1880f1e25cd92b06a666d1

3 months agoImprovements to QRF_STYLE_Line. Make it responsive to mxTotalWidth and
drh [Sat, 8 Nov 2025 18:31:57 +0000 (18:31 +0000)] 
Improvements to QRF_STYLE_Line.  Make it responsive to mxTotalWidth and
mxRowHeight.  Indent subsequent lines appropriately.  Add corresponding
test cases.

FossilOrigin-Name: 23ddc38cf19845a385c8b33002805c3c864ab9b2e36c3d609794444b06d20c89

3 months agoFix minor issues with alignment and quoting. All legacy tests are now
drh [Sat, 8 Nov 2025 17:08:19 +0000 (17:08 +0000)] 
Fix minor issues with alignment and quoting.  All legacy tests are now
passing.

FossilOrigin-Name: 712b890531d351cf19d57d8cc6dced5cdd2c394d69fd1ace98298d79ddca269a

3 months agoMiscellaneous fixes to the new alignment configurations.
drh [Sat, 8 Nov 2025 15:25:07 +0000 (15:25 +0000)] 
Miscellaneous fixes to the new alignment configurations.

FossilOrigin-Name: 787fb4c2ac80db6552bc7a740c3c3c63c0c8414cb4e7db80d367b4b5512519d0

3 months agoSeparate column width specification from cell alignment.
drh [Sat, 8 Nov 2025 14:04:29 +0000 (14:04 +0000)] 
Separate column width specification from cell alignment.

FossilOrigin-Name: 5dadfd7f41764ddfed39bb49bbde3a54d8f282bb494c9c2abbba37d0995a7f8e

3 months agoMinor changes to fix a few legacy test cases. Snapshot prior to yet another
drh [Sat, 8 Nov 2025 10:48:55 +0000 (10:48 +0000)] 
Minor changes to fix a few legacy test cases.  Snapshot prior to yet another
refactor.

FossilOrigin-Name: b429e7882fd630a490350efa38bfce8686d6727f324a60191337a59d5436828b

3 months agoMake sure columnar outputs always invoke qrfWrite().
drh [Sat, 8 Nov 2025 03:44:05 +0000 (03:44 +0000)] 
Make sure columnar outputs always invoke qrfWrite().

FossilOrigin-Name: 21084041196dd6908bb810d8fce80b7f6d5b12ebe474bf62b85128540ad020eb

3 months agoRewrite the table layout in QRF. Easier to maintain now. Still a few
drh [Sat, 8 Nov 2025 03:20:47 +0000 (03:20 +0000)] 
Rewrite the table layout in QRF.  Easier to maintain now.  Still a few
shell test failures, but much better after this rewrite.

FossilOrigin-Name: 25838d282c5f7a922988245f373edfe8adbe28e929abce83afcda2b08472e685

3 months agoFix some problems. But there is a need to do major surgery on the
drh [Fri, 7 Nov 2025 19:20:49 +0000 (19:20 +0000)] 
Fix some problems.  But there is a need to do major surgery on the
table layout algorithm, so it seems good to snapshot before proceeding.

FossilOrigin-Name: 9052991a897ad12ac54476d9a370d1ad18937abc3c3fc11efcb678f21cb5ef69

3 months agoIncremental check-in. QRF is working, but there are many test failures
drh [Fri, 7 Nov 2025 17:48:14 +0000 (17:48 +0000)] 
Incremental check-in.  QRF is working, but there are many test failures
in the shell test modules.

FossilOrigin-Name: de7fc9afc43d4bd5f5995832cd698633e0e7213c190fa044856c9f82512161f9

3 months agoBegin the process of integrating QRF into the CLI. Adjust makefiles.
drh [Fri, 7 Nov 2025 14:31:17 +0000 (14:31 +0000)] 
Begin the process of integrating QRF into the CLI.  Adjust makefiles.
Include the QRF code in shell.c.  But QRF is not yet used by the CLI.

FossilOrigin-Name: 7596fc32b371e5e657e830c2e80e61b0947320a7359833e915a888a438c2e935

3 months agoUpdate documentation to clarify that mxTotalWidth and mxLength are not
drh [Fri, 7 Nov 2025 13:23:29 +0000 (13:23 +0000)] 
Update documentation to clarify that mxTotalWidth and mxLength are not
yet implemented.

FossilOrigin-Name: c25806fc5491554f1cd55174c6cf98b509d619e3011b8e26abdf05b24133a6e8

3 months agoRename "mxWidth" to "mxColWidth". Add "mxTotalWidth" and "mxLength"
drh [Fri, 7 Nov 2025 13:11:16 +0000 (13:11 +0000)] 
Rename "mxWidth" to "mxColWidth".  Add "mxTotalWidth" and "mxLength"
settings and hook them up to the TCL interface, but those settings are
not yet implemented.

FossilOrigin-Name: 3f327e8fbc295b43c79118f8f49f8d2e20c2f3ac96e3b7f996720dab858d8199

3 months agoFix an error-message test case broken by the previous check-in.
drh [Fri, 7 Nov 2025 12:15:25 +0000 (12:15 +0000)] 
Fix an error-message test case broken by the previous check-in.

FossilOrigin-Name: fb040354901569915389c8c4c1530dfda8b724be7885adfde654e229d3e98eec

3 months agoAdd the JsonLine output style.
drh [Fri, 7 Nov 2025 12:12:02 +0000 (12:12 +0000)] 
Add the JsonLine output style.

FossilOrigin-Name: 7dfba841cfc515ac28401c4eb90ec24e04fd52cddaeae41be3cfa6967dac0eac

3 months agoAdd some UNUSED_PARAMATER()s for the sake of -pedantic -DSQLITE_OMIT_WAL.
stephan [Fri, 7 Nov 2025 11:46:56 +0000 (11:46 +0000)] 
Add some UNUSED_PARAMATER()s for the sake of -pedantic -DSQLITE_OMIT_WAL.

FossilOrigin-Name: 620434a4a276ecaf2ee56d325815ac4e33c95e1190b420a341e376e54ef60278

3 months agoFix a harmless static-analyzer warning.
drh [Fri, 7 Nov 2025 11:22:47 +0000 (11:22 +0000)] 
Fix a harmless static-analyzer warning.

FossilOrigin-Name: 9819fc5aa7706fda9d4ec67835ae87eed64d321672873c9d864788b8cf5d27d8

3 months agoFix the size of an integer in the TCL interface.
drh [Fri, 7 Nov 2025 00:05:44 +0000 (00:05 +0000)] 
Fix the size of an integer in the TCL interface.

FossilOrigin-Name: 04156c34e4efeebe9b8c2ee2944f9576b685c6aa7e6180c8a5caff4958cde2e8

3 months agoPut the style constants in alphabetic order. Improvements to
drh [Thu, 6 Nov 2025 23:34:30 +0000 (23:34 +0000)] 
Put the style constants in alphabetic order.  Improvements to
documentation.

FossilOrigin-Name: d5e891426f8b2a0c3326bf868f2d811c44a1f7e619f42b273c7445ab443d618c

3 months agoRevamp so that Explain and Eqp styles force the statement into the
drh [Thu, 6 Nov 2025 19:22:34 +0000 (19:22 +0000)] 
Revamp so that Explain and Eqp styles force the statement into the
the appropriate explain-mode for the rendering and restore it afterwards.
Add the new scanstatus styles: Stats, StatsEst, and StatsVm.

FossilOrigin-Name: 128f1149076ef00c567405ea2112be0ae665b12e81672ae5494d82af11633af5

3 months agoChanges to try to improve EXPLAIN capabilities. This is a snapshot
drh [Thu, 6 Nov 2025 17:28:34 +0000 (17:28 +0000)] 
Changes to try to improve EXPLAIN capabilities.  This is a snapshot
prior to an attempt to make sweeping changes in that area of the
interface.

FossilOrigin-Name: e7367d8089d43a06933f919c33c6edb15ee9bedf52d9a2d9ea989654077d998f

3 months agoMerge the latest trunk enhancements into the qrf branch.
drh [Thu, 6 Nov 2025 13:25:40 +0000 (13:25 +0000)] 
Merge the latest trunk enhancements into the qrf branch.

FossilOrigin-Name: 4e2ada6ad8a56d00aeb73570dc4ee22c484b65b8100a42a7085414d0a4c68afd

3 months agoGet the sqlite3Hwtime() function working on ARM. Enable scanstatus by
drh [Thu, 6 Nov 2025 13:19:50 +0000 (13:19 +0000)] 
Get the sqlite3Hwtime() function working on ARM.  Enable scanstatus by
default on Windows CLI builds.

FossilOrigin-Name: 305bb022368bac9fafd7c2794762299324796903aaea270923d07f2127d8926c

3 months agoImprovements to documentation for stmt_scanstatus interfaces.
drh [Thu, 6 Nov 2025 12:25:26 +0000 (12:25 +0000)] 
Improvements to documentation for stmt_scanstatus interfaces.

FossilOrigin-Name: 5f3e883d180d6fb7a1909df284713170f5431ea7afcc1a3eb5912c4620df42b2

3 months agoMore test cases and a bug fix.
drh [Wed, 5 Nov 2025 22:48:33 +0000 (22:48 +0000)] 
More test cases and a bug fix.

FossilOrigin-Name: 9a9c4580772fa35a68b3e27a40fc9bc615144979dfd27b1054538e29a489c024

3 months agoFurther testing and bug fixing.
drh [Wed, 5 Nov 2025 22:33:47 +0000 (22:33 +0000)] 
Further testing and bug fixing.

FossilOrigin-Name: d6b1bac15a692a69f3707fca721b57b3b283edb3850efa34ba42b02c3669fc71

3 months agoThe qrf-tester.c program was removed in the previous check-in, but the
drh [Wed, 5 Nov 2025 18:35:54 +0000 (18:35 +0000)] 
The qrf-tester.c program was removed in the previous check-in, but the
makefile rules to build it were not.  This check-in fixes that oversight.

FossilOrigin-Name: d1542696409b67635d0f172042642709452118d62102ebfab2ad3ff2b5732687

3 months agoThe TCL interface for QRF is now feature complete (at least until I think
drh [Wed, 5 Nov 2025 18:27:18 +0000 (18:27 +0000)] 
The TCL interface for QRF is now feature complete (at least until I think
of new features to add).  There is still a lot of testing, bug-fixing,
and documentation to be done, however.

FossilOrigin-Name: 633fe4fe584ae14ed6ced1ae137bf96a434a012423d70f0f93876737b0ca075c

3 months agoA few simple test cases added.
drh [Wed, 5 Nov 2025 16:29:06 +0000 (16:29 +0000)] 
A few simple test cases added.

FossilOrigin-Name: 7200372ed2424d1ac4c88644e0b17a224539f170b9111ced9c88774edbd75261

3 months agoNew style setting QRF_STYLE_Auto which chooses box, explain, or EQP depending
drh [Wed, 5 Nov 2025 15:44:11 +0000 (15:44 +0000)] 
New style setting QRF_STYLE_Auto which chooses box, explain, or EQP depending
on the statement to be rendered.  Improvements to memory management.
Updates to the documentation.

FossilOrigin-Name: 468ba188f034b23398e1f07b915cf7c8b337dcf7f56a13511947c5322ae98722

3 months agoThe new "format" method in the TCL interface is now partially functional.
drh [Wed, 5 Nov 2025 14:07:16 +0000 (14:07 +0000)] 
The new "format" method in the TCL interface is now partially functional.

FossilOrigin-Name: ace1ebda08740bb248c009cc4a6c99da318a2bba3e43ef20bd0c365c5021705f

3 months agoNew build product "tclsqlite-ex.c" is the tclsqlite.c file with QRF added.
drh [Wed, 5 Nov 2025 12:37:42 +0000 (12:37 +0000)] 
New build product "tclsqlite-ex.c" is the tclsqlite.c file with QRF added.
This is now used whereever tclsqlite.c was used.  Hence QRF is now in the
testfixture and in the tclextension.  The sqlite3 method is "format".  That
method is currently just a non-functional stub.

FossilOrigin-Name: e08d21fe1365176f268f1dcca4048fb5ff043356e5817c8622b4ed9a1a5a58cf

3 months agoJNI: doc tweaks. Add missing SQLITE_DBSTATUS_TEMPBUF_SPILL export.
stephan [Wed, 5 Nov 2025 10:07:57 +0000 (10:07 +0000)] 
JNI: doc tweaks. Add missing SQLITE_DBSTATUS_TEMPBUF_SPILL export.

FossilOrigin-Name: 2c8938f43f721a2592b0efe36f75ab87aa370654e1a22d646c0a17d58d643295

3 months agoTEA extension: add --tcl-stubs config flag, defaulting to zero, because there does...
stephan [Wed, 5 Nov 2025 05:59:53 +0000 (05:59 +0000)] 
TEA extension: add --tcl-stubs config flag, defaulting to zero, because there does not seem to be a universally-valid default for that. Addresses [forum:cd6503fce2|forum post cd6503fce2].

FossilOrigin-Name: 4954b94763052ed60ad2ae610e4f5c18fdba4475a39eb369408e984c89805e97

3 months agoRemove stale code from the fileio.c extension.
drh [Tue, 4 Nov 2025 23:47:49 +0000 (23:47 +0000)] 
Remove stale code from the fileio.c extension.

FossilOrigin-Name: d26f115760f16cac1cd28c950d1c0eec199461d2c9a52baafb91ff6b8d5ec151

3 months agoMerge the latest trunk enhancements into the qrf branch
drh [Tue, 4 Nov 2025 22:19:21 +0000 (22:19 +0000)] 
Merge the latest trunk enhancements into the qrf branch

FossilOrigin-Name: bed60e9be6d7f33c9f20dbb98bebdfaa7226a949a8e06691aea4d1e7c1af9507

3 months agoMinor wasm build simplifications and extend the JS bindings of sqlite3_column/value_t...
stephan [Tue, 4 Nov 2025 22:01:55 +0000 (22:01 +0000)] 
Minor wasm build simplifications and extend the JS bindings of sqlite3_column/value_text() such that they include embeded NUL bytes in their result strings rather than truncate them at NUL. Consolidate the shell.c build flags from the canonical and autoconf makefiles into the configure script.

FossilOrigin-Name: cee2e2576f5e91911a019bff025ee6071850c0d75941e8746f10d57b56bd830a

3 months agoVersion 3.51.0 major-release version-3.51.0
drh [Tue, 4 Nov 2025 19:38:17 +0000 (19:38 +0000)] 
Version 3.51.0

FossilOrigin-Name: fb2c931ae597f8d00a37574ff67aeed3eced4e5547f9120744ae4bfa8e74527b

3 months agoConsolidate the three VFS-specific SEE tests into a shared routine. wasm-post-3.51
stephan [Tue, 4 Nov 2025 01:03:58 +0000 (01:03 +0000)] 
Consolidate the three VFS-specific SEE tests into a shared routine.

FossilOrigin-Name: 8ac0bf125ddb6cc86a6825dcfe8895559835eca85ef14b5ad489f7c8159462e4

3 months agoMove the hard-coded SHELL_OPT makefile values from the two main makefiles into their...
stephan [Tue, 4 Nov 2025 00:15:51 +0000 (00:15 +0000)] 
Move the hard-coded SHELL_OPT makefile values from the two main makefiles into their shared configure script.

FossilOrigin-Name: 900885c4fb3071e461bf868e9e68d0d8f3d3e83a1bcbf5c9c68179c701c1fb92

3 months agoMerge trunk into wasm-post-3.51 to for some minor config script work.
stephan [Tue, 4 Nov 2025 00:10:10 +0000 (00:10 +0000)] 
Merge trunk into wasm-post-3.51 to for some minor config script work.

FossilOrigin-Name: bf55a4220a74022e8be5f8a0cd7f4ca395a36e1666e14113e7e60c4a94cf0b3a

3 months agoAdd tests demonstrating [d0e803b90344].
stephan [Mon, 3 Nov 2025 21:38:34 +0000 (21:38 +0000)] 
Add tests demonstrating [d0e803b90344].

FossilOrigin-Name: 7d22ee947ddecb0dc6c640e79c9a09c0931f8b04f97d3ac89afdbf1736312bf7