mirrors/sqlite
0
0 Fork 0
mirror of https://github.com/sqlite/sqlite.git synced 2026-10-29 02:07:03 +08:00
Code Activity
32,909 Commits 1,786 Branches 392 Tags
master
Commit Graph
10545 Commits
Author SHA1 Message Date
drh 3cf93639e3 Fix the log(B,N) function so that it works for 0.0<B<1.0. 
[bugs:/info/2026-10-26T16:32:25Z|Bug 2026-10-26T16:32:25Z]

FossilOrigin-Name: 994f05ccd131604c5c6296fab93c1bb1e936ce5ef70d1168abf275c3f30a0158
 2026-10-28 00:20:35 +00:00
drh e5796f671a Improve generate_series so that it handles constraints that compare 
the "value" output against a string or blob.
[bugs:/info/2026-10-26T12:55:22Z|Bug 2026-10-26T12:55:22Z]

FossilOrigin-Name: 6b66b52ab29511e0e9d775892bad4eb0b29a5d25289feeaed2eafe004e1e920a
 2026-10-27 18:46:26 +00:00
drh 7721051f69 Fix a problem introduced by [08e979525ff1eef8] and reported by 
[bugs:/forumpost/70e3174f54|a follow-up comment] to the original bug report.

FossilOrigin-Name: 6be81afa66f131d7efe59a24a693e738b0d48f82831ce2e0003dc4e4186fa980
 2026-10-27 18:26:34 +00:00
drh 814fd8ef4d Merge branch-3.54 fixes into trunk 
FossilOrigin-Name: 11932649019188e1d8abd30c61dc88f0d9a425e659461bbb78056c86d4dab12d
 2026-10-27 15:11:21 +00:00
dan fb6bc2334f Disable the "<expr> IN ('const')" to "expr = 'const'" optimization when 'const' has a collation sequence. Bug [bugs:/info/2026-10-26T04:25:22Z | 2026-10-26T04:25:22Z]. 
FossilOrigin-Name: 46da9e0212d2d3f3108b1985ebbabe637970d7329ed8c9c1ccb2bfb18a14acac
 2026-10-27 11:08:15 +00:00
drh aa20b91788 Expire every prepared statement that uses a schema when that schema is 
cleared.  In the VDBE, do not access p4.pTab or p4.pIdx fields if the
prepared statement is expired.

FossilOrigin-Name: 6ca068cdcef197ffe137d77d445b17a9d6b7f25d120acb55fb719b6842aef638
 2026-10-27 10:07:10 +00:00
drh 2cc8623f54 New test cases for schema resets. 
FossilOrigin-Name: b694f96bf89937f8d81fe885b08bc0a9e84ec97d37cb27dda5cbd37719d9e358
 2026-10-26 23:21:29 +00:00
dan 116c504057 Fix test script error causing failures in sessionfault2.test for SQLITE_DEBUG builds. 
FossilOrigin-Name: 5146cf4b3ec0aa8310e65fbc9add563b497733933cf0d8e750d816f358a42161
 2026-10-26 20:05:07 +00:00
drh 0b97f1b101 Test case tweaks to account for different configurations. 
FossilOrigin-Name: 46476df942c3684665e66f9e2cb7e7fa6a1822d1f059969cca91a6b665c4eea0
 2026-10-26 15:18:19 +00:00
drh 77f8caa273 Merge corrections from branch-3.54 into trunk 
FossilOrigin-Name: c2c5f34f0f60d3f8b09976149d633b36754c0f139b41cb30fc27b478dee9fdd5
 2026-10-26 14:43:56 +00:00
drh a74857a26a Fix the ext/recover/recovercorrupt4.test script so that works even 
if cell_size_check is turned on by default.

FossilOrigin-Name: a2b7dcba6bbca6fea1cc6aecb88ef6941c5ea00f0e3e6861d52619632b2b3ee1
 2026-10-26 13:55:24 +00:00
drh d07e02e1ed Test case changes to account for various configurations. 
FossilOrigin-Name: a207774a85f31cdc957857b7b0af161edcfd5e83e4f48ce64e6086fddfb2ebe8
 2026-10-26 13:21:51 +00:00
drh 1820defd76 Merge all recent branch-3.54 fixes into trunk 
FossilOrigin-Name: 4fee54f1d687c2e2b4a760c59d1d29fceb81623494cf65b72c309f4922dc0a7e
 2026-10-25 22:40:37 +00:00
drh f99a038a08 Avoid an integer overflow in the spellfix extension when setting 
a ridiculous values for the top= parameter.

FossilOrigin-Name: 3dfc7fa4c29741f530511ec9e5da4fd1b446cb2310ec00fb5c1b49124cd846d0
 2026-10-25 21:51:58 +00:00
drh e5672e209e Better detection of database corruption in the clearCellOverflow() routine. 
FossilOrigin-Name: b6c072240dfe4f5d075b1b505c98281f830579f48ff939cdb6e054bfb179efa3
 2026-10-25 18:43:18 +00:00
drh d16e78b4fb Fix two instances in test cases where there is an attempt to delete 
a file that is still open, which does not work on windows.

FossilOrigin-Name: c6e22bceae0e2ba57c739d6349f07da2bb27e115131e4d867163e5a8958a78c9
 2026-10-25 18:13:16 +00:00
drh 732a2f0d97 Teach SQLite's internal sqlite3AtoF() routine to understand "Inf" 
and in so doing fix
[bugs:/info/2026-10-22T05:11:21Z|Bug 2026-10-22T05:11:21Z].

FossilOrigin-Name: 8b1fa7497fef8e4bd36dc4614dbb33bc78f34b11300de0caff92a7da0d35a63e
 2026-10-25 15:59:53 +00:00
drh c1ee4b4c88 Fix a bug in the whereOrInsert() routine of the query planner that caused 
a sub-optimal query plan to be selected.
[bugs:/info/2026-10-24T05:24:02Z|Bug 2026-10-24T05:24:02Z]
The speedtest1.c program is updated to include the test case.

FossilOrigin-Name: acda734dc86a46636b9ea274b887f1587b762263cc7d1767cb43124bae4eaa00
 2026-10-25 12:39:29 +00:00
drh fb58600a8f The test case for this bug exercises code paths through the query planner 
and bytecode engine that are not otherwise followed in performance testing,
so it seems reasonable to add the test case to speedtest1.c.

FossilOrigin-Name: eff049863816827f66b63e9e160acff3ca26be600a97aae01ceaadab519072bd
 2026-10-25 12:30:45 +00:00
drh 0a4a0aab8c Pages that fail the cell-size-check should be marked as uninitialized so 
they are not reused without being checked again.
[bugs:/info/2026-10-24T05:20:01Z|Bug 2026-10-24T05:20:01Z]

FossilOrigin-Name: 0f540888bc7c62a44078bd0f1c1f98ed22624608384562e4b8b619382fe15631
 2026-10-24 18:13:36 +00:00
drh 3e6bbeaeca This is the change suggested by 
[bugs:/info/2026-10-24T05:24:02Z|Bug 2026-10-24T05:24:02Z].
But it makes SQLite run slower, at least on the speedtest1.c benchmark.
Need to investigate further.

FossilOrigin-Name: 1d40327bcf2db8ea63d872f4c2f0b9941cb27a4ea63edeee8268b20f0eaffd4e
 2026-10-24 17:25:21 +00:00
drh 30be364a7c Always report back the output flags from the xOpen method of the unix VFS. 
[bugs:/info/2026-10-24T04:49:19Z|Bug 2026-10-24T04:49:19Z]

FossilOrigin-Name: 7bd441063bd8d9681aac38f0951108f9d6b814a3e192a9f7f5ffe4c95103317a
 2026-10-24 17:08:39 +00:00
drh f565c8efc4 Fix various minor problems in the CLI. 
[bugs:/info/2026-10-24T04:43:44Z|Bug 2026-10-24T04:43:44Z]

FossilOrigin-Name: a7fd475c0d34d84232e721c724ccbc07729f594ab20aba9eb0631cf76a09ce23
 2026-10-24 16:49:09 +00:00
drh c6536c6e60 For the "relaxed" quoting mode of QRF, tighten the restrictions on what 
must be quoted to help prevent strings that actually look like numbers
from going unquoted.
[bugs:/info/2026-10-24T04:41:27Z|Bug 2026-10-24T04:41:27Z]

FossilOrigin-Name: 7c8c79a443e025f32035ec91d8c32e032996f1b798444b5b1b5ce98d759f1338
 2026-10-24 15:10:50 +00:00
dan 98fced6200 Change the order of fields in an internal structure to avoid the possibility of leaking heap address information when a corrupt database is queried. 
FossilOrigin-Name: 3f9a0ba4f4dffac7a4b9de30e66d94498a1433d96e327cfff43134b8856f4ba1
 2026-10-24 14:37:18 +00:00
dan 31b1a10a9c Change the order of fields in an internal structure to avoid the possibility of leaking heap address information when a corrupt database is queried. 
FossilOrigin-Name: a5261fd58070d4cb10c627e54491ed7588d96f47073b19612aa669f684e8e5b5
 2026-10-24 14:29:45 +00:00
drh 32d4ecb572 Improvement to testing using the new CLI commands. 
FossilOrigin-Name: 1209b11fda9649891b28add70a6503eeb7b9645c01a76e750703cec0297fb5dd
 2026-10-24 13:57:04 +00:00
drh 0e3a71c327 Further improvements and bug fixes to .if. Add the if.sql test script. 
FossilOrigin-Name: 8d352db18c50870df83af8ffd2fa2858264cebf2f67674fe1356bcef5bc80a2f
 2026-10-24 12:34:08 +00:00
drh 19e832b3b3 Merge WAL race condition fixes from branch-3.54 
FossilOrigin-Name: 6322b44f1389028fb64cdc1a644b45884b111fcc638ced02a981070af2860426
 2026-10-24 00:40:15 +00:00
dan 9a9446f3b0 Fix a race condition with a writer that could cause a connection with a read-only *-shm file to return a spurious SQLITE_READONLY_RECOVERY error. 
FossilOrigin-Name: e2e7c8eb02daea0876fb25abccd96c769f55fba3e995f0e7cf29aa992d7c61a6
 2026-10-23 18:14:43 +00:00
dan 196f6a9389 Fix a race condition with a writer that could cause a connection with a read-only *-shm file to return a spurious SQLITE_READONLY_CANTINIT error. 
FossilOrigin-Name: 30a301835b588f9d57fc04af3140612bef781bdc9b19aa83515d77a24ab06ee0
 2026-10-23 17:24:48 +00:00
drh a4b453a1e6 The .recover command should not remove BOMs that are already inside the 
database.
[bugs:/info/2026-10-18T20:41:57Z|Bug 2026-10-18T20:41:57Z]

FossilOrigin-Name: 69f4d423fa5538a555f862da3a1896e2fa3009dc650286042cb0beabe4dd2114
 2026-10-23 15:52:17 +00:00
drh 0bb1247fca Follow documented behavior when casting a zeroblob() to text on a UTF-16 
database. [bugs:/info/2026-10-23T12:45:59Z|bug 2026-10-23T12:45:59Z]

FossilOrigin-Name: 8a0296aa4db20cdcbbfaa0e4c61b5fe339b0514cf73832253ff0abd1ce59d31c
 2026-10-23 13:06:30 +00:00
drh 0ccc01d3d9 Fix query planner error in the case of a multi-index OR on a WITHOUT ROWID 
table where the OR-term uses the seek-scan optimization.
[bugs:/info/2026-10-23T03:09:01Z|Bug 2026-10-23T03:09:01Z].

FossilOrigin-Name: b33ff35e6246a9dc62205db244511eead28fae90cea686e205effae5e6cc5b49
 2026-10-23 12:14:17 +00:00
drh a9940a8503 Fix a problem in QRF when the screen width is narrower than a column. 
[bugs:/info/2026-10-23T03:50:28Z|Bug 2026-10-23T03:50:28Z]

FossilOrigin-Name: 8de43901c796964bfc7943261fe639874e395ec9415970e4e6a5d1c4868d18a8
 2026-10-23 11:55:02 +00:00
drh 25ba73bc9a Enhance the ieee754(X,Y) function so that it returns 0.0 even if Y very large. 
[bugs:/info/2026-10-23T03:55:14Z|Bug 2026-10-23T03:55:14Z]

FossilOrigin-Name: 7d8cc4d253a4d015a60f89c2b87851dccc53f551272f7f373bd1c65bc55d770d
 2026-10-23 11:09:58 +00:00
drh ac1dd97f22 Ensure that all content that is copied into the -shm file during recovery 
has been initialized, even in the case of no valid WAL frames.

FossilOrigin-Name: f2255af8231d74ce3d949d3d597a25eda6baa3c9ddfd23fa0e8020c213404e6c
 2026-10-23 09:34:42 +00:00
drh 02225da9a9 Ensure that all content that is copied into the -shm file during recovery 
has been initialized, even in the case of no valid WAL frames.
Private email from Mirchev.

FossilOrigin-Name: 64c93bc7e643433ddd79b9dc67e50d3d9fe2228a1234e27e143b06150d556abd
 2026-10-23 09:08:13 +00:00
drh 7c2cb02205 Improve ALTER TABLE DROP CONSTRAINT so that it is better able to deal 
with some corner case in the constraint syntax.
Bugs [bugs:/info/2026-10-22T16:25:18Z|2026-10-22T16:25:18Z] and
[bugs:/info/2026-10-22T16:30:48Z|2026-10-22T16:30:48Z].

FossilOrigin-Name: 14d924c33ff11babef13e68f178c715bb8744a0134ee580715486b601d5738d8
 2026-10-22 19:55:10 +00:00
drh ac429ff804 Index lookup of an integer column using value -9223372036854775808.0 
now works.
[bugs:/info/2026-10-21T17:54:28Z|Bug 2026-10-21T17:54:28Z]

FossilOrigin-Name: 03f699544e6b2040eda17e2f4b48813b10513fc05891a3dd4000867316413103
 2026-10-21 23:49:46 +00:00
drh 99774ca002 Make the NOT INDEXED key phrase work for WITHOUT ROWID tables. 
[bugs:/info/2026-10-21T17:47:47Z|Bug 2026-10-21T17:47:47Z]

FossilOrigin-Name: 9eafe6158d1042f27b867a90f0fb96abf639954efe7944aed6c8b5c9f4373dfa
 2026-10-21 20:53:42 +00:00
drh 671911de56 New CLI-based test cases for foreign keys. 
FossilOrigin-Name: f4f25cd2a8c13a1718a34be8fd36224fba7feab3fa8c44ba85a2aa59d3f1904f
 2026-10-21 16:29:13 +00:00
dan dd8f6a7422 Allow the foreign key code to use child indexes even when there are affinity mismatches between child and parent columns. 
FossilOrigin-Name: ee1424130e37c23c8b4db54252b6badef5bd548bfa8ffd3d88c8f70b4662e5af
 2026-10-21 14:41:53 +00:00
dan 0fa90d6621 Allow composite FKs to use indexes with mismatched affinities as well. 
FossilOrigin-Name: 2e0883964e8d14bd5337a3aaa838b72522ee7a54ea151db5e29cff1f9ee6981e
 2026-10-21 14:37:51 +00:00
drh 77207b3d94 Fix the fsdir() table-valued function to better cope with 
unreasonable LEVEL constraints.
[bugs:/info/2026-10-21T10:49:41Z|Bug 2026-10-21T10:49:41Z]

FossilOrigin-Name: 3e8932ebf2cec334b4867e0192d22b6de8102eda48f9f6e168fe5d2d24a8db0c
 2026-10-21 14:28:22 +00:00
drh 61a8c1579d The IN pre-filter is now only added when the child key can actually use an 
index lookup.

FossilOrigin-Name: a3d46e1f8f02f64c888d26038d83a065bcf56ec5df80d924e3b074152aab18dd
 2026-10-21 12:57:50 +00:00
drh e8eff0e979 An attempt to get the new foreign key code to use indexes on type mismatch 
between parent and child.

FossilOrigin-Name: c0523245e2ba3339d8b21cf26e164d05ec252f3d882eadacd4c510a224ccbdba
 2026-10-21 12:24:59 +00:00
dan 4242856e53 Ensure that all (parent_key = child_key) comparisons performed as part of foreign key processing are done using the affinity of the parent key. Report [bugs:/info/2026-10-20T02:56:10Z | 2026-10-20T02:56:10Z]. 
FossilOrigin-Name: feb6d3a3016d890fb1a8ca2a1752949b8adc0c06debb6ca305cacafc6b6edd10
 2026-10-21 11:52:56 +00:00
drh 5b61b78f12 Cap the number of entires in a ZIP archive processed by the zipfile 
extension at 65535.
[bugs:/info/2026-10-21T10:52:39Z|Bug 2026-10-21T10:52:39Z]

FossilOrigin-Name: decd49e6565bd5105e3b5cbe1067c8992582076a7c4e12cb6f3d089f38aba524
 2026-10-21 11:51:52 +00:00
drh 078f7c4c45 Test cases added 
FossilOrigin-Name: 2ec6c0ff491454f25103f368a5885a6bcd0177fa1eb0bfb2060cd5a6f8c60a72
 2026-10-21 10:27:51 +00:00