drh
dcd7408db8
Version 3.38.5
...
FossilOrigin-Name: 78d9c993d404cdfaa7fdd2973fa1052e3da9f66215cff9c5540ebe55c407d9fe
2022-05-06 15:25:27 +00:00
drh
3666744c10
Prevent an infinite loop on SQLITE_ERROR_RETRY when trying to modify a
...
corrupt schema while PRAGMA writeable_schema=ON is active.
dbsqlfuzz ded83609f475cc989c7339d45efb5151c1495501
FossilOrigin-Name: 7fcdb760a4df8c5c11e94cecdc61bb8f40c86b70aa05f48e17520443a3d3b451
2022-05-06 01:02:05 +00:00
drh
3fa6f4d248
Update the version number to 3.38.5
...
FossilOrigin-Name: bf73b57f700ea43cd8c5849dc8d7cca184329c77b065aa3da9459ce58959d3e9
2022-05-05 10:04:38 +00:00
drh
5c701b2f56
Backout check-in [9fb20a21feb8f697] which was incorrect.
...
FossilOrigin-Name: 66f65b322a85c971d72397c2d7315504cc53b295bc9e207b2dfc07b9eea5fee8
2022-05-05 10:03:19 +00:00
drh
f5dc59e376
Version 3.38.4
...
FossilOrigin-Name: d402f49871152670a62f4f28cacb15d814f2c1644e9347ad7d258e562978e45e
2022-05-04 15:45:55 +00:00
larrybr
85ba44e1ee
Fix CLI use of wrong allocator for free().
...
FossilOrigin-Name: 4f83c442c9b34abc292566b9547d3bd265e7a5e9662472fd6498faa22aafdd24
2022-05-04 03:48:07 +00:00
larrybr
5854a3611c
Fix multi-byte column name rendition on .import and display of NULL in columnar modes.
...
FossilOrigin-Name: f863aabe9da11b9d424362543536c929f34a0f632ba973c278d4cd56e21960fa
2022-05-03 19:51:22 +00:00
drh
c62e616278
Increase the version number to 3.38.4.
...
FossilOrigin-Name: def971a0e90212a2387967d4a4b266a7c39129ad66fb7df7bf11f6979d1e524a
2022-05-03 14:26:58 +00:00
drh
30b35a5572
Fix the Bloom filter pull-down optimization so that it jumps to the correct
...
place if it encounters a NULL key. Fix for the bug described by
[forum:/forumpost/2482b32700384a0f|forum thread 2482b32700384a0f].
FossilOrigin-Name: 3dc9fc2f2de8696b67d0fc6f414398625d6fe7de108e95b443fb11e8f460b84c
2022-05-03 14:25:52 +00:00
drh
20ccfc67e2
Preserve the COLLATE operator on an index on an expression when resolving
...
the use of that expression into a reference to the index. See
[forum:/info/7efabf4b03328e57|forum thread 7efabf4b03328e57] for details.
FossilOrigin-Name: ef72f9e289966d4bad5a2fa37d640f318dd972a9cf669425696e3e2a547fccb6
2022-04-30 12:55:29 +00:00
drh
a0b146cf30
Version 3.38.3
...
FossilOrigin-Name: 9547e2c38a1c6f751a77d4d796894dec4dc5d8f5d79b1cd39e1ffc50df7b3be4
2022-04-27 12:03:15 +00:00
drh
69110cb32a
Modify utility function sqlite3SetString() so that it may be used safely on Parse.zErrMsg. Fuzzer test case "crash-1604e5d76c92574e21e437049dab9b672e06b767.txt".
...
FossilOrigin-Name: b9c7d2c1bdc529b8c367e4a0894f4c966957cfa4b427175d5aa10af6a25f4f12
2022-04-26 20:58:48 +00:00
drh
214bd2ebe2
Cherry-pick various minor fixes from trunk into branch-3.38.
...
FossilOrigin-Name: fece097c707ba563abfeca82a3d8f6fe6e90d73ae8a8ecaa4695131baa76b3b1
2022-04-26 19:48:23 +00:00
drh
fc2f28fda0
Reverse the order of two tests to stop a harmless initialized value
...
warning from MSAN - reported by OSSFuzz.
FossilOrigin-Name: fb7e1a07a936857b2e9e50042a43d239817053e6dd3e36f3d2c55ec41fd3bdf3
2022-04-25 23:00:56 +00:00
drh
ea03c17bcf
Fix a problem with using multiple SQLITE_SUBTYPE function as window functions in a single query.
...
FossilOrigin-Name: 9caca6cb3e4eee9801cfb6f3def9b063f14c4d46269a0c4322c13a6e5f62f5a7
2022-04-25 21:31:28 +00:00
drh
ba7516ae4a
Increase the version number to 3.38.3.
...
FossilOrigin-Name: b113afa2245f465b2e3db4be3c2a323b9e6d100e7d0b462358f732402ae3e1dc
2022-04-25 21:22:59 +00:00
drh
3c2635c376
Fix a problem with automatic indexes introduced by
...
check-in [664b461bb5063d980] and reported by
[forum:/forumpost/0d3200f4f3bcd3a3|forum post 0d3200f4f3bcd3a3].
FossilOrigin-Name: 4fbb9ffe72f112d5f3b02760759b90ef935ddff4089013caac3a9e222a98a304
2022-04-25 21:21:08 +00:00
drh
9085b56c69
Fix two minor problems in the JSON functions associated with JSON Paths
...
for object labels that require quoting.
FossilOrigin-Name: 4a1553b55f085163278866617deb26df12571c55fc650f8daa9392fd77c1eba9
2022-04-04 15:26:31 +00:00
larrybr
1c3c8e00bd
Incorporate fix noted as absent by forum post https://sqlite.org/forum/forumpost/aefd62fcc7ebd8b6
...
FossilOrigin-Name: 336851b191fe79f0282148b5c42976df9d1ce584fc93e523bc1cd2cf0c2912e7
2022-03-30 11:12:04 +00:00
drh
86fbbbf964
Version 3.38.2
...
FossilOrigin-Name: d33c709cc0af66bc5b6dc6216eba9f1f0b40960b9ae83694c986fbf4c1d6f08f
2022-03-26 13:51:10 +00:00
drh
5eea5054d0
The "PRAGMA writable_schema=ON" flag should not allow OOM errors to pass
...
while parsing the schema.
dbsqlfuzz 9cc49e1a53e1cef8e3a1496a88c683aa20483163.
FossilOrigin-Name: 4977d8f453bcd56fb1dfab02cc5b283fb32d402bafdf2b6112e7dd322b7c32ad
2022-03-25 19:16:26 +00:00
drh
b64cf9b28c
Do not allow an #ifdef inside of an assert(), as gcc tells us that is
...
not portable.
FossilOrigin-Name: b193156c2a2407146e7cf77e237e0de0766d4ce8c673547d9f2bda4a1814959b
2022-03-25 17:43:32 +00:00
drh
2dc539addd
Bump the version number to 3.38.2.
...
FossilOrigin-Name: bb3ef206ab4a92bef16cd53bf23f574e720ed4709baba58700e04dbf48c1347e
2022-03-25 01:37:26 +00:00
drh
e62f31cdb4
Fix the Bloom-filter optimization so that it does not use IS NULL or
...
IS NOT NULL constraints from the WHERE clause when operating on a LEFT JOIN.
[forum:/forumpost/031e262a89b6a9d2|Forum thread 031e262a89b6a9d2].
FossilOrigin-Name: 8246bfbc1643497fbbebe950b5e297fdc2a90359603e5c01a79ba67168bd7d02
2022-03-25 01:31:18 +00:00
drh
1905379eb1
Ensure that database corruption does not cause the cursor passed into
...
sqlite3BtreeDelete() to be invalid.
dbsqlfuzz 209bf3de9ee11ae440848ab9bc9c13858f9be2e4.
FossilOrigin-Name: 780d00d4ec8c87229a639671a610c4561f2ab2b1729bb9a4386547ac18772dd4
2022-03-22 23:47:25 +00:00
drh
51907db8ca
Harden the xShmLock method of both the unix and Windows VFSes so that they
...
are robust against being invoked when the SHM file is not open.
FossilOrigin-Name: 06d4c4d17c49b98701e4b09c19c0cc68e65a0413850fda33b4991fa24fc84fa0
2022-03-22 20:02:53 +00:00
drh
e40d899afe
Strengthen the defenses against corrupt databases in the
...
sqlite3BtreeInsert() function of the btree module.
[forum:/forumpost/c7ec29905f|Forum post c7ec29905f].
FossilOrigin-Name: 883fec9c3a410280bd5160acf1e103fa3c5fb6c6a003b2b99567d3b7037bc07e
2022-03-21 18:23:24 +00:00
drh
2f0ebf5e5c
The previous assert() fix was not correct when building with
...
-DSQLITE_ENABLE_OFFSET_SQL_FUNC. This is the fix.
FossilOrigin-Name: b4210bc0ba1dddd163884b75a7bcc21d580598bdab06f938b0f84982274d6346
2022-03-21 16:34:19 +00:00
drh
2fc20b68e8
Fix the assert() that attempts to verify that the table-reference to
...
index-reference translator finds all required translations.
[forum:/forumpost/929168fdd6|Forum post 929168fdd6].
FossilOrigin-Name: ccd2a2a7e197736a18dce28272fdb4acdf8447342523819c545d28e744c99562
2022-03-21 13:55:56 +00:00
drh
52fceac318
Fix an assert() in sqlite3TableAffinity() that might have been false if there
...
was a prior syntax error in the query.
FossilOrigin-Name: 940f1a400bcd58c2dc135955f261df5f96615339645c25583947f1a7dedae4ce
2022-03-21 11:50:28 +00:00
drh
72327c367c
Fix the zipfile extension so that it knows that a zero-length BLOB returns
...
a NULL pointer.
[forum:/forumpost/ae86934905|Forum post ae86934905].
FossilOrigin-Name: b75c6bad3a5a165948077026441f02188ba30c7960815486c1973e18992401b3
2022-03-19 12:53:43 +00:00
drh
7fa8b4acf4
Another fix for a corner-case in sqlite_offset() - this one having to
...
do with computed virtual columns in a WITHOUT ROWID table. Also an
assertion fault problem with sqlite_offset().
FossilOrigin-Name: 9e72cae2f15bdd1466ff4fe1e9b747d7630b581bccd8b13d1fd69e33a81a0f72
2022-03-17 11:37:02 +00:00
drh
8a5d1585f1
Disable trigger coding while running sqlite3_declare_vtab().
...
dbsqlfuzz 97e1865771b4226f29e6e482411c1cae14133f50
FossilOrigin-Name: 5b8a0460a2ea8720731282a396e5de835cf87876d41f7d861712b160706b838d
2022-03-14 20:39:57 +00:00
drh
e3afca73dc
Version 3.38.1
...
FossilOrigin-Name: 38c210fdd258658321c85ec9c01a072fda3ada94540e3239d29b34dc547a8cbc
2022-03-12 13:37:29 +00:00
drh
3e7d815579
Fix a case in fts5 where a corrupt database could cause a crash.
...
FossilOrigin-Name: 1894577c8eff6d0cb586cc8cd3a8f6a2b5800b9aa6391261121f4e26c9ba5f8f
2022-03-11 12:40:18 +00:00
drh
401697bb54
Stronger defenses against corrupt schemas in the ALTER TABLE logic.
...
FossilOrigin-Name: 29744e69f473638796877bd073468046d4aeff209c0a0f30beee8c5f102112b6
2022-03-10 21:14:35 +00:00
larrybr
c606152c7b
Doc improvements re sqlite3_column_text*() endianness (no code change)
...
FossilOrigin-Name: a37c20d40f97570575abb1f1db31dbc934300e7f2294d38fe41850baedb3766f
2022-03-10 19:53:49 +00:00
drh
d8659ad141
Prevent a NULL-pointer dereference when trying to parse a illegal
...
schema entry that contains a window function while doing a RENAME COLUMN.
[forum:/forumpost/ec2a2e0deb|Forum post ec2a2e0deb].
FossilOrigin-Name: 2c393228257490efcf609f3e428f0d02c74cbea48a28763b2414e69a4ced66da
2022-03-10 16:28:13 +00:00
drh
4acead62b1
Check-in [642a0b4752743216] fixing sqlite_dbpage is not exactly correct.
...
This patch should fix it.
FossilOrigin-Name: b6c4c8a09a63693dd515d30a9f07f67ed81dc14df2586835fcb2b1bc6a9d01fc
2022-03-10 01:15:35 +00:00
drh
c36de71968
Further refinements to the sqlite_offset() fix from [6029514b08b88e3f].
...
FossilOrigin-Name: 98799d7bbb6d62d71862d5fdfe87856995dd179d66612e369c5dc440e7fac31a
2022-03-09 18:30:55 +00:00
drh
468657ec19
Fix the sqlite_dbpage virtual table so that it starts a write transaction
...
on all attached schemas.
FossilOrigin-Name: e92c4fdb99eb09507e6b970067c1a6f2043838f67017125851469d66c1bb5b20
2022-03-09 14:29:33 +00:00
drh
3b7520b747
Fix a potentially uninitialized local variable in the ".import"
...
command of the CLI - introduced by [741651fd4b1b776b]. This same change
is part of the nearby [/info/5e30c6ea707f9d38|"Fix compiler warnings"]
check-in.
FossilOrigin-Name: ce9e3d903c2e5993a3fdadaf809ce2026efd1b5b933930b50dd794c9a7329cdd
2022-03-08 16:12:53 +00:00
drh
c2384cdbea
Disable an assert in moveToRoot() when the database is corrupt.
...
[forum:/forumpost/e9a176b7bd|Forum post e9a176b7bd].
FossilOrigin-Name: ab744a5da80ddcd5c7cce60626d82c0e368f675b8a11bfb93b4739ea30bb07c0
2022-03-07 18:38:12 +00:00
drh
54068138f0
Do not allocate new Trigger objects in the parser following a syntax error,
...
to avoid violating invariants associated with Expr nodes. See
[forum:/forumpost/2024e94071ef1531|forum thread 2024e94071ef1531] for more
information.
FossilOrigin-Name: 369d240455a2806afb1699273864bca3f84b163c6b1f93807c9147437001132b
2022-03-07 16:40:44 +00:00
drh
312d0ec0a7
Fix the code generated for vector IN operator constraints on virtual tables
...
so that they work even if the "omit" field in the sqlite3_index_info object
is off. This has apparently never worked correctly before. Presumably, nobody
has ever before written a virtual table that can use vector IN operator
constraints and that relies on bytecode to double-check the constraints.
Test cases in TH3. Problem discovered by
dbsqlfuzz cab8e26194a40147627094f3c6849c0a7b1e0310.
FossilOrigin-Name: 4a2040d5c78f42b892a080ba086f6ab32f59bb9c31b897af40c4359cdb17b0e9
2022-03-07 14:59:45 +00:00
drh
135f5fb747
Fix the .import problem in the CLI reported by
...
[forum:/forumpost/72a024c957|forum post 72a024c957].
FossilOrigin-Name: d753285bcbb68bdf8f6d95a64af58b20ce6da9f048734fdb0ae49150eb7befd4
2022-03-07 01:28:13 +00:00
drh
2614c7c873
The sqlite_offset() function should be non-deterministic.
...
dbsqlfuzz 3df8230bb940870db87ffca2c0fc759c1e7fa356.
FossilOrigin-Name: 8083757606920151171530f337919553fa8ba902a51744d7b21eeba1558db9fa
2022-03-06 11:44:14 +00:00
drh
b9d060e934
Remove a NEVER() associated with sqlite_offset()>
...
FossilOrigin-Name: bf2501e26c8e4c08d679ea930bab89b9510808439aee9412ab176a9d29635cc7
2022-03-06 00:01:10 +00:00
drh
7b7932bed3
Fix the 'localtime' modifier in date/time functions so that it preserves
...
fractional seconds.
[forum:/forumpost/2ffbaa2c3fd7fb82|Forum post 2ffbaa2c3fd7fb82].
FossilOrigin-Name: 6833f4aeef4923c3633978720277ccbfc63b26c96092c12a6330e6d4629b5eb5
2022-03-05 20:20:45 +00:00
drh
1909223648
Increase the version number to 3.38.1.
...
FossilOrigin-Name: cd87e77dd062b6b9479c14f28bf7b94db86e3538d8977dc46f92fab8674dbec8
2022-03-05 19:46:17 +00:00
