database/sqlite
1
0
Fork 0
mirror of https://github.com/sqlite/sqlite.git synced 2026-10-26 21:59:27 +03:00
Code Activity
Files
no-rowid-on-view
sqlite/test
History
drh 6e5020e8da Also prohibit the use of rowid from a subquery. Add the 
SQLITE_ALLOW_ROWID_IN_VIEW compile-time option to restore legacy behavior
in case somebody actually needs it.

FossilOrigin-Name: 14b1d56ef84b0e62b7f9c4e5f7f985ca10e770c8db59f54004ad892c2a2dcbfb
2021-04-07 15:45:01 +00:00
..
8_3_names.test
…
affinity2.test
Avoid running a couple of tests in affinity2.test as part of the valgrind permutations, as the way floating point computations are simulated by valgrind causes them to fail.
2019-10-03 16:02:22 +00:00
affinity3.test
Do not apply affinities when creating entries for automatic indexes on views. Fix for [95302bdb].
2020-10-03 19:16:36 +00:00
aggerror.test
…
aggnested.test
Ensure that aggregate functions that (a) are part of SELECT statements with no FROM clause and (b) have one or more scalar sub-selects as arguments are assigned to the correct aggregate context.
2020-06-09 17:45:48 +00:00
alias.test
…
all.test
In all.test, do not attempt to run the RBU tests in non-RBU builds.
2018-09-06 20:33:11 +00:00
alter2.test
Add the SQLITE_DEFAULT_DEFENSIVE compile-time option. Fix up test cases
2018-11-07 02:17:01 +00:00
alter3.test
Release some restrictions on columns added by ALTER TABLE so that they
2020-05-08 19:02:21 +00:00
alter4.test
Release some restrictions on columns added by ALTER TABLE so that they
2020-05-08 19:02:21 +00:00
alter.test
Fix a bad assert in RENAME COLUMN.
2021-03-08 17:17:38 +00:00
alterauth2.test
Have ALTER TABLE RENAME COLUMN and DROP COLUMN use sqlite_rename_quotefix() to convert any double-quoted strings in the database schema to their single-quoted equivalents.
2021-03-16 16:14:48 +00:00
alterauth.test
Fix a compilation issue in the "userauth" extension. Also fix a few test
2018-09-19 17:09:09 +00:00
altercol.test
Fix a problem with renaming a column when there is a quoted string immediately following the column name somewhere in the schema.
2021-03-23 22:15:34 +00:00
altercorrupt.test
Fix test case in altercorrupt.test so that it works with SQLITE_ENABLE_OVERSIZE_CELL_CHECK builds.
2021-02-25 18:28:11 +00:00
alterdropcol2.test
Fix broken requirement marks.
2021-03-12 13:49:09 +00:00
alterdropcol.test
Fix a possible NULL pointer dereference when applying a DROP COLUMN to a
2021-03-06 13:02:12 +00:00
alterlegacy.test
Fix various issues with the changes on this branch. Add test cases for the same.
2021-02-17 20:08:22 +00:00
altermalloc2.test
By default, make all "ALTER TABLE RENAME" statements executed within a virtual
2018-09-20 17:21:21 +00:00
altermalloc3.test
When doing schema updates, try to convert (incorrect) double-quoted strings
2021-03-23 16:34:13 +00:00
altermalloc.test
Enhance tester.tcl so that when "--malloctrace=1" is specified, the test
2018-09-18 17:00:06 +00:00
alterqf.test
Add tests for sqlite_rename_quotefix(). Fix a memory leak in the same.
2021-03-16 18:24:49 +00:00
altertab2.test
In ALTER TABLE, rename columns and tables in expressions that are optimized out by the "AND 0" optimization. Doing this also fixes an otherwise harmless assert() failure.
2019-12-30 06:55:31 +00:00
altertab3.test
Fix a problem caused by using an SQL variable in an OVER clause within a trigger program.
2021-01-21 15:40:52 +00:00
altertab.test
Revise tests cases to align with the new EXPLAIN QUERY PLAN output.
2021-03-20 15:11:29 +00:00
amatch1.test
…
analyze3.test
Revise tests cases to align with the new EXPLAIN QUERY PLAN output.
2021-03-20 15:11:29 +00:00
analyze4.test
Revise tests cases to align with the new EXPLAIN QUERY PLAN output.
2021-03-20 15:11:29 +00:00
analyze5.test
Remove support for STAT3. The sqlite_stat3 tables are ignored, if they
2019-08-08 15:24:17 +00:00
analyze6.test
Revise tests cases to align with the new EXPLAIN QUERY PLAN output.
2021-03-20 15:11:29 +00:00
analyze7.test
Revise tests cases to align with the new EXPLAIN QUERY PLAN output.
2021-03-20 15:11:29 +00:00
analyze8.test
Revise tests cases to align with the new EXPLAIN QUERY PLAN output.
2021-03-20 15:11:29 +00:00
analyze9.test
Revise tests cases to align with the new EXPLAIN QUERY PLAN output.
2021-03-20 15:11:29 +00:00
analyze.test
Remove support for STAT3. The sqlite_stat3 tables are ignored, if they
2019-08-08 15:24:17 +00:00
analyzeC.test
Revise tests cases to align with the new EXPLAIN QUERY PLAN output.
2021-03-20 15:11:29 +00:00
analyzeD.test
Revise tests cases to align with the new EXPLAIN QUERY PLAN output.
2021-03-20 15:11:29 +00:00
analyzeE.test
Revise tests cases to align with the new EXPLAIN QUERY PLAN output.
2021-03-20 15:11:29 +00:00
analyzeF.test
Revise tests cases to align with the new EXPLAIN QUERY PLAN output.
2021-03-20 15:11:29 +00:00
analyzeG.test
Changes to test/analyzeG.test to conform to the new EXPLAIN QUERY PLAN syntax.
2021-03-23 15:07:17 +00:00
analyzer1.test
…
async2.test
…
async3.test
…
async4.test
…
async5.test
…
async.test
…
atof1.test
Apple the same fix for ticket [9eda2697f5cc1aba] to text-to-integer
2020-08-27 16:28:30 +00:00
atomic2.test
If an SQLITE_IOERR error is encountered as part of an atomic commit on an F2FS
2018-07-14 20:25:13 +00:00
atomic.test
…
atrc.c
Extend the refactoring into extensions. Clean up stray newlines.
2020-06-19 15:24:12 +00:00
attach2.test
…
attach3.test
…
attach4.test
Revise tests cases to align with the new EXPLAIN QUERY PLAN output.
2021-03-20 15:11:29 +00:00
attach.test
Do not confuse the constant SQLITE_MAX_ATTACHED with the maximum number of
2021-03-10 16:35:37 +00:00
attachmalloc.test
Enhance tester.tcl so that when "--malloctrace=1" is specified, the test
2018-09-18 17:00:06 +00:00
auth2.test
…
auth3.test
…
auth.test
Remove support for STAT3. The sqlite_stat3 tables are ignored, if they
2019-08-08 15:24:17 +00:00
autoanalyze1.test
…
autoinc.test
Add test cases to improve coverage of VDBE branches. Still some to go.
2019-04-04 17:58:34 +00:00
autoindex1.test
Revise tests cases to align with the new EXPLAIN QUERY PLAN output.
2021-03-20 15:11:29 +00:00
autoindex2.test
…
autoindex3.test
Revise tests cases to align with the new EXPLAIN QUERY PLAN output.
2021-03-20 15:11:29 +00:00
autoindex4.test
…
autoindex5.test
Also prohibit the use of rowid from a subquery. Add the
2021-04-07 15:45:01 +00:00
autovacuum_ioerr2.test
…
autovacuum.test
…
avfs.test
Fix appendvfs bug exposed with bigger files, and add tests for such conditions.
2021-03-16 06:41:51 +00:00
avtrans.test
…
backcompat.test
…
backup2.test
Fix an error in the test case fix in [ecd71203].
2021-02-15 11:14:53 +00:00
backup4.test
…
backup5.test
…
backup_ioerr.test
…
backup_malloc.test
…
backup.test
…
badutf2.test
Test case changes so that they work with both Tcl8.6 and Tcl8.7.
2019-04-12 16:25:42 +00:00
badutf.test
…
bc_common.tcl
…
bestindex1.test
Revise tests cases to align with the new EXPLAIN QUERY PLAN output.
2021-03-20 15:11:29 +00:00
bestindex2.test
Revise tests cases to align with the new EXPLAIN QUERY PLAN output.
2021-03-20 15:11:29 +00:00
bestindex3.test
Revise tests cases to align with the new EXPLAIN QUERY PLAN output.
2021-03-20 15:11:29 +00:00
bestindex4.test
Revise tests cases to align with the new EXPLAIN QUERY PLAN output.
2021-03-20 15:11:29 +00:00
bestindex5.test
Add the SQLITE_DEFAULT_DEFENSIVE compile-time option. Fix up test cases
2018-11-07 02:17:01 +00:00
bestindex6.test
Fix a problem with processing a "vtab.col IS NULL" expression within
2018-09-10 12:17:16 +00:00
bestindex7.test
Revise tests cases to align with the new EXPLAIN QUERY PLAN output.
2021-03-20 15:11:29 +00:00
between.test
Revise tests cases to align with the new EXPLAIN QUERY PLAN output.
2021-03-20 15:11:29 +00:00
bigfile2.test
…
bigfile.test
…
bigmmap.test
Fix a test case in bigmmap.test so that it works with the new
2021-03-23 14:33:35 +00:00
bigrow.test
…
bigsort.test
…
bind.test
…
bindxfer.test
…
bitvec.test
…
blob.test
…
boundary1.tcl
…
boundary1.test
…
boundary2.tcl
…
boundary2.test
…
boundary3.tcl
…
boundary3.test
…
boundary4.tcl
…
boundary4.test
…
btree01.test
…
btree02.test
Modify the btree02.test module so that it does not depend on whether TCL
2018-12-27 16:55:01 +00:00
btreefault.test
…
busy2.test
Revise tests cases to align with the new EXPLAIN QUERY PLAN output.
2021-03-20 15:11:29 +00:00
busy.test
…
cache.test
…
cacheflush.test
…
cachespill.test
…
capi2.test
…
capi3.test
Add the SQLITE_DEFAULT_DEFENSIVE compile-time option. Fix up test cases
2018-11-07 02:17:01 +00:00
capi3b.test
…
capi3c.test
Add the SQLITE_DEFAULT_DEFENSIVE compile-time option. Fix up test cases
2018-11-07 02:17:01 +00:00
capi3d.test
Add the sqlite3_stmt_isexplain() interface.
2019-03-06 14:53:27 +00:00
capi3e.test
…
carray01.test
Add a single-argument form to the CARRAY table-valued function, with
2020-11-17 14:41:37 +00:00
cast.test
Do not apply affinities when creating entries for automatic indexes on views. Fix for [95302bdb].
2020-10-03 19:16:36 +00:00
cffault.test
…
check.test
Include the original text of the CHECK constraint in the error message for
2020-08-27 18:36:30 +00:00
checkfault.test
When processing a BETWEEN or CASE expression, avoid transforming a node of the original expression into a TK_REGISTER node. Instead, take a copy and use it instead. Fix for [1be72aab9].
2019-07-17 14:34:17 +00:00
chunksize.test
Add a test case for the unix SQLITE_FCNTL_CHUNK_SIZE file-control.
2019-06-05 13:14:19 +00:00
close.test
Fix a problem that could cause a crash if a blob handle were closed after the associated database handle was closed using sqlite3_close_v2().
2019-07-15 13:58:28 +00:00
closure01.test
Fix a problem in the xBestIndex method of the closure extension causing it to
2018-05-02 08:12:22 +00:00
coalesce.test
…
collate1.test
Remove an over-zealous ALWAYS() macro and add a test case that shows that
2020-01-03 14:34:04 +00:00
collate2.test
…
collate3.test
…
collate4.test
…
collate5.test
…
collate6.test
…
collate7.test
…
collate8.test
…
collate9.test
…
collateA.test
…
collateB.test
…
colmeta.test
…
colname.test
Remove two incorrect assert() statements from the logic used to derive
2019-08-10 14:16:17 +00:00
columncount.test
Revise tests cases to align with the new EXPLAIN QUERY PLAN output.
2021-03-20 15:11:29 +00:00
conflict2.test
Include the original text of the CHECK constraint in the error message for
2020-08-27 18:36:30 +00:00
conflict3.test
Do not allow triggers that run as part of REPLACE conflict resolution
2019-12-29 22:08:20 +00:00
conflict.test
Include the original text of the CHECK constraint in the error message for
2020-08-27 18:36:30 +00:00
contrib01.test
…
corrupt2.test
Fix test cases. Avoid unnecessary tests for MemPage.nFree less than zero.
2019-02-11 17:22:30 +00:00
corrupt3.test
All TCL tests now passing.
2020-07-22 17:12:59 +00:00
corrupt4.test
…
corrupt5.test
Add the SQLITE_DEFAULT_DEFENSIVE compile-time option. Fix up test cases
2018-11-07 02:17:01 +00:00
corrupt6.test
…
corrupt7.test
…
corrupt8.test
…
corrupt9.test
…
corrupt.test
More test-case adjustments for defensive mode.
2018-11-07 14:41:08 +00:00
corruptA.test
…
corruptB.test
…
corruptC.test
Remove the legacy_file_format PRAGMA. In its place, provide the
2019-10-29 16:18:45 +00:00
corruptD.test
Fix test cases. Avoid unnecessary tests for MemPage.nFree less than zero.
2019-02-11 17:22:30 +00:00
corruptE.test
Remove the legacy_file_format PRAGMA. In its place, provide the
2019-10-29 16:18:45 +00:00
corruptF.test
…
corruptG.test
…
corruptH.test
…
corruptI.test
Add the SQLITE_DEFAULT_DEFENSIVE compile-time option. Fix up test cases
2018-11-07 02:17:01 +00:00
corruptJ.test
…
corruptK.test
Fix test cases. Avoid unnecessary tests for MemPage.nFree less than zero.
2019-02-11 17:22:30 +00:00
corruptL.test
Modify a test for corruption within the wal checkpoint code to account for the pending-byte page. And for the fact that test configurations might move the pending-byte page.
2020-08-11 18:00:10 +00:00
corruptM.test
Update corruptM.test to account for the fact that the database schema may be loaded from within the "sqlite3" command for some test permutations.
2019-10-02 19:43:38 +00:00
corruptN.test
Update an assert statement that could fail when using "PRAGMA writable_schema = 1" to access a database with a corrupt schema.
2021-04-06 18:02:17 +00:00
cost.test
Revise tests cases to align with the new EXPLAIN QUERY PLAN output.
2021-03-20 15:11:29 +00:00
count.test
Revise tests cases to align with the new EXPLAIN QUERY PLAN output.
2021-03-20 15:11:29 +00:00
countofview.test
Fix the count-of-view optimization so that it is (correctly) disabled for
2019-05-15 18:42:15 +00:00
coveridxscan.test
Revise tests cases to align with the new EXPLAIN QUERY PLAN output.
2021-03-20 15:11:29 +00:00
crash2.test
…
crash3.test
…
crash4.test
…
crash5.test
Update test helper procedure 'get_pwd' to handle the ComSpec environment variable being absent.
2021-01-18 19:27:56 +00:00
crash6.test
…
crash7.test
…
crash8.test
…
crash.test
…
crashM.test
…
crashtest1.c
…
createtab.test
Early detection of too many columns in an index avoid a possible 16-bit
2019-03-31 21:09:33 +00:00
cse.test
Avoid factoring out constant expressions on the LHS of an IN(...) operator, as the IN(...) operation may affect the affinity of these values.
2020-04-03 19:37:14 +00:00
csv01.test
Fix the csv01.test module so that it works on systems with \r\n line endings.
2019-01-03 16:03:48 +00:00
ctime.test
…
cursorhint2.test
Fix a problem causing ENABLE_CURSOR_HINTS builds to segfault.
2018-09-11 13:38:35 +00:00
cursorhint.test
Test script changes to account for the fact that the "p5" column in the EXPLAIN output is now an integer, not a text values containing a 2-digit hex value.
2020-05-15 11:26:31 +00:00
dataversion1.test
Add the SQLITE_FCNTL_DATA_VERSION file control
2018-07-18 19:09:07 +00:00
date2.test
Date/time functions with no arguments (ex: date() or time()) should be
2021-03-16 18:41:20 +00:00
date.test
…
dbdata.test
Fix an incompatibility with -DSQLITE_OMIT_LOAD_EXTENSION=1 in dbdata.test.
2019-05-01 17:36:56 +00:00
dbfuzz2-seed1.db
Initial code for a fuzzing tool on database file that works with the
2018-10-27 00:47:33 +00:00
dbfuzz2.c
Add the --lookaside SIZE COUNT command-line option to the dbfuzz2 testing tool.
2020-12-01 23:18:13 +00:00
dbfuzz001.test
Disable rootpage bounds checking when the SQLITE_TESTCTRL_EXTRA_SCHEMA_CHECKS
2020-07-22 21:05:23 +00:00
dbfuzz.c
…
dbpage.test
Add the SQLITE_DEFAULT_DEFENSIVE compile-time option. Fix up test cases
2018-11-07 02:17:01 +00:00
dbstatus2.test
…
dbstatus.test
Remove support for STAT3. The sqlite_stat3 tables are ignored, if they
2019-08-08 15:24:17 +00:00
decimal.test
New test cases for decimal and ieee754.
2020-07-15 02:15:03 +00:00
default.test
The sqlite3ExprCodeFactorable() routine should make a copy of non-factorable
2020-03-10 02:57:37 +00:00
delete2.test
…
delete3.test
…
delete4.test
Add test cases to improve coverage of VDBE branches. Still some to go.
2019-04-04 17:58:34 +00:00
delete_db.test
…
delete.test
Fix the table name aliasing on INSERT so that it occurs before the column list
2018-04-19 11:45:16 +00:00
descidx1.test
Remove the legacy_file_format PRAGMA. In its place, provide the
2019-10-29 16:18:45 +00:00
descidx2.test
Remove the legacy_file_format PRAGMA. In its place, provide the
2019-10-29 16:18:45 +00:00
descidx3.test
Remove the legacy_file_format PRAGMA. In its place, provide the
2019-10-29 16:18:45 +00:00
diskfull.test
…
distinct2.test
Sometimes it makes sense to do a full table scan rather than try to use
2020-10-22 15:47:48 +00:00
distinct.test
Also prohibit the use of rowid from a subquery. Add the
2021-04-07 15:45:01 +00:00
distinctagg.test
Fix a crash in handling queries of the form "SELECT aggregate(DISTINCT tbl.col) FROM ... LEFT JOIN tbl ...". Fixes a problem introduced by [ef4ac0ddd297bbd3].
2021-04-03 19:23:59 +00:00
e_blobbytes.test
…
e_blobclose.test
…
e_blobopen.test
…
e_blobwrite.test
…
e_changes.test
…
e_createtable.test
Revise tests cases to align with the new EXPLAIN QUERY PLAN output.
2021-03-20 15:11:29 +00:00
e_delete.test
…
e_droptrigger.test
Update requirement marks due to wording improvements in the documentation.
2020-08-08 15:40:42 +00:00
e_dropview.test
Allow "main" to be used to refer to the main database even after SQLITE_DBCONFIG_MAINDBNAME has been used to assign another alias.
2020-03-20 20:54:28 +00:00
e_expr.test
Update a requirement mark in the e_expr.test script.
2020-11-25 18:44:20 +00:00
e_fkey.test
Revise tests cases to align with the new EXPLAIN QUERY PLAN output.
2021-03-20 15:11:29 +00:00
e_fts3.test
More test-case adjustments for defensive mode.
2018-11-07 14:41:08 +00:00
e_insert.test
…
e_reindex.test
Add the SQLITE_DEFAULT_DEFENSIVE compile-time option. Fix up test cases
2018-11-07 02:17:01 +00:00
e_resolve.test
…
e_select2.test
…
e_select.test
Remove unnecessary whitespace from testcase result strings.
2018-12-22 15:46:23 +00:00
e_totalchanges.test
…
e_update.test
…
e_uri.test
…
e_vacuum.test
Minor fixes to requirements marks.
2019-04-04 18:20:25 +00:00
e_wal.test
…
e_walauto.test
…
e_walckpt.test
…
e_walhook.test
…
emptytable.test
…
enc2.test
Do not allow the "PRAGMA encoding" statement to change the database
2020-01-15 16:20:16 +00:00
enc3.test
…
enc4.test
…
enc.test
Report an error if the main, or any other, database encoding is modified by an external process (perhaps using the backup API) after the db has been opened.
2020-03-05 18:04:09 +00:00
eqp.test
Revise tests cases to align with the new EXPLAIN QUERY PLAN output.
2021-03-20 15:11:29 +00:00
errmsg.test
…
eval.test
…
exclusive2.test
…
exclusive.test
Update test file exclusive.test so that it works with the "journaltest" permutation.
2020-01-21 16:31:26 +00:00
exec.test
…
exists2.test
Do not do the EXISTS-to-IN transformation if the sub-select has LIMIT clause.
2021-03-29 20:28:27 +00:00
exists.test
…
existsfault.test
Revise tests cases to align with the new EXPLAIN QUERY PLAN output.
2021-03-20 15:11:29 +00:00
expr2.test
Update the sqlite3ExprCompare() routine so that it does not think "? IS NOT TRUE" is the same as "? IS TRUE". Fix for [d3e7f2ba5b3].
2019-05-20 10:36:15 +00:00
expr.test
Fix the sqlite3ExprImpliesNonNullRow() routine so that it correctly
2020-01-01 16:43:41 +00:00
extension01.test
…
external_reader.test
Add experimental SQLITE_FCNTL_EXTERNAL_READER file control.
2021-04-02 19:55:48 +00:00
extraquick.test
…
fallocate.test
Minor fix the fallocate.test module change from [7cd56cad5efead5]
2019-01-21 14:49:14 +00:00
filectrl.test
…
filefmt.test
…
filter1.test
Fix a problem with VM code generated for some aggregate SELECT statements that feature min()/max() aggregates both with and without FILTER clauses.
2020-07-01 14:07:45 +00:00
filter2.tcl
Add tests for the FILTER clause. And a bugfix.
2019-07-03 18:31:20 +00:00
filter2.test
Add tests for the FILTER clause. And a bugfix.
2019-07-03 18:31:20 +00:00
filterfault.test
Fix a memory leak that could follow an OOM in the new FILTER code.
2019-07-13 18:27:54 +00:00
fkey1.test
…
fkey2.test
Include the original text of the CHECK constraint in the error message for
2020-08-27 18:36:30 +00:00
fkey3.test
…
fkey4.test
…
fkey5.test
Changes to busy2.test, corruptL.test and fkey5.test so that new test cases pass with all test permutations.
2020-08-08 20:03:12 +00:00
fkey6.test
…
fkey7.test
Do not commit an "OR FAIL" statement that causes foriegn key constraint violations.
2019-05-07 19:44:11 +00:00
fkey8.test
Remove support for STAT3. The sqlite_stat3 tables are ignored, if they
2019-08-08 15:24:17 +00:00
fkey_malloc.test
…
fordelete.test
Test script changes to account for the fact that the "p5" column in the EXPLAIN output is now an integer, not a text values containing a 2-digit hex value.
2020-05-15 11:26:31 +00:00
format4.test
Remove the legacy_file_format PRAGMA. In its place, provide the
2019-10-29 16:18:45 +00:00
fts1a.test
…
fts1b.test
…
fts1c.test
…
fts1d.test
…
fts1e.test
…
fts1f.test
…
fts1i.test
…
fts1j.test
…
fts1k.test
…
fts1l.test
…
fts1m.test
…
fts1n.test
…
fts1o.test
…
fts1porter.test
…
fts2.test
…
fts2a.test
…
fts2b.test
…
fts2c.test
…
fts2d.test
…
fts2e.test
…
fts2f.test
…
fts2g.test
…
fts2h.test
…
fts2i.test
…
fts2j.test
…
fts2k.test
…
fts2l.test
…
fts2m.test
…
fts2n.test
…
fts2o.test
…
fts2p.test
…
fts2q.test
…
fts2r.test
…
fts2token.test
…
fts3_common.tcl
Fix a broken assert() in fts3. Also some test script issues causing failures with builds that do not support fts3.
2019-01-26 21:05:54 +00:00
fts3.test
…
fts3aa.test
Add new sqlite3_prepare_v3() flag SQLITE_PREPARE_NO_VTAB, for preparing
2018-12-21 19:29:11 +00:00
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
Fix a test script issue in fts3ao.test.
2018-09-10 19:34:06 +00:00
fts3atoken.test
Check for whether or not it is safe to use non-innocuous functions as the
2020-01-08 17:28:19 +00:00
fts3auto.test
Fix a case in fts3auto.test that fails for SQLITE_DISABLE_FTS4_DEFERRED builds.
2020-01-21 15:01:14 +00:00
fts3aux1.test
Revise tests cases to align with the new EXPLAIN QUERY PLAN output.
2021-03-20 15:11:29 +00:00
fts3aux2.test
Do not assume that text parameters passed to fts4aux queries do not contain embedded nul characters.
2019-01-28 13:27:25 +00:00
fts3b.test
…
fts3c.test
…
fts3comp1.test
…
fts3conf.test
…
fts3corrupt2.test
Fix a buffer overread in fts3 that could occur when decoding a corrupted record.
2020-06-12 15:17:27 +00:00
fts3corrupt3.test
Enable DEFENSIVE mode by default for tests. This requires lots of case of
2018-11-06 19:26:04 +00:00
fts3corrupt4.test
Fix a case where FTS3/4 could pass a NULL pointer to memcpy() when handling a corrupt db.
2021-02-20 19:22:32 +00:00
fts3corrupt5.test
Remove support for STAT3. The sqlite_stat3 tables are ignored, if they
2019-08-08 15:24:17 +00:00
fts3corrupt6.test
Revise tests cases to align with the new EXPLAIN QUERY PLAN output.
2021-03-20 15:11:29 +00:00
fts3corrupt.test
Improved detection of corruption in the interior nodes of a segment btree
2020-03-03 01:16:04 +00:00
fts3cov.test
Fix an assert() in fts3 that could fail due to corrupt database records.
2019-11-26 02:03:16 +00:00
fts3d.test
Add the SQLITE_DEFAULT_DEFENSIVE compile-time option. Fix up test cases
2018-11-07 02:17:01 +00:00
fts3defer2.test
Add the SQLITE_DEFAULT_DEFENSIVE compile-time option. Fix up test cases
2018-11-07 02:17:01 +00:00
fts3defer3.test
…
fts3defer.test
Add the SQLITE_DEFAULT_DEFENSIVE compile-time option. Fix up test cases
2018-11-07 02:17:01 +00:00
fts3drop.test
…
fts3e.test
…
fts3expr2.test
…
fts3expr3.test
…
fts3expr4.test
Reformat the white-space in a few test cases so that the tests work with Tcl 8.6.9.
2019-02-26 19:16:49 +00:00
fts3expr5.test
Remove support for STAT3. The sqlite_stat3 tables are ignored, if they
2019-08-08 15:24:17 +00:00
fts3expr.test
Fix compiler warnings in FTS3.
2018-04-28 04:10:55 +00:00
fts3fault2.test
…
fts3fault.test
Avoid deferencing a freed pointer following an OOM or SQLITE_CORRUPT error in
2019-01-21 17:57:31 +00:00
fts3first.test
…
fts3fuzz001.test
More aggressive early detection of orphaned and malformed autoindexes when
2019-01-10 14:33:15 +00:00
fts3join.test
Revise tests cases to align with the new EXPLAIN QUERY PLAN output.
2021-03-20 15:11:29 +00:00
fts3malloc.test
…
fts3matchinfo2.test
Fix a null pointer deference that can occur on a strange matchinfo()
2020-05-14 23:59:24 +00:00
fts3matchinfo.test
Add the SQLITE_DEFAULT_DEFENSIVE compile-time option. Fix up test cases
2018-11-07 02:17:01 +00:00
fts3misc.test
Fix an integer overflow in fts3 causing a usan error.
2020-04-22 11:11:17 +00:00
fts3near.test
…
fts3offsets.test
…
fts3prefix2.test
…
fts3prefix.test
…
fts3query.test
Revise tests cases to align with the new EXPLAIN QUERY PLAN output.
2021-03-20 15:11:29 +00:00
fts3rank.test
…
fts3rnd.test
…
fts3shared.test
…
fts3snippet2.test
Revise tests cases to align with the new EXPLAIN QUERY PLAN output.
2021-03-20 15:11:29 +00:00
fts3snippet.test
Move some new test cases from fts3snippet.test into fts3snippet2.test.
2020-05-15 01:13:46 +00:00
fts3sort.test
…
fts3tok1.test
…
fts3tok_err.test
…
fts3varint.test
Fix the fts3varint.test script so that it works even on versions of TCL
2019-04-13 16:43:58 +00:00
fts4aa.test
Improve corruption detection in fts3 shadow tables earlier in order to prevent an assert() from failing.
2020-04-16 11:35:27 +00:00
fts4check.test
Add the SQLITE_DEFAULT_DEFENSIVE compile-time option. Fix up test cases
2018-11-07 02:17:01 +00:00
fts4content.test
Prevent direct and indirect recursive content= options in fts3/4 and fts5.
2019-11-21 14:20:59 +00:00
fts4docid.test
…
fts4growth2.test
…
fts4growth.test
Enable DEFENSIVE mode by default for tests. This requires lots of case of
2018-11-06 19:26:04 +00:00
fts4incr.test
…
fts4langid.test
Fix a spurious report of corruption from the fts3/4 integrity-check triggered by using the languageid option.
2019-12-21 20:43:34 +00:00
fts4lastrowid.test
…
fts4merge2.test
…
fts4merge3.test
…
fts4merge4.test
…
fts4merge5.test
Fix a long-standing problem in fts4 incrmental merge.
2019-10-02 19:33:34 +00:00
fts4merge.test
Avoid an infinite loop in fts3/4 incremental-merge in the case where the lowest level in the database contains segments but no data (because there is a delete-marker for each valid entry). Fix for [bf1aab89].
2019-10-17 15:41:36 +00:00
fts4min.test
Optimization for "SELECT min(x) FROM tbl" where "x" is indexed and NOT NULL. This also allows similar queries on NOT NULL virtual table columns to be optimized.
2020-02-27 15:07:16 +00:00
fts4noti.test
…
fts4onepass.test
…
fts4opt.test
Add the SQLITE_DEFAULT_DEFENSIVE compile-time option. Fix up test cases
2018-11-07 02:17:01 +00:00
fts4record.test
Add extra tests for the handling of corrupt records in fts3.
2019-09-18 17:22:00 +00:00
fts4rename.test
Merge changes from trunk into the alter-table-drop-column branch.
2021-02-18 22:47:34 +00:00
fts4umlaut.test
Fix cut-and-paste error in test file fts4umlaut.test.
2018-12-22 07:16:42 +00:00
fts4unicode.test
Add extra test for handling of embedded nul characters in the fts4 unicode61 tokenizer.
2021-01-04 18:28:29 +00:00
fts4upfrom.test
Revise tests cases to align with the new EXPLAIN QUERY PLAN output.
2021-03-20 15:11:29 +00:00
fts-9fd058691.test
…
full.test
…
func2.test
…
func3.test
The affinity of the unlikely() function and its cousins should be "none".
2019-06-11 21:02:15 +00:00
func4.test
Include the original text of the CHECK constraint in the error message for
2020-08-27 18:36:30 +00:00
func5.test
Do not factor out constant functions into the initialization section at the
2020-03-11 17:58:27 +00:00
func6.test
…
func7.test
Fix possible division-by-zero in the new log() SQL functions.
2021-01-29 16:20:16 +00:00
func.test
Rename sqlite3ExprCodeAtInit() to sqlite3ExprCodeRunJustOnce().
2020-03-11 19:41:49 +00:00
fuzz2.test
…
fuzz3.test
…
fuzz4.test
Fix another problem found by Matthew Denton's new fuzzer.
2018-12-12 21:34:17 +00:00
fuzz_common.tcl
Fix a case in "fuzz.test" that could fail, as non-deterministic functions may no longer appear in CHECK constraints.
2020-01-17 11:18:54 +00:00
fuzz_malloc.test
Enhance tester.tcl so that when "--malloctrace=1" is specified, the test
2018-09-18 17:00:06 +00:00
fuzz-oss1.test
…
fuzz.test
…
fuzzcheck.c
Fix an assert() in sqlite3BtreeLast() that needs an "|| CORRUPT_DB" term.
2021-04-04 23:56:15 +00:00
fuzzdata1.db
Add more test cases from Yongheng Chen and Rui Zhong.
2019-11-22 11:38:40 +00:00
fuzzdata2.db
Add the --info option to the fuzzcheck test utility.
2018-08-06 01:39:31 +00:00
fuzzdata3.db
…
fuzzdata4.db
Fix an overzealous assert() statement discovered by OSSFuzz.
2018-08-06 01:21:53 +00:00
fuzzdata5.db
Fix a faulty assert() in the validation logic for the LEFT JOIN strength
2018-09-23 02:01:42 +00:00
fuzzdata6.db
Fuzz test cases for UPSERT.
2018-05-08 12:49:53 +00:00
fuzzdata7.db
Remove a NEVER() macro and add a test case to cause its argument to be true.
2020-02-18 23:58:58 +00:00
fuzzdata8.db
New test cases added to fuzzdata8.db.
2021-04-06 16:55:30 +00:00
fuzzer1.test
…
fuzzer2.test
…
fuzzerfault.test
Add OOM test case associated with the fix in the previous commit.
2021-02-27 15:32:02 +00:00
gcfault.test
…
gencol1.test
Fix generated columns so that they play well with upsert.
2020-06-29 20:26:50 +00:00
genesis.tcl
…
having.test
New test case for the HAVING fix of check-in [f62f983b56623f0e].
2020-12-30 13:20:27 +00:00
hexlit.test
…
hidden.test
…
hook2.test
…
hook.test
Revise tests cases to align with the new EXPLAIN QUERY PLAN output.
2021-03-20 15:11:29 +00:00
icu.test
Chagnes the ESCAPE clause on the LIKE operator to overwrite wildcard
2020-03-19 18:13:28 +00:00
ieee754.test
Add the ieee754_to_blob() and ieee754_from_blob() functions. Fix the handling
2020-06-26 15:32:29 +00:00
imposter1.test
…
in2.test
…
in3.test
…
in4.test
Revise tests cases to align with the new EXPLAIN QUERY PLAN output.
2021-03-20 15:11:29 +00:00
in5.test
When populating an ephemeral b-tree for the RHS of an IN(...) clause, avoid applying an affinity to a value that may be used later on for some other purpose. Fix for [c7a117190].
2019-08-17 19:13:49 +00:00
in6.test
At the end of the right-hand table loop of a LEFT JOIN that uses an IN
2020-03-16 03:07:53 +00:00
in.test
Include the original text of the CHECK constraint in the error message for
2020-08-27 18:36:30 +00:00
incrblob2.test
…
incrblob3.test
…
incrblob4.test
…
incrblob_err.test
Enhance tester.tcl so that when "--malloctrace=1" is specified, the test
2018-09-18 17:00:06 +00:00
incrblob.test
…
incrblobfault.test
…
incrcorrupt.test
…
incrvacuum2.test
…
incrvacuum3.test
…
incrvacuum_ioerr.test
…
incrvacuum.test
Fix an assert() that can be false when doing an incremental vacuum on a
2021-04-05 17:50:38 +00:00
index2.test
…
index3.test
Add the SQLITE_DEFAULT_DEFENSIVE compile-time option. Fix up test cases
2018-11-07 02:17:01 +00:00
index4.test
…
index5.test
…
index6.test
Revise tests cases to align with the new EXPLAIN QUERY PLAN output.
2021-03-20 15:11:29 +00:00
index7.test
Revise tests cases to align with the new EXPLAIN QUERY PLAN output.
2021-03-20 15:11:29 +00:00
index8.test
Revise tests cases to align with the new EXPLAIN QUERY PLAN output.
2021-03-20 15:11:29 +00:00
index9.test
…
index.test
Ensure that the typeof() function always returns SQLITE_FLOAT for floating
2019-05-02 17:45:52 +00:00
indexedby.test
Revise tests cases to align with the new EXPLAIN QUERY PLAN output.
2021-03-20 15:11:29 +00:00
indexexpr1.test
Revise tests cases to align with the new EXPLAIN QUERY PLAN output.
2021-03-20 15:11:29 +00:00
indexexpr2.test
Revise tests cases to align with the new EXPLAIN QUERY PLAN output.
2021-03-20 15:11:29 +00:00
indexfault.test
In sqlite3NestedParse() be sure to detect all SQLITE_NOMEM and SQLITE_TOOBIG
2019-02-22 16:18:12 +00:00
init.test
…
insert2.test
…
insert3.test
…
insert4.test
Include the original text of the CHECK constraint in the error message for
2020-08-27 18:36:30 +00:00
insert5.test
…
insert.test
Add missing VdbeCoverage() macro. Fix an off-by-one error in partial index
2019-10-26 01:43:14 +00:00
insertfault.test
Fix a segfault that could follow an OOM when querying a table that has one or more columns with default values "true" or "false".
2019-01-25 17:26:59 +00:00
instr.test
Test cases for ticket [587791f92620090e]
2019-09-17 13:30:30 +00:00
instrfault.test
Update test script instrfault.test to account for the fact that bound blob values cast to text values are now intepreted using the text encoding of the database, instead of always as utf-8.
2020-01-17 15:45:59 +00:00
intarray.test
Add the ability to unregister a virtual table module by invoking
2019-08-16 22:58:29 +00:00
interrupt2.test
…
interrupt.test
…
intpkey.test
Revise tests cases to align with the new EXPLAIN QUERY PLAN output.
2021-03-20 15:11:29 +00:00
intreal.test
Fix the OP_Affinity operator so that when applying REAL affinity, it
2019-07-29 06:06:53 +00:00
io.test
…
ioerr2.test
…
ioerr3.test
…
ioerr4.test
…
ioerr5.test
…
ioerr6.test
…
ioerr.test
…
istrue.test
Include the original text of the CHECK constraint in the error message for
2020-08-27 18:36:30 +00:00
join2.test
Revise tests cases to align with the new EXPLAIN QUERY PLAN output.
2021-03-20 15:11:29 +00:00
join3.test
…
join4.test
…
join5.test
Revise tests cases to align with the new EXPLAIN QUERY PLAN output.
2021-03-20 15:11:29 +00:00
join6.test
Fix a buffer overread found by OSSFuzz that could occur if a WITHOUT ROWID table with many columns was NATURAL JOINed against itself.
2020-09-15 20:48:30 +00:00
join.test
In the query flattener when substituting expression Y in place of expression X,
2020-09-30 15:36:03 +00:00
journal1.test
…
journal2.test
…
journal3.test
Modify journal3.test so that it can handle Tcl command "file attr <file> -perm" returning octal values in either "00755" or "0o755" format.
2019-11-25 04:15:33 +00:00
jrnlmode2.test
…
jrnlmode3.test
…
jrnlmode.test
Disable PRAGMA journal_mode=OFF when SQLITE_DBCONFIG_DEFENSIVE is turned on.
2019-05-17 20:37:17 +00:00
json101.test
Proper surrogate pair decoding added to JSON functions. See the mailing list
2019-11-10 11:09:06 +00:00
json102.test
…
json103.test
Get the json_group_array() and json_group_object() SQL functions working
2018-07-05 20:05:29 +00:00
json104.test
Remove support for STAT3. The sqlite_stat3 tables are ignored, if they
2019-08-08 15:24:17 +00:00
json105.test
Extend the json-path mechanism with array indexes of the form "#" or "#-n" for
2019-11-22 17:37:56 +00:00
keyword1.test
…
kvtest.c
Extend the refactoring into extensions. Clean up stray newlines.
2020-06-19 15:24:12 +00:00
lastinsert.test
…
laststmtchanges.test
…
lemon-test01.y
Add a simple test case for Lemon. Always include assert.h in the
2018-11-27 14:34:33 +00:00
like2.test
…
like3.test
Revise tests cases to align with the new EXPLAIN QUERY PLAN output.
2021-03-20 15:11:29 +00:00
like.test
Revise tests cases to align with the new EXPLAIN QUERY PLAN output.
2021-03-20 15:11:29 +00:00
limit2.test
Fix multiple issues with the ORDER BY LIMIT optimization. This is the
2018-09-08 20:09:46 +00:00
limit.test
Fix the processing of implied LIMIT clauses when flattening a compound
2021-03-05 14:08:45 +00:00
loadext2.test
…
loadext.test
Fix the regexp used to recognize libdl errors on OS-X.
2018-11-17 14:59:35 +00:00
lock2.test
…
lock3.test
…
lock4.test
…
lock5.test
…
lock6.test
…
lock7.test
…
lock_common.tcl
Copy some extra test infrastructure from the mutexfree-shmlock branch to trunk.
2018-12-24 15:22:47 +00:00
lock.test
…
lookaside.test
Avoid incrementing the SQLITE_LOOKASIDE_MISS_SIZE stat before sqlite3_open()
2018-09-18 17:50:34 +00:00
main.test
…
make-where7.tcl
…
malloc3.test
…
malloc4.test
…
malloc5.test
Update a test case in malloc5.test to take into account that malloc()
2018-06-02 17:00:57 +00:00
malloc6.test
…
malloc7.test
…
malloc8.test
…
malloc9.test
…
malloc_common.tcl
…
malloc.test
…
mallocA.test
Remove support for STAT3. The sqlite_stat3 tables are ignored, if they
2019-08-08 15:24:17 +00:00
mallocAll.test
…
mallocB.test
…
mallocC.test
…
mallocD.test
…
mallocE.test
…
mallocF.test
…
mallocG.test
…
mallocH.test
…
mallocI.test
…
mallocJ.test
…
mallocK.test
Revise tests cases to align with the new EXPLAIN QUERY PLAN output.
2021-03-20 15:11:29 +00:00
mallocL.test
…
mallocM.test
…
malloctraceviewer.tcl
Enhance tester.tcl so that when "--malloctrace=1" is specified, the test
2018-09-18 17:00:06 +00:00
manydb.test
…
mem5.test
…
memdb1.test
Do not invoke the xDelete method when converting to PRAGMA journal_mode=OFF
2021-04-05 13:41:42 +00:00
memdb.test
…
memleak.test
…
memsubsys1.test
…
memsubsys2.test
…
minmax2.test
Also prohibit the use of rowid from a subquery. Add the
2021-04-07 15:45:01 +00:00
minmax3.test
…
minmax4.test
Add tests to ensure that this branch really does fix ticket [f8a7060ece].
2019-08-17 18:16:59 +00:00
minmax.test
Also prohibit the use of rowid from a subquery. Add the
2021-04-07 15:45:01 +00:00
misc1.test
Do not set the Cursor.seekOp test variable in the OP_NotExists opcode.
2018-12-20 22:08:32 +00:00
misc2.test
Also prohibit the use of rowid from a subquery. Add the
2021-04-07 15:45:01 +00:00
misc3.test
…
misc4.test
Add the SQLITE_DEFAULT_DEFENSIVE compile-time option. Fix up test cases
2018-11-07 02:17:01 +00:00
misc5.test
Add the SQLITE_DEFAULT_DEFENSIVE compile-time option. Fix up test cases
2018-11-07 02:17:01 +00:00
misc6.test
…
misc7.test
Test result adjustments in test/misc7.test due to the EQP format change.
2021-03-23 19:39:27 +00:00
misc8.test
Also prohibit the use of rowid from a subquery. Add the
2021-04-07 15:45:01 +00:00
misuse.test
…
mjournal.test
Add the SQLITE_DEFAULT_DEFENSIVE compile-time option. Fix up test cases
2018-11-07 02:17:01 +00:00
mmap1.test
Minor fixes for problems revealed by releasetest.tcl.
2018-09-07 11:51:21 +00:00
mmap2.test
…
mmap3.test
…
mmap4.test
…
mmapfault.test
…
mmapwarm.test
…
multiplex2.test
…
multiplex3.test
…
multiplex4.test
…
multiplex.test
…
mutex1.test
Further refactoring of the schema table name.
2020-06-19 13:33:53 +00:00
mutex2.test
…
nan.test
…
nockpt.test
…
nolock.test
…
normalize.test
Enhancements to SQL query normalization for UPDATE statements.
2019-10-16 17:46:22 +00:00
notify1.test
…
notify2.test
…
notify3.test
…
notnull2.test
Revise tests cases to align with the new EXPLAIN QUERY PLAN output.
2021-03-20 15:11:29 +00:00
notnull.test
Add the SQLITE_DEFAULT_DEFENSIVE compile-time option. Fix up test cases
2018-11-07 02:17:01 +00:00
notnullfault.test
Revise tests cases to align with the new EXPLAIN QUERY PLAN output.
2021-03-20 15:11:29 +00:00
null.test
Back out the incorrect optimization of check-in [e51ecadcbdef5ce6] as
2020-09-30 17:32:22 +00:00
nulls1.test
Revise tests cases to align with the new EXPLAIN QUERY PLAN output.
2021-03-20 15:11:29 +00:00
numcast.test
…
numindex1.test
…
offset1.test
…
openv2.test
…
optfuzz-db01.c
Extend the refactoring into extensions. Clean up stray newlines.
2020-06-19 15:24:12 +00:00
optfuzz-db01.txt
…
optfuzz.c
…
orderby1.test
Revise tests cases to align with the new EXPLAIN QUERY PLAN output.
2021-03-20 15:11:29 +00:00
orderby2.test
…
orderby3.test
…
orderby4.test
…
orderby5.test
Fix an incorrect assert() statement that was added yesterday.
2020-02-13 11:46:47 +00:00
orderby6.test
…
orderby7.test
…
orderby8.test
…
orderby9.test
…
orderbyA.test
Allow SQLite to omit redundant ORDER BY sorts in the case where a SELECT statement has GROUP BY and ORDER BY clauses that use the same expressions, even when the ORDER BY expressions are marked "DESC".
2019-09-21 15:44:12 +00:00
oserror.test
Changes to oserror.test so that it works even on systems that allow
2019-04-29 16:44:11 +00:00
ossfuzz.c
Fix a bug in the hard_heap_limit pragma so that it returns the new value of
2019-11-14 17:46:32 +00:00
ossshell.c
…
ovfl.test
…
pager1.test
Include the original text of the CHECK constraint in the error message for
2020-08-27 18:36:30 +00:00
pager2.test
…
pager3.test
…
pager4.test
…
pagerfault2.test
…
pagerfault3.test
…
pagerfault.test
…
pageropt.test
…
pagesize.test
…
parser1.test
Add the SQLITE_DEFAULT_DEFENSIVE compile-time option. Fix up test cases
2018-11-07 02:17:01 +00:00
pcache2.test
…
pcache.test
…
percentile.test
…
permutations.test
Have the Tcl tests support environment variable SQLITE_TEST_PATTERN_LIST, so that if it is set it is interpreted as a list of patterns that are matched against tests file names. Only test files that match at least one pattern are run.
2021-03-11 08:49:52 +00:00
pg_common.tcl
Allow a FROM clause in UPDATE statements.
2020-04-27 20:55:33 +00:00
pragma2.test
…
pragma3.test
Fix "PRAGMA data_version" so that it works the same way with locking_mode=PERSIST and journal_mode=PERSIST configured. Fix for 7a458c2a5f.
2019-12-22 14:29:55 +00:00
pragma4.test
Fix minor test script problems.
2020-08-10 10:43:43 +00:00
pragma5.test
Enhance PRAGMA function_list so that it shows all instances of each FuncDef,
2020-01-04 01:43:02 +00:00
pragma.test
Add the ability to do a PRAGMA integrity_check (or quick_check) on a single
2020-07-23 00:45:06 +00:00
pragmafault.test
…
prefixes.test
Add scalar function "prefix_length()" to ext/misc/prefixes.c.
2019-01-14 20:44:00 +00:00
printf2.test
…
printf.test
Modify a test file to avoid causing Tcl to allocate too much memory.
2020-06-09 13:53:56 +00:00
progress.test
…
ptrchng.test
…
pushdown.test
…
queryonly.test
…
quick.test
…
quota2.test
…
quota-glob.test
…
quota.test
…
quote.test
An additional test case
2021-03-14 20:17:06 +00:00
randexpr1.tcl
…
randexpr1.test
…
rbu.test
…
rdonly.test
…
recover.test
Fix a problem with running the ".recover" command on a database that is zero pages in size.
2019-05-09 11:45:21 +00:00
regexp1.test
…
regexp2.test
…
reindex.test
Fix an assert() and potential buffer overrun in fts5 that could occur if the database was corrupt.
2019-05-14 11:33:09 +00:00
releasetest_data.tcl
Fix a problem preventing wapptest from setting SQLITE_ENABLE_LOCKING_STYLE for OSX tests. Also modify the "Sanitize" configuration in releasetest_data.tcl to subsume test item 6g.
2021-03-10 10:43:17 +00:00
releasetest.tcl
Update error detection logic in releasetest.tcl to account for new
2019-10-02 19:44:42 +00:00
resetdb.test
Update test file "resetdb.test" so that it works with the "prepare" permutation.
2019-02-05 08:55:43 +00:00
resolver01.test
…
returning1.test
Raise an error if a query tries to access the "rowid" of a view, as views
2021-04-06 19:13:44 +00:00
rollback2.test
Revise tests cases to align with the new EXPLAIN QUERY PLAN output.
2021-03-20 15:11:29 +00:00
rollback.test
…
rollbackfault.test
…
round1.test
Improved rounding even on systems with an 8-byte "long double" type.
2019-05-27 00:29:15 +00:00
rowallock.test
…
rowhash.test
…
rowid.test
Fix a problem with the fix for [9cf6c9bb51] (commit [658b84d7]) that could cause a cursor to be left in an invalid state following a (rowid < text-value) search.
2019-05-14 20:25:22 +00:00
rowvalue2.test
…
rowvalue3.test
…
rowvalue4.test
Revise tests cases to align with the new EXPLAIN QUERY PLAN output.
2021-03-20 15:11:29 +00:00
rowvalue5.test
…
rowvalue6.test
…
rowvalue7.test
Improved detection of number of column mismatch for vector assignment
2019-08-26 14:18:28 +00:00
rowvalue8.test
…
rowvalue9.test
…
rowvalue.test
Revise tests cases to align with the new EXPLAIN QUERY PLAN output.
2021-03-20 15:11:29 +00:00
rowvaluefault.test
…
rowvaluevtab.test
Fix a problem with using views in SQLITE_OMIT_VIRTUAL_TABLE builds. Also some test case fixes required for the same builds.
2020-01-21 16:23:17 +00:00
rtree.test
…
run-wordcount.sh
…
savepoint2.test
…
savepoint4.test
…
savepoint5.test
…
savepoint6.test
…
savepoint7.test
…
savepoint.test
…
savepointfault.test
…
scanstatus.test
Tweaks to test/scanstatus.test to account for the new EQP format.
2021-03-23 15:39:02 +00:00
schema2.test
…
schema3.test
…
schema4.test
…
schema5.test
…
schema6.test
…
schema.test
The sqlite3_set_authorizer() interface should only expire prepared statements
2019-08-01 22:48:45 +00:00
schemafault.test
Avoid leaving view-definitions with an incomplete set of column names/types in
2018-07-09 18:55:44 +00:00
securedel2.test
…
securedel.test
…
select1.test
Fix incorrect test name labels in the select1.test script.
2021-02-13 18:14:15 +00:00
select2.test
…
select3.test
Avoid deleting expression nodes in the flattener code, as they may be referenced by AggInfo objects further up the stack.
2020-06-13 21:24:40 +00:00
select4.test
Defer deletion of expressions that are optimized out by the AND optimizer
2021-03-31 13:31:33 +00:00
select5.test
Calculate non-aggregate expressions in the SELECT list of an aggregate query
2018-06-05 20:04:28 +00:00
select6.test
Fix the query flattener optimization so that it preserve the "SF_Compound"
2019-05-29 17:22:38 +00:00
select7.test
…
select8.test
…
select9.test
Revise tests cases to align with the new EXPLAIN QUERY PLAN output.
2021-03-20 15:11:29 +00:00
selectA.test
Revise tests cases to align with the new EXPLAIN QUERY PLAN output.
2021-03-20 15:11:29 +00:00
selectB.test
…
selectC.test
Allow sub-queries that use UNION ALL to be flattened, even if the parent query is a join. Still some problems on this branch.
2020-12-16 20:00:46 +00:00
selectD.test
Revise tests cases to align with the new EXPLAIN QUERY PLAN output.
2021-03-20 15:11:29 +00:00
selectE.test
…
selectF.test
…
selectG.test
…
server1.test
Disable the server1.test script on old PPC Macs due to problems in the
2018-08-28 21:12:02 +00:00
session.test
…
sessionfuzz-data1.db
…
sessionfuzz.c
Add the OMIT_ZLIB compile-time option to sessionfuzz.c. (Originally
2020-07-23 18:03:14 +00:00
shared2.test
…
shared3.test
More test case changes so that shared-cache mode tests all work
2020-11-19 21:01:11 +00:00
shared4.test
…
shared6.test
…
shared7.test
…
shared8.test
Add the SQLITE_DEFAULT_DEFENSIVE compile-time option. Fix up test cases
2018-11-07 02:17:01 +00:00
shared9.test
…
shared_err.test
…
shared.test
Enhance the unix VFS so that it removes extra "/", "/./" and "/../" from
2020-11-16 18:45:21 +00:00
sharedA.test
…
sharedB.test
…
sharedlock.test
…
shell1.test
New CLI command: ".stats vmstep" enables the display of the virtual-machine
2021-01-09 19:10:04 +00:00
shell2.test
…
shell3.test
…
shell4.test
New CLI command: ".stats vmstep" enables the display of the virtual-machine
2021-01-09 19:10:04 +00:00
shell5.test
Enhancements to the ".import" command of the CLI.
2020-03-09 15:39:39 +00:00
shell6.test
…
shell7.test
…
shell8.test
…
shmlock.test
Fix the shmlock.test script so that it works with the Windows restriction
2019-01-03 16:00:23 +00:00
shortread1.test
…
show_speedtest1_rtree.tcl
…
shrink.test
…
sidedelete.test
…
skipscan1.test
Revise tests cases to align with the new EXPLAIN QUERY PLAN output.
2021-03-20 15:11:29 +00:00
skipscan2.test
Revise tests cases to align with the new EXPLAIN QUERY PLAN output.
2021-03-20 15:11:29 +00:00
skipscan3.test
…
skipscan5.test
Revise tests cases to align with the new EXPLAIN QUERY PLAN output.
2021-03-20 15:11:29 +00:00
skipscan6.test
Revise tests cases to align with the new EXPLAIN QUERY PLAN output.
2021-03-20 15:11:29 +00:00
snapshot2.test
Add the SQLITE_DEFAULT_DEFENSIVE compile-time option. Fix up test cases
2018-11-07 02:17:01 +00:00
snapshot3.test
Add the SQLITE_DEFAULT_DEFENSIVE compile-time option. Fix up test cases
2018-11-07 02:17:01 +00:00
snapshot4.test
Add the SQLITE_DEFAULT_DEFENSIVE compile-time option. Fix up test cases
2018-11-07 02:17:01 +00:00
snapshot_fault.test
Update the coverage-wal permutation to cover branches enabled by
2018-12-26 18:34:56 +00:00
snapshot_up.test
Add the SQLITE_DEFAULT_DEFENSIVE compile-time option. Fix up test cases
2018-11-07 02:17:01 +00:00
snapshot.test
If a call to sqlite3_snapshot_open() fails because the requested snapshot no
2018-08-31 19:00:16 +00:00
soak.test
Fix a test script error causing tests to fail in soak.test.
2018-04-27 16:35:44 +00:00
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
Slightly faster tokenization of non-keyword identifiers.
2020-12-02 00:20:00 +00:00
spellfix2.test
…
spellfix3.test
…
spellfix4.test
…
spellfix.test
…
sqldiff1.test
…
sqllimits1.test
Fix a problem caused by a small SQLITE_LIMIT_LENGTH value and a CREATE TABLE with a very large name.
2019-04-09 20:50:44 +00:00
sqllog.test
…
startup.c
Add the "startup" test program designed to measure startup performance,
2021-01-01 15:13:17 +00:00
stat.test
Further refactoring of the schema table name.
2020-06-19 13:33:53 +00:00
statfault.test
…
stmt.test
…
stmtvtab1.test
…
subjournal.test
…
subquery2.test
Ensure that when an ephemeral cursor is reopened with a second invocation of to OP_OpenEphemeral, the sequence counter is reset and the cache marked as stale. Fix for [9cdc5c46].
2019-06-26 21:04:30 +00:00
subquery.test
…
subselect.test
…
substr.test
Allow "substring()" as an alias for "substr()" for compatibility with other
2020-11-23 14:50:43 +00:00
subtype1.test
…
superlock.test
…
swarmvtab2.test
…
swarmvtab3.test
Add the SQLITE_DEFAULT_DEFENSIVE compile-time option. Fix up test cases
2018-11-07 02:17:01 +00:00
swarmvtab.test
…
swarmvtabfault.test
Add the SQLITE_DEFAULT_DEFENSIVE compile-time option. Fix up test cases
2018-11-07 02:17:01 +00:00
symlink2.test
Add support for the SQLITE_ACCESS_SYMLINK flag in the Win32 VFS.
2019-11-18 23:48:03 +00:00
symlink.test
Add support for SQLITE_OPEN_NOFOLLOW.
2019-11-18 17:46:38 +00:00
sync2.test
…
sync.test
…
syscall.test
…
sysfault.test
…
tabfunc01.test
Fix table-valued functions so that they will work as the right table
2019-11-15 00:52:13 +00:00
table.test
Add the SQLITE_DEFAULT_DEFENSIVE compile-time option. Fix up test cases
2018-11-07 02:17:01 +00:00
tableapi.test
Enhance tester.tcl so that when "--malloctrace=1" is specified, the test
2018-09-18 17:00:06 +00:00
tableopts.test
…
tclsqlite.test
Disable a redundant test case that uses a very large stack, and hence
2020-01-18 19:07:00 +00:00
tempdb2.test
Remove support for STAT3. The sqlite_stat3 tables are ignored, if they
2019-08-08 15:24:17 +00:00
tempdb.test
…
tempfault.test
…
temptable2.test
…
temptable3.test
…
temptable.test
…
temptrigger.test
…
tester.tcl
Corrections to the 'filepath_normalize' test suite helper procedure.
2021-02-03 19:38:40 +00:00
thread1.test
…
thread2.test
…
thread001.test
…
thread002.test
…
thread003.test
…
thread004.test
…
thread005.test
…
thread_common.tcl
…
threadtest1.c
…
threadtest2.c
…
threadtest3.c
Fix a tsan error that could occur when using shared-cache mode.
2020-09-04 19:10:43 +00:00
threadtest4.c
…
time-wordcount.sh
…
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
…
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
More test case changes so that shared-cache mode tests all work
2020-11-19 21:01:11 +00:00
tkt2920.test
…
tkt2927.test
…
tkt2942.test
…
tkt3080.test
…
tkt3093.test
…
tkt3121.test
…
tkt3201.test
…
tkt3292.test
Remove the legacy_file_format PRAGMA. In its place, provide the
2019-10-29 16:18:45 +00:00
tkt3298.test
…
tkt3334.test
…
tkt3346.test
…
tkt3357.test
…
tkt3419.test
…
tkt3424.test
…
tkt3442.test
Revise tests cases to align with the new EXPLAIN QUERY PLAN output.
2021-03-20 15:11:29 +00:00
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
More test case changes so that shared-cache mode tests all work
2020-11-19 21:01:11 +00:00
tkt3810.test
Suppress errors associated with TEMP triggers that reference objects in
2020-11-05 19:13:44 +00:00
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
Always clear the temporary register cache after coding a subroutine.
2019-09-18 20:34:54 +00:00
tkt-3fe897352e.test
Back out the change from [7fab1393c2b22b1f] that tries to convert invalid
2020-05-20 15:02:04 +00:00
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
Revise tests cases to align with the new EXPLAIN QUERY PLAN output.
2021-03-20 15:11:29 +00:00
tkt-80ba201079.test
Remove debugging pragmas accidently left in by a prior change.
2019-01-04 12:46:01 +00:00
tkt-80e031a00f.test
…
tkt-91e2e8ba6f.test
…
tkt-94c04eaadb.test
…
tkt-385a5b56b9.test
Revise tests cases to align with the new EXPLAIN QUERY PLAN output.
2021-03-20 15:11:29 +00:00
tkt-752e1646fc.test
…
tkt-8454a207b9.test
…
tkt-18458b1a.test
Remove the legacy_file_format PRAGMA. In its place, provide the
2019-10-29 16:18:45 +00:00
tkt-31338dca7e.test
…
tkt-54844eea3f.test
…
tkt-313723c356.test
…
tkt-868145d012.test
…
tkt-3998683a16.test
…
tkt-a7b7803e.test
…
tkt-a7debbe0.test
Remove the legacy_file_format PRAGMA. In its place, provide the
2019-10-29 16:18:45 +00:00
tkt-a8a0d2996a.test
When casting string values into numeric and the string has a prefix that looks
2019-06-07 22:26:08 +00:00
tkt-b1d3a2e531.test
…
tkt-b75a9ca6b0.test
Revise tests cases to align with the new EXPLAIN QUERY PLAN output.
2021-03-20 15:11:29 +00:00
tkt-b351d95f9.test
…
tkt-b72787b1.test
…
tkt-ba7cbfaedc.test
…
tkt-bd484a090c.test
…
tkt-bdc6bbbb38.test
…
tkt-c48d99d690.test
…
tkt-c694113d5.test
Do not abort running queries due to a CREATE INDEX statement. Allow them
2018-07-24 22:02:12 +00:00
tkt-cbd054fa6b.test
Remove support for STAT3. The sqlite_stat3 tables are ignored, if they
2019-08-08 15:24:17 +00:00
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
Revise tests cases to align with the new EXPLAIN QUERY PLAN output.
2021-03-20 15:11:29 +00:00
trace2.test
…
trace3.test
Fix a problem with sqlite3_expanded_sql() that could occur with statements that use both numbered (e.g. "?1") and unnumbered (i.e. "?") parameters.
2020-12-17 11:24:26 +00:00
trace.test
…
trans2.test
…
trans3.test
…
trans.test
Add support for the sqlite3_txn_state() interface.
2020-08-25 19:09:07 +00:00
transitive1.test
Revise tests cases to align with the new EXPLAIN QUERY PLAN output.
2021-03-20 15:11:29 +00:00
trigger1.test
Fix a false-positive in the register validity tracking logic by moving the
2020-01-04 15:21:47 +00:00
trigger2.test
Fix a problem in VIEW creation that was introduced by the generated columns
2019-11-02 17:59:10 +00:00
trigger3.test
…
trigger4.test
…
trigger5.test
…
trigger6.test
…
trigger7.test
Add the SQLITE_DEFAULT_DEFENSIVE compile-time option. Fix up test cases
2018-11-07 02:17:01 +00:00
trigger8.test
…
trigger9.test
Raise an error if a query tries to access the "rowid" of a view, as views
2021-04-06 19:13:44 +00:00
triggerA.test
Enhance tester.tcl so that when "--malloctrace=1" is specified, the test
2018-09-18 17:00:06 +00:00
triggerB.test
…
triggerC.test
Remove support for STAT3. The sqlite_stat3 tables are ignored, if they
2019-08-08 15:24:17 +00:00
triggerD.test
…
triggerE.test
Fix a problem caused by using an SQL variable in an OVER clause within a trigger program.
2021-01-21 15:40:52 +00:00
triggerF.test
Remove unnecessary whitespace from testcase result strings.
2018-12-22 15:46:23 +00:00
triggerG.test
Fix a problem with using views in SQLITE_OMIT_VIRTUAL_TABLE builds. Also some test case fixes required for the same builds.
2020-01-21 16:23:17 +00:00
triggerupfrom.test
Revise tests cases to align with the new EXPLAIN QUERY PLAN output.
2021-03-20 15:11:29 +00:00
trustschema1.test
Fix a problem that restricted edgy functions in TEMP tables.
2020-01-09 01:20:03 +00:00
tt3_checkpoint.c
…
tt3_index.c
…
tt3_lookaside1.c
…
tt3_shared.c
Fix a tsan error that could occur when using shared-cache mode.
2020-09-04 19:10:43 +00:00
tt3_stress.c
Extend the refactoring into extensions. Clean up stray newlines.
2020-06-19 15:24:12 +00:00
tt3_vacuum.c
…
types2.test
…
types3.test
…
types.test
…
unionall2.test
Avoid coding unindexed WHERE constraints if an equivalent transitive term has already been coded by an outer loop.
2021-04-05 16:20:59 +00:00
unionall.test
Fix a problem in the unreleased union-all flattening code.
2021-02-13 14:26:25 +00:00
unionallfault.test
When flattening UNION ALL subqueries into a join query, ensure that separate cursor numbers are used for each segment of the newly flattened query.
2020-12-18 16:13:39 +00:00
unionvtab.test
Remove unnecessary whitespace from testcase result strings.
2018-12-22 15:46:23 +00:00
unionvtabfault.test
Add the SQLITE_DEFAULT_DEFENSIVE compile-time option. Fix up test cases
2018-11-07 02:17:01 +00:00
unique2.test
…
unique.test
…
unixexcl.test
…
unordered.test
Revise tests cases to align with the new EXPLAIN QUERY PLAN output.
2021-03-20 15:11:29 +00:00
update2.test
Make sure cursors are opened on all indexes for an UPDATE OR REPLACE
2019-01-22 13:45:48 +00:00
update.test
Do not allow triggers that run as part of REPLACE conflict resolution
2019-12-29 22:08:20 +00:00
upfrom1.tcl
Make it an error to repeat the target object/alias of an UPDATE statement in its FROM clause.
2020-07-17 16:31:37 +00:00
upfrom1.test
Fix a corner-case error in the new UPDATE FROM logic helpfully discovered
2020-07-20 18:07:35 +00:00
upfrom2.test
Revise tests cases to align with the new EXPLAIN QUERY PLAN output.
2021-03-20 15:11:29 +00:00
upfrom3.test
Revise tests cases to align with the new EXPLAIN QUERY PLAN output.
2021-03-20 15:11:29 +00:00
upfromfault.test
Revise tests cases to align with the new EXPLAIN QUERY PLAN output.
2021-03-20 15:11:29 +00:00
upsert1.test
If an UPSERT can cause an Abort due to a constraint failure, make sure
2019-12-26 23:40:33 +00:00
upsert2.test
Fix the table name aliasing on INSERT so that it occurs before the column list
2018-04-19 11:45:16 +00:00
upsert3.test
Fix the table name aliasing on INSERT so that it occurs before the column list
2018-04-19 11:45:16 +00:00
upsert4.test
A few more tests for upsert.
2018-04-21 14:11:18 +00:00
upsert5.test
Fix a crash that could occur when an INSERT has more than one ON CONFLICT clause, at least one of which contains an unresolvable symbol.
2021-03-19 14:26:24 +00:00
upsertfault.test
A few more tests for upsert.
2018-04-21 14:11:18 +00:00
uri2.test
…
uri.test
…
userauth01.test
…
utf16align.test
…
vacuum2.test
Avoid loading large intkey rows when VACUUMing, even if the page-size is changing.
2020-12-09 16:32:11 +00:00
vacuum3.test
…
vacuum4.test
…
vacuum5.test
…
vacuum6.test
Fix an assert() broken by recent changes to vacuum.
2020-12-11 19:01:24 +00:00
vacuum-into.test
Enhance the VACUUM INTO command so that it works on read-only databases.
2019-03-19 20:42:42 +00:00
vacuum.test
…
vacuummem.test
…
varint.test
…
veryquick.test
…
view.test
Modify the SQLITE_DBCONFIG_ENABLE_VIEW option so that it always permits
2021-03-05 18:33:01 +00:00
vtab1.test
Add the ability to unregister a virtual table module by invoking
2019-08-16 22:58:29 +00:00
vtab2.test
…
vtab3.test
…
vtab4.test
…
vtab5.test
…
vtab6.test
…
vtab7.test
…
vtab8.test
…
vtab9.test
…
vtab_alter.test
…
vtab_err.test
Fix a failing assert() in sqlite3ResetAllSchemasOfConnection().
2018-11-27 19:47:55 +00:00
vtab_shared.test
…
vtabA.test
…
vtabB.test
…
vtabC.test
…
vtabD.test
…
vtabdrop.test
Fix a problem causing the sqlite_master entry corresponding to a virtual table
2018-12-28 17:45:08 +00:00
vtabE.test
…
vtabF.test
…
vtabH.test
Update test cases so that they work with ICU enabled.
2019-08-13 17:56:56 +00:00
vtabI.test
…
vtabJ.test
Fix UPDATE FROM statements on virtual tables that are declared WITHOUT ROWID.
2020-10-12 14:29:11 +00:00
wal2.test
Fix a couple of test scripts to match the new wal recovery behaviour on this branch.
2020-07-27 15:05:20 +00:00
wal3.test
…
wal4.test
…
wal5.test
…
wal6.test
…
wal7.test
…
wal8.test
…
wal9.test
…
wal64k.test
In the unix VFS, fix the heap shm allocator (used for unix-excl)
2018-10-11 02:39:11 +00:00
wal_common.tcl
…
wal.test
Do not confuse the constant SQLITE_MAX_ATTACHED with the maximum number of
2021-03-10 16:35:37 +00:00
walbak.test
…
walbig.test
…
walblock.test
…
walcksum.test
…
walcrash2.test
…
walcrash3.test
…
walcrash4.test
…
walcrash.test
…
walfault2.test
Avoid attempting to delete a file while it is still open in walfault2.test.
2019-02-06 19:42:02 +00:00
walfault.test
…
walhook.test
…
walmode.test
…
walnoshm.test
…
waloverwrite.test
…
walpersist.test
…
walprotocol2.test
In wal mode, if a "BEGIN EXCLUSIVE" command (or any other command that
2018-07-05 15:46:55 +00:00
walprotocol.test
Fix a couple of test scripts to match the new wal recovery behaviour on this branch.
2020-07-27 15:05:20 +00:00
walro2.test
…
walro.test
…
walrofault.test
…
walsetlk.test
Revise tests cases to align with the new EXPLAIN QUERY PLAN output.
2021-03-20 15:11:29 +00:00
walshared.test
…
walslow.test
…
walthread.test
…
walvfs.test
Fix a test script problem in walvfs.test.
2020-12-04 16:26:25 +00:00
wapp.tcl
Add test/wapptest.tcl, a wapp alternative to releasetest.tcl.
2019-04-09 19:53:32 +00:00
wapptest.tcl
Fix harmless USAN warnings from gcc9.
2020-08-11 21:53:42 +00:00
where2.test
Revise tests cases to align with the new EXPLAIN QUERY PLAN output.
2021-03-20 15:11:29 +00:00
where3.test
Revise tests cases to align with the new EXPLAIN QUERY PLAN output.
2021-03-20 15:11:29 +00:00
where4.test
…
where5.test
…
where6.test
…
where7.test
Revise tests cases to align with the new EXPLAIN QUERY PLAN output.
2021-03-20 15:11:29 +00:00
where8.test
Add the "sorter-reference" optimization, allowing SQLite to be configured so
2018-04-18 19:56:14 +00:00
where9.test
Revise tests cases to align with the new EXPLAIN QUERY PLAN output.
2021-03-20 15:11:29 +00:00
where.test
Revise tests cases to align with the new EXPLAIN QUERY PLAN output.
2021-03-20 15:11:29 +00:00
whereA.test
Disable the OP_SeekScan opcode of the in-scan-vs-index optimization when
2020-10-02 02:02:18 +00:00
whereB.test
…
whereC.test
…
whereD.test
In the OP_Column opcode, if the cursor is marked NullRow (due to being the
2020-02-22 13:01:19 +00:00
whereE.test
Revise tests cases to align with the new EXPLAIN QUERY PLAN output.
2021-03-20 15:11:29 +00:00
whereF.test
Revise tests cases to align with the new EXPLAIN QUERY PLAN output.
2021-03-20 15:11:29 +00:00
wherefault.test
…
whereG.test
Revise tests cases to align with the new EXPLAIN QUERY PLAN output.
2021-03-20 15:11:29 +00:00
whereH.test
…
whereI.test
Revise tests cases to align with the new EXPLAIN QUERY PLAN output.
2021-03-20 15:11:29 +00:00
whereJ.test
Revise tests cases to align with the new EXPLAIN QUERY PLAN output.
2021-03-20 15:11:29 +00:00
whereK.test
Revise tests cases to align with the new EXPLAIN QUERY PLAN output.
2021-03-20 15:11:29 +00:00
whereL.test
Revise tests cases to align with the new EXPLAIN QUERY PLAN output.
2021-03-20 15:11:29 +00:00
wherelfault.test
…
wherelimit2.test
Fix test case result on a DELETE with an INDEXED BY clause due to
2020-07-18 18:59:11 +00:00
wherelimit.test
Fix incorrect RETURNING test cases in wherelimit.test
2021-04-06 13:57:23 +00:00
win32heap.test
…
win32lock.test
…
win32longpath.test
Enhancements to long-path support in the Win32 VFS.
2020-05-15 01:18:07 +00:00
win32nolock.test
…
window1.test
Do not allow floating point rounding errors to cause a window function xInverse() function to be invoked before the corresponding xStep() call.
2021-04-05 19:05:18 +00:00
window2.tcl
Do not mistake constant integers in a PARTITION BY expression for references to ORDER BY style references to values returned by the SELECT statement.
2019-12-27 15:31:47 +00:00
window2.test
Do not mistake constant integers in a PARTITION BY expression for references to ORDER BY style references to values returned by the SELECT statement.
2019-12-27 15:31:47 +00:00
window3.tcl
Implement the EXCLUDE clause for window frames.
2019-03-15 20:46:19 +00:00
window3.test
Add further tests for new window function functionality.
2019-03-18 21:19:40 +00:00
window4.tcl
Fix handling of window functions in aggregate queries that have no GROUP BY clause. Also remove a faulty assert causing the error reported in [618156e3].
2020-03-16 18:52:53 +00:00
window4.test
Fix handling of window functions in aggregate queries that have no GROUP BY clause. Also remove a faulty assert causing the error reported in [618156e3].
2020-03-16 18:52:53 +00:00
window5.test
Add the SQLITE_DEFAULT_DEFENSIVE compile-time option. Fix up test cases
2018-11-07 02:17:01 +00:00
window6.test
Remove support for STAT3. The sqlite_stat3 tables are ignored, if they
2019-08-08 15:24:17 +00:00
window7.tcl
Support some "ROWS BETWEEN N PRECEDING AND M FOLLOWING" window functions without caching entire partitions.
2019-03-04 21:07:11 +00:00
window7.test
Fix problems with window frames that use ORDER BY ... NULLS LAST etc.
2019-08-19 19:59:50 +00:00
window8.tcl
Fix handling of NULL, text and blob values in window queries that use "RANGE BETWEEN A FOLLOWING AND B FOLLOWING", or "B PRECEDING AND A PRECEDING", where A>B.
2019-09-04 06:56:43 +00:00
window8.test
Fix handling of NULL, text and blob values in window queries that use "RANGE BETWEEN A FOLLOWING AND B FOLLOWING", or "B PRECEDING AND A PRECEDING", where A>B.
2019-09-04 06:56:43 +00:00
window9.test
Ensure that negative numbers may not be used in frame offset clauses even if they are initially text value. e.g. (RANGE BETWEEN '-1' PRECEDING ...).
2021-03-31 11:31:19 +00:00
windowA.test
Back out the change at [47cd634c98b502d4] which was incorrect. Add a test
2019-08-30 18:02:49 +00:00
windowB.test
Ensure the correct collation sequence is used for comparisons when delimiting a RANGE window.
2021-03-06 14:46:24 +00:00
windowerr.tcl
Fix error handling for the case where a window function is passed the wrong number of arguments.
2019-07-13 17:45:25 +00:00
windowerr.test
Fix error handling for the case where a window function is passed the wrong number of arguments.
2019-07-13 17:45:25 +00:00
windowfault.test
Improved robustness to OOM conditions in the window function logic.
2021-04-03 23:30:33 +00:00
windowpushd.test
Revise tests cases to align with the new EXPLAIN QUERY PLAN output.
2021-03-20 15:11:29 +00:00
with1.test
Revise tests cases to align with the new EXPLAIN QUERY PLAN output.
2021-03-20 15:11:29 +00:00
with2.test
Correlated CTEs should not generate a materialization subroutine. If they
2021-03-19 13:53:34 +00:00
with3.test
Use the canonical name, not the AS name, when showing the MATERIALIZE or
2021-03-20 15:46:01 +00:00
with4.test
…
with5.test
New test cases for recursive CTEs with multiple recursive terms.
2020-10-19 01:44:43 +00:00
with6.test
Use the canonical name, not the AS name, when showing the MATERIALIZE or
2021-03-20 15:46:01 +00:00
withM.test
…
without_rowid1.test
Include the original text of the CHECK constraint in the error message for
2020-08-27 18:36:30 +00:00
without_rowid2.test
…
without_rowid3.test
Include the original text of the CHECK constraint in the error message for
2020-08-27 18:36:30 +00:00
without_rowid4.test
…
without_rowid5.test
…
without_rowid6.test
Revise tests cases to align with the new EXPLAIN QUERY PLAN output.
2021-03-20 15:11:29 +00:00
without_rowid7.test
Fix some test script issues that come up with SQLITE_OMIT_VIRTUALTABLE builds.
2019-10-03 14:36:36 +00:00
wordcount.c
Add the --upsert option to the wordcount test program.
2018-04-19 16:52:37 +00:00
writecrash.test
…
zeroblob.test
Do not accidently truncate zeroblob values when doing an arithmetic
2019-01-25 20:09:04 +00:00
zerodamage.test
…
zipfile2.test
Add the SQLITE_DEFAULT_DEFENSIVE compile-time option. Fix up test cases
2018-11-07 02:17:01 +00:00
zipfile.test
Improvement to check-in [7405e98225761180] so that missing or null filenames
2020-01-03 16:38:54 +00:00
zipfilefault.test
…