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
d3c9cce43c Enhance the timestamp-vfs prototype so that it also keeps an event log. 
FossilOrigin-Name: f087c6c0cdd542ec24b4668fff9cb434f46caf554f8856a49fd062ab3f72014e
 2026-01-06 20:51:06 +00:00
drh
bcf1c8d6e3 Update to the sqlite3_get_clientdata() documentation. No code changes. 
FossilOrigin-Name: 395b7168b873390c05ea2cc71fe14bafb5bdee77f32a047bec8d7ed6feb9ed90
 2026-01-06 13:00:24 +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
bb4428e605 Add the experimental tmstmpvfs.c extension that adds a timestamp and other 
debugging information on each page of a database as that page is written,
if the database is configured for exactly 16 bytes of reserve space.

FossilOrigin-Name: 703e593dfc92676a2d44c67ca8282a78a1943b9c1e3f2447c0a9917d70a383c4
 2026-01-05 17:28:33 +00:00
stephan
b1e9111249 Fix an uninitialized var use reported in [forum:88561a4a1e|forum post 88561a4a1e]. 
FossilOrigin-Name: 707c0f6442e946f23de061ee2753eb5994ab55d411c49b232799f309ba0f10cf
 2026-01-04 11:05:05 +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
drh
0ed2541168 Minor change to an #if in the Windows VFS, which I am told will allow 
SQLite to be compiled for 64-bit Windows7.

FossilOrigin-Name: 2afc54b91fe94a37bd3754b5beae6b1f378488b33f7d23eeeebe96d78d120fe3
 2026-01-02 19:42:55 +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
2b112e0907 Change the shelltest target on the windows makefile to use testrunner.tcl 
FossilOrigin-Name: db4d07623500325153c3254c2ad9eaf5e0f1d056637c6799643fcc9bb3a5e84e
 2026-01-02 00:23:22 +00:00
drh
b0a1ed2980 Further improvements to testrunner.tcl documentation. 
FossilOrigin-Name: c71402031ce81b4415a793afa3152f5691b197dce634c1322948f39086b8c819
 2026-01-01 21:35:25 +00:00
drh
6e8afa79e7 Updates to the testrunner documentation. 
FossilOrigin-Name: bcac99f962c6403fddfcaeef309ea9f825fa661fee0b3e3fd24f04c861be1d1b
 2026-01-01 15:41:50 +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
02e38b4d21 In the (completely unused, as far as I know) btreeinfo.c extension (not 
a part of any standard build) do a better job of detecting corrupt database
files and provide better error messages when corruption is detected.
[forum:/forumpost/e66a458339|Forum post e66a458339].

FossilOrigin-Name: 326d29ac7ecd933d6fca80d3d538783ed46939e7bc6e3aa60ded4b619aa73730
 2025-12-31 19:45:45 +00:00
drh
6789770822 Use 64-bit integers to track memory allocation sizes in the CSV extension. 
[forum:/forumpost/e66a458339|Forum post e66a458339].

FossilOrigin-Name: f293a2b3ffcfe20fcda954bd31e88bbfcba18d007e9b5f29a473983f6030f2ce
 2025-12-31 18:30:45 +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
f8bd7df996 Use sqlite3_malloc64() in all places in the compress.c extension to avoid 
integer overflow.
[forum:/forumpost/2025-12-31T01:04:00z|Forum post 2025-12-31T01:04:00z].

FossilOrigin-Name: 7ceaf1f0c3d9b96d2224ce6526fb3092b9e1673573e3d7dd898b2a135e23027d
 2025-12-31 01:19:51 +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
d32e21ac95 Fix the output from the (undocumented) --test-argv option of the CLi so 
that it correctly displays UTF8 text on Windows.

FossilOrigin-Name: 39e15ce3d6c42b13d0c1164a161e7b5d5d8382050c2729961733ddef695c9116
 2025-12-30 13:10:10 +00:00
drh
9f44bc5ea0 Add missing free() to winmain.c 
FossilOrigin-Name: 44dff1a1bb986cd08b729d4b73f09c995cbc67f884caa297674b31fb36805c8b
 2025-12-30 13:01:05 +00:00
drh
02ceb91875 Improved handling of the process entry point in Windows, to translate 
arguments into UTF8.

FossilOrigin-Name: 1d4ee6c35e69d43e2b801c425308de0ef5d5d9d2d0af9b406b664bf0f9cfa337
 2025-12-30 12:38:43 +00:00
dan
918efe3cce Avoid signed integer overflow when an fts5 'merge' command is passed -2147483648 as a parameter. 
FossilOrigin-Name: 52738908b04848b93d54431def37ffaa9723043270ff8ba1e2fa59ab0040afc5
 2025-12-30 11:36:23 +00:00
dan
01f2907d48 Fix the change on this branch so that it works with amalgamation builds. 
FossilOrigin-Name: 7f0b9e7a8bba1b73ef16257e72a055ea84fb10eb5cf0e6431fca81b2f040c5ee
 2025-12-30 11:33:30 +00:00
dan
6e92494955 Avoid signed integer overflow when an fts5 'merge' command is passed -2147483648 as a parameter. 
FossilOrigin-Name: 4c5d18d7f5bdcf95efdf96062c7434d5d10584a1fdfd65b18d331b8aae42e26a
 2025-12-30 11:19:27 +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
bd91ba71d5 Update to the unix build documentation. 
FossilOrigin-Name: 004cf4ad3cb0c05e501a464bee55e8ed168c4825cf419902890593468ca4d588
 2025-12-29 12:46:35 +00:00
drh
ce36cccd36 Fix the "testfixture" makefile target so that it builds with a static TCL 
library on Mac-ARM.  Fix the "tool-zip" target so that it uses ordinary
tclsh rather than testfixture to run the tool/mmktoolzip.tcl script that
builds the archive.

FossilOrigin-Name: adf5d624cf109ebd05952e5df62f143f40829070cbcbe43280d371a60db7470b
 2025-12-29 12:34:37 +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
c00c0a8392 If the filename argument to the .import command is of the form 
"<<endmark" then the content is read from the script (or stdin) until
the first line that begins with "endmark".

FossilOrigin-Name: 6e8ab51fbe0ee918bce6ab960c9fb078764aa9721ef41d39818127eb98045d46
 2025-12-28 14:32:28 +00:00
drh
38c8014940 Improvements to the .import command of the CLI. 
FossilOrigin-Name: 436ed7937bcd3b5781539d883ff2957b81d74abccb75f65a2ffb7446a5944522
 2025-12-28 14:01:52 +00:00
drh
35f37ec959 Change a single integer variable to 64-bit in the tokenizer to avoid 
any possibility of an integer overflow.

FossilOrigin-Name: 69cf692a24d714305b2e4c8c4c40f70dc6510c26b8db7e5249f32a53e44c7e5c
 2025-12-27 19:57:59 +00:00
drh
7f56d23f9c Work around the Windows "Worst-Fit" bug in the "sqldiff.exe" program. 
FossilOrigin-Name: f41851587328f8b434e66987765324b7bf5746ecdf3a9f2869000276e0f79401
 2025-12-26 20:13:32 +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
stephan
91d0ffa576 Doc typo fixes in the configure script pieces. 
FossilOrigin-Name: 8ab37d9fb909dc6bfbede004f342e6c1625c99df9b316807dc77a9a636ee6873
 2025-12-24 18:12:08 +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
drh
337fce82f0 Additional changes to support the ".schema" command on builds that omit 
virtual tables.

FossilOrigin-Name: 6b5c0374fa81cf069263bebf9b740573de4f82fde3c4e5796af80dcbe6a1a2e7
 2025-12-23 17:24:10 +00:00
drh
f256886b8e Fix the ".schema" command in the CLI so that it works on builds that 
omit virtual table support.

FossilOrigin-Name: b4e3c8170a107b2018fe5374495dbec14c851ccbf7419cd382991b2fe68c45e4
 2025-12-23 16:51:49 +00:00
drh
8511ee1e19 Harmless typo fixes in shell.c 
FossilOrigin-Name: 519877cdbde80071ac08f2e467ef8b9679816dc486cf6eb87ec2d9a38c819f88
 2025-12-23 11:13:52 +00:00
drh
766389bd65 API documentation enhancements. 
FossilOrigin-Name: 99ac94cb9a7a76312cda2d236dcc0c92b2ca269456daed06a1c2674c4f326867
 2025-12-22 17:06:37 +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
8d41b94bb4 Fix spurious error log reports caused by [d25c8a6222d4e3f2]. See 
[forum:/forumpost/d2326687662430c1|forum post d2326687662].

FossilOrigin-Name: 403dafc7790a2e8d1772537800760addc47d3e3555bda343c3991d56c1b36e70
 2025-12-22 12:33:27 +00:00
drh
3b81f93532 Fix a harmless signed integer overflow warning in the ieee754() extension 
function.

FossilOrigin-Name: f43d3339c1f06aabcb8e678ed4b91a490cfd0bc880c642ce9c1138c7e08cb360
 2025-12-22 12:00:57 +00:00
drh
19a3f74bdc Remove unused thunk cases from os_win.c, so that it will (hopefully) compile 
again on WinXP.

FossilOrigin-Name: eb2c020481dd591f459cf7191d18c2499aeec210fc3fc27bb35e5abc0d9cb6d8
 2025-12-22 11:28:16 +00:00
drh
174dabe096 Add experimental compile-time option SQLITE_ALLOW_TRIGGERS_ON_SYSTEM_TABLES. 
FossilOrigin-Name: f916bcc8657a4db2d069018751815f2ad91851499add761b1eb119f265b72a09
 2025-12-19 13:17:40 +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