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

5 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