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

6204 Commits

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
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
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
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
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
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
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
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
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
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
drh
03c38c992a Merge branch-3.54 fixes into trunk 
FossilOrigin-Name: 8efb0acad85f6220f576c71530256d62f92dfba5673cdc5e0371f480753f1034
 2026-10-20 17:53:47 +00:00
drh
d3d85df39e Enhance the readfile() function in the fileio.c extension so that it 
is able to read from pipes.
[bugs:/info/2026-10-20T14:02:37Z|Enhancement request 2026-10-20T14:02:37Z]

FossilOrigin-Name: 49d185f2ac2d01c6b1bd9c20d13628eff3803529faaf969bace3981f6acc7a28
 2026-10-20 17:46:19 +00:00
drh
e3a9db8c15 Raise an error if a REGEXP pattern ends with "\\". 
[bugs:/info/2026-10-20T13:44:52Z|Bug 2026-10-20T13:44:52Z]

FossilOrigin-Name: 480d6e1a39a2057685260cf8386a3dbef4f391c6d1766a6cded5f8cc4d1a0ec4
 2026-10-20 15:42:45 +00:00
drh
7697c7d2b9 Fix QRF so that it correctly handles zero-length output appended to 
the sqlite3_qrf_spec.pzOutput result.
[bugs:/info/2026-10-20T13:22:11Z|/info/2026-10-20T13:22:11Z]

FossilOrigin-Name: ee344fc063ec0de8f1cd4c61c88eca33c2587c52d868202db3c514f0bc2fae52
 2026-10-20 14:36:09 +00:00
dan
d89373dc10 Fix a problem causing queries on secure-delete fts5 databases to occasionally return extra, non-matching, rows. Report [bugs:/info/2026-10-18T20:40:47Z | 2026-10-18T20:40:47Z]. 
FossilOrigin-Name: 10b8f4166da26908aef9182824b0c967af7d861ff6c83daed7cd50321ee563b3
 2026-10-20 11:13:15 +00:00
drh
1f3e5e763d Merge the latest branch-3.54 fixes into trunk 
FossilOrigin-Name: b3606f7019b2a2dc77d9e476055156631d07c33dfef2d8bc0fdd75b13fad54fd
 2026-10-20 00:17:35 +00:00
drh
a315fb49a2 Fix errors in the decimal_cmp() comparison routine of the decimal extension, 
and the corresponding "decimal" collating sequence, as reported by
[bugs:/info/2026-10-19T06:35:26Z|Bug 2026-10-19T06:35:26Z]

FossilOrigin-Name: bf74b51f7e40dd4fbc7bbeba1539a38a0e19252c60ad87d514a09895b47bb506
 2026-10-19 23:22:16 +00:00
stephan
f6ba5a5abf Correct two bugs, dating back to [96ba44946b|2022-12-23], which caused the JS wrappers of sqlite3_bind_text/blob() to severely misbehave. Add missing tests. [bugs:bbb715c3f2a0e989|Bug report 2026-10-19T19:03:55Z]. 
FossilOrigin-Name: d45943cbaf35f21f72b78aafa88f72830343bfeb3a0198a3af0da063dcf6a707
 2026-10-19 21:07:18 +00:00
dan
6410c0e4a9 Avoid dropping error codes from the streaming input callback in sqlite3rebaser_rebase_strm(). Report [bugs:/info/2026-10-18T05:31:08Z | 2026-10-18T05:31:08Z]. 
FossilOrigin-Name: 90f953b42a7c9c4939b215fa9e1fe11cf381978d3ee7737d390ae14611cccbcf
 2026-10-19 20:21:23 +00:00
drh
154360f1cd Fix a regression in the CLI's handling of control characters in CSV output, 
caused by [d0fe92e0ce8662b9].
[bugs:/info/2026-10-18T20:38:57Z|Bug 2026-10-18T20:38:57Z].

FossilOrigin-Name: 2146eab561d153b70eb41c54bb122ea8d2dc0ad983f00639aa2f65fd3a64e603
 2026-10-19 19:15:13 +00:00
dan
6a63c4070b Fix a problem in the sessions rebaser occuring when a DELETE/REPLACE rebase record is followed by another rebase record on the same row. Report [bugs:/info/2026-10-18T05:00:41Z | 2026-10-18T05:00:41Z]. 
FossilOrigin-Name: c2d299124211d8780bc0beab8217fc53da8aadca0c3abce0fedbe84506ef412a
 2026-10-19 18:57:35 +00:00
stephan
c01201027e Wasm build: move wasm-strip to after wasm-opt, at recommendation from an Emscripten ticket. Remove several more uses of -sWASM_BIGINT=1, as described for [cc9457981e2a]. 
FossilOrigin-Name: c2fc091401aa8c75db5f0c98486d9ee1e54fb6c96ec2dc04eecca41aa26990a1
 2026-10-19 18:33:02 +00:00
drh
ea1e2759a1 Merge the latest branch-3.54 fixes onto trunk 
FossilOrigin-Name: 79ba7ba1a75c998c68dd2cc60de7fbe133a563e803a536efea94eff657603965
 2026-10-19 18:26:06 +00:00
stephan
16327cc106 JS: resolve a [https://github.com/emscripten-core/emscripten/issues/28016|build regression] triggered by Emscripten 6.0.5+. Remove the -sWASM_BIGINT flag from the build because (A) it's been Emscripten's default for a long time and (B) Emscripten now warns loudly if it's used. Remove a stray build flag from fiddle, inadvertently introduced in [c32cf3e355], which caused it to build in 64-bit mode. 
FossilOrigin-Name: cc9457981e2a63d271525b1d891a63dd28b1c2da04777228e27132d7cc743cfa
 2026-10-19 18:05:25 +00:00
dan
18a23191bf Avoid crashing if an RBU vacuum is attempted with a VFS that does not support RBU. Report [bugs:/info/2026-10-19T12:21:34Z | 2026-10-19T12:21:34Z]. 
FossilOrigin-Name: 5024b528dcf419393086d89eff50aa1b52116bb05b6e07849555f76891bc68a0
 2026-10-19 17:44:46 +00:00
stephan
55b6ae8606 Apply [5080eb6d7a7a] to a similar case in the JS test suite. 
FossilOrigin-Name: 336154a23a2a98df12a2a5e6ef51221acccef4063936cbb48cbb77a24cf1bd26
 2026-10-19 15:06:38 +00:00
stephan
d37e0daad3 JS: reject URL arguments which may influence the load path for sqlite3.js and sqlite3.wasm if those values look like they might be remote URLs. sqlite3.mjs (ESM) is unaffected by this. This addresses [bugs:74f052d3d2|bug report 2026-10-19T12:25:33Z] but is a preliminary measure, with follow-ups expected. 
FossilOrigin-Name: 5080eb6d7a7a7a5c2cdfd08a766f0e096d0d5536488fcf0b325e7b06a6bdd092
 2026-10-19 14:50:22 +00:00
drh
853288469d The default floating point format for JSON and INSERT output modes 
should be "%!0.17" to preserve full binary→text→binary round-trips
with no loss of precision.
[bugs:/info/2026-10-18T20:37:23Z|Bug 2026-10-18T20:37:23Z].

FossilOrigin-Name: c31221e954bcca2e6505338446635d0efb809f453008c4927441ebd6f0e1b873
 2026-10-19 14:34:34 +00:00
dan
b7defd99b3 Fix a vec1 problem with querying a table within the same transaction as writing it in some configurations. 
FossilOrigin-Name: e2af533c281989c751fa4a15e8a5ebafa9cad5efadfd37a2407c89e397b3ddf2
 2026-10-19 11:06:06 +00:00
dan
cc758d2fba Fix a vec1 problem with issuing a 'rebuild' command within a transaction that has already written to the table. Report [bugs:/info/2026-10-18T20:40:18Z | 2026-10-18T20:40:18Z]. 
FossilOrigin-Name: 2448fc46cae2149c5d1777b9fe574a48e21d5e16dd64997d2343bb6e160840e3
 2026-10-19 08:05:27 +00:00
dan
948ad6e798 Fix a vec1 problem with deleting rows that share rowids with tombstone values within transactions. Report [bugs:/info/2026-10-18T20:41:06Z | 2026-10-18T20:41:06Z]. 
FossilOrigin-Name: b8fc7a1398c7aaf2359c311d46a55aeea213d60889826119d1ddef2364387ea0
 2026-10-19 05:43:09 +00:00
drh
623bc0b1d5 Fix harmless compiler warnings. 
FossilOrigin-Name: a68c9f3e98a7be2e7ac020fcbdf3b39cd9015e1d2fa07d30619c47a05cf7aab4
 2026-10-18 21:36:55 +00:00
drh
4e512bf10d Fix the decimal extension to correctly deal with NULL parameters. 
[bugs:/info/2026-10-18T14:25:03Z|Bug 2026-10-18T14:25:03Z]

FossilOrigin-Name: 716b63c934156d8b19bda24c5bb544cc3d7d0ef66228150eea0a166d6e8c9caa
 2026-10-18 19:42:52 +00:00
drh
d7e0a4717a Merge recent branch-3.54 fixes into trunk 
FossilOrigin-Name: f9e0ce3382e4787468bdb4029105fbffb2d4ab92b51c655ae762b555d8570efb
 2026-10-18 16:31:01 +00:00
dan
3baca233c5 Ensure that vec1 normalizes vectors before, not after, applying the WHT transform. Report [bugs:/info/2026-10-18T10:46:11Z | 2026-10-18T10:46:11Z]. 
FossilOrigin-Name: b5a53fbedeb127393b2096073ebccfe71136705851598a3d9e4c2b632c10001c
 2026-10-18 13:54:43 +00:00
stephan
352e01f2fc Correct a var name typo in the session extension. [forum:527f85c78d|Bug report 2026-10-18T10:40:12Z]. 
FossilOrigin-Name: 9826ef1c52fcae73dd0550982e9eda27a4ca43460ded890f9873c61d5d8020d3
 2026-10-18 10:43:06 +00:00
stephan
c8e019ec97 Minor doc-only updates to ext/wasm/README.md and GNUmakefile. 
FossilOrigin-Name: 7f6793fe94636e83b851919878d52201002dd9d28ac33f9e9c90d4f7cb1feacf
 2026-10-18 10:39:36 +00:00