bahman/sqlite
1
0
Fork 0
Code Issues Pull Requests Actions Packages Projects Releases Wiki Activity
31,213 Commits 1,672 Branches 385 Tags
json_array_insert
Commit Graph

10014 Commits

Author SHA1 Message Date
drh
4720c16223 Raise an error if any PATH argument to json_array_insert() is not the path 
of an array element.  Add some test cases for json_array_insert().

FossilOrigin-Name: 96b7d2c60a3f8a9f9d69313bad599a3a5ad335cb382263e4254e2d20929d5e55
 2026-01-17 19:01:37 +00:00
drh
9dff6ac96e Try to prevent false positives in fuzzinvariants.c due to scalar subqueries. 
FossilOrigin-Name: c20be882a62e75abc50fd2dcae26ebbe83a01f09369525392fa22223627a04ea
 2026-01-16 17:48:46 +00:00
drh
4dd1a202de The optimization at [8bdda827a3d26800] is incorrect for the case where one 
of the two expressions has been commuted such that the collating sequence
has changed.  This check-in fixes the problem.  Problem reported by
[forum:/forumpost/2026-01-16T11:35:28Z|forum post 2026-01-16T11:35:28Z].

FossilOrigin-Name: 9d8fb7a9e23d5ef76d05824401976247debe51be6f658f132609257a068a73de
 2026-01-16 15:53:20 +00:00
drh
43eb1d4d22 Adjust the output of the fuzzcheck test program so that testrunner.tcl can 
capture the number of tests run even when the --slice option is used.

FossilOrigin-Name: dddaeff4ce552f3aa57cc6e18ed35051138b591338242df5f3af39e24006a834
 2026-01-14 19:22:36 +00:00
drh
e5fba7f094 Guard against oversized index entries in databases larger than 2GiB. 
FossilOrigin-Name: ed17a878e5a2e0cd1e9b69d528f5ac2ba8452d7c83deaf3cc72ecbff054f5ca3
 2026-01-14 13:43:32 +00:00
drh
35b9709d46 Fix integer overflow problems and error reporting memory leaks in 
the zipfile extension.
[forum:/forumpost/2026-01-13T00:09:06Z|Forum post 2026-01-13T00:09:06Z].

FossilOrigin-Name: 8e656a483557bc5385219d560b9155c232e7dc9d62642249abc879fb37bacd2a
 2026-01-13 02:35:19 +00:00
stephan
2f47a58c5d Update speedtest.md to point out xdg-open on Linux. 
FossilOrigin-Name: 47c7fbcb46df5a657ec76dff9a370aea9e7d0d95406b1e124e9fe527cf85350d
 2026-01-10 14:12:40 +00:00
stephan
644c42f3a4 Fix a help text typo in speedtest1.tcl, pointed out off-list by BrickViking. 
FossilOrigin-Name: 1fd02a75a914f131948fe06fc99f851d3e226f9f1270e25393d79c493c28a347
 2026-01-10 00:38:00 +00:00
drh
03c0ac435e Enhance QRF so that it terminates more quickly if it encounters an OOM 
or oversize string error, and fix it so that it reports such errors.

FossilOrigin-Name: ebedeb6169cc3bc3708130d4061065af600a8851e896fc3eeaf33c8c83fe3b95
 2026-01-07 16:19:18 +00:00
dan
55f258bd27 Update the regexp extension so that the "-" character may be escaped with a backslash. Forum post [forum:c5e7358f82 | c5e7358f82]. 
FossilOrigin-Name: 80013129361fb81ce5db1f6390cad640c2cb547e5ba16724dfb55d0aceecdf6d
 2026-01-05 18:29:07 +00:00
drh
904abc85cf Fix yet another bug in the [/info/e33da6d5dc964db8|EXISTS-to-JOIN] 
optimization, reported by
[forum:/forumpost/2026-01-03T14:05:48z|forum post 2026-01-03T14:05:48z].

FossilOrigin-Name: f60e863e0ca2d8ab853fa5f48d3cd7b062b13167fcddffc4563bde9285b92320
 2026-01-03 15:11:07 +00:00
dan
a0cc06b66b Ensure that loops created by the exists-to-join optimization use unique cursor numbers, even if the EXISTS expression in the WHERE clause is a copy of an expression from the result-set of the SELECT. dbsqlfuzz 4f6a5213cf74fcf2a8a3e48abc2333100348c38e. 
FossilOrigin-Name: 19e57a18cbfad44bb1cb1e62d4485635d26059cb2319f4b7f1244df2638bea43
 2026-01-02 17:10:40 +00:00
drh
db4d8946ef Verify the effect of "--titles on" in the "insert" mode in the CLI. 
FossilOrigin-Name: a5f922b0832d9544b083f3d55d4029aa80e320bf5505547c5a1ddb21f4685e3e
 2025-12-31 20:43:31 +00:00
drh
f395df1307 The header setting from the legacy ".headers" dot-command takes precedence 
over the current ".mode" setting, for backwards compatibility.
[forum:/forumpost/2025-12-31T19:14:24z|Forum post 2025-12-31T19:14:24z].

FossilOrigin-Name: d2c5df41285a9c8a66e9bdea4e28d86fe10665ad01cfbab5a7ce43b8e39b4e34
 2025-12-31 20:35:16 +00:00
drh
d964b8cfa3 Add the new "retest" command to testrunner.tcl, which reruns any tests that 
failed or never completed in the previous invocation.  New makefile target
"retest" for both unix and Windows that runs testrunner.tcl with "retest".

FossilOrigin-Name: 9b668d56bf0eca3eb826df3edd6705cc809d920494c192a9949cafda791d83f9
 2025-12-31 17:21:30 +00:00
drh
634a915132 Enhance testrunner.tcl so that it can always be run from an ordinary tclsh 
as long as that tclsh can load the sqlite3 package.

FossilOrigin-Name: 1a08b85a862e8c9ac56c11e05f76abc25ad98b510fb13ad0716206ba797e53a8
 2025-12-31 14:17:51 +00:00
drh
31f6052f03 Fix test/shellB.test so that it works under Device-One. Also bring the 
header comment of shellB up to date.

FossilOrigin-Name: 836d02468c7749fa9cdb656c9f80cfef9a41e2eb1321d4bb56c0e0cbc5f37df4
 2025-12-31 11:46:26 +00:00
drh
03380a55a5 Fix a typo in [0819fe670f9ceec7] that lead to incomplete protection against 
buffer overflow in the zipfile extension.
[forum:/forumpost/2025-12-30T23:57:19z|Forum post 2025-12-30T23:57:19z]

FossilOrigin-Name: a6abbadacbb88c1ddcc236b40fb34eddf3bb0891189bd00a5af8d34b42871967
 2025-12-31 01:01:14 +00:00
drh
9924b07cc2 Fix the new .import logic in the CLI so that it honors ".bail on". 
[forum:/forumpost/6c1c0e213d|Forum post 6c1c0e213d].

FossilOrigin-Name: d58846e74b6971a5fd80e5f030985273b7dfa0087c2f3c9d0c088c248e183f8a
 2025-12-29 23:56:05 +00:00
drh
fb795dbe73 Fix error messages associated with .import, along with corresponding 
test cases.

FossilOrigin-Name: 2084e805d0d9da8f419b8506fccd652a7d20262bd95729250a2d2eabfdd079ad
 2025-12-29 21:39:48 +00:00
drh
7dfb1431dc Incremental improvements to .import, and new test cases. 
FossilOrigin-Name: 5a1e931b19c346bdc8d1a51fa6ef8ee04b7371cdf5df2ee32e1333226c42d327
 2025-12-29 19:04:41 +00:00
drh
6693e78772 Test cases for .import, as well as minor enhancements to .import and to .check. 
FossilOrigin-Name: 0252ac1c946cd2101f0084f11951b1aeea330dea23b707934c8852d9abe136b9
 2025-12-28 21:37:58 +00:00
drh
38c8014940 Improvements to the .import command of the CLI. 
FossilOrigin-Name: 436ed7937bcd3b5781539d883ff2957b81d74abccb75f65a2ffb7446a5944522
 2025-12-28 14:01:52 +00:00
dan
4056656047 To ensure that the sqlite3_hard_heap_limit() call it makes is effective, add "sqlite3_config(SQLITE_CONFIG_MEMSTATUS, 1);" to fuzzcheck.c. 
FossilOrigin-Name: f7736af849d910f04d8622ed7c6e705d84cf22f0a73dca0f30eead9bd1f28bc7
 2025-12-26 17:23:25 +00:00
drh
683df60dbf Enhance the omit-noop-join optimization so that it is able to omit a 
chain of noop-joins.  Optimization improvement suggested by
[forum:/forumpost/11a53f2bad|forum post 11a53f2bad].

FossilOrigin-Name: 5a85b83b9f21ad88938e273bb35b398e91133424683e915836f322b69f277673
 2025-12-24 14:03:15 +00:00
dan
add73c831b Add the SQLITE_PREPARE_FROM_DDL flag to sqlite3_prepare_v3(). Use this to prevent fts3/4 tables in non-trusted schemas from calling unsafe SQL functions. 
FossilOrigin-Name: 26f39ac806a5582fab1497e38a4ce68dad2b79df8c8aade43c4e21eed7576931
 2025-12-22 15:22:02 +00:00
drh
683c563241 Bug fix in the vt02.c test virtual table. 
FossilOrigin-Name: a7a73d30c552195c95c282688eb3d067746c722b702c7f2ba151996ec92136f5
 2025-12-18 20:44:48 +00:00
dan
65bc1f0ff4 Allow queries that use "GROUP BY e1 ORDER BY e2" where e1 and e2 are identical aprt from ASC/DESC sort-orders to be optimized using a single index. Also allow virtual tables to optimize DISTINCT in cases where the result-set of a query does not exactly match the ORDER BY clause. 
FossilOrigin-Name: fba29a8b560d839e42c2a46421ab870da6e6ed6e15a17aa51f223e32ec3aa8ae
 2025-12-18 18:47:49 +00:00
drh
ae66a8d760 New options for vt02.c that allow tests to configure it to partially 
de-duplicate a DISTINCT query.

FossilOrigin-Name: 1c65bb6e5d92cf39c409b7f870253571ec96b48abf87e5ed931cabd86f582069
 2025-12-18 16:14:38 +00:00
dan
ce46f82bc4 Improve tests in bestindexF.test. No changes to non-test code. 
FossilOrigin-Name: 347d4d34c1815827e7049e57830c1fff67f6eb16ae5cc00839e35d94bac81e92
 2025-12-18 16:05:05 +00:00
drh
4461335b00 Better orderByConsumed logic in the vt02.c test virtual table. 
FossilOrigin-Name: 612c1ece6752e3318fc688717ad6a82219b85df7d32e4e07dbc2f361a5aeeee4
 2025-12-18 15:35:50 +00:00
drh
93c6b19f92 Enhance the vt02.c test virtual table with the ability to process 
ORDER BY DESC.

FossilOrigin-Name: 35461a8d5a103e373e5b38b3974a3bb1074e914e862825108713b36bef04b6bd
 2025-12-18 12:49:44 +00:00
dan
6c2f5dabf4 Fix the return value of sqlite3_vtab_distinct() in cases where a virtual table query has similar GROUP BY and ORDER BY expression lists. 
FossilOrigin-Name: d017ae8640f24543ad5bf37a3e514c1e919730b8c686255c61890448ba22b3e1
 2025-12-17 21:00:06 +00:00
drh
93ecf30068 CLI: The .imposter command matches the index name regardless of case. 
Minor fixes to .check.

FossilOrigin-Name: 989ebba9ad263abafeddaf4a0e3e1275e83a3a12d7f95c7a451ecf8cbd64a583
 2025-12-16 13:43:35 +00:00
drh
6c26b5db71 CLI improvements. In the .check command, ignore leading and trailing 
whitespace unless the --exact option is used.  In the .limit command, do
not print the new limit when changing the limit, but only when requesting
the current value of the limit.

FossilOrigin-Name: d72cb66d672d514822b2fbb0be8880377628599f1f8e2a219d36791c125c6242
 2025-12-16 13:25:45 +00:00
drh
28ec7be607 Stricter enforcement of the LIKE_PATTERN_LENGTH for the regexp extension. 
FossilOrigin-Name: c94b1e9c5674f7d0ad75d91085262f38cba6036979e8a0f9d39edc7db841915f
 2025-12-16 13:13:21 +00:00
dan
a1dbb7a93e Fix for optimizing "SELECT DISTINCT ...cols... FROM vtab" in cases where the virtual table implementation is able to deliver results sorted by "...cols...". 
FossilOrigin-Name: 80c0d922937615422e813593ac4eb83c3040a417fad97dba18a549de50a91b72
 2025-12-15 18:45:22 +00:00
drh
586a649698 Fix the test/vt100-a.sql script to use .testcase and .check. 
FossilOrigin-Name: 5cf9e99ff8279530cb73a24794107591f8dab755fe78acd6c11429e532f3d1bf
 2025-12-15 13:26:27 +00:00
drh
e2bb4cf412 Enable an ORDER BY clause to refer to columns in outer queries. 
FossilOrigin-Name: ef9b4b1e4690c889c48f4e725d42127c46f60c6bf2023ae79bf1e9c6c83368ec
 2025-12-15 11:59:47 +00:00
drh
5266818aed In the CLI, if a command-line argument names a file and the filename ends 
with .sql or .txt, then process that file as an SQL script.  Use this
feature for better testing.

FossilOrigin-Name: 19cc0522e2255f21f6fb6af1442c2ba122fdd4deacd9ea2c181ce9e597b88770
 2025-12-13 21:11:49 +00:00
drh
ce43bf85fa Back out the --compat option from the CLI. 
FossilOrigin-Name: 850d5dbfb0f1eacd1e5213759810ec7e5eba4fcc0b2718dabccd5b269b126f1c
 2025-12-13 00:13:40 +00:00
drh
4f3ab29aab Get the .testcase and .check commands working in the CLI. 
FossilOrigin-Name: 1ca31e1a297c0d53d068afb658ce6602887cda0f3eaf42cd629c4d1b7204f0b0
 2025-12-12 18:22:07 +00:00
dan
9334b9f1b8 Fix calls to sqlite3_wal_checkpoint_v2(SQLITE_CHECKPOINT_NOOP) so that they do not return SQLITE_MISUSE. 
FossilOrigin-Name: 117f4093f08e0abbde2041f70898220e237e250664f6ede6d4eb2a8a44050466
 2025-12-11 11:05:26 +00:00
drh
85fb541ac0 Various improvements to the .mode command of the CLI, and especially to how 
it handles the --limits option.

FossilOrigin-Name: f883b854976d2aa679c87edce3b577f38b5fa518f707706320d1ddb38365e2dd
 2025-12-10 19:04:49 +00:00
drh
1debc25ef8 Test cases and documentation tweaks. 
FossilOrigin-Name: cc9e47a205883aedf24b5e85e8e0499567f514780e3e6ec58069a39ea6270133
 2025-12-10 15:50:23 +00:00
drh
9bf37cc3eb Add the nTitleLimit option to QRF. Also change "line" style so that it 
uses zColumnSep as the divider between the title and the value.

FossilOrigin-Name: d67a299c86ff80ed67857d2546b0edaf852cb23dbfbc15e24793d1c4860a2e50
 2025-12-10 15:24:46 +00:00
drh
4a33eed6e9 Remove #ifdefs intended to make SQLite compatible with Windows RT. WinRT 
was short-lived and has been discontinued for a long time.

FossilOrigin-Name: 108691a3cb2f296f0ede06c34271ee185f299bfd76e97a1bd06c730a28d94ff4
 2025-12-06 19:56:40 +00:00
drh
4ddf151841 New test cases to cover the "--quote relaxed" feature. 
FossilOrigin-Name: d00d9556edc198d49cf9aa2f14e46bb5b1021ef0622aee1fa4ae585ed9a13a98
 2025-12-06 11:35:30 +00:00
drh
5fb9d599ed Update test cases to work with the new box format and with --quote relaxed. 
FossilOrigin-Name: e3f442d08f455e0aa260cc8db4922a5f611e17afe71b0bb251328ab4b3ad46ca
 2025-12-06 11:02:14 +00:00
drh
14706ff98d Minor adjustment to the zipfile.test script so that it works on Windows. 
FossilOrigin-Name: 7bb633df97678b98515e603c5154ffc5b54055cff187d74a2c5d010e5b3720d1
 2025-12-05 15:09:42 +00:00