database/sqlite
1
0
Fork 0
mirror of https://github.com/sqlite/sqlite.git synced 2025-11-14 00:22:38 +03:00
Code Activity
29,836 Commits 1,608 Branches 185 Tags
json-opt
Commit Graph

19158 Commits

Author SHA1 Message Date
drh
5dd74bf384 Improved progress-handler and interrupt detection during PRAGMA integrity_check. 
FossilOrigin-Name: 6db42780a9e530bcc94490cc6080536309666dc13523272d1799d6661137e908
 2023-01-11 16:17:31 +00:00
drh
3b7a19b033 Add a new sqlite3_is_interrupted() interface that can be used by long-running 
app-defined functions and similar to see if they need to exit early due to
an sqlite3_interrupt() call.

FossilOrigin-Name: d030f341369b7f32789cbcf3d0ad9a2ac5cad99a56dac7dfe68b7f06dc339b17
 2023-01-11 00:27:06 +00:00
drh
706631de32 When computing the datatypes for columns in a view, use the same datatype name 
as the underlying table if such is available and is consistent with
the computed affinity of the column.
[forum:/forumpost/7fb1fe9dcf310ef5|Forum thread 7fb1fe9dcf310ef5].

FossilOrigin-Name: 497a98363fd1ed079544620ec5d0883f987ed03013131542741c93d7568e8568
 2023-01-10 19:57:26 +00:00
dan
8340f54bdd Fix handling of unix paths that contain ".." components such that "/" is considered its own parent directory. 
FossilOrigin-Name: b829dd1b976454619ca04c69aec5ebb5a2286772f4267b82ab2ea5fdb81ccd41
 2023-01-10 15:07:18 +00:00
drh
b0779fb969 Improvements to the SQLITE_DIRECTONLY documentation. 
FossilOrigin-Name: b277ba40a8b0acea15bd73036d1c86fb5187f047ec8500ebc88c738ea3dbd118
 2023-01-10 14:33:26 +00:00
dan
2e77734b98 Fix handling of unix paths that contain ".." components such that "/" is considered its own parent directory. 
FossilOrigin-Name: 3c6cadb396de3981bd950eddd532daa8134bd4bf22c578620e323835c96a8500
 2023-01-10 14:31:56 +00:00
larrybr
bf395ec58e Clarify help for .quit. 
FossilOrigin-Name: 8004a2b7439748f1034df897af7b6c58b48a46923c6fdddbe7d78c89b8d7b438
 2023-01-09 18:42:28 +00:00
drh
6791891f92 Fix JSON functions so that they work correctly under PRAGMA trusted_schema. 
[forum:/forumpost/c88a671ad083d153|Forum thread c88a671ad083d153].

FossilOrigin-Name: 51a5d83c425d2e31508b73074d0076156817afb19003f847d16bf4a69ae5077b
 2023-01-09 12:01:30 +00:00
larrybr
4ff47d3e37 Doc-only update, sqlite3_preupdate_hook() return 
FossilOrigin-Name: 2da51d7e1b9f16ef03efbb096ce2a84e8c23b883380f48b2d374bdc521865aeb
 2023-01-07 22:28:00 +00:00
drh
50da6ac8c1 Changes a testcase() into an assert() due to the 
[e58bba93717cd6ff] change.

FossilOrigin-Name: a6251d72894f9c2e21fc6e91b1d2452a204952f5e1a94fd93835a47c7dfb9be3
 2023-01-05 14:41:18 +00:00
dan
e3b1c3868b Fix a problem with applying integer affinity to a MEM_IntReal value. Forum post [forum:/forumpost/d270125fae|forum post d270125fae]. 
FossilOrigin-Name: e58bba93717cd6ff950c6f9e077b4327b59b1956dd5f6668be3de9509584b8fe
 2023-01-05 13:35:23 +00:00
dan
52c08ee982 Ensure that LIMIT clauses may be passed through to virtual table implementations even if the WHERE clause uses operators that may only be optimized by virtual, not built-in, tables (!=, functions, MATCH etc.). 
FossilOrigin-Name: f38caab23bcef1df02618376de22d208a3333d023628cde310345505933329f1
 2023-01-04 17:46:29 +00:00
larrybr
fd318937e7 Employ deliberate_fall_through macro to quiet some compilers. 
FossilOrigin-Name: 869635fb81e0868dee80ce77653a2c1d2af41b3ffbf0a3f7b788ac99dc808887
 2023-01-04 16:54:55 +00:00
drh
d0fe0fc531 Enhance PRAGMA integrity_check so that it verifies that the string values 
stored in indexes are byte-for-byte identical to the values in the table, and
not just equivalent according to the collating sequence.
dbsqlfuzz 686e2e205e0c0594d3fb524bea0c25e621d1a870.

FossilOrigin-Name: 9302e4bfdce5905576b8f0af7d6b3a864e1dcd58ed89bb303010a1c4f826e915
 2023-01-04 15:18:52 +00:00
drh
cef97068cd Remove the unused "sqlite3StackAllocZero()" macro. 
FossilOrigin-Name: f0ca57207e9f3ab401264498f65c249b479d9e0da7158e001b002584ac67dd0a
 2023-01-04 11:58:36 +00:00
stephan
373d34d610 Elaborate on the open-in-read-only fallback behavior of the SQLITE_OPEN_READWRITE flag, per user request. Unrelated trailing EOL whitespace cleanups. 
FossilOrigin-Name: 1003144fc192e1531e1bc968d7e1d0ccc7ad31e501180f90e1479565a4abfb96
 2023-01-04 11:57:27 +00:00
drh
a9e1e4edaf Small performance increase in the symbol hash table. 
FossilOrigin-Name: a19597b4fd2530a89363992b9179f9f3f0621a6e3861a91324f29311aafe09b9
 2023-01-03 19:27:00 +00:00
drh
fbde3f50bf Avoid an unnecessary call to strlen() in the sqlite3VdbeMemStringify() routine, 
for a performance increase and size reduction.

FossilOrigin-Name: 284382d37850f469dc4bf3ab8efd2f20971554e897f1ba3e94d3f2f0c35d97d0
 2023-01-03 18:51:18 +00:00
drh
1eb88d6e5a Small performance improvement in the btreeOverwriteCell() routine. 
FossilOrigin-Name: df5ea47130d275e9fa1bd6aa8d55f1d5e136cba30ba13b7ede22224aa7f78919
 2023-01-03 15:11:01 +00:00
peter.d.reid
206db97ddd Remove redundant assignment in kvvfs's decoding. 
FossilOrigin-Name: 2ffbf0c73c5a0f08717093cfaac99c4aedee506ec7b5a9a62c92168a2bcadc14
 2022-12-31 05:26:35 +00:00
peter.d.reid
576fe9035b Avoid an infinite loop when an unexpected character is being decoded by kvvfs 
FossilOrigin-Name: 6909195f77b50650982a6afd9d72b3a6ac9aff1f86c653fa18d0d9bf64e9bd8f
 2022-12-31 05:19:45 +00:00
drh
12e1eb344f A call to sqlite3_declare_vtab() should not cause DML/DDL authorization 
failures.

FossilOrigin-Name: eed1e030722deb24674e7c2d165a2a359576c6bb5769d3bdd5fa645bc0f2ecc7
 2022-12-29 18:54:15 +00:00
drh
4e013284a0 Fix a missing 0 at the end of an integer literal in check-in [8da0f0c38a458c57] 
FossilOrigin-Name: e3776796f55574f357eb429e20399389092a68e9ca00aa104ed33eb559ae0de5
 2022-12-27 14:03:04 +00:00
drh
ff78b2bee8 Fix an infinite loop in the MEMSYS5 auxiliary memory allocator that occurs 
for memory allocations between 1GiB and 2GiB in size.  Error introduced
by check-in [949133231f8f751a].  The problem only affects builds that
include the SQLITE_ENABLE_MEMSYS5 compile-time option.

FossilOrigin-Name: 8da0f0c38a458c57f979d59b49cf4804ef81fc2eccabde1f166bab24dd1dabea
 2022-12-26 15:14:24 +00:00
larrybr
3a8fbc0749 Grammar fixup in comment re SQLITE_TRACE_PROFILE trace event. 
FossilOrigin-Name: b6dc80cbf63ed521ef8f878fba24b0110d61813763ca7bfbcfb0a145656b300a
 2022-12-26 01:44:04 +00:00
stephan
6e893aee95 Merge trunk into wasi-patches branch. 
FossilOrigin-Name: 52f40ab12e437c59af2b91c7ac105ab7784db57fc8d9ab7a1356f17092681f43
 2022-12-24 15:31:56 +00:00
larrybr
0953c5354a Add base64() and base85() text/blob conversions to the CLI. 
FossilOrigin-Name: 4bc98a2d9520efa9b80142163cbfab72a5f2fe9854cd6ba8291dcefdb872e657
 2022-12-23 19:04:59 +00:00
drh
3547e4997f Fix lots of harmless, nuisance compiler warnings, mostly unused parameter 
warnings in extensions.

FossilOrigin-Name: c14bbe1606c1450b709970f922b94a641dfc8f9bd09126501d7dc4db99ea4772
 2022-12-23 14:49:24 +00:00
drh
de5f3af2b9 Additional fixes for yet more completely harmless compiler warnings. 
FossilOrigin-Name: 7d3772f0bd0e2602fe919573b49001da4e2b9f3874cb0183dea675204afa7abd
 2022-12-23 11:46:57 +00:00
stephan
dc02d5658b Squelch a new (and, in this case, harmless) compiler warning. 
FossilOrigin-Name: a02e19dd6ce00492f3d187e3c3c9bde4d9d1ee9a23616e62ea3590eec95652bd
 2022-12-23 11:32:06 +00:00
drh
f26bad66ba Asserts added to ensure that the iCompare variable in the bytecode engine 
is correctly initialized before it is used.

FossilOrigin-Name: 7b5900a111b9410f7d60c937e5a56304f2f66b94cd0881e94abcc5eedde52514
 2022-12-22 21:32:58 +00:00
drh
cce70d52d0 Avoid having to reinitialize Vdbe.pResultRow upon each call to sqlite3_step() 
for a small size reduction and performance increase.

FossilOrigin-Name: 6a00d67f5955ab86eea982c27b3a03b680fdf644ec63f49586ade6342a4d64a6
 2022-12-22 19:12:48 +00:00
drh
edc2713fdc Rename the Vdbe.pResultSet field to pResultRow in order to better distinguish 
it from other variables with similar names.

FossilOrigin-Name: 1fd6211ef7bd26ed625177bfedfd5153ace547de6a71365ecfa076578d043f1a
 2022-12-22 18:44:39 +00:00
drh
c2d853e562 Small performance optimization associated with shared cache in the 
byte-code engine.

FossilOrigin-Name: 3181331c1c0259d5cd274dcb33faba930dae51b1f0fe51e8a0318d9c564b94f9
 2022-12-22 18:35:21 +00:00
drh
57366d8cec Small performance optimization on the OP_Insert opcode. 
FossilOrigin-Name: 781fdcb9ce85aa2844ef8c00cf908f1a87eeff80dadaf73a71f88b4279260e57
 2022-12-22 17:36:02 +00:00
drh
79b9bc4452 More efficient implementation of large precisions on the "%c" format for 
the built-in printf().  This is an effort to avoid a reported
timeout on a (ridiculous) query generated by OSSFuzz.

FossilOrigin-Name: 371f9b88387a44a5f820279d79733d1deb7eafc72f320ec47a11679bbdbb49ef
 2022-12-21 19:11:56 +00:00
drh
fe83892bc1 Ensure that the expression of a virtual column really is an expression and 
not just a reference to another column, as a real expression is necessary for
the indexed expression coverage optimization to work properly.
[forum:/forumpost/07b36e3899a9ae21|Forum thread 07b36e3899a9ae21].

FossilOrigin-Name: 40549bacb3923e439627b0103bedd7da30258b69a46960040f7176e060f51f2f
 2022-12-21 14:13:49 +00:00
drh
4f0c36b327 New WHERETRACE entries for adding and removing objects from the 
Parse.pIdxEpr list as part of indexed expression coverage.  Debug and
testing changes only - no affect on production builds.

FossilOrigin-Name: 4dc438a951bdbe27fbd5ee7cfb907e30ec0efbf8ce02109f18997cc221e0ad3b
 2022-12-21 12:18:06 +00:00
drh
2656b1b0a0 Add ALWAYS() to always-true branches in the locking logic of the memdb VFS. 
FossilOrigin-Name: 01fa760212a40cec5b43da99b917ab6389561c96d0567a9f67f516bdfa8f5f3d
 2022-12-20 15:02:44 +00:00
drh
1379b9f51a Improvement to the dbsqlfuzz fix of [f113eebdbe68246f]. 
FossilOrigin-Name: 79d62956f206cb2987891d4ba5985cece21fc8c8c1158f46c2951f65c0dcf4e8
 2022-12-20 14:02:35 +00:00
drh
98164c3452 Do not use indexed expressions to replace the expression being indexed on a 
RIGHT JOIN as that leads to problems, as shown by
dbsqlfuzz a644e70d7683a7ca59c71861a153c1dccf8850b9.

FossilOrigin-Name: f113eebdbe68246fd38d640b0cdf0fd73ab5d2abad9226274dfa2e41fe286bf0
 2022-12-20 01:48:43 +00:00
drh
b7fe3cb890 Remove an unused variable. 
FossilOrigin-Name: 5c4d94147d290d4a68ac0d5ae8f9e6bbfe7522ad58b2298e387f8c699048e111
 2022-12-19 19:04:32 +00:00
dan
1532f9d155 Fix an assert() in fts5. Simplify memdb xLock/xUnlock some. 
FossilOrigin-Name: 7fe158aa8071acadd959b2b4a4b66e8a7f7eecec207ba681abf516b0457c2921
 2022-12-19 14:06:36 +00:00
drh
a4569bd5d0 Fix a minor problem with the printAggInfo() routine (used on during 
debugging).

FossilOrigin-Name: c8329967f32efedfc8244631a5682f7f7d21c1b3fcd7d5cc67716555716d4926
 2022-12-19 12:25:41 +00:00
drh
b7959e3419 Fix an unnecessarily restrictive assert() in the aggregate logic. 
dbsqlfuzz 699bee2aa26c5dc84afabf6894685c316d936485

FossilOrigin-Name: 8cc0af81ad03ac65f230d78cf97e1448c2d93d556467ea3ef700d5abd4a3890c
 2022-12-17 22:10:05 +00:00
larrybr
88fbe16154 Remove slew of inadvertant tabs in favor of spaces. 
FossilOrigin-Name: 0aa6da69e12e483b5561bb9a054ec27a99f51772340c950783e342e6dd39beb9
 2022-12-17 19:56:28 +00:00
drh
1c70429569 Add NEVER/ALWAYS to branches that have become unreachable due to recent 
enhancements.

FossilOrigin-Name: b4281db4e4762773684d27b809ef911da08b81cb953b3666e535b990d4d5f701
 2022-12-17 12:49:04 +00:00
drh
00d6b2755f Create a new affinity called FLEXNUM that works like NUMERIC except that it 
never tries to convert integer to real or real to integer.  The affinity is
only used internally - it is not possible to create a table column with this
affinity.  This affinity is used on subqueries and views that are built off
of a compound SELECT and where the datatype is controlled by a CAST expression.
dbsqlfuzz c9ee6f9a0a8b8fefb02cf69de2a8b67ca39525c8

FossilOrigin-Name: 44135d6ea84f7ba6b36549954b38a8bc048d5ffea5a9779e35950afa4eb2dfb2
 2022-12-15 20:03:08 +00:00
dan
118b53bd21 Fix an incompatibility between the Tcl interface and the "memdb" vfs by allowing memdb to accept filenames that begin with '\' characters. 
FossilOrigin-Name: bd537f2057a4800bd30e7dd57405c3e57df649471104c80bd32573a89568029e
 2022-12-15 18:56:12 +00:00
drh
f000c9b638 Omit the columnTypeImpl() function from the build when SQLITE_OMIT_DECLTYPE 
is defined, because it is no longer used in that case.

FossilOrigin-Name: 751e344f4cd2045caf97920cc9f4571caf0de1ba83b94ded902a03b36c10a389
 2022-12-15 15:37:52 +00:00