database/sqlite
1
0
Fork 0
mirror of https://github.com/sqlite/sqlite.git synced 2026-10-23 21:49:02 +03:00
Code Activity
32,815 Commits 1,782 Branches 392 Tags
bom-handling
Commit Graph

32815 Commits

This Branch
This Branch
All Branches
Author SHA1 Message Date
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
5285494b18 Fix the sqlite3_bind_value() interface so that it does not remove a 
byte-order mark on the value being bound.

FossilOrigin-Name: 56e268312d038608b5fb2a8ed24002f478ad5a22eb0214b1a064f2926aada66c
 2026-10-23 15:30:27 +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
47f34d87e3 Merge the FTS5 fix from branch-3.54 
FossilOrigin-Name: 320cb1f51382868ed576d8fa52c75672a2c3e4cee99f868385645bd9a370457a
 2026-10-23 12:51:22 +00:00
drh
881f4fd025 Fix a UAF in FTS5 on a query that uses a prefix query and a ordinary term 
inside of a transaction.
[bugs:/info/2026-10-23T03:10:17Z|Bug 2026-10-23T03:10:17Z].

FossilOrigin-Name: 599f3345b99b79e11a71bd0087555d0980f2af5cffb6b78683a5027e78f67831
 2026-10-23 12:23:36 +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
7ab0f7308f Enhancements to the geopoly extension to catch some invalid polygons that 
it was letting through.
[bugs:/info/2026-10-23T03:54:22Z|Bug 2026-10-23T03:54:22Z]

FossilOrigin-Name: a327ab93a4758f9bb420e9ae1dd955ce102d28b89a9b1294414266a5f583b282
 2026-10-23 11:15:34 +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
38fff5fe3e Cap the sleep time for sqlite3_sleep() at 2147483 milliseconds to avoid 
overflowing the microsecond-resolution parameter to the xSleep method
of the VFS.  Test cases in TH3.
[bugs:/info/2026-10-23T04:02:08Z|Bug 2026-10-23T04:02:08Z].

FossilOrigin-Name: 58efac83960f8f69291602f6c407cd6bbcb8aa2c29335637b43bda3a987284d7
 2026-10-23 10:57:51 +00:00
drh
ba44f903b8 Merge the latest branch-3.54 fixes into trunk 
FossilOrigin-Name: 47da4393af3a6c9c4efe7457db075dc1b927fc917016e5eadfa0a4e10adcedc2
 2026-10-23 10:39:05 +00:00
drh
878113ff3b In FTS5, fix a potential read past the string terminator while parsing 
a malformed RANK input.  Private email from Mirchev.

FossilOrigin-Name: d7e1c85c176083d78b60b3098a863754160edada5b0cb924b3468650713c1075
 2026-10-23 09:48:13 +00:00
drh
a0599e8b60 Fix a heap-buffer overread in FTS5 due to a corrupt inverted index holding 
an empty doclist.  Private email from Mirchev.

FossilOrigin-Name: d0716cc48bd182436ae017ffc25b8889854cb82f8209b82f8d0af6cda6dedd56
 2026-10-23 09:38:43 +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
20822819ad Fix two minor issues with the geopoly extension. 
Bugs [bugs:/info/2026-10-21T02:53:43Z]
and [bugs:/info/2026-10-21T05:30:42Z].

FossilOrigin-Name: d6f1df8c0bbc2c04d9cdbbf33ff6ff9ba35d80f6e33ddab688827e7e2fe568d5
 2026-10-23 00:49:30 +00:00
drh
31ebfdf4a1 Performance improvements in PRAGMA integrity_check and in materialized CTEs. 
FossilOrigin-Name: 52d0c0b3d18b032e2d2c006a5d60df4c65da3b95200eaaffddb0ede9ed63f29f
 2026-10-22 20:03:37 +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
jeffchen
138f51ac68 Remove unused per-index counters from integrity checking. 
FossilOrigin-Name: d0b5bc53a9d828c425ea29bc418688aa7df20e8cc4b69b81acb0ac1a7c169b6a
 2026-10-22 14:03:32 +00:00
jeffchen
fd8be0ca94 Avoid repeated setup when reusing a materialized CTE. 
FossilOrigin-Name: 18bec552a0da979f32f7a5a024691ab2bbb09454c75a7e99a125a5bd7545584f
 2026-10-22 14:03:19 +00:00
drh
bc766d966a Merge branch-3.54 fixes into trunk 
FossilOrigin-Name: fdf339d965aba5e35feaf3ef613e2e2ce0795338591f261998141a6d080bb0da
 2026-10-22 11:41:16 +00:00
drh
03c3a3edd2 Make the session rebaser more robust the face of column count mismatches. 
FossilOrigin-Name: 12285a3f4efdf41210fa3020127670b0d1fd8d740a5ac43db0c6641fec3e5142
 2026-10-22 11:35:33 +00:00
drh
007df2b477 Add a rootpage number lower bounds check in the "recover" extension. 
Test case in TH3.

FossilOrigin-Name: 4a1fd244b5ca93c6cfe1e0f8e1d087d5b99482081e4b760d09909959c258e506
 2026-10-22 11:19:52 +00:00
drh
de805a8c12 Increased safety margin in sqlite3_preupdate_old(). Test case in TH3. 
FossilOrigin-Name: 31b84157965fcd3309a1420db71e0beee4ccdd88a2f44e5f9029a05cb04ae9cf
 2026-10-22 11:03:08 +00:00
drh
7f91834658 Extra safety margin added to sqlite3VdbeMemFromBtree(). Change 
suggested by Martin Mirchev.  Test cases in TH3.

FossilOrigin-Name: 952ae2c63e0a2007d8213132636e2e99bae113a9c7582b68b2e5a686b0777a99
 2026-10-22 10:40:42 +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
0168a3f32b Mark the AND optimization as "not-a-real-0-or-1" so as not to confuse 
ORDER BY and GROUP BY clauses.
[bugs:/info/2026-10-21T15:33:18Z|Bug 2026-10-21T15:33:18Z]

FossilOrigin-Name: 16cf625360a1448741dafa3d67263b5dda112648a05a0df6a766fae95b529f45
 2026-10-21 17:36:54 +00:00
dan
4f6dc901fe Do not synthesize position-lists for UNINDEXED fts5 columns in detail=none mode. Report [bugs:/info/2026-10-20T20:40:52Z | 2026-10-20T20:40:52Z]. 
FossilOrigin-Name: 64e37575ca1531ebea52402e6fa9ee1de399f1767f5baedc12ffde03a995b477
 2026-10-21 17:23:01 +00:00
dan
4259cf5264 Avoid orphaning an fts5 %_content table when dropping or renaming an fts5 table that uses contentless_unindexed=1. Report [bugs:/info/2026-10-21T02:51:01Z | 2026-10-21T02:51:01Z]. 
FossilOrigin-Name: fa0247a431bd99a9442c61028dc85ad1ffd2c5ea5b76ab68c394eaeda9af9409
 2026-10-21 16:56:58 +00:00
dan
0b73214725 Improve usage of fts5 doclist-indexes in tokendata=1 tables. 
FossilOrigin-Name: 3e4c42ea20573a02fde30c25f0b11d0d0cace6f4a65849ca817d238d5315a8ee
 2026-10-21 16:48:04 +00:00
drh
671911de56 New CLI-based test cases for foreign keys. 
FossilOrigin-Name: f4f25cd2a8c13a1718a34be8fd36224fba7feab3fa8c44ba85a2aa59d3f1904f
 2026-10-21 16:29:13 +00:00
dan
d08513bcbc When querying an fts5 table in tokendata mode, avoid using the "has-doclist" flag from the previous leaf page when querying for a non-existent term larger than all terms on that page. Report [bugs:/info/2026-10-21T02:52:01Z | 2026-10-21T02:52:01Z]. 
FossilOrigin-Name: 3769f60be38ba67efce022d4cb72a1db89b36641b2f132698d4d85b0f6b30775
 2026-10-21 16:05:34 +00:00
dan
0269dadc3d Avoid returning extra rows when the RHS of a "rowid = " constraint on an fts5 table is not an integer value. Report [bugs:/info/2026-10-20T20:31:49Z | 2026-10-20T20:31:49Z]. 
FossilOrigin-Name: 5a09fc807377b4cfa37b06d69101530611df143bd64f3384db480797d8795fea
 2026-10-21 15:25:33 +00:00
drh
f1196b59b4 Improve RTREE to be more robust against abuses of the "rowid" column. 
[bugs:/info/2026-10-21T05:31:28Z|Bug 2026-10-21T05:31:28Z]

FossilOrigin-Name: 8d5a59d56e2ed1355033966c99455d4e4cad5aec13db536a938b4b2fccfba058
 2026-10-21 15:15:32 +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
1113952d2a Allow the origin counter in FTS5 to grow beyond 32 bits. 
[bugs:/info/2026-10-21T10:56:15Z|Bug 2026-10-21T10:56:15Z]

FossilOrigin-Name: a0fed3f26e969ae47834ab9f34deaee42c6b51da3151af836ca5b299ed79a5f3
 2026-10-21 14:35:08 +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
23b355fb6e If a reprepare fails in sqlite3_stmt_explain(), do not leave the prepared 
statement in an invalid state.
[Bugs:/info/2026-10-21T09:18:32Z|Bug 2026-10-21T09:18:32Z].
Test cases in TH3.

FossilOrigin-Name: 0ffda38c5f7f506cd14c9aedc756f2fc025fe49f0822a4ecf28451a4d2b840e0
 2026-10-21 11:25:55 +00:00
drh
b6b600ac29 Improvements to vtab handling of SAVEPOINT. 
FossilOrigin-Name: 1d886c6abf1ed0be934d93cd7fe8d200b626a40b534e493ac15370819211bc72
 2026-10-21 10:31:35 +00:00
drh
078f7c4c45 Test cases added 
FossilOrigin-Name: 2ec6c0ff491454f25103f368a5885a6bcd0177fa1eb0bfb2060cd5a6f8c60a72
 2026-10-21 10:27:51 +00:00
drh
049891534d If a virtual table is created within a SAVEPOINT, it needs to be undo by 
the corresponding ROLLBACK TO.  This resolves an issue going back to
before version 3.7.8 circa 2011.
[bugs:/info/2026-10-20T20:37:14Z|Bug 2026-10-20T20:37:14Z]

FossilOrigin-Name: 33aeb419d594cd131124cd228dbbb4da246a531edea40009d95d6b2b376bd76b
 2026-10-21 00:34:39 +00:00
drh
3e97799009 Change the sqlite3_serialize() interface to return a NULL pointer if 
the database is file-based and an I/O error occurs while reading.
[bugs:/info/2026-10-18T10:04:32Z|Enhancement request 2026-10-18T10:04:32Z].

FossilOrigin-Name: aa36cfe5b0f944752ace7986b2bff5dcb597fc0d456da781ed5b55e47ecb3d3c
 2026-10-20 20:17:15 +00:00
drh
99f724be20 Simplify the ".clone" command so that it just makes a copy of the main 
database.  Move the implementation into a separate dotCmdClone() function
and provide better help text explaining its history.

FossilOrigin-Name: 8b5c87a5f4dc6dccf2130d41df958ea59f0892836b574388539ee7d905cd014d
 2026-10-20 19:30:24 +00:00
drh
255534dc97 Fix the shellB.test module so that it does not try to run dump.sql 
without virtual tables available.

FossilOrigin-Name: 3f8b4c7760148eabbf721ff9b8321793972d372fa3156dc8c60ed680f5467d0c
 2026-10-20 19:21:43 +00:00