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

31213 Commits

This Branch
This Branch
All Branches
Author SHA1 Message Date
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
1b7b75679a Enhance the sqlite3_load_extension() so that when the entry point is 
not specified, after trying sqlite3_extension_init() and
sqlite3_X_init() where X is the alphabetic part of the base filename,
if neither or found it tries again with X as the alpha*numeric* part
of the base filename.  Hence, a shared library named "vt02.so" can be
loaded with just ".load vt02" and without having to specify the entry
point separately.

FossilOrigin-Name: acc95f24cc034408de1e9225aef4dae8bf76beec812c152bea32db95f7d2b854
 2025-12-18 14:01:43 +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
89bc8e8a34 Fix a FILE* leak in the CLI 
FossilOrigin-Name: 7986a35d27fe0cfd7d9a3bfec0ee0d1c5556b24d571bb68c35dd5eb7251e423c
 2025-12-17 13:10:23 +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
97601244e2 Enhance the vtablog extension so that it shows the value of 
sqlite3_vtab_distinct() in xBestIndex, and so that provides the new
consume_order_by option that can cause xBestIndex to set the
orderByConsumed flag.

FossilOrigin-Name: b158fe929929ae209f2603b11a2c4f44ad9147f6b2ce09a10ec1f92429402631
 2025-12-15 17:32:56 +00:00
drh
22546e1d7e Clarify the affect of nCharLimit, nLineLimit, and nTitleLimit on the 
xRender output from QRF.

FossilOrigin-Name: 881534858de8bccffca53e7256a725378a98a354e792374d972b120880c2ae78
 2025-12-15 13:58:41 +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
76f1fe2942 Use the correct wildcard character in sqlite3_strlike() in the previous 
check-in.

FossilOrigin-Name: 87bca1250c5e660debbb29c5fabb89082c2d2059fc8b5851e1b1a519c3be7fc1
 2025-12-13 23:18:04 +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
drh
d031267c17 Add new assert() statements designed to detect and prevent the kind 
of system interface numbering errors that happened in [108691a3cb2f296f]
and that were not fixed until [fe49703034bd23fa].

FossilOrigin-Name: 4e6e551c89c4f18299b3d60369f439e80f2fe2b0e70199f649821b1dbf20c668
 2025-12-12 12:06:42 +00:00
drh
48915e7c7d Omit unused entries in the aSysCall array for the Windows driver. Fix 
incorrect numbering in alter entries of that array.

FossilOrigin-Name: fe49703034bd23fa8f43ffdf0e23ec9613688d957adf96b3f1ea86fb02a8d86b
 2025-12-12 11:50:37 +00:00
dan
462289df52 Remove from os_win.c a reference to unused system call CreateEventExW() left over from the now removed winrt support. 
FossilOrigin-Name: c68ef69ec97da0312b95375b3af159f8a06ce1a69376d042c557dcca18d3f77e
 2025-12-12 11:02:18 +00:00
drh
63f1fb40be Fix an inaccuracy in the qrfRelaxable() routine in QRF when the input is 
an empty string.

FossilOrigin-Name: eb8a519571f7d35b81cbdbe668da45b33e5505d9a038305129df7ba2c16fd3b0
 2025-12-12 10:21:52 +00:00
drh
5eba66ad66 Include the latest Makefile.msc changes and the new "make.bat" script 
in the amalgamation tarballs.

FossilOrigin-Name: 6deab75874acfa183e51b8ae8d9305e8d09072bb6c646859ed40beb46e91fe0f
 2025-12-12 00:21:10 +00:00
drh
c2cd606f8a Prevent a malicious delta from causing an integer overflow in the 
fossildelta extension.  This code is not used in the SQLite core.

FossilOrigin-Name: 01409738afc2c0d5bdaa248ffb508aa5f36a66390f6b8e4834734529ee8ed2fa
 2025-12-11 23:24:05 +00:00
drh
b304b0d165 Update build instructions for Windows to explain how to link against 
ZLIB.

FossilOrigin-Name: e785a80e4100c368dca8d73cb662cff4d0fd76734fa0f3fa9b5754a380f7c746
 2025-12-11 18:16:39 +00:00
drh
e29acd77c3 Adjust the MSVC Makefile so that when it invokes the zlib makefile, it 
changes CFLAGS to use the correct -M compiler option to match SQLite.

FossilOrigin-Name: ba003c7c74fb4dd665a8ec6dea7d030f1e7e9cbb13e60bb728860ebffdff5aaf
 2025-12-11 17:49:17 +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
c0160fa11a Use macros for the default values for QRF limits in the CLI, rather than 
hard-coded magic numbers.

FossilOrigin-Name: 4ef66da15bfe69d940cfbeff2be2b7e13da156495b349b453d68e70f4dcca36a
 2025-12-10 19:43:06 +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
stephan
3262f769ee In fiddle, remove the default .dot-commands it runs, as they do not reflect current shell defaults. 
FossilOrigin-Name: 27b6aeda5d70e3480b1448b06277a19395b30a205f3f3bac5ce0e4102e3849ed
 2025-12-10 16:20:44 +00:00
drh
2f2b5d7b20 Add the --titlelimit option to CLI, defaulting to 20. In "line" mode of 
the CLI, the default seperator is changed from " = " to ": ".  This can be
overridden using the --colsep option.

FossilOrigin-Name: 291677ebb3e5c2fe00e4340d8d3661fde6bd18494f1d4e56da1efcf613ab21b6
 2025-12-10 16:10:26 +00:00
drh
9d5f00706f Do not show the --titlelimit setting in ".mode" setting output unless -v 
is used or unless the current style is tabular or line.

FossilOrigin-Name: a9b0a3ce043fc910465d676c72bcf44c2ff6fbc1b0a832106cd2d3f97c7fb16a
 2025-12-10 15:55:44 +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
dan
b4f6c09e60 In fts5, avoid holding an open blob handle after an INSERT/UPDATE/DELETE statement, as this can interfere with sqlite3_interrupt(). Forum post [forum:/forumpost/95413eb410 | 95413eb410]. 
FossilOrigin-Name: f88e1d03573f394fc7caf60704c96152717b3fe8be4eef0caeb64737054f0fd2
 2025-12-09 13:41:01 +00:00
stephan
567dcbb5db Update the added-in-version stamp to some kvvfs JS APIs. 
FossilOrigin-Name: 939275c6c574a3354e0626164aab1a005998f811c53a66b078249d6b2fcbd68e
 2025-12-08 13:11:17 +00:00
stephan
91479c6b10 Introducing kvvfs v2 for the JS bindings. Summary: no longer hard-coded to session/localStorage, available outside of the main UI thread (non-persistently), a simpler-to-use import/export API, and adds an asynchronous event interface intended for creating page-by-page db backups. 
FossilOrigin-Name: ec866b04d088e53b09764d00f5403902785328fd8f3cbf80d3affa166477711d
 2025-12-08 13:06:27 +00:00
stephan
50ef2f7813 Replace some double-quotes with single quotes an SQL doc snippet in the csv example virtual table. 
FossilOrigin-Name: 1781e5e8d0cd2b508f7992987257416bd48841ea7e30bc9294784a7c1a402be7
 2025-12-08 12:24:23 +00:00
drh
1241fe1450 Minor tweaks to the QRF documentation. No changes to code. 
FossilOrigin-Name: b2517d01e65b34ea4ca52c9149d7b255a36a45a50b332cb8ccfdacf22e629be2
 2025-12-07 18:19:22 +00:00
drh
ee9f4acb10 Do not return too many bytes from the zipfile extension given a malformed 
ZIP file.

FossilOrigin-Name: 9766b47beb9ec72f55bfe9fa6e4dadf1829848389388aa30e97094a325de17fa
 2025-12-06 23:58:09 +00:00
drh
5a05c59d4d In the zipfile extension, only return as many bytes as Inflate actually 
generated.  [forum:/forumpost/761eac3c82|Forum post 761eac3c82].
Adjust ./configure so that it builds zipfile into testfixture if ZLIB
is available, so that tests get run on unix platforms.

FossilOrigin-Name: 3d459f1fb1bd1b5e723629c463ab392af7b206ece3388bda216c6a4c26160909
 2025-12-06 20:41:24 +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
97b5c8c624 Fix a harmless compiler warning inside an assert() in FTS3. 
FossilOrigin-Name: 005e176b4e5b3a28865b08c23d6ecd2c76c036b9c6b2075e6d7bfc584d3c433e
 2025-12-06 18:40:14 +00:00
drh
6cc0da6e7d Fox the "box" format, use rounded corners and use a double-line to separate 
the header from the content.  Add the "-quote relaxed" text rendering mode
and make it the default for TTYs.

FossilOrigin-Name: b3da6a8728641a0c9ca2f3b20c9817c0a2be6c5bf05f020590547480d2aff0e0
 2025-12-06 11:54:43 +00:00
drh
4ccd61107f Fix typos and harmless compiler warnings. Omit the use of ctypes.h in QRF. 
FossilOrigin-Name: 4f7edadbdeeb4baee2e4a4703def6e258ce00f54684343b73380e7c69165892e
 2025-12-06 11:50:36 +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
cff66960fd New text rendering style of QRF_TEXT_Relaxed. 
FossilOrigin-Name: d2049bffe6674b8840663b0e5f404a040b715640c87f022517cf11546548fda3
 2025-12-06 10:07:15 +00:00
drh
a3647d17c8 When drawing boxes using QRF, use rounded corners and use a double-line to 
separate column headers from the content.

FossilOrigin-Name: 8c1ca30707c36f074dad29556df4176a74aa573491bb4aad973789aee5ad80da
 2025-12-05 22:04:49 +00:00