]> git.ipfire.org Git - thirdparty/sqlite.git/log
thirdparty/sqlite.git
4 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

4 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

4 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

4 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

4 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

4 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

4 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

4 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

4 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

4 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

4 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

4 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

4 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

4 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

4 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

4 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

4 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

4 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

4 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

4 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

4 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

4 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

4 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

4 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

4 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

4 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

4 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

4 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

4 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

4 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

4 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

4 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

4 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

4 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

4 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

4 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

4 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

4 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

4 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

4 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

4 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

4 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

4 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

4 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

4 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

4 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

4 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

4 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

4 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

4 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

4 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

4 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

4 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

4 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

4 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

4 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

4 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

4 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

4 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

4 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

4 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

4 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

4 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

4 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

4 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

4 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

4 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

4 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

4 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

4 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

4 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

4 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

4 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

4 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

4 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

4 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

4 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

4 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

4 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

4 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

4 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

4 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

4 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

4 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

4 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

4 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

4 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

4 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

4 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

4 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

4 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

4 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

4 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

4 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

4 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

4 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

4 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

4 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

4 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

4 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