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

10092 Commits

Author SHA1 Message Date
drh
5239e69fb1 Remove a harmless unused variable from the fp-speed-2.c benchmark. 
FossilOrigin-Name: ff9008e7615d877e6cc852c60097777006b274971646d368eaa56b99a7acf6c7
 2026-03-28 14:21:53 +00:00
drh
20d93e16d7 Enhancements to the fp-speed-N.c programs, suggested by Andreas Kupries. 
FossilOrigin-Name: 7d81ff4c509d4039ef9e2f1066284ec560131422db0cbffa7e1826d71bb8f8e1
 2026-03-28 14:17:53 +00:00
drh
ff8a0895d6 Fix up the floating-point speed tests so that they only need to be run once 
to get a performance comparision.  Provide the fp-speed-test makefile target
to build and run them both.

FossilOrigin-Name: 09e0e78a8265c2e2bc36fef1fa88bd5bf414f9b776966c1c91a4ed4b7866331d
 2026-03-27 20:18:06 +00:00
drh
a2f78f665c Add a comment to test/fptest01.sql to remind us that failures in that 
script might not be the fault of SQLite.

FossilOrigin-Name: 65efcb0a2ed49fa2fd747b5f034d976ed3cb4a01a185bcada70bf8a5208f3841
 2026-03-27 19:25:25 +00:00
drh
c4cedd7ffe New test cases for text→float conversions. 
FossilOrigin-Name: bbf2d648376a965605d5c641a889ab7ef365bc53788d984c054468e9889deee6
 2026-03-27 18:58:50 +00:00
drh
be2242d2ee Change the print resolution the fp-speed-1.c test to 17 digits. 
FossilOrigin-Name: c687b32a956315ddf4336df42deb4037c37d51b536b8a24c5cef4c5a0bc4c79b
 2026-03-27 14:54:01 +00:00
drh
2dd3b4a646 Update fp-speed-1.c and fp-speed-2.c to include its own timers, so that it 
works on platforms that lack the "time" command.

FossilOrigin-Name: 9b083070de2d782fe1db62652af8f3cd48abe16b55b974f3927b738e3d914887
 2026-03-27 14:19:01 +00:00
drh
4570aeb7bc Add the fp-speed-2.c performance test program. 
FossilOrigin-Name: b788256f1980531e7abb15c5fbcdd40ae166f091aea28f449c0407105ddf1aa4
 2026-03-27 14:03:41 +00:00
drh
f163bfba4e If the argument to REINDEX is EXPRESSIONS (with no schema prefix) then it 
updates both expression indexes, and any indexes named "expressions" or
all indexes of any tables name "expressions".

FossilOrigin-Name: 72650dc152279a6da1937f377b1e16b79f4cd664841e12222dc5459838408d22
 2026-03-20 19:30:58 +00:00
dan
bd580270a5 Ensure that collation sequences on non-PK columns of a WITHOUT ROWID table are used correctly when they are part of a row value comparison. Fix for forum post [forum:7a308e933d | 7a308e933d]. 
FossilOrigin-Name: 078b3162d0d3d3035f4d3ad88664066d99c218a731ac481b9f1172529e26e4eb
 2026-03-20 11:35:15 +00:00
dan
58012b85b0 Do not assume that a recursive CTE emits rows in ORDER BY order. Fix for forum post [forum:deb1eadf4d677bd5 | deb1eadf4d677bd5]. 
FossilOrigin-Name: cadb6cdd32c3c9abd7e063f25acd39dddc9ff764a16019ffd5aa11063175326f
 2026-03-19 10:51:40 +00:00
drh
5a6772eaa5 Comment improvements. Ensure that tests in shellB.test that require 
virtual tables do not run when compiling without virtual table support.

FossilOrigin-Name: a270c6cc0eea8a8a2cf1ce30d724b2f12b11a1c343cd8520bd7843f4e62878f8
 2026-03-18 17:16:18 +00:00
drh
acc213b42f Improve the integrity-check error message when floating point index values 
are off by one or two ULPs.  Change the name of the eiib1.test test module
to expridx1.test.

FossilOrigin-Name: 4e996c183ea8d270b4448b471d4d032e13cef89f537674599d1e7c367cc2d0f8
 2026-03-18 15:51:15 +00:00
dan
345bc91673 Do not assume that a recursive CTE emits rows in ORDER BY order. Forum [forum:deb1eadf4d677bd5 | deb1eadf4d677bd5]. 
FossilOrigin-Name: 971aa34b3fd86ba30fe170886d9f83c17159b1638c4bd4fb6cdef79b1c9a88e2
 2026-03-18 15:40:26 +00:00
dan
3f2d7d4aaa Fix some cases where integrity-check would fail to identify real values in indexed expressions that are with 2 ULPs of each other. 
FossilOrigin-Name: 40c5966f7b784f181365c81fc559aee9463c374ee56677cf6e0aecaed39d2b28
 2026-03-18 11:06:10 +00:00
dan
362b9cecdb Modify integrity-check so that it is only tolerant of very small distortions of real values in indexed expression fields. 
FossilOrigin-Name: 82e6de835bde306778425d18ab1a15ae80fdf01af7f577ead89c09f9d53b5b2f
 2026-03-17 21:17:42 +00:00
dan
ae2820ab28 When integrity-check finds a missing index entry, search a small range (currently 10) of entries around the missing key for an entry that matches all non-virtual and non-expression fields. 
FossilOrigin-Name: 978cedcbd33165dadc7dffc118bde359eff6751ec9842230880cb827d9f7845f
 2026-03-17 17:05:45 +00:00
dan
022f2f96bc Change the sqlite3VdbeFindDeleteKey() routine so that all index fields that are not expressions or virtual columns must match the table for the delete to succeed. 
FossilOrigin-Name: eccd9fcfa7e34ddcdeb671544c6afac7aa0d4665c5e1df7c8e53c41387ed0386
 2026-03-17 11:17:54 +00:00
drh
1c1f7c259e Merge trunk enhancements into the idxdelete-tolerance branch 
FossilOrigin-Name: 5f5ab3eb3618b6a2799355df50bfdf94121161f7cadba6253963036d9f284f08
 2026-03-17 09:53:02 +00:00
dan
f6308e68ff Further tests for the code on this branch. 
FossilOrigin-Name: f928a38091977268aa6a096104797158883ed89b9e026b4e4b98b9b5da967de1
 2026-03-16 16:44:14 +00:00
dan
b2006499c7 Fix a problem with the find-delete-key method on this branch. 
FossilOrigin-Name: 6f49b5ecad5d924999d045a1ade93d95e731182be1781aefa5bc763b6202e9c3
 2026-03-16 15:49:58 +00:00
drh
bf057073c3 Rework the ".indexes" command of the CLI. (1) The PATTERN now matches 
the name of the index itself, not the name of the table containing
the index, thus making the pattern actually useful.  (2)  System-generated
indexes (for UNIQUE constraints and similar) are omitted unless
the -a|-all or --sys options are added.  (3) The --expr option causes
only expression indexes to be shown.

FossilOrigin-Name: 13e2cad810bfd59a9e18eb38bda1241715b76756ffec7d617e9ce99b89f19284
 2026-03-16 15:35:41 +00:00
dan
061459bf76 Properly fix temp triggers created as part of FK processing to their schemas. Otherwise they may become confused by similarly named child tables in other attached databases. Fix for forum post [forum:636bd0180a | 636bd0180a]. 
FossilOrigin-Name: 80bc5bc07e221f837c28066f0a438f11c8ab6be4c8ba93615439eb1667967003
 2026-03-16 11:14:26 +00:00
drh
3bd23b0d78 Fix the behavior dot-commands that appear as command line arguments to the 
CLI so that their effect persists into subsequent commands on the command
line.  This fix also improves error messages caused by command line
arguments. 
[forum:/forumpost/2026-03-10T19:26:06z|Forum post 2026-03-10T19:26:06z].

FossilOrigin-Name: ff084ae341eab5c4ce9403defee03adc448c05f77648a954f0942a38f640080b
 2026-03-10 21:01:59 +00:00
drh
abc82c49c2 Revamp the QRF insert-mode optimization of [659ff6ab55802507]. The 
control value is now nMultiInsert.  Multiple rows are added to each INSERT
statement until the number of bytes in that statement exceeds the
nMultiInsert value.  The CLI uses a default value of 3000, which provides
a good balance between speed and prepare-statement size.  The output
from ".dump" now loads nearly 2x faster in some cases.

FossilOrigin-Name: 55b0ce9f93d68b17a18423f0f751b778573127743a2bac67abfea074ac32d41a
 2026-03-10 18:13:13 +00:00
drh
efa8633fd8 Enhance QRF with the mxTuple field, which if greater than 1 causes the 
QRF_STYLE_Insert style to group as many as mxTuple adjacent rows into
a single INSERT statement.  The field is accessible using the -mxtuple
option in the TCL interface, and the --mxtuple option in ".mode".  The
output of the ".dump" and ".fullschema" commands responds to the current
--mxtuple setting.

FossilOrigin-Name: 659ff6ab5580250707908af003ecd093bd5313f03f21f0efd000a7aff6638b3c
 2026-03-10 14:02:03 +00:00
drh
e795890d7e In QRF, fix line-wrap indentation for "line" mode when using a 
non-standard column separator.

FossilOrigin-Name: 00c96cca3de709e40207feb9c10a94e38e7857c9bc01938849c6c5daee7148c7
 2026-03-09 13:53:58 +00:00
dan
5ed6e4ccd1 Fix a problem with RIGHT JOIN and expressions on indexes. [forum:e3dba5426a | Forum post e3dba5426a]. 
FossilOrigin-Name: f27d578edac06eb28739f23351ab1cf07531bc7b32f4077e4dc9c8166f551d95
 2026-03-09 11:49:51 +00:00
drh
13a494fddd Give the fuzzcheck test program access to all the same extensions that 
dbsqlfuzz has access to.

FossilOrigin-Name: d9c23b49e355233bbfcdc8305dcae21640e66a0bbf1daed0dd3f9d132c1ef69f
 2026-03-07 21:07:18 +00:00
drh
275e7c7caa Merge fixes that were deferred until after the 3.52.0 release, including: 
(1) Fix handling of DISTINCT with OUTER JOIN, (2) Enhance configure to
auto-detect linenoise, (3) Add recent configuration settings to WASM.

FossilOrigin-Name: 9d51bec1b17925f5cac0d590c0d70bb34e77fdb7253d18007f52711d42f6f5d0
 2026-03-06 18:51:49 +00:00
dan
ea595494e2 Uninstall faultsim at the end of the walrestart.test script. 
FossilOrigin-Name: 798905a1277ecb17245f2a7378fdc8dc608374fde50bdfe44d09195a7c78cb5c
 2026-03-06 11:18:12 +00:00
dan
46686ac681 Fix a long-standing problem with DISTINCT LEFT JOIN queries. 
FossilOrigin-Name: f43294a5582b540a33c584ec8c69b6a5006a4d243ad5cf36125b2b0806e3518b
 2026-03-05 14:39:27 +00:00
drh
bef2a1e33e Add a little flexibility to checkpoint sizes in the walrestart.test script. 
FossilOrigin-Name: e438b564ca84377746464034d770e9c1f5899d935c6a4dffc546acb92afb800e
 2026-03-05 00:30:05 +00:00
drh
76e562e222 Fix a code-generator bug introduced by the UNION/INTERSECT/EXISTS 
optimization of check-in [132ba781b031972c] and reported in
[forum:/forumpost/2026-03-04T05:06:26Z|forum post 2026-03-04T05:06:26Z].

FossilOrigin-Name: 6ba7797cac7dc873b62a12be5712511c9199b379342dac4a1887bfd65227a298
 2026-03-04 13:02:08 +00:00
dan
8ba2a38363 Do not run test script walrestart.test with the "memsubsys1" permutation. 
FossilOrigin-Name: 703cbb0f760515eac1e6f72a5e5cd928258c71378e4a976082b6518c90128135
 2026-03-03 18:34:38 +00:00
drh
bb80d688ac Minor tweaks to the previous, for testability. 
FossilOrigin-Name: decb69015457b4f70cf574aeef87d40f9de60b94965f4a915e8d0cd7559ef2ae
 2026-03-03 18:21:22 +00:00
dan
fe57e14b49 Avoid an obscure race condition between a checkpointer and a writer wrapping around to the start of the wal file. 
FossilOrigin-Name: 053bd3930f827156fd67ea4546a36227cffbb6f8bada3b5d1a7cf5f1867ac624
 2026-03-03 17:34:01 +00:00
drh
f6c8adf3a2 Omit explain_i calls from TCL test scripts. 
FossilOrigin-Name: 204f25c882832058c3291d4d6a0a6ac2711c081cb91b19feb2cf94a25ed61ecf
 2026-03-02 16:40:16 +00:00
drh
ea6b2a87d1 Disable test shell1-5.0 as it is causing a use of initialized deep inside 
of TCL.

FossilOrigin-Name: 440bd6091e3767f0a2f42ffdc92ca5e4736c0a73324fdd15397c3b5dbbc31fb8
 2026-03-02 13:43:08 +00:00
dan
33478099c9 Fix a possible 9-byte buffer overread in the zipfile extension hit when processing a corrupt zip file. Forum post [forum:/forumpost/721a05d2c5 | 721a05d2c5]. 
FossilOrigin-Name: 5db21813d126554d80db903be6d36ab6c1f73f9135a54af6dcfcfce0bcc18e68
 2026-03-02 11:22:28 +00:00
drh
93ad2e083e The intck01.sql test should only be run if virtual tables work. 
FossilOrigin-Name: 641d6f31a7f7b4901061e24d4e624da5ed92282e79771bb019b82a882e5d1ae9
 2026-03-02 00:06:02 +00:00
drh
ffaf9110f6 More floating point conversion test cases. 
FossilOrigin-Name: 44a736a700ab12b398873400dc06cd334817842b4fa08bf8070a9ad6dbff0b51
 2026-03-01 23:23:52 +00:00
drh
7e4e866baf New floating-point test case. 
FossilOrigin-Name: f353399932e9797198e635405a594c2987850070e3f9aee87a05c5a65d4c1e00
 2026-03-01 23:01:17 +00:00
drh
e293b2d835 Fix an OOB read in the incremental integrity-check extension. 
FossilOrigin-Name: abecc8e388e294311aa0b572e0a984b8ddad2afbf829c1246e1682fa549c8fac
 2026-03-01 22:36:02 +00:00
drh
7d9fbe6476 Fix an off-by-one error in the indentation of multi-line outputs in 
QRF_STYLE_Line mode.

FossilOrigin-Name: d47499b21c893cc8749a1cafe1cf712dacfeaa6cfe2cdb75d1fc450f3cb6879f
 2026-02-27 13:25:42 +00:00
dan
a86c6017e7 Fix a problem where the wrong collation could be used as part of a row-value comparison between columns with different collation sequences. [forum:/forumpost/6ceca07fc3 | Forum post 6ceca07fc3]. 
FossilOrigin-Name: 212c68249cc0e8904fc36d8e90646d04604f2b3b9d4c32eaeac7d920fa0fba99
 2026-02-26 11:03:22 +00:00
drh
b1a73ba34d Adjust the changes to shell8.test from [5da9bf09cc00faf9] so that they 
work with older versions of TCL.

FossilOrigin-Name: c3b9e2cee3565da50bcc92766f700c31142391a697cbab7465774cf20a307dd8
 2026-02-24 19:50:27 +00:00
drh
9d65290207 Rename SQLITE_ENABLE_MULTITHREADED_CHECKS to SQLITE_THREAD_MISUSE_WARNINGS. 
Run test cases with that option. Also add the
SQLITE_THREAD_MISUSE_ABORT option.

FossilOrigin-Name: be8c8b9cb7b618a1571a988bc1cfdc15d99a8bf144d699385c0076e940b9f7f5
 2026-02-24 19:37:16 +00:00
drh
d2e27e5d54 Add test cases for the symlink defenses of the previous check-in. 
FossilOrigin-Name: 5da9bf09cc00faf98cc515fb5a10a0af325b8f7608893808d031dfef62380be2
 2026-02-23 13:29:29 +00:00
drh
8642ca2025 New sqlite3_db_config(SQLITE_DBCONFIG_FP_DIGITS) that let's the application 
specify the number of significant digits that double→text conversions
will attempt to preserve.

FossilOrigin-Name: 3f16985dcc47a366b54164c5024f920a79dddd76faeac5e36b4770732ed72c0a
 2026-02-21 19:26:58 +00:00