Commit Graph
29548 Commits
Author SHA1 Message Date
drh 1b571af11a Version 3.49.2
FossilOrigin-Name: 17144570b0d96ae63cd6f3edca39e27ebd74925252bbaf6723bcb2f6b4861fb1
version-3.49.2
2025-05-07 10:39:52 +00:00
drh 999fef466a Fix a bug in the NOT NULL/IS NULL optimization
that can cause invalid data to be used for a column if that column has a
CHECK constraint that includes the NOT NULL or IS NULL operator.

FossilOrigin-Name: 9d1f01aac909a0689ab881e269c3f1e4b583b0b135689a39fd2822de7a059e5f
2025-05-06 18:04:04 +00:00
drh 42182f1c1c Correctly handle the case of a multi-column UNIQUE constraint that contains
the ROWID as one of it columns, and then the columns of that UNIQUE are
used in a row-value IN operator as a WHERE clause constraint.

FossilOrigin-Name: ba7d5bad32ad6aaca1cde7133afb20e8a060b16494098b1308c945ea2de00632
2025-04-16 10:53:20 +00:00
stephan 0b3ba763c5 Correct a makefile var name type in the configure script, introduced in [8830f86335].
FossilOrigin-Name: fa29e6a3b744d2dce15354aeda9e12d80c82e79c0dccec92b9a76272eaf97299
2025-04-04 22:58:49 +00:00
stephan 966933f276 Improve --all flag handling so that combinations of (--all --disable-FEATURE) and (--disable-all --FEATURE) work more intuitively. Add missing handling of the --fts3 flag (it was accepted but ignored before). Partial merge of [26ef0ff4bfbb], minus proj.tcl changes.
FossilOrigin-Name: 5db613dd407198c2e9f70db64cee2ef5ce8efa2d22d0f45ceb85076adf6bec4a
2025-04-04 21:11:32 +00:00
stephan 31eb27ef83 Account for the Mac-specific -install_name linker flag. See [forum:5651662b8875ec0a|forum post 5651662b8875ec0a].
FossilOrigin-Name: 8830f86335855e0cd508830a3c53590a734e0cd618d79e3eb1546a70b883d15e
2025-04-04 20:58:11 +00:00
drh d705a70eb4 Fixes for two problems with the generate_series() table-valued function.
FossilOrigin-Name: f5aea14e6e20ede782500615c4378725680c235eb8f6bbfbcdb1efd4adf6112e
2025-03-22 23:03:58 +00:00
drh 5b92ef7440 Fix two obscure logic problems that cause incorrect answers, found by a
third-party fuzzer.

FossilOrigin-Name: 1a8f763c31be5603862d20f1ee2a71bde159516bb6025fc254a43e3076e882df
2025-03-18 20:28:53 +00:00
drh a4542bcf4a Disable the [d1ba200234f40b84|count-of-view optimization] if any subquery
is DISTINCT, as the optimization does not work in that case.

FossilOrigin-Name: bae270b988139e070ac52fe8e12ddb946ae9c3be6d4229dfb3169ddc6ed6b121
2025-03-10 10:39:52 +00:00
drh e8bc8b68b0 Fix the build by rerunning test/mkpragmatab.tcl.
FossilOrigin-Name: 167d6314c5125c79a9f147b36de2d1c65f99ec5462c90742c436e872f3ac8fdf
2025-03-10 10:36:50 +00:00
stephan f5d3e81eff Bring the autosetup-related bits up to par with trunk.
FossilOrigin-Name: 47fe1c59787ffbd1558f7663fd65976b57c2f7c91df8b578d504e980f3a12380
2025-02-28 05:01:38 +00:00
stephan 9b7c5c247b 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: 8b5996f45ff45d7f0cfc17ec1469f246f8cdc5d85387c33f23d64d429d142d65
2025-02-28 01:06:14 +00:00
stephan 6fc161ff9c Configure script cosmetics: emit the host/build system info before the directory info.
FossilOrigin-Name: 9d5b97dd92f68370bcef02eb8621d893cecc1aa2c4c6fb8f04f7c5bdd84bc533
2025-02-25 16:48:34 +00:00
stephan 335c54bdf1 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: 144aacfdf76d89d30f0f6f4dfccd686d3a219f778f98487264b6ef69331ae722
2025-02-25 16:17:57 +00:00
stephan 07acc6b7b6 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: 47c43fcb5109ae660d5b56c536d8c23bdc99727648f4dd8b336ff98f9ef07d6c
2025-02-21 03:22:57 +00:00
stephan f16f93c3f2 Bump VERSION to 3.49.2.
FossilOrigin-Name: eaa2503ef699d03686beb5a3866e2a16c9de5f617a179aee2e77b98820065cca
2025-02-20 17:16:16 +00:00
stephan f9f6410c31 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: b6603986e621918525312130996c298135ad27af293df9bb9f99e1fc87844379
2025-02-20 17:15:37 +00:00
stephan b484242dba 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: e5ea86dccf0f4dccfcccb2402f4177777d86af9ebb93794a909ccad369299b68
2025-02-20 16:47:12 +00:00
drh 3cd92ce875 Version 3.49.1
FossilOrigin-Name: 873d4e274b4988d260ba8354a9718324a1c26187a4ab4c1cc0227c03d0f10e70
version-3.49.1
2025-02-18 13:38:58 +00:00
stephan 963aa5bdbf Add two generated files to the distclean rules of the autoconf bundle.
FossilOrigin-Name: 57eceb361f0290b1326acf791565eb33267a10a5201aee34bdd2d1c93d647ff8
2025-02-17 16:15:54 +00:00
stephan d3e44d4fa0 Pull build fix [edb8a78c023] and cleanup [0c085a5ab5] into branch-3.49.
FossilOrigin-Name: f10e7ac65baec64a64b340f6e799d876ca5dac05d6615c900784a45fa8f71019
2025-02-17 16:07:39 +00:00
drh 03e2f9da23 Harden the SQLITE_DBCONFIG_LOOKASIDE interface against misuse. This is a
simplification of [1ec4c308c76c69fb] appropriate for use in a patch release.

FossilOrigin-Name: 78c4994c1c1ee1fdbee39ad611eba251a7bdb02d146331d43f178094c0d282e3
2025-02-17 14:27:33 +00:00
stephan 4dd457c3ce 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: e9035c6c89e719626a55c9fa889aacc87b0b256c09817294617b515e035c4a80
2025-02-16 18:16:42 +00:00
drh 63725a467f Add a typecast to avoid 32-bit integer overflow in the concat_ws()
function with an enormous separator values and many arguments.

FossilOrigin-Name: cf6b162de534d4f5a5a02064f0618a84b70d0aa87a541cf149dacff34be2d3ab
2025-02-16 11:23:00 +00:00
drh 30c605e8ae Remove the autoconf/tea/configure.ac check from tool/srctree-check.tcl
since that file no longer exists.

FossilOrigin-Name: ff879e8e7d0c153ddc241bd8425703b019cdc143b401b915a84ea8c78759b09b
2025-02-16 11:20:00 +00:00
stephan ba96468b9b Automate update of the library version number in autoconf/tea/configure.ac as part of the tool/mkautoconfamal.sh process.
FossilOrigin-Name: d5c0be36fca18e15938ce9dc9c13bf79497d013623de85e23bb18e0940b56eba
2025-02-15 16:29:34 +00:00
stephan 8a61fe879d 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: d94ad545776ad5cdbd637c1532e0be5f0364eee31484ede97ec4173b2b76f781
2025-02-15 16:24:52 +00:00
stephan 360abdca9c A cleaner workaround for [6a21d6a2].
FossilOrigin-Name: 467804412230450c63ec47e8f903e58dce971a4752c242c3fa6b1249e535d2ac
2025-02-15 14:13:35 +00:00
stephan f15a16e00a More informative output for the pthread feature test.
FossilOrigin-Name: adf042fba614e1fbe694cf111b7c8f5408eb64031b799870495748c51c7d458c
2025-02-14 18:18:27 +00:00
stephan 5e3ef1e524 Make failure to find pthreads support non-fatal unless --enable-threadsafe is specifically passed in. Build regression reported in [8e0fdb8c0d].
FossilOrigin-Name: f8843b82921621f24c81092debd3c9a5225b498efd47e494c70378342f06b060
2025-02-14 18:07:04 +00:00
stephan b36434d0d6 Simplify the --help workaround introduced in [6a21d6a2ed].
FossilOrigin-Name: 03d0c19289b06a05a08091d23a253fa660c6d94a0c8d18742e68da5c37a00dcc
2025-02-14 17:53:52 +00:00
stephan e4f445e587 Work around autosetup --help quirk described in [6a21d6a2ed62].
FossilOrigin-Name: 61726358c57348a9537c6a83abfabbdc25fc2f94a9a7ea31c8e97066bf822571
2025-02-14 17:25:50 +00:00
stephan 40c674e54a 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: 80311f0925962f952c0112a8241774cb151fca5263824f25b0c30d17c3a805bc
2025-02-14 16:43:41 +00:00
stephan 46701fcccf When using the --out-implib build option, install the generated .dll.a file to PREFIX/lib.
FossilOrigin-Name: 8e8037bafccdbde0aefba29a13fe6026488b0f17cfc1b4c1700d2aa3c974ecc4
2025-02-13 16:31:22 +00:00
stephan 613929c59f Bring the 3.49 branch's configure-related files up to par with the current trunk.
FossilOrigin-Name: 1cc8d16b636de128ca5e9c6cf7630fb323e2969aaac984ebee928b0fe690b84b
2025-02-13 14:45:47 +00:00
stephan 967a5e8b75 Rename a configure-internal function and fix handling of --dump-defines for the autoconf bundle.
FossilOrigin-Name: 3f539d81576068f37fbd548cca384bc1ac3dfd9049354d128aea8050c694b2f7
2025-02-11 17:22:07 +00:00
stephan 26787f3538 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: 5a964bf3d8311f79d812a93e76a00f8a2a62e73b737b27a1552f7169c93fc1e5
2025-02-11 17:13:24 +00:00
stephan 15e556f552 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: 77621fd141e7a673f4d3d109ecd21bd6710eaa6f59d9e6335a6c0d971bb8b0f4
2025-02-11 13:18:01 +00:00
stephan 75b9706776 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: 8212f8ee45efa290e70a397a486e02f19d8efbb0e9e374eb908aafea1e30a37c
2025-02-11 13:15:28 +00:00
stephan 2c9a970eb8 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: 7db7eb223e0fe39a3ba00359eb3a4645db013511c823db24823b6bd904481aa1
2025-02-10 15:02:35 +00:00
stephan ecf0462e8f Update the 'clean' rules for autoconf/Makefile.in to account for [6092b0b8].
FossilOrigin-Name: 23d25ae267a5e265fa3dd36b0c4d1f0f89a87068df98799ea48faa2f2817048d
2025-02-09 05:37:46 +00:00
stephan f10e7bcd1e Apply [6092b0b8] to autoconf/Makefile.in.
FossilOrigin-Name: 6c17e4b80cd5f7e37c02989878b19d3f85c897368c0bd67521dce7cee2b24f17
2025-02-09 05:32:53 +00:00
stephan 9f10d81707 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: 705a6d3e0e8e2044a541d89be79b1bad9a5a71b11f2f878e6d385ae735cc27ee
2025-02-09 04:40:54 +00:00
stephan 82afe06bb4 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: 012b308b04e6a9e3acbb842317b01b4b91ac165b925918cf20c1f52d045a6ec0
2025-02-09 01:50:41 +00:00
stephan 3022685857 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: dcb44da41f922b9d22731ef7ba7b084444396b206757825e6fcbc165bc73368b
2025-02-09 01:30:47 +00:00
stephan 6d3751ebd4 build: work around a report of (install -d DIR) failing in one environment if DIR already exists.
FossilOrigin-Name: 4bc6fe30c967e4f15e2c154a1af5434bfecd89cab0e4d040a5bf68c8ce47a546
2025-02-07 19:15:37 +00:00
stephan db109887e8 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: 4b073687ee98163faeac6c8626a3bca96331a354a249c6c0990649a459974b3f
2025-02-07 14:47:12 +00:00
stephan 97056a2a21 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: b7c84c04a4eb0575a44edc0abd5ea2bbe4dd07ab6241533fababeca6326f8159
2025-02-07 12:59:03 +00:00
stephan 53d352b5c2 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: de3d2e4caa8a645847a4ceb2c82f2f6ad485e16d8970316335fec041601b588b
2025-02-07 12:36:25 +00:00
stephan aebe9962ab Fix out-of-tree builds of the autoconf bundle, as reported in [forum:a0cd0beb1baa6bef|forum post a0cd0beb1baa6bef]. Bumd version number to 3.49.1.
FossilOrigin-Name: 37dbacde3e18bb1984e301302118a6879006356fafc95882373feacbd5768cb9
2025-02-07 11:18:43 +00:00