aboutsummaryrefslogtreecommitdiff
path: root/src
Commit message (Collapse)AuthorAge
...
* Fix the concat_ws() SQL function so that it includes empty strings in thedrh2025-06-11
| | | | | concatenation. [forum:/forumpost/52503ac21d|Forum post 52503ac21d]. FossilOrigin-Name: 80a78987da484d435a8242c05c48d546d430920df713b24a9d9d9fff7ba1113d
* Improved selection of the divisor when subdividing nested Bitvec objects.drh2025-06-10
| | | | | | This fixes a potential stack overflow that can occur when the database size is within 60 pages of the maximum allowed by the file format. FossilOrigin-Name: f7ab764ed9df6d7a4a96cb0933d291f00174f33fed3d9951785078fe225adcb7
* Minor corrections to the new Bitvec testing logic.drh2025-06-10
| | | FossilOrigin-Name: 77b79ca1277419b91589aff2c601d4abdd7107d48019a58f7f7c85d96c2a538e
* Enhancements to sqlite3BitvecBuiltinTest() that allow testing code todrh2025-06-10
| | | | | create very large Bitvec objects that do not use the linear array cross-check. FossilOrigin-Name: c5680672cae23f65637eebf66f3bb983a2864be03ea70378832034f3c89ef728
* Improved diagnostics for Bitvec: Add the sqlite3ShowBitvec() routine thatdrh2025-06-10
| | | | | | can be called from a debugger (only available with SQLITE_DEBUG). Add new output opcodes for sqlite3BitvecBuiltinTest(). FossilOrigin-Name: dea1e37fa67ada6efc1533b449d9eb22338d9e58eec8f89b48c38319c212c8f4
* Remove unnecessary whitespace and otherwise improve comments in thedrh2025-06-06
| | | | | wherecode.c module. No coding changes. FossilOrigin-Name: 2eb4e9bf0f2df50324a62fb272a92bbd931b8b4e4b35bac0c05b676c97b61339
* Remove the clunky test_windirent.h and test_windirent.c files from src/drh2025-06-05
| | | | | and replace them with a much cleaner and more compact ext/misc/windirent.h. FossilOrigin-Name: acc978df52ec41ffdb5c27764f30d53efa1f25a314b7d98983dc0d211a36b570
* Fix harmless compiler warning introduced by the setlk-snapshot-fix merge.drh2025-06-03
| | | FossilOrigin-Name: c1f20f89d9eb3e1dd1018c0e0efe5d3043a592f078e235ad04b960334c7186c2
* Fix JSONB edit so that when it is trying to reduce the size of an elementdrh2025-06-02
| | | | | it understands 0xf0 (8-byte) sizes. FossilOrigin-Name: 5b3de6e8ab6b228bf6c0e0c31b50ca29d8b7852b460eaaca6c6ecf5a3c083cab
* Fixes to ensure SQLITE_ENABLE_SETLK_TIMEOUT builds use a blocking lock and ↵dan2025-06-02
|\ | | | | | | | | do not call xSleep() when (a) opening a snapshot transaction, and (b) when blocked by another process running recovery. FossilOrigin-Name: 7f9c0cdd0630a41db359b188b226a1ad6a3bae1663c27169acfe25edc7fb171b
| * Fix os_win.c so that SQLITE_ENABLE_SETLK_TIMEOUT=2 builds work on windows.dan2025-06-02
| | | | | | FossilOrigin-Name: 8efb95e0d4670b9c5dbd8cf34512334f47951a8dff8fdadc8645f75076acd91f
| * Merge trunk changes into this branch.dan2025-06-02
| |\ | | | | | | FossilOrigin-Name: 7d27451804e525190f8e67da75aaeb3bf2de677021f7566c6681398e60a88c72
| * | Fix assert() statements in os_unix.c and os_win.c. Allow ↵dan2025-05-31
| | | | | | | | | | | | | | | walsetlk_recover.test to run in non-SQLITE_ENABLE_SNAPSHOT builds. FossilOrigin-Name: 9f521ecda2b8d2f383cc84e308b3a4adfcf1bd6339eb834c8fa76c8704c861b7
| * | If blocking locks are enabled, avoid using the busy handler when blocked by ↵dan2025-05-30
| | | | | | | | | | | | | | | another process running recovery. FossilOrigin-Name: a35236757ab57c4c9b34e47c5dbc10d8f1220f8152955f5303cf9c3902ee169b
| * | Avoid invoking the busy-handler if a blocking lock times out while ↵dan2025-05-30
| | | | | | | | | | | | | | | attempting to open a snapshot transaction. FossilOrigin-Name: fe11f85fd3283bb7002f43bd8b796e9e7b67f6d1a92eb676be06b46d1458fc1d
* | | Improve the accuracy of affinity and collating sequence analysis fordrh2025-06-02
| |/ |/| | | | | | | | | | | NATURAL JOINs to the left of RIGHT JOINs where source tables are views or subqueries. Initial problem report in [forum:/forumpost/829306db47|forum post 829306db47]. FossilOrigin-Name: f184d1d236e47962658a4639d9533f67a525b74cfe0f06c93e9b85fdcd02a15f
* | Remove an unnecessary parameter from sqlite3VdbeRecordUnpack(). Improveddrh2025-06-02
| | | | | | | | | | comments and assert()s on KeyInfo. FossilOrigin-Name: 387f4c4d98b8fb83f6ae406e4143dabda7766e8752b7f6ca104655e51330c978
* | Fix stale comments related to KeyInfo. Add new assert()s associated withdrh2025-06-02
| | | | | | | | | | memory management of KeyInfo. FossilOrigin-Name: abd805bc76f14ede7359b029908179b7ca57e929c5918acae1403ef73ae0bd47
* | Fix an off-by-one error in the size computation of a vdbe-sorter.drh2025-06-01
| | | | | | | | | | | | [forum:/forumpost/c1cc8b057a|Forum post c1cc8b057a]. Problem introduced by checkin [d4307a0d43f42e96]. FossilOrigin-Name: 8b7a7fcf62e5c2742c243808fa482472954f2b4aae0bc7ae513bc07065c93737
* | Fix VACUUM so that it works even when ATTACH_WRITE is disabled.drh2025-06-01
| | | | | | FossilOrigin-Name: 42494f85acb303919d3f1f2202f8b95fbd657652da4b8dc00451c10ea6c496e0
* | Enhance "box" and "column" mode formatting in the CLI to better deal withdrh2025-05-31
| | | | | | | | | | double-wide characters. FossilOrigin-Name: b0de22ed0abf2ea5d269f191c884d7b2be167a2ed27018c25aaa0ea238cd621a
* | Fix an affinity problem caused by a USING or NATURAL JOIN on the LHS of a ↵dan2025-05-31
| | | | | | | | | | FULL JOIN. [forum:/forumpost/5028c785b6|Forum post 5028c785b6]. FossilOrigin-Name: 8d393ca07fe09f48d77adb517e2e4baaa58a9251422de62a0504999205d3ea1d
* | Relax query flattener constraint (3b) and thereby allow flattening the RHS ofdrh2025-05-31
| | | | | | | | | | | | | | | | a LEFT JOIN even if the RHS contains a virtual table. This was previously disallowed by [9dbae1df75219e2a] as a performance optimization. It turns out that the constraint causes performance issues, and we do not have a record of any performance issue that it solves. FossilOrigin-Name: 1ddaa92057e550ea281d45d9860eafe69399224725548a93dd91c47a34e52152
* | tcl extension: UDFs may now 'break' to return an SQL NULL. Add the (eval ↵stephan2025-05-31
| | | | | | | | | | -asdict) flag to use a dict, instead of an array, for the eval row data. FossilOrigin-Name: 413a626b5c7902c1810142536c36e4ea8ee7c616ea82dfe1114199f9319091f7
* | Add some missing UNUSED_PARAMETER() annotations to squelch downstream build ↵stephan2025-05-31
| | | | | | | | | | warnings when using -Wextra -pedantic. FossilOrigin-Name: a98a2f49355ec39c56e571c70d377675b1bd99a6d43cf9217b0eb1e081895d8e
* | Follow-up to the previous: The same optimization suppression needs todrh2025-05-30
| | | | | | | | | | happen if the left-hand side is coming from a LEFT JOIN. FossilOrigin-Name: cf5b37b3a39013d8ca9de92da2289346caf52b56daff59e19b140cc586a3421f
* | When synthesizing an ON constraint from a USING or NATURAL, if the left-handdrh2025-05-30
|/ | | | | | | | side is coming from a RIGHT JOIN, be sure to set the EP_CanBeNull flag so that the optimizer knows to check for NULL even if the column has a NOT NULL constraint. Fix for the problem reported by [forum:/forumpost/4fc70203b61c7e12|forum post 4fc70203b61] FossilOrigin-Name: 60adc78a22956429d34ccc4e2c193c5994c11c3b3cff7901d47fad7d92dba935
* Use a more robust backup definition for offsetof().drh2025-05-30
| | | FossilOrigin-Name: 22441955e03df07903b98832a60c05c53721cd67c667f6c83d5e97fcc62735ee
* Extend the fix for ticket [623eff57e76d45f6] so that it covers RIGHT JOINdrh2025-05-29
| | | | | | in addition to LEFT JOIN. Problem reported by [forum:/forumpost/7dee41d32506c4ae|forum post 2025-05-29T15:10:14Z]. FossilOrigin-Name: 29b1e1b97619d03a97ef562a5707929e241d019179b4ff1d0bc2a8c008441431
* Do not use a partial index if the truth of the WHERE clause does not dependdrh2025-05-28
| | | | | on at least one column from the table being indexed. FossilOrigin-Name: cbe2a392e45d40778570656d2ef2db43e58ad6453bd9d4b936fecfd963e22736
* tclsqlite.c doc typo fix.stephan2025-05-26
| | | FossilOrigin-Name: de0dfac1e5ca9d2661674c20664095386f60c77378311507fcba08111df52b38
* Change json_group_object() so that it ignores entries where the labeldrh2025-05-24
| | | | | is NULL. [forum:/forumpost/e5bd251fb5|Forum post e5bd251fb5]. FossilOrigin-Name: 28215d131cd970a2756338579fb6b6091ab155be8f419505cae8ac918956165c
* Clarify some malloc size computations to simplify the proof that theydrh2025-05-19
| | | | | are safe. Remove some code associated with cygwin that is marked "#if 0". FossilOrigin-Name: ba8184d132a935aa1980fbfb61ff308b93d433d559db4968f9014f7653ac9c6e
* Make the new sqlite3_setlk_timeout() interface accessible to loadabledrh2025-05-19
| | | | | extensions. FossilOrigin-Name: 8819b7285b71932327f47d29fa575cfb338e2fccd3f7c2023faf0575bfdb0079
* Remove stray tab characters from source files.drh2025-05-19
| | | FossilOrigin-Name: 298ff5a1dc5dbccaf6acd91731044f478a5ce522745332801708ceee996b01e6
* Fix a harmless comment typodrh2025-05-19
| | | FossilOrigin-Name: c4d25acec3c1e28e5a4664a74c263cc0d00e118a6db4b26b51cb0d42d0f2b26f
* Improved version of the previous check-in.drh2025-05-16
| | | FossilOrigin-Name: 036c97e36cb36a2ac765a8e8539433dcb63f69155d4c24857f84faa44eed6eb5
* Fix the optimization of check-in [663f5dd32d9db832] that strives to avoiddrh2025-05-16
| | | | | | | duplicate compuations in the GROUP BY clause so that it works even if the GROUP BY term is a subquery on the RHS of a LEFT JOIN. Problem found by dbsqlfuzz. Test cases in TH3. FossilOrigin-Name: 955a026996b93e530ca5b566689cc646b31d3b9b5a5837897a58452d70f6d942
* Rework the showHelp() function in the CLI implementation so that itsdrh2025-05-15
| | | | | | purpose and operation are well described by the header commit. Omit the use of enums that cause issues for MSVC 2025. FossilOrigin-Name: 336ceeccc6f85bd78f4a26648af7edf9056d569a767b4120f125a02b2090a349
* Back out the "low-quality index" query planner hack of check-indrh2025-05-14
| | | | | | | | [bcac937526d9a6ef]. Subsequent query planner enhancements for dealing with star-queries make that change unnecessary and the change was recently found to cause a performance regression in an unrelated query. Also fix a typo in a debugging message. FossilOrigin-Name: e7dcf25efae364b7cdf9eb8265803c816c8b8557e4a7684da428badc6ffb3875
* First cut at enhancing the fsdir virtual table so that it works withdrh2025-05-13
| | | | | unicode characters on Windows. FossilOrigin-Name: c9e04dadfdf6c860631ce5603693add565ff2033aa25af5736302af7045fc91e
* Omit the unused readdir_r() routine from test_windirent.cdrh2025-05-13
| | | FossilOrigin-Name: f9a216e3ad1b3bc9be350aad5ef3dc8b3534d3ee67d160bfedda81a61295320c
* Provide the SQLITE_BUG_COMPATIBLE_20250510 compile-time option that restoresdrh2025-05-10
| | | | | | the JSON5 bug fixed in the previous check-in, in case some applications need it for legacy compatibility. FossilOrigin-Name: 491cf31904fdbc9567b838d1ba27901e75f8ea3a117043017d08354bb09f9711
* Add enforcement of the obscure JSON5 syntax rule that the \0 escapedrh2025-05-10
| | | | | | sequence must not be followed by a digit. [forum:/forumpost/c061e87faf7d1c55|Forum post c061e87faf]. FossilOrigin-Name: 83c7477f2b9b0d6cb54cf6b14bf3c8ef4807e4bddc7986d275cf6717da8606b7
* Fix PRAGMA trusted_schema=OFF and similar so that it restricts the kindsdrh2025-05-08
| | | | | | | | | of functions in CHECK constraints that the documentation says it does. It was letting through some function that it ought not have. This is a defect in [5720924cb07766cd]. See [forum:/forumpost/3fa9d44c0b381342|forum thread 2025-05-08T08:50Z]. Additional test cases will be added separately. FossilOrigin-Name: 25920beebf71ebc9a1bb9f56932280c9e03390f26fe9da2258f950979b238ce6
* Internal doc typo fix. No code changes.stephan2025-05-08
| | | FossilOrigin-Name: ac2aa39f7e3ae7ac921fac6566186939a1282f80ced5b3e3d5006a77ecf583ff
* Fix a harmless warning about and oversize shift operation on malformed JSONBdrh2025-05-07
| | | | | inputs. [https://issues.oss-fuzz.com/issues/415850463|OSSFuzz 415850463]. FossilOrigin-Name: cf8b55b3b6f0b73158e21731a206d5a8d8d9892989d91171a11c6dbbee34b338
* Fix a bug in the NOT NULL/IS NULL optimization of check-in [cb94350185f555c3]drh2025-05-06
| | | | | | | | | 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. Problem discovered by the [https://issues.chromium.org/issues/415397143|Chromium fuzzer]. Never seen in the wild, as far as anybody knows. FossilOrigin-Name: 2adaee9aa90f280a406007695fbc4a314806584c93d6b62b46c031492b31ec27
* Fix the sqlite3VdbeTypeofColumn() function so that it works correctlydrh2025-05-06
| | | | | even when SQLITE_DEBUG is defined. FossilOrigin-Name: 1d5021533ed688d7a815ce75b338c72f577c14554027f88a21419935a9e68239
* Fix a harmless problem in the CLI in which SQL errors that occur duringdrh2025-04-30
| | | | | | the ".schema" command are properly ignored, yes still appear in the ".log" output. [forum:/forumpost/42fe6520b803be51|Forum post 42fe6520b8] FossilOrigin-Name: 20abf1ec107f942e4527901685d61283c9c2fe7bcefad63dbf5c6cbf050da849