database/sqlite
1
0
Fork 0
mirror of https://github.com/sqlite/sqlite.git synced 2025-08-05 15:55:57 +03:00
Code Activity
29,745 Commits 1,570 Branches 183 Tags
flex-array
Commit Graph

9687 Commits

Author SHA1 Message Date
drh
2ed4f5016a Fix handling of COLLATE. Add test cases for the same. Code cleanup for 
improved understandability and maintainability.

FossilOrigin-Name: 41a41c173a9d15d94f23d73a5c04bfb1616cb9223bc81d41808f9b4d00817fbf
 2024-08-16 11:26:21 +00:00
drh
235b5d0ac5 If a subquery is materialized due to an ORDER BY and that ordering is useful 
in helping to satisfy the ORDER BY or GROUP BY in the order query without
doing an extra sort, then omit the extra sort.

FossilOrigin-Name: 2fbb4dc2327ee435cb2b7a4adcddf5a9cee6dff7de96e2ecb761166427b5ddea
 2024-08-15 23:38:52 +00:00
drh
8c411f7fce Resolve parameters Bind $int_N and $test_T in fuzzcheck inputs. 
FossilOrigin-Name: 9c10664416274df6f8da53ddd86f6356c9704ad798fd4034d2784ae433c1c056
 2024-08-12 09:49:02 +00:00
drh
1107b4b9cf Bind the new debug parameters in fuzzinvariants.c. 
FossilOrigin-Name: 7e1dc263051cf50db04643d1a2aa9f91559b2b121859b750ce4446012d5f3c3e
 2024-08-09 12:35:27 +00:00
dan
679f5d458e Add assert() statements and reorganize code slightly in fts3 and fts5 to make it easier to follow. 
FossilOrigin-Name: 797b0a13fd7a42b0a48ecbf0cd1961aa932da3e9c9ccffd903a3a4d963d0cc54
 2024-08-08 15:07:27 +00:00
drh
1193e4679d Do not let the number of terms on a VALUES clause be limited by 
SQLITE_LIMIT_COMPOUND_SELECT, even if the VALUES clause contains elements
that appear to be variables due to the use of double-quoted string literals.
[https://issues.chromium.org/issues/358174302|Chromium issue 358174302].

FossilOrigin-Name: 670beb133eb203065a75022f0c6db7c605a4e0e22c8ef6d6b4724be2663ff3dc
 2024-08-08 14:45:50 +00:00
dan
0a83dac31c Ensure the sqlite3_index_info.colUsed mask always includes the PK fields of WITHOUT ROWID vtabs in cases where they may be used. 
FossilOrigin-Name: c327c0c02cfefdba373cfb15933a9cdfddb578b6582f2ce7c08929203743ffe9
 2024-08-03 18:45:48 +00:00
drh
4a36d30493 Add the --status option to the test runs using testrunner.tcl. Only works 
on Unix platforms.  The "exec" command appears to interfere with VT100
escape codes on windows.

FossilOrigin-Name: 94015cda4ceb4292ceceadb951fe5d9cb3e4e20403719b7254ad094a5b749ab3
 2024-08-03 15:55:25 +00:00
drh
b2d590c5f9 Add the "-d SECS" option to the "status" command of testrunner.tcl 
FossilOrigin-Name: 2151ea31632f7aa363c7d4b7205e1174a45d710783a8efad8176049d356cfc70
 2024-08-02 17:36:34 +00:00
drh
a51de65758 Include a test case summary in the output of "errors" in testrunner.tcl. 
FossilOrigin-Name: 173df1478e89996126e172656e35da8026d4ef145b2341ef56213f00ade14f48
 2024-08-01 14:43:27 +00:00
drh
5cc7f4b580 Add the "errors" command to testrunner.tcl. 
FossilOrigin-Name: 03b7f99229cfcffde024915e6812d75ae11318db9dc93a00838e4588a79b1243
 2024-08-01 14:16:36 +00:00
drh
b030bc6980 testrunner.db should be in WAL mode for improved concurrency while running 
"watch sqlite3 test/testrunner.tcl status".

FossilOrigin-Name: f23ad0979865f3c11a3dbd0598ee7c4e2eabeaf1863d000fc0242e18890a4a11
 2024-07-31 22:26:04 +00:00
drh
d888e79bb8 Fix typo in testrunner.tcl for the "status" command that was causing it 
to fail if any errors were seen.

FossilOrigin-Name: 8327c5ed535c57c4082211a50bfb1c32ea5d5fe1cf71f37798d8b58e88948ac2
 2024-07-31 22:17:26 +00:00
drh
a7382d3523 Under Tcl9, the %x format letter truncates to 32-bits. Must use %llx in order 
to get a 64-bit rendering.

FossilOrigin-Name: a3044e0ae65c099d76bf04536e223e70d89971688627c342252951f6c65f49d1
 2024-07-31 19:56:14 +00:00
drh
ff79000f28 Fix a typo in testrunner_data.tcl that prevented --with-tcl specifications 
from being carried through into sub-builds.  Adjust test cases to account
for new floating-point differences discovered when --with-tcl was fixed.

FossilOrigin-Name: b8f81351914deac99b14be6bb5e4096c1efed9bdb057750825760f09dae04656
 2024-07-31 16:37:02 +00:00
drh
ad2bcef112 Remove obsolete testfixture TCL commands formerly required by Windows 
but now handled by Tcl itself.  Update tests case accordingly.

FossilOrigin-Name: 4f065fb638b24b33283518af8ad55f28a49cfac4086fa5e4568e2f3a6814962d
 2024-07-31 15:04:37 +00:00
drh
3f80dbd51e Fix problems uncovered while testing Tcl9 on Windows. 
FossilOrigin-Name: d5523c77fd0bcdc8344971a116d6ce9657f2b6daddeb7d936cd7607163a36744
 2024-07-31 13:00:18 +00:00
drh
096c22ad5e Minor adjustments to get Tcl9-based testing working on Macs. 
FossilOrigin-Name: 066c8672ee85a6ce972de38fcd3793fc2c1ef4f21c3de2379746d0ff18df8dc0
 2024-07-31 12:19:16 +00:00
drh
f15c80d80f Patch to testrunner.tcl so that it works with Tcl9's pedantic UTF-8 checking. 
FossilOrigin-Name: 8d4a23d32dc16b115153e6e100ba3ba15273c3e37310e8a1b4bace885c5383a8
 2024-07-31 11:12:13 +00:00
drh
4400b0ac45 Fix a problem with strictly conforming UTF8 in shell1.test. 
FossilOrigin-Name: 8ee187f98d310e1e7cf6c3fdf000c19e98a9f11e01436c3c407df04da79aa7c0
 2024-07-31 02:01:19 +00:00
drh
3bad3d6964 Adjust a few tests that don't work even with the new floating point 
comparison routine.

FossilOrigin-Name: 895125a4895099df7c3841ca7c34697ba17fd667bddbc2fd7148f7aa9d6d2b9d
 2024-07-31 01:53:48 +00:00
drh
f504cc761b Implement a new comparison routine to compare text renderings of 
floating point values.  This gets the number of failures down to just 5.
But the routine needs work, and probably refactoring.

FossilOrigin-Name: 71f2ee5db01150707401804b136641170e7ed44760fccec20de19184e4d0a840
 2024-07-31 01:45:14 +00:00
drh
262addd9ab All tests in "make test" now pass with Tcl9, except for about 198 cases where 
the error involves small differences in the rendering to floating point
values.

FossilOrigin-Name: 8e27f5326c69aa4fb6f3f1f42668ab1b08140ab0a614ac4a9d94679c8fb9734e
 2024-07-30 20:39:05 +00:00
drh
780187f090 Get rid of "-encoding binary" across all test cases, as that is no longer 
supported in Tcl9.  Use "-translation binary" instead.

FossilOrigin-Name: e0d9670dd98a22d2e22aac8ba8720787a05e280e18ec9b2d4323f947c83718f5
 2024-07-30 17:09:51 +00:00
drh
b18d851119 Add the percentile_cont(Y,P) variant of percentile() to the percentile 
extension.

FossilOrigin-Name: 095c22e62248f8ef50cd8531171827f50a7bdd4fc1128bf0e616a3eb2dce980e
 2024-07-24 13:41:09 +00:00
drh
171c944345 Enhance the percentile() extension function to include the median() 
variant.  Update the implementation to implement its own sorting
algorithm, so that the extension no longer depends on qsort().

FossilOrigin-Name: 6e31b1bab1f014933c671a12a5930c1e88d611cfe68d389e9ce888bd8842addd
 2024-07-23 16:23:46 +00:00
dan
a61f11f307 Add test cases to in7.test. 
FossilOrigin-Name: 07817efc10a6ab59dcb18ad218a3bb5a5d49a724c51296d5c8d7e386b0e0c789
 2024-07-04 18:56:26 +00:00
drh
0cf237c5b0 Be more aggressive about reusing subqueries that appear on the RHS of IN 
operators that have been replicated due to the predicate push-down optimization.

FossilOrigin-Name: 2accf32b6e45a396503c29eecc14a103bcc7b4c313cde921b26b489704060177
 2024-07-04 16:57:11 +00:00
drh
5b070cfa0f Show the creation of IN-operator Bloom filters in the EXPLAIN QUERY PLAN output. 
FossilOrigin-Name: c10a1b99d47a4c93bdb16e646f6a21add570d6dbb34fd91a32f8abacdb28712b
 2024-07-03 20:10:42 +00:00
drh
f1bf103e4e Fix a typo in a comment in a test case. No changes to code. 
FossilOrigin-Name: f501166de4f967b7e2e895f180308630e3c88b12bc51823a0a124ee5089eae4f
 2024-06-29 15:57:55 +00:00
drh
076bd5758b Do not convert an expression node that is already TK_REGISTER into a 
new TK_REGISTER.  This is a follow-up to [663f5dd32d9db832] that fixes a
bug discovered by dbsqlfuzz.

FossilOrigin-Name: fcb669cfaa8a59ca710504d5aaa1936f65a6da8ff13473ad84458f97a6fd1f49
 2024-06-28 17:14:00 +00:00
dan
9e72ea5ddc Omit tests that depend on sqlite3_release_memory() in lock5.test when running the memsubsys1 or memsubsys2 permutations. 
FossilOrigin-Name: 9d63033bf46ddf0f4d9d4ef06d56357fe6165f2370cd19cf81c2f7f61ce224fc
 2024-06-12 15:29:37 +00:00
dan
f8ed7db472 Do not attempt to run hot journal rollback tests in lock5.test with the "inmemory_journal" permutation, which cannot generate hot journals. 
FossilOrigin-Name: 1e6fa95b88cace9e6cac476863d57cfd8de483f83c922ff964b77cbaee6e9ae4
 2024-06-12 11:41:18 +00:00
dan
41caf1cdfa Handle the case where unix-dotfile is used with URI parameter nolock=1. 
FossilOrigin-Name: 3925a5b904e159d54455cfc73fe837a9c6ea3a6d60da63afde3242b4d6f67c90
 2024-06-11 20:28:56 +00:00
dan
f6ec2b5946 Fix a problem with rolling back hot journals using the unix-dotfile VFS. 
FossilOrigin-Name: 4ae3300b79e03381fd7f1033bb7978bb6367369790f17c3bdacac51e205edaf9
 2024-06-11 20:03:32 +00:00
drh
bd1402487b Omit bogus tests accidentally added by the privious commit. 
FossilOrigin-Name: e94dfe9928750dd98145d4d9920b298f7b0868703b487f86e0db77a41d53ccf9
 2024-06-06 23:22:32 +00:00
drh
4703b7d092 Better optimize queries that use parameters in the LIMIT clause. 
FossilOrigin-Name: e58cb304d1e0ec6e30260a165aaccc2cf096ce6c999efb06683c4ef600ee12ef
 2024-06-06 15:03:16 +00:00
dan
e3eefe00dd Fix a very obscure issue where the name resolver could get confused if aliases like "sqlite_schema" or "sqlite_master" were used in a query involving the sqlite_temp_schema table. 
FossilOrigin-Name: a096eb7554952f8137c6e9330c328164719fb27e958787fbd503bcd1364e6ae4
 2024-06-05 11:36:58 +00:00
dan
7d24afa0de Better handle WHERE terms that are common to two or more OR branches when planning virtual table queries. 
FossilOrigin-Name: 1976c3f7e1fe77cf3367710e8ada230a3672ed374e316425164e42b2622526c7
 2024-06-04 17:26:15 +00:00
dan
077f9b14f1 Fix a couple of memory leaks in the shell tool code that could occur when processing errors. 
FossilOrigin-Name: e84f09d469ee76a5b5e44baf6a69b90c69d4160fa4c32de04a96f868643acd96
 2024-06-04 15:07:38 +00:00
drh
8741ca0819 Address a corner-case associated with the call-function-once optimization 
of check-in [663f5dd32d9db832] that was causing a (harmless) use of an
uninitialized bytecode register.
dbsqlfuzz 8a44f675401a8b1f68a43bf813c4f4f72ad8f0ea

FossilOrigin-Name: b37ac2d020873b78efa164036db4056406a67330679f850775da520cd8027cb9
 2024-06-03 18:04:10 +00:00
dan
af35432400 Further tests for OR constraints on virtual tables. 
FossilOrigin-Name: ff4a30056f8dbcbd045afdbee485f6671c3580b95187144aa9a77c97dfda2647
 2024-05-31 20:32:10 +00:00
dan
cadfdd4e09 Better handle WHERE terms that are common to two or more OR branches when planning virtual table queries. 
FossilOrigin-Name: 4edd9b29f58621335b8a562280c991c34804bbba090f90c951261d043cff1965
 2024-05-31 19:26:22 +00:00
drh
d79ce8a459 Fix typos in the star-schema test cases. 
FossilOrigin-Name: 4080937353985eb391f70a3a7fae890823cf01d19c52939e343fb2504f3f8659
 2024-05-29 09:53:19 +00:00
drh
c34ff12c59 Use a heuristic in the query planner to help it better cope with large 
star schema queries.

FossilOrigin-Name: a98be0f548f277fab8f38a2dec6ddcbe7a7fff27856ba19e76ad8c5641894b7b
 2024-05-29 00:38:12 +00:00
drh
b23f92b286 Avoid creating an automatic index on a column that is known to be not very 
selective.

FossilOrigin-Name: 70409763f70faa2a0f4f072fd318a687b109a0905cc57906ad7f80d2885fe6d9
 2024-05-27 21:55:01 +00:00
dan
09f87094bd Fix a possible buffer overwrite in the ".import" command. [forum:/forumpost/0c447f0548|forum post 0c447f0548]. 
FossilOrigin-Name: 0fd958fa9b56a8ef254127e29800ca2a267590e86edf739bd339239b25a5da6e
 2024-05-27 11:35:05 +00:00
dan
89b04f3786 Ensure that queries like "SELECT indeterministic(a) FROM tbl GROUP BY 1" invoke the indeterministic function only once for each row of tbl. 
FossilOrigin-Name: 4555d66547e28cb110e1012b145bcf3aafb5d4bde05e9d27bcb4ca33837b28f5
 2024-05-24 18:31:39 +00:00
drh
31079226f7 Add the stmtrand() extension function for use in testing. 
FossilOrigin-Name: 5c97a5b9d163b1c427e002f3734687ca0384bc0da6a90fc4bfd358c654d3a7b3
 2024-05-24 14:16:06 +00:00
dan
7c492a250b Fix an "ifcapable" expression in values.test. 
FossilOrigin-Name: b8442d2a6012b1f2e15381613267db0982e36bb4c748b15b56e668e0d0a3d0d2
 2024-05-24 13:33:39 +00:00