]> git.ipfire.org Git - thirdparty/sqlite.git/log
thirdparty/sqlite.git
9 months agoImprovement output for ".schema --indent" in the CLI when the schema contains wrong-branch
drh [Wed, 5 Mar 2025 16:30:36 +0000 (16:30 +0000)] 
Improvement output for ".schema --indent" in the CLI when the schema contains
partial indexes with long and complicated WHERE clauses.

FossilOrigin-Name: 94c6e8d97158fde5c8200206cf21e8acc9de8d1b4cbaf7db8d9c6a56ad6762e4

9 months agoUpdate Lemon so that it accepts filename arguments to directives like
drh [Wed, 5 Mar 2025 13:39:33 +0000 (13:39 +0000)] 
Update Lemon so that it accepts filename arguments to directives like
"%include".  Ex:  "<tt>%include &lt;./subdir/file-to-include.txt&gt;</tt>".
This was capability needed by pikchr and backported here for safe keeping.
SQLite does not need this capability, though it doesn't hurt to have it in tree.

FossilOrigin-Name: 52b97a7ad5d944e44240f624b30a76398d10ef945d8edc4b7d7b36ed2e515327

9 months agoFix pointless comparison of an unsigned integer to less than zero in Lemon.
drh [Tue, 4 Mar 2025 17:06:38 +0000 (17:06 +0000)] 
Fix pointless comparison of an unsigned integer to less than zero in Lemon.

FossilOrigin-Name: 559560da45d0e22ccc6f47dd9eb5ba16851ea444da7e4e951f07b8aa6f6b3753

9 months agoMerge the latest trunk enhancements into the reuse-schema branch.
drh [Mon, 3 Mar 2025 16:53:48 +0000 (16:53 +0000)] 
Merge the latest trunk enhancements into the reuse-schema branch.

FossilOrigin-Name: b51690e180cfb6034c772899f068453da8484a830283f7c152cfb6fa4330c31e

9 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

9 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

9 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

9 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

9 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

9 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

9 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

9 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

9 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

9 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

9 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

9 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

9 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

9 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

9 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

9 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

9 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

9 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

9 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

9 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

9 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

9 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

9 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

9 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

9 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

9 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

9 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

9 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

9 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

9 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

9 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

9 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

9 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

9 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

9 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

9 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

9 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

9 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

9 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

9 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

9 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

9 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

9 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

9 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

9 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

9 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

9 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

9 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

9 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

9 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

9 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

9 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

9 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

9 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

9 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

9 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

10 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

10 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

10 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

10 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

10 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

10 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

10 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

10 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

10 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

10 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

10 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

10 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

10 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

10 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

10 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

10 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

10 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

10 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

10 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

10 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

10 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

10 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

10 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

10 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

10 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

10 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

10 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

10 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

10 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

10 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

10 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

10 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

10 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

10 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

10 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

10 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

10 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

10 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

10 months agoMerge the latest trunk enhancements into the reuse-schema branch.
drh [Tue, 18 Feb 2025 14:56:13 +0000 (14:56 +0000)] 
Merge the latest trunk enhancements into the reuse-schema branch.

FossilOrigin-Name: b2bf063011df07a4ee8031461dee9ee9b6e4de46f24e492d95104707332b26dc

10 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