paulhorn/sqlite
1
0
Fork 0
Code Issues Pull Requests Packages Projects Releases Wiki Activity
Files
scanstatus-improvements
sqlite/test
T
History
drh 761118497a Improve the query planner by reducing the estimated number of output rows 
for each stage of a join if there are LIKE, GLOB, REGEXP, or MATCH
constraints on the table where the pattern string is a constant.  The
reduction in the output row estimate is proportional to the length of
the pattern string.

FossilOrigin-Name: 6852843e6aa23051de0884593ce64b96a16f16c4d63b222bd324297581f7cf75
2026-02-03 17:21:59 +00:00
..
json
…
8_3_names.test
…
affinity2.test
…
affinity3.test
…
aggerror.test
…
aggfault.test
…
aggnested.test
…
aggorderby.test
…
alias.test
…
all.test
…
alter2.test
…
alter3.test
…
alter4.test
…
alter.test
…
alterauth2.test
Add tests for ALTER TABLE authorization callbacks and other things.
2025-09-27 18:08:19 +00:00
alterauth.test
…
altercol.test
Fix some problems with DROP CONSTRAINT and DROP NOT NULL on generated columns.
2025-10-01 17:27:23 +00:00
altercons2.test
Strip unterminated "--" comments from the end of constraints added using ALTER TABLE ADD CONSTRAINT or ADD NOT NULL.
2025-11-19 11:31:59 +00:00
altercons.test
Fix some problems with DROP CONSTRAINT and DROP NOT NULL on generated columns.
2025-10-01 17:27:23 +00:00
altercorrupt.test
…
alterdropcol2.test
…
alterdropcol.test
…
alterfault.test
Merge latest trunk changes into this branch.
2025-12-01 17:22:35 +00:00
alterlegacy.test
…
altermalloc2.test
…
altermalloc3.test
…
altermalloc.test
…
alterqf.test
…
altertab2.test
…
altertab3.test
Fix a problem with ALTER TABLE DROP COLUMN commands where the column being dropped is the rightmost in table and is immediately preceded by a comment containing a "," character.
2025-12-02 14:43:59 +00:00
altertab.test
…
altertrig.test
Experimental change to allow triggers in the temp schema to use fully qualified table names in INSERT/UPDATE/DELETE statements.
2025-10-29 20:57:44 +00:00
amatch1.test
…
analyze3.test
…
analyze4.test
…
analyze5.test
…
analyze6.test
…
analyze7.test
…
analyze8.test
…
analyze9.test
…
analyze.test
…
analyzeC.test
…
analyzeD.test
…
analyzeE.test
…
analyzeF.test
…
analyzeG.test
…
analyzer1.test
…
atof1.test
…
atomic2.test
…
atomic.test
…
atrc.c
…
attach2.test
…
attach3.test
…
attach4.test
…
attach.test
…
attachmalloc.test
…
auth2.test
…
auth3.test
…
auth.test
…
autoanalyze1.test
…
autoinc.test
…
autoindex1.test
…
autoindex2.test
…
autoindex3.test
…
autoindex4.test
…
autoindex5.test
…
autovacuum2.test
…
autovacuum_ioerr2.test
…
autovacuum.test
…
avfs.test
Fix test cases impacted by the use of ~/.sqliterc
2025-11-17 00:15:14 +00:00
avtrans.test
…
backcompat.test
…
backup2.test
…
backup4.test
…
backup5.test
…
backup_ioerr.test
…
backup_malloc.test
…
backup.test
…
badutf2.test
…
badutf.test
…
basexx1.test
Fix some integer overflow warnings in the base64 and base85 extensions.
2025-10-07 15:14:03 +00:00
bc_common.tcl
…
bestindex1.test
…
bestindex2.test
…
bestindex3.test
…
bestindex4.test
…
bestindex5.test
…
bestindex6.test
…
bestindex7.test
…
bestindex8.test
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.
2025-12-18 18:47:49 +00:00
bestindex9.test
…
bestindexA.test
…
bestindexB.test
…
bestindexC.test
…
bestindexD.test
…
bestindexE.test
Add better test case for the issue with dropping RETURNING triggers when the schema is reset while preparing a statement.
2025-11-13 17:42:55 +00:00
bestindexF.test
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.
2025-12-18 18:47:49 +00:00
between.test
…
bigfile2.test
…
bigfile.test
…
bigmmap.test
…
bigrow.test
Fix an assert() that could fail when reading a blob or text value larger than 1GiB from the database (requires a non-default build configuration). This is an assert() fix only, production builds were functioning correctly.
2025-10-11 16:23:22 +00:00
bigsort.test
…
bind2.test
…
bind.test
…
bindxfer.test
…
bitvec.test
…
blob.test
…
bloom1.test
…
boundary1.tcl
…
boundary1.test
…
boundary2.tcl
…
boundary2.test
…
boundary3.tcl
…
boundary3.test
…
boundary4.tcl
…
boundary4.test
…
btree01.test
…
btree02.test
…
btreefault.test
…
busy2.test
…
busy.test
…
cache.test
…
cacheflush.test
…
cachespill.test
…
capi2.test
…
capi3.test
…
capi3b.test
…
capi3c.test
…
capi3d.test
…
capi3e.test
…
carray01.test
Add alternative sqlite3_carray_bind_v2() interface.
2026-01-26 13:44:42 +00:00
carray02.test
Were we to choose to integrate the carray() table-valued function into the
2025-10-08 15:32:55 +00:00
carrayfault.test
Fix the carrayfault.test script so that it works in configurations that
2025-10-10 13:43:53 +00:00
cast.test
…
cffault.test
…
changes2.test
…
changes.test
…
check.test
…
checkfault.test
…
chunksize.test
…
cksumvfs.test
Fix cksumvfs test case added by [e3bd1feccaee8ff2] so that it works
2025-08-23 11:09:53 +00:00
close.test
…
closure01.test
…
coalesce.test
…
collate1.test
…
collate2.test
…
collate3.test
…
collate4.test
…
collate5.test
Minor fixes. Tests are passing now.
2026-01-20 15:07:28 +00:00
collate6.test
…
collate7.test
…
collate8.test
…
collate9.test
…
collateA.test
…
collateB.test
…
colmeta.test
…
colname.test
…
columncount.test
…
conflict2.test
…
conflict3.test
…
conflict.test
…
contrib01.test
…
corrupt2.test
…
corrupt3.test
…
corrupt4.test
…
corrupt5.test
…
corrupt6.test
…
corrupt7.test
…
corrupt8.test
…
corrupt9.test
…
corrupt.test
…
corruptA.test
…
corruptB.test
…
corruptC.test
…
corruptD.test
…
corruptE.test
…
corruptF.test
…
corruptG.test
…
corruptH.test
…
corruptI.test
…
corruptJ.test
…
corruptK.test
…
corruptL.test
Guard against oversized index entries in databases larger than 2GiB.
2026-01-14 13:43:32 +00:00
corruptM.test
…
corruptN.test
…
cost.test
Do not reduce the estimated truth probability of LIKE and GLOB operators
2026-02-02 16:03:24 +00:00
count.test
…
countofview.test
…
coveridxscan.test
…
crash2.test
…
crash3.test
…
crash4.test
…
crash5.test
…
crash6.test
…
crash7.test
…
crash8.test
…
crash.test
…
crashM.test
…
crashtest1.c
…
createtab.test
…
cse.test
…
csv01.test
…
ctime.test
…
cursorhint2.test
…
cursorhint.test
…
dataversion1.test
…
date2.test
…
date3.test
…
date4.test
…
date5.test
…
date.test
In the date/time functions, a timezone suffix of "+00:00" should work
2025-09-17 14:55:47 +00:00
dbdata.test
…
dbfuzz2-seed1.db
…
dbfuzz2.c
…
dbfuzz001.test
…
dbfuzz.c
…
dblwidth-a.sql
In the CLI, if a command-line argument names a file and the filename ends
2025-12-13 21:11:49 +00:00
dbpage.test
…
dbpagefault.test
…
dbstatus2.test
Adjust the dbstatus2.test module so that it works on 32-bit builds in
2025-11-03 12:36:52 +00:00
dbstatus.test
…
decimal.test
Special case the "decimal(-0.0)" output to show exactly 0.0, just as it
2025-09-24 17:49:09 +00:00
default.test
…
delete2.test
…
delete3.test
…
delete4.test
…
delete_db.test
…
delete.test
…
descidx1.test
…
descidx2.test
…
descidx3.test
…
diskfull.test
…
distinct2.test
Minor fixes. Tests are passing now.
2026-01-20 15:07:28 +00:00
distinct.test
…
distinctagg.test
…
dotcmd01.sql
Minor change to test/dotcmd01.test so that it works with STAT4.
2026-02-03 17:07:28 +00:00
e_blobbytes.test
…
e_blobclose.test
…
e_blobopen.test
…
e_blobwrite.test
…
e_changes.test
…
e_createtable.test
…
e_delete.test
…
e_droptrigger.test
…
e_dropview.test
…
e_expr.test
Fix a logic error introduced by [cea8bf79e18d55a8] which caused
2025-10-29 20:47:01 +00:00
e_fkey.test
…
e_fts3.test
…
e_insert.test
…
e_reindex.test
…
e_resolve.test
…
e_select2.test
…
e_select.test
…
e_totalchanges.test
…
e_update.test
Experimental change to allow triggers in the temp schema to use fully qualified table names in INSERT/UPDATE/DELETE statements.
2025-10-29 20:57:44 +00:00
e_uri.test
…
e_vacuum.test
…
e_wal.test
…
e_walauto.test
…
e_walckpt.test
Fix calls to sqlite3_wal_checkpoint_v2(SQLITE_CHECKPOINT_NOOP) so that they do not return SQLITE_MISUSE.
2025-12-11 11:05:26 +00:00
e_walhook.test
…
emptytable.test
…
enc2.test
…
enc3.test
…
enc4.test
…
enc.test
…
eqp2.test
…
eqp.test
Minor fixes. Tests are passing now.
2026-01-20 15:07:28 +00:00
errmsg.test
…
errofst1.test
…
eval.test
…
exclusive2.test
…
exclusive.test
…
exec.test
…
exists.test
…
existsexpr2.test
…
existsexpr.test
Fix yet another bug in the [/info/e33da6d5dc964db8|EXISTS-to-JOIN]
2026-01-03 15:11:07 +00:00
existsfault.test
…
expr2.test
…
expr.test
Fix a logic error introduced by [cea8bf79e18d55a8] which caused
2025-10-29 20:47:01 +00:00
exprfault2.test
…
exprfault.test
…
extension01.test
…
external_reader.test
…
extraquick.test
…
fallocate.test
…
filectrl.test
Remove #ifdefs intended to make SQLite compatible with Windows RT. WinRT
2025-12-06 19:56:40 +00:00
filefmt.test
…
filter1.test
…
filter2.tcl
…
filter2.test
…
filterfault.test
…
fkey1.test
…
fkey2.test
…
fkey3.test
…
fkey4.test
…
fkey5.test
…
fkey6.test
…
fkey7.test
…
fkey8.test
…
fkey_malloc.test
…
fordelete.test
…
fork-test.c
…
format4.test
…
fp-speed-1.c
…
fpconv1.test
…
fts3_common.tcl
…
fts3.test
…
fts3aa.test
…
fts3ab.test
…
fts3ac.test
…
fts3ad.test
…
fts3ae.test
…
fts3af.test
…
fts3ag.test
…
fts3ah.test
…
fts3ai.test
…
fts3aj.test
…
fts3ak.test
…
fts3al.test
…
fts3am.test
…
fts3an.test
…
fts3ao.test
…
fts3atoken2.test
Add tests to check that SQLITE_DBCONFIG_ENABLE_FTS3_TOKENIZER is working.
2025-09-05 11:20:11 +00:00
fts3atoken.test
…
fts3auto.test
…
fts3aux1.test
…
fts3aux2.test
…
fts3b.test
…
fts3c.test
…
fts3comp1.test
Add test for fts3 compress= and uncompress= options.
2026-01-26 20:17:10 +00:00
fts3conf.test
…
fts3corrupt2.test
…
fts3corrupt3.test
…
fts3corrupt4.test
…
fts3corrupt5.test
…
fts3corrupt6.test
…
fts3corrupt7.test
…
fts3corrupt.test
…
fts3cov.test
…
fts3d.test
…
fts3defer2.test
…
fts3defer3.test
…
fts3defer.test
…
fts3drop.test
…
fts3dropmod.test
…
fts3e.test
…
fts3expr2.test
…
fts3expr3.test
…
fts3expr4.test
…
fts3expr5.test
…
fts3expr.test
…
fts3f.test
…
fts3fault2.test
…
fts3fault3.test
…
fts3fault.test
…
fts3first.test
…
fts3fuzz001.test
…
fts3integrity.test
…
fts3join.test
…
fts3malloc.test
…
fts3matchinfo2.test
…
fts3matchinfo.test
…
fts3misc.test
…
fts3near.test
…
fts3offsets.test
…
fts3prefix2.test
…
fts3prefix.test
…
fts3query.test
…
fts3rank.test
…
fts3rnd.test
…
fts3shared.test
…
fts3snippet2.test
…
fts3snippet.test
…
fts3sort.test
…
fts3tok1.test
…
fts3tok_err.test
…
fts3varint.test
…
fts4aa.test
…
fts4check.test
…
fts4content.test
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.
2025-12-22 15:22:02 +00:00
fts4docid.test
…
fts4growth2.test
…
fts4growth.test
…
fts4incr.test
…
fts4intck1.test
…
fts4langid.test
…
fts4lastrowid.test
…
fts4merge2.test
…
fts4merge3.test
…
fts4merge4.test
…
fts4merge5.test
Fix a typo in fts3/4 debugging code allowing 'maxpendinXY' to act as a synonym for 'maxpending=' in special INSERT statements.
2025-11-25 15:11:34 +00:00
fts4merge.test
…
fts4min.test
…
fts4noti.test
…
fts4onepass.test
…
fts4opt.test
…
fts4record.test
…
fts4rename.test
…
fts4umlaut.test
…
fts4unicode.test
…
fts4upfrom.test
…
fts-9fd058691.test
…
full.test
…
func2.test
…
func3.test
…
func4.test
…
func5.test
…
func6.test
…
func7.test
…
func8.test
…
func9.test
Fix a bug in concat_ws() in which an initial empty string was treated as if
2025-10-13 12:36:54 +00:00
func.test
…
fuzz2.test
…
fuzz3.test
…
fuzz4.test
…
fuzz_common.tcl
…
fuzz_malloc.test
…
fuzz-oss1.test
…
fuzz.test
…
fuzzcheck.c
Adjust the output of the fuzzcheck test program so that testrunner.tcl can
2026-01-14 19:22:36 +00:00
fuzzdata1.db
…
fuzzdata2.db
…
fuzzdata3.db
…
fuzzdata4.db
…
fuzzdata5.db
…
fuzzdata6.db
…
fuzzdata7.db
…
fuzzdata8.db
…
fuzzer1.test
…
fuzzer2.test
…
fuzzerfault.test
…
fuzzinvariants.c
Try to prevent false positives in fuzzinvariants.c due to scalar subqueries.
2026-01-16 17:48:46 +00:00
gcfault.test
…
gencol1.test
…
genesis.tcl
…
having.test
…
hexlit.test
…
hidden.test
…
hook2.test
…
hook.test
…
icu.test
…
ieee754.test
In the ieee754 extension, render -0.0 as 'ieee754(-1,-3071)' instead of
2025-09-23 16:01:45 +00:00
import01.sql
For CSV import in the CLI, when the table is created automatically
2026-01-27 14:59:08 +00:00
imposter1.sql
CLI: The .imposter command matches the index name regardless of case.
2025-12-16 13:43:35 +00:00
imposter1.test
Improvements to imposter tables: (1) They are read-only unless writable-schema
2025-09-19 17:24:12 +00:00
in2.test
…
in3.test
…
in4.test
…
in5.test
…
in6.test
…
in7.test
…
in.test
…
incrblob2.test
…
incrblob3.test
…
incrblob4.test
…
incrblob_err.test
…
incrblob.test
…
incrblobfault.test
…
incrcorrupt.test
…
incrvacuum2.test
…
incrvacuum3.test
…
incrvacuum_ioerr.test
…
incrvacuum.test
…
index2.test
…
index3.test
…
index4.test
…
index5.test
…
index6.test
…
index7.test
…
index8.test
…
index9.test
…
index.test
…
indexA.test
…
indexedby.test
…
indexexpr1.test
…
indexexpr2.test
…
indexexpr3.test
…
indexfault.test
…
init.test
…
insert2.test
…
insert3.test
…
insert4.test
…
insert5.test
Enable an ORDER BY clause to refer to columns in outer queries.
2025-12-15 11:59:47 +00:00
insert.test
…
insertfault.test
…
instr.test
…
instrfault.test
…
intarray.test
…
interrupt2.test
…
interrupt.test
…
intpkey.test
…
intreal.test
…
io.test
…
ioerr2.test
…
ioerr3.test
…
ioerr4.test
…
ioerr5.test
…
ioerr6.test
…
ioerr.test
…
istrue.test
…
join2.test
…
join3.test
…
join4.test
…
join5.test
…
join6.test
…
join7.test
…
join8.test
…
join9.test
…
join.test
Enhance the omit-noop-join optimization so that it is able to omit a
2025-12-24 14:03:15 +00:00
joinA.test
…
joinB.test
…
joinC.test
…
joinD.test
…
joinE.test
…
joinF.test
…
joinH.test
Detect some cases of ambiguous column references in USING clauses that can come up with nested joins.
2025-10-31 16:07:31 +00:00
joinI.test
Add test case to this branch to show that it handles cases where ON clauses use select-list aliases to refer to columns to their right.
2025-08-25 11:47:15 +00:00
journal1.test
…
journal2.test
…
journal3.test
…
jrnlmode2.test
…
jrnlmode3.test
…
jrnlmode.test
…
json101.test
…
json102.test
Avoid unsigned integer overflow when evaluating an array index in a
2026-01-27 23:33:42 +00:00
json103.test
Fix the jsonb_group_array() and jsonb_group_object() functions so that they return
2026-01-25 15:18:31 +00:00
json104.test
…
json105.test
Avoid unsigned integer overflow when evaluating an array index in a
2026-01-27 23:33:42 +00:00
json106.test
…
json107.test
…
json108.test
…
json109.test
Raise an error if any PATH argument to json_array_insert() is not the path
2026-01-17 19:01:37 +00:00
json501.test
…
json502.test
…
jsonb01.test
…
keyword1.test
…
kvtest.c
…
lastinsert.test
…
laststmtchanges.test
…
lemon-test01.y
…
like2.test
…
like3.test
…
like.test
…
limit2.test
…
limit.test
…
literal2.tcl
…
literal2.test
…
literal.test
…
loadext2.test
…
loadext.test
…
lock2.test
…
lock3.test
…
lock4.test
…
lock5.test
…
lock6.test
…
lock7.test
…
lock_common.tcl
…
lock.test
…
lookaside.test
…
main.test
…
make-where7.tcl
…
malloc3.test
…
malloc4.test
…
malloc5.test
…
malloc6.test
…
malloc7.test
…
malloc8.test
…
malloc9.test
…
malloc_common.tcl
…
malloc.test
…
mallocA.test
…
mallocAll.test
…
mallocB.test
…
mallocC.test
…
mallocD.test
…
mallocE.test
…
mallocF.test
…
mallocG.test
…
mallocH.test
…
mallocI.test
…
mallocJ.test
…
mallocK.test
…
mallocL.test
…
mallocM.test
…
malloctraceviewer.tcl
…
manydb.test
…
mem5.test
…
memdb1.test
…
memdb2.test
…
memdb.test
…
memjournal2.test
…
memjournal.test
…
memleak.test
…
memsubsys1.test
…
memsubsys2.test
…
merge1.test
…
minmax2.test
…
minmax3.test
…
minmax4.test
…
minmax.test
…
misc1.test
…
misc2.test
…
misc3.test
…
misc4.test
…
misc5.test
Add the SQLITE_LIMIT_PARSER_DEPTH value for sqlite3_limit(). This isn't
2025-11-18 14:48:33 +00:00
misc6.test
…
misc7.test
…
misc8.test
…
misuse.test
Have sqlite3_set_errmsg() return SQLITE_MISUSE if a NULL db handle is passed to it, as documented.
2025-11-10 10:47:29 +00:00
mjournal.test
…
mmap1.test
…
mmap2.test
…
mmap3.test
…
mmap4.test
…
mmapcorrupt.test
…
mmapfault.test
…
mmapwarm.test
…
modeA.sql
Enhance QRF so that it terminates more quickly if it encounters an OOM
2026-01-07 16:19:18 +00:00
multiplex2.test
…
multiplex3.test
…
multiplex4.test
…
multiplex.test
…
mutex1.test
…
mutex2.test
…
nan.test
…
nockpt.test
…
nolock.test
…
normalize.test
…
notify1.test
…
notify2.test
…
notify3.test
…
notnull2.test
In the cost metrics of the query planner, the estimated number of output rows
2026-01-23 20:46:54 +00:00
notnull.test
…
notnullfault.test
…
null.test
…
nulls1.test
…
numcast.test
…
numindex1.test
…
offset1.test
Minor fixes. Tests are passing now.
2026-01-20 15:07:28 +00:00
openv2.test
…
optfuzz-db01.c
…
optfuzz-db01.txt
…
optfuzz.c
…
orderby1.test
…
orderby2.test
…
orderby3.test
…
orderby4.test
…
orderby5.test
…
orderby6.test
…
orderby7.test
…
orderby8.test
…
orderby9.test
…
orderbyA.test
…
orderbyB.test
…
oserror.test
…
ossfuzz.c
Reduce the maximum size of LIKE and GLOB patterns in the ossfuzz.c test
2025-10-19 17:30:07 +00:00
ossshell.c
…
ovfl.test
…
pager1.test
…
pager2.test
…
pager3.test
…
pager4.test
…
pagerfault2.test
…
pagerfault3.test
…
pagerfault.test
…
pageropt.test
…
pagesize.test
…
parser1.test
…
pcache2.test
…
pcache.test
…
pendingrace.test
…
percentile.test
This is how the percentile() family of functions might be integrated into
2025-10-08 16:29:14 +00:00
permutations.test
…
pg_common.tcl
…
pragma2.test
…
pragma3.test
…
pragma4.test
…
pragma5.test
…
pragma6.test
…
pragma.test
…
pragmafault.test
…
prefixes.test
…
printf2.test
…
printf.test
…
progress.test
…
ptrchng.test
…
pushdown.test
…
qrf01.test
Test cases and documentation tweaks.
2025-12-10 15:50:23 +00:00
qrf02.test
Further testing and bug fixing.
2025-11-05 22:33:47 +00:00
qrf03.test
Update test cases to work with the new box format and with --quote relaxed.
2025-12-06 11:02:14 +00:00
qrf04.test
New test case for bSplitColumn in QRF.
2025-11-23 10:55:38 +00:00
qrf05.test
New test cases for QRF
2025-12-02 18:37:49 +00:00
qrf06.test
Update test cases to work with the new box format and with --quote relaxed.
2025-12-06 11:02:14 +00:00
queryonly.test
…
quick.test
…
quickcheck.test
…
quota2.test
…
quota-glob.test
…
quota.test
…
quote.test
…
randexpr1.tcl
…
randexpr1.test
…
rbu.test
…
rdonly.test
…
readonly.test
…
recover.test
Fix test cases impacted by the use of ~/.sqliterc
2025-11-17 00:15:14 +00:00
regexp1.sql
CLI improvements. In the .check command, ignore leading and trailing
2025-12-16 13:25:45 +00:00
regexp1.test
Update the regexp extension so that the "-" character may be escaped with a backslash. Forum post [forum:c5e7358f82 | c5e7358f82].
2026-01-05 18:29:07 +00:00
regexp2.test
Limit the complexity of a REGEXP pattern using SQLITE_LIMIT_LIKE_PATTERN_LENGTH
2025-09-26 15:38:52 +00:00
reindex.test
…
reservebytes.test
Update test script reservebytes.test so that it works with the "prepare" permutation.
2025-08-29 16:51:16 +00:00
resetdb.test
…
resolver01.test
…
returning1.test
Avoid dropping RETURNING triggers when the schema is reset while preparing a statement.
2025-11-10 17:37:59 +00:00
returningfault.test
Add an OOM test case for the issue with dropping RETURNING triggers when the schema is reset while preparing a statement that uses an eponymous vtab.
2025-11-13 18:02:22 +00:00
rollback2.test
…
rollback.test
…
rollbackfault.test
…
round1.test
…
rowallock.test
…
rowhash.test
…
rowid.test
…
rowvalue2.test
…
rowvalue3.test
…
rowvalue4.test
…
rowvalue5.test
…
rowvalue6.test
…
rowvalue7.test
…
rowvalue8.test
…
rowvalue9.test
…
rowvalue.test
…
rowvalueA.test
…
rowvaluefault.test
…
rowvaluevtab.test
…
rtree.test
…
run-wordcount.sh
…
savepoint2.test
…
savepoint4.test
…
savepoint5.test
…
savepoint6.test
…
savepoint7.test
…
savepoint.test
…
savepointfault.test
…
scanstatus2.test
…
scanstatus.test
…
schema2.test
…
schema3.test
…
schema4.test
…
schema5.test
…
schema6.test
…
schema.test
…
schemafault.test
…
securedel2.test
…
securedel.test
…
seekscan1.test
…
select1.test
…
select2.test
…
select3.test
…
select4.test
…
select5.test
…
select6.test
…
select7.test
…
select8.test
…
select9.test
Fix another test case to work with union-by-merge.
2026-01-20 18:20:26 +00:00
selectA.test
…
selectB.test
…
selectC.test
…
selectD.test
…
selectE.test
…
selectF.test
…
selectG.test
…
selectH.test
…
session.test
…
sessionfuzz-data1.db
…
sessionfuzz.c
…
shared2.test
…
shared3.test
…
shared4.test
…
shared6.test
…
shared7.test
…
shared8.test
…
shared9.test
…
shared_err.test
…
shared.test
…
sharedA.test
…
sharedB.test
…
sharedlock.test
…
shell1.test
Enhance the ".timer" command in the CLI to accept the "once" argument, and
2026-02-01 15:58:37 +00:00
shell2.test
Improvements to the .import command of the CLI.
2025-12-28 14:01:52 +00:00
shell3.test
Back out the --compat option from the CLI.
2025-12-13 00:13:40 +00:00
shell4.test
Fix a bug in ".show". Adjust test cases for the new default mode.
2025-11-16 23:06:45 +00:00
shell5.test
Enhance the ".timer" command in the CLI to accept the "once" argument, and
2026-02-01 15:58:37 +00:00
shell6.test
…
shell7.test
…
shell8.test
…
shell9.test
…
shellA.test
Back out the --compat option from the CLI.
2025-12-13 00:13:40 +00:00
shellB.test
Fix the new CLI so that the ".eqp" setting does not affect the output of other dot
2026-01-30 16:03:22 +00:00
shmlock.test
…
shortread1.test
…
show_speedtest1_rtree.tcl
…
shrink.test
…
sidedelete.test
…
skipscan1.test
…
skipscan2.test
…
skipscan3.test
…
skipscan5.test
…
skipscan6.test
…
snapshot2.test
…
snapshot3.test
…
snapshot4.test
…
snapshot_fault.test
…
snapshot_up.test
…
snapshot.test
…
soak.test
…
softheap1.test
…
sort2.test
…
sort3.test
…
sort4.test
…
sort5.test
…
sort.test
…
sorterref.test
…
sortfault.test
…
speed1.test
…
speed1p.explain
…
speed1p.test
…
speed2.test
…
speed3.test
…
speed4.test
…
speed4p.explain
…
speed4p.test
…
speedtest1.c
In speedtest1, always use fatal_error() to exit fatally, instead of an fprintf/exit() pair, so that stdout/stderr get flushed consistently (which is significant for the WASM build).
2025-09-24 06:59:47 +00:00
speedtest.md
Update speedtest.md to point out xdg-open on Linux.
2026-01-10 14:12:40 +00:00
speedtest.tcl
Fix a help text typo in speedtest1.tcl, pointed out off-list by BrickViking.
2026-01-10 00:38:00 +00:00
spellfix2.test
…
spellfix3.test
…
spellfix4.test
…
spellfix.test
…
sqldiff1.test
…
sqllimits1.test
…
sqllog.test
…
starschema1.test
…
startup.c
…
stat.test
…
statfault.test
…
stmt.test
…
stmtrand.test
…
stmtvtab1.test
…
strict1.test
…
strict2.test
…
subjournal.test
…
subquery2.test
Fix a problem that could occur when a scalar subquery had both a DISTINCT and OFFSET clause. First reported by [forum:41bd7af485 | forum post 41bd7af485].
2025-12-03 14:39:25 +00:00
subquery.test
…
subselect.test
…
substr.test
…
subtype1.test
…
superlock.test
…
swarmvtab2.test
…
swarmvtab3.test
…
swarmvtab.test
…
swarmvtabfault.test
…
symlink2.test
…
symlink.test
…
sync2.test
…
sync.test
…
syscall.test
…
sysfault.test
…
tabfunc01.test
Add ENABLE compile-time options to enable carray() and median(). Hence
2025-10-08 18:11:37 +00:00
table.test
…
tableapi.test
…
tableopts.test
…
tclsqlite.test
New build product "tclsqlite-ex.c" is the tclsqlite.c file with QRF added.
2025-11-05 12:37:42 +00:00
tempdb2.test
…
tempdb.test
…
tempfault.test
…
temptable2.test
…
temptable3.test
…
temptable.test
…
temptrigfault.tes
Add further test cases for temp triggers to this branch.
2025-11-11 16:50:31 +00:00
temptrigger.test
Add further test cases for temp triggers to this branch.
2025-11-11 16:50:31 +00:00
tester.tcl
Remove #ifdefs intended to make SQLite compatible with Windows RT. WinRT
2025-12-06 19:56:40 +00:00
testloadext.c
Add the test/testloadext.c loadable extension to test the ability to use
2025-10-14 17:50:55 +00:00
testrunner_data.tcl
Remove #ifdefs intended to make SQLite compatible with Windows RT. WinRT
2025-12-06 19:56:40 +00:00
testrunner_estwork.tcl
Add a new direct CLI testing script in test/modeA.clitest to demonstration
2025-11-12 13:46:11 +00:00
testrunner.tcl
Add the new "retest" command to testrunner.tcl, which reruns any tests that
2025-12-31 17:21:30 +00:00
thread1.test
…
thread2.test
…
thread3.test
…
thread001.test
…
thread002.test
…
thread003.test
…
thread004.test
…
thread005.test
…
thread_common.tcl
…
threadtest1.c
…
threadtest2.c
…
threadtest3.c
…
threadtest4.c
…
threadtest5.c
…
time-wordcount.sh
…
timediff1.test
…
tkt35xx.test
…
tkt1435.test
…
tkt1443.test
…
tkt1444.test
…
tkt1449.test
…
tkt1473.test
…
tkt1501.test
…
tkt1512.test
…
tkt1514.test
…
tkt1536.test
…
tkt1537.test
…
tkt1567.test
…
tkt1644.test
…
tkt1667.test
…
tkt1873.test
…
tkt2141.test
…
tkt2192.test
…
tkt2213.test
…
tkt2251.test
…
tkt2285.test
…
tkt2332.test
…
tkt2339.test
Minor fixes. Tests are passing now.
2026-01-20 15:07:28 +00:00
tkt2391.test
…
tkt2409.test
…
tkt2450.test
…
tkt2565.test
…
tkt2640.test
…
tkt2643.test
…
tkt2686.test
…
tkt2767.test
…
tkt2817.test
…
tkt2820.test
…
tkt2822.test
…
tkt2832.test
…
tkt2854.test
…
tkt2920.test
…
tkt2927.test
…
tkt2942.test
…
tkt3080.test
…
tkt3093.test
…
tkt3121.test
…
tkt3201.test
…
tkt3292.test
…
tkt3298.test
…
tkt3334.test
…
tkt3346.test
…
tkt3357.test
…
tkt3419.test
…
tkt3424.test
…
tkt3442.test
…
tkt3457.test
…
tkt3461.test
…
tkt3493.test
…
tkt3508.test
…
tkt3522.test
…
tkt3527.test
…
tkt3541.test
…
tkt3554.test
…
tkt3581.test
…
tkt3630.test
…
tkt3718.test
…
tkt3731.test
…
tkt3757.test
…
tkt3761.test
…
tkt3762.test
…
tkt3773.test
…
tkt3791.test
…
tkt3793.test
…
tkt3810.test
…
tkt3824.test
…
tkt3832.test
…
tkt3838.test
…
tkt3841.test
…
tkt3871.test
…
tkt3879.test
…
tkt3911.test
…
tkt3918.test
…
tkt3922.test
…
tkt3929.test
…
tkt3935.test
…
tkt3992.test
…
tkt3997.test
…
tkt4018.test
…
tkt-2a5629202f.test
…
tkt-2d1a5c67d.test
…
tkt-2ea2425d34.test
…
tkt-3a77c9714e.test
…
tkt-3fe897352e.test
…
tkt-4a03edc4c8.test
…
tkt-4c86b126f2.test
…
tkt-4dd95f6943.test
…
tkt-4ef7e3cfca.test
…
tkt-5d863f876e.test
…
tkt-5e10420e8d.test
…
tkt-5ee23731f.test
…
tkt-6bfb98dfc0.test
…
tkt-7a31705a7e6.test
…
tkt-7bbfb7d442.test
…
tkt-8c63ff0ec.test
…
tkt-9a8b09f8e6.test
…
tkt-9d68c883.test
…
tkt-9f2eb3abac.test
…
tkt-02a8e81d44.test
…
tkt-26ff0c2d1e.test
…
tkt-38cb5df375.test
…
tkt-78e04e52ea.test
…
tkt-80ba201079.test
…
tkt-80e031a00f.test
…
tkt-91e2e8ba6f.test
…
tkt-385a5b56b9.test
…
tkt-752e1646fc.test
…
tkt-8454a207b9.test
…
tkt-18458b1a.test
…
tkt-31338dca7e.test
…
tkt-54844eea3f.test
…
tkt-313723c356.test
…
tkt-868145d012.test
…
tkt-3998683a16.test
…
tkt-99378177930f87bd.test
Fix a missed optimization opportunity due to a typo in check-in [898bfa1afd8260ea].
2026-01-31 02:17:55 +00:00
tkt-a7b7803e.test
…
tkt-a7debbe0.test
…
tkt-a8a0d2996a.test
…
tkt-b1d3a2e531.test
…
tkt-b75a9ca6b0.test
…
tkt-b351d95f9.test
…
tkt-b72787b1.test
…
tkt-ba7cbfaedc.test
…
tkt-bd484a090c.test
…
tkt-bdc6bbbb38.test
…
tkt-c48d99d690.test
…
tkt-c694113d5.test
…
tkt-cbd054fa6b.test
…
tkt-d11f09d36e.test
…
tkt-d82e3f3721.test
…
tkt-d635236375.test
…
tkt-f3e5abed55.test
…
tkt-f7b4edec.test
…
tkt-f67b41381a.test
…
tkt-f973c7ac31.test
…
tkt-f777251dc7a.test
…
tkt-fa7bf5ec.test
…
tkt-fc7bd6358f.test
…
tkt-fc62af4523.test
…
tokenize.test
…
tpch01.test
…
trace2.test
…
trace3.test
…
trace.test
…
trans2.test
…
trans3.test
…
trans.test
…
transitive1.test
…
trigger1.test
…
trigger2.test
…
trigger3.test
…
trigger4.test
…
trigger5.test
…
trigger6.test
…
trigger7.test
…
trigger8.test
…
trigger9.test
…
triggerA.test
…
triggerB.test
…
triggerC.test
…
triggerD.test
…
triggerE.test
…
triggerF.test
…
triggerG.test
…
triggerupfrom.test
…
trustschema1.test
…
tt3_checkpoint.c
…
tt3_index.c
…
tt3_lookaside1.c
…
tt3_shared.c
…
tt3_stress.c
…
tt3_vacuum.c
…
types2.test
…
types3.test
…
types.test
…
unhex.test
…
unionall2.test
…
unionall.test
…
unionallfault.test
…
unionvtab.test
…
unionvtabfault.test
…
unique2.test
…
unique.test
…
unixexcl.test
…
unordered.test
…
update2.test
…
update.test
…
upfrom1.tcl
…
upfrom1.test
…
upfrom2.test
…
upfrom3.test
…
upfrom4.test
…
upfromfault.test
…
upsert1.test
…
upsert2.test
…
upsert3.test
…
upsert4.test
…
upsert5.test
…
upsertfault.test
…
uri2.test
…
uri.test
…
utf16align.test
…
vacuum2.test
…
vacuum3.test
…
vacuum4.test
…
vacuum5.test
…
vacuum6.test
…
vacuum-into.test
…
vacuum.test
…
vacuummem.test
…
values.test
…
valuesfault.test
…
varint.test
…
veryquick.test
…
view2.test
…
view3.test
…
view.test
…
vt02.c
Bug fix in the vt02.c test virtual table.
2025-12-18 20:44:48 +00:00
vt100-a.sql
Fix the test/vt100-a.sql script to use .testcase and .check.
2025-12-15 13:26:27 +00:00
vtab1.test
…
vtab2.test
…
vtab3.test
…
vtab4.test
…
vtab5.test
…
vtab6.test
…
vtab7.test
…
vtab8.test
…
vtab9.test
…
vtab_alter.test
…
vtab_err.test
…
vtab_shared.test
…
vtabA.test
…
vtabB.test
…
vtabC.test
…
vtabD.test
…
vtabdistinct.test
…
vtabdrop.test
…
vtabE.test
…
vtabF.test
…
vtabH.test
…
vtabI.test
…
vtabJ.test
…
vtabK.test
…
vtabL.test
…
vtabrhs1.test
…
wal2.test
…
wal3.test
…
wal4.test
…
wal5.test
…
wal6.test
…
wal7.test
…
wal8.test
…
wal9.test
…
wal64k.test
…
wal_common.tcl
…
wal.test
…
walbak.test
…
walbig.test
…
walblock.test
…
walckptnoop.test
Fix calls to sqlite3_wal_checkpoint_v2(SQLITE_CHECKPOINT_NOOP) so that they do not return SQLITE_MISUSE.
2025-12-11 11:05:26 +00:00
walcksum.test
…
walcrash2.test
…
walcrash3.test
…
walcrash4.test
…
walcrash.test
…
walfault2.test
…
walfault.test
…
walhook.test
…
walmode.test
…
walnoshm.test
…
waloverwrite.test
…
walpersist.test
…
walprotocol2.test
…
walprotocol.test
…
walro2.test
…
walro.test
…
walrofault.test
…
walseh1.test
…
walsetlk2.test
…
walsetlk3.test
…
walsetlk_recover.test
…
walsetlk_snapshot.test
…
walsetlk.test
…
walshared.test
…
walslow.test
…
walthread.test
Update the test/walthread.test testing script so that it uses a random
2025-11-01 20:14:43 +00:00
walvfs.test
…
where2.test
Make CROSS JOIN a join reorder barrier again, as the SQLite documentation says it is. It
2026-01-30 17:10:22 +00:00
where3.test
…
where4.test
…
where5.test
…
where6.test
…
where7.test
…
where8.test
…
where9.test
…
where.test
…
whereA.test
…
whereB.test
…
whereC.test
…
whereD.test
…
whereE.test
…
whereF.test
…
wherefault.test
…
whereG.test
…
whereH.test
…
whereI.test
…
whereJ.test
…
whereK.test
The optimization at [8bdda827a3d26800] is incorrect for the case where one
2026-01-16 15:53:20 +00:00
whereL.test
…
wherelfault.test
…
wherelimit2.test
…
wherelimit3.test
…
wherelimit.test
…
whereM.test
…
whereN.test
…
widetab1.test
…
win32heap.test
…
win32lock.test
…
win32longpath.test
Remove #ifdefs intended to make SQLite compatible with Windows RT. WinRT
2025-12-06 19:56:40 +00:00
win32nolock.test
…
window1.test
Improve performance of window function queries that use "BETWEEN :x FOLLOWING AND :y FOLLOWING" where :y is a very large number.
2025-09-24 16:10:46 +00:00
window2.tcl
…
window2.test
…
window3.tcl
…
window3.test
…
window4.tcl
…
window4.test
…
window5.test
…
window6.test
…
window7.tcl
…
window7.test
…
window8.tcl
…
window8.test
…
window9.test
…
windowA.test
…
windowB.test
…
windowC.test
…
windowD.test
…
windowE.test
…
windowerr.tcl
…
windowerr.test
…
windowfault.test
…
windowpushd.test
…
with1.test
…
with2.test
…
with3.test
…
with4.test
…
with5.test
…
with6.test
…
withM.test
…
without_rowid1.test
…
without_rowid2.test
…
without_rowid3.test
…
without_rowid4.test
…
without_rowid5.test
…
without_rowid6.test
…
without_rowid7.test
Avoid returning SQLITE_ERROR_RETRY if collation sequences associated with the table's PK cannot be found when creating an index. Possible fix for [forum:aa61ab56ad | forum post aa61ab56ad].
2025-08-20 15:42:23 +00:00
wordcount.c
…
writecrash.test
…
zeroblob.test
…
zeroblobfault.test
…
zerodamage.test
…
zipfile2.test
Fix a buffer overrun in the zipfile extension that could occur while processing zip archives with extremely long file-names and comment fields.
2025-10-02 11:16:22 +00:00
zipfile.test
Fix integer overflow problems and error reporting memory leaks in
2026-01-13 02:35:19 +00:00
zipfilefault.test
…