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
5db5c122ef Remove an ALWAYS() that can be false in some very rare cases. 
dbsqlfuzz 2274a23c85a93b870f7eb12fe686073da01abc33

FossilOrigin-Name: a4eb0b0d837291590958a5f292f41e80e0f722668a060aebfed5ea36ea176332
 2023-02-04 20:07:52 +00:00
dan
fb962837fd Updates to the testrunner.tcl script so that uses a separate sub-process for each test. And so that it runs the release test procedure currently handled by wapptest.tcl. 
FossilOrigin-Name: 4c3c587500ac5a3758008f0acb9432bd3bc6f0f31bacd5615f46280e55842982
 2023-02-04 19:01:17 +00:00
drh
ad1079e35c Better error message when trying to do an INSERT on an sqlite_dbpage virtual 
table.

FossilOrigin-Name: a98e4908dabc8f45f7859a26bd1d0c04de34ec68c1367c2cdd9b0242e08b938f
 2023-02-04 14:23:26 +00:00
drh
989d0cec5d Attempt to fix harmless compiler warnings that reportedly appear in clang 15. 
FossilOrigin-Name: c045d76b908a8c90d22511df7884e78d452b250db9ba70d4cb0935048a3c3ac4
 2023-02-03 14:57:40 +00:00
dan
60228cb3d2 Avoid using Tcl command [clock] in testrunner.tcl. 
FossilOrigin-Name: b2faf9289f6fbbcd4491e1b063da731b35aeed9ff1fc97f64798e99cac847b4a
 2023-02-03 11:32:51 +00:00
drh
2dd3b645b6 Improved and simplified logic for resolving the various aliases of the schema 
table.

FossilOrigin-Name: 5c19491c36b9e2128430e4f153bdef48c3f7b6541d44f36044e8fc2921ecc830
 2023-02-02 16:30:32 +00:00
drh
6f31eac7d8 Resolve all possible aliases and variations of the schema table names. 
FossilOrigin-Name: e7a0112b235d97cb68c92b967bf2218b90258c243ec2b638aaac142392873126
 2023-02-02 15:28:40 +00:00
drh
71a9339672 Adjustments of assert() statement in STAT4 in order to give 100% MC/DC. 
FossilOrigin-Name: 55a26c67ed4a3a937e009f60da2cd951d6f090b0bea748037db5c1680e5ff3b4
 2023-02-01 23:24:34 +00:00
drh
45ae9d6ba6 New assert() statements to verify that sqlite3DeleteIndexSamples() is always 
called with non-NULL parameters.

FossilOrigin-Name: 92c71fdd7167a7db055ef0aec522bbba8c7b4b37658efda10dac44699921b57f
 2023-02-01 20:45:12 +00:00
drh
54725efd80 Just because a CTE is used more than once, does not mean it should be 
tagged with M10d_Yes and thereby prohibited from participating in the
query flattening optimization.  See
[forum:/forumpost/1d571c02963355ed|forum thread 1d571c02963].

FossilOrigin-Name: 66f29c403d28630bfaea9124bd63ee4a047b1fe4a7e27dc5d10d67d1601b15e0
 2023-02-01 15:41:07 +00:00
dan
288409d731 Fix a comment related to PENDING locks in os_unix.c. No code changes. 
FossilOrigin-Name: 6b3546c871fe78a4e550e0144b48ac98325787cc8b192a9e7f5f2a2ffa57f76d
 2023-02-01 14:17:25 +00:00
dan
ca3aabdf53 Fix a race condition during hot-journal rollback that could theoretically cause spurious corruption errors. 
FossilOrigin-Name: 20ea53ddf590a9dd19501fabd2bfdb9c10b5eb265cd2995bdb335769c936c763
 2023-01-31 20:21:06 +00:00
drh
f7af9ba13c Additional tweaks to the enhancement at [609fbb94b8f01d67] to further reduce 
the cost estimate for constructing an automatic index on an ephemeral table,
in order to resolve the performance problem described by
[forum:/forumpost/1d571c0296|forum post 1d571c0296].

FossilOrigin-Name: bf1aae7a8c7f2c74681aa29baa35259d10ce6a1737d2607def6bf27fed592131
 2023-01-30 20:44:54 +00:00
dan
05a377fd46 Do not assume that sub-queries that contain window functions are uncorrelated. 
FossilOrigin-Name: f27804484df57de76be9dbd1a9e5869916617684ee407101c978df7da30b34ac
 2023-01-28 21:06:15 +00:00
drh
8cc8d36e4c Show more details about the SrcItem.fg field in tree-trace output. 
FossilOrigin-Name: 3d05dddd0bc826a73a8cecd6b116168082fb46b6e4868d03438c0a5a546d2f97
 2023-01-28 21:01:33 +00:00
dan
20438431c8 Fix a problem causing "PRAGMA quick_check" to return spurious corruption errors for a WITHOUT ROWID for which all columns are either virtual or part of the primary key, and for which the order of the columns in the primary key definition is different from the order in the table. 
FossilOrigin-Name: a7530f897127f35a212db6557edbcbbb286cc0e094754c1c1b74ce8dbf724470
 2023-01-28 17:37:37 +00:00
drh
f92b006a6e Add an assert() to help static analyzers. 
FossilOrigin-Name: e446c8b4aa2ffe075f9c289c771d62a414661c3ffe6abae5649c50af8e32fab6
 2023-01-27 20:15:48 +00:00
stephan
87ce1ff7f7 Merge trunk into wasi-patches branch. 
FossilOrigin-Name: 2ce89f5efcdb8b4c58eb2d30833a76d79ae0134c31d5ab8564be9e1cf5a1f4f0
 2023-01-27 05:37:24 +00:00
drh
3c12ebd4a3 Improved fix to allow sqlite3_vtab_in_first() to reliably return SQLITE_ERROR. 
FossilOrigin-Name: b25eec1c13f6a8c7ba993e5a55e26798f3b67a8b9571998459671cb570cbdfb4
 2023-01-26 02:18:53 +00:00
drh
e9b20a9c4b Defer calling the destructor for the user data on a module until after the 
module has disconnected.
[forum:/forumpost/b68391eb71fdff73|Forum post b68391eb71fdff73].

FossilOrigin-Name: 1ab122289fe6ac4cb3b0c47d17ac22627fcdfed80c941a57e6e6cc4d9dbd9273
 2023-01-25 19:05:04 +00:00
drh
b604f1456e Enhance the sqlite3_vtab_in_first() and sqlite3_vtab_in_next() interfaces so 
that they reliably return SQLITE_ERROR (and not SQLITE_MISUSE) if they are
invoked on a parameter that did not have multi-value IN processing enabled
via a prior call to sqlite3_vtab_in().  See
[forum:/forumpost/a823d4a3d5f73def|forum thread a823d4a3d5f73def].

FossilOrigin-Name: 144326dc171025dc8b5a77bebd8de3c19d5244ab807f5aa41f95313a25b880bc
 2023-01-25 16:56:24 +00:00
dan
f36fa4e902 Add scalar SQL function unhex(). 
FossilOrigin-Name: 890e9629a7480138c9c1d3acc2d1e7b3c05e0d156e5c5fba428bc1aeb790fbfb
 2023-01-24 20:17:43 +00:00
dan
a50db438eb Update unhex() to allow a second argument, specifying a set of characters that are permitted to appear between pairs of hexadecimal digits. 
FossilOrigin-Name: 66c8562690b19f17972589611810e1dccad3a48777acb05208289c1f77076f71
 2023-01-24 17:19:47 +00:00
drh
f648389a2e Suppress a harmless compiler warning. 
[forum:forumpost/e3f72e9291189925|Forum post e3f72e9291189925].  The code
was legal and correct. The revised code is actually less clear in its intent.
But at least now there will (hopefully) be no warning.

FossilOrigin-Name: 48bb7c88787bf5de1d70cf3cc81ada38c6c02e476dbdff12c8676c6d5ee19aed
 2023-01-23 21:41:41 +00:00
drh
c3f616597c Due to a coding error, check-in [8efd61e8518594e3] did not actually use 
just read transactions if the operation is read-only and the
SQLITE_MAX_ATTACHED macro is set to 31 or more.  This was due to a misuse
of the writeMask field of Parse, pointed out by
[forum:/forumpost/aa173c18d5|forum post aa173c18d5].

FossilOrigin-Name: 8760566893b64325874c7ec0aff8014026ce525e7fff1489027d2ce698495e76
 2023-01-23 20:45:47 +00:00
dan
e3c11d55db Add experimental user function unhex(). 
FossilOrigin-Name: dbe424b5db33ce2c7562dfb44daf2969cf3074234cc891eb9b8d0d907faf6a78
 2023-01-23 14:11:34 +00:00
larrybr
f75e485ea7 Give CLI .version a place in .help output. 
FossilOrigin-Name: 5f2dfdcc345453ee0a05311f6826d90b7c1d7b95fdaf77a0a8383923a8fc7213
 2023-01-22 21:54:17 +00:00
stephan
cdcb84ef00 Merge trunk into wasi-patches branch. 
FossilOrigin-Name: 6fc20d75d49310aedbc3351a4a5f1aa9ef5b4100501c7bfbe556aca2be2e44d7
 2023-01-21 12:18:28 +00:00
drh
3fdb05e883 Fix a memory leak in the TCL test harness associated with carray. 
FossilOrigin-Name: 5a316f9fd94b73fc54ef94a1dab2f13bdd16c4fb13d2620b7c907d104d5b4d7a
 2023-01-21 00:59:20 +00:00
drh
c1b54fa225 Fix harmless compiler warnings. 
FossilOrigin-Name: ded60f5b3431283d70eb8c41761c0fa9727021e6309d0df0ae3fb0a5274c1299
 2023-01-21 00:19:29 +00:00
drh
a96cd076fe Extend the carray extension to allow the use of BLOB values to be bound 
as an array of "struct iovec" objects.

FossilOrigin-Name: e117a03ca6560e958884f277db827c51ae337a970c17143a0a5f9b150f52f87a
 2023-01-20 21:00:03 +00:00
drh
42d652c047 Two branches associated with memdb are now always taken (I believe). Tag 
them with ALWAYS() to verify this.

FossilOrigin-Name: 20b9b5aa4fa6136059cf1123f00d86cb7bd8fb0f0f86f971e9714f22725e60b5
 2023-01-20 19:19:24 +00:00
dan
d993b15aa3 Ensure that the database encoding cannot be changed while there are statements running. And that the connection is left in a valid state after an obscure OOM within sqlite3_deserialize(). 
FossilOrigin-Name: a02da71f3a80dd8e817e89cdaa775c95e38c90d2471f8fec516bed086539e2c0
 2023-01-20 17:50:24 +00:00
drh
3601db8f86 The json_group_array(), json_group_object(), and fts5_source_id() functions 
should all be deterministic and innocuous.

FossilOrigin-Name: edcb83fa0d3c832d044b267d608fed31a2ac841b81c7c9406b2136ac43d61a1a
 2023-01-20 13:34:14 +00:00
drh
f06067f0b2 Change an now unreachable testcase() into an assert(). 
FossilOrigin-Name: 517b2c4c4ee9afc50e5457a6877e5af34358a6267d8dad669d25410c124866ac
 2023-01-17 19:00:22 +00:00
drh
d37aabe53f Fix harmless compiler warnings in the CLI. 
FossilOrigin-Name: 7cf282d307a23697b38f5fd4b46f13f63a9e6f7cc74ccd66297d88c00aa8f454
 2023-01-17 18:40:54 +00:00
dan
19ab86f3ff Update virtual tables json_each and json_tree so that adding "ORDER BY rowid" to a query does not require an external sort. 
FossilOrigin-Name: ce18f0ed684824e67ed6c09acab8e735fef2c52b2ed32270dee1a2a67802c59b
 2023-01-17 15:46:27 +00:00
larrybr
e8f114baa6 Cause .clone to not trip over sequence table as reported at [forum:/forumpost/71ff9e6c4c|forum post 71ff9e6c4c]. 
FossilOrigin-Name: b44d04f7b051d807a81152a6e4f15a765f7b9ed1f01b48b40dc5420c11e0c251
 2023-01-16 21:49:37 +00:00
drh
5b17533994 In the CLI, create our own private version of strncpy() to work around 
false-positive compiler warnings from Alpine Linux.

FossilOrigin-Name: 83f21285fe86430a66ce6841606e3ad7c27da52ac75a034c6a00c7a9fdb9791d
 2023-01-16 18:13:00 +00:00
larrybr
58abb646c5 Doc-only fix, per [forum:/forumpost/0cfaf6876b|forum post 0cfaf6876b] 
FossilOrigin-Name: eac135fd6a5dd220a0f7c1b61f987bbd801faabdb76846c4417fef0dd03fcb87
 2023-01-14 19:09:26 +00:00
drh
475e76d43e In expression nodes of type REGISTER with sub-type COLUMN, ensure that the 
iColumn field is set correctly, as otherwise the "IS NULL" operator might
be incorrectly optimized.  Fix for the problem described by 
[forum:/forumpost/d010a26798915b53|forum post d010a26798915b53].

FossilOrigin-Name: 0819a1869a39d54a405259ea323365506a182962a02affdef16a03446005da64
 2023-01-13 19:29:46 +00:00
drh
b928141edc Update documentation for sqlite3_progress_handler(). 
FossilOrigin-Name: 41b4c407b7f6968f4493fb9a0b220c55a6f6a353a8e6cb054efd3eb01bdd11dc
 2023-01-13 15:31:24 +00:00
drh
7ef26cbffa Remove an incorrect legacy assert(). 
FossilOrigin-Name: 3006b3b32fb1efedde3ade418c19c35b6e9a4af1e6a7cb5d5c72a080ec1f6f3c
 2023-01-13 11:31:49 +00:00
drh
94effc8a05 Reduce the frequency of calls to sqlite3ProgressCheck(). 
FossilOrigin-Name: 795aca4a269ea4ede547844037c218ac714c40e8bee003e4d9b786befc9cf97a
 2023-01-12 20:36:43 +00:00
drh
2fc9dc9330 Fix sqlite3_prepare() so that it only invokes the progress handler on every 
N-th call to sqlite3ProgressCheck(), where N is the progress handler step
count.  Also fix faulty asserts exposed by the ability to interrupt in the
middle of sqlite3_prepare().

FossilOrigin-Name: 05461651599bb490ac6cfd893645dabab9cccedc6adcce15aee2487b2ea6027a
 2023-01-12 19:51:49 +00:00
drh
f84cbd1676 Attempt to provide a mechanism to do early termination of long-running 
statement preparation by invoking the progress handler at strategic points
during sqlite3_parpare().  This experiment shows that sqlite3_prepare() might
leave the resulting prepared statement uninitialized following an interrupt.

FossilOrigin-Name: 79636f2d80aee70832913a78933da2a7e30cc037810b93903ebbc1925ea93fef
 2023-01-12 13:25:48 +00:00
stephan
a7c498599f Merge trunk into wasi-patches branch and add missing yes/no result to the configure script's output for the --with-wasi-sdk=PATH test. 
FossilOrigin-Name: adc0ede0a43241b85563408d0de8e640a75ec4f7bdfe5e48acc5cdd6b182b88c
 2023-01-11 22:45:20 +00:00
drh
8518eaccd7 Fix duplicate semicolon in btreeInt.h. 
[forum:/forumpost/8db1711ca2|Forum post 8db1711ca2]

FossilOrigin-Name: 7526c46632578a2b602622b9debc406b52af4a42cc880970c4307d13853d59d3
 2023-01-11 20:52:15 +00:00
drh
d2467a89fd If OP_Rewind has P2 of zero, that is an assertion that the table is never 
empty.  This fixes a false-positive in the out-of-subroutine jump detection
logic added in version 3.39.0, and which was causing the assertion on the
previous check-in.

FossilOrigin-Name: 33fd9997ebb88f0d78522c036e75aef08015d31d28b1cbee08ae7c4cd5ecc6aa
 2023-01-11 17:50:24 +00:00
drh
d2b11786e8 Add an assert() to the byte-code engine that goes off if the OP_Halt opcode 
is invoked with SQLITE_INTERNAL.  This causes the RIGHT JOIN error
"Opcode jumps to ... which is outside the subroutine ..." to fail immediately,
causing it to come more readily to tester's attention.  There is at least
one testcase in test/fuzzdata8.db that asserts due to this change.

FossilOrigin-Name: b8f994414285264f4f7c472dfad646a061fc3580b754eac0f20080c24ecc256d
 2023-01-11 16:44:57 +00:00