database/sqlite
1
0
Fork 0
mirror of https://github.com/sqlite/sqlite.git synced 2025-09-11 08:30:57 +03:00
Code Activity
26,093 Commits 1,582 Branches 184 Tags
branch-3.42
Commit Graph

26093 Commits

This Branch
This Branch
All Branches
Author SHA1 Message Date
drh
bfe2964c5d Version 3.42.1 
FossilOrigin-Name: 4a8bf3c146c24759709eec55cdb0a9d2153c3a40e6645727c55c0404a99b5b4a
version-3.42.1 		2025-08-06 11:05:53 +00:00
drh
bb0afc2818 Fix the same potential integer overflow problem of [5508b56fd24016c1] in 
a different and much simpler way.  No error is raised but memory errors are
avoided.

FossilOrigin-Name: 6f4a6e564b49bed1b31fe698c358c5944c6a1272e6d4fc6f6d98f56051bdba28
 2025-08-05 21:04:04 +00:00
drh
48b12598cb Fix a couple of potential integer overflow problems in FTS5. 
FossilOrigin-Name: 1f479ee3b7fa02fc7dad7fd78177137f5092caca04fa20a0bd2e6e8d9a6ee1ee
 2025-08-05 20:33:14 +00:00
drh
e25813cd12 Fix a buffer overread in the sessions extension that could occur when 
processing a corrupt changeset.

FossilOrigin-Name: 5833174c9df7df2307718c2d01c3c766deef24290f34f8b8016952b9604fc31e
 2025-08-05 19:36:05 +00:00
dan
015830dced Fix a problem with an fts5 secure-delete on a rowid/term pair that follows a legacy delete of the same pair. 
FossilOrigin-Name: f5913e763290043cb0243fc4a9a6c1f56520f291f05e072fd86ceab560985958
 2023-10-12 20:03:26 +00:00
dan
81a18232ed Fix a problem with fts5 secure-delete mode causing fts5 to corrupt its records. 
FossilOrigin-Name: cc0f82a480a400c670ae1d4193007640056bd545aed75613c088d5869a3fc817
 2023-09-08 19:32:48 +00:00
larrybr
d01c7c421d Fix CLI .sha3sum error message for keyword identifiers, reported in [forum:/forumpost/7cbe081746dd|forum post 7cbe081746dd]. 
FossilOrigin-Name: bc27bda164b86892b9dce1b5b6fe3513e6615e4fac6b55e69c828183eefec58d
 2023-06-26 17:23:53 +00:00
stephan
177479fb16 Replace some JS 'self' references with 'globalThis', as reported via the npm subproject. 
FossilOrigin-Name: b6ae84915f364f47f7cb66361dd3cb27f49d6617011077e3a4a669241a4e9dcb
 2023-06-26 07:20:21 +00:00
drh
1549472fb9 Fix a buffer over-read that could occur as part of an fts5 secure-delete operation on a database containing corrupt fts5 records. 
dbsqlfuzz a463eac437783bcd246cc675b87842618a569cae

FossilOrigin-Name: 44fdc798de2798870373f881124fd9b8ca58448a8162eabada4d6fe1e2922959
 2023-06-12 14:16:19 +00:00
drh
db7f2f8b5f Make sure temporary sqlite3_value objects used by STAT4 are reset to NULL prior 
to being reused, to prevent a memory leak associated with
the custom xDel string value destructor.
dbsqlfuzz 65209ab5d5730e4fd14fff9d024325a77239036e.

FossilOrigin-Name: 2cf197a28b4bb3442329c418579d18d307e2b9aed0973e4bca3a44b8c03235c0
 2023-06-12 14:12:50 +00:00
drh
cfa35c0c2d Defer setting the BTS_PAGESIZE_FIXED flag until after we are certain there 
are no errors and the page size has been set.
[forum:/forumpost/b901808856|Forum post b901808856].

FossilOrigin-Name: cefaf128d2f1361c7853e4e4679bb3237c6e3a80c19cb71a453033846c3e1211
 2023-06-12 14:09:11 +00:00
drh
8c3ea529fd Extra space to prevent a buffer overread on corrupt STAT4 records. 
dbsqlfuzz 7128d1b41ce9df2c007f9c24c1e89e2f1b2590ca.

FossilOrigin-Name: 566c4c14dd0ff0b68ef20968b0bbaee92f88374ee969ee6251dc3764ce935267
 2023-06-12 14:03:20 +00:00
drh
575d823095 Simplify a memcpy() in defragmentPage(). It now might copy more content than 
is strictly necessary, but runs faster and uses less code space.  Possible
reasons for the improved performance:
(1) the copy is now always 8-byte aligned,
(2) fewer intermediate results are required which means less register
pressure which helps the compiler to optimize the subroutine.

FossilOrigin-Name: 1292d676ea68b9347e3b65b9945749deb45f07bf4c83aa5386c3efcade346932
 2023-06-12 13:57:42 +00:00
drh
f7d02ca6fa Fix CLI fault on missing -nonce reported by [forum:/info/f8c14a1134|forum post f8c14a1134]. 
FossilOrigin-Name: 67cf7c40961f6d181577783e1c656abb56c4848d087794b6fc98f4d42aba48ea
 2023-06-12 13:53:48 +00:00
drh
38657ffcad Fix a problem causing an infinite loop in the recovery extension when processing a corrupt free-block list. 
FossilOrigin-Name: d21c06b73dc4e472950fb27e589e951601b642501b0200fd14685174d90d8f7b
 2023-06-12 13:46:26 +00:00
drh
6e0d6e0cc1 Fix an issue with sqldiff reported by 
[forum:/info/9bd2155bdfae25a7|forum post 9bd2155bdfae25a7].

FossilOrigin-Name: 50721074f70d19128c9ae048a6d9f7608f8c54c42e6b3ae45dfd0939448233bf
 2023-06-12 13:43:38 +00:00
drh
1409791d96 Avoid performing aggregate processing more than once for a single expression. 
FossilOrigin-Name: 1bc549716c8a96a6db579d48027fde7388e1fdad22e39f223984cdb1321fe6b2
 2023-05-23 17:43:24 +00:00
drh
51aa802a4a When converting an aggregate expression to AGG_COLUMN, be sure to remove 
the EP_Unlikely flag if it is present.

FossilOrigin-Name: 20c8a9247be2f0c1606e2c79910f28593898054b99adf505b32ac6352ce8e89e
 2023-05-23 15:22:25 +00:00
stephan
eeec597f9b Extend detection of the INSERT...RETURNING locking case to the DB.selectValue(s)/selectArray/selectObject() family of functions. Add tests for INSERT/UPDATE...RETURNING with those functions. 
FossilOrigin-Name: 58be212d56d7601e270eb11c77c8371db7507a0a19d4febf1d6c0cd87c0b1016
 2023-05-19 18:26:47 +00:00
stephan
303ba6ca1b oo1.Stmt.finalize() no longer throws, but instead returns the same as the C API. oo1.DB.exec() now triggers the INSERT...RETURNING locking failure as an exception via reset() instead of finalize(). Some code-adjacent internal API renaming for clarity's sake. 
FossilOrigin-Name: 15f105c78268fb68a4713da444452f5d7b038019b21024302beebb6b26ff2244
 2023-05-19 17:52:24 +00:00
stephan
1c1dfc1d46 sqlite3.oo1.Stmt.reset() and finalize() now throw if their underlying C-level APIs return non-0, in order to avoid silent failure in certain locking-related cases. 
FossilOrigin-Name: db36a9ef5958cd761ca5bde697cc7cd83328dcc24d818023b813f6f860052754
 2023-05-19 16:39:02 +00:00
stephan
10f6cdd308 Correct typo in an 'extern' decl name, reported in [forum:1d4342156439233b|forum post 1d4342156439233b]. 
FossilOrigin-Name: 3bb1d7b376b740c1a7bca82a8908840a9e6e9c1474c4f0fedf3d7eb917305b99
 2023-05-19 12:46:38 +00:00
drh
f1343a7532 Fix incorrect b-tree root page reports from the enhanced PRAGMA integrity_check 
output introduced in version 3.42.0.

FossilOrigin-Name: 0a0b7a2d3178f1aa650acd1d729566c889e27c9714463437a7f17c08e992ffd3
 2023-05-18 23:28:33 +00:00
drh
7a68f807d4 Avoid an assert() failure that could occur in SQLITE_ENABLE_UPDATE_DELETE_LIMIT builds when a WITH clause attached to an UPDATE or DELETE statement created a CTE of the same name as the table being modified. 
FossilOrigin-Name: 60f03e3245089ce24020105a4dbe4c9ac3de4c4978ec87b62538c1a3929e11b3
 2023-05-17 11:45:25 +00:00
stephan
2997f03826 Resolve the JS-side corner case reported in [forum:7774b773937cbe0a | forum post 7774b773937cbe0a] by not caching oo1.Stmt.columnCount. 
FossilOrigin-Name: adee1440bdca6ef9ab4096abf6cb59b30cd801055f6158b153dfcd512abdd8bb
 2023-05-17 00:47:03 +00:00
drh
09d3f5df07 Increase the version number to 3.42.1 
FossilOrigin-Name: da0c662b31ae8bf721de5bd57aaed1fa1844cd8eb721c54da005b4c2d1d3ff5e
 2023-05-17 00:32:45 +00:00
drh
27052c3e6f Fix two assert() statements that failed to take into account 
the likely() built-in function.  This does not impact production code.

FossilOrigin-Name: 634fe4c2386d42fac8bc6c4633ea95e8af61c1b0e8bf11a89b49d8dcbcfeee31
 2023-05-17 00:29:46 +00:00
drh
89efa89778 Version 3.42.0 
FossilOrigin-Name: 831d0fb2836b71c9bc51067c49fee4b8f18047814f2ff22d817d25195cf350b0
version-3.42.0 		2023-05-16 12:36:15 +00:00
drh
89caab8147 Update the tool/mkmsvcmin.tcl script so that it prints a one-line message 
to explain what it has done.

FossilOrigin-Name: 4254f086419892634c80b0b915e14edea365adc6a45bcc75eecba889da274ac3
 2023-05-16 12:34:26 +00:00
drh
e680b6dcf7 Fix a C++-style variable declaration in the generate_series() extension. 
FossilOrigin-Name: 1d3e008905461ebbd3ea0a862672f740fa72914d4d59fcf800e1ce56f1edfc9d
 2023-05-15 19:17:31 +00:00
dan
aeb064c069 Limit the number of nested NOT nodes in an fts5 expression to 256. 
FossilOrigin-Name: 01219e69b430c8f5fea5ab6ce511ba8c9b4c9b32b6d2d36623dde99c3d3812c9
 2023-05-15 17:24:48 +00:00
drh
ff4e771c0f Increase the stack size available to fuzzcheck to 8MB on Windows. 
FossilOrigin-Name: 2290dc6876041bcc982f162f59fdc9fd98b0983e1058c0a33fd46937ecc4bd84
 2023-05-15 17:20:21 +00:00
dan
4042d2b424 Limit the number of nested NOT nodes in an fts5 expression to 256. 
FossilOrigin-Name: 0e5c1ee40a146ef8b2b3c5f53d0a45e092bc8d8e933f3819805c995819d31bae
 2023-05-15 17:14:16 +00:00
drh
307db965c6 Add the --wait command-line option to fuzzcheck. 
FossilOrigin-Name: 5a479a2c7637a018d1828d9d37973bf3d36a2fc4cd5b752bca61a41cd0920d39
 2023-05-15 10:55:04 +00:00
larrybr
b579db6d5c Make generate_series() correct on ones complement ALUs and acceptable to UBSAN. 
FossilOrigin-Name: 4c5cd3e6968c44749b7663beee790969b41d247b9201b771ef90cbb03d09108f
 2023-05-15 03:48:48 +00:00
drh
eb4455e4e4 As evidenced by [forum:/forumpost/f3f546025a|forum post f3f546025a], the 
new RIGHT JOIN related restriction on the push-down optimization implemented
by [da3fba18742b6e0b] also needs to apply to the automatic index
(a.k.a. hash-join) optimization and to the Bloom filter optimization.
Computation of the restriction is now
moved into the sqlite3ExprIsSingleTableConstraint() routine.

FossilOrigin-Name: 4902015dcf3869f08d9986e422faa231d9218a5e0fc59ba8df0f407e4eb3d605
 2023-05-15 02:06:35 +00:00
drh
fa746af4a3 Simplify the interface to constructAutomaticIndex(). 
FossilOrigin-Name: c5da16551619718bf649c517515261706843e11e131f0b99e1fd6927d0f7e238
 2023-05-15 01:02:50 +00:00
dan
b8d689b666 Fix windows-specific problems in test scripts sessionnoop2.test and sessionrowid.test. 
FossilOrigin-Name: e4989c111ddffe6818cbb88a72bd027b30124d1e8de0cce4109c72a214ffb5b8
 2023-05-13 20:01:27 +00:00
dan
5e65cd1caa Remove unnecessary call to sqlite3_dbdata_init() from shell.c. 
FossilOrigin-Name: 84ca2000007d217f911a3b1586143fc9261c0697a9e9fadda6bd3dd6afdfb099
 2023-05-13 19:38:30 +00:00
dan
fd0791587b Add an "#ifndef SQLITE_HAVE_SQLITE3R" directive to shell.c.in, to avoid including the recovery code a second time if the shell is being compiled with sqlite3r.c. 
FossilOrigin-Name: 6f1a60fb7b3ef463b4131dfecbc72b7c778c794a9aa13ce4617ab6dd895508b2
 2023-05-13 19:13:40 +00:00
larrybr
ea51c09a8b Mention that sqlite3_mutex_free() accepts NULL as a no-op. 
FossilOrigin-Name: 603d9ad5012ca8996783996d7b8cd6a1aabf12b21604a2ccc137f4c2d99427b9
 2023-05-13 15:34:15 +00:00
mistachkin
273c2a9425 Fix compilation issue seen with MSVC. 
FossilOrigin-Name: 67001887044da71ab50c07d8345bd950a0a1f9688cf9cd6966312ea163cf6e17
 2023-05-13 05:13:29 +00:00
drh
59b6a2bcbe Fix harmless compiler warning caused by [0772ddf56713d013]. 
FossilOrigin-Name: f06c16a8b0e7a15ce4f7d99af3376a1bf1bfbfc0fdc048b079418ae74c619d6b
 2023-05-12 19:06:00 +00:00
dan
83be5586a0 Add multi-threaded test for "INSERT ... RETURNING ..." and SQLITE_BUSY errors. 
FossilOrigin-Name: 559cb1c6de384fd14160db005acaf1858b8b018d3d40d7f786a56a49d3cdbd59
 2023-05-12 19:02:50 +00:00
drh
4f3dc93978 Make the regexp extension more robust against OOM errors during compilation 
of the recognizer engine.
[forum:/forumpost/f50aecd5e8|Forum post f50aecd5e8].

FossilOrigin-Name: 0772ddf56713d013cd1bd44f9c75977ca14f852e3a8f038b0a6b9814f6519d79
 2023-05-12 15:45:34 +00:00
larrybr
fb74019a14 Fix unlikely strange result of CLI edit(). 
FossilOrigin-Name: ab3797e844c97fed344b36f30cfb788aca9e0d68c574fb833712219eb712db44
 2023-05-12 14:51:00 +00:00
drh
69bc8c70f9 Ensure the _O_U16TEXT is defined for Windows builds of the CLI. 
[forum:/forumpost/c80aa942dc6bf2|Forum post c80aa942dc6bf2].

FossilOrigin-Name: 504effa89b48c0dc6cd12b3eaf6017be3f32017c601af17759a3cc185346d868
 2023-05-12 13:20:57 +00:00
drh
26a3e56649 Remove a stray CR from end of line in a source file. 
FossilOrigin-Name: 48139fb904de4b7b383e7f8c29bed83ad878eb22b1dd773c366a0aee74613d23
 2023-05-12 12:57:44 +00:00
drh
61791c6f4c Fix harmless typos in comments. 
FossilOrigin-Name: 607c3efbe0293d7c11a955a9f21e24fb9f7f1bb758e13e60f4ba0cc0ac8b900c
 2023-05-12 12:45:56 +00:00
drh
6b429dc11b Ensure that all prepared statements are expired and forced to reprepare 
whenever the database text encoding changes.
[forum:/forumpost/43cbfc4d23|Forum post 43cbfc4d23].

FossilOrigin-Name: 469718f106e1cfa7f8f4714a9e743108c361af81e0258061c2b76880a7c352ae
 2023-05-12 10:52:12 +00:00