drh ece1729958 Fix a memory error in test logic introduced by [8704034254938662]. ...

FossilOrigin-Name: 8a56e98d257e280d308b9fdc26e17e202f00a70fb9a780e30924e87a189fc7f4

2025-01-07 15:39:57 +00:00

..

json

Update JSON performance testing procedures for clarity and to describe how to

2024-01-06 15:22:16 +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

If the SELECT that implements a subquery or a VIEW or a CREATE TABLE AS is

2022-12-14 14:41:35 +00:00

aggerror.test

…

aggfault.test

Fix an error in new test script test/aggfault.test.

2023-03-30 12:19:38 +00:00

aggnested.test

New test case based on Chromium bug report 1511689.

2023-12-16 10:50:06 +00:00

aggorderby.test

Pass subtype information through the aggregate ORDER BY sorter for

2023-12-14 13:58:50 +00:00

alias.test

Rework the column-cache mechanism to be more robust (and more correct).

2009-04-23 13:22:42 +00:00

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

Ensure that values generated by DEFAULT clauses that specify real numbers that can be expressed as 64-bit integers (e.g. -1234.0) are not silently converted to integers.

2024-01-20 18:41:13 +00:00

alter3.test

Fix issues in the new ADD COLUMN constraint checking. Add preliminary

2021-07-20 08:23:54 +00:00

alter4.test

RETURNING bug fix: Correctly deal with RETURNING statements on changes to

2021-04-27 13:04:18 +00:00

alter.test

Another assertion fault fix, similar to [a9443dbfbe25e588]. dbsqlfuzz

2023-11-18 11:23:01 +00:00

alterauth2.test

Fix a test result for alterauth2.test due to the recent fix to authorizer

2022-01-19 18:31:43 +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

Test case for alter column that is used in the ORDER BY of an aggregate.

2023-10-18 22:53:22 +00:00

altercorrupt.test

…

alterdropcol2.test

Fix broken requirement marks.

2021-03-12 13:49:09 +00:00

alterdropcol.test

Ensure that all records are updated by setting the OPFLAG_SAVEPOSITION flag when updating records as part of ALTER TABLE DROP COLUMN.

2021-04-18 05:30:39 +00:00

alterfault.test

Do not attempt to run the tests in alterfault.est with SQLITE_OMIT_ALTERTABLE builds.

2021-11-22 16:43:53 +00:00

alterlegacy.test

…

altermalloc2.test

Update some OOM tests of the ALTER TABLE command to account for an error message which may be returned if opening the temp db fails.

2022-02-11 19:41:03 +00:00

altermalloc3.test

Test module altermalloc3.test requires DQS_DDL to be turned on.

2023-10-25 17:26:11 +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

Fix a test case broken by the previous check-in.

2023-10-21 11:00:57 +00:00

altertab2.test

Fix a case where an error in the ORDER BY clause of an aggregate function that is part of a trigger body might cause an assert() to fail in an ALTER TABLE command.

2024-05-15 21:38:04 +00:00

altertab3.test

Avoid expanding integer values in columns with real affinity to the full 8-byte representation when editing records as part of a DROP COLUMN command.

2024-03-26 11:14:52 +00:00

altertab.test

Fix an obscure issue with ALTER TABLE RENAME that comes up with triggers

2023-04-13 18:44:59 +00:00

altertrig.test

Add string_agg(X,Y) as an alias for group_concat(X,Y), for compatibility

2023-10-20 20:19:30 +00:00

amatch1.test

Add some timing tests to the amatch test script.

2013-09-30 19:05:03 +00:00

analyze3.test

Do not overflow the Index.aSample[] array if the same index appears in

2023-05-03 05:00:10 +00:00

analyze4.test

Change things so that SQLITE_OMIT_VIRTUALTABLE implies SQLITE_OMIT_ALTER_TABLE.

2021-10-01 20:39:50 +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

Minor STAT4 test case change due to the ANALYZE enhancement of

2022-05-09 17:55:34 +00:00

analyze.test

Fix an assert that can go bad if STAT4 content is corrupt. This is a

2023-06-10 18:40:20 +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

When reading sqlite_stat4 data during query planning, be sure to expand

2023-03-25 22:37:23 +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

Run TCL tests in a subdirectory "testdir".

2016-03-14 13:42:29 +00:00

atof1.test

On x64 hardware, round-trip uint64_t→double→uint64_t conversions

2024-12-07 14:48:55 +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

Add new test file test/atomic.test.

2017-07-28 11:05:33 +00:00

atrc.c

…

attach2.test

Ensure that the database encoding cannot be changed while there are statements running. And that the connection is left in a valid state after an obscure OOM within sqlite3_deserialize().

2023-01-20 17:50:24 +00:00

attach3.test

All temp.sqlite_master to be used as an alias for sqlite_temp_master.

2016-12-16 01:00:21 +00:00

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

In the documentation emphasize that the use of shared cache is discouraged.

2022-08-15 12:26:26 +00:00

auth2.test

Disable the authorizer callback when reparsing the schema. This avoids

2016-07-28 18:38:13 +00:00

auth3.test

Change things so that SQLITE_OMIT_VIRTUALTABLE implies SQLITE_OMIT_ALTER_TABLE.

2021-10-01 20:39:50 +00:00

auth.test

Fix some test scripts that were failing with SQLITE_OMIT_VIRTUALTABLE builds.

2023-02-06 10:47:57 +00:00

autoanalyze1.test

Do not run test file autoanalyze1.test if OMIT_VIRTUALTABLE is defined.

2017-03-23 17:22:09 +00:00

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

Show the creation of IN-operator Bloom filters in the EXPLAIN QUERY PLAN output.

2024-07-03 20:10:42 +00:00

autoindex2.test

Do not use an automatic index on an outer loop that only runs once.

2016-02-25 18:03:38 +00:00

autoindex3.test

Avoid creating an automatic index on a column that is known to be not very

2024-05-27 21:55:01 +00:00

autoindex4.test

Fix the LEFT JOIN strength reduction for IN operators in the WHERE clause.

2023-06-01 00:01:20 +00:00

autoindex5.test

Allow unqualified "rowid" references to be used in join queries, provided that only one of the source objects has a rowid.

2021-07-01 18:19:17 +00:00

autovacuum2.test

…

autovacuum_ioerr2.test

…

autovacuum.test

…

avfs.test

Update mdevtest and sdevtest to do shell builds in parallel. And only if one or more of the tcl scripts run requires it.

2024-03-11 19:33:55 +00:00

avtrans.test

Fix a typo preventing test script avtrans.test from running in auto-vacuum

2018-03-26 17:56:39 +00:00

backcompat.test

Get rid of "-encoding binary" across all test cases, as that is no longer

2024-07-30 17:09:51 +00:00

backup2.test

Fix an error in the test case fix in [ecd71203].

2021-02-15 11:14:53 +00:00

backup4.test

Many test cases fixed to work with encryption.

2016-03-14 17:05:04 +00:00

backup5.test

Have calls to sqlite3_backup_init() fail if there is already a read or read-write transaction open on the destination database.

2014-11-13 14:18:25 +00:00

backup_ioerr.test

…

backup_malloc.test

…

backup.test

Fix a segfault that could occur if a non-empty in-memory database was the destination of a backup operation from a database with a smaller page size.

2023-04-19 17:07:35 +00:00

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

Fixes for compilation/testing when the various OMIT macros are defined. (CVS 4423)

2007-09-12 17:01:45 +00:00

basexx1.test

Speed up base64 conversions, and add test with more data for the baseNN conversion to grind.

2022-11-24 02:59:33 +00:00

bc_common.tcl

…

bestindex1.test

…

bestindex2.test

…

bestindex3.test

…

bestindex4.test

…

bestindex5.test

…

bestindex6.test

…

bestindex7.test

…

bestindex8.test

Allow virtual table implementations to handle OFFSET but not LIMIT, but not LIMIT but not OFFSET.

2024-04-26 18:13:11 +00:00

bestindex9.test

…

bestindexA.test

…

bestindexB.test

…

bestindexC.test

Further tests for OR constraints on virtual tables.

2024-05-31 20:32:10 +00:00

bestindexD.test

Ensure the sqlite3_index_info.colUsed mask always includes the PK fields of WITHOUT ROWID vtabs in cases where they may be used.

2024-08-03 18:45:48 +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

Fix test issues for Windows portability.

2013-09-13 23:26:47 +00:00

bigfile.test

Disable the bigfile tests on Macs.

2012-09-29 15:45:12 +00:00

bigmmap.test

…

bigrow.test

Do not invoke the busy callback when trying to promote a lock from SHARED

2004-08-07 23:54:48 +00:00

bigsort.test

…

bind2.test

Fix the bind2.test test script so that it works even if

2022-02-11 12:06:37 +00:00

bind.test

Update error message text for standard error codes to better describe the

2017-07-10 12:07:53 +00:00

bindxfer.test

Check-in (6514) did not completely remove the obsolete test, resulting in a

2009-04-17 11:56:27 +00:00

bitvec.test

Increase test coverage of bitvec.c slightly. Fix the line length on a

2009-04-01 23:49:04 +00:00

blob.test

Fix an out-of-order test number in blob.test. Cosmetic change. No

2009-04-28 18:00:27 +00:00

bloom1.test

Fix Bloom filters on an expression index.

2023-03-14 20:08:39 +00:00

boundary1.tcl

…

boundary1.test

Many of the boundary tests depend on a working 64-bit implementation of TCL, so skip them if this is not available. (CVS 6099)

2009-01-02 15:45:47 +00:00

boundary2.tcl

…

boundary2.test

Many of the boundary tests depend on a working 64-bit implementation of TCL, so skip them if this is not available. (CVS 6099)

2009-01-02 15:45:47 +00:00

boundary3.tcl

…

boundary3.test

Many of the boundary tests depend on a working 64-bit implementation of TCL, so skip them if this is not available. (CVS 6099)

2009-01-02 15:45:47 +00:00

boundary4.tcl

…

boundary4.test

Various fixes so that "make test" works with OMIT_FOREIGN_KEY, OMIT_TRIGGER and OMIT_ALTER_TABLE.

2009-09-29 06:33:23 +00:00

btree01.test

New test cases added.

2022-04-11 18:54:23 +00:00

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

Remove a NEVER() macro for a condition that is actually reachable following an OOM. dbsqlfuzz crash-6ef3cd3b18ccc5de86120950a0498641acd90a33.txt.

2022-08-25 13:32:55 +00:00

busy2.test

Remove a few unsuitable scripts from the "veryquick" test suite. Also have every second testrunner.tcl process favour running test scripts that contain text like "testrunner: slow" before any others.

2022-07-18 19:32:30 +00:00

busy.test

Change the 0x20000 bit (use analysis limit) to 0x10, meaning that this feature

2024-02-19 13:06:27 +00:00

cache.test

Many spelling fixes in comments. No changes to code.

2013-03-21 21:20:32 +00:00

cacheflush.test

From test scripts, remove stray "breakpoint" commands and blank lines

2016-02-05 16:46:09 +00:00

cachespill.test

…

capi2.test

Recognize certain standard datatypes ("INT", "INTEGER", "REAL", "TEXT", and

2021-07-30 23:30:30 +00:00

capi3.test

Omit a capi3 test from 2007 that depends upon undefined behavior (UAF).

2024-05-20 19:59:32 +00:00

capi3b.test

Refactor some of the global variables and commands used by tester.tcl.

2010-06-07 14:28:16 +00:00

capi3c.test

Fix sqlite3_prepare() so that it only invokes the progress handler on every

2023-01-12 19:51:49 +00:00

capi3d.test

Enhance the documentation on sqlite3_stmt_readonly() to explain that

2022-02-17 17:24:39 +00:00

capi3e.test

Revise how the Tcl system encoding is handled by the test suite.

2014-02-14 00:25:03 +00:00

carray01.test

Extend the carray extension to allow the use of BLOB values to be bound

2023-01-20 21:00:03 +00:00

cast.test

Remove all code that makes use of the C-language "long double" datatype.

2024-10-01 20:29:43 +00:00

cffault.test

Fixes for OOM and IO error handling with temp file databases.

2016-04-11 18:07:47 +00:00

changes2.test

Add string_agg(X,Y) as an alias for group_concat(X,Y), for compatibility

2023-10-20 20:19:30 +00:00

changes.test

Add string_agg(X,Y) as an alias for group_concat(X,Y), for compatibility

2023-10-20 20:19:30 +00:00

check.test

Fix test cases so that they all still work even with -DSQLITE_DQS=0.

2022-01-16 19:11:13 +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

…

cksumvfs.test

Avoid spurious SQLITE_IOERR_DATA errors when reading partial pages from a cksumvfs database using a SQLITE_DIRECT_OVERFLOW_READ build.

2024-03-18 20:52:45 +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

Fix test cases so that they all still work even with -DSQLITE_DQS=0.

2022-01-16 19:11:13 +00:00

collate2.test

New test cases added.

2022-04-11 18:54:23 +00:00

collate3.test

Correctly deal with an unknown collating sequence on an indexed DISTINCT query.

2015-04-15 05:31:02 +00:00

collate4.test

Improvements and simplifications to the equality seek logic. Tests are

2015-11-05 22:30:54 +00:00

collate5.test

Fix a problem with using the push-down optimization on compound SELECTs where component SELECTs use different collation sequences. dbsqlfuzz 11516f050100243e5a845f5a2b48a90ed2efaf2e.

2022-10-14 19:30:34 +00:00

collate6.test

Fix a bug with explicit collation sequences attached to a column reference expression that is on the right-hand-side of a binary comparison operator. (CVS 4187)

2007-07-30 14:40:48 +00:00

collate7.test

Add retry logic for AV defense to winOpen. Also, refactor test suite to allow the key Tcl file operations (e.g. copy and delete) to be retried.

2011-08-02 00:57:34 +00:00

collate8.test

Propagate the COLLATE operator upward through function calls.

2015-02-09 16:09:34 +00:00

collate9.test

Remove unused code. Test coverage enhancements. Modify the algorithm used

2008-07-10 00:32:42 +00:00

collateA.test

Fix a bug in the RTRIM collating sequence discovered while working

2008-04-15 04:02:40 +00:00

collateB.test

Remove an invalid assert() statement failing when VACUUMing a database that

2017-03-23 17:03:35 +00:00

colmeta.test

Fix the sqlite3_table_column_metadata() routine so that it gives the correct

2014-12-09 22:24:42 +00:00

colname.test

Allow arbitrary expressions as the second argument to RAISE().

2024-05-08 17:42:13 +00:00

columncount.test

Change things so that SQLITE_OMIT_VIRTUALTABLE implies SQLITE_OMIT_ALTER_TABLE.

2021-10-01 20:39:50 +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

Add test cases to confirm that the schema parsing quirk in which an

2023-01-17 13:33:51 +00:00

contrib01.test

Add a test case contributed on the mailing list

2013-06-05 12:18:15 +00:00

corrupt2.test

Get rid of "-encoding binary" across all test cases, as that is no longer

2024-07-30 17:09:51 +00:00

corrupt3.test

…

corrupt4.test

Get rid of "-encoding binary" across all test cases, as that is no longer

2024-07-30 17:09:51 +00:00

corrupt5.test

…

corrupt6.test

…

corrupt7.test

…

corrupt8.test

…

corrupt9.test

…

corrupt.test

Get rid of "-encoding binary" across all test cases, as that is no longer

2024-07-30 17:09:51 +00:00

corruptA.test

…

corruptB.test

…

corruptC.test

Change test results in corruptC.test to account for the added detail in the

2024-03-04 16:44:37 +00:00

corruptD.test

Have "PRAGMA quick_check" compare the number of entries in tables and indexes.

2024-02-02 16:51:24 +00:00

corruptE.test

…

corruptF.test

…

corruptG.test

…

corruptH.test

…

corruptI.test

…

corruptJ.test

…

corruptK.test

Get rid of "-encoding binary" across all test cases, as that is no longer

2024-07-30 17:09:51 +00:00

corruptL.test

Fix a case where a corrupt stat4 record could go unrecognized due to integer overflow.

2024-04-24 14:18:20 +00:00

corruptM.test

…

corruptN.test

Attempt to reduce divergence with begin-concurrent.

2024-11-18 16:44:26 +00:00

cost.test

Change EXPLAIN QUERY PLAN output to say "USE TEMP B-TREE FOR LAST TERM OF ORDER BY", or "LAST N TERMS OF ORDER BY", instead of "RIGHT PART OF ORDER BY".

2024-03-20 16:27:08 +00:00

count.test

Allow a HAVING clause on any aggregate query, even if there is no GROUP BY

2022-06-21 13:41:24 +00:00

countofview.test

Omit the the count-of-view optimization if there is a HAVING clause.

2023-03-31 23:48:59 +00:00

coveridxscan.test

…

crash2.test

If the sector size is greater than the database page size, SQLite journals all pages that lie within a sector before writing to any of them. This change ensure that a journal sync does not occur halfway through journalling the set of pages that belong to a single sector. (CVS 5605)

2008-08-25 07:12:28 +00:00

crash3.test

Add retry logic for AV defense to winOpen. Also, refactor test suite to allow the key Tcl file operations (e.g. copy and delete) to be retried.

2011-08-02 00:57:34 +00:00

crash4.test

Add retry logic for AV defense to winOpen. Also, refactor test suite to allow the key Tcl file operations (e.g. copy and delete) to be retried.

2011-08-02 00:57:34 +00:00

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

Add retry logic for AV defense to winOpen. Also, refactor test suite to allow the key Tcl file operations (e.g. copy and delete) to be retried.

2011-08-02 00:57:34 +00:00

crash7.test

…

crash8.test

…

crash.test

Get rid of "-encoding binary" across all test cases, as that is no longer

2024-07-30 17:09:51 +00:00

crashM.test

Disable multiplexing of master-journal files in the test_multiplex.c module.

2015-03-12 19:12:30 +00:00

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

Avoid ignoring the last line of a csv file if the final field is empty and

2022-07-06 15:44:57 +00:00

ctime.test

Fix test cases so that they all still work even with -DSQLITE_DQS=0.

2022-01-16 19:11:13 +00:00

cursorhint2.test

…

cursorhint.test

…

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

date3.test

Enforce the restriction that 'unixepoch' only works as the first modifier

2022-01-27 13:52:01 +00:00

date4.test

Make sure that %V and %G are testing for every since day in between 1970-01-01

2024-01-20 16:38:00 +00:00

date5.test

New date/time test cases to validate ancient dates.

2024-08-19 13:53:49 +00:00

date.test

Adjust date/time functions so that they do a better job of keeping track

2024-03-04 13:58:09 +00:00

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

…

dbfuzz2.c

Enable the sqlite3_serialize() and sqlite3_deserialize() interfaces by

2021-05-08 17:18:23 +00:00

dbfuzz001.test

Add test case for [29937081].

2023-10-12 18:09:27 +00:00

dbfuzz.c

Fix harmless compiler warnings in dbfuzz.

2017-02-07 21:00:44 +00:00

dbpage.test

Close database connections in test/dbpage.test, for Windows.

2025-01-02 17:56:11 +00:00

dbpagefault.test

Improvements to the way that truncation is implemented in sqlite_dbpage().

2025-01-02 15:03:13 +00:00

dbstatus2.test

Fix a duplicate test number and cleanup a bit of Makefile whitespace.

2018-03-16 23:53:47 +00:00

dbstatus.test

Remove support for STAT3. The sqlite_stat3 tables are ignored, if they

2019-08-08 15:24:17 +00:00

decimal.test

Rename the decimal_sci() function to decimal_exp().

2023-08-18 15:39:38 +00:00

default.test

Fix test cases due to an error message change.

2024-04-04 13:07:43 +00:00

delete2.test

3 more coverage tests for btree.c. (CVS 5370)

2008-07-08 15:59:51 +00:00

delete3.test

Fix a bug in DELETE that might cause a segfault when deleting more

2005-08-24 16:13:51 +00:00

delete4.test

Fix the truncate optimization so that PRAGMA count_changes and changes()

2021-06-03 18:51:51 +00:00

delete_db.test

…

delete.test

Do not use the one-pass optimization on an UPDATE if there is a subquery

2023-03-16 10:17:30 +00:00

descidx1.test

…

descidx2.test

…

descidx3.test

…

diskfull.test

Add retry logic for AV defense to winOpen. Also, refactor test suite to allow the key Tcl file operations (e.g. copy and delete) to be retried.

2011-08-02 00:57:34 +00:00

distinct2.test

Do not convert an expression node that is already TK_REGISTER into a

2024-06-28 17:14:00 +00:00

distinct.test

Correctly handle SELECT DISTINCT ... ORDER BY when all of the result set terms

2023-03-16 20:54:29 +00:00

distinctagg.test

Consider an index for queries like "SELECT count(DISTINCT col) FROM ...", even if the index records are not smaller than the table records.

2024-01-29 19:30:16 +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

Provide a two-argument version of the iif() function, plus an alternative

2024-11-26 20:56:03 +00:00

e_fkey.test

…

e_fts3.test

…

e_insert.test

…

e_reindex.test

Have "PRAGMA quick_check" compare the number of entries in tables and indexes.

2024-02-02 16:51:24 +00:00

e_resolve.test

…

e_select2.test

…

e_select.test

…

e_totalchanges.test

…

e_update.test

…

e_uri.test

…

e_vacuum.test

…

e_wal.test

…

e_walauto.test

…

e_walckpt.test

…

e_walhook.test

…

emptytable.test

Query planner optimization to detect empty tables in a join early and bail out

2017-02-15 22:36:15 +00:00

enc2.test

Do not allow the "PRAGMA encoding" statement to change the database

2020-01-15 16:20:16 +00:00

enc3.test

In the documentation emphasize that the use of shared cache is discouraged.

2022-08-15 12:26:26 +00:00

enc4.test

Add retry logic for AV defense to winOpen. Also, refactor test suite to allow the key Tcl file operations (e.g. copy and delete) to be retried.

2011-08-02 00:57:34 +00:00

enc.test

Ensure that the database encoding is detected before the code generator gets

2024-11-04 19:08:53 +00:00

eqp2.test

Change EXPLAIN QUERY PLAN output to say "USE TEMP B-TREE FOR LAST TERM OF ORDER BY", or "LAST N TERMS OF ORDER BY", instead of "RIGHT PART OF ORDER BY".

2024-03-20 16:27:08 +00:00

eqp.test

If a subquery is materialized due to an ORDER BY and that ordering is useful

2024-08-15 23:38:52 +00:00

errmsg.test

Change the error message text for SQLITE_ERROR to omit the part about

2017-07-07 19:43:23 +00:00

errofst1.test

Do not report an sqlite3_error_offset() for errors that occur inside of

2024-11-20 11:34:16 +00:00

eval.test

Fix test cases so that they all still work even with -DSQLITE_DQS=0.

2022-01-16 19:11:13 +00:00

exclusive2.test

Get rid of "-encoding binary" across all test cases, as that is no longer

2024-07-30 17:09:51 +00:00

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

Miscellaneous test coverage improvements. (CVS 4734)

2008-01-21 16:22:45 +00:00

exists.test

…

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

Add IS NOT DISTINCT FROM and IS DISTINCT FROM binary operators which are

2022-05-12 11:45:20 +00:00

exprfault2.test

Add a test for the fixes on this branch.

2024-05-10 18:15:03 +00:00

exprfault.test

Add experimental user function unhex().

2023-01-23 14:11:34 +00:00

extension01.test

Fix the extension01.test script so that it works on windows. Fix a

2014-06-16 12:51:56 +00:00

external_reader.test

…

extraquick.test

"test" targets on all makefiles use --verbose=file --output=test-out.txt.

2015-06-10 18:53:09 +00:00

fallocate.test

Minor fix the fallocate.test module change from [7cd56cad5efead5]

2019-01-21 14:49:14 +00:00

filectrl.test

Corrections to a couple recently added 'filectrl.test' results.

2016-10-17 18:33:36 +00:00

filefmt.test

Update error message text for standard error codes to better describe the

2017-07-10 12:07:53 +00:00

filter1.test

…

filter2.tcl

…

filter2.test

…

filterfault.test

…

fkey1.test

Avoid double de-quoting of table names when processing RESTRICT actions

2023-04-14 00:20:16 +00:00

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

Standardize the error messages generated by constraint failures to a format

2013-11-05 13:33:55 +00:00

fkey4.test

Rename SQLITE_CONSTRAINT_RAISE to SQLITE_CONSTRAINT_TRIGGER. Put the

2013-02-09 15:37:11 +00:00

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

Fix a problem in the sessions extension allowing changesets containing foreign key violations to be committed under some circumstances.

2025-01-04 16:30:05 +00:00

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

Fix a problem with "ON DELETE RESTRICT" and "ON UPDATE RESTRICT" foreign keys in attached databases scanning child tables in the wrong schema.

2022-04-16 15:46:23 +00:00

fkey_malloc.test

…

fordelete.test

…

fork-test.c

Add the test/fork-test.c test program.

2024-11-13 16:08:02 +00:00

format4.test

…

fp-speed-1.c

Remove all code that makes use of the C-language "long double" datatype.

2024-10-01 20:29:43 +00:00

fpconv1.test

New test cases for floating-point conversions.

2023-07-03 12:58:18 +00:00

fts3_common.tcl

…

fts3.test

Re-introduce the prefix-search optimization of [feef1b15d6], which was lost in a reorganization of FTS3 code.

2010-07-19 11:16:36 +00:00

fts3aa.test

Add new sqlite3_prepare_v3() flag SQLITE_PREPARE_NO_VTAB, for preparing

2018-12-21 19:29:11 +00:00

fts3ab.test

Make sure errors encountered while initializing extensions such as FTS4

2013-12-19 16:26:05 +00:00

fts3ac.test

Fix for [9861b74ab9]. Correctly handle strings with zero tokens in the fts3 offsets() function.

2010-03-24 15:57:33 +00:00

fts3ad.test

…

fts3ae.test

…

fts3af.test

Replicate the fts2*.test files as fts3a*.test, and convert fts2 to

2007-08-20 17:38:42 +00:00

fts3ag.test

…

fts3ah.test

…

fts3ai.test

…

fts3aj.test

…

fts3ak.test

…

fts3al.test

…

fts3am.test

…

fts3an.test

…

fts3ao.test

…

fts3atoken.test

…

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

…

fts3aux2.test

…

fts3b.test

Change the error message text for SQLITE_ERROR to omit the part about

2017-07-07 19:43:23 +00:00

fts3c.test

Start reworking fts3 code to match the rest of SQLite (code conventions, malloc-failure handling etc.).

2009-11-13 10:36:20 +00:00

fts3comp1.test

Change fts4aux to (additionally) report on term frequency in individual columns of an fts table.

2011-02-04 18:56:25 +00:00

fts3conf.test

…

fts3corrupt2.test

…

fts3corrupt3.test

…

fts3corrupt4.test

Fix an FTS3 corruption test case that depends on the specific pseudo-random

2024-11-06 19:19:49 +00:00

fts3corrupt5.test

…

fts3corrupt6.test

…

fts3corrupt7.test

Fix a case in fts3 where a corrupt database record was not being handled correctly.

2024-11-09 17:54:51 +00:00

fts3corrupt.test

…

fts3cov.test

…

fts3d.test

Add the SQLITE_DEFAULT_DEFENSIVE compile-time option. Fix up test cases

2018-11-07 02:17:01 +00:00

fts3defer2.test

…

fts3defer3.test

…

fts3defer.test

…

fts3drop.test

Avoid attempting to call savepoint related methods on deleted sqlite3_vtab objects. Fix for [48f299634a].

2011-10-29 11:43:04 +00:00

fts3dropmod.test

Fix a typo in the result of one of the new test cases.

2021-12-16 17:21:34 +00:00

fts3e.test

…

fts3expr2.test

Remove leftover "breakpoint" commands from test scripts. Also remove blank

2009-06-05 17:09:11 +00:00

fts3expr3.test

Update fts3 so that expressions to the left and right of a NOT operator are balanced. This prevents relatively small expressions (a dozen terms or so) that are children of NOT operators from triggering the "expression tree is too large" error.

2015-10-05 15:39:45 +00:00

fts3expr4.test

Fix a test case in fts3expr4.test to account for different locales.

2022-11-24 17:58:55 +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

fts3f.test

Fix a use-after-free in fts3 that could follow an optimize() in the middle of a SELECT statement when the hash table is non-empty.

2021-10-12 11:30:07 +00:00

fts3fault2.test

…

fts3fault3.test

Ensure the fts3 xIntegrity method correctly returns error codes unrelated to corruption or missing SQL elements.

2024-02-01 15:21:55 +00:00

fts3fault.test

Fix a problem handling OOM errors in fts3 that could occur when parsing multi-token strings.

2024-11-19 11:58:32 +00:00

fts3first.test

Have FTS3 ignore ^ prefixes. The ^ syntax is only supported on FTS4 tables.

2011-10-19 15:52:48 +00:00

fts3fuzz001.test

…

fts3integrity.test

Avoid expiring prepared statements in the middle of an integrity-check.

2023-12-15 19:26:16 +00:00

fts3join.test

Make the SQLITE_DBCONFIG_STMT_SCANSTATUS option on by default.

2023-03-03 21:17:12 +00:00

fts3malloc.test

Cut over the next generation query planner. Increase the version number

2013-06-26 11:43:18 +00:00

fts3matchinfo2.test

…

fts3matchinfo.test

…

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

Fix test cases for the new EXPLAIN QUERY PLAN format. Add the

2013-06-10 23:30:09 +00:00

fts3prefix.test

Fix a problem with fts3 prefix terms within phrase queries on "order=DESC" tables with a mix of negative and positive rowids.

2015-04-06 09:05:29 +00:00

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

Fix test cases for the new EXPLAIN QUERY PLAN format. Add the

2013-06-10 23:30:09 +00:00

fts3snippet2.test

Fix a "shift exponent is too large" usan error that could occur in the fts3 snippet() function when a query phrase contains more than 64 tokens.

2024-04-09 19:23:18 +00:00

fts3snippet.test

Add assert() statements and reorganize code slightly in fts3 and fts5 to make it easier to follow.

2024-08-08 15:07:27 +00:00

fts3sort.test

…

fts3tok1.test

…

fts3tok_err.test

…

fts3varint.test

…

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 xIntegrity method to the sqlite3_module object. Implement this

2023-09-06 12:52:00 +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

…

fts4incr.test

…

fts4intck1.test

Ensure that the xIntegrity methods of fts3 and fts5 work on read-only databases.

2024-01-16 16:05:21 +00:00

fts4langid.test

Add the xIntegrity method to the sqlite3_module object. Implement this

2023-09-06 12:52:00 +00:00

fts4lastrowid.test

…

fts4merge2.test

…

fts4merge3.test

…

fts4merge4.test

…

fts4merge5.test

…

fts4merge.test

…

fts4min.test

…

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

…

fts4rename.test

…

fts4umlaut.test

…

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

…

fts-9fd058691.test

…

full.test

Allow SQLite to work on Win32 with SQLITE_OS_WINNT=0 as long as WAL is disabled.

2012-09-13 01:51:02 +00:00

func2.test

Avoid slowdown when exprNodeIsConstant() is called on deeply nested SQL functions.

2024-04-24 11:40:47 +00:00

func3.test

Fix an assert() that might fail if sqlite3_create_function_v2() is invoked with NULL xStep and xFinal callbacks and a non-NULL xDestroy.

2021-07-09 14:59:12 +00:00

func4.test

Remove all code that makes use of the C-language "long double" datatype.

2024-10-01 20:29:43 +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

Get rid of "-encoding binary" across all test cases, as that is no longer

2024-07-30 17:09:51 +00:00

func7.test

Fix a typo in testrunner_data.tcl that prevented --with-tcl specifications

2024-07-31 16:37:02 +00:00

func8.test

Add test cases for functions named the same as join keywords.

2023-03-17 19:07:48 +00:00

func9.test

Add support for the CONCAT() and CONCAT_WS() SQL functions, modeled after

2023-08-29 15:24:41 +00:00

func.test

Fix additional integer overflow problems in the substr() function.

2024-12-19 12:08:39 +00:00

fuzz2.test

Make sure errors in the FROM clause of a SELECT cause analysis to abort

2015-01-22 12:00:17 +00:00

fuzz3.test

Get rid of "-encoding binary" across all test cases, as that is no longer

2024-07-30 17:09:51 +00:00

fuzz4.test

Fix another problem found by Matthew Denton's new fuzzer.

2018-12-12 21:34:17 +00:00

fuzz_common.tcl

…

fuzz_malloc.test

…

fuzz-oss1.test

Fix test cases so that they all still work even with -DSQLITE_DQS=0.

2022-01-16 19:11:13 +00:00

fuzz.test

Update fuzz.test to account for a change in error message made in the core.

2022-02-12 13:45:02 +00:00

fuzzcheck.c

Show ETC in fuzzcheck with the --spinner option when there is only one input

2024-12-28 13:04:31 +00:00

fuzzdata1.db

Fix a faulty assert() statement identified by

2022-06-10 10:10:31 +00:00

fuzzdata2.db

Add the --info option to the fuzzcheck test utility.

2018-08-06 01:39:31 +00:00

fuzzdata3.db

Add a corrupt database to test/fuzzdata3.db to validate the previous

2015-09-30 14:30:19 +00:00

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

Change the debugging "json_parse(X)" function so that it shows a more

2023-07-26 13:17:43 +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

Add a test case to prevent a regression of the leak fixed in the previous

2023-10-07 08:15:47 +00:00

fuzzer1.test

Avoid running some particularly time-consuming tests as part of veryquick.test.

2016-02-04 17:31:03 +00:00

fuzzer2.test

Avoid running some particularly time-consuming tests as part of veryquick.test.

2016-02-04 17:31:03 +00:00

fuzzerfault.test

Add OOM test case associated with the fix in the previous commit.

2021-02-27 15:32:02 +00:00

fuzzinvariants.c

Fix an off-by-one error in the routines that bind the special $test_TTT and

2024-09-07 16:04:04 +00:00

gcfault.test

Add string_agg(X,Y) as an alias for group_concat(X,Y), for compatibility

2023-10-20 20:19:30 +00:00

gencol1.test

…

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

Fix then handling of the (oversized) integer literal -0x8000000000000000.

2016-11-30 14:47:37 +00:00

hidden.test

Fix a problem with VACUUM and __hidden__ columns.

2015-11-19 18:09:05 +00:00

hook2.test

Experimental change to invoke the preupdate hook when WITHOUT ROWID tables are

2017-01-30 19:44:53 +00:00

hook.test

Fix the preupdate hook so that it works when the "old.*" row has a column with a non-NULL default value that was added by ALTER TABLE ADD COLUMN after the current record was created.

2024-09-18 15:02:27 +00:00

icu.test

Add an optional 3rd argument to the icu_load_collation() function that

2024-04-02 21:55:45 +00:00

ieee754.test

…

imposter1.test

Change SQLITE_TESTCTRL_INITMODE to SQLITE_TESTCTRL_IMPOSTER. Revise the order

2015-01-30 20:59:27 +00:00

in2.test

Remove leftover debugging commands (breakpoint and btree_breakpoint) from

2008-07-12 14:52:20 +00:00

in3.test

Fix (make test) with SQLITE_OMIT_COMPOUND_SELECT. Ticket #3235. (CVS 5530)

2008-08-04 03:51:24 +00:00

in4.test

Omit the "noop(X)" test SQL function. Accomplish the same thing using

2024-03-17 16:01:23 +00:00

in5.test

Slight performance improvement for the new code on this branch.

2024-04-20 19:19:30 +00:00

in6.test

Fix the IN-early-out optimization so that it works even for the corner case

2021-04-29 15:49:34 +00:00

in7.test

Bug fix in the SubrtnSig logic from [c9a3498113074bbc], if a subquery is

2024-11-20 14:59:32 +00:00

in.test

Add a test case for the ALWAYS() macro removed by the previous check-in.

2023-04-05 02:55:08 +00:00

incrblob2.test

…

incrblob3.test

…

incrblob4.test

…

incrblob_err.test

…

incrblob.test

…

incrblobfault.test

…

incrcorrupt.test

…

incrvacuum2.test

…

incrvacuum3.test

Get rid of "-encoding binary" across all test cases, as that is no longer

2024-07-30 17:09:51 +00:00

incrvacuum_ioerr.test

…

incrvacuum.test

…

index2.test

Continue to support the (broken) legacy syntax of allowing strings for

2015-09-04 12:54:01 +00:00

index3.test

Add the SQLITE_DEFAULT_DEFENSIVE compile-time option. Fix up test cases

2018-11-07 02:17:01 +00:00

index4.test

Standardize the error messages generated by constraint failures to a format

2013-11-05 13:33:55 +00:00

index5.test

Remove possibly stray output from various tests.

2015-06-10 22:51:02 +00:00

index6.test

Do not allow a partial index scan on the left table of a RIGHT JOIN, because

2022-06-08 12:46:58 +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

Minor fix to test/index9.test so that it can be invoked with other

2022-06-08 12:35:39 +00:00

index.test

Fix test cases so that they all still work even with -DSQLITE_DQS=0.

2022-01-16 19:11:13 +00:00

indexA.test

Add string_agg(X,Y) as an alias for group_concat(X,Y), for compatibility

2023-10-20 20:19:30 +00:00

indexedby.test

…

indexexpr1.test

Experimental change to explain query plan to identify covering indexes on expressions.

2024-10-11 20:36:26 +00:00

indexexpr2.test

When translating arguments of aggregate functions into references to

2023-04-03 23:49:00 +00:00

indexexpr3.test

Experimental change to explain query plan to identify covering indexes on expressions.

2024-10-11 20:36:26 +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

Disable the "init.test" test script when compiled with SQLITE_THREADSAFE=0.

2010-03-22 15:47:38 +00:00

insert2.test

Fix an obscure problem with "INSERT INTO tbl(cols) SELECT" statements where the SELECT is a compound with an ORDER BY and "cols" is a strict subset of tbl's columns.

2015-04-21 15:49:04 +00:00

insert3.test

Move the asynchronous IO code from src/test_async.c to ext/async/. Refactor it to be a standalone module and to support windows. (CVS 6539)

2009-04-23 14:58:39 +00:00

insert4.test

Fix the Xfer-optimization on the INSERT statement so that it is omitted if

2022-02-28 16:44:58 +00:00

insert5.test

Add retry logic for AV defense to winOpen. Also, refactor test suite to allow the key Tcl file operations (e.g. copy and delete) to be retried.

2011-08-02 00:57:34 +00:00

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

Disable new test modules nockpt.test and interrupt2.test for incompatible

2016-12-27 12:35:36 +00:00

interrupt.test

Add a new sqlite3_is_interrupted() interface that can be used by long-running

2023-01-11 00:27:06 +00:00

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 a problem with applying integer affinity to a MEM_IntReal value. Forum post [forum:/forumpost/d270125fae|forum post d270125fae].

2023-01-05 13:35:23 +00:00

io.test

Update test scripts to unregister the test devsim VFS after it is used.

2021-10-19 18:40:00 +00:00

ioerr2.test

Update a couple of test cases to account for the fact that ROLLBACK does not always abort all running SELECT statements.

2014-11-18 20:16:27 +00:00

ioerr3.test

Additional test coverage improvements. Test coverage now stands at 98.73%. (CVS 4731)

2008-01-19 23:50:26 +00:00

ioerr4.test

Add retry logic for AV defense to winOpen. Also, refactor test suite to allow the key Tcl file operations (e.g. copy and delete) to be retried.

2011-08-02 00:57:34 +00:00

ioerr5.test

Get rid of "-encoding binary" across all test cases, as that is no longer

2024-07-30 17:09:51 +00:00

ioerr6.test

Fix test cases for the new EXPLAIN QUERY PLAN format. Add the

2013-06-10 23:30:09 +00:00

ioerr.test

Get rid of "-encoding binary" across all test cases, as that is no longer

2024-07-30 17:09:51 +00:00

istrue.test

Change things so that SQLITE_OMIT_VIRTUALTABLE implies SQLITE_OMIT_ALTER_TABLE.

2021-10-01 20:39:50 +00:00

join2.test

Ensure that the WhereInfo.revMask bitmap is adjusted when tables are removed

2024-09-05 23:22:55 +00:00

join3.test

Continued refactoring of the name resolution logic and query optimizer. (CVS 2236)

2005-01-19 23:24:50 +00:00

join4.test

Add the SQLITE_OMIT_TEMPDB compile time macro. (CVS 2427)

2005-03-29 03:10:59 +00:00

join5.test

Update test scripts to account for [8fcea4cd].

2024-03-19 16:51:18 +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

join7.test

New FULL JOIN test cases. No changes to code.

2022-05-31 18:18:09 +00:00

join8.test

Update test scripts to account for [8fcea4cd].

2024-03-19 16:51:18 +00:00

join9.test

Fix the query flattener so that it does not flatten a RIGHT or FULL JOIN into

2022-04-18 23:20:02 +00:00

join.test

Add [/info/cec6a06508239c09e363?ln=5525-5531|restriction (5)] to the

2023-05-11 21:15:55 +00:00

joinA.test

Generalize the LEFT JOIN strength reduction optimization so that it works for

2023-06-01 20:38:22 +00:00

joinB.test

Add 512 new join test cases derived from PostgreSQL output.

2022-04-19 15:01:57 +00:00

joinC.test

Tweaks to the name resolution on parenthesized joins. A small number of

2022-04-28 17:35:58 +00:00

joinD.test

Remove a few unsuitable scripts from the "veryquick" test suite. Also have every second testrunner.tcl process favour running test scripts that contain text like "testrunner: slow" before any others.

2022-07-18 19:32:30 +00:00

joinE.test

Corrections to the header comment to the new joinE.test script. Add the

2022-05-13 15:36:47 +00:00

joinF.test

More JOIN test cases inspired by the problem fixed in [3869fd9a2b9483cb].

2022-05-31 17:24:56 +00:00

joinH.test

Check-in [a9657c87c53c1922] is wrong: the IndexedExpr.bMaybeNullRow flag is

2024-04-05 13:56:05 +00:00

journal1.test

Fix various problems in test scripts preventing "make test" from passing on

2018-01-13 13:07:49 +00:00

journal2.test

Modify the permutations.test script so as to set any permutation specific configuration values before running each individual test script.

2016-04-27 18:54:49 +00:00

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

…

json101.test

Fix the subtype on the value column from json_each/json_tree for cases

2024-02-16 21:30:08 +00:00

json102.test

New test cases.

2024-11-26 23:30:49 +00:00

json103.test

Always enable all JSON tests, now that JSON is included by default.

2022-01-30 11:44:17 +00:00

json104.test

Fix a problem with json_patch() when one side or the other is JSON5.

2023-04-30 23:52:55 +00:00

json105.test

Add randomjson.c to testfixture. Use it for a new set of invariant tests

2023-12-18 14:24:13 +00:00

json106.test

Add test cases for json_pretty().

2024-03-06 20:38:52 +00:00

json107.test

If a BLOB looks like JSON when cast to text, then treat it as if it really

2024-01-23 13:21:40 +00:00

json108.test

Add test cases for json_pretty().

2024-03-06 20:38:52 +00:00

json501.test

Allow control characters in JSON5 string literals.

2024-01-31 13:46:44 +00:00

json502.test

Fix a bug in the parsing of some corner-case JSON PATH strings that contain

2024-09-04 16:01:44 +00:00

jsonb01.test

Avoid a potential buffer overread when handling corrupt json blobs.

2024-01-29 15:30:35 +00:00

keyword1.test

…

kvtest.c

Fix harmless typo in a comment.

2023-06-15 15:43:08 +00:00

lastinsert.test

Add additional test cases and requirements evidence marks for WITHOUT ROWID.

2013-11-27 00:45:49 +00:00

laststmtchanges.test

Make sqlite3_count_changes() and total_changes() work with "DELETE FROM <table-name>". (CVS 5844)

2008-10-27 13:59:33 +00:00

lemon-test01.y

Fix a compilation error in test/lemon-test01.y, reported in [forum:f0ad095705|forum post f0ad095705].

2024-05-07 13:20:24 +00:00

like2.test

Fix a problem in the LIKE and GLOB operators that may occur when the character immediately following a "%" or "*" wildcard is U+80. Reported by [forum:61bf7ccbdf].

2022-10-14 15:10:36 +00:00

like3.test

Revise tests cases to align with the new EXPLAIN QUERY PLAN output.

2021-03-20 15:11:29 +00:00

like.test

Fix handling of U+fffd in the LIKE optimization.

2024-10-07 12:19:23 +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

literal2.tcl

Fix a problem in the previous commit with hex literals that start with "0X" instead of "0x".

2024-01-22 19:42:56 +00:00

literal2.test

Fix a problem in the previous commit with hex literals that start with "0X" instead of "0x".

2024-01-22 19:42:56 +00:00

literal.test

Always convert 32-bit integer literals into EP_IntValue notation, even if

2024-02-28 01:12:21 +00:00

loadext2.test

Add the sqlite3_cancel_auto_extension(X) interface which will undo a prior

2013-07-15 17:02:28 +00:00

loadext.test

Fix the regexp used to recognize libdl errors on OS-X.

2018-11-17 14:59:35 +00:00

lock2.test

Fix problems with running the async.test script.

2010-07-13 07:38:51 +00:00

lock3.test

Back out check-in (6380). Replace it with a proper fix to the

2009-03-28 15:04:24 +00:00

lock4.test

Fix various problems in test scripts preventing "make test" from passing on

2018-01-13 13:07:49 +00:00

lock5.test

Avoid running some new tests in lock5.test with the inmemory_journal permutation.

2024-10-11 18:59:29 +00:00

lock6.test

Fix minor test suite problems causing errors on OSX.

2010-10-06 16:42:52 +00:00

lock7.test

Fix test cases for the new EXPLAIN QUERY PLAN format. Add the

2013-06-10 23:30:09 +00:00

lock_common.tcl

…

lock.test

Omit the antiquated and long-unsupport async extension since it has been

2024-10-28 15:38:53 +00:00

lookaside.test

…

main.test

Omit the antiquated and long-unsupport async extension since it has been

2024-10-28 15:38:53 +00:00

make-where7.tcl

…

malloc3.test

In SQLITE_ENABLE_BATCH_ATOMIC_WRITE builds on F2FS file-systems, invoke

2018-01-23 14:01:51 +00:00

malloc4.test

Add the memory fault simulator to mem5.c. Enable soft heap limit on mem5.c.

2008-02-18 22:24:57 +00:00

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

Add the memory fault simulator to mem5.c. Enable soft heap limit on mem5.c.

2008-02-18 22:24:57 +00:00

malloc7.test

Add the memory fault simulator to mem5.c. Enable soft heap limit on mem5.c.

2008-02-18 22:24:57 +00:00

malloc8.test

Add the memory fault simulator to mem5.c. Enable soft heap limit on mem5.c.

2008-02-18 22:24:57 +00:00

malloc9.test

Fix the output labels on the tests in malloc9. (CVS 4966)

2008-04-04 12:21:25 +00:00

malloc_common.tcl

…

malloc.test

Update a couple of test scripts so that they work on F2FS file-systems that

2018-01-24 06:30:10 +00:00

mallocA.test

Remove support for STAT3. The sqlite_stat3 tables are ignored, if they

2019-08-08 15:24:17 +00:00

mallocAll.test

Change all.test, quick.test and permutations.test so that they use a separate interpreter for each test file.

2010-06-07 17:47:26 +00:00

mallocB.test

Add the memory fault simulator to mem5.c. Enable soft heap limit on mem5.c.

2008-02-18 22:24:57 +00:00

mallocC.test

Refactor some of the global variables and commands used by tester.tcl.

2010-06-07 14:28:16 +00:00

mallocD.test

Add the memory fault simulator to mem5.c. Enable soft heap limit on mem5.c.

2008-02-18 22:24:57 +00:00

mallocE.test

Add the memory fault simulator to mem5.c. Enable soft heap limit on mem5.c.

2008-02-18 22:24:57 +00:00

mallocF.test

Add the memory fault simulator to mem5.c. Enable soft heap limit on mem5.c.

2008-02-18 22:24:57 +00:00

mallocG.test

Skip tests that require UTF-16 support when compiled with SQLITE_OMIT_UTF16.

2013-03-07 09:39:18 +00:00

mallocH.test

Bring test coverage up to 99%. (CVS 5522)

2008-08-01 20:10:08 +00:00

mallocI.test

Add a test case for the fix in [a596b7c6cc].

2016-10-05 15:04:35 +00:00

mallocJ.test

More coverage improvements. (CVS 6148)

2009-01-09 02:49:31 +00:00

mallocK.test

Revise tests cases to align with the new EXPLAIN QUERY PLAN output.

2021-03-20 15:11:29 +00:00

mallocL.test

From test scripts, remove stray "breakpoint" commands and blank lines

2016-02-05 16:46:09 +00:00

mallocM.test

Fix a crash that could follow an OOM condition in the instr() SQL function.

2017-03-16 12:11:07 +00:00

malloctraceviewer.tcl

…

manydb.test

Add retry logic for AV defense to winOpen. Also, refactor test suite to allow the key Tcl file operations (e.g. copy and delete) to be retried.

2011-08-02 00:57:34 +00:00

mem5.test

Fix issue with mem5 allocator when min request size is larger thatn 2^30.

2011-03-09 21:36:17 +00:00

memdb1.test

Get rid of "-encoding binary" across all test cases, as that is no longer

2024-07-30 17:09:51 +00:00

memdb2.test

Add string_agg(X,Y) as an alias for group_concat(X,Y), for compatibility

2023-10-20 20:19:30 +00:00

memdb.test

Simplify the page recycling condition in pcache1. Fix test cases to work

2015-07-07 14:06:18 +00:00

memjournal2.test

Add string_agg(X,Y) as an alias for group_concat(X,Y), for compatibility

2023-10-20 20:19:30 +00:00

memjournal.test

Fix a problem in the in-memory journal code that could occasionally lead to a segfault when a sub-transaction that modified zero pages was committed.

2021-05-24 14:35:19 +00:00

memleak.test

Omit the antiquated and long-unsupport async extension since it has been

2024-10-28 15:38:53 +00:00

memsubsys1.test

An attempt to enhance PRAGMA integrity check so that it does data type

2022-10-10 18:25:05 +00:00

memsubsys2.test

Fix problems with test scripts preventing them from running with SQLITE_DEFAULT_MEMSTATUS=0 builds. Or builds without SQLITE_ENABLE_STAT4.

2023-02-06 11:02:31 +00:00

merge1.test

Enhance the generate_series() table-valued function such that it is able to

2024-08-22 18:12:10 +00:00

minmax2.test

Also prohibit the use of rowid from a subquery. Add the

2021-04-07 15:45:01 +00:00

minmax3.test

Change the weighting of binary searches on tables to 1/10th the cost of a

2011-01-28 01:57:41 +00:00

minmax4.test

Add tests to ensure that this branch really does fix ticket [f8a7060ece].

2019-08-17 18:16:59 +00:00

minmax.test

Defer deleting subqueries in the compound-SELECT code generator until the

2021-08-21 16:42:58 +00:00

misc1.test

Allow underscores to occur in hex literals.

2024-01-22 19:38:55 +00:00

misc2.test

Update tests to work with SQLITE_ALLOW_ROWID_IN_VIEW.

2024-03-19 15:27:15 +00:00

misc3.test

Minor adjustments to get Tcl9-based testing working on Macs.

2024-07-31 12:19:16 +00:00

misc4.test

Add the SQLITE_DEFAULT_DEFENSIVE compile-time option. Fix up test cases

2018-11-07 02:17:01 +00:00

misc5.test

Ensure that the database encoding is detected before the code generator gets

2024-11-04 19:08:53 +00:00

misc6.test

Get the build working with -DSQLITE_OMIT_UTF16=1. Ticket #2314. (CVS 3865)

2007-04-23 23:56:31 +00:00

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

Fix all test cases so that they work with SQLITE_ALLOW_ROWID_IN_VIEW.

2024-03-21 10:35:33 +00:00

misuse.test

Update error message text for standard error codes to better describe the

2017-07-10 12:07:53 +00:00

mjournal.test

Add the SQLITE_DEFAULT_DEFENSIVE compile-time option. Fix up test cases

2018-11-07 02:17:01 +00:00

mmap1.test

Slight adjustment to test results for Windows in mmap1.test due to

2024-01-23 21:10:01 +00:00

mmap2.test

Add extra "PRAGMA mmap_size = N" statements to mmap1.test and mmap2.test.

2013-05-17 12:25:00 +00:00

mmap3.test

Many more test cases fixed. Only a few remain.

2016-03-14 18:34:42 +00:00

mmap4.test

Avoid running some particularly time-consuming tests as part of veryquick.test.

2016-02-04 17:31:03 +00:00

mmapcorrupt.test

Do not attempt to run mmapcorrupt.test with builds that do not support mmap().

2024-05-21 14:54:46 +00:00

mmapfault.test

Make sure errors encountered while initializing extensions such as FTS4

2013-12-19 16:26:05 +00:00

mmapwarm.test

Update some test cases to work with SQLITE_OMIT_VIRTUALTABLE and

2017-10-12 11:13:34 +00:00

multiplex2.test

…

multiplex3.test

…

multiplex4.test

…

multiplex.test

…

mutex1.test

Fix mutex1.test to take into account that the prng mutex is not (as of [c84e4483cb4]) taken when writing a header to an in-memory journal.

2023-10-23 14:24:09 +00:00

mutex2.test

Remove the SQLITE_MUTEX_APPDEF compile-time option. The SQLITE_THREADSAFE=0

2008-10-07 15:25:48 +00:00

nan.test

Adjust a few tests that don't work even with the new floating point

2024-07-31 01:53:48 +00:00

nockpt.test

Fix a problem in test file nockpt.test causing errors with

2018-03-09 14:11:36 +00:00

nolock.test

Skip recently added test cases in nolock.test when running in

2016-03-21 16:19:29 +00:00

normalize.test

…

notify1.test

Add retry logic for AV defense to winOpen. Also, refactor test suite to allow the key Tcl file operations (e.g. copy and delete) to be retried.

2011-08-02 00:57:34 +00:00

notify2.test

Change notify2.test to check that sqlite3_blocking_step() uses CPU more efficiently than sqlite3_step(), not that it results in greater overall throughput for any specific number of threads.

2014-12-30 12:03:35 +00:00

notify3.test

Ensure that the database encoding cannot be changed while there are statements running. And that the connection is left in a valid state after an obscure OOM within sqlite3_deserialize().

2023-01-20 17:50:24 +00:00

notnull2.test

The NOT NULL strength reduction optimization from [de9c86c9e4cdb34f] should

2024-03-08 21:37:18 +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

Fix text-to-numeric type casting so that it works correctly on UTF16

2013-03-20 12:04:29 +00:00

numindex1.test

More test cases for indexes on large numeric values.

2015-11-06 04:14:38 +00:00

offset1.test

Fix a problem with the query optimizer for LIMIT/OFFSET queries when

2022-08-04 17:15:00 +00:00

openv2.test

Add retry logic for AV defense to winOpen. Also, refactor test suite to allow the key Tcl file operations (e.g. copy and delete) to be retried.

2011-08-02 00:57:34 +00:00

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

Enable the sqlite3_serialize() and sqlite3_deserialize() interfaces by

2021-05-08 17:18:23 +00:00

orderby1.test

Change EXPLAIN QUERY PLAN output to say "USE TEMP B-TREE FOR LAST TERM OF ORDER BY", or "LAST N TERMS OF ORDER BY", instead of "RIGHT PART OF ORDER BY".

2024-03-20 16:27:08 +00:00

orderby2.test

…

orderby3.test

…

orderby4.test

…

orderby5.test

…

orderby6.test

…

orderby7.test

…

orderby8.test

…

orderby9.test

…

orderbyA.test

…

orderbyB.test

Fix handling of COLLATE. Add test cases for the same. Code cleanup for

2024-08-16 11:26:21 +00:00

oserror.test

…

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

Fix utility compilation issues with MSVC.

2018-03-07 14:42:17 +00:00

ovfl.test

From test scripts, remove stray "breakpoint" commands and blank lines

2016-02-05 16:46:09 +00:00

pager1.test

Increase the max_page_count on ROLLBACK, if necessary, so that it is sufficient

2022-03-01 14:13:32 +00:00

pager2.test

Fix the pager2-3.1 test case so that it does not run if a required

2023-05-05 14:14:10 +00:00

pager3.test

Fix various problems in test scripts preventing "make test" from passing on

2018-01-13 13:07:49 +00:00

pager4.test

Fix a couple of problems with new test scripts causing the permutations test to fail.

2014-01-27 16:35:15 +00:00

pagerfault2.test

Fix test cases for the new EXPLAIN QUERY PLAN format. Add the

2013-06-10 23:30:09 +00:00

pagerfault3.test

Fix test cases for the new EXPLAIN QUERY PLAN format. Add the

2013-06-10 23:30:09 +00:00

pagerfault.test

In SQLITE_ENABLE_BATCH_ATOMIC_WRITE builds on F2FS file-systems, invoke

2018-01-23 14:01:51 +00:00

pageropt.test

More test-case changes so that everything works when the reserved_bytes

2016-03-15 12:37:08 +00:00

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

Modify a few test scripts to avoid leaving the sqlite3Config structure in a non-default state.

2015-07-24 14:17:17 +00:00

pcache.test

Defer the bulk pcache1 memory allocation until the first page allocation

2015-07-16 18:18:19 +00:00

pendingrace.test

Get rid of "-encoding binary" across all test cases, as that is no longer

2024-07-30 17:09:51 +00:00

percentile.test

Improved error messages on percentile functions. More tests cases for

2024-09-02 11:17:04 +00:00

permutations.test

Omit the antiquated and long-unsupport async extension since it has been

2024-10-28 15:38:53 +00:00

pg_common.tcl

…

pragma2.test

From test scripts, remove stray "breakpoint" commands and blank lines

2016-02-05 16:46:09 +00:00

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 a memory error in test logic introduced by [8704034254938662].

2025-01-07 15:39:57 +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

pragma6.test

Fix pragma6.test so that it works with ENABLE_OVERSIZE_CELL_CHECK builds.

2024-03-08 11:13:20 +00:00

pragma.test

Add a test case to the fix to PRAGMA integrity_check in the previous check-in.

2024-05-02 12:00:36 +00:00

pragmafault.test

Fix a problem causing "PRAGMA integrity_check" to disable the xfer

2017-04-04 19:58:54 +00:00

prefixes.test

Add scalar function "prefix_length()" to ext/misc/prefixes.c.

2019-01-14 20:44:00 +00:00

printf2.test

Fix some of the new date/time function features to comply with the spec.

2022-01-21 18:57:30 +00:00

printf.test

Fix rounding in zero-precision %f and %g printf conversions.

2024-02-17 03:32:31 +00:00

progress.test

More test output refinements.

2015-06-10 23:02:38 +00:00

ptrchng.test

Remove leftover debugging commands (breakpoint and btree_breakpoint) from

2008-07-12 14:52:20 +00:00

pushdown.test

Ensure that the query flattener does not change an ON clause term to a WHERE clause term.

2024-12-02 17:21:52 +00:00

queryonly.test

Add the experimental "query_only" pragma.

2013-07-11 15:22:31 +00:00

quick.test

Add test file pager1.test, containing tests of inter-process locking in non-wal mode.

2010-06-15 17:44:47 +00:00

quickcheck.test

Add string_agg(X,Y) as an alias for group_concat(X,Y), for compatibility

2023-10-20 20:19:30 +00:00

quota2.test

…

quota-glob.test

…

quota.test

…

quote.test

Improved error message when a double-quoted string is used and it seems likely

2024-01-22 15:26:33 +00:00

randexpr1.tcl

Add test cases that verify evaluation of randomly generated SQL expressions. (CVS 6029)

2008-12-15 16:33:29 +00:00

randexpr1.test

Changes to various test scripts so that veryquick.test runs with OMIT_COMPOUND_SELECT defined.

2012-02-13 10:00:35 +00:00

rbu.test

Change the name of the OTA extension to RBU: Resumable Bulk Update.

2015-07-23 20:44:49 +00:00

rdonly.test

Clearification of some documentation text. Added requirements marks.

2015-03-06 04:37:26 +00:00

readonly.test

Fix problems uncovered while testing Tcl9 on Windows.

2024-07-31 13:00:18 +00:00

recover.test

Get rid of "-encoding binary" across all test cases, as that is no longer

2024-07-30 17:09:51 +00:00

regexp1.test

…

regexp2.test

Fix more cases in the regexp extension where the 0x00 terminator at the end

2021-06-04 15:56:43 +00:00

reindex.test

…

resetdb.test

Add tests for changing the database encoding via RESET_DATABASE/VACUUM. And test that it is not possible to trick another connection with this.

2023-01-20 15:13:30 +00:00

resolver01.test

Fix a faulty assert() in the "AS" alias resolution logic of the parser.

2015-04-23 13:37:05 +00:00

returning1.test

Fix a very obscure issue where the name resolver could get confused if aliases like "sqlite_schema" or "sqlite_master" were used in a query involving the sqlite_temp_schema table.

2024-06-05 11:36:58 +00:00

returningfault.test

…

rollback2.test

Revise tests cases to align with the new EXPLAIN QUERY PLAN output.

2021-03-20 15:11:29 +00:00

rollback.test

Get rid of "-encoding binary" across all test cases, as that is no longer

2024-07-30 17:09:51 +00:00

rollbackfault.test

From test scripts, remove stray "breakpoint" commands and blank lines

2016-02-05 16:46:09 +00:00

round1.test

Improved rounding policy.

2023-07-01 17:56:00 +00:00

rowallock.test

Fix the rowallock.test script so that it works with builds that do not support mmap mode.

2015-07-25 14:26:17 +00:00

rowhash.test

In the rowhash.test, make sure global variables are cleared prior to use.

2010-06-02 14:43:30 +00:00

rowid.test

Fix all test cases so that they work with SQLITE_ALLOW_ROWID_IN_VIEW.

2024-03-21 10:35:33 +00:00

rowvalue2.test

Add test cases to rowvalue2.test.

2016-08-26 19:47:30 +00:00

rowvalue3.test

New test cases for row values and RIGHT JOIN.

2022-06-01 20:08:22 +00:00

rowvalue4.test

Show the creation of IN-operator Bloom filters in the EXPLAIN QUERY PLAN output.

2024-07-03 20:10:42 +00:00

rowvalue5.test

Test cases for sqlite3_vtab_in() and sqlite3_vtab_distinct().

2022-02-02 19:15:53 +00:00

rowvalue6.test

Fix a SQL NULL handling bug in the vector IN operator code generation.

2016-08-18 19:04:57 +00:00

rowvalue7.test

Improved detection of number of column mismatch for vector assignment

2019-08-26 14:18:28 +00:00

rowvalue8.test

Fix the vector BETWEEN operator so that it only evaluates the left-most

2016-08-22 14:30:05 +00:00

rowvalue9.test

Add string_agg(X,Y) as an alias for group_concat(X,Y), for compatibility

2023-10-20 20:19:30 +00:00

rowvalue.test

Fix the whereKeyStats() routine (part of STAT4 processing only) so that it

2022-07-15 12:16:11 +00:00

rowvalueA.test

Add string_agg(X,Y) as an alias for group_concat(X,Y), for compatibility

2023-10-20 20:19:30 +00:00

rowvaluefault.test

Improve the error message in cases where there is a row-value on the LHS of an IN() operator, the RHS is a list (not a sub-select) and at least one element of the list is not a row-value with the correct number of elements.

2021-07-07 13:53:55 +00:00

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

Fix a couple of memory leaks in r-tree that can occur following an OOM condition.

2010-08-26 14:15:37 +00:00

run-wordcount.sh

…

savepoint2.test

Add the "wal" permutation to run existing test files savepoint.test and savepoint2.test in WAL mode.

2010-04-26 12:39:03 +00:00

savepoint4.test

Change savepoint4.test to limit database growth. Otherwise the test can take a very long time to run, depending on the prng. (CVS 6737)

2009-06-09 15:25:33 +00:00

savepoint5.test

Reinitialize page 1 of the database file following a ROLLBACK TO of a

2009-01-02 21:08:09 +00:00

savepoint6.test

Attempt to reduce divergence with the wal2 branch.

2024-11-18 17:05:45 +00:00

savepoint7.test

Add test cases for ticket [7f7f8026eda387d544].

2016-04-07 21:14:35 +00:00

savepoint.test

Further fixes to comments in sqlite3recover.h. Also rework some data structures in sqlite3recover.c.

2022-09-09 20:44:56 +00:00

savepointfault.test

Avoid running some particularly time-consuming tests as part of veryquick.test.

2016-02-04 17:31:03 +00:00

scanstatus2.test

Under Tcl9, the %x format letter truncates to 32-bits. Must use %llx in order

2024-07-31 19:56:14 +00:00

scanstatus.test

Make the SQLITE_DBCONFIG_STMT_SCANSTATUS option on by default.

2023-03-03 21:17:12 +00:00

schema2.test

Simplify wording of backup API error message. Decapitalize some other

2009-02-04 17:40:57 +00:00

schema3.test

Change things so that SQLITE_OMIT_VIRTUALTABLE implies SQLITE_OMIT_ALTER_TABLE.

2021-10-01 20:39:50 +00:00

schema4.test

All temp.sqlite_master to be used as an alias for sqlite_temp_master.

2016-12-16 01:00:21 +00:00

schema5.test

Standardize the error messages generated by constraint failures to a format

2013-11-05 13:33:55 +00:00

schema6.test

Updates to test procedures so that they all work with encryption. No changes

2017-10-23 16:34:07 +00:00

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

Fix test cases for the new EXPLAIN QUERY PLAN format. Add the

2013-06-10 23:30:09 +00:00

securedel.test

Update tests to deal with SQLITE_FAST_SECURE_DELETE.

2017-11-28 00:52:14 +00:00

seekscan1.test

Avoid having OP_SeekScan jump over an OP_IdxGT or OP_IdxGE that follows the OP_SeekGE opcode. Fix for [b50528af4468237c].

2023-03-29 21:58:06 +00:00

select1.test

Improve EXPLAIN QUERY PLAN output and comments on bytecode listings by

2022-04-22 17:36:10 +00:00

select2.test

Further refinements to table order selection on join query planning.

2010-04-15 01:04:54 +00:00

select3.test

Add string_agg(X,Y) as an alias for group_concat(X,Y), for compatibility

2023-10-20 20:19:30 +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

When doing the optimization that attempts to avoid sorting on a

2021-04-26 14:32:48 +00:00

select6.test

Fix an obscure problem with multiple outer joins, ON clauses and query flattening. Forum [forum:5c8a069d23|thread 5c8a069d23].

2024-12-09 11:12:12 +00:00

select7.test

Do not let the number of terms on a VALUES clause be limited by

2024-08-08 14:45:50 +00:00

select8.test

Remove possibly stray output from various tests.

2015-06-10 22:51:02 +00:00

select9.test

Revise tests cases to align with the new EXPLAIN QUERY PLAN output.

2021-03-20 15:11:29 +00:00

selectA.test

Change EXPLAIN QUERY PLAN output to say "USE TEMP B-TREE FOR LAST TERM OF ORDER BY", or "LAST N TERMS OF ORDER BY", instead of "RIGHT PART OF ORDER BY".

2024-03-20 16:27:08 +00:00

selectB.test

Minor cleanups of the compound-subquery flattening logic. New test cases

2011-12-10 23:18:32 +00:00

selectC.test

Do not perform the omit-unused-subquery-columns optimizations on a

2023-02-16 15:54:55 +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

Fix a faulty assert() statement in the name resolver associated with the

2015-04-15 06:45:13 +00:00

selectF.test

Change an OP_SCopy into an OP_Copy in a case where the destination might be

2014-03-03 17:36:39 +00:00

selectG.test

Avoid excess stack usage when a VALUES clause with lots of rows occurs

2018-01-14 20:12:23 +00:00

selectH.test

Do not disable unused columns in a UNION ALL sub-query if any component of the sub-query is DISTINCT.

2023-08-31 18:00:10 +00:00

session.test

Change the names of the stream interface APIs to be of the form

2014-09-27 20:45:48 +00:00

sessionfuzz-data1.db

Add the sessionfuzz test program and data obtained from a week of running

2018-03-07 20:48:21 +00:00

sessionfuzz.c

Enhancements to testrunner.tcl:

2024-03-21 11:46:52 +00:00

shared2.test

Change the ROLLBACK command so that pending statements to not block it. The

2012-02-13 16:43:16 +00:00

shared3.test

More test case changes so that shared-cache mode tests all work

2020-11-19 21:01:11 +00:00

shared4.test

Remove possibly stray output from various tests.

2015-06-10 22:51:02 +00:00

shared6.test

Add retry logic for AV defense to winOpen. Also, refactor test suite to allow the key Tcl file operations (e.g. copy and delete) to be retried.

2011-08-02 00:57:34 +00:00

shared7.test

Identify requirements text in the SQLITE_CONFIG_ documentation. Fix a typo

2013-10-11 23:37:57 +00:00

shared8.test

Add the SQLITE_DEFAULT_DEFENSIVE compile-time option. Fix up test cases

2018-11-07 02:17:01 +00:00

shared9.test

In the documentation emphasize that the use of shared cache is discouraged.

2022-08-15 12:26:26 +00:00

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

In the documentation emphasize that the use of shared cache is discouraged.

2022-08-15 12:26:26 +00:00

sharedB.test

In the documentation emphasize that the use of shared cache is discouraged.

2022-08-15 12:26:26 +00:00

sharedlock.test

Obtain the required shared-cache write-lock when executing "DELETE FROM tbl" statements. Fix for [1e1321ee98].

2013-09-26 15:21:16 +00:00

shell1.test

An improved method for statically linking sqlite3_analyzer.exe using Tcl9.

2024-10-11 17:02:37 +00:00

shell2.test

Disable shell test cases that require virtual tables when testfixture is

2024-08-28 09:47:29 +00:00

shell3.test

Fix a couple of memory leaks in the shell tool code that could occur when processing errors.

2024-06-04 15:07:38 +00:00

shell4.test

Update mdevtest and sdevtest to do shell builds in parallel. And only if one or more of the tcl scripts run requires it.

2024-03-11 19:33:55 +00:00

shell5.test

Disable shell test cases that require virtual tables when testfixture is

2024-08-28 09:47:29 +00:00

shell6.test

Update mdevtest and sdevtest to do shell builds in parallel. And only if one or more of the tcl scripts run requires it.

2024-03-11 19:33:55 +00:00

shell7.test

Get rid of "-encoding binary" across all test cases, as that is no longer

2024-07-30 17:09:51 +00:00

shell8.test

When extracting links from sqlar archives, clobber any existing file or link, and do not call utimes() to set the timestamp - it looks through the link and operates on the target.

2024-05-06 20:21:31 +00:00

shell9.test

Update mdevtest and sdevtest to do shell builds in parallel. And only if one or more of the tcl scripts run requires it.

2024-03-11 19:33:55 +00:00

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

Fix problems with test scripts preventing them from running with SQLITE_DEFAULT_MEMSTATUS=0 builds. Or builds without SQLITE_ENABLE_STAT4.

2023-02-06 11:02:31 +00:00

sidedelete.test

Fix (make test) with SQLITE_OMIT_COMPOUND_SELECT. Ticket #3235. (CVS 5530)

2008-08-04 03:51:24 +00:00

skipscan1.test

If a subquery is materialized due to an ORDER BY and that ordering is useful

2024-08-15 23:38:52 +00:00

skipscan2.test

Change things so that SQLITE_OMIT_VIRTUALTABLE implies SQLITE_OMIT_ALTER_TABLE.

2021-10-01 20:39:50 +00:00

skipscan3.test

Enhancements to skip-scan such that it is operable when a middle column of

2014-08-20 23:38:07 +00:00

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

When possible, avoid taking wal file read-lock 0 in sqlite3_snapshot_get().

2024-09-26 18:02:17 +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

…

snapshot_up.test

…

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

More test cases and requirements marks for pragmas.

2015-02-28 01:04:27 +00:00

sort2.test

…

sort3.test

…

sort4.test

Fix the sort4.test module so that the first two test cases are omitted

2024-12-19 14:20:47 +00:00

sort5.test

…

sort.test

…

sorterref.test

…

sortfault.test

…

speed1.test

Update test scripts speed1.test and speed1p.test so they may be run by testrunner.tcl.

2023-02-06 15:46:01 +00:00

speed1p.explain

Add speed-test scripts that also show EXPLAIN output. (CVS 5017)

2008-04-16 12:57:48 +00:00

speed1p.test

Update test scripts speed1.test and speed1p.test so they may be run by testrunner.tcl.

2023-02-06 15:46:01 +00:00

speed2.test

Detect database file changes using a 128-bit segment of the file header

2007-04-16 15:02:19 +00:00

speed3.test

Rename a test procedure in 'speed3.test' to avoid a name collision.

2016-08-26 04:32:59 +00:00

speed4.test

Remove leftover debugging commands (breakpoint and btree_breakpoint) from

2008-07-12 14:52:20 +00:00

speed4p.explain

…

speed4p.test

Avoid running a couple of tests in crash8.test that depend on the presence of

2018-03-06 11:46:34 +00:00

speedtest1.c

Remove all code that makes use of the C-language "long double" datatype.

2024-10-01 20:29:43 +00:00

spellfix2.test

Adjustments to spellfix2.test so that it works reliably on mac.

2015-10-07 16:14:18 +00:00

spellfix3.test

Update spellfix1_scriptcode() to output 215 (latin) for pure numeric text.

2016-03-11 14:30:18 +00:00

spellfix4.test

Improve performance of editdist3() by keeping the costs in sorted order.

2018-02-15 03:56:33 +00:00

spellfix.test

Try to optimize spellfix1 by storing a NULL in the k1 column of %_vocab

2018-02-14 14:13:09 +00:00

sqldiff1.test

…

sqllimits1.test

Fix a test case in sqllimits1.test so that it works with the Apple

2024-12-19 20:29:36 +00:00

sqllog.test

…

starschema1.test

Fix typos in the star-schema test cases.

2024-05-29 09:53:19 +00:00

startup.c

Add the "startup" test program designed to measure startup performance,

2021-01-01 15:13:17 +00:00

stat.test

There are two possible error messages from stat-9.1, depending on

2021-11-22 16:06:57 +00:00

statfault.test

Add string_agg(X,Y) as an alias for group_concat(X,Y), for compatibility

2023-10-20 20:19:30 +00:00

stmt.test

Fix various problems in test scripts preventing "make test" from passing on

2018-01-13 13:07:49 +00:00

stmtrand.test

Add the stmtrand() extension function for use in testing.

2024-05-24 14:16:06 +00:00

stmtvtab1.test

…

strict1.test

Allow an "IntReal" value to count as a REAL when checking types for

2022-01-17 23:37:25 +00:00

strict2.test

Fix an issue in PRAGMA integrity_check associated reporting NULL values in

2021-11-03 11:43:09 +00:00

subjournal.test

Change the error message text for SQLITE_ERROR to omit the part about

2017-07-07 19:43:23 +00:00

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

Further improvements to the computation of affinity for compound subqueries:

2024-04-25 17:52:10 +00:00

subselect.test

Catch vector size mismatch problems during name resolution to avoid later

2016-09-05 12:02:34 +00:00

substr.test

Allow "substring()" as an alias for "substr()" for compatibility with other

2020-11-23 14:50:43 +00:00

subtype1.test

New test cases.

2024-11-26 23:30:49 +00:00

superlock.test

Get rid of "-encoding binary" across all test cases, as that is no longer

2024-07-30 17:09:51 +00:00

swarmvtab2.test

Enhance the "swarmvtab" extension. See header comments in ext/misc/unionvtab.c

2017-12-15 20:21:17 +00:00

swarmvtab3.test

Fix a problem in test file swarmvtab3.test causing occasional failures.

2022-05-16 16:10:04 +00:00

swarmvtab.test

Fix test cases so that they all still work even with -DSQLITE_DQS=0.

2022-01-16 19:11:13 +00:00

swarmvtabfault.test

…

symlink2.test

Document that -nofollow does not work on Windows. Fix Windows symlink

2024-11-21 01:50:01 +00:00

symlink.test

…

sync2.test

Fix various problems in test scripts preventing "make test" from passing on

2018-01-13 13:07:49 +00:00

sync.test

Fix various problems in test scripts preventing "make test" from passing on

2018-01-13 13:07:49 +00:00

syscall.test

Get rid of "-encoding binary" across all test cases, as that is no longer

2024-07-30 17:09:51 +00:00

sysfault.test

A unix VFS change replaces fsync() with fstat() when using SQLITE_NO_SYNC, so

2015-12-03 01:48:32 +00:00

tabfunc01.test

Have the xBestIndex method of the generate_series virtual table ignore contraints on the "value" column with usable=0.

2024-11-05 18:25:32 +00:00

table.test

Add string_agg(X,Y) as an alias for group_concat(X,Y), for compatibility

2023-10-20 20:19:30 +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

Throw an error if AUTOINCREMENT appears in a WITHOUT ROWID table.

2013-11-09 18:15:35 +00:00

tclsqlite.test

Make the sqlite3_error_offset() interface accessible from TCL using the

2022-02-16 15:11:01 +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

Fix various problems in test scripts preventing "make test" from passing on

2018-01-13 13:07:49 +00:00

tempfault.test

Fix some problems to do with temp-file databases and recovering from IO and SQLITE_FULL errors.

2016-04-23 14:55:28 +00:00

temptable2.test

Remove a few unsuitable scripts from the "veryquick" test suite. Also have every second testrunner.tcl process favour running test scripts that contain text like "testrunner: slow" before any others.

2022-07-18 19:32:30 +00:00

temptable3.test

Add another test case to temptable3.test.

2016-05-10 20:16:43 +00:00

temptable.test

Many spelling fixes in comments. No changes to code.

2013-03-21 21:20:32 +00:00

temptrigger.test

All temp.sqlite_master to be used as an alias for sqlite_temp_master.

2016-12-16 01:00:21 +00:00

tester.tcl

Testrunner.tcl enhancements: (1) Attempt to build the SQLite tcl extension

2024-09-05 15:28:15 +00:00

testrunner_data.tcl

Patch bundle accumulated via /chat: add missing --enable/disable-shared flag to configure script and update testrunner.tcl for other configure script flag changes.

2024-10-26 16:03:04 +00:00

testrunner.tcl

Fix minor problems in testrunner.tcl that pop up when the command-line arguments

2024-11-18 13:29:16 +00:00

thread1.test

Avoid running thread1.test or thread2.test if SQLITE_MUTEX_NOOP is defined.

2011-04-07 14:05:47 +00:00

thread2.test

Avoid running thread1.test or thread2.test if SQLITE_MUTEX_NOOP is defined.

2011-04-07 14:05:47 +00:00

thread3.test

Add string_agg(X,Y) as an alias for group_concat(X,Y), for compatibility

2023-10-20 20:19:30 +00:00

thread001.test

In the documentation emphasize that the use of shared cache is discouraged.

2022-08-15 12:26:26 +00:00

thread002.test

In the documentation emphasize that the use of shared cache is discouraged.

2022-08-15 12:26:26 +00:00

thread003.test

Enable the thread test logic to work with the SQLITE_HAS_CODEC compile-time

2011-08-30 19:52:32 +00:00

thread004.test

Remove leftover "breakpoint" commands from test scripts. Also remove blank

2009-06-05 17:09:11 +00:00

thread005.test

Add retry logic for AV defense to winOpen. Also, refactor test suite to allow the key Tcl file operations (e.g. copy and delete) to be retried.

2011-08-02 00:57:34 +00:00

thread_common.tcl

Changes to the TCL extension and how it is built, suggested by Jan Nijtmans.

2024-10-09 13:19:21 +00:00

threadtest1.c

Bug-fixes to get the two threadtest C programs working again. (CVS 1756)

2004-06-29 07:45:33 +00:00

threadtest2.c

Fix some problems in test code detected by cppcheck.

2015-08-05 08:01:46 +00:00

threadtest3.c

Fix compilation of 'threadtest3' for some older versions of MSVC.

2021-07-20 00:18:22 +00:00

threadtest4.c

Add extra tests to threadtest4.c. Fix a benign data race accessing the

2014-12-12 23:17:54 +00:00

threadtest5.c

Add the new threadtest5 test program for stressing multiple database

2021-05-12 14:17:20 +00:00

time-wordcount.sh

…

timediff1.test

Extended the time-diff format so that it can have a 5-digit year. This enables

2023-06-13 16:55:24 +00:00

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

…

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

Get rid of "-encoding binary" across all test cases, as that is no longer

2024-07-30 17:09:51 +00:00

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

All tests in "make test" now pass with Tcl9, except for about 198 cases where

2024-07-30 20:39:05 +00:00

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

Ensure that values generated by DEFAULT clauses that specify real numbers that can be expressed as 64-bit integers (e.g. -1234.0) are not silently converted to integers.

2024-01-20 18:41:13 +00:00

tkt-18458b1a.test

…

tkt-31338dca7e.test

…

tkt-54844eea3f.test

…

tkt-313723c356.test

…

tkt-868145d012.test

…

tkt-3998683a16.test

…

tkt-99378177930f87bd.test

…

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

Adjust date/time functions so that they do a better job of keeping track

2024-03-04 13:58:09 +00:00

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

Testing coverage enhancements. (CVS 5358)

2008-07-08 00:06:49 +00:00

tpch01.test

Revise tests cases to align with the new EXPLAIN QUERY PLAN output.

2021-03-20 15:11:29 +00:00

trace2.test

Fix a problem causing the fts3 integrity-check to fail if run inside a transaction.

2015-04-23 11:52:04 +00:00

trace3.test

Fix the trace3-4.4 test to be more rebust against timing quirks.

2023-11-21 12:02:04 +00:00

trace.test

Show the text of individual statements within a trigger, as they

2017-12-27 20:38:35 +00:00

trans2.test

Update a few test cases to account for the new error message formats.

2013-11-28 19:28:00 +00:00

trans3.test

Experimental changes that permit read operations to continue after a

2014-11-11 01:33:57 +00:00

trans.test

Add support for the sqlite3_txn_state() interface.

2020-08-25 19:09:07 +00:00

transitive1.test

Once corner case for the fix at [8b24c177061c3836] was not quite right.

2021-10-06 10:04:04 +00:00

trigger1.test

Allow arbitrary expressions as the second argument to RAISE().

2024-05-08 17:42:13 +00:00

trigger2.test

Add string_agg(X,Y) as an alias for group_concat(X,Y), for compatibility

2023-10-20 20:19:30 +00:00

trigger3.test

Rename SQLITE_CONSTRAINT_RAISE to SQLITE_CONSTRAINT_TRIGGER. Put the

2013-02-09 15:37:11 +00:00

trigger4.test

Add retry logic for AV defense to winOpen. Also, refactor test suite to allow the key Tcl file operations (e.g. copy and delete) to be retried.

2011-08-02 00:57:34 +00:00

trigger5.test

Insert #ifdefs that can optionally remove features at compiletime resulting

2004-10-31 02:22:47 +00:00

trigger6.test

Fix a datatype in trigger6.test that changed due to the previous check-in. (CVS 2454)

2005-05-05 11:04:50 +00:00

trigger7.test

Add the SQLITE_DEFAULT_DEFENSIVE compile-time option. Fix up test cases

2018-11-07 02:17:01 +00:00

trigger8.test

Changes to support recursive triggers.

2009-08-28 18:53:45 +00:00

trigger9.test

Update tests to work with SQLITE_ALLOW_ROWID_IN_VIEW.

2024-03-19 15:27:15 +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

Additional coverage testing in the new name resolver module. (CVS 5608)

2008-08-25 12:14:08 +00:00

triggerC.test

Remove support for STAT3. The sqlite_stat3 tables are ignored, if they

2019-08-08 15:24:17 +00:00

triggerD.test

Add retry logic for AV defense to winOpen. Also, refactor test suite to allow the key Tcl file operations (e.g. copy and delete) to be retried.

2011-08-02 00:57:34 +00:00

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 JSON functions so that they work correctly under PRAGMA trusted_schema.

2023-01-09 12:01:30 +00:00

tt3_checkpoint.c

…

tt3_index.c

…

tt3_lookaside1.c

…

tt3_shared.c

…

tt3_stress.c

…

tt3_vacuum.c

…

types2.test

…

types3.test

All tests in "make test" now pass with Tcl9, except for about 198 cases where

2024-07-30 20:39:05 +00:00

types.test

…

unhex.test

Add string_agg(X,Y) as an alias for group_concat(X,Y), for compatibility

2023-10-20 20:19:30 +00:00

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

In the name resolver when SQLITE_ALLOW_ROWID_IN_INDEX is enabled, if there

2024-03-19 16:34:32 +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

Do not allow rowid in a UNIQUE or PRIMARY KEY constraint. (This restores the

2015-09-19 03:07:30 +00:00

unique.test

Standardize the error messages generated by constraint failures to a format

2013-11-05 13:33:55 +00:00

unixexcl.test

…

unordered.test

…

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

Restore part of the UPDATE one-pass optimization that was removed by

2023-08-01 00:34:03 +00:00

upfrom1.tcl

…

upfrom1.test

Fix a faulty assert() statement in sqlite3ExprListDup(). This is a continuation

2021-05-20 23:25:28 +00:00

upfrom2.test

Fix the assert() that attempts to verify that the table-reference to

2022-03-21 13:47:15 +00:00

upfrom3.test

Revise tests cases to align with the new EXPLAIN QUERY PLAN output.

2021-03-20 15:11:29 +00:00

upfrom4.test

Avoid performing aggregate processing more than once for a single expression. [forum:/info/36ff78b2a3|Forum post 36ff78b2a3].

2023-05-23 17:35:18 +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

Test case for the fix in the previous check-in.

2024-04-12 11:28:35 +00:00

upsert2.test

Add function format() as an alias for printf(), for compatibility with other

2022-01-08 21:00:38 +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

Silently ignore redundant ON CONFLICT clauses in an UPSERT. Only the first

2024-03-08 14:01:48 +00:00

upsertfault.test

A few more tests for upsert.

2018-04-21 14:11:18 +00:00

uri2.test

Add extra tests to check the result of including a %00 escape in a URI

2016-10-26 13:44:07 +00:00

uri.test

In the documentation emphasize that the use of shared cache is discouraged.

2022-08-15 12:26:26 +00:00

utf16align.test

Fix test cases so that they all still work even with -DSQLITE_DQS=0.

2022-01-16 19:11:13 +00:00

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

Fix vacuum3.test so that it works with SQLITE_OMIT_ALTERTABLE builds.

2021-11-05 11:26:00 +00:00

vacuum4.test

Add some missing "finish_test" lines to the end of test scripts.

2017-11-17 20:07:19 +00:00

vacuum5.test

Fix various problems in test scripts preventing "make test" from passing on

2018-01-13 13:07:49 +00:00

vacuum6.test

Remove a few unsuitable scripts from the "veryquick" test suite. Also have every second testrunner.tcl process favour running test scripts that contain text like "testrunner: slow" before any others.

2022-07-18 19:32:30 +00:00

vacuum-into.test

The read-only CHECK-constraint optimization of [34ddf02d3d21151b] inhibits the

2024-04-09 13:57:27 +00:00

vacuum.test

Disable the xfer optimization if "PRAGMA count_changes=1" is configured. Ticket [c48d99d690].

2011-09-30 12:01:01 +00:00

vacuummem.test

Remove a few unsuitable scripts from the "veryquick" test suite. Also have every second testrunner.tcl process favour running test scripts that contain text like "testrunner: slow" before any others.

2022-07-18 19:32:30 +00:00

values.test

Fix an "ifcapable" expression in values.test.

2024-05-24 13:33:39 +00:00

valuesfault.test

Attempt to reduce the memory used by VALUES clauses in as many statements as possible, not just INSERT. This branch still has problems.

2024-03-11 17:27:19 +00:00

varint.test

Add some missing "finish_test" lines to the end of test scripts.

2017-11-17 20:07:19 +00:00

veryquick.test

Fix test cases for the new EXPLAIN QUERY PLAN format. Add the

2013-06-10 23:30:09 +00:00

view2.test

Ensure that objects within view definitions are not incorrectly resolved to CTEs that are part of the statement using the view.

2021-05-20 17:15:06 +00:00

view3.test

Remove a few unsuitable scripts from the "veryquick" test suite. Also have every second testrunner.tcl process favour running test scripts that contain text like "testrunner: slow" before any others.

2022-07-18 19:32:30 +00:00

view.test

Back out the previous change on this branch. In its place: Determine the

2024-04-25 16:55:53 +00:00

vt02.c

Further enhancements to make sure the correct returnning trigger is run when

2023-10-26 16:59:22 +00:00

vtab1.test

Avoid accessing the sqlite3_module.xShadowName field if (sqlite3_module.iVersion<3).

2021-11-06 10:59:27 +00:00

vtab2.test

Test case for writing to a WITHOUT ROWID virtual table. The TCLVAR virtual

2017-08-10 17:53:11 +00:00

vtab3.test

Add support for the extra parameter on the sqlite3_set_authorizer() callback

2014-09-11 13:44:52 +00:00

vtab4.test

Add the "colUsed" field to the sqlite3_index_info structure passed to virtual table xBestIndex methods. To indicate the subset of the virtual table columns that may be required by the current scan.

2015-11-26 19:33:41 +00:00

vtab5.test

Various fixes so that "make test" works with OMIT_FOREIGN_KEY, OMIT_TRIGGER and OMIT_ALTER_TABLE.

2009-09-29 06:33:23 +00:00

vtab6.test

New requirement marks.

2022-05-10 18:43:54 +00:00

vtab7.test

Update error message text for standard error codes to better describe the

2017-07-10 12:07:53 +00:00

vtab8.test

Handle the case where the estimated cost of a virtual table scan is larger than SQLITE_BIG_DBL. Ticket #2253. (CVS 3670)

2007-03-02 08:12:22 +00:00

vtab9.test

Ensure sqlite3_finalize() can be called from within the xDisconnect() method of virtual tables. (CVS 3845)

2007-04-16 15:06:25 +00:00

vtab_alter.test

…

vtab_err.test

…

vtab_shared.test

…

vtabA.test

Recognize certain standard datatypes ("INT", "INTEGER", "REAL", "TEXT", and

2021-07-30 23:30:30 +00:00

vtabB.test

Add test cases to prove that ticket #3082 has been fixed. (CVS 5048)

2008-04-25 12:10:15 +00:00

vtabC.test

Add retry logic for AV defense to winOpen. Also, refactor test suite to allow the key Tcl file operations (e.g. copy and delete) to be retried.

2011-08-02 00:57:34 +00:00

vtabD.test

Changes to various test scripts so that veryquick.test runs with OMIT_COMPOUND_SELECT defined.

2012-02-13 10:00:35 +00:00

vtabdistinct.test

Bring sqlite3_vtab_distinct() up to spec so that it works as described in the

2022-01-22 20:45:57 +00:00

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

Test case for writing to a WITHOUT ROWID virtual table. The TCLVAR virtual

2017-08-10 17:53:11 +00:00

vtabF.test

Fix typos in 'vtabF.test' file. No changes to code.

2016-08-25 23:24:09 +00:00

vtabH.test

Remove obsolete testfixture TCL commands formerly required by Windows

2024-07-31 15:04:37 +00:00

vtabI.test

Add the "colUsed" field to the sqlite3_index_info structure passed to virtual table xBestIndex methods. To indicate the subset of the virtual table columns that may be required by the current scan.

2015-11-26 19:33:41 +00:00

vtabJ.test

Fix UPDATE FROM statements on virtual tables that are declared WITHOUT ROWID.

2020-10-12 14:29:11 +00:00

vtabK.test

Improved the error message that results when a schema parse fails after

2021-11-03 15:59:17 +00:00

vtabL.test

Add extra tests for the error messages generated by sqlite3_declare_vtab() when passed something other than a well-formed CREATE TABLE statement.

2024-05-16 16:22:51 +00:00

vtabrhs1.test

…

wal2.test

Reduce divergence from begin-concurrent.

2024-11-18 18:45:31 +00:00

wal3.test

Remove a few unsuitable scripts from the "veryquick" test suite. Also have every second testrunner.tcl process favour running test scripts that contain text like "testrunner: slow" before any others.

2022-07-18 19:32:30 +00:00

wal4.test

Add retry logic for AV defense to winOpen. Also, refactor test suite to allow the key Tcl file operations (e.g. copy and delete) to be retried.

2011-08-02 00:57:34 +00:00

wal5.test

More test-case changes so that everything works when the reserved_bytes

2016-03-15 12:37:08 +00:00

wal6.test

Adjust the MSVC makefile to use Tcl8.6 by default.

2016-11-02 19:49:22 +00:00

wal7.test

Further tweaks to the wal7.test test case.

2011-06-15 19:18:47 +00:00

wal8.test

Many more test cases fixed. Only a few remain.

2016-03-14 18:34:42 +00:00

wal9.test

Update a couple of test scripts so that they work in auto-vacuum mode.

2012-12-05 09:12:58 +00:00

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

Attempt to reduce divergence with begin-concurrent.

2024-11-18 16:44:26 +00:00

wal.test

Get rid of "-encoding binary" across all test cases, as that is no longer

2024-07-30 17:09:51 +00:00

walbak.test

Many more test cases fixed. Only a few remain.

2016-03-14 18:34:42 +00:00

walbig.test

On Windows, make sure the current directory value used by the test suite is 'normalized' to what the parent command shell sees. Also, clean the test directories used by the quota2.test file.

2012-03-08 20:00:36 +00:00

walblock.test

Disable the SQLITE_FCNTL_WAL_BLOCK feature for now. It needs more work and

2015-04-03 20:33:33 +00:00

walcksum.test

Get rid of "-encoding binary" across all test cases, as that is no longer

2024-07-30 17:09:51 +00:00

walcrash2.test

Fix test cases for the new EXPLAIN QUERY PLAN format. Add the

2013-06-10 23:30:09 +00:00

walcrash3.test

…

walcrash4.test

…

walcrash.test

Update walcrash.test to ensure that, during a particular test, enough data is written to cause SQLite to sync the wal file 14 times.

2016-02-01 16:36:47 +00:00

walfault2.test

…

walfault.test

Fix duplicate test names in 'walfault.test'.

2018-01-17 01:15:08 +00:00

walhook.test

Add a version number to the wal-index header. If SQLite encounters a version number in either the wal or wal-index files that it does not understand, the operation is abandoned and SQLITE_CANTOPEN returned.

2010-06-23 15:55:43 +00:00

walmode.test

Fix various problems in test scripts preventing "make test" from passing on

2018-01-13 13:07:49 +00:00

walnoshm.test

…

waloverwrite.test

From test scripts, remove stray "breakpoint" commands and blank lines

2016-02-05 16:46:09 +00:00

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

Fix the ability to read read-only WAL-mode database when -shm is present,

2022-01-20 02:04:53 +00:00

walro.test

On unix, if the *-shm file cannot be opened for read/write access, open it

2017-11-07 15:43:52 +00:00

walrofault.test

Get read-only SHM file tests passing on Win32.

2017-11-09 20:02:44 +00:00

walseh1.test

…

walsetlk.test

…

walshared.test

In the documentation emphasize that the use of shared cache is discouraged.

2022-08-15 12:26:26 +00:00

walslow.test

Get rid of "-encoding binary" across all test cases, as that is no longer

2024-07-30 17:09:51 +00:00

walthread.test

In SQLITE_ENABLE_BATCH_ATOMIC_WRITE builds on F2FS file-systems, invoke

2018-01-23 14:01:51 +00:00

walvfs.test

Remove a few unsuitable scripts from the "veryquick" test suite. Also have every second testrunner.tcl process favour running test scripts that contain text like "testrunner: slow" before any others.

2022-07-18 19:32:30 +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

Improvements to the query planner to address the inefficiency described

2023-12-23 19:03:50 +00:00

where4.test

Improvements and simplifications to the equality seek logic. Tests are

2015-11-05 22:30:54 +00:00

where5.test

Additional test cases for comparisons against NULL in the WHERE clause

2007-06-08 08:43:10 +00:00

where6.test

Make sure the ON clause of a LEFT JOIN does not cause an index to be

2010-02-25 04:15:47 +00:00

where7.test

Fix a test case whose value changes under the no_optimization permutation

2023-08-03 13:07:58 +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

Show LEFT and RIGHT JOIN processing in the EXPLAIN QUERY PLAN output.

2022-04-11 14:26:37 +00:00

where.test

Fix some test scripts that were failing with SQLITE_OMIT_VIRTUALTABLE builds.

2023-02-06 10:47:57 +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

Tweak to the new whereB.test file to make it more consistent.

2009-08-13 19:54:26 +00:00

whereC.test

Simplified implementation of indexing with the IS operator.

2015-05-13 19:33:41 +00:00

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

…

whereF.test

Revise tests cases to align with the new EXPLAIN QUERY PLAN output.

2021-03-20 15:11:29 +00:00

wherefault.test

Add extra test case for OOM handling in where.c.

2021-04-15 13:26:29 +00:00

whereG.test

Back out an incorrect change to the sqlite3ExprCompareSkip() function that

2023-11-20 15:54:00 +00:00

whereH.test

Also make sure an index that is a proper subset of some other index has a

2014-03-31 19:49:00 +00:00

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

Omit the "noop(X)" test SQL function. Accomplish the same thing using

2024-03-17 16:01:23 +00:00

wherelfault.test

Add further tests for the code on this branch.

2017-11-10 17:47:54 +00:00

wherelimit2.test

Omit bogus tests accidentally added by the privious commit.

2024-06-06 23:22:32 +00:00

wherelimit3.test

Better optimize queries that use parameters in the LIMIT clause.

2024-06-06 15:03:16 +00:00

wherelimit.test

Fix incorrect RETURNING test cases in wherelimit.test

2021-04-06 13:57:23 +00:00

whereM.test

Add new test file whereM.test. Containing tests for the change on this branch.

2021-05-26 19:37:27 +00:00

whereN.test

Add a heuristic in between the two solver() passes of the query planner that

2024-04-02 11:44:44 +00:00

widetab1.test

Test cases for covering indexes on wide tables.

2022-10-24 11:02:02 +00:00

win32heap.test

…

win32lock.test

Remove a few unsuitable scripts from the "veryquick" test suite. Also have every second testrunner.tcl process favour running test scripts that contain text like "testrunner: slow" before any others.

2022-07-18 19:32:30 +00:00

win32longpath.test

Make extra efforts to delete the over-size directory names created by

2024-09-04 13:09:58 +00:00

win32nolock.test

…

window1.test

Fix the window-function group_concat() so that it returns an empty string

2024-05-23 23:26:04 +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 string_agg(X,Y) as an alias for group_concat(X,Y), for compatibility

2023-10-20 20:19:30 +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

Fix test cases so that they all still work even with -DSQLITE_DQS=0.

2022-01-16 19:11:13 +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 a problem with window functions min() and max() when used with a FILTER clause. Forum post [forum:/forumpost/e9126d554a | e9126d554a].

2024-11-14 14:38:16 +00:00

window8.test

Fix a problem with window functions min() and max() when used with a FILTER clause. Forum post [forum:/forumpost/e9126d554a | e9126d554a].

2024-11-14 14:38:16 +00:00

window9.test

Fix a problem with window functions min() and max() when used with a FILTER clause. Forum post [forum:/forumpost/e9126d554a | e9126d554a].

2024-11-14 14:38:16 +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

Fix some test scripts that were failing with SQLITE_OMIT_VIRTUALTABLE builds.

2023-02-06 10:47:57 +00:00

windowC.test

Fix windowC tests to specify little-endian or big-endian UTF16, for

2021-12-16 19:50:02 +00:00

windowD.test

Fix a problem with flattening and window functions causing an "IS <column>" to be transformed to "IS TRUE" or "IS FALSE" when <column> is a view or sub-select expression that is the literal value "TRUE" or "FALSE".

2022-06-02 16:26:21 +00:00

windowE.test

Fix a case where the BTCF_AtLast flag was being left set incorrectly. This was causing obscure window function queries to fail.

2024-08-29 16:27:57 +00:00

windowerr.tcl

…

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

Add extra tests for the group_concat() fix on this branch.

2021-09-29 14:14:16 +00:00

windowpushd.test

If a subquery is materialized due to an ORDER BY and that ordering is useful

2024-08-15 23:38:52 +00:00

with1.test

Do not compute result columns of subqueries that are never used. Make those

2023-02-15 17:53:17 +00:00

with2.test

Fix a name resolution issue with CTEs.

2024-08-20 22:44:40 +00:00

with3.test

The view-scan optimization was added to enhance the performance of one specific

2023-09-15 14:06:44 +00:00

with4.test

Do not allow parameters or schema references inside of WITH clause of

2018-02-15 21:00:37 +00:00

with5.test

New test cases for recursive CTEs with multiple recursive terms.

2020-10-19 01:44:43 +00:00

with6.test

If a subquery is materialized due to an ORDER BY and that ordering is useful

2024-08-15 23:38:52 +00:00

withM.test

From test scripts, remove stray "breakpoint" commands and blank lines

2016-02-05 16:46:09 +00:00

without_rowid1.test

…

without_rowid2.test

…

without_rowid3.test

…

without_rowid4.test

…

without_rowid5.test

…

without_rowid6.test

…

without_rowid7.test

…

wordcount.c

…

writecrash.test

Disable the writecrash.test module on Windows.

2017-07-28 20:49:02 +00:00

zeroblob.test

Fix the zeroblob() function and related APIs so that they work with SQLITE_OMIT_INCRBLOB builds.

2021-11-08 19:35:26 +00:00

zeroblobfault.test

Fix the zeroblob() function and related APIs so that they work with SQLITE_OMIT_INCRBLOB builds.

2021-11-08 19:35:26 +00:00

zerodamage.test

Fix various problems in test scripts preventing "make test" from passing on

2018-01-13 13:07:49 +00:00

zipfile2.test

All tests in "make test" now pass with Tcl9, except for about 198 cases where

2024-07-30 20:39:05 +00:00

zipfile.test

All tests in "make test" now pass with Tcl9, except for about 198 cases where

2024-07-30 20:39:05 +00:00

zipfilefault.test

Fix a test case in zipfilefault.test so that it only runs if JSON1 is

2018-03-09 14:06:11 +00:00