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,770 Commits 1,782 Branches 392 Tags
vtab-savepoint
Commit Graph

6182 Commits

Author SHA1 Message Date
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
dan
43a48f7758 Fix uses of C99 and other minor issues in ext/vec1/vec1.c. Report [bugs:/info/2026-10-17T09:17:48Z | 2026-10-17T09:17:48Z]. 
FossilOrigin-Name: 8fd4b73592063f9192f3ea1bd363e0e0659844797b597152831e42e4459ab7ce
 2026-10-17 18:25:47 +00:00
drh
94852686fe Merge recent branch-3.54 fixes into trunk. 
FossilOrigin-Name: c75eff906c11d8f17ae198e5f6cfea34636df2bde0104440fd0b6983ddb2f918
 2026-10-17 12:10:02 +00:00
drh
ea9d6e8419 Fix an incorrect assert() in generate_series(). No impact on non-debug 
builds.
[bugs:/info/2026-10-17T09:24:09Z|Bug 2026-10-17T09:24:09Z]

FossilOrigin-Name: c5d67762df0507fe58e035b572623f36efb394d08d322bbdb313a2f0da49c734
 2026-10-17 12:03:36 +00:00
drh
06a948cadd Enhance ".expert" in the CLI so that when it is generating unique index 
names, the probability of being unable to create a unique names becomes
vanishingly small, essentially zero.  And even if that does happen,
be sure to free the last candidate name before returning an error.
[bugs:/info/2026-10-17T09:25:38Z|Bug 2026-10-17T09:25:38Z]

FossilOrigin-Name: d43611f653bad426df8dc4ac12d0fff1662245b0715f7e66a023bd1dd129faea
 2026-10-17 11:34:38 +00:00
drh
8e1b59b6dc Enhance QRF to deal with zero-length column names. 
Also make use of the new sqlite3_str_free() interface.
[bugs:/info/2026-10-17T09:26:21Z|Bug 2026-10-17T09:26:21Z]

FossilOrigin-Name: d3e004fe3daeb01085e969890beb56fe71839bcad0e7a19e1690a1b2d14b2775
 2026-10-17 11:13:08 +00:00
drh
6444bb328b Fix a harmless C90 compiler warning in the decimal extension. 
FossilOrigin-Name: a7f6aa448f35553952a15608c9b88a03be910304200bcce61e7c38e9a9d9ea0e
 2026-10-16 17:58:38 +00:00
drh
848cad0ec0 Deal with harmless 32-bit integer overflow on parameters to some extension 
SQL functions.
[bugs:/info/2026-10-15T04:34:08Z|Bug 2026-10-15T04:34:08Z]

FossilOrigin-Name: ca52702835d16afd04e936bc4d57f78f0c4d37f83b19b632122f6a699009ca3c
 2026-10-15 21:46:13 +00:00
dan
fff257d3ed Improve the error messages emitted by fts5 in some cases. Report [forum:2026-10-13T21:57:58Z | 2026-10-13T21:57:58Z]. 
FossilOrigin-Name: dabff5c1cde60883f23d41f713f44a5942ae229c3abe280778dc2df41c894907
 2026-10-14 16:11:09 +00:00
drh
cf9555999e Merge all recent branch-3.54 fixes into trunk 
FossilOrigin-Name: 74a6182a0c90d0a035cb23e5237780f0470e0af9d140c52b6f686687f40f8dd3
 2026-10-13 18:36:33 +00:00
dan
cb1bf41aaa Restore 3.53.0 handling of codepoints u+fffe and u+ffff (they are separator characters) in fts3 and fts5. See forum post [forum:/info/9c6ec90d24 | 2026-10-13T08:37:16Z]. 
FossilOrigin-Name: f5ed4850175263ef66fade0d54193dfa96935ae63e2516922b7aae816924726a
 2026-10-13 15:51:29 +00:00
dan
c8922e6f6b Merge fixes to vec1 made on trunk into this branch. 
FossilOrigin-Name: 2ca1a93f01b777276494cf2bd6f7aaa86deeb2d8a43dbcd5dccc3a31318482a3
 2026-10-13 14:59:41 +00:00
drh
5bab74a91b Merge the latest fixes on branch-3.54 into trunk 
FossilOrigin-Name: c57525b36a4a07ef2080824913effef614f545c3d85377376fe04238f7cddf2d
 2026-10-13 11:05:00 +00:00
stephan
5ba0b0a4e0 Merge wasm-post-3.54 into branch-3.54: wasm build updates for emcc changes and an OPFS fix for an as-yet-hypothetical failure case. 
FossilOrigin-Name: c32cf3e355c4656a4415c7f3cf4de4701f9da6aa5f928487e257293b6e78b274
 2026-10-13 06:45:28 +00:00
drh
77b2a47a20 Fix compiler warnings, mostly associated with the new ext/misc/optname.c 
extension.

FossilOrigin-Name: 9d1bc870de51a35d2ecb362a728643d751f33efef2399dccd0d64438e8e48979
 2026-10-12 22:42:19 +00:00
stephan
891eb44d4d Minor hardening of the fossil delta extension against malformed deltas. Based on suggestions from Dan Mestas. 
FossilOrigin-Name: 4528f00d5a189f4cc3a3ecf5b3afa13f103cf438f923e19eb0bbe4c4e369e8ec
 2026-10-12 09:49:25 +00:00
dan
a27bcfe21c Fix a vec1 problem where rounding errors when assigning vectors to centroids could cause delete operations to fail. 
FossilOrigin-Name: aab150f4b39aa8dfa0df9161368b5f3b50859b2657be1bf55d06b67a03005c6b
 2026-10-10 18:06:06 +00:00
drh
4c7729af99 New extension ext/misc/optname.c provides the canonical mapping between 
optimization bitmaps and optimization names.  This gives a single point
of edit when there are changes.  Used by the CLI, by testfixture, and by
TH3.

FossilOrigin-Name: 135ed9e2cc9bd37c3e158a488e37f4ce14ffeca44ff12e31f25a6686a2622ca1
 2026-10-10 17:40:46 +00:00
dan
31e3b6ff45 Update vec1 integrity-check method to tolerate small rounding errors when checking that a vector has been assigned to the correct centroid. 
FossilOrigin-Name: 54e6ae3ae6ac533277def3105162d4578ab4499aec6fbca65000289fbdb9df78
 2026-10-10 16:05:09 +00:00
dan
6e55a61a68 Fix some problems with handling corrupt meta-value arrays in vec1. 
FossilOrigin-Name: fa41e6201609f40ce9d6ec28693e4cd143363a78f072476586f6de7fd90aed66
 2026-10-09 19:12:32 +00:00
dan
ab1268f758 Fix test script errors causing problems on windows. 
FossilOrigin-Name: 379c017e8f999c35e3b3de64fcc3923e45570ba20bee50a3dd00f6996990a033
 2026-10-08 16:17:45 +00:00
drh
82fda1d99a Sanitize "*/" in tables names of the output of the .diskused command 
in the CLI, and in sqlite3_analyzer, so that it doesn't prematurely
close the comment. ANT-2026-XQM1QD48

FossilOrigin-Name: bcde8f991a86aed6280c1b6164bc14cc1aff1a966a694a5fb32341ffa0202960
 2026-10-08 10:55:33 +00:00
dan
aa49b4609a Mark vec1 training function vec1_train() as SQLITE_DIRECTONLY, on the grounds that it sometimes prepares and executes SQL statements based on user-supplied arguments. 
FossilOrigin-Name: 38c5972e914ba8c54b76f6de89501fce576c4a05a7f88f90c39b268203f54582
 2026-10-07 21:12:50 +00:00