database/sqlite
1
0
Fork 0
mirror of https://github.com/sqlite/sqlite.git synced 2026-10-25 09:59:22 +03:00
Code Activity
23,802 Commits 1,785 Branches 392 Tags
version-3.38.4
Commit Graph

23802 Commits

This Branch
This Branch
All Branches
Author SHA1 Message Date
drh
f5dc59e376 Version 3.38.4 
FossilOrigin-Name: d402f49871152670a62f4f28cacb15d814f2c1644e9347ad7d258e562978e45e
version-3.38.4 		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
relese version-3.38.3 		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
version-3.38.2 		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
version-3.38.1 		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
version-3.38.0 		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