]> git.ipfire.org Git - thirdparty/sqlite.git/log
thirdparty/sqlite.git
4 months agoExperimental prototype for "PRAGMA loadall(TABLE_OR_INDEX)". pragma-loadall
drh [Thu, 20 Feb 2025 12:34:24 +0000 (12:34 +0000)] 
Experimental prototype for "PRAGMA loadall(TABLE_OR_INDEX)".

FossilOrigin-Name: f24e4d7bc073bd91f23967e1d8478e81089670cbdf1eb8166955768ab62a51c7

4 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

4 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

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

4 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

4 months agoFix problems in test script fkey6.test.
dan [Mon, 17 Feb 2025 19:44:45 +0000 (19:44 +0000)] 
Fix problems in test script fkey6.test.

FossilOrigin-Name: 088e476519c2c759ba9387cb18eaad7c042cc37e45e96237d3125ba33ee3633a

4 months agoFix a typo in a comment in wal.c.
dan [Mon, 17 Feb 2025 19:06:01 +0000 (19:06 +0000)] 
Fix a typo in a comment in wal.c.

FossilOrigin-Name: e0f898f356e50568ebf62f18f39b05d2428038b88e277613bbed818dac1b0fd0

4 months agoAdditional changes making it easier to prove that integer overflow does not
drh [Mon, 17 Feb 2025 18:09:24 +0000 (18:09 +0000)] 
Additional changes making it easier to prove that integer overflow does not
occur.  No problems found.

FossilOrigin-Name: e846743a875430a5c51d41f00ac9532214f97d9925e6261113b63580f92369fc

4 months agoCode changes that make it easier to prove that no 32-bit integer overflows
drh [Mon, 17 Feb 2025 17:33:14 +0000 (17:33 +0000)] 
Code changes that make it easier to prove that no 32-bit integer overflows
happen during memory allocation.  No problems fixed; this change is just
to make future maintenance easier.

FossilOrigin-Name: 215650a5a1d55bdbca9c92524804a1a54456a17f42a17e53747b21a6507506f5

4 months agoAdd two generated files to the distclean rules of the autoconf bundle.
stephan [Mon, 17 Feb 2025 16:14:15 +0000 (16:14 +0000)] 
Add two generated files to the distclean rules of the autoconf bundle.

FossilOrigin-Name: b59d0ebb22e4ca2f3a7a73dd49a0c142dbca538cb1b4eafd35a78bac87c6c456

4 months agoReplace TEXE (legacy name) with T.exe (3.48+ name) in two places in makefiles. This...
stephan [Mon, 17 Feb 2025 16:04:21 +0000 (16:04 +0000)] 
Replace TEXE (legacy name) with T.exe (3.48+ name) in two places in makefiles. This fixes distclean of jimsh.exe in the canonical build in non-native Windows environments.

FossilOrigin-Name: edb8a78c0238f085eefbf86aa7777528f36f3400d4ef096ffd6855cf3321a97b

4 months agoHarden the SQLITE_DBCONFIG_LOOKASIDE interface against misuse, such as
drh [Mon, 17 Feb 2025 14:16:49 +0000 (14:16 +0000)] 
Harden the SQLITE_DBCONFIG_LOOKASIDE interface against misuse, such as
described in [forum:/forumpost/48f365daec|forum post 48f365daec].  Enhancements
to the SQLITE_DBCONFIG_LOOKASIDE documentation.  Test cases in TH3.

FossilOrigin-Name: 1ec4c308c76c69fba031184254fc3340f07607cfbf8342b13713ab445563d377

4 months agoFix a typo (a missing ")") in a comment that is used to generate
drh [Mon, 17 Feb 2025 10:58:23 +0000 (10:58 +0000)] 
Fix a typo (a missing ")") in a comment that is used to generate
documentation.  No changes to code.

FossilOrigin-Name: ea21685658df8246551650666ff59945ac27271b10a675104cbadaf57d48595f

4 months agoInternal reordering/re-grouping of some configure flags. No functional changes.
stephan [Sun, 16 Feb 2025 19:16:09 +0000 (19:16 +0000)] 
Internal reordering/re-grouping of some configure flags. No functional changes.

FossilOrigin-Name: 0c085a5ab51d6ac793a147a865bd086b1a6a572932c251b38d3854e4ea802f8d

4 months agoRe-add the --disable-static-shell configure feature to the autoconf bundle. It got...
stephan [Sun, 16 Feb 2025 18:14:05 +0000 (18:14 +0000)] 
Re-add the --disable-static-shell configure feature to the autoconf bundle. It got lost in the autoconf-to-autosetup port, as reported in [forum:cc219ee7044|forum post cc219ee7044].

FossilOrigin-Name: 47e817f663468ce08dae4965b7ecacefb921a77398ec958b35bf5cedee767e24

4 months agoUpdate autoconf/Makefile.msc from tool/mkmsvcmin.tcl.
stephan [Sun, 16 Feb 2025 13:49:18 +0000 (13:49 +0000)] 
Update autoconf/Makefile.msc from tool/mkmsvcmin.tcl.

FossilOrigin-Name: 9ffe94d2ea0b3679c3d2657e2c3b67f84c09e9bcbbe0a13c76d58858df367d1b

4 months agoAPI naming typo reported in [forum:416f2d8dec|forum post 416f2d8dec]. No functional...
stephan [Sun, 16 Feb 2025 13:13:19 +0000 (13:13 +0000)] 
API naming typo reported in [forum:416f2d8dec|forum post 416f2d8dec]. No functional changes.

FossilOrigin-Name: 0cfb9e234e116741d01b65d0abf18210e495276319fb08ec6e40d3f2e698956d

4 months agoAdd a typecast to avoid 32-bit integer overflow in the concat_ws()
drh [Sun, 16 Feb 2025 10:57:25 +0000 (10:57 +0000)] 
Add a typecast to avoid 32-bit integer overflow in the concat_ws()
function with an enormous separator values and many arguments.

FossilOrigin-Name: 498e3f1cf57f164fbd8380e92bf91b9f26d6aa05d092fcd135d754abf1e5b1b5

4 months agoRemove tea version check from tool/srctree-check.tcl, as it's obsoleted by [be265559].
stephan [Sat, 15 Feb 2025 17:29:56 +0000 (17:29 +0000)] 
Remove tea version check from tool/srctree-check.tcl, as it's obsoleted by [be265559].

FossilOrigin-Name: 1860ea060bd373f49d0b5d41367409a4607e9a0a0cb606af99927af15de1e21e

4 months agoAutomate update of the library version number in autoconf/tea/configure.ac as part...
stephan [Sat, 15 Feb 2025 16:24:05 +0000 (16:24 +0000)] 
Automate update of the library version number in autoconf/tea/configure.ac as part of the tool/mkautoconfamal.sh process, per /chat discussion.

FossilOrigin-Name: be265559a334eda127862ae54edb58c46051f74445642daa84a9f61a81df1bac

4 months agoDLL installation rules no longer create versioned symlinks on platforms where the...
stephan [Sat, 15 Feb 2025 16:12:28 +0000 (16:12 +0000)] 
DLL installation rules no longer create versioned symlinks on platforms where the DLL extension is '.dll' (cygwin, msys2, etc.), as suggested in [forum:28bb79638844c328|forum post 28bb79638844c328].

FossilOrigin-Name: d743410665df8ba962db6e1f245d929b005d0add77be95af3c3c7f87a1c758fb

4 months agoA cleaner workaround for [6a21d6a2], provided by autosetup's creator.
stephan [Sat, 15 Feb 2025 14:12:24 +0000 (14:12 +0000)] 
A cleaner workaround for [6a21d6a2], provided by autosetup's creator.

FossilOrigin-Name: 334ed723d0fc0b202f79a9746459181f637ca99c54864a4aa11629eecb4b8d0c

4 months agoMore informative output for the pthread feature test.
stephan [Fri, 14 Feb 2025 18:17:31 +0000 (18:17 +0000)] 
More informative output for the pthread feature test.

FossilOrigin-Name: 01b9ed73ca6e72411dcf5a81f445c15c5bc42fa068fc7eca485ac72635b9d2fc

4 months agoMake failure to find pthreads support non-fatal unless --enable-threadsafe is specifi...
stephan [Fri, 14 Feb 2025 18:06:28 +0000 (18:06 +0000)] 
Make failure to find pthreads support non-fatal unless --enable-threadsafe is specifically passed in. Build regression reported in [8e0fdb8c0d].

FossilOrigin-Name: 806ad1ac173d7c0d6d94bfccd3b961fc5c9541b32773c063a8c4082380d7a90d

4 months agoSimplify the --help workaround introduced in [6a21d6a2ed].
stephan [Fri, 14 Feb 2025 17:52:57 +0000 (17:52 +0000)] 
Simplify the --help workaround introduced in [6a21d6a2ed].

FossilOrigin-Name: b0928f2043ed2a5d445c65f0d7271431e182f5a6fcd24ddcd57ea1cdcf4bbaa2

4 months agoWork around a autosetup --help bug which only(?) triggers on tcl 8.6, introduced...
stephan [Fri, 14 Feb 2025 17:21:05 +0000 (17:21 +0000)] 
Work around a autosetup --help bug which only(?) triggers on tcl 8.6, introduced by [9978c87139b7b042] and reported upstream as [https://github.com/msteveb/autosetup/issues/73|ticket #73]. Summary: calling 'options' from a proc, instead of the global scope, triggers an error about an invalid use of 'break'.

FossilOrigin-Name: 6a21d6a2ed627ba0a864bef85369ed17553b808ae5c19891fa1f70505dfcbe39

4 months agoICU config support: add more details to error messages and correct a typo which would...
stephan [Fri, 14 Feb 2025 16:42:37 +0000 (16:42 +0000)] 
ICU config support: add more details to error messages and correct a typo which would cause a configure crash if --with-icu-config=X refered to a non-executable X.

FossilOrigin-Name: ff508926651d632d86081ccde89d3367c89538dde469e9e925540d634ac8a416

4 months agoFix test cases added for [d7b90d92ffbfc61f] so that they also work when
drh [Fri, 14 Feb 2025 10:28:28 +0000 (10:28 +0000)] 
Fix test cases added for [d7b90d92ffbfc61f] so that they also work when
compiling with ICU support.
[forum:/forumpost/2ca8a09a7e|Forum post 2ca8a09a7e]

FossilOrigin-Name: 5964616dc9de9323fddfede0ded29ee135498c8760017ce1158461f596fe6914

4 months agoWhen using the --out-implib build option, install the generated .dll.a file to PREFIX...
stephan [Thu, 13 Feb 2025 16:20:05 +0000 (16:20 +0000)] 
When using the --out-implib build option, install the generated .dll.a file to PREFIX/lib.

FossilOrigin-Name: 0dadea0ec86b6ac74281915433e41ae66cc20547d9882c4be2933a24c8287927

4 months agoEnsure the counts of "deferred FK violations" and "deferred immediate FK violations...
dan [Thu, 13 Feb 2025 14:47:25 +0000 (14:47 +0000)] 
Ensure the counts of "deferred FK violations" and "deferred immediate FK violations" are kept separate when "PRAGMA defer_foreign_keys" is used.

FossilOrigin-Name: c5190b0fd9bd76653fb7bb08e931699e42c88cef8a00352360d091948cda93a2

4 months agoFix a few 32-bit overflow problems in showdb.c.
dan [Wed, 12 Feb 2025 20:19:57 +0000 (20:19 +0000)] 
Fix a few 32-bit overflow problems in showdb.c.

FossilOrigin-Name: 9377766647eeaa575d646cf5f66c3163ef7074930aa5c3b11073e6b1e90ce799

4 months agoconfigure --help cleanups and eliminate the use of a JS-esque inner function in sqlit...
stephan [Wed, 12 Feb 2025 16:59:07 +0000 (16:59 +0000)] 
configure --help cleanups and eliminate the use of a JS-esque inner function in sqlite-config.tcl. No functional changes.

FossilOrigin-Name: 6df859cd18ded3ca64a184e45709503dd9b6a3f65e7611d3352f0bad288400f4

4 months agoRemove old function declaration accidentally left in sqlite3session.h.
dan [Wed, 12 Feb 2025 15:31:26 +0000 (15:31 +0000)] 
Remove old function declaration accidentally left in sqlite3session.h.

FossilOrigin-Name: 0cfbe349d4b740f3d2be8c714cf679901fc2465db4c64e4c3742da700d82f4e7

4 months agoTiny tcl comment tweaks. No functional changes.
stephan [Wed, 12 Feb 2025 14:51:02 +0000 (14:51 +0000)] 
Tiny tcl comment tweaks. No functional changes.

FossilOrigin-Name: da94e551c0ed354ae782c89fd9495d607b77ad7572d90c41ceac12bd6ec4c31b

4 months agoOmit the src/pragma.h file. It is generated by the tool/mkpragmatab.tcl script.
drh [Tue, 11 Feb 2025 19:54:13 +0000 (19:54 +0000)] 
Omit the src/pragma.h file.  It is generated by the tool/mkpragmatab.tcl script.
The makefiles now know how to build this file for themselves.

FossilOrigin-Name: 9709ed1cdfa17f690ffd4ec8cfc54efefec8352143c1d8b701f09299bd7eef6e

4 months agoOmit the src/ctime.c source file, since it is automatically generated by a TCL
drh [Tue, 11 Feb 2025 19:40:19 +0000 (19:40 +0000)] 
Omit the src/ctime.c source file, since it is automatically generated by a TCL
script.  Instead, add rules to the various makefiles to generate ctime.c on
demand.

FossilOrigin-Name: 958bb5de7c484cc503c38d38d51a30f679244fd364df5cbfc1992e36995b2ff9

4 months agoRename a configure-internal function and fix handling of --dump-defines for the autoc...
stephan [Tue, 11 Feb 2025 17:20:12 +0000 (17:20 +0000)] 
Rename a configure-internal function and fix handling of --dump-defines for the autoconf bundle.

FossilOrigin-Name: 6aa54cc180e034a10d8fc8f8b0c13d7bc0c94509b4240ac855121d501853768f

4 months agoMove the configure flags definition and handling into autosetup/sqlite-config.tcl...
stephan [Tue, 11 Feb 2025 17:10:10 +0000 (17:10 +0000)] 
Move the configure flags definition and handling into autosetup/sqlite-config.tcl to avoid duplication between auto.def and autoconf/auto.def while still giving us a way to filter the canonical-tree-only flags out of the autoconf build.

FossilOrigin-Name: 9978c87139b7b04208fd1f62121fc4e1e2080723fde69a2bbdca88769f4baf22

4 months agoMake the --out-implib support ([6092b0b86bf93a3d]) specifically opt-in because the...
stephan [Tue, 11 Feb 2025 13:13:46 +0000 (13:13 +0000)] 
Make the --out-implib support ([6092b0b86bf93a3d]) specifically opt-in because the feature check for it passes on some platforms where it is not recognized at link-time.

FossilOrigin-Name: 75535f2355b3b2e83dd57f4c30340af98c8dbcfe6ff1e9be17d23bd30d7d766c

4 months agoAdapt [https://fossil-scm.org/home/info/3bff7b92d6d|Fossil SCM patch 3bff7b92d6d...
stephan [Tue, 11 Feb 2025 13:00:40 +0000 (13:00 +0000)] 
Adapt [https://fossil-scm.org/home/info/3bff7b92d6d|Fossil SCM patch 3bff7b92d6d], applying -lrt for platforms which need it for one of {fdatasync, nanosleep}.

FossilOrigin-Name: 1768de6e9e2c6ff3a9ee29fa6f488fb3d23a3599195ac7d1b09e61c02b7d18b3

4 months agoRemove a pointless line of code.
drh [Mon, 10 Feb 2025 19:48:13 +0000 (19:48 +0000)] 
Remove a pointless line of code.

FossilOrigin-Name: 57b2b812c8c5524f315e20cee0e6a12a3b1635aeb42925bf891532a7029d0eb0

4 months agoAdd the --size option to the test/speedtest.tcl script.
drh [Mon, 10 Feb 2025 19:12:18 +0000 (19:12 +0000)] 
Add the --size option to the test/speedtest.tcl script.

FossilOrigin-Name: 6b9007cb30257ca97de74dec1df47f46f238f034083517a51c24334e4bd30663

4 months agoMinor autosetup doc tweaks.
stephan [Mon, 10 Feb 2025 18:41:46 +0000 (18:41 +0000)] 
Minor autosetup doc tweaks.

FossilOrigin-Name: bb53beb267ee5f5836020a58f32f1bed8deb587890eef9a6e034dad53f8c3f42

4 months agoMake the "mix1" testset the default for speedtest1.
drh [Mon, 10 Feb 2025 16:34:30 +0000 (16:34 +0000)] 
Make the "mix1" testset the default for speedtest1.

FossilOrigin-Name: 7a0c3d0e14984dd49a7c1e824b9e50564094ad57c43182bfec7624a55815f961

4 months agoEnhance speedtest1 with a new testset that calls sqlite3_open() and uses the
drh [Mon, 10 Feb 2025 16:13:56 +0000 (16:13 +0000)] 
Enhance speedtest1 with a new testset that calls sqlite3_open() and uses the
connection many times.

FossilOrigin-Name: ce307addb0c7cf72e4cca066521df6e15d1220bce303a3796a794a2ae5fa95b3

4 months agoAdd jimsh.exe and jimsh0.exe to the clean rules in Makefile.msc so that stale builds...
stephan [Mon, 10 Feb 2025 15:58:22 +0000 (15:58 +0000)] 
Add jimsh.exe and jimsh0.exe to the clean rules in Makefile.msc so that stale builds of those files from msys2 and friends do not cause mysterious build errors.

FossilOrigin-Name: 44b4e4db321815c6fc0327ed7b97df868833654411e882b70f54ad3f6d212987

4 months agoconfigure: when dlopen() is not found, only fail fatally if --enable-loadable-module...
stephan [Mon, 10 Feb 2025 15:01:14 +0000 (15:01 +0000)] 
configure: when dlopen() is not found, only fail fatally if --enable-loadable-module is explicitly provided, else warn instead. Based on discussion around [forum:2efe9c33bd9021ca|forum post 2efe9c33bd9021ca]. Update proj-indented-notice to behave like its docs say it should when the -error flag is used.

FossilOrigin-Name: f28e52cbf9e80cb5a1cde7cba099e2c2b6787a77263796e4f9febf3f30bc99dc

4 months agoConvert some expensive NEVER() and ASSERT() macros into assert()s.
drh [Mon, 10 Feb 2025 11:16:37 +0000 (11:16 +0000)] 
Convert some expensive NEVER() and ASSERT() macros into assert()s.

FossilOrigin-Name: 4aad891802d9d87f1ff3cbbf4bc70fa242c6782088189a2bd5d6f8863f552d29

4 months agoSmall performance increase in jsonTranslateBlobToText().
drh [Mon, 10 Feb 2025 00:20:50 +0000 (00:20 +0000)] 
Small performance increase in jsonTranslateBlobToText().

FossilOrigin-Name: 3b1dcac2eeaf5f97450919f2a6eed74a4d54fb2b812bdb4a580f79d075e99dfe

4 months agoPerformance optimization to the substr() SQL function.
drh [Sun, 9 Feb 2025 20:23:29 +0000 (20:23 +0000)] 
Performance optimization to the substr() SQL function.

FossilOrigin-Name: ce228ce3d0132ad758b5b7464fcf22ae5976df3c02ec948280cc76290c79ed0b

4 months agoPerformance and size optimization for the sqlite3ColumnIndex() routine.
drh [Sun, 9 Feb 2025 19:49:46 +0000 (19:49 +0000)] 
Performance and size optimization for the sqlite3ColumnIndex() routine.

FossilOrigin-Name: a93e3fe0ee8f98a7ec0dfb2e1abf432cc9d5f9d3ad345b5db261475215d43df9

4 months agoUpdate the 'clean' rules for autoconf/Makefile.in to account for [6092b0b8].
stephan [Sun, 9 Feb 2025 05:37:25 +0000 (05:37 +0000)] 
Update the 'clean' rules for autoconf/Makefile.in to account for [6092b0b8].

FossilOrigin-Name: f3a35fdc9113ad5f1fed6a2f474aee670e1793d355475a7971d376bf33823cc4

4 months agoApply [6092b0b8] to autoconf/Makefile.in.
stephan [Sun, 9 Feb 2025 05:30:47 +0000 (05:30 +0000)] 
Apply [6092b0b8] to autoconf/Makefile.in.

FossilOrigin-Name: 9ae245cff49716e4c0bbd3fbb3f82276e5fb54d595d1e1d9a452edef45d7740f

4 months agoconfigure: if the linker supports --out-implib, generate libsqlite3.X.a, where X...
stephan [Sun, 9 Feb 2025 04:38:56 +0000 (04:38 +0000)] 
configure: if the linker supports --out-implib, generate libsqlite3.X.a, where X is the platform's DLL file extension. Discussion in/around [forum:0c7fc097b2|forum post 0c7fc097b2].

FossilOrigin-Name: 6092b0b86bf93a3d58a83774b6d07ef9735e6c8a0f2ac2d0a6d263c2e9f1e3ca

4 months agowasm: add some build-time validation to ensure that the problem fixed in [65798c09a00...
stephan [Sun, 9 Feb 2025 04:16:01 +0000 (04:16 +0000)] 
wasm: add some build-time validation to ensure that the problem fixed in [65798c09a00662a3] does not recur. Ensure that files generated via mkwasmbuilds.c have the generated makefile as a dependency.

FossilOrigin-Name: 55e01365946b3432e93da5c08200e476e2a134c98b963b4170e4dfae8408a005

4 months agowasm: when building in -O0 mode (typical dev mode), use -sASSERTIONS=2, else -sASSERT...
stephan [Sun, 9 Feb 2025 03:24:00 +0000 (03:24 +0000)] 
wasm: when building in -O0 mode (typical dev mode), use -sASSERTIONS=2, else -sASSERTIONS=0, in response [https://github.com/emscripten-core/emscripten/pull/23629/commits/7e3e35cbff9c5688eacb3cddc5045f872d744efd|Emscripten checkin 7e3e35cbff9], which adds assertions to check for the condition reported in [https://github.com/emscripten-core/emscripten/issues/23420|Emscripten ticket 23420]. Update some unrelated JS-side internal docs.

FossilOrigin-Name: 1f554610ba5d9d474ec4570bb7ca09125fd2cdfb4976530a4227cc6ebdf3a962

4 months agoJS: add a mechanism to the Worker1 exec API to fetch the last_insert_rowid(), as...
stephan [Sun, 9 Feb 2025 02:41:35 +0000 (02:41 +0000)] 
JS: add a mechanism to the Worker1 exec API to fetch the last_insert_rowid(), as requested in [forum:56bc35390183f5d5|forum post 56bc353901].

FossilOrigin-Name: c22c48360756b1c7e2f5a9c01aff799bc188e100d364931de0dc3686e5de57a9

4 months agoconfigure: when transfering ENABLE/OMIT flags from CFLAGS to OPT_FEATURE_FLAGS, also...
stephan [Sun, 9 Feb 2025 01:25:00 +0000 (01:25 +0000)] 
configure: when transfering ENABLE/OMIT flags from CFLAGS to OPT_FEATURE_FLAGS, also do the same for CPPFLAGS and remove those ENABLE/OMIT flags from CFLAGS/CPPFLAGS to mimic legacy build behavior. Strip ENABLE/OMIT flags from BUILD_CFLAGS but do not transfer those to OPT_FEATURE_FLAGS, also to mimic legacy behavior. This is the second part of a fix discussed at [forum:9801e54665afd728|forum post 9801e54665afd728].

FossilOrigin-Name: 16d307cc6c1e203900e7a2dc0730fc0e453946622a2114a07d64ebb99045cfbf

4 months agoAdd the "star" testset to speedtest1. Include it as part of "mix1".
drh [Sun, 9 Feb 2025 00:54:56 +0000 (00:54 +0000)] 
Add the "star" testset to speedtest1.  Include it as part of "mix1".

FossilOrigin-Name: f1345b84eaae5404268df1d0449c409fe5c4a4f9742bd67a75c7333c8c9cd597

4 months agoPut a 16-byte hash table for column names on each Table object, to speed
drh [Sat, 8 Feb 2025 16:16:08 +0000 (16:16 +0000)] 
Put a 16-byte hash table for column names on each Table object, to speed
up column name lookups.

FossilOrigin-Name: 11eb8f99e5c4974cb6ba39e5bbc99f6b88b9e01006b70d5fea85c2a6d4f7044f

4 months agoUse the sqlite3ColumnIndex() routine to look up a column in a table, rather
drh [Sat, 8 Feb 2025 14:15:42 +0000 (14:15 +0000)] 
Use the sqlite3ColumnIndex() routine to look up a column in a table, rather
than using a custom loop.  Performance improvement, size reduction, and
complexity decrease.

FossilOrigin-Name: 351dbbc2bf0b23efdc625ddaa5dc2239cf2990addf071a04bd41612b341de8c8

4 months agoFix GCC-isms and compiler warnings introduced by recent check-ins
drh [Sat, 8 Feb 2025 13:34:19 +0000 (13:34 +0000)] 
Fix GCC-isms and compiler warnings introduced by recent check-ins
[c56092507c967230] and [6e57848fe1e0e2b5].

FossilOrigin-Name: 91102c04375f83cffcd0f3204870e476636f651710e9e6fb773cf74085ef7636

4 months agoImprovements to the symbol table hash: faster lookups with fewer calls to
drh [Sat, 8 Feb 2025 12:04:25 +0000 (12:04 +0000)] 
Improvements to the symbol table hash: faster lookups with fewer calls to
sqlite3StrICmp() for schemas with many symbols and large names.

FossilOrigin-Name: 6e57848fe1e0e2b533dd65c2bc5fbac660202cf91cb94ac5468a3434e367a087

4 months agoImprovements to the hash table used to store symbols in the schema, so that hash-improvements
drh [Sat, 8 Feb 2025 11:15:41 +0000 (11:15 +0000)] 
Improvements to the hash table used to store symbols in the schema, so that
it works better (requires fewer calls to sqlite3StrICmp()) for large schemas,
and uses less code space.

FossilOrigin-Name: 0318b68c845c84eded757c67f820e1783551574ac9e5670be640c4bfe22a934b

4 months agobuild: work around a report of (install -d DIR) failing in one environment if DIR...
stephan [Fri, 7 Feb 2025 19:18:20 +0000 (19:18 +0000)] 
build: work around a report of (install -d DIR) failing in one environment if DIR already exists.

FossilOrigin-Name: 8f7b7840d48c391d43ac034ebfee9227dc1c2800adda24f02f3d3bb942f4380e

4 months agoFix comments on the Parse.nMaxArgs field so that they are correct. Add
drh [Fri, 7 Feb 2025 19:09:20 +0000 (19:09 +0000)] 
Fix comments on the Parse.nMaxArgs field so that they are correct.  Add
assert()s to ensure they are correct.  Other Parse changes to reduce the
amount of memset() needed to initialize it.

FossilOrigin-Name: c56092507c96723030589ddd9121bc993d615a7acd453305fc3b1dbb9e30554c

4 months agoFurther reduction in the amount of memset() needed to initialize the Parse
drh [Fri, 7 Feb 2025 15:49:21 +0000 (15:49 +0000)] 
Further reduction in the amount of memset() needed to initialize the Parse
object.

FossilOrigin-Name: 45e462c0060e51c3375a226d636148e3415ee6020e544ecc84861c7aef4ecf7b

4 months agoMac-specific build fixes discussed in [forum:9dfd5b8fd525a5d7|forum thread 9dfd5b8fd5...
stephan [Fri, 7 Feb 2025 14:44:31 +0000 (14:44 +0000)] 
Mac-specific build fixes discussed in [forum:9dfd5b8fd525a5d7|forum thread 9dfd5b8fd525a5d7]: rename dylib links and add legacy-compatibility versioning stamps to libsqlite3.dylib.

FossilOrigin-Name: 668bcf327a82a63d45be8cf38fdddc855dbcefdedf6c208e091eb7e2d244929d

4 months agoReduce the amount of memset() needed to initialize the Parse object.
drh [Fri, 7 Feb 2025 13:37:15 +0000 (13:37 +0000)] 
Reduce the amount of memset() needed to initialize the Parse object.

FossilOrigin-Name: 284538d8486ef3e9bee1ab980043b53c144743c31b984be13a5cc137e7cbec31

4 months agoconfigure: change extension of static libraries from .lib to .a on msys/cygwin, as...
stephan [Fri, 7 Feb 2025 12:58:09 +0000 (12:58 +0000)] 
configure: change extension of static libraries from .lib to .a on msys/cygwin, as per discussion in [forum:02db2d4240|forum post 02db2d4240]. Replace unidiomatic JS-style use of inner procs in autosetup/proj.tcl with TCL lambdas.

FossilOrigin-Name: 46f51e2a3707614a2b3ca6261bc6e0e8835477fdb7cbcf2f06b20cdebde2bab9

4 months agoReorder a piece of ext/wasm/GNUmakefile to correct the timing of various var accesses...
stephan [Fri, 7 Feb 2025 12:33:48 +0000 (12:33 +0000)] 
Reorder a piece of ext/wasm/GNUmakefile to correct the timing of various var accesses. Fixes a problem [https://github.com/sqlite/sqlite-wasm/pull/99|reported in the downstream npm subproject] and explains the confusion in [4aa025a943a4024094b9] (which has been reverted).

FossilOrigin-Name: 65798c09a00662a3598f01571d6f3a2dc750c3d0b127c344590539244afe4aa7

4 months agoFix out-of-tree builds of the autoconf bundle, as reported in [forum:a0cd0beb1baa6bef...
stephan [Fri, 7 Feb 2025 11:15:58 +0000 (11:15 +0000)] 
Fix out-of-tree builds of the autoconf bundle, as reported in [forum:a0cd0beb1baa6bef|forum post a0cd0beb1baa6bef].

FossilOrigin-Name: d47964a65bcfd4bc0b06baca281467a0b7fc87eba912a19c0974f63a54928ff8

4 months agoBump TEA configure.ac version number.
stephan [Fri, 7 Feb 2025 01:43:05 +0000 (01:43 +0000)] 
Bump TEA configure.ac version number.

FossilOrigin-Name: a1a9c780d1f1b47b0408397edded9c5d230c7b144207ad142d06c048792d31fa

4 months agoAdjust the test/speedtest.tcl script so that it uses an on-disk database
drh [Thu, 6 Feb 2025 17:29:14 +0000 (17:29 +0000)] 
Adjust the test/speedtest.tcl script so that it uses an on-disk database
rather than an in-memory database.

FossilOrigin-Name: e93d7aa1db9bdbf1996c4c168e67284177e384b7acf176d74a0458258faab05c

4 months agoFix a harmless typo in a comment.
drh [Thu, 6 Feb 2025 17:10:38 +0000 (17:10 +0000)] 
Fix a harmless typo in a comment.

FossilOrigin-Name: ed82272904deb37640286448e03153316f828c629547a615a504af1d7ec5a278

4 months agoBump version number to 3.50.0 for the next dev cycle.
stephan [Thu, 6 Feb 2025 13:36:31 +0000 (13:36 +0000)] 
Bump version number to 3.50.0 for the next dev cycle.

FossilOrigin-Name: 46d08071f3f9fef78bc2444b52060e0e7de8c357a2aa213ac13c565e33acc4a0

4 months agoFix a dependencies/order-of-operations bug in ext/wasm/GNUmakefile which causes creat...
stephan [Thu, 6 Feb 2025 13:18:49 +0000 (13:18 +0000)] 
Fix a dependencies/order-of-operations bug in ext/wasm/GNUmakefile which causes creation of files filtered via c-pp to fail if the ext/wasm/jswasm dir did not exist beforehand.

FossilOrigin-Name: 4bac76138853a89484d3ac0486a9ed5143aa671b13b4b3abb704c1487213b388

4 months agoMerge version 3.49.0 into the bedrock branch.
drh [Thu, 6 Feb 2025 12:46:51 +0000 (12:46 +0000)] 
Merge version 3.49.0 into the bedrock branch.

FossilOrigin-Name: cc3ce784b0feea2f7e86960d262a04c555df817192695d5760c2a83fb804a212

4 months agoMerge version 3.49.0 into the wal2 branch.
drh [Thu, 6 Feb 2025 12:43:21 +0000 (12:43 +0000)] 
Merge version 3.49.0 into the wal2 branch.

FossilOrigin-Name: e194c8e8c75fcfda263fbf3f51e5236e66221bd245805af95afbf6a60506d247

4 months agoVersion 3.49.0 version-3.49.0
drh [Thu, 6 Feb 2025 11:55:18 +0000 (11:55 +0000)] 
Version 3.49.0

FossilOrigin-Name: 4a7dd425dc2a0e5082a9049c9b4a9d4f199a71583d014c24b4cfe276c5a77cde

4 months agoIf SQLite is compiled with SQLITE_ENABLE_WAL_BIGHASH defined, use
dan [Wed, 5 Feb 2025 17:52:13 +0000 (17:52 +0000)] 
If SQLite is compiled with SQLITE_ENABLE_WAL_BIGHASH defined, use
hash tables large enough to fit 128K, instead of 4K, entries in the *-shm file.

FossilOrigin-Name: 581efc34624c55832afbf7b691d768d6ddbf2b23d6a190d2fa0dde1b00251454

4 months agoFix a harmless unused-parameter compiler warning introduced by [75f3d8744879].
drh [Wed, 5 Feb 2025 16:08:11 +0000 (16:08 +0000)] 
Fix a harmless unused-parameter compiler warning introduced by [75f3d8744879].

FossilOrigin-Name: 9f28f6694f97d5ee0345b45f9bf81e3fdce0990ce32fb9bdbbaac079126a67c9

4 months agoSummarize known incompatibilities/gotches between JimTCL and canonical TCL, and their...
stephan [Wed, 5 Feb 2025 12:56:55 +0000 (12:56 +0000)] 
Summarize known incompatibilities/gotches between JimTCL and canonical TCL, and their workarounds. Doc changes only.

FossilOrigin-Name: 60c932e67b886d4c050698f36e1d3fc04eb99473d62bb3b1585a97d90e27227e

4 months agoUpstream JimTCL patch and minor tcl script tweaks to support (fconfigure -translation...
stephan [Wed, 5 Feb 2025 12:49:15 +0000 (12:49 +0000)] 
Upstream JimTCL patch and minor tcl script tweaks to support (fconfigure -translation binary) for better cross-platform build portability.

FossilOrigin-Name: 0974a17c4565f202777fc6203df20dca19acc1e8740ede15334783f41e3e5054

4 months agoAttempted improvements to the SQLITE_DBCONFIG_... documentation.
drh [Wed, 5 Feb 2025 12:02:43 +0000 (12:02 +0000)] 
Attempted improvements to the SQLITE_DBCONFIG_... documentation.

FossilOrigin-Name: baac853871ad307b67b4d624b9ee47fc1313f1aa62c9f8072fb49e97aa33db94

4 months agoDetect and report signed integer overflow in the sumInverse() routine,
drh [Tue, 4 Feb 2025 02:38:23 +0000 (02:38 +0000)] 
Detect and report signed integer overflow in the sumInverse() routine,
used by window functions.

FossilOrigin-Name: 317e9a470fba2a4b717b9cb66488b8fccb44810a80f3a7deaf1ea81906e2b8d2

5 months agoTest case for the FTS3 fix in the previous check-in.
drh [Mon, 3 Feb 2025 23:27:27 +0000 (23:27 +0000)] 
Test case for the FTS3 fix in the previous check-in.

FossilOrigin-Name: 459d8f695ef868d0ec09920ab2035eebd36a66051f9905e2605f4600623faa47

5 months agoFix a potential UAF in FTS3.
drh [Mon, 3 Feb 2025 23:19:42 +0000 (23:19 +0000)] 
Fix a potential UAF in FTS3.

FossilOrigin-Name: 75f3d87448793fc7fd68d817874d561842e029a2d6c1ea4abcec39764cd38469

5 months agoNew dbsqlfuzz case added to fuzzdata8.db. fuzzer-20250203
drh [Mon, 3 Feb 2025 21:24:40 +0000 (21:24 +0000)] 
New dbsqlfuzz case added to fuzzdata8.db.

FossilOrigin-Name: 7ee20cfc237229dbea7116149c0c35883f7b8087b9ccdce6dca16b6da1c6caf8

5 months agoThe Parse.addrExplain field is never even if SQLITE_OMIT_EXPLAIN is defined.
drh [Mon, 3 Feb 2025 21:04:21 +0000 (21:04 +0000)] 
The Parse.addrExplain field is never even if SQLITE_OMIT_EXPLAIN is defined.

FossilOrigin-Name: 5d81a984c6aabb9fa9180efde8ca942b40f1ec18ff5a89f2fbb1252734f051d3

5 months agoEnhance fuzzcheck so that the --sqlid and --dbid options can take a range
drh [Mon, 3 Feb 2025 18:53:02 +0000 (18:53 +0000)] 
Enhance fuzzcheck so that the --sqlid and --dbid options can take a range
of IDs to run.

FossilOrigin-Name: 408fa57f048e05a261fb62b45ae44b8a97c97fc01e3776124cbef6595df579d4

5 months agoFixes and improved documentation to the new --sqlid and --dbid range fuzzcheck-improvements
drh [Mon, 3 Feb 2025 18:49:06 +0000 (18:49 +0000)] 
Fixes and improved documentation to the new --sqlid and --dbid range
options in fuzzcheck.

FossilOrigin-Name: 59e26632449163a36b803cc7027ed99c1f6b675dda6f0b2b12bbe55884923f08

5 months agoEnhance fuzzcheck so that the --sqlid and --dbid options can specify a
drh [Mon, 3 Feb 2025 18:36:05 +0000 (18:36 +0000)] 
Enhance fuzzcheck so that the --sqlid and --dbid options can specify a
range of tests to be run.

FossilOrigin-Name: cdd0af6f86e49ade1339ad5a3cc444400a9722a9efdf84a30b3ff9428b7ac36d

5 months agoFix for a potential UAF in FTS5.
drh [Mon, 3 Feb 2025 18:05:54 +0000 (18:05 +0000)] 
Fix for a potential UAF in FTS5.

FossilOrigin-Name: e33f2fedda17b4f3678fc23c438093c256b0c125da5f1ac42ecaf3d604d54b6a

5 months agoImprove the JS-side sqlite3_set_auxdata() test to also trigger the case that the...
stephan [Mon, 3 Feb 2025 18:01:42 +0000 (18:01 +0000)] 
Improve the JS-side sqlite3_set_auxdata() test to also trigger the case that the aux data actually gets reused. Test changes only, no library code.

FossilOrigin-Name: 9f27379d860518e6e097a2c999da04176812260a61bf11fe495c3efd76971806

5 months agoFix a use-after-free case in fts5 provoked by fuzzdata8.db. Tcl test case pending. fuzz-data
dan [Mon, 3 Feb 2025 17:54:55 +0000 (17:54 +0000)] 
Fix a use-after-free case in fts5 provoked by fuzzdata8.db. Tcl test case pending.

FossilOrigin-Name: a4962df665084e423e020be9a2834b6886a8e3feb461cff5358b61398a2a20d2

5 months agoNew test case for test/fuzzdata8.db
drh [Mon, 3 Feb 2025 17:45:41 +0000 (17:45 +0000)] 
New test case for test/fuzzdata8.db

FossilOrigin-Name: 8a882f976e22100b91c7ca4119123f16ad5f03311f0a6dc17449bcdcff29618c

5 months agoRework [76c8435a] to eliminate automatic JS-to-WASM function conversions of sqlite3_s...
stephan [Mon, 3 Feb 2025 17:34:12 +0000 (17:34 +0000)] 
Rework [76c8435a] to eliminate automatic JS-to-WASM function conversions of sqlite3_set_auxdata() destructors because it can leads to leaks on every call of a UDF. This feature never worked before [76c8435a] but fixing it was ill-conceived because of the memory leakage it introduces. WASM function pointers can still be used as destructors in this context.

FossilOrigin-Name: 3fb993af0caf041da934cea29c039b27c468be0b75bce1537a6425767cf9bf8d

5 months agoMerge all the latest trunk enhancements into the bedrock branch.
drh [Mon, 3 Feb 2025 15:11:11 +0000 (15:11 +0000)] 
Merge all the latest trunk enhancements into the bedrock branch.

FossilOrigin-Name: 1cef92de5059e468e0b1282425f50b089629c4f74671763bcefcb835798a9124

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

FossilOrigin-Name: e2d4c1890acfb97b6deda316d5308cea90d39f668319c3b42199b982d746e05c