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
drh
c95b28ebea
Cherry-pick all bug fix changes since the 3.38.0 release.
...
FossilOrigin-Name: 45a5d5acf712cccf6d7043412fb21541ec00081d10fbd85421014677470a74f2
2022-03-05 19:39:19 +00:00
drh
98095e3949
Version 3.38.0
...
FossilOrigin-Name: 40fa792d359f84c3b9e9d6623743e1a59826274e221df1bde8f47086968a1bab
2022-02-22 18:58:40 +00:00
drh
60f3657b4a
Fix an undersized memory allocation in the test harness for RTREE. This
...
error was in test logic only, not in the SQLite library itself.
[forum:/forumpost/35470a0a72a005e1|forum post 35470a0a72a005e1]
FossilOrigin-Name: 7e3c9594390ac8defaf9825e14b4c19ef8c123b747971dd3d4df16110f443d3b
2022-02-22 15:47:55 +00:00
drh
16f56e8416
Fix compiler warnings for older compilers (ex: gcc 4.0.1 powerpc-apple-darwin).
...
FossilOrigin-Name: 5c188243d769681c68938c8e432155c8ec838d9e32fe8d1b12286ebc9d0e87f1
2022-02-21 14:30:59 +00:00
drh
a12500005f
Remove stray tab characters from auxiliary source code files.
...
FossilOrigin-Name: e25e33582b69289a2c3a6bc403e3911de22a3b529db1a565efb9f1af01b9e382
2022-02-21 13:44:51 +00:00
drh
91260dcf83
Add SQLITE_OMIT_JSON to the compile-time option test sequence.
...
FossilOrigin-Name: f36325a6e21c4d3b6ab48ebfb2efabda089281344d1e61949d1c9290e88395b1
2022-02-21 13:02:23 +00:00
drh
d01a1bd94a
Do not allow error messages from sqlite3NestedParse() to leak up into the
...
main parse.
FossilOrigin-Name: 9c4e21abdca664d6b7bcf0043fe9ec05ef8b2949ba6ee7208abaaec1ff4ed679
2022-02-21 00:23:49 +00:00
larrybr
a7919add6a
Improve .backup and .save help text
...
FossilOrigin-Name: 741651fd4b1b776b4dea156cdc987f426f7c668ece203bda6654b2c7117c8933
2022-02-19 21:25:48 +00:00
drh
1ff855b22e
Add a NEVER() to a branch that is unreachable for STAT4.
...
FossilOrigin-Name: e4e97505af4016c48465009686bfeffe9627e225a5b2082a5bf4baeee40db5c9
2022-02-19 15:57:28 +00:00
drh
b15a3940d1
Enhance the documentation on sqlite3_stmt_readonly() to explain that
...
EXPLAIN and EXPLAIN QUERY PLAN do not affect the return value. Add test
cases to verify this. Add new test cases and requirements marks for
complete requirements test coverage on this interface.
FossilOrigin-Name: a6fbb7ba0583b3981e2d8b809006b902b3e97e516dbd3ab7d905c5ea73df2272
2022-02-17 17:24:39 +00:00
