database/sqlite
1
0
Fork 0
mirror of https://github.com/sqlite/sqlite.git synced 2026-10-23 21:49:02 +03:00
Code Activity
32,598 Commits 1,782 Branches 392 Tags
version-3.54.0
Commit Graph

10412 Commits

Author SHA1 Message Date
dan
bfb858c596 Ensure the join flags on the parent are set correctly when flattening UNION ALL sub-queries that include branches with RIGHT joins. Report [bugs:/info/2026-10-08T15:27:33Z | 2026-10-08T15:27:33Z]. 
FossilOrigin-Name: cfa69ea48a7aa379ee0c30ae81d2802da862d610f829c933e5eb358c23fc2b9d
 2026-10-08 19:34:24 +00:00
drh
f19a90c569 Improvements to the display of DDL SQL statements in the CLI and in 
the sqldiff command-line tool in order to close comments and similar
in the case of a corrupt schema, and avoid possible SQL injection
attacks.  ANT-2026-9VFH4DZS.

FossilOrigin-Name: 028a92f9c353d3b400551954de2e09c1723076491f79ff767dd24b452654fda8
 2026-10-08 18:34:12 +00:00
dan
28e05e55f6 Avoid clearing unrelated join related expression flags when processing window function queries. Report [bugs:/info/2026-10-08T15:38:26Z | 2026-10-08T15:38:26Z]. 
FossilOrigin-Name: c50d7f682cc95715e4577413196dbdb2845d7c845b0e760c7060b7cdcda87770
 2026-10-08 17:57:48 +00:00
drh
74675a9e87 Assign the correct encoding to the BLOB values read from an overflow page. 
[bugs:/info/2026-10-07T15:44:40Z|Bug 2026-10-07T15:44:40Z]

FossilOrigin-Name: a8895cb047a3aeed35642111fa79bde9db962a5d7bc3f0cc472b4dbe510cb3f9
 2026-10-08 03:28:50 +00:00
drh
644fa62518 Fix processing of LEFT JOIN when the right operand is controlled by an IN 
loop.  [bugs:/info/2026-10-07T23:22:09Z|Bug 2026-10-07T23:22:09Z].

FossilOrigin-Name: e71b0465b9fa13db3922e767c1d8979d221516475670dcd3fa4df1fab30176c6
 2026-10-08 02:55:50 +00:00
drh
9d50c7ebfc Fix the expansion of "TABLE.*" so that it works the same as PostgreSQL 
when TABLE is the left operand of a RIGHT JOIN USING.
[bugs:/info/2026-10-07T02:56:24Z|Bug 2026-10-07T02:56:24Z]

FossilOrigin-Name: d232720b7932c1cebe4cf5b1a1e9096889e1807844351390149dfeb2ea7fc304
 2026-10-07 10:41:59 +00:00
dan
c62b4abb99 Handle temp triggers attached to databases clobbered by sqlite3_deserialize() in the same way as those attached to DETACHed databases. 
FossilOrigin-Name: 84c773fcc2f785346fd12e8a17ac45f9068797d9629ddc367318994b6fed421b
 2026-10-05 18:07:26 +00:00
dan
b642a1d56d Ensure that deserializing into a database expires existing prepared statements. 
FossilOrigin-Name: de0361b1caa97d36ea79a5bcb032539ccfb235c03581e0e88c54c03a321d7911
 2026-10-05 17:51:16 +00:00
drh
95170adc37 Fixes to sqlite3_incomplete() so that it does not appear to presume a 
trailing newline if there is none.
[forum:/info/2026-10-05T16:22:33Z|Forum 2026-10-05T16:22:33Z]

FossilOrigin-Name: adc1113cfd1d675a44a4ef34d7be3e0cf20129840e542d692fefa249780e23b8
 2026-10-05 17:32:25 +00:00
dan
8a91f5484c Do not run new virtual table tests in memdb1.test for SQLITE_OMIT_VIRTUALTABLE builds. 
FossilOrigin-Name: eced240b2a991ff8255f98d189a6874dda44e3cdb1fcd07e74abddf2a9a71ea4
 2026-10-05 17:25:06 +00:00
dan
5ee733befe Allow windows clients to open and recover a wal mode database even if an old client still has the *-shm file mapped. Forum post [forum:/info/2026-10-05T14:07:31Z | 2026-10-05T14:07:31Z]. 
FossilOrigin-Name: 7c103a0b7d509dce58aa87518e13213451e5f70938ff08aa55accd645e3b2ff3
 2026-10-05 17:11:27 +00:00
drh
45cd455d79 Update test cases so that they work for configuration that use 
-DSQLITE_MAX_EXPR_DEPTH=0.

FossilOrigin-Name: 4bfc6e53a95d710b7f40fa9c80d8cdd1df50d69ed8614e9800f7e6a1ca5a3c29
 2026-10-05 14:22:13 +00:00
dan
6e20be1c58 Ensure that eponymous virtual table objects are not left with dangling schema pointers if the main database is overwritten using sqlite3_serialize(). 
FossilOrigin-Name: 18d2646f6fa56244be12122873cd9aa48b2074a22f0be637edfcc9b5de99158b
 2026-10-05 14:03:54 +00:00
drh
8532bf12f4 Correctly rollback "OR REPLACE" changes following a "datatype mismatch" error. 
[bugs:/info/2026-10-05T07:15:40Z|Bug 2026-10-05T07:15:40Z].

FossilOrigin-Name: 028f3f96a0af9fc71f1c191bbd44e0b7c3884d0571931b2808e4cdd1bb2f5081
 2026-10-05 13:27:07 +00:00
dan
4cf3766d09 Ensure that when a value that may be stored without data loss as an integer is stored in a column with REAL affinity, the values passed to the preupdate-hook are of type SQLITE_FLOAT, not SQLITE_INTEGER. Report [bugs:/info/2026-10-04T16:18:21Z | 2026-10-04T16:18:21Z]. 
FossilOrigin-Name: 9f7490065e24fc69a5fc13371aeb40214d617209bb0cd9a3e23f76486d4704c0
 2026-10-05 11:29:02 +00:00
dan
1ad569d147 Ensure that it is not a constraint violation if a CHECK constraint that evaluates to NULL for one or more existing rows is added to a table using ALTER TABLE. Report [bugs:/info/2026-10-05T07:36:38Z | 2026-10-05T07:36:38Z]. 
FossilOrigin-Name: f940c67b21b112e33bfdd54f2c3a19b06ad5bf661ddf2f85dd464fb76d115e31
 2026-10-05 10:54:29 +00:00
drh
996ded6c48 Raise a "nested too deep" error if the number of cursors consumed when 
resolving a CTE name exceeds SQLITE_LIMIT_EXPR_DEPTH.
[bugs:/info/2026-10-04T05:35:14Z|Bug 2026-10-04T05:35:14Z]

FossilOrigin-Name: e68aa6e1293a2c7ad37d4b9fea8e649c318f9b4c64381eefebd0413363f56da4
 2026-10-05 10:41:45 +00:00
drh
e6ff280c83 Limit the depth of recursion for CTEs using SQLITE_LIMIT_EXPR_DEPTH. 
[bugs:/info/2026-10-04T04:58:58Z|Bug 2026-10-04T04:58:58Z].

FossilOrigin-Name: f54730871303e655a70f3167ce1a39dcd4e53fcf017d225f429e2bb67ad96604
 2026-10-05 09:32:24 +00:00
drh
d54522a5b8 Fix expression tree depth calculations for COLLATE. 
[bugs:/info/2026-10-04T04:50:56Z|Bug 2026-10-04T04:50:56Z]

FossilOrigin-Name: 252c0b7bf5a727d29605672bb58e06c758173c276671df3e388a68294998b4d3
 2026-10-04 21:54:17 +00:00
drh
e8cbe2c96a In QRF, add the zero-pad flag to the default floating-point format in 
output modes that render JSON or INSERT, so that infinities are shown
as 9e999 or similar instead of as "Inf".
[bugs:/info/2026-10-04T05:35:43Z|Bug 2026-10-04T05:35:43Z]

FossilOrigin-Name: f63139ba68bc7df770bbd3c26bcd760c479889fb45fa921e9e225e38c9e2044c
 2026-10-04 16:23:01 +00:00
drh
2f77d50f7e Fix test cases added by [e21c5bc59ae66173] so that they work with 
in-memory configurations.

FossilOrigin-Name: 85207e5253967c2d30c67ff1f5b572ca3117b5d95ecba65affc861c4ce7ec10c
 2026-10-03 10:45:03 +00:00
drh
61978d90eb Do not allow surplus SQL text to come after the CREATE statement in the 
sqlite_schema.sql field.  Any such text is flagged as an error.  However,
the schema will still work if PRAGMA writable_schema is engaged.

FossilOrigin-Name: e21c5bc59ae6617362e085711ddb4436db5cc4ad4b740873850a4aecdb91f4f2
 2026-10-02 19:56:59 +00:00
dan
cb5651e46d Fix integrity-check fails that would occur if the database contained a contentless fts4 table. Report [bugs:/info/2026-10-02T12:22:03Z | 2026-10-02T12:22:03Z]. 
FossilOrigin-Name: ca8de9a30484d26739a09c972c525a1ae6edcce41b0f3c612805836b894c7a26
 2026-10-02 14:33:50 +00:00
dan
e32fbe0c23 Import vec1 sources into directory ext/vec1/ of this project. 
FossilOrigin-Name: 3a0876d973868be7b6f4156a434cd09098c7ab1abdc7f0ef4f3d12a03de68b24
 2026-09-30 14:49:16 +00:00
drh
34615b9c1f Reset the nullRow flag on the pseudo-cursor on each iteration of the loop 
when the RHS of a LEFT JOIN is a multi-row VALUES clause.  Fix for
[bugs:/info/2026-09-29T00:41:09Z|Bug 2026-09-29T00:41:09Z].  Problem
introduced by check-in [a120c9235f125e05] with a missed opportunity to
fix the problem at check-in [8c0f69e0e4ae0a44].

FossilOrigin-Name: 8e59d3c0a428ff12ea852c7a9f15b6b7b4ca0da55708f3d303b2e88818a17476
 2026-09-29 11:52:00 +00:00
drh
1059bc8eac Fix a duplicate test case identifier label in speedtest1.c. 
FossilOrigin-Name: 6f7db1d7313892260298aa78cfa1a3d91e5e55aebd16862d77835c5e070857c5
 2026-09-28 16:30:59 +00:00
dan
00830b2819 Fix some cases where fts3 integrity-check was not detecting corrupt databases. Report [bugs:/info/2026-09-25T11:18:11Z | 2026-09-25T11:18:11Z]. 
FossilOrigin-Name: 9b23f99212f49587c5f0b025e90fdd2e844437fbb76fc11c26062df7bcff765c
 2026-09-25 14:55:16 +00:00
dan
2503dc6182 Avoid marking little-known extension function next_char() as SQLITE_INNOCUOUS by default. 
FossilOrigin-Name: 481a1df638aeef163022523f8de590c265f64d078eb070cf262995e8ecb0f690
 2026-09-24 17:09:56 +00:00
dan
4d577dfb33 Fix an off-by-one error in sqlite3GetUInt32(). The only user-visible effect of fixing this problem is that the error message emitted for a corrupt database has changed in one obscure case. 
FossilOrigin-Name: 7f0149c9696ed8c804fb1f6d4e78f4e887e465015795e03bae0f8ea648d515b4
 2026-09-24 15:34:05 +00:00
drh
28c6f996b0 Fix test case inaccuracy introduced by [4f4ca57309c82d9e]. 
FossilOrigin-Name: 1b097b30ac1009073bec72f67b3bcbe55478795149017ed3c72a32ab652bf4f7
 2026-09-24 10:37:53 +00:00
drh
4b495f91a9 In date/time functions, the hour can be 24 as long as the minutes and 
seconds are zero.
[bugs:/info/2026-09-23T02:44:48Z|Bug 2026-09-23T02:44:48Z]

FossilOrigin-Name: 52eec02592f9d0d2d4282c20cc0872215c8d88e17f1a3e34d2ccab48119f7c42
 2026-09-24 00:18:35 +00:00
drh
9da2d2374a The --escape mode for CSV should default to "off". 
[bugs:/info/2026-09-23T16:25:07Z|Bug 2026-09-23T16:25:07Z]

FossilOrigin-Name: c356641fadf591bcf312ae9657ddc84e483a06aa068eb2d3021467435cbad0c1
 2026-09-23 21:04:57 +00:00
drh
64c8a0f2e9 Minor adjustment to [987ba5a3dc5f2a22] to deal with a corner case involving 
the maximum integer.
[bugs:/info/2026-09-23T03:07:00Z|Bug 2026-09-23T03:07:00Z].

FossilOrigin-Name: 4a66e328a080b7719e5f76283ae0502f0aaed1b4fa35339c0160b91c3189de5b
 2026-09-23 12:27:03 +00:00
drh
d884a3c7c9 An attempt to improve the handling of rowid lookups using very 
large floating point values.

FossilOrigin-Name: 881da860d6048106a50cfec463bd64ee2773baa996129dab369939252f8fcf48
 2026-09-23 11:37:04 +00:00
dan
681d217d49 Do not allow the arguments of table-valued-functions to the left of a LEFT JOIN to refer to tables to the right of the LEFT JOIN. Fix for [bugs:/info/2026-09-20T09:57:48Z | 2026-09-20T09:57:48Z]. 
FossilOrigin-Name: e9e341013f770a82a60ca947f1b3471370fc2ad9f7feb9dd5f86f61d9d8e3315
 2026-09-23 11:12:41 +00:00
drh
c907770214 Improved capture and reporting of errors by the CLI. 
[bugs:/info/2026-09-21T02:55:55Z|Bug 2026-09-21T02:55:55Z]

FossilOrigin-Name: 6698a7e18727b08748eb875c08c93a23afa391d3642e7610a87e86f7528a04bc
 2026-09-22 17:12:56 +00:00
dan
6c6d1c71eb Fix calculation of the virtual table dbstat.pgoffset field for overflow pages. Report [bugs:/info/2026-09-22T01:43:42Z | 2026-09-22T01:43:42Z]. 
FossilOrigin-Name: 4f4ca57309c82d9e2e090cf3accb83d4ee2868de2a7626d7afc30ff4c8351695
 2026-09-22 10:30:05 +00:00
dan
bed690d6f9 Do not allow the arguments of table-valued-functions to the left of a LEFT JOIN to refer to tables to the right of the LEFT JOIN. Fix for [bugs:/info/2026-09-20T09:57:48Z | 2026-09-20T09:57:48Z]. 
FossilOrigin-Name: c6b035ceffb7771e5fa9b1b1efc1544b0d7eea6d0576f257c836c82c4122d58d
 2026-09-21 15:45:19 +00:00
dan
5f8b6a782d Fix truncation of 64-bit integer values passed to the fts3 snippet() function. Report [bugs:/info/2026-09-21T02:41:49Z | 2026-09-21T02:41:49Z]. 
FossilOrigin-Name: b0919c9687f01240c89171e1607816b603450e5bed37c468860298b2ccc11a81
 2026-09-21 11:14:14 +00:00
drh
93d6a90fe9 Adjustments to the substr() function so that it can accommodate 
ridiculous values for the second argument.
[bugs:/info/2026-09-20T18:42:27Z|Bug 2026-09-20T18:42:27Z]

FossilOrigin-Name: aadf42e021fc55d457836c7cda68f3d22dcaae72a7bbc105c3c727b3eb5c4657
 2026-09-20 20:17:58 +00:00
drh
30fbf300af Fix test cases added by [f847298c8d424071] so that they work on 
all configurations.

FossilOrigin-Name: 977e0faac735409fd06d61851a30686b471bcfc3f1dcfba2debe2b4a3d42b5e8
 2026-09-19 11:07:26 +00:00
drh
ac2685b071 Fix new test cases added by [c77ff6089de242d8] so that they work 
on all configurations.

FossilOrigin-Name: 78d3370d36fb8872de1ed853f3a479273b54d2cff9fdfe83db963f4da9c7f999
 2026-09-19 10:58:12 +00:00
drh
b8c29c92a5 Ensure that the comments generated by the ".schema" command in the CLI 
are not terminated early by rogue SQL.

FossilOrigin-Name: e6eef2cb8fff278cfef2b8898e12d641df22c435d70800d0f031ae740cc88b7e
 2026-09-19 09:24:10 +00:00
stephan
9073f828a3 Cygwin portability fixes contributed by Jan Nijtmans, including the un-exporting of some non-public-APIs which need to be reviewed closely. One test (delete_db.test) is failing but that specific failure has been a recurring theme in this environment. 
FossilOrigin-Name: fe484c8dbc4829508616a1db1bd38a8e451409bddcc20b593fbf51a6ab1a1b00
 2026-09-15 08:37:47 +00:00
drh
1eca07ed73 Do not discard INDEXED BY or NOT INDEXED from a parenthesized term 
of the FROM clause.
[bugs:/info/2026-09-10T20:38:13Z|Bug 2026-09-10T20:38:13Z].

FossilOrigin-Name: e308b0fce47e184860564f0535174017eb7d5d7efc4f86dd1eb8d234f75e4d08
 2026-09-10 23:54:06 +00:00
drh
134f69359c In PRAGMA integrity_check, double the space available for checking that 
every byte of a page is used only once as a safety margin to deal with
unforeseen kinds of database corruption.

FossilOrigin-Name: 0c173d54b1bab44748f0010ec7aa5bd79891aa9aaea91d2996c6f0d3f859d1a8
 2026-09-10 20:04:18 +00:00
drh
220b580fc7 Fix minor issues with the delta_parse() table-valued function in the 
fossildelta.c extension.  Add test cases for the fossildelta.c extension.
[bugs:/info/2026-09-09T10:29:35Z|Bug 2026-09-09T10:29:35Z] and
[bugs:/info/2026-09-09T10:55:54Z|Bug 2026-09-09T10:55:54Z].

FossilOrigin-Name: 737ab94632c7745d3fd1f82894a1c8174db59350a33329660681398dd604c4d0
 2026-09-09 13:49:42 +00:00
drh
e137e97af6 Improved orderly-shutdown in testrunner. Windows lets running jobs complete. 
Unix just invokes exit and lets the OS deal with cleaning up the mess.

FossilOrigin-Name: ce822e8dc137128a6c495600205c6659a9cd2ba6ba188d86567ed97c04b7aeea
 2026-09-04 14:02:05 +00:00
drh
55f0206dca Remove an intentional error used for testing that was accidently left in 
the previous check-in.

FossilOrigin-Name: 87f9d70d9e3fae2eda2650d9f58fd587c5f7b9cf7f7d13d47ebd11053ce63a25
 2026-09-04 13:43:43 +00:00
drh
b5e3cf0655 The testrunner.tcl script is enhanced so that --stop-on-error does not 
exit immediately, but instead  marks all pending tasks as "halt" so
that no new tasks are scheduled, but allows "running" tasks to continue
on to completion, as an immediate halt can cause hung processes on  Windows.
Also, in Makefile.msc, the "test" target now includes --stop-on-error.

FossilOrigin-Name: 0fba9b52b41a5fade0d162c947712669653c4619c89a79800017703e978d8a24
 2026-09-04 13:37:51 +00:00