]>
git.ipfire.org Git - thirdparty/sqlite.git/log
drh [Wed, 27 Oct 2021 23:55:30 +0000 (23:55 +0000)]
Ensure that all possible outcomes for walIndexPage() are accounted for by
callers.
FossilOrigin-Name:
12715c6b234a04627ca27e94bfa8bd456998360a9f0117480e0038f4747818d6
drh [Wed, 27 Oct 2021 20:23:59 +0000 (20:23 +0000)]
Avoid the 1-based indexing on the WalHashLoc.aPgno[] array. Make it 0-indexed
instead.
FossilOrigin-Name:
28f5f709b4b28ba7f6f56bdd4a9e8c04d0d2df90d13d6df1a589fa4a65163f4d
drh [Wed, 27 Oct 2021 19:57:59 +0000 (19:57 +0000)]
Improve the comment on walIndexPage() to more accurately describe the
post-conditions.
FossilOrigin-Name:
b619e936455f4001b543a9a58dea2ac9ebd598327d6be01130ca6e7e9764ffe6
drh [Wed, 27 Oct 2021 19:05:04 +0000 (19:05 +0000)]
New assert()s to help prove correctness in sqlite3VdbeMemExpandBlob().
FossilOrigin-Name:
7238d58051bfdcea8f7a4aeab89145849d0659c987df9063aacafe97be6657fe
drh [Wed, 27 Oct 2021 17:15:08 +0000 (17:15 +0000)]
Fix the build for various the OMIT-everything compile-time option. No impact
on regular builds.
FossilOrigin-Name:
947805719bc8629619af5358ad50a6365c01f8d9ceabfe8e4df947696d3819b3
drh [Wed, 27 Oct 2021 15:19:01 +0000 (15:19 +0000)]
drh [Wed, 27 Oct 2021 15:16:30 +0000 (15:16 +0000)]
Fix a harmless compiler warning in fuzzcheck.
FossilOrigin-Name:
1cfb7e8a095e1e24df5117aa7be97470d8ce91837ff83dabebac53fafee0b09c
drh [Wed, 27 Oct 2021 13:16:33 +0000 (13:16 +0000)]
Change fuzzcheck so that it accepts binary dbsql files.
FossilOrigin-Name:
c87a2426b81f22bd21543aa2408625ae472d8fe6cbe6b04145937066e61123c9
drh [Wed, 27 Oct 2021 12:05:28 +0000 (12:05 +0000)]
drh [Tue, 26 Oct 2021 22:36:41 +0000 (22:36 +0000)]
Enhance fuzzcheck so that if an argument is an ordinary disk file (not
a database) it is read in and processed as a script.
FossilOrigin-Name:
978dc89df521f5855678128b3c0eb503c67c1b97ddb297076e5f2c03d6297605
drh [Tue, 26 Oct 2021 17:36:26 +0000 (17:36 +0000)]
larrybr [Tue, 26 Oct 2021 16:57:09 +0000 (16:57 +0000)]
Add phase and error number to CLI error messages.
FossilOrigin-Name:
7f87a298688c37bbad8fd2e1cf0e8fbcc36f0c211dcfa3685298525648dbe21b
drh [Tue, 26 Oct 2021 09:53:51 +0000 (09:53 +0000)]
Fix the busy_timeout restriction on fuzzcheck so that it can deal with
hexadecimal integer literals.
FossilOrigin-Name:
4b41535b096dec4b15a85e657102a72d4288728da6103f3fdcbe0e6f244c673a
drh [Mon, 25 Oct 2021 18:51:56 +0000 (18:51 +0000)]
Remove a NEVER() in rebuildPage that is reachable, as is demonstrated by
dbsqlfuzz case
beac09b2756b5d285aa68f9737fdb06c972f159a .
FossilOrigin-Name:
ac3f617827e06800d26ef688c5f5480b9621676f141d2eac134f877e0c454149
drh [Mon, 25 Oct 2021 12:54:23 +0000 (12:54 +0000)]
Do not allow large busy_timeout pragmas in fuzzcheck, as they accomplish
nothing other than making the tests unnecessarily slow.
FossilOrigin-Name:
fba441bf9f6ed729a66ccd4e42b5a8859bf3952d70a66bc9a2496ec49d90a60c
drh [Sat, 23 Oct 2021 22:14:11 +0000 (22:14 +0000)]
Improve the authorizer filter for ATTACH on fuzzcheck.
FossilOrigin-Name:
87d49e80878674470d280de79c8ade222dd006e65c90e79616c4f72c7c32dabb
drh [Sat, 23 Oct 2021 22:11:18 +0000 (22:11 +0000)]
Provide an assert() to fire for applications that should never open or create
a disk-based database file.
FossilOrigin-Name:
5218ac788ca35fdd7f98117758f0bef9d55fe7517098e7bf62fda3fed2af3d51
drh [Sat, 23 Oct 2021 20:32:27 +0000 (20:32 +0000)]
The pager now remembers when a VFS reports that a database file is
SQLITE_OPEN_MEMORY and treats that database as an in-memory database.
FossilOrigin-Name:
967b65623807ff992869da0a7d9b0105701939c4658a7aee37a30fb267869c6d
drh [Sat, 23 Oct 2021 17:46:00 +0000 (17:46 +0000)]
Fix the memdb VFS so that it does not allow mmap if it is resizable, and so
that it never opens a disk file for any reason.
FossilOrigin-Name:
5ee14715a561d7522e9c6fd35a2ad3e6de526450025a99d2a523c2b27151be4f
drh [Sat, 23 Oct 2021 11:30:35 +0000 (11:30 +0000)]
Update fuzzcheck so that it allows ATTACH statements with memdb filenames.
FossilOrigin-Name:
31671237e560b52dc27f707309269069a6bdcd017df9844908e77b57dc11f180
drh [Fri, 22 Oct 2021 11:17:29 +0000 (11:17 +0000)]
Fix harmless compiler warnings. Improve the independence of some TCL tests.
FossilOrigin-Name:
1a038242dc6c0cab97dd9375acfce62aa1c386debc36aaed388d366b87ddd931
drh [Thu, 21 Oct 2021 20:08:00 +0000 (20:08 +0000)]
drh [Thu, 21 Oct 2021 19:48:14 +0000 (19:48 +0000)]
Fix the previous check-in so that it works with virtual tables that add new
shadow tables the first time they are referenced.
FossilOrigin-Name:
f73b499e539b9551a70deecec4fc10c3a4af3830324977861cd0558f9782a1d3
drh [Thu, 21 Oct 2021 17:01:10 +0000 (17:01 +0000)]
Fix the new "table_list" pragma so that it shows the correct number of
columns for views and virtual tables even when the object has not been
previously used.
FossilOrigin-Name:
fb0ed8c55f6362d2639687392a72cc3ed9dc318929e11893edd2a0f023929f7e
drh [Wed, 20 Oct 2021 20:22:37 +0000 (20:22 +0000)]
Fix an incorrect JSON assert() that was added 5 days ago by check-in [
7b8ea2298927fd34 ].
FossilOrigin-Name:
e162da3ab4c183b67872be004035c48fc8f20084bc5757aec27410ce23a36631
drh [Wed, 20 Oct 2021 18:17:31 +0000 (18:17 +0000)]
Fix the finish_test proc in tester.tcl so that it works for Windows test
builds. Fix for problem introduced yesterday by check-in [
3658417bf300e004 ].
FossilOrigin-Name:
f52b84e69e5fcbe59ccc6163e7e78aa3822f2c354c88f8a76a2d1d4c90a99821
drh [Wed, 20 Oct 2021 17:58:33 +0000 (17:58 +0000)]
Enabled the testcase() macros under SQLITE_DEBUG.
FossilOrigin-Name:
0ae8dd132db8331ca9cc42ad511066924f9d3a1d158ecdb630cebc41b6bd2493
drh [Wed, 20 Oct 2021 13:48:12 +0000 (13:48 +0000)]
Fix a problem with the CARRAY extension when the SQLITE_TRANSIENT destructor
is used for non-text arrays.
[forum:/forumpost/
48e525b266 |Forum thread
48e525b266 ].
FossilOrigin-Name:
cac910c15f409c5358843643b2f90252eb90328b9e5ff84cedbccb604d9891af
drh [Wed, 20 Oct 2021 12:52:12 +0000 (12:52 +0000)]
Ensure that valid bytecode is generated for RETURNING clauses even if
the schema is corrupt and PRAGMA writable_schema is set so that the
schema parse returns no errors.
dbsqlfuzz
cb21825bdcd6fdb4b686ce4f6e2f45e781d2f220
FossilOrigin-Name:
699117156e0b5a7beda606de56bd511af322e3efa4eee6e60f0a8d60561def64
dan [Wed, 20 Oct 2021 11:40:34 +0000 (11:40 +0000)]
Fix a case in the fts3 offsets() function where a corrupt database record could lead to dereferencing an uninitialized pointer.
FossilOrigin-Name:
7b7d31a6153b1505288eb3e849d0d9ef9e88e961c7b2f918ef5582fd77990f6d
drh [Tue, 19 Oct 2021 18:59:10 +0000 (18:59 +0000)]
Improved cleanup in finish_test so that specifying multiple test modules
on the "./testfixture" command-line is more likely to work.
FossilOrigin-Name:
3658417bf300e004e5166ee69aa2d8c70697b87ea7456cb6337b0ad6d60257d5
dan [Tue, 19 Oct 2021 18:53:30 +0000 (18:53 +0000)]
Fix permutations.test so that it can be called with a test file pattern that uses square brackets.
FossilOrigin-Name:
55b6241871a3b52d835ebdc52a1ce6c736861cf7a03331391c5d6ffd39720514
dan [Tue, 19 Oct 2021 18:40:00 +0000 (18:40 +0000)]
Update test scripts to unregister the test devsim VFS after it is used.
FossilOrigin-Name:
bb0e18ae4a49c305dd8b26886a3a4f3c6dad380edca57af835da4ad470ca8eb6
drh [Sun, 17 Oct 2021 10:31:09 +0000 (10:31 +0000)]
Remove an incorrect assert() added 4 days ago by check-in [
9e2f06b84f994277 ].
Replace it with a testcase() macro.
FossilOrigin-Name:
03dff7196bb00f8e32f574f65745ceafb33ee3fdd169263121342859c362eca5
drh [Sat, 16 Oct 2021 19:50:03 +0000 (19:50 +0000)]
drh [Sat, 16 Oct 2021 18:53:36 +0000 (18:53 +0000)]
Add NEVER() macros on branches that become unreachable due to the
previous check-in.
FossilOrigin-Name:
5fa272cc033216ed2d3b16078db58accf4d9a3d10e6dd64d362ef844b3e267b6
dan [Sat, 16 Oct 2021 17:09:36 +0000 (17:09 +0000)]
Have the btree layer detect when a "DELETE FROM tbl" statement is clearing a database page that is still in use (due to database corruption) and report SQLITE_CORRUPT.
FossilOrigin-Name:
a6fda39e81d0da98dd6b60b32e6df786f0089c1f4ac7f3a2936afd118bd04353
dan [Sat, 16 Oct 2021 13:59:08 +0000 (13:59 +0000)]
Fix an assert() in fts5 that could fail with a corrupt database.
FossilOrigin-Name:
e99979855de937ed5ee0994b180054501400bf8776fb70acd31786d2ba1ad49a
drh [Fri, 15 Oct 2021 17:06:16 +0000 (17:06 +0000)]
Protect the WhereTerm.u union using nearby assert()s and/or branches.
FossilOrigin-Name:
8a56de5b9c6f4522000f8d991373490b67b9e9d97f03c1ca2cf32816d84789ef
drh [Fri, 15 Oct 2021 16:15:04 +0000 (16:15 +0000)]
Protect the JsonNode.u union using nearby assert()s and branches.
FossilOrigin-Name:
7b8ea2298927fd34f27b3345add3ce751ed728387fe3d9207b601ba6449d5af9
dan [Thu, 14 Oct 2021 21:13:02 +0000 (21:13 +0000)]
Fix a signed integer overflow in fts5 leading to a segfault that could occur when processing corrupt records.
FossilOrigin-Name:
69a3ff0cc159cdf84a5367eaf708882ddeda4fa65c96a5b546ae4a0114f02cb7
drh [Thu, 14 Oct 2021 19:28:28 +0000 (19:28 +0000)]
Protect access to the WhereLoop.u union using nearby assert()s and
branches.
FossilOrigin-Name:
bdd840216cc4c5293c112f182a189f7562b3cc0f6270e3c4af5eb2e8bd61ccc9
drh [Thu, 14 Oct 2021 17:30:32 +0000 (17:30 +0000)]
Update requirement marks. No changes to code.
FossilOrigin-Name:
3a6887a543ac348d1a0d4b7f54b13c9dae929c3fa3408c5a44420943ba8c116f
drh [Wed, 13 Oct 2021 20:29:05 +0000 (20:29 +0000)]
drh [Wed, 13 Oct 2021 20:11:30 +0000 (20:11 +0000)]
Convert an assert() into a corruption detection branch in
sqlite3BtreePayload(). dbsqlfuzz
848171b5d58f6e4a62257466e0e7de16696d4f02 .
FossilOrigin-Name:
f038d7f90e04838479e44ded00f627ec5ad8e1bd477edea8e87e66dd37485f30
drh [Wed, 13 Oct 2021 15:09:37 +0000 (15:09 +0000)]
Attempt to clarify the sqlite3_open_v2() documentation so that people do not
come away with the idea that SQLITE_OPEN_EXCLUSIVE is an allowed bit value
for the 3rd argument bitmask.
FossilOrigin-Name:
1310a126deae6974277d281ff78a7c34bd21829dd822a9fd8d6bda23cfba3f15
drh [Wed, 13 Oct 2021 14:45:35 +0000 (14:45 +0000)]
Back out the SQLITE_OPEN_EXCLUSIVE changes because it does not work on
Windows and it does not work always on unix.
FossilOrigin-Name:
d008ad793dfb11c287f366377cbc561acedef6c9d08b1557f463484eda41a84e
drh [Wed, 13 Oct 2021 14:01:44 +0000 (14:01 +0000)]
Remove a NEVER() macro in ALTER TABLE due to an
obscure case of a nested CTE inside an UPDATE within a
trigger. dbsqlfuzz
e89174cbfad2d904f06b5e24df0a22510b6a1c1e
FossilOrigin-Name:
9e2f06b84f9942772c30bed2ac71b3296c9adf9661dbf8916d56996253ee8d28
drh [Wed, 13 Oct 2021 13:00:34 +0000 (13:00 +0000)]
The sqlite3_result_text() routine (and similar) should record OOM errors
in addition to SQLITE_TOOBIG errors.
dbsqlfuzz
FossilOrigin-Name:
eca434362652fe2edd6090b29417b35bc88a170609810aa9d266f6fc27baeab8
drh [Tue, 12 Oct 2021 22:55:04 +0000 (22:55 +0000)]
Fix the group_concat() inverse function implementation so that it correctly
handles BLOB inputs when database text encoding is UTF16.
FossilOrigin-Name:
38a1326b4bd11bbe2846990d099c28520d17ab4cace1af67248c2472f89df929
drh [Tue, 12 Oct 2021 18:05:55 +0000 (18:05 +0000)]
Fix an incorrect assert() in SQLITE_ENABLE_SORTER_REFERENCES logic - a new
assert() introduced 5 days ago by [
87e2f5eb436fc448 ].
FossilOrigin-Name:
7cfc839e5f1f28514cba7d11b0c0eb56d5ea65caacb8893dcf9fcf2d409e2ba5
dan [Tue, 12 Oct 2021 11:30:07 +0000 (11:30 +0000)]
Fix a use-after-free in fts3 that could follow an optimize() in the middle of a SELECT statement when the hash table is non-empty.
FossilOrigin-Name:
8124b2ceb71447157283b16f9a7fa6e250003b9ddf1c1b45f91db64aed79b5da
mistachkin [Tue, 12 Oct 2021 02:26:32 +0000 (02:26 +0000)]
Fix another harmless compiler warning for MSVC.
FossilOrigin-Name:
b54c0db0fd686b85269cf4c301c9b483c5272269d0cd69a1c7141a91101192f0
mistachkin [Tue, 12 Oct 2021 02:17:39 +0000 (02:17 +0000)]
Fix harmless compiler warnings in the debug build for MSVC.
FossilOrigin-Name:
1ceb73f316ddc736aebd1e82ef3a0d9c173d025ac5b7fcfbde0a65a0eeb60a4b
drh [Mon, 11 Oct 2021 15:54:05 +0000 (15:54 +0000)]
Fail a schema parse if a virtual table or view has a positive integer
rootpage.
FossilOrigin-Name:
02656760406add06303afc94eaf9f2be021cbdbc7ac1ca79b139a7d2de9c0dc5
drh [Mon, 11 Oct 2021 15:21:42 +0000 (15:21 +0000)]
Use the IsOrdinaryTable() macro, not a test of tnum, to distinguish tables
from views and virtual tables.
FossilOrigin-Name:
6189b7809d774bf697d14e27a4bd961df5c318d261dce97db7801ce83f12c59a
drh [Mon, 11 Oct 2021 09:48:59 +0000 (09:48 +0000)]
drh [Mon, 11 Oct 2021 09:39:42 +0000 (09:39 +0000)]
drh [Sat, 9 Oct 2021 16:00:56 +0000 (16:00 +0000)]
Detect any attempt to use an INDEXED BY clause on a CTE and report an
error.
FossilOrigin-Name:
35a9de2c97b9a386070e7827a0842bb1caf3af69ea0d6f67ce2a50be3426fb63
drh [Fri, 8 Oct 2021 18:15:50 +0000 (18:15 +0000)]
Further to the previous check-in, remove the "harmless()" macro definition as
it is no longer used.
FossilOrigin-Name:
b8c9a54664a87ac464b413390572c3feb912e1efc9c8a78c61f1b370e2165c05
drh [Fri, 8 Oct 2021 18:12:37 +0000 (18:12 +0000)]
Remove a "harmless()" macro that is no longer relevant.
FossilOrigin-Name:
87c357c60168fdc52c82382aa7288d66886f5fbe2ae6af68344dbcfdbca9069b
drh [Fri, 8 Oct 2021 16:39:33 +0000 (16:39 +0000)]
Add support for "PRAGMA writable_schema=RESET".
FossilOrigin-Name:
a51b305bd068f8d8e85b9fc38d61cdf5957f3a2ad2eb2e77015547910088e681
drh [Fri, 8 Oct 2021 16:15:17 +0000 (16:15 +0000)]
drh [Fri, 8 Oct 2021 10:25:06 +0000 (10:25 +0000)]
Minor improvements to comments in the data structure definitions. No
changes to code.
FossilOrigin-Name:
e77ac4050cf6c24118ce2af4c075f60e3eeb2dafe6d222c848bc4e541eef7172
drh [Thu, 7 Oct 2021 23:04:50 +0000 (23:04 +0000)]
New assert() statements to protect the u1 and u2 unions of SrcList.
FossilOrigin-Name:
9b91fbcfcc14048f7d0755d47d9b7f9212fa2eaa6f3c04f417fa16c3a47943bf
drh [Thu, 7 Oct 2021 20:46:29 +0000 (20:46 +0000)]
Protect access to the Expr.y union using nearby assert()s and branches.
FossilOrigin-Name:
87e2f5eb436fc448427b0e24fb70f29688796b513b8c7b12f1a21540dae1e56d
dan [Thu, 7 Oct 2021 19:27:17 +0000 (19:27 +0000)]
Break the tcl release tests into smaller units to better take advantage of multi-processor systems.
FossilOrigin-Name:
03cef1c30d96cd42682f57667bb3072c7643ef43fe05eda2d8b82c30789234af
drh [Thu, 7 Oct 2021 17:43:30 +0000 (17:43 +0000)]
Protect all accesses to the Expr.x union using nearby assert()s and branches.
FossilOrigin-Name:
8eaa1d4a98b24adf245bbd2fe9212aa6a924a0f09c445906d7f87574f36a7423
drh [Thu, 7 Oct 2021 14:19:32 +0000 (14:19 +0000)]
Fix an incorrect assert() on PRAGMA table_xinfo added by the previous check-in.
FossilOrigin-Name:
f85cb287c52baa729aeb223038e979a3b74a1eb3d97bf59c01f5417998204f84
drh [Thu, 7 Oct 2021 13:40:29 +0000 (13:40 +0000)]
Protect all accesses to the FuncDef.u and Expr.u unions using nearby
assert()s or branches.
FossilOrigin-Name:
9af863f065e0bef491c2ab7525194505f9516f4e6dfc789d2e3a9d2c2438533a
drh [Thu, 7 Oct 2021 12:11:20 +0000 (12:11 +0000)]
Protect every access to the Table.u union using a nearby assert() or branch.
FossilOrigin-Name:
50e08338aed7ac0cee600098d2ecd4b3b7bfd31a597bb26773badf3d2e2582c8
drh [Wed, 6 Oct 2021 10:36:56 +0000 (10:36 +0000)]
Fix a macro typo introduced by [
5da112c02f9e8d0b ] that prevented coverage
tests from working.
FossilOrigin-Name:
566e6974892ebd3d3de8d77b24655257a5efe14434c553e1a25fc680b201b336
drh [Wed, 6 Oct 2021 10:04:04 +0000 (10:04 +0000)]
Once corner case for the fix at [
8b24c177061c3836 ] was not quite right.
Caught overnight by both OSSFuzz and dbsqlfuzz and repaired here.
FossilOrigin-Name:
79e90a8225b90593e384eab49a8d1d3c93a3deaf2739dcc30f6c88852df80d04
drh [Tue, 5 Oct 2021 22:51:26 +0000 (22:51 +0000)]
Fix a harmless typo in a comment.
[forum:/forumpost/
218c116fdf |forum post
218c116fdf ].
FossilOrigin-Name:
8ca0c7d826622c9660ecbd9664eba2bac9bb1b850f96f35d6c959d0acde2309b
drh [Tue, 5 Oct 2021 18:59:05 +0000 (18:59 +0000)]
Fix harmless compiler warnings, mostly caused by prior efforts to get static
analyzers to run without warnings.
FossilOrigin-Name:
cddd3b382a118bb16be3a602ae711fe2c2a7d1c673dd30dd3977b67ee555e666
drh [Tue, 5 Oct 2021 18:33:38 +0000 (18:33 +0000)]
Fix more harmless static-analyzer warnings. As of this check-in, no warnings
are generated by scan-build for clang-6 or clang-10.
FossilOrigin-Name:
a7835bead85b1b18a8affd9835240b0baf9c7af887196bbdcc3f5d58055042fc
drh [Tue, 5 Oct 2021 17:41:12 +0000 (17:41 +0000)]
Fixes for harmless static-analyzer warnings. This also makes the code easier
for humans to understand.
FossilOrigin-Name:
36177a62feeb4fa93ab6e3c6f4dbe1ddcf63bb02f93284abab979da0261b218e
drh [Tue, 5 Oct 2021 15:30:52 +0000 (15:30 +0000)]
Fix separate compilation of json1.c, which was apparently broken by
check-in [
32f33f356931242b ].
FossilOrigin-Name:
0c7ece6792d30bdb314e2a6e61d0c051c3619a2d749f8b1df7dc2b1f521388bf
drh [Tue, 5 Oct 2021 13:00:50 +0000 (13:00 +0000)]
Small change to FTS5 to help static analyzers understand that it is not
dereferencing a NULL pointer.
FossilOrigin-Name:
0d853df1b19a0270b2cb0ebdf5df8067572f19ab9a82d047cb047f3f9e850348
drh [Tue, 5 Oct 2021 12:34:54 +0000 (12:34 +0000)]
Ensure that geopoly does not invoke sqlite3_result_error_nomem() with a
NULL pointer.
FossilOrigin-Name:
2483310d15022b47109b44c86e100f5894be7a45a0568dfef6aea80e6c518654
drh [Tue, 5 Oct 2021 11:11:43 +0000 (11:11 +0000)]
Simplifications to the preupdate_hook logic to make it easier to reason about,
and reduce static analyzer warnings.
FossilOrigin-Name:
91e3b98e06feaa5b70caf2266200d20d0ae4e432db147975c9f5959f93df7e7b
drh [Mon, 4 Oct 2021 22:34:38 +0000 (22:34 +0000)]
drh [Mon, 4 Oct 2021 18:59:02 +0000 (18:59 +0000)]
Merge static-analyzer warning fixes and the new SQLITE_OMIT_AUXILIARY_SAFETY_CHECKS macro.
FossilOrigin-Name:
5da112c02f9e8d0bcbed8bcf6bab9c227607a802e85c8f70b1ca628d24960dee
drh [Mon, 4 Oct 2021 18:57:42 +0000 (18:57 +0000)]
Some #defines somehow failed to get set correctly in the previous check-in.
Fixed here.
FossilOrigin-Name:
15bbdf9ac840a220f384411d3025ef22f949d310194b60bca8e6d6a759e6042e
drh [Mon, 4 Oct 2021 18:21:14 +0000 (18:21 +0000)]
Fix harmless static analyzer warnings in sessions, rtree, fts3 and fts5.
Add the -DSQLITE_OMIT_AUXILIARY_SAFETY_CHECKS compile-time option to cause
ALWAYS() and NEVER() macros to be omitted from the build.
FossilOrigin-Name:
1c67f957fc77e37ce8f0d447c41ca975e8e79a35d332739c24a633649b5b0387
drh [Mon, 4 Oct 2021 16:14:51 +0000 (16:14 +0000)]
Fix harmless static analyzer warnings in auxiliary build tools, mkkeywordhash.c
and lemon.c. No changes to the SQLite core.
FossilOrigin-Name:
f2f279b2cc1c8b3b162058c33956be4037cd519715ac0c4290f10c58d2528f0a
drh [Mon, 4 Oct 2021 15:08:49 +0000 (15:08 +0000)]
drh [Mon, 4 Oct 2021 13:30:22 +0000 (13:30 +0000)]
The pragma_table_list virtual table should have only one "schema" column.
FossilOrigin-Name:
886feffaad6baac37dfaab489c2aecc4abf51a3a5bce1e8a94be7cc1d2a3c30c
drh [Mon, 4 Oct 2021 13:18:44 +0000 (13:18 +0000)]
drh [Mon, 4 Oct 2021 11:10:15 +0000 (11:10 +0000)]
Fix query plans created by whereShortCut() so that they always check
transitive constraints that drive an index. The is analogous to the
[
f1f9b5de3c59489b ] check-in, just for whereShortCut() rather than the
full query planner. Fix for the issue described by
[forum:/forumpost/
a65cacbf5e1c41ba |forum post
a65cacbf5e1c41ba ].
FossilOrigin-Name:
8b24c177061c38361588f419eda9b7943b72a0c6b2855b6f39272451b8a1b813
larrybr [Sun, 3 Oct 2021 22:03:59 +0000 (22:03 +0000)]
In CLI, ensure correct line-accumulation state whenever line(s) are dumped or processed. And test this.
FossilOrigin-Name:
be211a9c59234ef202e772fcaae18be43c44e1e00674f137cad2d903e00bfcab
drh [Sun, 3 Oct 2021 00:12:43 +0000 (00:12 +0000)]
Add the sqlite3ResultStrAccum() internal interface to simplify the
the implementation of functions that return strings.
FossilOrigin-Name:
e548e9299d3fd6ce5b647cf0dd93ff8e917a5eda43076c6a02389c52640e2e50
drh [Sat, 2 Oct 2021 18:22:24 +0000 (18:22 +0000)]
Try to fix a harmless static-analyzer warning in sqlite3BtreeTransferRow().
FossilOrigin-Name:
5906a0152deded614d965e790a33c67832890828a4835451d65c06414ba71f8b
drh [Sat, 2 Oct 2021 17:46:24 +0000 (17:46 +0000)]
Fix a harmless static-analyzer warning in sqlite3ExprCode().
FossilOrigin-Name:
918c22e82ae6e366ddd094d337ed73fd23878c51745045519ed700113832545c
drh [Sat, 2 Oct 2021 17:34:28 +0000 (17:34 +0000)]
Remove an unnecessary static buffer from sqlite3VdbeExpandSql().
FossilOrigin-Name:
953a33b7f739bb39f4a0efedcad2236c09fb798da4a519f8e1049aebe3bbf3ff
drh [Sat, 2 Oct 2021 17:12:58 +0000 (17:12 +0000)]
Make the sqlite3_filename_xxxx() interfaces robust against NULL pointer
arguments, even though the documentation says the behavior is undefined
in that case.
FossilOrigin-Name:
dd64c60bab4e2b44419db6882dfcc80b73d733ebe3bea64a7588c33fbc428234
drh [Sat, 2 Oct 2021 16:39:16 +0000 (16:39 +0000)]
larrybr [Sat, 2 Oct 2021 15:34:52 +0000 (15:34 +0000)]
Fix CLI line processing. (back to start state after meta-command executes)
FossilOrigin-Name:
928c2a34986644d34bcb5e8a1b2720f31cf703383f4ce75381faefca6f356d04
drh [Fri, 1 Oct 2021 22:48:52 +0000 (22:48 +0000)]
Fix a problem with group_concat() when it is used as a window function with
a sliding window, as described by
[forum:/forumpost/
f3eb24a6c0 |forum thread
f3eb24a6c0 ].
FossilOrigin-Name:
f47f7f78227830c065d9ce715b8456eab81a38d680f76bf4ff08f298d84f9c7a
drh [Fri, 1 Oct 2021 21:01:07 +0000 (21:01 +0000)]