c707b2eb6d
Squash sign-comparison warnings reported in [forum:5e605a763a65c3f8 | forum post 5e605a763a65c3f8].
...
FossilOrigin-Name: e74fce93c518296bdb0a4273cd5fd3f785d37d27750ca456b61a3502135775f9
2024-09-27 16:20:03 +00:00
0992764c7a
Merge trunk changes into this branch.
...
FossilOrigin-Name: 4a26a4e0015bc42b1d007def3750caf7baefe429270a295cc2f4499c98c07247
2024-09-27 11:35:22 +00:00
bcd6d5d393
Allow UPDATEs of unindexed columns in fts5 contentless_unindexed=1 tables. Testing to come.
...
FossilOrigin-Name: cd36d66c88d7282eb0a3ccde5713253f72f5843e451b2693b71adfdae28b41fb
2024-09-27 10:57:41 +00:00
c94e4a7b2f
Fix a harmless compiler warning in the CLI.
...
FossilOrigin-Name: 27ef1909bb0c4d9470c6074b40500632c68341127a079a3eb3b6a19dbfb2aeac
2024-09-26 22:25:13 +00:00
74194f14ec
Add the ext/misc/sqlite3_stdio.c portability interface and incorporate it
...
into the CLI, sqldiff, and sqlite3_analyzer. Enhance the CLI with the new
".www" dot-command and related options on .once and .output.
FossilOrigin-Name: f97f9944b829a49da12786f934da0a5ad51591afd6d8a19a4a0835f51bbdbff2
2024-09-26 19:38:34 +00:00
2b041fb97a
Provide SQLITE_U8TEXT_ONLY and SQLITE_U8TEXT_STDIO compile-time options
...
to the sqlite3_stdio.c module.
FossilOrigin-Name: f31588520e3f45b50dcaa9eecab17f52ebb56bb53d0f9bdb88cc596d1a156353
2024-09-26 19:16:20 +00:00
2c77d51dfe
Resolve a harmless compiler warning in QNX builds.
...
FossilOrigin-Name: 2916460179c6089375188c6e4e3cff1fca5bbbbb7280a10c919e09e75d1f11f8
2024-09-26 18:13:10 +00:00
d0720eee5e
When possible, avoid taking wal file read-lock 0 in sqlite3_snapshot_get().
...
FossilOrigin-Name: 34b6ac3d76dbc6819778ec2a0f81cbcdcc0cd1a6303381d97f1c479e4ecdd132
2024-09-26 18:02:17 +00:00
2fb055366d
Clarification of the meaning of the nByte parameter to sqlite3_prepare().
...
Comment and documentation change only - no changes to the code.
FossilOrigin-Name: 92d71eee4f3a5edb3877c108d14972d80654982b0de3e635d9d008e9d3b6591f
2024-09-26 13:12:19 +00:00
b7ceffdadf
Fix shell test cases to account for recent additions to the ".help" output.
...
FossilOrigin-Name: 54c22bc6165affbea0d1166a0912d19939300ccc4ae33a6b2ed8c510ab61c574
2024-09-26 01:29:22 +00:00
66b3ed318b
Always show HTML table headers in ".www" output mode.
...
FossilOrigin-Name: 660ca5ce6600d897cc2b00b9d39e5d993c1c0e71ec0d5dc706246c053a163281
2024-09-25 16:11:27 +00:00
878db7b099
Add the --plain option to the ".www" dot-command.
...
FossilOrigin-Name: a9209519f612e66cfe11c89e70efd8285a0185ac0d3e5795846aafbd05d7a21f
2024-09-25 15:55:52 +00:00
7119a6c16b
Have the zipfile and fileio extensions use sqlite3_stdio.c when it is
...
available - such as when those extensions are preloaded into the CLI.
FossilOrigin-Name: 74bbb2b2b4507d9acbd91209a2ce341968e9ff64f3aebe9e817bfe488d39ae03
2024-09-25 15:26:37 +00:00
95f35b64da
Redirect timer output just like any other text.
...
FossilOrigin-Name: 3b5ae21074958788b23ccf449e52fbbad1f81779e07a6ca62ad8395f88a37286
2024-09-25 14:09:47 +00:00
62d96919f6
Improvements to ".www" and ".output -w" so that text that is not part of
...
query output is shown using <pre>.
FossilOrigin-Name: f8ef65c52305b2180ec56760f5762ac5638584cd504c79d57e86f61736901aa4
2024-09-25 13:56:05 +00:00
2a9254cf2c
Add the "www" output mode that include <table> in the HTML output.
...
Add the ".www" command and the "-w" option to ".once".
FossilOrigin-Name: b06fd9e6bcce09f12c994dc34f329a8d267ea0601bb07c9b00903c5017d55d42
2024-09-25 13:29:03 +00:00
9e59c06fb1
Always include a UTF-8 BOM at the beginning of the output CSV when using
...
the ".excel" command on Windows, as the actual Excel program requires the
BOM in order to work correctly.
FossilOrigin-Name: 04727fc00207325a76a5d5f20549c00232810ac727dedb70bc9e8112e60b3f56
2024-09-25 12:56:44 +00:00
777c35dbe8
Prevent regular DELETE and UPDATE statements from running against contentless_unindexed=1 tables that are not also contentless_delete=1.
...
FossilOrigin-Name: 21539e9d0d57fdc762affbce9220d1bb1ca009d9dc751b4ccfe63eecbbe2f575
2024-09-25 12:03:08 +00:00
853520ddbf
Fix stray fputs() calls in the CLI.
...
FossilOrigin-Name: 1ee3fa0f0e87a61b5700abd56547c4acefe999317b0d53d66d890d9e09d8b7d9
2024-09-25 11:38:00 +00:00
38b4158aba
Use sqlite3_fgets() instead of fgetc() to end the startup debugging pause
...
in the CLI.
FossilOrigin-Name: 869b3c05e852a797b5801a81d30a1f7955c31afad0274327f7af2284b555f23a
2024-09-25 11:27:59 +00:00
8f1f9ef09f
Merge trunk enhancements, and especially the zero- and double-width character
...
processing for columnar outputs into the cli-stdlib branch.
FossilOrigin-Name: d6262a4bcd7b0334b23ae4d194ca2bce7c6554ee6c678666b24c830e4c14a467
2024-09-25 09:43:05 +00:00
8cd30e3f5b
In the CLI, for columnar output formats, try to account for the presence of
...
zero-width and double-width characters in the output and adjust column widths
accordingly.
FossilOrigin-Name: 9592b9ba3ad7a842cdd4c4010da278485a6fdec7e811bda01ebe640162a8c3b6
2024-09-25 09:39:11 +00:00
f4382b2415
Improvements to comments on data structures and subroutines.
...
FossilOrigin-Name: b217e3004b58af0e777726bdd652b999ad41815261299ef4ce8f8d2f6b0afe8d
2024-09-25 09:33:14 +00:00
613c2ee21f
Minor wasmfs speedtest1 build tweaks. Disable one wasmfs demo which was broken by Emscripten-side changes.
...
FossilOrigin-Name: 5ccc85d8f5809d961602dff557dca1ed34f5db61203912387272034e4da02614
2024-09-24 21:54:37 +00:00
18e2ace468
Fix over-length lines in the shell source code.
...
FossilOrigin-Name: f3fdf76a0d3abeb5202f2b6f26318815396da7df680073955bde60b13f84e797
2024-09-24 19:47:12 +00:00
697c3fb25b
Fix error messages in the shell.
...
FossilOrigin-Name: aeef82e974c24071e3211588001a92c7f122fbaf02d9dcf7fa5aaf30d2729f64
2024-09-24 19:19:53 +00:00
63558eae54
Get fiddle working again on this branch.
...
FossilOrigin-Name: 0f228317c6ea1388d82df46f44c166b2aa9be63361ff9b81569ebee63c930f2e
2024-09-24 18:01:50 +00:00
6ba175f0c8
Port sqlite3_analyzer.exe to use sqlite3_stdio.
...
FossilOrigin-Name: 7c1c1226d803dbaf8e75085b1cc2aad88aef4c3168288e587c8c736633d09054
2024-09-24 17:49:06 +00:00
a55901a27c
Port sqldiff over to use sqlite3_stdio.
...
FossilOrigin-Name: 18f784c47d4252bc3696a7e084a1afb9f51f006cf2021292f2103531b8235226
2024-09-24 17:40:54 +00:00
0be2dd9a1b
Get output redirection working again in the CLI.
...
FossilOrigin-Name: 086034c3508d95e4f620c5e0580fae770e85410b0c8bd94f600fc0fd25088947
2024-09-24 16:09:50 +00:00
29057f3d18
Fix a memory leak in sqlite3expert.c introduced by [f1d76c86].
...
FossilOrigin-Name: 42bb941584a1ac922ee6b0b6ecadce71c9259555563cf49913a6f820f3f9b887
2024-09-24 15:11:34 +00:00
57b32ef924
Add the sqlite3_stdio.h library for Windows console I/O.
...
FossilOrigin-Name: fcd0ecffc9889f8c855ea340f075ec42cdca482df82d6e67dc9c32613e8d5846
2024-09-24 13:46:32 +00:00
d2917d9f69
Minor tweaks in mkwasmbuilds.c.
...
FossilOrigin-Name: cee43280727435440b9e01b302a790a1a102aea930bc821ebc737ea519458cef
2024-09-24 13:00:21 +00:00
88c43ce1f6
Wasm build cleanups. Fix the wasm speedtest1 builds broken by yesterday's refactoring.
...
FossilOrigin-Name: 5d4a090230d1d7609e70b9c28d662dc8b0f8dd4d70a254f3ce6e449c68a25897
2024-09-24 12:16:05 +00:00
3c90b86372
Avoid an error in sqlite3expert if the database has existing indexes on expressions.
...
FossilOrigin-Name: f1d76c8636866424fe0b57d8814b8bb1a0ed4e2ca1b75d8e308d4b962ad8dc3b
2024-09-24 11:26:21 +00:00
4e34558f1b
Use _wfopen() instead of fopen() on Windows in the CLI.
...
FossilOrigin-Name: 21a8cac5e9a0d5ead29ca1114be7520d182348f7e2e2e2416852b827d7e09f21
2024-09-24 10:30:07 +00:00
118ac6a7ad
Always use fputws() for output to a Windows command-line prompt.
...
FossilOrigin-Name: 33950a8c3f3e48e5107fe56647da05147aa84f9c3eccbe7c8671f5b502ebb70b
2024-09-24 09:51:53 +00:00
7d24e6b080
Remove an ALWAYS() that can sometimes be false, with wildly incorrect SQL
...
inputs. dbsqlfuzz 707afcf73930de2624cdeca0ad1f0deea982dfea
FossilOrigin-Name: 766cf5535b9f51decd88c1736b988def929a90f68eb6a52bcaa21bb321586a08
2024-09-24 00:53:27 +00:00
405ae974ee
Further wasm build cleanups and tweaks. No functional changes.
...
FossilOrigin-Name: 3b72a143431537ec275aefae739e56330c1d445c9ea80885882a2b9aa2201179
2024-09-24 00:31:08 +00:00
415acd09d7
In the CLI, when displaying results in a columnar format, take into account
...
zero-width and double-width Unicode characters.
FossilOrigin-Name: 47cfad71eddc6fc4414ff853ee172da72527620eee743721806072c6e0a80caa
2024-09-24 00:01:47 +00:00
6ed21e8fd7
Typo fix in makefile comments.
...
FossilOrigin-Name: a4a1287fe8205d7c24556ec2e7ae09cda37a36dbe405ea70cd756cf488549036
2024-09-23 22:56:54 +00:00
69cce89425
wasm: replace much of the eval makefile spaghetti with equivalent code generated from a small C app. It turns out that's easier to read and write than doing the same thing from shell or tcl code, due entirely to C's lack of need for escaping dollar signs.
...
FossilOrigin-Name: 5440de48903e94f91090e2df65702ec0c504e33dd5cbd50f684cf30988f20b02
2024-09-23 21:22:09 +00:00
1d9db01065
CLI uses only lib-c for I/O on Windows. No calls to Win32. Works on Win11,
...
at least. Reads and writes unicode to/from the console and UTF-8 to/from files.
Prototype code only - must testing and additional work required.
FossilOrigin-Name: 5c54530d5a0a4125a1ba44f22537c4f63d5e5708f347c43cbac3e1832c4335da
2024-09-23 20:23:43 +00:00
253695caf3
Fix a couple of problems with the sessions streaming interfaces.
...
FossilOrigin-Name: 9a1fc8d36b5b262f9d17a4743b4b9bb54510cf257d2d9778ebc42d5224856b1e
2024-09-23 19:32:06 +00:00
d69b4249ff
Merge current trunk into this branch.
...
FossilOrigin-Name: ed47d7f9a44b2af8ab7dd956495e71ea9a159cec438d1909f7022254a779e068
2024-09-23 17:06:06 +00:00
5e419c1048
Add the run-fuzzcheck target to the MSVC makefile.
...
FossilOrigin-Name: 2e5194407a1b34dd0659c350ea8098bfef7b3f11aa5b2a07ecd2bce5582655a2
2024-09-21 17:27:47 +00:00
38f2c5f81c
If the database filename pointer passed to sqlite3_open(), change it
...
into ":memory:".
FossilOrigin-Name: 62e11a3a78edf9853b74d6495ccd8ae9ac1966c7d78eb3682cf2d5885e3740ec
2024-09-21 15:57:06 +00:00
8a894cd804
Fix comment typo in the fileio.c extension. No changes to code.
...
FossilOrigin-Name: bf2c5b368ac094e048ca33a5e9175fe6a1fb5e2b1e392935eb29388e8999c40b
2024-09-20 17:41:05 +00:00
7f0e0c7dbf
New assert()s to help verify union access. No logic changes. Testing and
...
validation code only.
FossilOrigin-Name: b7b64c53f5d7f6b405ee3f1f1be1d84230aa79db5a502c8ad78d3e524f4384fb
2024-09-20 12:58:15 +00:00
db467f5777
Fix harmless compiler warning in the vfstrace extension.
...
FossilOrigin-Name: c8b4d092a22d87f1231424c8e3fa6a02f17fb965cb2a931621e1b51f4d215de7
2024-09-19 15:44:41 +00:00
stephan