]> git.ipfire.org Git - thirdparty/sqlite.git/log
thirdparty/sqlite.git
10 months agoMerge the latest trunk enhancements into the bedrock branch through the wal2
drh [Mon, 3 Mar 2025 16:01:11 +0000 (16:01 +0000)] 
Merge the latest trunk enhancements into the bedrock branch through the wal2
intermediary.

FossilOrigin-Name: 203376300781167f3e96da0197a9c8e8da6fed15c56c8980a4c283ef34478a07

10 months agoMerge the latest trunk enhancements into the wal2 branch.
drh [Mon, 3 Mar 2025 15:57:12 +0000 (15:57 +0000)] 
Merge the latest trunk enhancements into the wal2 branch.

FossilOrigin-Name: 6baea938f0230f8b81b33373f948857fc44c2b3788bf8d4ee6e863b045632b82

10 months agoInternal configure script cleanups. Resolve an as-yet-hypothetical corner case involv...
stephan [Mon, 3 Mar 2025 14:15:13 +0000 (14:15 +0000)] 
Internal configure script cleanups. Resolve an as-yet-hypothetical corner case involving the --dev flag mixed with custom CFLAGS containing SQLITE_ENABLE... or SQLITE_OMIT... flags. Fix an unrelated API doc typo reported in [forum:606ea661df|forum post 606ea661df].

FossilOrigin-Name: 0554c00f32b7cc81d35340080df10ea6d66c9ff07fe749ea76cc523a4149b5c8

10 months agoMinor configure script doc tweaks. This is also a note that the basic elements of...
stephan [Mon, 3 Mar 2025 11:48:09 +0000 (11:48 +0000)] 
Minor configure script doc tweaks. This is also a note that the basic elements of the build run as-is on Haiku OS Beta 5 but the tcl bits do not (for lack of tclConfig.sh).

FossilOrigin-Name: acf9babf0efc346b26c8ac02c0bd973498bf1604b47fe320de14027f9b21ed33

10 months agoEnsure that detection of control characters by comparison against 0x1f
drh [Sun, 2 Mar 2025 20:29:49 +0000 (20:29 +0000)] 
Ensure that detection of control characters by comparison against 0x1f
uses unsigned characters. [forum:/forumpost/4c344ca61f|Forum post 4c344ca61f].

FossilOrigin-Name: b7c5ce84216cc7f5a3ba07404572edb94fd628b3a7421111cd5f5333f3e56ea8

10 months agoUse SQLITE_EXTRA_INIT_MUTEXED instead of SQLITE_EXTRA_INIT for the SQLITE_WASM_EXTRA_...
stephan [Sat, 1 Mar 2025 23:44:11 +0000 (23:44 +0000)] 
Use SQLITE_EXTRA_INIT_MUTEXED instead of SQLITE_EXTRA_INIT for the SQLITE_WASM_EXTRA_INIT feature, as suggested in [forum:14183b98fc0b1dea|forum post 14183b98fc0b1dea]. This doesn't make a functional difference now - this is in the name of future-proofing against eventual threading support in wasm.

FossilOrigin-Name: 46479c2e30b9676e0fa8da117ba67f673671fb340c9bea38ece19a1b2371a57b

10 months agoAdd an assert() in vdbesort.c to help both humans and static analyzer AIs
drh [Sat, 1 Mar 2025 11:47:01 +0000 (11:47 +0000)] 
Add an assert() in vdbesort.c to help both humans and static analyzer AIs
understand why a particular array cannot overflow.

FossilOrigin-Name: a14d4afd5020af327629e5c72b0699ddab0ef4e3f23938a1b72669aa29fc2e87

10 months agoIn the CLI, ensure that all calls to ctype.h macros are cast to unsigned char.
drh [Fri, 28 Feb 2025 15:54:28 +0000 (15:54 +0000)] 
In the CLI, ensure that all calls to ctype.h macros are cast to unsigned char.
Apparently cygwin needs this.

FossilOrigin-Name: 44bd44532d4a63b2f600427dc425bde618bcc21e4abffaa2ec19f27350e54732

10 months agoLatest upstream autosetup. Fixes two minor corner-case issues which we haven't yet...
stephan [Fri, 28 Feb 2025 04:58:43 +0000 (04:58 +0000)] 
Latest upstream autosetup. Fixes two minor corner-case issues which we haven't yet seen in practice.

FossilOrigin-Name: 5c2438a719de6787c2f7c9f38d14d5ccdb8d36a120657661ec28051c83a93270

10 months agoApproximately 100 typo corrections spanning the whole tree, submitted via [forum...
stephan [Thu, 27 Feb 2025 21:17:55 +0000 (21:17 +0000)] 
Approximately 100 typo corrections spanning the whole tree, submitted via [forum:0db9827f0464bc33|forum post 0db9827f0464bc33] and individually audited and verified. Affects only code comments, innocuous test strings, error message text in tool (not library) code, and configure-level help text.

FossilOrigin-Name: f50c21484d3cac73589da0376c423de39ae8b842218105786c5aa3726e4dcaed

10 months agoReimplement testrunner_data.tcl::trd_get_bin_name() to assume a .exe extension on...
stephan [Thu, 27 Feb 2025 19:40:02 +0000 (19:40 +0000)] 
Reimplement testrunner_data.tcl::trd_get_bin_name() to assume a .exe extension on all platforms not matching "unix", to avoid having to do file-exists checks.

FossilOrigin-Name: ce5519102a1b4df5d513835974799cdcda3478ec53ae99bbb631951095291919

10 months agoStrive to make sorts stable in the mkpragmatab.tcl build script, so that
drh [Thu, 27 Feb 2025 16:07:49 +0000 (16:07 +0000)] 
Strive to make sorts stable in the mkpragmatab.tcl build script, so that
we get consistent amalgamations regardless of platform.
[forum:/forumpost/c9914addebf3da51|Forum thread c9914addebf3da51].

FossilOrigin-Name: 3f57584710d611748eb0af797c58c72e4ac099db09f5286cafdbd9a8ce354c90

10 months agoMerge back a sequence of three changes that were branched due to a build break.
drh [Thu, 27 Feb 2025 15:55:01 +0000 (15:55 +0000)] 
Merge back a sequence of three changes that were branched due to a build break.

FossilOrigin-Name: 67809715977a5bad0ec7830e27746aba2080852eb725d471c0fd62d4f464a884

10 months agoFix build break in [e2bd23f251359e7a]. build-break
drh [Thu, 27 Feb 2025 15:52:15 +0000 (15:52 +0000)] 
Fix build break in [e2bd23f251359e7a].

FossilOrigin-Name: 6ed84211033ee0ff00c8fd088979fe06d3a264e4f935162f36a62c00af135c63

11 months agoAdd support for SQLITE_EXTRA_INIT_MUTEXED - like SQLITE_EXTRA_INIT, but is called...
dan [Thu, 27 Feb 2025 11:03:54 +0000 (11:03 +0000)] 
Add support for SQLITE_EXTRA_INIT_MUTEXED - like SQLITE_EXTRA_INIT, but is called from within sqlite3_initialize() when the SQLITE_MUTEX_STATIC_MAIN mutex is still held.

FossilOrigin-Name: 3cf88d429f6e7c10b8f19c283151541924c4bb84bbd0d2e05cabdd4f9f0e88c9

11 months agoInternal doc typo fixes reported in [forum:01d15f21b6|forum post 01d15f21b6].
stephan [Thu, 27 Feb 2025 03:23:33 +0000 (03:23 +0000)] 
Internal doc typo fixes reported in [forum:01d15f21b6|forum post 01d15f21b6].

FossilOrigin-Name: d6514c20ff583ccc4fb3a526fb8f86a563224f513ee10bb39a978046bd952726

11 months agoTeach testrunner how to run local binaries which have a .exe extension. Also teach...
stephan [Wed, 26 Feb 2025 19:22:52 +0000 (19:22 +0000)] 
Teach testrunner how to run local binaries which have a .exe extension. Also teach it to recognized mingw environments (but actually building the test programs there currently doesn't work).

FossilOrigin-Name: e2bd23f251359e7a818c4cfacf114aa9fd8c0a9a1cb802654e96fad67b505508

11 months agoTest testrunner.tcl to identify an msys environment.
stephan [Wed, 26 Feb 2025 18:31:42 +0000 (18:31 +0000)] 
Test testrunner.tcl to identify an msys environment.

FossilOrigin-Name: e9f777ceda9fca51c37caca0afeadfc3f99b86e945496f52c71adcc520dcee98

11 months agoUndo part of [69e83ab859c], as that order of operations breaks the --prefix=... confi...
stephan [Wed, 26 Feb 2025 17:11:25 +0000 (17:11 +0000)] 
Undo part of [69e83ab859c], as that order of operations breaks the --prefix=... configure flag. Found a workaround for the library version and OS/environment info being emitted when --help.

FossilOrigin-Name: cd2a84a72c922c330441d6b75df0c8b2f6df2c25bc7c37ac37046fffd702624a

11 months agoconfigure: extend the readline detection a bit so that it can find readline on termux...
stephan [Wed, 26 Feb 2025 16:15:34 +0000 (16:15 +0000)] 
configure: extend the readline detection a bit so that it can find readline on termux environments without having to be told where it is. Fix a typo in a libedit-related message.

FossilOrigin-Name: 52f528c4be4ee4ae4ee4c05009c33bb97269d27380ce2cdd717a514616f39be7

11 months agoShift some bootstrapping configure bits to avoid emitting extra output if --help...
stephan [Wed, 26 Feb 2025 09:14:26 +0000 (09:14 +0000)] 
Shift some bootstrapping configure bits to avoid emitting extra output if --help is specified.

FossilOrigin-Name: 69e83ab859ca37c047defdaba84e80d028b30045631e773bd8dfa286c41a57e8

11 months agoFix a bug in mkwasmbuilds.c which caused sqlite3.wasm to get deleted directly after...
stephan [Wed, 26 Feb 2025 03:20:26 +0000 (03:20 +0000)] 
Fix a bug in mkwasmbuilds.c which caused sqlite3.wasm to get deleted directly after it was built.

FossilOrigin-Name: 1a72d1d13e42f69f02861f8ac3058e69b78d4fd2050ca8c53a1ce016b7e0863d

11 months agoDisable some misuse tests that sometimes cause segfaults during
drh [Tue, 25 Feb 2025 21:16:13 +0000 (21:16 +0000)] 
Disable some misuse tests that sometimes cause segfaults during
"make releasetest".

FossilOrigin-Name: 5856251a7e8a69aa181f89533bc2a78812d8b450a407b4b2f73f0c146cd78072

11 months agoApproximately 50 typo fixes, spanning the whole tree, contributed via [forum:006c8fa1...
stephan [Tue, 25 Feb 2025 20:55:14 +0000 (20:55 +0000)] 
Approximately 50 typo fixes, spanning the whole tree, contributed via [forum:006c8fa165083ac3|forum post 006c8fa165083ac3] and individually checked for correctness. Affects only code comments, docs, and a single line of debug output in a test app.

FossilOrigin-Name: af928818a030924060ee0762431dae0f16d53a62f4e1132754d052eb9c621ac2

11 months agoFix a test case that was broken when the default --escape type was changed
drh [Tue, 25 Feb 2025 20:36:46 +0000 (20:36 +0000)] 
Fix a test case that was broken when the default --escape type was changed
by the previous check-in.

FossilOrigin-Name: 5f2531e068b4856db2270518c370b65cbd0c0ab5443d76f1fb1116fe9ad80296

11 months agoChange the default control-character escape algorithm from "symbol" to
drh [Tue, 25 Feb 2025 20:10:46 +0000 (20:10 +0000)] 
Change the default control-character escape algorithm from "symbol" to
"ascii", since the "ascii" algorithm works even on terminals that do
not support unicode.

FossilOrigin-Name: d35320495eb282601ab4f3b9efc53c7c1d58e890f025317e34c7046a43c8cb53

11 months agoFix harmless "unused parameter" compiler warnings.
drh [Tue, 25 Feb 2025 20:02:58 +0000 (20:02 +0000)] 
Fix harmless "unused parameter" compiler warnings.

FossilOrigin-Name: 7a68a3ead8e6c75203641542256bcfa05067bed4bf9035452fbd134534801a08

11 months agoImproved help messages for the --escape option in the CLI.
drh [Tue, 25 Feb 2025 18:10:47 +0000 (18:10 +0000)] 
Improved help messages for the --escape option in the CLI.

FossilOrigin-Name: e6784af6d50f715338ae3218fc8ba1b894883c27d797f0b7fd2625cac17d9cd7

11 months agoConfigure script cosmetics: emit the host/build system info before the directory...
stephan [Tue, 25 Feb 2025 16:39:51 +0000 (16:39 +0000)] 
Configure script cosmetics: emit the host/build system info before the directory info.

FossilOrigin-Name: 6f0b6d95db17e69ac7e46a39f52770291ac4cfe43eea09add224946a6e11f04e

11 months agoRestructure [826bad10e9ccd6f71e] as that structure mysteriously breaks the --prefix...
stephan [Tue, 25 Feb 2025 16:11:25 +0000 (16:11 +0000)] 
Restructure [826bad10e9ccd6f71e] as that structure mysteriously breaks the --prefix=... configure flag.

FossilOrigin-Name: d284230f68616b78a527d34df777b0220376ba6a00e9e927d4ffb4cbddab900c

11 months agoEnhancements to help avoid problems in the CLI when trying display content
drh [Tue, 25 Feb 2025 15:57:49 +0000 (15:57 +0000)] 
Enhancements to help avoid problems in the CLI when trying display content
that contains ANSI escape codes:  (1) Add the --escape MODE option to the CLI
where MODE is one of "symbol", "ascii", "off" where the default is "symbol".
(2) Add the unistr() SQL function.  (3) Add the unistr_quote() SQL function.
(4) Add the %#Q and %#q conversions in the built-in printf.

FossilOrigin-Name: e3e509ae145ee2623ac68ededa59991a97fcd28313e03f67a3890b560c5381b0

11 months agoDiverse configure tweaks to better support package maintainers on the unix-on-windows...
stephan [Tue, 25 Feb 2025 15:54:07 +0000 (15:54 +0000)] 
Diverse configure tweaks to better support package maintainers on the unix-on-windows environments like msys2, cygwin, and mingw, based largely on feedback in forum posts [forum:e6cf2bbb70da2922|e6cf2bbb70da2922] and [forum:828fdfe9041fd725|828fdfe9041fd725].

FossilOrigin-Name: 85b56fb0cce4b628f80b26a67b43236ef1557282775739bdbe7cc4d65948d66f

11 months agoReinstate the assert() removed by [0f6223b8]. Avoid holding a wal-mode write lock...
dan [Tue, 25 Feb 2025 15:27:55 +0000 (15:27 +0000)] 
Reinstate the assert() removed by [0f6223b8]. Avoid holding a wal-mode write lock after the transaction has been rolled back if an IO error occurs while restarting the wal file.

FossilOrigin-Name: 277e150d6ab75de2407f6761aa2359df80a4e1dbce30788df06621dee05b2ef1

11 months agoFix a test script problem causing errors with Tcl 9.
dan [Tue, 25 Feb 2025 13:33:43 +0000 (13:33 +0000)] 
Fix a test script problem causing errors with Tcl 9.

FossilOrigin-Name: dbec2c47d09027f2458036f675c8af3f8f152c0530799582eeac231649eba501

11 months agoSmall performance improvement for the new %#Q conversion in printf. unistr
drh [Tue, 25 Feb 2025 12:18:27 +0000 (12:18 +0000)] 
Small performance improvement for the new %#Q conversion in printf.

FossilOrigin-Name: 17e440781e68d7d3ea68c5144e1e08e183f0caef595a6c7ac4ce56489c60f476

11 months agoUpdate the autoconf Makefile for nmake to support SETLK_TIMEOUT.
drh [Tue, 25 Feb 2025 12:11:57 +0000 (12:11 +0000)] 
Update the autoconf Makefile for nmake to support SETLK_TIMEOUT.

FossilOrigin-Name: 46909fe3348976448d6a0d9e9aacaeaccdf0978c9e9d10742a96842418ab3a08

11 months agoAvoid running certain tests in walsetlk2.test if SQLITE_ENABLE_SETLK_TIMEOUT is set...
dan [Tue, 25 Feb 2025 11:48:57 +0000 (11:48 +0000)] 
Avoid running certain tests in walsetlk2.test if SQLITE_ENABLE_SETLK_TIMEOUT is set to 2, not 1.

FossilOrigin-Name: 86788c08fa09019f224d5dbd76f06c1d113b04ca5eca5d773719194a8b02da22

11 months agoConsolidate two different UTF8 encoders into a single subroutine.
drh [Tue, 25 Feb 2025 11:47:34 +0000 (11:47 +0000)] 
Consolidate two different UTF8 encoders into a single subroutine.

FossilOrigin-Name: 6208e494858b9d362efc7db4e8aac6f8e93fe51d2e038c94dfa97c55a74688a0

11 months agoRemove an assert() added by [e88212b1] that is sometimes false.
dan [Tue, 25 Feb 2025 11:29:04 +0000 (11:29 +0000)] 
Remove an assert() added by [e88212b1] that is sometimes false.

FossilOrigin-Name: 0f6223b8f6c044db687f78e19f6373d0dda9155445c511a297efa05bac3b16e5

11 months agoFix the new shellA.test test script so that it works with Valgrind.
drh [Mon, 24 Feb 2025 23:34:50 +0000 (23:34 +0000)] 
Fix the new shellA.test test script so that it works with Valgrind.

FossilOrigin-Name: c3949852cee320c2e02123b99c33155c459b10b2ac8e4fe80b1b7624c9ce0817

11 months agoSupport SQLITE_ENABLE_SETLK_TIMEOUT on windows.
dan [Mon, 24 Feb 2025 21:27:16 +0000 (21:27 +0000)] 
Support SQLITE_ENABLE_SETLK_TIMEOUT on windows.

FossilOrigin-Name: e88212b10a7829ff42ef51a02863d788c929e54161faf492f9ef2ad90fd7074e

11 months agoSlightly simplify auto.def and autoconf/auto.def. configure-dll-support
stephan [Mon, 24 Feb 2025 20:53:50 +0000 (20:53 +0000)] 
Slightly simplify auto.def and autoconf/auto.def.

FossilOrigin-Name: d84f591b962ea44efb902043444e4e54bc55e5bb32e5108f04df824407c412dd

11 months agoUse an assert() to fix a harmless (false-positive) scan-build warning
drh [Mon, 24 Feb 2025 20:13:29 +0000 (20:13 +0000)] 
Use an assert() to fix a harmless (false-positive) scan-build warning
in the CLI.

FossilOrigin-Name: 4c56cd7392f114e27b43d8fcc79444c3078cd65285ba7dd3338a414e2a9f5392

11 months agoautoconf/auto.def: remove a define which made superfluous by [b8bf966628c0]. Add...
stephan [Mon, 24 Feb 2025 18:45:30 +0000 (18:45 +0000)] 
autoconf/auto.def: remove a define which made superfluous by [b8bf966628c0]. Add a check/status message for whether to statically link the library into the CLI shell.

FossilOrigin-Name: df95e908cacc7e8e749701ff49d2ce02a927c58a474dd9a362d5f84cb3d7413f

11 months agoconfigure: in autoconf build if both --disable-shared and --disable-static-shell...
stephan [Mon, 24 Feb 2025 18:14:27 +0000 (18:14 +0000)] 
configure: in autoconf build if both --disable-shared and --disable-static-shell are used together, ignore the former and emit a notice to that effect.

FossilOrigin-Name: b8bf966628c0cbbb6f0bc09a70800ac0b6b7f8c2d2f70c91f4b6e65daae0b192

11 months agoOnly use unistr() in columnar formats when strictly needed.
drh [Mon, 24 Feb 2025 17:50:49 +0000 (17:50 +0000)] 
Only use unistr() in columnar formats when strictly needed.
Do not use unistr() in insert mode when --escape is off.
More test cases.

FossilOrigin-Name: e029828de91b10b4c7f4a19bc70c35e4f36fae4ebf32b40553a6ba9f2b3af295

11 months agoAdd the unistr_quote() function that works like quote(), but also escape
drh [Mon, 24 Feb 2025 13:51:24 +0000 (13:51 +0000)] 
Add the unistr_quote() function that works like quote(), but also escape
control characters using unistr() if necessary.

FossilOrigin-Name: e99e37b54baf7283588ead4983e613a1e14c58a0b92be5f7b25b4d9d287b5324

11 months agoBug fix and initial test-case infrastructure for control-character escaping
drh [Mon, 24 Feb 2025 13:27:16 +0000 (13:27 +0000)] 
Bug fix and initial test-case infrastructure for control-character escaping
in the CLI.

FossilOrigin-Name: c809997792602a7299b8ab84d018a03d291695e308ce750fc8b9d7a824edfd6e

11 months agoOngoing work to get all the quoting and escaping variations in the CLI
drh [Mon, 24 Feb 2025 12:41:30 +0000 (12:41 +0000)] 
Ongoing work to get all the quoting and escaping variations in the CLI
working correctly.

FossilOrigin-Name: b77aea93e7eff0af408f598727caedcfc4428361b8440fbc1cc54c18f93abb69

11 months agoConfigure doc tweaks. Move the package version/build dir output so that it does not...
stephan [Mon, 24 Feb 2025 12:19:06 +0000 (12:19 +0000)] 
Configure doc tweaks. Move the package version/build dir output so that it does not appear at the start of --help text, but otherwise still appears before the first output from low-level config initialization.

FossilOrigin-Name: 826bad10e9ccd6f71e6dad90d41fb7d4a941e459d2e080901345ed8877ad5e38

11 months agoFurther consolidation of auto.def and autoconf/auto.def. Note in configure --help...
stephan [Mon, 24 Feb 2025 11:21:32 +0000 (11:21 +0000)] 
Further consolidation of auto.def and autoconf/auto.def. Note in configure --help that --disable-largefile is a legacy option which has no effect on the library but may influence the generated sqlite_cfg.h.

FossilOrigin-Name: 17fd6836f362c646d6dadb40adc0a8a31e2bfc9416651dde2c156400b3aa06dd

11 months agoMerge latest changes from trunk into this branch. win32-enable-setlk
dan [Mon, 24 Feb 2025 10:52:34 +0000 (10:52 +0000)] 
Merge latest changes from trunk into this branch.

FossilOrigin-Name: 55324d1c862c42b95251a398c40930d9fa94debb1aec7d3d0ae734d6b17b4a59

11 months agoMove the configure output about the SQLite version and build dirs up, so that they...
stephan [Mon, 24 Feb 2025 10:30:59 +0000 (10:30 +0000)] 
Move the configure output about the SQLite version and build dirs up, so that they appear before any tests for the C compiler and such.

FossilOrigin-Name: 83e0f3d138abf33751f735169aee752ba1677c5df37c3947f2c8be3ea3629822

11 months agoFurther consolidation of the main auto.def and the autoconf auto.def content into...
stephan [Mon, 24 Feb 2025 08:42:40 +0000 (08:42 +0000)] 
Further consolidation of the main auto.def and the autoconf auto.def content into sqlite-config.tcl.

FossilOrigin-Name: 76a4efa9668791f23de8d4db1788708891f5efa01ba73bced6abfc54391c3b28

11 months agoConfigure-internal doc tweaks. Fix the distclean rules for libsqlite3.dll.a on msys...
stephan [Mon, 24 Feb 2025 07:06:36 +0000 (07:06 +0000)] 
Configure-internal doc tweaks. Fix the distclean rules for libsqlite3.dll.a on msys/cygwin/mingw, broken when the DLL basename was changed for those platforms.

FossilOrigin-Name: 8641e2c7c868be67ebb367fe7c8ceeee0e0d96574c164191ce9e340e7a527f49

11 months agoAdd some internal notes about potential changes for the rpath flag handling.
stephan [Mon, 24 Feb 2025 05:10:09 +0000 (05:10 +0000)] 
Add some internal notes about potential changes for the rpath flag handling.

FossilOrigin-Name: 6f904f0695c7e3396522c061170d6201b256af0294afeefcf8b6672e3ba15987

11 months agoUpdate jimsh0.c from upstream autosetup to address [https://github.com/msteveb/autose...
stephan [Mon, 24 Feb 2025 04:47:34 +0000 (04:47 +0000)] 
Update jimsh0.c from upstream autosetup to address [https://github.com/msteveb/autosetup/issues/75|autosetup ticket #75], triggered by this build in the Gentoo project.

FossilOrigin-Name: ffd05de8a3b7cab1b8e91b99da74b43ec5a7b91c78dcfd7cf338b66126e30a56

11 months agoMake column output modes in the CLI responsive to the --escape setting.
drh [Mon, 24 Feb 2025 00:40:36 +0000 (00:40 +0000)] 
Make column output modes in the CLI responsive to the --escape setting.

FossilOrigin-Name: 14ff5557d450475ad959f8c753c0cecb85dfca7346fcacd91da16e4d36e30508

11 months agoThree different --escape modes: symbol, ascii, off.
drh [Mon, 24 Feb 2025 00:18:12 +0000 (00:18 +0000)] 
Three different --escape modes:  symbol, ascii, off.

FossilOrigin-Name: b5adb52fc0dc1838cb9c66cff422f2b8ec147e546cf909dd3c48731fa1edfe50

11 months agoFurther improvements to control-character escapes in the CLI.
drh [Sun, 23 Feb 2025 20:50:37 +0000 (20:50 +0000)] 
Further improvements to control-character escapes in the CLI.

FossilOrigin-Name: 9c2f974c17e3dfac78f3808fdfe916f7617cfdaa64430af38eae21bd6592e6f5

11 months agoWork toward VT100-safe output from the CLI by default.
drh [Sun, 23 Feb 2025 20:20:56 +0000 (20:20 +0000)] 
Work toward VT100-safe output from the CLI by default.

FossilOrigin-Name: 44c44620e8648a4265053f194e32b3a5c65d25b4f1fff61ef9b944e7cb0ed624

11 months agoAdd (disabled) infrastructure for disabling use of the rpath linker flag. This is...
stephan [Sun, 23 Feb 2025 17:55:41 +0000 (17:55 +0000)] 
Add (disabled) infrastructure for disabling use of the rpath linker flag. This is a proactive precautionary measure because how the rpath is used does not match up with what the unix-on-windows environments do with their DLLs.

FossilOrigin-Name: 38ba8e837c2679f12a4019612f7188cb4afffd43cef7af4a4aa02e62c20885ac

11 months agoInternal cleanups to how certain linker flags are tested.
stephan [Sun, 23 Feb 2025 17:24:55 +0000 (17:24 +0000)] 
Internal cleanups to how certain linker flags are tested.

FossilOrigin-Name: 6743e3e5b87f1d2308ec8cebef3c7ecccddafdace107630e0d8feee2b089d105

11 months agoInternal configure doc cleanups. Apply the [5ecbe7ddc4] unix-on-windows DLL install...
stephan [Sun, 23 Feb 2025 15:34:05 +0000 (15:34 +0000)] 
Internal configure doc cleanups. Apply the [5ecbe7ddc4] unix-on-windows DLL install dir fix to the canonical build.

FossilOrigin-Name: 51b9812df9087ec0aa7656178a069ddf2d60dcffa5ab0de57a84bd412b2f71c7

11 months agoThe %#Q conversion now adds unistr('...') around the converted string if
drh [Sun, 23 Feb 2025 11:48:07 +0000 (11:48 +0000)] 
The %#Q conversion now adds unistr('...') around the converted string if
escape characters were inserted.  %#w now works just like %w as escape
sequences inside of identifiers are not recognized.

FossilOrigin-Name: 997391d42079783e294836f714ccd9526ecc442c8dbf8212d72cd17c67e7158a

11 months agoEnhance the %Q, %q, and %w printf conversions so that if the alternate-form
drh [Sun, 23 Feb 2025 00:09:24 +0000 (00:09 +0000)] 
Enhance the %Q, %q, and %w printf conversions so that if the alternate-form
flag # is present, they transform backslash and control characters into
unistr()-style backslash escape codes.

FossilOrigin-Name: ffbfcc2bbb57f02aa5ee813e7a25a2a014e3353a10f6bccb609075a5b63545d7

11 months agoPrototype implementation of the unistr() SQL function.
drh [Sat, 22 Feb 2025 23:18:38 +0000 (23:18 +0000)] 
Prototype implementation of the unistr() SQL function.

FossilOrigin-Name: 7cc302de05ed2a973372c05f55b048bf99af3d2590dd29f6fd0f379fb451aa0e

11 months agoUpdate the help text to account for [35b1c32f80b9].
stephan [Sat, 22 Feb 2025 17:33:18 +0000 (17:33 +0000)] 
Update the help text to account for [35b1c32f80b9].

FossilOrigin-Name: f2e7355d87450f9a4d98390cf9d830e9902105048f9308e02c597190ecf2a594

11 months agoReplace --dll-basename=none with --dll-basename=default.
stephan [Sat, 22 Feb 2025 17:30:08 +0000 (17:30 +0000)] 
Replace --dll-basename=none with --dll-basename=default.

FossilOrigin-Name: 35b1c32f80b9aed04776508683a1828fd5777ee8bb0e42e593557ae3cca558e4

11 months agoTamp down various harmless compiler warnings. Use "int" in places instead
drh [Sat, 22 Feb 2025 16:44:14 +0000 (16:44 +0000)] 
Tamp down various harmless compiler warnings.  Use "int" in places instead
of "u16" or "i16" since the compiler complains less and generates faster
code.

FossilOrigin-Name: 742827f049768c4f69ccdfaadfad339aaad3bc126d3a68b90cfea01d825bf7ce

11 months agoOn unix-on-windows platforms, if either of --out-implib or --dll-basename are not...
stephan [Sat, 22 Feb 2025 16:31:16 +0000 (16:31 +0000)] 
On unix-on-windows platforms, if either of --out-implib or --dll-basename are not provided, auto-enable them. Add the 'none' special value to those flags to specifically disable the environment-specific handling of those flags.

FossilOrigin-Name: 486400801a4540392c04d805a47df5249c4010b1a5fbac91900db6149374c274

11 months agoEnsure that [08c9e56f60] uses an absolute path when appending .exe to mksourceid.
stephan [Sat, 22 Feb 2025 14:58:20 +0000 (14:58 +0000)] 
Ensure that [08c9e56f60] uses an absolute path when appending .exe to mksourceid.

FossilOrigin-Name: 906d27f7a645833595f02ddf05892703783d89116b1009f04e0b71679ff34a8b

11 months agoRandom non-functional configure script cleanups.
stephan [Sat, 22 Feb 2025 14:53:31 +0000 (14:53 +0000)] 
Random non-functional configure script cleanups.

FossilOrigin-Name: 2ee73109809e7d4a9d203cfa42f29c62837c06dc414f9dbf17ce00d9bbb5a883

11 months agotool/mksqlite3h.tcl: when invoking the mksourceid binary, add a .exe to it, if needed...
stephan [Sat, 22 Feb 2025 14:53:00 +0000 (14:53 +0000)] 
tool/mksqlite3h.tcl: when invoking the mksourceid binary, add a .exe to it, if needed, to appease msys2.

FossilOrigin-Name: 08c9e56f6082bb609a42f0e34c83542fe8b682757bc45616810d91491950fd0f

11 months agoFix an incorrect assert added by [d7729dbbf231d57c].
drh [Sat, 22 Feb 2025 11:40:29 +0000 (11:40 +0000)] 
Fix an incorrect assert added by [d7729dbbf231d57c].

FossilOrigin-Name: eeea11278bdebe336f0c30fbad79e30e3456ab67dae46abdd5f9951ea1b61bed

11 months agoFix installation rules for import lib in the autoconf bundle, broken by recent refact...
stephan [Sat, 22 Feb 2025 00:01:30 +0000 (00:01 +0000)] 
Fix installation rules for import lib in the autoconf bundle, broken by recent refactoring in this branch.

FossilOrigin-Name: 95b71fc7e9887833f03f84c37b94385012a6ae76b86cd079372f1752833e0f5d

11 months agoRename configure-defined ENABLE_SHARED/STATIC makefile vars to ENABLE_LIB_... so...
stephan [Fri, 21 Feb 2025 23:43:10 +0000 (23:43 +0000)] 
Rename configure-defined ENABLE_SHARED/STATIC makefile vars to ENABLE_LIB_... so that they're consistent between the canonical and autoconf builds (baby steps towards further configure code consolidation).

FossilOrigin-Name: a7647fd07792ef32697c7ba8ab6348593c2a5c4cedf673b155206da6aae799f8

11 months agoConfigure docs/help text tweaks. No functional changes.
stephan [Fri, 21 Feb 2025 23:27:03 +0000 (23:27 +0000)] 
Configure docs/help text tweaks. No functional changes.

FossilOrigin-Name: 701cc1aff423b87996134801abbbcd06d529bbf522c725837844b6aea406fb1c

11 months agoOnly use the platform-specific --dll-basename if that option is explicitly provided...
stephan [Fri, 21 Feb 2025 22:46:18 +0000 (22:46 +0000)] 
Only use the platform-specific --dll-basename if that option is explicitly provided, else use libsqlite3.

FossilOrigin-Name: 69bacfdce5d99ba532feb30d19ccea9ef49ed3bbf33e44d41bb8740811f5b0cf

11 months agoFix another deps problem for msys installs.
stephan [Fri, 21 Feb 2025 22:39:48 +0000 (22:39 +0000)] 
Fix another deps problem for msys installs.

FossilOrigin-Name: b0b9e92599dd4fbe2aafacf41eef5fecfce3295b025dad799a292e78f5e370c2

11 months agoEnsure that the prefix/bin dir exists on msys/cygwin installations before installing...
stephan [Fri, 21 Feb 2025 22:35:10 +0000 (22:35 +0000)] 
Ensure that the prefix/bin dir exists on msys/cygwin installations before installing the DLL there.

FossilOrigin-Name: 5ecbe7ddc48f688b1a511a86f81e7fb8ad3a559c2d513738c839f4d37c63db1c

11 months agoAdd --dll-basename flag to give clients control over the DLL's base name. Split the...
stephan [Fri, 21 Feb 2025 21:58:32 +0000 (21:58 +0000)] 
Add --dll-basename flag to give clients control over the DLL's base name. Split the DLL installation makefile rules into digestible, platform-specific chunks. On Windows-side Unix-like environments, install the DLL into the bin dir. Requires testing and feedback from those platforms' package maintainers to confirm it follows the expectated conventions.

FossilOrigin-Name: 8d5fed807b7151dcb79b97cfc2da0e8ac3586a0bf8b4c28967ad4cffafa53c08

11 months agoThe number of declared columns in an index is limited to SQLITE_LIMIT_COLUMN.
drh [Fri, 21 Feb 2025 20:35:37 +0000 (20:35 +0000)] 
The number of declared columns in an index is limited to SQLITE_LIMIT_COLUMN.
But the actual number of columns in the implementation might need to be
twice as much to account for the primary key at the end.  Ensure that the
code is able to deal with this.  This is a correction to
check-in [d7729dbbf231d57c].

FossilOrigin-Name: 5822feec43be9352fd87bf9968c39c0218e01ab5fe3ba50431ae21cba79e6c89

11 months agoExtend --out-implib to optionally specify the import lib's name. Add as-yet-unused...
stephan [Fri, 21 Feb 2025 20:28:44 +0000 (20:28 +0000)] 
Extend --out-implib to optionally specify the import lib's name. Add as-yet-unused internals for specifying the DLL's base name (which differs across the Windows-side Unix-esque environments).

FossilOrigin-Name: 12a55d343f9663acb68cd0f75fbb6c9ab67f4f88ad296e3e266f12d91522dd19

11 months agoMakefile-internal var renaming in prep for pending portability-related changes in...
stephan [Fri, 21 Feb 2025 20:22:56 +0000 (20:22 +0000)] 
Makefile-internal var renaming in prep for pending portability-related changes in the handling of DLLs. No functional/build interface changes.

FossilOrigin-Name: ebf41fc90aa9fb1bb96239145c0cdd06eced391499975c71734610996d088641

11 months agoDetect when a UNIQUE or PRIMARY KEY on a WITHOUT ROWID table would need
drh [Fri, 21 Feb 2025 17:03:22 +0000 (17:03 +0000)] 
Detect when a UNIQUE or PRIMARY KEY on a WITHOUT ROWID table would need
to use more than SQLITE_LIMIT_COLUMN columns and raise an error.
Also include some unrelated compiler warning fixes.

FossilOrigin-Name: d7729dbbf231d57cbcaaa5004d0a9c4957f112dd6520052995b232aa521c0ca3

11 months agoconfigure: in several places where support for -Wl,... linker flags are checked,...
stephan [Fri, 21 Feb 2025 03:19:21 +0000 (03:19 +0000)] 
configure: in several places where support for -Wl,... linker flags are checked, ensure that the check invokes the linker (not just the compiler) to avoid false positives. This allows us to remove the AIX-specific handling and --disable-rpath bits added in [a15e0f680], as well as make several similar checks more robust.

FossilOrigin-Name: 4e81e2c707a954dcda6219dc94e2b96dd0c9907bd4beab28adad51d488b7d739

11 months agoconfigure: automatically fail the check for rpath on AIX systems and provide a -...
stephan [Thu, 20 Feb 2025 17:14:40 +0000 (17:14 +0000)] 
configure: automatically fail the check for rpath on AIX systems and provide a --disable-rpath flag as a fallback for use on platforms which pass the configure-time rpath check but then fail at link-time. Based on discussion in [forum:ae5bd8a84b|forum thread ae5bd8a84b].

FossilOrigin-Name: a15e0f6802a5ba7bc5a7a70d6a162ea4548b49b132a5ac31263e64c388bbafcb

11 months agoFix autoconf bundle to honor the --disable-static and --disable-shared flags, as...
stephan [Thu, 20 Feb 2025 16:45:45 +0000 (16:45 +0000)] 
Fix autoconf bundle to honor the --disable-static and --disable-shared flags, as reported in [forum:ae5bd8a84b|forum post ae5bd8a84b]. Problem introduced in 3.49.0.

FossilOrigin-Name: 56027220cc15b69cb98ba5360ffd3718c997e10d51e30eebeff14f0dc358d103

11 months agowasm: do not build the (untested/unsupported) node-for-node build by default, to...
stephan [Thu, 20 Feb 2025 05:39:18 +0000 (05:39 +0000)] 
wasm: do not build the (untested/unsupported) node-for-node build by default, to cut build time by about 15%. Adjacent cleanups in mkwasmbuilds.c.

FossilOrigin-Name: e4539ebebd89840b76f5a0626393299100685a38f45546a0bf7a62e4df56f863

11 months agowasm makefile docs: make explicit that the node.js-for-node.js builds (as opposed...
stephan [Thu, 20 Feb 2025 04:45:02 +0000 (04:45 +0000)] 
wasm makefile docs: make explicit that the node.js-for-node.js builds (as opposed to the node.js-for-browser builds) are both untested and unsupported.

FossilOrigin-Name: e1f184889fef4603d61d306c8c0dc86df616290ccf73dbd871fa27bd99e5e5c9

11 months agoAdd the pause/unpause capability to the opfs-sahpool VFS, as discussed in [forum...
stephan [Thu, 20 Feb 2025 04:14:26 +0000 (04:14 +0000)] 
Add the pause/unpause capability to the opfs-sahpool VFS, as discussed in [forum:fe8cdb8431c|forum thread fe8cdb8431c]. Summary: this gives clients a way to eke some degree of multi-page/tab/Worker concurrency out of this VFS but requires that coordination to be implemented client-side, e.g. via a SharedWorker or WebLocks.

FossilOrigin-Name: b5dbd521951e129b4dec69f191a872500dbf387b34a8479ad58b053ffcccbab9

11 months agoconfigure: when running proj-check-function-in-lib, strip -Werror from CFLAGS for...
stephan [Thu, 20 Feb 2025 03:27:47 +0000 (03:27 +0000)] 
configure: when running proj-check-function-in-lib, strip -Werror from CFLAGS for the duration of the test. This enables CFLAGS='-Wall -Werror' and the like to be passed to configure without breaking these configure-time checks.

FossilOrigin-Name: 4ae9d6c642295e3a0c1732dacf7c18ecacd39d3e74e38381ac5531c8396f5f1c

11 months agoIncrease default CLI shell .prompt buffer length to 128 bytes, based on discussion...
stephan [Wed, 19 Feb 2025 13:05:33 +0000 (13:05 +0000)] 
Increase default CLI shell .prompt buffer length to 128 bytes, based on discussion in [forum:362f185a6aa|forum post 362f185a6aa].

FossilOrigin-Name: 628407f03d4bfb7499f0e6e2197089edf859380a3c4e6fecc517390327718141

11 months agoSlight tweak to the CLI shell help output to help convey that it can accept multiple...
stephan [Wed, 19 Feb 2025 13:02:23 +0000 (13:02 +0000)] 
Slight tweak to the CLI shell help output to help convey that it can accept multiple SQL arguments, as suggested in [forum:20e617feee|forum post 20e617feee].

FossilOrigin-Name: 82fc67070f9aff0065c07cbeed40f4321e03617bdc3e517adc58a2d96e6e3e49

11 months agoHave SQLITE_FTS5_ENABLE_TEST_MI builds avoid reading the database schema from
dan [Tue, 18 Feb 2025 15:11:30 +0000 (15:11 +0000)] 
Have SQLITE_FTS5_ENABLE_TEST_MI builds avoid reading the database schema from
within sqlite3_open().

FossilOrigin-Name: 15dc524fd4113026cc542140c39c1c8f9e052d36946f0c599f282d9ac27efdab

11 months agoMerge the latest trunk enhancements into the bedrock branch.
drh [Tue, 18 Feb 2025 14:48:14 +0000 (14:48 +0000)] 
Merge the latest trunk enhancements into the bedrock branch.

FossilOrigin-Name: c09656c62155a6e82d0fa6c27bf8ec40a14854845adfa53db3cb42a0b1b29101

11 months agoMerge all the latest trunk enhancements into the wal2 branch.
drh [Tue, 18 Feb 2025 14:38:00 +0000 (14:38 +0000)] 
Merge all the latest trunk enhancements into the wal2 branch.

FossilOrigin-Name: bd4651659548bfa523dd99f0c771b7d3c9f5dc41d0412f4f939710c4f4c6e17d

11 months agoUpdate path on the web server for test/snapshot instances of fiddle.
stephan [Tue, 18 Feb 2025 01:16:26 +0000 (01:16 +0000)] 
Update path on the web server for test/snapshot instances of fiddle.

FossilOrigin-Name: 57caa3136d1bfca06e4f2285734a4977b8d3fa1f75bf87453b975867e9de38fc

11 months agoAdd an ORDER BY to a test case for skip-scan to make the output consistent.
drh [Mon, 17 Feb 2025 20:13:20 +0000 (20:13 +0000)] 
Add an ORDER BY to a test case for skip-scan to make the output consistent.

FossilOrigin-Name: 9c9c19414ac243ce48a34bf13a08bff54a465e54a0c09ded50508b8d4bdba227