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
25,651 Commits 1,785 Branches 392 Tags
version-3.41.1
Commit Graph

25651 Commits

This Branch
This Branch
All Branches
Author SHA1 Message Date
drh
cd0b19a37f Version 3.41.1 
FossilOrigin-Name: 20399f3eda5ec249d147ba9e48da6e87f969d7966a9a896764ca437ff7e737ff
version-3.41.1 		2023-03-10 12:13:52 +00:00
drh
10e44bf373 In the Bloom filter optimization, hash all strings and blobs into the same 
value, because we do not know if two different strings might compare equal
even if they have different byte sequences, due to collating functions.
Formerly, the hash of a string or blob was just its length.  This could
all be improved.

FossilOrigin-Name: cc8a0ee40cfc83ab42a0ff452de0a53fe17784aefb944ea7ac2cb078a8310730
 2023-03-09 16:04:34 +00:00
dan
b08004d947 Fix countofview.test so that it works with SQLITE_OMIT_PROGRESS_CALLBACK builds. 
FossilOrigin-Name: d55a7742c9447eba20a7fe252fb3edcabba3793030a55976d5a5e6c65bce7706
 2023-03-09 15:08:56 +00:00
drh
322b844815 Update the version number to 3.41.1 
FossilOrigin-Name: e4e2e64725a196ee4f287649db33f49fd7329c95cef3ce743cd177c998a6a343
 2023-03-09 14:14:18 +00:00
drh
da1b094d95 Merge count-of-view optimization fixes from trunk. But count-of-view is 
still off by default for this branch.

FossilOrigin-Name: cbbe8986ea26e78a7c5b122170cb5bf3f275f8e3a2941017f9ef11d7f3864256
 2023-03-09 13:58:49 +00:00
drh
cc4f0f678d Fix a possible NULL pointer dereference due to the sqlite3_interrupt() 
enhancement in the 3.41.0 release.

FossilOrigin-Name: 66d24a220e3455a183b61490f42869520744cb3990e13f3ded92f1b6a7e248ce
 2023-03-09 01:35:52 +00:00
drh
86ac593b84 Keep the historical datatype ("INT", not "NUM") for a table created as follows: "CREATE TABLE t1 AS SELECT CAST(123 AS INT) AS value;". The use of FLEXNUM only occurs on compound queries. 
FossilOrigin-Name: dc1033af4bf707095032f66d7a8ab63204f38bae244fab16a2bc870840d5bffd
 2023-03-08 14:37:04 +00:00
drh
fe8d2d2497 Fix an assertion fault added by [65ffee234787213c]. 
FossilOrigin-Name: d00e68baf73238d2f91df6b19525c91539a7fe26406516cbacfff113e79e26ea
 2023-03-08 00:04:47 +00:00
drh
ec1533e366 Cherry-pick the agg-with-indexed-expr optimization fix from trunk. 
FossilOrigin-Name: b2ad89d3f0fe5c7582d97e65770eb93986ba8d4b031aafb04f86160383b47aab
 2023-03-04 15:49:33 +00:00
drh
9ebf799d5b Do not use an expression index on a generated column if generated column has the wrong affinity. 
FossilOrigin-Name: 65ffee234787213ca3b12afde1b5ed7ae536366c30e984b14c0975da0c57917d
 2023-03-03 19:47:09 +00:00
drh
5a7afccd51 Enhance PRAGMA integrity_check so that it can detect when there are extra 
bytes at the end of an index record, which might cause OP_IdxRowid to
malfunction.

FossilOrigin-Name: c143f08713ec5dcc7609804f1fa0d795005c7ebd265b73e42342584d759eae01
 2023-03-03 18:47:29 +00:00
drh
74273c4369 When it is known when preparing a statement that X cannot be NULL, transform the expression (X IS NULL) to integer value 1 instead of 'true'. This is because under some circumstances, "Y IS TRUE" may not be equivalent to "Y IS 1". 
FossilOrigin-Name: 0fc7f7c2a90ce9bc3462478441b4e628c90e5adff0d461e6cc3521371b7f1f08
 2023-03-03 17:11:15 +00:00
drh
7a83522677 When flattening the right operand of a LEFT JOIN, 
ensure that the OP_IfNullRow opcode does not
NULL-out a subquery result that was computed within OP_Once.

FossilOrigin-Name: c80b262c9dbde80c51872f36f9c4d406eba1c3f34468d36d5cb7084b1720ee5c
 2023-03-02 14:09:11 +00:00
drh
843c71d748 When flattening a view that is the right operand of a LEFT JOIN 
always insert the TK_IF_NULL_ROW expression nodes, even for TK_COLUMN
expressions, as the TK_COLUMN might be a column from an outer query
and hence still need to be NULLed out.

FossilOrigin-Name: 371838562a675c1bdd9c80250230eb87ac0e5e135cc39abbdbe1f8b1b8149445
 2023-03-01 20:44:34 +00:00
drh
cbfa2269c4 Make sure subtypes do not cross a subquery 
boundary even if the function that returned the value with a subtype is
buried down inside a larger expression.

FossilOrigin-Name: 9dc460318d98308f51e31df216872ff96ece67c86f50c3fd11bf2a3df112afdd
 2023-03-01 15:28:34 +00:00
drh
0a64b581dd When a table-valued function appears as the right table of a RIGHT JOIN, 
the argument constraints on the table-valued function should be considered
part of the ON clause of the RIGHT JOIN.

FossilOrigin-Name: d225d077c4fcc526e70d59018479bba723d464cac5ac805eeeebd7d2a48cedcf
 2023-02-26 21:09:45 +00:00
drh
72e2aa5096 Provide -DHAVE_LOG2=0 and -DHAVE_LOG10=0 compile-time options for use on systems 
that lack the log2() and log10() standard math library routines, to cause
SQLite to substitute its own alternatives.

FossilOrigin-Name: ff3362ab53752de10bd95a16804ce3ef31edd8f0cb3099841c3e4ffc1d79d64d
 2023-02-23 17:12:07 +00:00
drh
3b832a1a29 Version 3.41.0 
FossilOrigin-Name: 05941c2a04037fc3ed2ffae11f5d2260706f89431f463518740f72ada350866d
version-3.41.0 		2023-02-21 18:09:37 +00:00
drh
b5726a76f7 Disable DQS by default in the MSVC makefile for the amalgamation tarball. 
FossilOrigin-Name: 409a19145e9558686acab730b94c6d53691b6d0efcea1e9239fc7e5863586a85
 2023-02-21 13:28:49 +00:00
drh
61f0a03492 Yet another comment typo fix. No changes to working code. 
FossilOrigin-Name: cdbdc8013fcfa8ce1bd4f5521c8d98afc53b9c577d43e5e6d0d1e15c789b910f
 2023-02-21 12:42:25 +00:00
drh
0c30eaec99 Fix a minor typo in a comment. No changes to working code. 
FossilOrigin-Name: 7981671d1449b3fc6eb214deb558d91b87dc4fa6e38e24606625a146cc71664a
 2023-02-21 12:34:00 +00:00
drh
6e2b2f3073 Fix formatting and improved documentation on the various sqlite3_file_control() 
opcodes.  Other minor documentation changes.  No changes to working code.

FossilOrigin-Name: 13280f720a4ef5a1f7f2a2fbe72f374d3a2e12be9bc0c50f7fce50d0cd28a67f
 2023-02-21 12:30:18 +00:00
drh
3eeace23f5 Update the TEA version number to 3.41.0 
FossilOrigin-Name: b450a920c0c59affd105616e999205cb9d2b25a79f8a7f7f05610ddaac0f770f
 2023-02-20 19:43:01 +00:00
drh
ffe9bfd8e9 Fix an incorrect #ifdef in the CLI. 
FossilOrigin-Name: 3c4d29cf227511bf218ef620d497dc72c708dcc819971b34c7629f3ed11803fb
 2023-02-20 16:55:58 +00:00
drh
e17cac189f Fix a harmless compiler warning. 
FossilOrigin-Name: b2534d8de5051a3516f4b9ee5a4b99e1dcf455e9af88c60815d2c2a479fc8566
 2023-02-19 19:16:51 +00:00
drh
1603f7edee Fix stale requirement marks and fix a typo in the documentation for 
sqlite3_preupdate_hook().

FossilOrigin-Name: 655991f5d9afdd3281049eb430921046e0ba90eef215020c2fb149adc0d3c4c5
 2023-02-18 20:31:26 +00:00
drh
3c7e90b894 Fix a harmless UBSAN warning in debugging code of the new unhex() function. 
FossilOrigin-Name: 315574d5cbe5c805ff2163052d986b054985984fb45bfb064d1a7b39a22b90eb
 2023-02-18 15:50:23 +00:00
drh
16cdb4b632 Fix a harmless typo in the test case added by [29fc06465efb948f]. 
FossilOrigin-Name: e0a0bf56f11f32f58705098e76c276deaf90cfa87e110032bdaad10ce9674f61
 2023-02-17 22:48:46 +00:00
drh
ab31a5df93 Do not allow the COUNTOFVIEW optimization to run if the count() contains 
a FILTER clause.  dbsqlfuzz 4f8e0de6e272bbbb3e1b41cb5aea31e0b47297e3

FossilOrigin-Name: 29fc06465efb948f98d2733bb25ffa1e0662a0189304006b3d0be9fec7dd28c5
 2023-02-17 18:27:48 +00:00
dan
bdb2ec409a Update testrunner.tcl to run zipvfs test scripts on unix. 
FossilOrigin-Name: e6c8e19ab0d6e7526d4596b75a45bb6becaf3c029690f7e75c016eac803c9990
 2023-02-14 18:09:40 +00:00
drh
d6ba4252b2 Ignore extra parentheses around a subquery on the RHS of an IN operator, 
because that is what PostgreSQL does.

FossilOrigin-Name: ecdeef43b27412b0b0b09e09a62ad3a03836a3fc80f2070268090e7ca8f02712
 2023-02-13 19:32:40 +00:00
drh
b4dc263ec5 Do not allow WHERE clause terms to match constant string index terms, which 
can happen if DQS_DDL is enabled.  Follow-up to
[44200596aa943963].  dbsqlfuzz 54c9db85ed4af7055f5fd0d50877875c82b11d46.

FossilOrigin-Name: 2d2b91cc0f6fed8cb6f738dc7019047ce0f1e86b5eb8efa997095d08a32cbcb6
 2023-02-13 18:42:01 +00:00
dan
1aacb3b02f Allow vector-IN expressions like "(a, b) IN ( (?,?), (?,?) )" to use an index. 
FossilOrigin-Name: 18a99d9cfbc3a0419342b3fe91a83d2217578d0f6e8ee1084237d000946b1942
 2023-02-13 18:37:48 +00:00
dan
5c84aafd77 Fix compile time option SQLITE_DEFAULT_SYNCHRONOUS so that it works consistently. 
FossilOrigin-Name: bf6f1ee77c4bf653f6cd2a3db5292b8c5c83f18ea9acf951107d22807546b28a
 2023-02-13 18:26:58 +00:00
dan
0c69938511 Allow vector-IN expressions like "(a, b) IN ( (?,?), (?,?) )" to use an index. 
FossilOrigin-Name: 1815b15ddb8785a25b7617aab19e13c2410b9377389c16a85176025b3d9400e8
 2023-02-13 16:10:31 +00:00
drh
9e463e878d In the LIKE optimization, do not analyze the new virtual WHERE clause terms 
until both have been added, since they are expected to be consecutive and
the analysis might add complementary terms.
This fixes a problem caused by [44200596aa943963] and discovered by dbsqlfuzz
and recorded as case 7e3b5983727d843b910b2d9ab556e4afcd777cfb.

FossilOrigin-Name: d35de3ad3fac6b30d3f266cbe4b1e9923eb31a1eff4a869205bbc3ba122eeec5
 2023-02-13 12:46:22 +00:00
drh
0c55b5fd1c Change a variable from 32 to 64-bits to avoid a harmless compiler warning 
in Xcode.  [forum:/forumpost/402d733c22|Forum post 402d733c22].

FossilOrigin-Name: 0216ce23cf23bc147c5de6de178a6689b7ad744bf0ee0098809938b5fe10708b
 2023-02-11 21:11:39 +00:00
drh
80e936aef0 Do a better job of detecting when a WHERE clause term might be useful to 
an expression index.  Fix for performance regression reported by
[forum:/forumpost/e65800d8cb|forum thread e65800d8cb].

FossilOrigin-Name: 44200596aa943963bc6ca98b5d4fd5b9235d1109d8dfc1a75eeae353b4239142
 2023-02-10 21:53:33 +00:00
dan
a3e6192941 Fix a problem with the fts5 trigram tokenizer and LIKE or GLOB patterns for which contain runs of 2 or fewer non-wildcard characters that are 3 or more bytes when encoded as utf-8. 
FossilOrigin-Name: 00714b39b39c51519edbc0194f98c7275fecf96763a06fd95db6e1d81bb9f1f1
 2023-02-10 17:17:04 +00:00
drh
74e6e30358 Ensure that the valueFromFunction() routine does not clear a prior 
parser error.  dbsqlfuzz 6fa816f20cf5b62260d635d110b88f38e29d8fe1.

FossilOrigin-Name: 734766451123c98a467c3407562eaa097b3307c8a275e1c8dd93e4654fe78014
 2023-02-10 14:20:18 +00:00
stephan
98094e2f4c Minor text-only updates to wasm demo/test HTML and license header. 
FossilOrigin-Name: f28e2a8613571fe3c23bfbbb602311071f4cb9731653216cfe436c38b0a59736
 2023-02-10 11:05:16 +00:00
stephan
c9e3cbe873 Fix ext/wasm/fiddle build, which was silently broken by recent build refactoring. 
FossilOrigin-Name: dcf532931136d09bef23ccad669d486cb31daec8565317c3209c280b5695d45d
 2023-02-10 11:04:39 +00:00
drh
3f4795a391 Disable the double-quoted string misfeature by default in CLI builds. 
DQS can be reenabled at run-time using the ".dbconfig dqs_dml" and
".dbconfig dqs_ddl" dot-commands.

FossilOrigin-Name: c995932c3ffe7f2710ebce0fa407eca3200418aa84febc15fb15f20f3758a98d
 2023-02-09 15:32:24 +00:00
stephan
5b56a13977 Squelch two harmless signedness comparison warnings in shell.c.in. 
FossilOrigin-Name: bdd3edec13fa1142a8074c316e9ecec93fb278d42836eeb38587376fdf22cebd
 2023-02-09 12:59:44 +00:00
drh
9a8330b550 New test cases added to fuzzdata8.db. 
FossilOrigin-Name: be67bafccd79ba835ed7e287e09852ce83805da0797b164d0c8e44be05d9d28a
 2023-02-09 12:47:15 +00:00
drh
a0c8ec9ee5 The "flexnum" affinity that was added by [44135d6ea84f7ba6] needs to also 
be added to the output of the affinity() built-in function.
dbsqlfuzz d309eaa5fe492c9606a8be876c2bc7dedb29d3d8

FossilOrigin-Name: f4ec68ceefa3a607f37d6355aac89fd1ae1704da4061bad7f271db1f17c1dd3a
 2023-02-09 11:51:40 +00:00
drh
601e4d4a0f Back out the 'txn' enhancement to date/time functions. The duration of a 
"transaction" is confused and needs to be straightened out prior to moving
forward with this change.

FossilOrigin-Name: 4a145f07322d768a07619bed27e0390d50f3a01d07787b9296234a5ceb6f1218
 2023-02-08 20:29:48 +00:00
drh
03b30b7abe Always use 64-bit integers for stats associated with STAT1 and STAT4. 
FossilOrigin-Name: 6647d1cb8b53102c8114b1f3e34173d907504d78aa3140eab53f88027a36660b
 2023-02-08 17:28:42 +00:00
dan
0d12a79310 Better fix the problem where optimizing an fts5 table too often causes it to become unreadable (first attempt was [35bed981]). 
FossilOrigin-Name: 459d986d38fc0ccbfd66801e0f22900cfed831268cf59ac8d1cd1e556f0d1441
 2023-02-08 17:28:08 +00:00
larrybr
72ce57e675 Cause gcc warning suppression in shell.c to be nice in other project(s). 
FossilOrigin-Name: 6b41ba2e996ab7b9c3943ab93a19748db5cf37792f5d59d20eec301085282355
 2023-02-08 14:49:52 +00:00