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,798 Commits 1,570 Branches 183 Tags
tclsqlite-db-copy-fix
Commit Graph

9695 Commits

Author SHA1 Message Date
drh
d9bc2bb638 Improvements to testrunner.tcl: Show elapse time in MM:SS or HH:MM:SS. 
Keep track of the total number of tests and the total number of errors
and report those values on a summary line at the end.

FossilOrigin-Name: 40b232924c973f8d94605946fff75acbe120d90634a2eaf38bd31649e9f1390b
 2024-08-27 19:17:29 +00:00
drh
dac0d0b310 Updates to testrunner: (1) Omit all testing of User-Auth. 
(2) Automatically add the "*" wildcard before and after all pattern
arguments.  (3) Build the sqlite3 CLI for release tests.

FossilOrigin-Name: d03d35eebaf82709414c87cfa6abc9d2baf8d7e64c2627bad0fd5bbda3e78d60
 2024-08-27 17:38:26 +00:00
dan
58b08d7702 Avoid a stack overflow that could be caused by a recursively defined WINDOW() with a strategically embedded error. 
FossilOrigin-Name: bada54bd6bf54190e40aa721b77081015957d204c7b6a9fdbe8c67bcf20798f8
 2024-08-24 15:54:15 +00:00
drh
5804da0218 Enhance the generate_series() table-valued function such that it is able to 
recognize equality and inequality constraints on the "value" column and
optimize its operating accordingly.

FossilOrigin-Name: d50b784807333c5461a2d027778c746c799285b95bb1952f142b317ea2846460
 2024-08-22 18:12:10 +00:00
drh
5648d717b1 Refactor the SrcItem object to move fields associated with subqueries out 
into a separate object named Subquery.  This reduces the size of the SrcItem
object by about 1/3rd and provides improved performance.

FossilOrigin-Name: 484bcd75bc95491d8540c791c1c4d40d996cb465839564662e14f98739699bf1
 2024-08-20 23:11:28 +00:00
drh
a0651b3707 Fix a name resolution issue with CTEs. 
FossilOrigin-Name: 4fa8235dd59cd683d6c6c97bfe181a9637be7c054d435323c903b9dbd74aff02
 2024-08-20 22:44:40 +00:00
drh
5a18c1f9cd New date/time test cases to validate ancient dates. 
FossilOrigin-Name: 82719074f090d9d0a0b9baea0dee7b1dd40a272e3f3e45043d4a640c07989d5d
 2024-08-19 13:53:49 +00:00
drh
8797bd695f Reduce the size of the SrcItem object by combining fields into a union. 
FossilOrigin-Name: a4c59ac3c6ec979c25b544d29e47b8e39f6439c098eed8f84b3bd506c9adf047
 2024-08-17 19:46:49 +00:00
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