drh 588cac9388 Attempt to treat the arguments to a table-valued function as if they occur ...

in the ON clause of a LEFT JOIN rather than in the WHERE clause.  But this
causes undesirable behavior with generate_series, as demonstrated by test
cases.  This is an incremental check-in pending further work.

FossilOrigin-Name: 00ac73a01caf578c70b7114f84f35fdba9a2097c

2016-04-08 21:35:34 +00:00

..

8_3_names.test

Make test_wholenumber.c into a loadable extension and move it to

2013-04-25 11:58:36 +00:00

affinity2.test

Add test cases for type affinity rules.

2015-06-02 17:25:05 +00:00

aggerror.test

…

aggnested.test

Do not flatten aggregate subqueries that contain min() or max() functions

2014-09-15 14:46:02 +00:00

alias.test

…

all.test

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

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

alter2.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

alter3.test

Code simplification: ALTER TABLE ADD COLUMN always upgrades the file_format

2016-02-09 16:09:22 +00:00

alter4.test

Allow CAST expressions and unary "+" operators to be used in the DEFAULT

2014-08-25 20:11:52 +00:00

alter.test

Fix an assert() failure that could occur if the internal sqlite3_rename_parent() SQL scalar function was invoked directly.

2015-04-28 14:07:02 +00:00

altermalloc.test

…

amatch1.test

Add some timing tests to the amatch test script.

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

analyze3.test

Add the SQLITE_LIKE_DOESNT_MATCH_BLOBS compile-time option.

2015-12-01 21:23:07 +00:00

analyze4.test

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

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

analyze5.test

If ENABLE_STAT3 is defined but ENABLE_STAT4 is not, have ANALYZE create and populate the sqlite_stat3 table instead of sqlite_stat4.

2013-08-12 20:14:04 +00:00

analyze6.test

Expire prepared statements after running ANALYZE.

2014-07-22 14:42:16 +00:00

analyze7.test

If ENABLE_STAT3 is defined but ENABLE_STAT4 is not, have ANALYZE create and populate the sqlite_stat3 table instead of sqlite_stat4.

2013-08-12 20:14:04 +00:00

analyze8.test

Change the query planner to do a better job of estimating the number rows

2014-11-05 19:26:12 +00:00

analyze9.test

Improved debugging output with wheretrace. Fix some typos in test script

2016-03-01 22:41:27 +00:00

analyze.test

When parsing the schema, ignore any SQL that does not begin with "CREATE".

2015-04-16 00:26:03 +00:00

analyzeA.test

Test cases added for using unary "+" and CAST operators on the RHS of range

2014-08-25 20:21:07 +00:00

analyzeB.test

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

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

analyzeC.test

Enhance the sqlite_stat1.stat parsing to allow additional text parameters

2014-07-22 14:58:12 +00:00

analyzeD.test

Improved debugging output with wheretrace. Fix some typos in test script

2016-03-01 22:41:27 +00:00

analyzeE.test

Fix the STAT4 range scan estimates for DESC indexes.

2014-10-08 02:53:25 +00:00

analyzeF.test

A new approach to very large sqlite3_mprintf() strings: Back out the

2016-01-04 12:07:27 +00:00

analyzer1.test

Run TCL tests in a subdirectory "testdir".

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

async2.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

async3.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

async4.test

…

async5.test

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

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

async.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

atof1.test

A different approach to handling integer/float comparisons. This seems to

2015-11-06 14:59:07 +00:00

attach2.test

Identify requirements text in the SQLITE_CONFIG_ documentation. Fix a typo

2013-10-11 23:37:57 +00:00

attach3.test

Make sure errors encountered while initializing extensions such as FTS4

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

attach4.test

Fix some test files so that they work with SQLITE_OMIT_WAL builds.

2011-09-24 05:55:36 +00:00

attach.test

Handle very large URI pathnames for in-memory shared-cache databases.

2015-03-31 16:33:08 +00:00

attachmalloc.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

auth2.test

Add support for the extra parameter on the sqlite3_set_authorizer() callback

2014-09-11 13:44:52 +00:00

auth3.test

Add support for the extra parameter on the sqlite3_set_authorizer() callback

2014-09-11 13:44:52 +00:00

auth.test

Test that the view name is passed to the authorization callback when a SELECT statement is run on a view.

2016-04-04 16:40:44 +00:00

autoinc.test

Change the REAL-to-INTEGER casting behavior so that if the REAL value

2013-11-26 15:45:02 +00:00

autoindex1.test

Remove an incorrect ALWAYS() from the automatic index generator.

2015-04-15 07:34:25 +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

Consider using an automatic-index for a scan even if there exists a possible skip-scan that uses one or more "=" operators.

2014-11-14 19:34:20 +00:00

autoindex4.test

This additional fix prevents a partial index from being qualified for use

2015-02-24 16:48:59 +00:00

autoindex5.test

When creating an automatic-index on a sub-query, add a unique integer to the end of each index key to ensure the entire key is unique. Fix for [8a2adec1].

2015-10-24 20:31:22 +00:00

autovacuum_ioerr2.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

autovacuum.test

Test script changes to support testing the SQLite Encryption Extension.

2016-03-14 16:16:43 +00:00

avtrans.test

…

backcompat.test

Fix the backcompat.test script so that it works with the --testdir test option.

2016-03-14 15:43:03 +00:00

backup2.test

Fix backup2.test so that it passes on OpenBSD (which produces a slightly different error message in one case).

2012-01-13 15:21:07 +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

Many spelling fixes in comments. No changes to code.

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

backup_malloc.test

…

backup.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

badutf2.test

Fix some problems in os_unix.c when compiled with ENABLE_LOCKING_STYLE on OSX. Also some minor issues with test scripts.

2011-04-01 09:04:36 +00:00

badutf.test

…

bc_common.tcl

Fix the backcompat.test script so that it works with the --testdir test option.

2016-03-14 15:43:03 +00:00

bestindex1.test

Disable the bestindex*.test modules when building without virtual table support.

2016-03-09 11:59:16 +00:00

bestindex2.test

Disable the bestindex*.test modules when building without virtual table support.

2016-03-09 11:59:16 +00:00

between.test

Handle virtual tables correctly when using logarithmic costs. Fixes

2013-06-11 01:50:08 +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

bigrow.test

…

bigsort.test

Disable the bigsort.test module on machine with less than 8GB of available

2014-12-31 19:58:32 +00:00

bind.test

…

bindxfer.test

…

bitvec.test

…

blob.test

…

boundary1.tcl

…

boundary1.test

…

boundary2.tcl

…

boundary2.test

…

boundary3.tcl

Update the boundary3.tcl script so that it can be run with tcl 8.5 or 8.6 to regenerate boundary3.test.

2013-06-26 16:30:26 +00:00

boundary3.test

Improvements to ORDER BY handling in the NGQP. Fix an "exit" mistakenly

2013-05-22 02:06:59 +00:00

boundary4.tcl

…

boundary4.test

…

btree01.test

More test cases for the balancer.

2014-11-27 04:23:19 +00:00

btree02.test

Fix the saveCursorPosition() routine in btree.c so that it works

2015-03-25 17:35:01 +00:00

btreefault.test

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

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

busy.test

…

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

capi2.test

Standardize the error messages generated by constraint failures to a format

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

capi3.test

Fix "ifcapable" tests in capi3.test and capi3c.test so that the tests work with more build configurations.

2016-03-23 16:32:29 +00:00

capi3b.test

…

capi3c.test

Fix "ifcapable" tests in capi3.test and capi3c.test so that the tests work with more build configurations.

2016-03-23 16:32:29 +00:00

capi3d.test

Fix the sqlite3_stmt_busy() interface so that it always returns FALSE after

2015-07-31 18:59:56 +00:00

capi3e.test

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

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

cast.test

Changes to various test scripts so that they pass on windows.

2011-05-05 19:44:22 +00:00

cffault.test

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

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

check.test

Fix to previous check-in: Make sure CHECK constraints involving the ROWID

2016-02-10 18:24:05 +00:00

close.test

Many test cases fixed to work with encryption.

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

closure01.test

Add a few more CTE test cases to closure.test.

2014-01-24 15:42:51 +00:00

coalesce.test

…

collate1.test

Correctly handle COLLATE operators applied to COLLATE operators in an

2015-04-15 05:57:50 +00:00

collate2.test

Fix typo in test.

2013-08-21 19:59:14 +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

Test cases and bug fixes applied to the ORDER BY optimization for joins.

2012-09-27 17:31:32 +00:00

collate6.test

…

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

…

collateA.test

…

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

…

conflict2.test

Update test cases to taken deferred statement-journal opening into account.

2016-03-04 14:23:10 +00:00

conflict3.test

Fix conflict handling for the case when the rowid uses REPLACE but other

2013-11-05 19:41:32 +00:00

conflict.test

Update test cases to taken deferred statement-journal opening into account.

2016-03-04 14:23:10 +00:00

contrib01.test

Add a test case contributed on the mailing list

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

corrupt2.test

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

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

corrupt3.test

Many test cases fixed to work with encryption.

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

corrupt4.test

Many test cases fixed to work with encryption.

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

corrupt5.test

Add a new sqlite3_test_control() that indicates that database files are

2013-11-29 15:06:27 +00:00

corrupt6.test

Many test cases fixed to work with encryption.

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

corrupt7.test

Many test cases fixed to work with encryption.

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

corrupt8.test

Add a new sqlite3_test_control() that indicates that database files are

2013-11-29 15:06:27 +00:00

corrupt9.test

Add a new sqlite3_test_control() that indicates that database files are

2013-11-29 15:06:27 +00:00

corrupt.test

Add a new sqlite3_test_control() that indicates that database files are

2013-11-29 15:06:27 +00:00

corruptA.test

Add a new sqlite3_test_control() that indicates that database files are

2013-11-29 15:06:27 +00:00

corruptB.test

Add a new sqlite3_test_control() that indicates that database files are

2013-11-29 15:06:27 +00:00

corruptC.test

Remove a test made obsolete by the ONEPASS DELETE optimization.

2015-09-18 14:22:34 +00:00

corruptD.test

Add a new sqlite3_test_control() that indicates that database files are

2013-11-29 15:06:27 +00:00

corruptE.test

Many test cases fixed to work with encryption.

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

corruptF.test

Add a new sqlite3_test_control() that indicates that database files are

2013-11-29 15:06:27 +00:00

corruptG.test

Many test cases fixed to work with encryption.

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

corruptH.test

Many test cases fixed to work with encryption.

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

corruptI.test

Many test cases fixed to work with encryption.

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

corruptJ.test

Many test cases fixed to work with encryption.

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

cost.test

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

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

count.test

Change an assert() in the aggregate query code generator into a testcase().

2015-04-21 15:16:48 +00:00

coveridxscan.test

Extend [3e9ed1ae] so that covering indexes on WITHOUT ROWID tables are also identified.

2016-02-24 20:16:28 +00:00

crash2.test

…

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

Many spelling fixes in comments. No changes to code.

2013-03-21 21:20:32 +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

Add a test for the problem fixed by [bf44d73d3e].

2012-10-17 16:20:36 +00:00

crash8.test

Many test cases fixed to work with encryption.

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

crash.test

Fix all known instances of 'repeated the' style typos in comments. No changes to code.

2012-08-25 10:01:29 +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

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

cse.test

…

ctime.test

Remove the SQLITE_PAGECACHE_BLOCKALLOC compilation option.

2011-09-22 14:56:31 +00:00

cursorhint.test

Add releasetest.tcl cases for SQLITE_LIKE_DOESNT_MATCH_BLOB and

2016-01-04 01:08:50 +00:00

date.test

Enhance the 'utc' modifier on date/time functions so that if the LHS is

2015-12-23 10:54:48 +00:00

dbstatus2.test

Refactoring the mmap interface. The controlling pragma is now "mmap_size"

2013-04-15 17:03:42 +00:00

dbstatus.test

Fix issue with several memory allocation tests due to KeyInfo allocations now being shared.

2013-11-11 03:37:04 +00:00

default.test

Do not allow parameters in a DEFAULT clause of a CREATE TABLE statement.

2014-09-24 13:20:22 +00:00

delete2.test

…

delete3.test

…

delete4.test

Add test cases to the ONEPASS optimization corruption problem fixed by the

2015-09-28 15:08:28 +00:00

delete.test

Experimental change to use a single-pass approach for DELETE statements on non-virtual tables that do not fire triggers or require foriegn-key processing.

2015-09-12 19:26:11 +00:00

descidx1.test

Pull in recent trunk changes. Fix the ORDER BY optimizer so that it is better

2013-06-03 20:46:35 +00:00

descidx2.test

…

descidx3.test

Fix a test case that had an ambiguous result.

2013-03-12 22:13:33 +00:00

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

distinct.test

Remove an incorrect ALWAYS() macro. Fix for ticket [e5c6268dd807fa8950] -

2015-11-24 02:10:52 +00:00

distinctagg.test

…

e_blobbytes.test

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

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

e_blobclose.test

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

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

e_blobopen.test

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

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

e_blobwrite.test

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

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

e_changes.test

Remove a stray "exit" in a test script.

2016-01-29 18:48:08 +00:00

e_createtable.test

Update evidence marks due to wording changes in requirements text. No

2015-09-11 20:54:44 +00:00

e_delete.test

Update evidence marks due to wording changes in requirements text. No

2015-09-11 20:54:44 +00:00

e_droptrigger.test

Updates to requirements marks. No code changes.

2013-08-02 23:40:45 +00:00

e_dropview.test

Updates to requirements marks. No code changes.

2013-08-02 23:40:45 +00:00

e_expr.test

Update evidence marks due to wording changes in requirements text. No

2015-09-11 20:54:44 +00:00

e_fkey.test

Update requirements marks to fix typos in the requirements text.

2014-04-26 19:23:14 +00:00

e_fts3.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

e_insert.test

Update evidence marks due to wording changes in requirements text. No

2015-09-11 20:54:44 +00:00

e_reindex.test

Update evidence marks due to wording changes in requirements text. No

2015-09-11 20:54:44 +00:00

e_resolve.test

Update evidence marks due to wording changes in requirements text. No

2015-09-11 20:54:44 +00:00

e_select2.test

Update some requirements marks to conform with improvements

2014-01-27 15:02:07 +00:00

e_select.test

Update evidence marks on SELECT tests. Comment changes only.

2014-01-30 17:47:02 +00:00

e_totalchanges.test

Add new test file e_totalchanges.test, containing tests of the sqlite3_total_changes() interface.

2014-10-28 20:49:59 +00:00

e_update.test

Update evidence marks due to wording changes in requirements text. No

2015-09-11 20:54:44 +00:00

e_uri.test

Test script changes to support testing the SQLite Encryption Extension.

2016-03-14 16:16:43 +00:00

e_vacuum.test

Many test cases fixed to work with encryption.

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

e_wal.test

Update a requirements mark to reflect a change of wording in the documentation.

2015-02-26 16:40:41 +00:00

e_walauto.test

Many more test cases fixed. Only a few remain.

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

e_walckpt.test

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

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

e_walhook.test

Fix a requirement mark to conform to a typo fix in the documentation.

2016-02-27 14:04:27 +00:00

enc2.test

Many spelling fixes in comments. No changes to code.

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

enc3.test

Add the SQLITE_LIKE_DOESNT_MATCH_BLOBS compile-time option.

2015-12-01 21:23:07 +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

…

eqp.test

Many test cases fixed to work with encryption.

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

errmsg.test

Standardize the error messages generated by constraint failures to a format

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

eval.test

Ensure that the OP_Prev opcode verifies that content has not been deleted

2014-09-29 15:00:28 +00:00

exclusive2.test

Make sure errors encountered while initializing extensions such as FTS4

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

exclusive.test

Fix exclusive.test so that it works with -DSQLITE_TEMP_STORE=3.

2016-03-19 18:11:59 +00:00

exec.test

…

exists.test

Add a case to permutations.test to run the veryquick test suite using sqlite3_prepare() instead of sqlite3_prepare_v2(). This helps to test the fix for bug [25ee812710].

2011-06-27 16:55:50 +00:00

expr.test

In the expression-tree comparison routine, do not compiler Expr.iColumn

2015-04-17 19:41:37 +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

extraquick.test

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

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

fallocate.test

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

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

filectrl.test

Remove possibly stray output from various tests.

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

filefmt.test

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

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

fkey1.test

Clear the BTCF_ValidNKey flag when putting a cursor into REQUIRESEEK state. Fix for [1b266395].

2015-09-30 12:59:12 +00:00

fkey2.test

Make sure all cursors are closed when returning from a VDBE subprogram that

2015-04-16 18:11:50 +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

Update evidence marks due to wording changes in requirements text. No

2015-09-11 20:54:44 +00:00

fkey6.test

Disable the RESTRICT foreign key action if "PRAGMA defer_foreign_keys" is set.

2016-02-25 20:17:55 +00:00

fkey7.test

Add new test file e_blobopen.test, containing tests for sqlite3_blob_open().

2014-11-07 14:41:11 +00:00

fkey8.test

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

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

fkey_malloc.test

Update a few test cases to account for the new error message formats.

2013-11-28 19:28:00 +00:00

fordelete.test

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

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

format4.test

…

fts1a.test

…

fts1b.test

…

fts1c.test

…

fts1d.test

…

fts1e.test

…

fts1f.test

…

fts1i.test

…

fts1j.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

fts1k.test

…

fts1l.test

…

fts1m.test

…

fts1n.test

…

fts1o.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

fts1porter.test

…

fts2.test

…

fts2a.test

…

fts2b.test

…

fts2c.test

…

fts2d.test

…

fts2e.test

…

fts2f.test

…

fts2g.test

…

fts2h.test

…

fts2i.test

…

fts2j.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

fts2k.test

…

fts2l.test

…

fts2m.test

…

fts2n.test

…

fts2o.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

fts2p.test

…

fts2q.test

…

fts2r.test

…

fts2token.test

…

fts3_common.tcl

Remove the fts3merge.test script in favour of changing the fts4merge.test script so that it runs tests using both fts4 and fts3. Fix some problems with incr-merge and FTS3 tables.

2012-03-27 15:00:06 +00:00

fts3.test

…

fts3aa.test

Fix a problem affecting some fts3 UPDATE and DELETE statements on order=DESC tables.

2015-04-17 20:51:55 +00:00

fts3ab.test

Make sure errors encountered while initializing extensions such as FTS4

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

fts3ac.test

…

fts3ad.test

…

fts3ae.test

…

fts3af.test

…

fts3ag.test

Make sure errors encountered while initializing extensions such as FTS4

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

fts3ah.test

…

fts3ai.test

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

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

fts3aj.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

fts3ak.test

…

fts3al.test

…

fts3am.test

…

fts3an.test

…

fts3ao.test

Fix an obscure bug causing sqlite3_close() to fail if there are virtual tables on the disconnect list when it is called.

2014-03-12 19:38:38 +00:00

fts3atoken.test

Provide the new SQLITE_DBCONFIG_ENABLE_FTS3_TOKENIZER option to

2016-02-26 15:38:24 +00:00

fts3auto.test

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

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

fts3aux1.test

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

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

fts3aux2.test

Add the "languageid" hidden column to fts4aux.

2013-10-15 19:06:17 +00:00

fts3b.test

…

fts3c.test

…

fts3comp1.test

…

fts3conf.test

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

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

fts3corrupt2.test

…

fts3corrupt.test

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

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

fts3cov.test

…

fts3d.test

Remove possibly stray output from various tests.

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

fts3defer2.test

Fix an fts4 matchinf() problem triggered by deferred tokens that are part of phrases that are part of AND expressions.

2015-05-25 10:57:13 +00:00

fts3defer3.test

Add new test file fts3defer3.test.

2013-09-28 16:43:49 +00:00

fts3defer.test

Add the SQLITE_DISABLE_FTS4_DEFERRED compile time option.

2012-08-20 17:24:48 +00:00

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

fts3e.test

…

fts3expr2.test

…

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

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

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

fts3expr5.test

Fix an fts4 problem to do with the handling of phrases that contain zero tokens.

2015-04-21 12:06:53 +00:00

fts3expr.test

Fix the way parenthesis in MATCH expressions are handled by FTS if the tokenizer considers them to be token characters.

2014-05-07 19:59:36 +00:00

fts3fault2.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 11:04:51 +00:00

fts3fault.test

Fix two problems that could cause fts3 auxiliary functions to occasionally misbehave if used with match expressions that contain both OR and NEAR.

2015-07-08 17:59:08 +00:00

fts3first.test

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

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

fts3join.test

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

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

fts3malloc.test

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

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

fts3matchinfo.test

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

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

fts3near.test

Make sure errors encountered while initializing extensions such as FTS4

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

fts3offsets.test

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

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

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

Add the fts3 matchinfo 'b' flag.

2015-05-05 20:39:53 +00:00

fts3rnd.test

Fix problems to do with using both OR and NEAR operators in a single expression.

2011-06-09 10:48:02 +00:00

fts3shared.test

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

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

fts3snippet.test

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

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

fts3sort.test

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

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

fts3tok1.test

Remove an incorrect assert() statement from sqlite3Fts3Dequote().

2015-04-15 09:16:39 +00:00

fts3tok_err.test

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

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

fts3varint.test

Fix a typo in fts3varint.test preventing the valgrind permutation test from running.

2013-12-03 17:09:53 +00:00

fts4aa.test

Add support for the extra parameter on the sqlite3_set_authorizer() callback

2014-09-11 13:44:52 +00:00

fts4check.test

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

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

fts4content.test

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

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

fts4docid.test

Have fts4 full-text queries consider "docid<?" and similar constraints.

2013-09-30 11:42:19 +00:00

fts4growth2.test

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

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

fts4growth.test

Update fts3/4 so that the 'merge=X,Y' command merges at least, instead of exactly, Y segments from a single level. This matches the documentation. 'merge=X,0' is, as it was in 3.11, an error.

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

fts4incr.test

Remove possibly stray output from various tests.

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

fts4langid.test

Update fts3/4 so that the 'merge=X,Y' command merges at least, instead of exactly, Y segments from a single level. This matches the documentation. 'merge=X,0' is, as it was in 3.11, an error.

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

fts4merge2.test

Add tests for incremental merge code.

2012-03-14 20:01:52 +00:00

fts4merge3.test

Update fts3/4 so that the 'merge=X,Y' command merges at least, instead of exactly, Y segments from a single level. This matches the documentation. 'merge=X,0' is, as it was in 3.11, an error.

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

fts4merge4.test

Fix a problem to do with loading the value of the FTS automerge setting from the database.

2014-05-14 18:45:27 +00:00

fts4merge.test

Update fts3/4 so that the 'merge=X,Y' command merges at least, instead of exactly, Y segments from a single level. This matches the documentation. 'merge=X,0' is, as it was in 3.11, an error.

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

fts4noti.test

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

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

fts4onepass.test

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

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

fts4opt.test

Fix a problem in fts3/4 that was causing it to discard data cached in-memory if an 'optimize' command is run when there is no data on disk. The usual way this would happen is if the very first transaction that writes to the fts3/4 table also includes an 'optimize' command.

2016-03-09 18:17:42 +00:00

fts4unicode.test

Adjust ICU tests to account for recent changes in the official

2015-06-15 16:40:38 +00:00

fts-9fd058691.test

Handle updating the only row of an FTS table correctly. Fix for [9fd058691].

2011-10-13 17:16:45 +00:00

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

…

func3.test

Updates to evidence marks and requirements. No changes to code.

2014-08-11 15:54:11 +00:00

func4.test

Standardize the error messages generated by constraint failures to a format

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

func5.test

Allow the SQLITE_DETERMINISTIC flag to be ORed into the preferred text encoding

2013-12-14 13:44:22 +00:00

func.test

Make sure the group_concat() function returns an empty string, not a NULL,

2014-05-07 17:19:31 +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

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

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

fuzz_common.tcl

…

fuzz_malloc.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

fuzz-oss1.test

Increase the version number to 3.7.12.1. Minor changes to test scripts.

2012-05-21 22:45:35 +00:00

fuzz.test

Fix a broken test case in fuzz.test.

2014-05-02 14:54:56 +00:00

fuzzcheck.c

Avoid calling realloc() with a zero size in fuzzcheck.c.

2016-03-23 17:54:19 +00:00

fuzzdata1.db

Update the fuzztest data using the latest test vectors discovered by AFL.

2015-06-20 14:11:56 +00:00

fuzzdata2.db

The "make fuzztest" target now uses fuzzcheck instead of fuzzershell.

2015-05-26 18:15:08 +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

Capture AFL-generated fuzz tests for json1.c into the test/fuzzdata4.db file.

2015-09-23 11:59:50 +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

Update 'fuzzerfault' test for its new module loading command. Fix several test names in 'io.test' and make sure the database gets closed between tests.

2013-04-29 07:01:23 +00:00

genesis.tcl

Fix memory leaks in the amatch extension. Add a few simple test cases.

2013-09-30 17:37:15 +00:00

hexlit.test

Add a test case for the fix of check-in [19d9f9ce691963310]

2015-11-24 03:50:16 +00:00

hidden.test

Fix a problem with VACUUM and __hidden__ columns.

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

hook.test

Merge recent enhancements from trunk.

2016-01-20 11:33:37 +00:00

icu.test

Fix a potential buffer overflow in the ICU upper() function.

2016-02-26 21:20:57 +00:00

ieee754.test

Fix the ieee754.test module so that it works both on systems that report

2015-12-31 22:29:36 +00:00

imposter1.test

Change SQLITE_TESTCTRL_INITMODE to SQLITE_TESTCTRL_IMPOSTER. Revise the order

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

in2.test

…

in3.test

…

in4.test

Enhancements to the code generator for the IN operator that result in much

2014-08-02 21:03:33 +00:00

in5.test

Add another test case for bug [5e3c8867].

2016-03-09 15:14:54 +00:00

in.test

Test that the left and right sides of a compound SELECT operator have the same number of expressions in the expanded expression list before beginning to generate code.

2015-06-23 12:19:55 +00:00

incrblob2.test

Fix an incrblob2 test case so that it works on 32-bit systems.

2015-03-10 15:34:47 +00:00

incrblob3.test

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

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

incrblob4.test

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

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

incrblob_err.test

Many test cases fixed to work with encryption.

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

incrblob.test

Many more test cases fixed. Only a few remain.

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

incrblobfault.test

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

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

incrcorrupt.test

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

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

incrvacuum2.test

First small steps toward brining trunk and apple-osx closer together.

2015-02-19 00:29:11 +00:00

incrvacuum3.test

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

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

incrvacuum_ioerr.test

Fix a problem in incrvacuum_ioerr.test. Do not run ioerr6.test with an in-memory journal.

2013-03-06 11:44:57 +00:00

incrvacuum.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

index2.test

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

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

index3.test

If a table-constraint PRIMARY KEY lists a single column in single-quotes and

2015-11-01 21:19:13 +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

Enhance the query planner so that it is able to use partial indexes that use

2015-08-07 20:57:00 +00:00

index7.test

Fix an incorrect assert() statement in the CREATE INDEX code generator.

2015-04-18 17:43:29 +00:00

index.test

Add code to maintain indexes with expression arguments across DELETE, INSERT,

2015-08-25 16:57:52 +00:00

indexedby.test

Experimental change to use a single-pass approach for DELETE statements on non-virtual tables that do not fire triggers or require foriegn-key processing.

2015-09-12 19:26:11 +00:00

indexexpr1.test

Ensure that the Expr objects that describe indexed expressions are not modified

2015-12-21 15:22:13 +00:00

indexfault.test

Add the SQLITE_OMIT_MERGE_SORT pre-processor directive. To omit the code in vdbesort.c.

2011-08-12 15:02:00 +00:00

init.test

…

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

…

insert4.test

Fix a broken assert() and comparison for INSERT INTO ... SELECT when the

2015-04-19 22:41:22 +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

Make sure sufficient VDBE registers are allocated for an INSERT...SELECT

2014-05-23 11:48:57 +00:00

instr.test

Additional test cases and requirements marks for the unlikely(),

2013-10-11 16:35:49 +00:00

intarray.test

…

interrupt.test

Veryquick passes all tests now.

2012-12-08 03:34:04 +00:00

intpkey.test

Fix the query planner so that it is able to use the integer primary key

2016-03-16 18:26:54 +00:00

io.test

Many more test cases fixed. Only a few remain.

2016-03-14 18:34:42 +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

…

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

…

ioerr6.test

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

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

ioerr.test

Update a few test cases to account for the new error message formats.

2013-11-28 19:28:00 +00:00

join2.test

…

join3.test

…

join4.test

…

join5.test

Do not apply the WHERE-clause pushdown optimization to terms that originate

2015-08-22 01:32:29 +00:00

join6.test

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

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

join.test

If a query contains "FROM t1 LEFT JOIN t2, t3, t4", ensure that tables t3 and t4 are not scanned before t2. The trunk already does this.

2015-06-08 18:48:29 +00:00

journal1.test

Fix all known instances of 'repeated the' style typos in comments. No changes to code.

2012-08-25 10:01:29 +00:00

journal2.test

Change the name ZERO_DAMAGE to the more descriptive POWERSAFE_OVERWRITE.

2011-12-23 01:04:17 +00:00

journal3.test

On unix, ignore the umask when creating journal files. That way, journal files

2012-02-13 20:16:37 +00:00

jrnlmode2.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

jrnlmode3.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

jrnlmode.test

Remove a couple stray test breakpoint calls.

2015-05-08 00:58:39 +00:00

json101.test

Escape control characters in JSON.

2016-02-04 10:28:57 +00:00

json102.test

Json1 tests are working. Builds without FTS5 enabled. Still some problems

2015-10-08 23:37:00 +00:00

json103.test

A different way to clear the subtype on VDBE registers when the value of the register is overwritten with new content. To fix [[f45ac567eaa9f93].

2016-01-30 15:46:03 +00:00

keyword1.test

Add tests that verify that keywords WITH, WITHOUT, and RECURSIVE can still

2014-01-17 16:19:01 +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

…

like2.test

…

like3.test

Add the SQLITE_LIKE_DOESNT_MATCH_BLOBS compile-time option.

2015-12-01 21:23:07 +00:00

like.test

Case folding in the LIKE operator should look at all bits of the character,

2016-01-20 14:22:41 +00:00

limit.test

New requirements marks on compound SELECT statements.

2015-03-05 01:29:51 +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

Enhance testing support for the Win32 VFS dynamic extension loading facilities.

2014-02-24 21:20:25 +00:00

lock2.test

…

lock3.test

…

lock4.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

lock5.test

Fix a problem causing lock5.test to fail in mmap-mode.

2014-10-15 14:45:34 +00:00

lock6.test

…

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

Add a test for the change on this branch.

2015-03-17 16:01:29 +00:00

lock.test

New requirements marks and a few new test cases to go with them. No changes

2015-02-27 20:28:08 +00:00

lookaside.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

main.test

Avoid a potential buffer overrun if an SQL statement being parsed ends

2016-02-18 14:49:28 +00:00

make-where7.tcl

…

malloc3.test

Many spelling fixes in comments. No changes to code.

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

malloc4.test

…

malloc5.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

malloc6.test

…

malloc7.test

…

malloc8.test

…

malloc9.test

…

malloc_common.tcl

Further test coverage improvements for fts5.

2015-05-16 20:04:43 +00:00

malloc.test

Fix an obscure memory leak that could follow an OOM in where.c.

2015-04-25 12:20:24 +00:00

mallocA.test

Remove some temporary code in mallocA.test that was accidentally checked in.

2014-10-08 11:11:24 +00:00

mallocAll.test

…

mallocB.test

…

mallocC.test

…

mallocD.test

…

mallocE.test

…

mallocF.test

…

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

…

mallocI.test

…

mallocJ.test

…

mallocK.test

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

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

mallocL.test

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

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

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

…

memdb.test

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

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

memleak.test

…

memsubsys1.test

Larger margins for one memsubsys1 range check when running with a

2016-03-24 15:32:19 +00:00

memsubsys2.test

Fix a test script problem in memsubsys2.test.

2015-07-25 12:03:57 +00:00

minmax2.test

Add an optimization that attempts to run a subquery as a coroutine rather

2012-10-30 00:29:07 +00:00

minmax3.test

…

minmax4.test

Do not flatten aggregate subqueries that contain min() or max() functions

2014-09-15 14:46:02 +00:00

minmax.test

Attempt to further generalize the min/max optimization so that, if an appropriate index exists, it can be used by any aggregate query that contains only a single aggregate of the form max(colname) or min(colname) and does not contain a GROUP BY clause.

2012-12-13 16:37:10 +00:00

misc1.test

Avoid a potential buffer overrun if an SQL statement being parsed ends

2016-02-18 14:49:28 +00:00

misc2.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

misc3.test

In the P4 column of the EXPLAIN listing, abbreviate "keyinfo" as just "k" and

2013-10-30 13:46:01 +00:00

misc4.test

Make a hard copy of the results of a subquery lest the result of the

2015-05-18 04:24:27 +00:00

misc5.test

Silently ignore parser stack overflow when parsing a malformed schema in

2015-04-19 22:31:45 +00:00

misc6.test

…

misc7.test

Modifications to test files to omit any tests that intentionally access out-of-bounds locations in clang -fsanitize=address builds.

2014-01-23 14:44:08 +00:00

misc8.test

Ephemeral tables used to hold manifested views may not be unordered since

2016-02-26 04:13:39 +00:00

misuse.test

Modifications to test files to omit any tests that intentionally access out-of-bounds locations in clang -fsanitize=address builds.

2014-01-23 14:44:08 +00:00

mmap1.test

Many more test cases fixed. Only a few remain.

2016-03-14 18:34:42 +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

mmapfault.test

Make sure errors encountered while initializing extensions such as FTS4

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

multiplex2.test

Add a hard limit to the number of chunks a multiplexed database may consist of if ENABLE_8_3_NAMES is defined.

2011-12-13 19:03:34 +00:00

multiplex3.test

Fix a case where an error code was being overwritten in multiplexDelete().

2012-02-28 11:52:12 +00:00

multiplex4.test

Clearification of some documentation text. Added requirements marks.

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

multiplex.test

Add a missing call to "test_sqlite3_log" to multiplex.test.

2014-07-31 18:14:37 +00:00

mutex1.test

Fix more test-case errors in the Apple configuration.

2016-03-18 00:19:48 +00:00

mutex2.test

…

nan.test

Many more test cases fixed. Only a few remain.

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

nolock.test

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

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

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

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

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

notnull.test

Standardize the error messages generated by constraint failures to a format

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

null.test

Do not assume an index contains unique entries unless it is declared UNIQUE and NOT NULL is specified for all columns. Fix for [7b4fee9f6c].

2015-04-11 11:44:27 +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 the LIMIT and OFFSET handling for UNION ALL queries that contain a

2015-10-06 17:27:18 +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

orderby1.test

When the [https://www.sqlite.org/queryplanner.html#partialsort|block sorting optimization]

2016-01-13 17:50:10 +00:00

orderby2.test

Update the query planner to recognize more cases where ORDER BY clauses

2012-10-03 12:56:18 +00:00

orderby3.test

Fix the date on the new orderby3.test test case.

2013-01-09 11:27:48 +00:00

orderby4.test

A fix an test-case for the ORDER BY problem identified by ticket [a179fe7465].

2013-03-27 15:04:28 +00:00

orderby5.test

Fix an sqlite3_stmt_status() problem caused by recent changs on this branch.

2014-04-26 20:21:14 +00:00

orderby6.test

New test case for block-sorting.

2014-03-21 15:24:07 +00:00

orderby7.test

Add test cases to ensure correct operation of joins with a virtual table

2014-04-25 17:37:16 +00:00

orderby8.test

There are asserts in place now that will prevent a recurrence of

2015-01-19 21:10:53 +00:00

orderby9.test

Fix the orderby9.test case so that it works with 32-bit versions of TCL

2015-09-18 14:42:48 +00:00

oserror.test

Only use lstat() if the HAVE_LSTAT macro is defined. Fix some test file issues.

2016-01-25 18:43:05 +00:00

ovfl.test

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

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

pager1.test

Changing page size using VACUUM or backup is not allowed with a codec attached.

2016-03-14 20:49:24 +00:00

pager2.test

Add tests to "permutations.test coverage-pager" to cover uncovered branches.

2013-04-06 11:03:09 +00:00

pager3.test

…

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

Fix a problem in pagerfault.test causing an assert() to fail.

2014-01-27 14:19:22 +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

Fix a faulty assert() in the btree part of the "PRAGMA page_size = ?" code.

2015-05-05 10:03:08 +00:00

parser1.test

Enhances the parser so that it accepts arbitrary expressions for the arguments

2015-08-24 20:21:20 +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

percentile.test

Fix a floating-point round-off error problem in the percentile.test module.

2014-12-31 20:19:20 +00:00

permutations.test

Merge all recent enhancements from trunk.

2016-03-16 01:16:30 +00:00

pragma2.test

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

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

pragma3.test

Many more test cases fixed. Only a few remain.

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

pragma.test

Many more test cases fixed. Only a few remain.

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

printf2.test

Fix a faulty assert() in the sqlite3StrAccumAppend() routine.

2015-04-15 05:38:35 +00:00

printf.test

Avoid signed integer overflow when converting oversized in-line integer

2015-04-07 15:39:29 +00:00

progress.test

More test output refinements.

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

ptrchng.test

…

queryonly.test

Add the experimental "query_only" pragma.

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

quick.test

…

quota2.test

Fix test issues for Windows portability.

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

quota-glob.test

Documentation improvements and additional test cases.

2011-12-02 15:27:41 +00:00

quota.test

Make sure the "bak.db" database file does not actually exist before

2016-02-05 17:49:43 +00:00

quote.test

…

randexpr1.tcl

…

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

regexp1.test

Make "test_regexp.c" into a loadable extension and move it over to

2013-04-23 20:10:13 +00:00

regexp2.test

Add an extra test case for the change in commit [c4295725].

2016-02-22 09:45:27 +00:00

reindex.test

…

releasetest.tcl

Fix harmless compiler warnings that arise with -DSQLITE_OMIT_LOAD_EXTENSION

2016-03-17 23:16:37 +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

rollback2.test

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

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

rollback.test

This is a cherry-pick of version [b5df5ac052].

2014-11-11 22:55:26 +00:00

rollbackfault.test

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

2016-02-05 16:46:09 +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

…

rowid.test

Merge the latest enhancements from trunk.

2015-08-31 14:27:29 +00:00

rtree.test

…

run-wordcount.sh

Modify wordcount so that timer information appears on standard error instead

2013-11-21 21:40:45 +00:00

savepoint2.test

…

savepoint4.test

…

savepoint5.test

…

savepoint6.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

savepoint7.test

Add test cases for ticket [7f7f8026eda387d544].

2016-04-07 21:14:35 +00:00

savepoint.test

This is a cherry-pick of version [b5df5ac052].

2014-11-11 22:55:26 +00:00

savepointfault.test

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

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

scanstatus.test

Deploy heuristics (well-commented) to better estimate how much unindexed terms

2014-11-22 18:50:44 +00:00

schema2.test

…

schema3.test

…

schema4.test

…

schema5.test

Standardize the error messages generated by constraint failures to a format

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

schema.test

…

securedel2.test

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

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

securedel.test

Make sure errors encountered while initializing extensions such as FTS4

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

select1.test

Fix a faulty assert() in sqlite3SelectNew().

2015-04-17 15:16:58 +00:00

select2.test

…

select3.test

…

select4.test

Implement FROM-clause subqueries as co-routines whenever they are guaranteed

2016-03-15 17:52:12 +00:00

select5.test

…

select6.test

Add test cases for the query flattener fix for

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

select7.test

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

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

select8.test

Remove possibly stray output from various tests.

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

select9.test

Make sure the schema is verified prior to processing a "WHERE 0" on the

2013-07-09 03:04:32 +00:00

selectA.test

Fix a problem with resolving ORDER BY clauses that feature COLLATE clauses attached to compound SELECT statements.

2015-04-04 16:43:16 +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

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

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

selectD.test

Make sure the affinity and datatype of sub-subqueries are initialized

2013-04-25 00:57:10 +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

Improved and more rigorous test of large VALUES clauses.

2015-01-06 16:53:49 +00:00

server1.test

The server1.test script should only run if mutexes are functional.

2011-08-31 19:40:58 +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

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

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

2016-02-05 16:46:09 +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

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

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

shared9.test

Add a test case that demonstrates ticket [71e333e7d2e642].

2012-12-06 15:15:15 +00:00

shared_err.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

shared.test

Fix a problem preventing a shared in-memory database from being attached to a read-only connection.

2012-06-07 17:16:04 +00:00

sharedA.test

Fix the sharedA.test module so that it does not attempt to run TCL callbacks

2013-05-15 16:08:33 +00:00

sharedB.test

Improved comment on the sharedB.test test script.

2014-12-05 14:34:30 +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

Improve error messages from the 'shell1-5.0' test.

2016-04-04 17:59:37 +00:00

shell2.test

More changes to the shellN.test scripts to get them working on all variations

2016-03-26 15:36:36 +00:00

shell3.test

More changes to the shellN.test scripts to get them working on all variations

2016-03-26 15:36:36 +00:00

shell4.test

Fix the shellN.test test scripts so that they work with the --testdir option.

2016-03-15 09:55:44 +00:00

shell5.test

Fix the shellN.test test scripts so that they work with the --testdir option.

2016-03-15 09:55:44 +00:00

shortread1.test

…

show_speedtest1_rtree.tcl

Add the sqlite3_rtree_query_callback() API to the RTree virtual table.

2014-04-28 17:56:19 +00:00

shrink.test

Disable the page cache bulk allocation for the shrink.test and wal.test

2015-07-25 03:10:12 +00:00

sidedelete.test

…

skipscan1.test

The sqlite3ExprCodeGetColumn() is not guaranteed to put the result in the

2015-07-23 16:39:33 +00:00

skipscan2.test

Changes to the output of EXPLAIN QUERY PLAN to make it clearer when a query uses the PRIMARY KEY index of a WITHOUT ROWID table.

2014-05-23 17:17:06 +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

Adjust skip-scan cost estimates slightly so that a full table scan is

2014-09-23 01:40:59 +00:00

skipscan6.test

Add a test case to check that the previous commit is effective.

2014-11-05 14:19:05 +00:00

snapshot_fault.test

Fix some test scripts so that they work with various permutations.

2016-03-24 15:09:14 +00:00

snapshot.test

Fix some test scripts so that they work with various permutations.

2016-03-24 15:09:14 +00:00

soak.test

…

softheap1.test

More test cases and requirements marks for pragmas.

2015-02-28 01:04:27 +00:00

sort2.test

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

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

sort3.test

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

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

sort4.test

Clearification of some documentation text. Added requirements marks.

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

sort5.test

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

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

sort.test

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

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

sortfault.test

Add the SQLITE_CONFIG_PMASZ start-time option.

2015-01-02 15:55:29 +00:00

speed1.test

…

speed1p.explain

…

speed1p.test

Add test cases for errors in mmap() or mremap() is os_unix.c.

2013-04-02 12:04:09 +00:00

speed2.test

…

speed3.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

speed4.test

…

speed4p.explain

…

speed4p.test

…

speedtest1.c

Improvements to the performance testing program "speedtest1.c" and the

2016-03-30 12:20:24 +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

spellfix.test

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

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

sqldiff1.test

Fix test scripts sqldiff.test and rbudiff.test so that they work with the --testdir option.

2016-03-19 14:53:36 +00:00

sqllimits1.test

Fix an obscure memory leak found by libfuzzer that may occur under some circumstances if expanding a "*" expression causes a SELECT to return more than 32767 columns.

2015-11-21 19:43:29 +00:00

sqllog.test

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

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

stat.test

Many more test cases fixed. Only a few remain.

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

statfault.test

Add fault-injection tests for the code in test_stat.c.

2015-04-27 19:53:55 +00:00

stmt.test

Update test cases to taken deferred statement-journal opening into account.

2016-03-04 14:23:10 +00:00

subquery2.test

Add test cases for ticket [89398880bcfff9].

2014-09-21 20:31:26 +00:00

subquery.test

Make sure the datatype and collating sequence of transients tables are

2015-04-21 17:07:01 +00:00

subselect.test

…

substr.test

…

subtype1.test

Experimental implementation of sqlite3_result_subtype() and

2015-09-10 20:34:56 +00:00

superlock.test

Changing page size using VACUUM or backup is not allowed with a codec attached.

2016-03-14 20:49:24 +00:00

symlink.test

Ensure that unixFullpathname() always nul-terminates its output buffer, even when returning an error.

2016-01-26 13:56:42 +00:00

sync.test

Refinements to synchronous logic:

2016-02-04 09:48:12 +00:00

syscall.test

Only use lstat() if the HAVE_LSTAT macro is defined. Fix some test file issues.

2016-01-25 18:43:05 +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

Attempt to treat the arguments to a table-valued function as if they occur

2016-04-08 21:35:34 +00:00

table.test

When running a CREATE TABLE AS, make the initial temporary sqlite_master entry

2015-09-09 13:28:06 +00:00

tableapi.test

Fix problem with tableapi.test on Windows.

2011-03-24 17:37:24 +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

Merge all recent enhancements from trunk.

2016-03-16 01:16:30 +00:00

tempdb.test

Update test cases to taken deferred statement-journal opening into account.

2016-03-04 14:23:10 +00:00

temptable.test

Many spelling fixes in comments. No changes to code.

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

temptrigger.test

Fix a test case in temptrigger.test so that it works in auto-vacuum mode.

2013-11-28 06:17:56 +00:00

tester.tcl

Remove the catchcmd_collapse_space procedure in tester.tcl - no longer needed.

2016-03-26 14:41:13 +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

thread001.test

Modify a query in test/thread001.test to ensure that results are returned in the order expected by the test.

2012-12-05 16:44:13 +00:00

thread002.test

Enable the thread test logic to work with the SQLITE_HAS_CODEC compile-time

2011-08-30 19:52:32 +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

…

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

Do not run multi-threaded Tcl tests if the library was built with SQLITE_MUTEX_NOOP defined.

2011-04-07 10:09:00 +00:00

threadtest1.c

…

threadtest2.c

Fix some problems in test code detected by cppcheck.

2015-08-05 08:01:46 +00:00

threadtest3.c

Fix an incorrect VFS version number check in the threadtest3.c test program.

2016-01-19 21:36:26 +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

tkt35xx.test

Standardize the error messages generated by constraint failures to a format

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

tkt1435.test

…

tkt1443.test

…

tkt1444.test

…

tkt1449.test

…

tkt1473.test

…

tkt1501.test

…

tkt1512.test

…

tkt1514.test

…

tkt1536.test

…

tkt1537.test

…

tkt1567.test

Standardize the error messages generated by constraint failures to a format

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

tkt1644.test

…

tkt1667.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

tkt1873.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

tkt2141.test

…

tkt2192.test

…

tkt2213.test

…

tkt2251.test

…

tkt2285.test

…

tkt2332.test

…

tkt2339.test

…

tkt2391.test

…

tkt2409.test

Many spelling fixes in comments. No changes to code.

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

tkt2450.test

…

tkt2565.test

…

tkt2640.test

…

tkt2643.test

…

tkt2686.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

tkt2767.test

…

tkt2817.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

tkt2820.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

tkt2822.test

Bare identifiers in ORDER BY clauses bind more tightly to output column name,

2013-08-15 20:24:27 +00:00

tkt2832.test

…

tkt2854.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

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

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

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

tkt3457.test

Remove superfluous text from a comment.

2013-01-04 22:26:47 +00:00

tkt3461.test

…

tkt3493.test

…

tkt3508.test

…

tkt3522.test

…

tkt3527.test

Add an optimization that attempts to run a subquery as a coroutine rather

2012-10-30 00:29:07 +00:00

tkt3541.test

…

tkt3554.test

…

tkt3581.test

…

tkt3630.test

…

tkt3718.test

…

tkt3731.test

…

tkt3757.test

…

tkt3761.test

…

tkt3762.test

If a rollback mode transaction reduces the size of the database file, avoid actually truncating the file until after the transaction has been committed (but before the db has been unlocked). This means pages that are removed from the database by truncating the file need not be journalled.

2013-02-23 16:40:46 +00:00

tkt3773.test

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

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

tkt3791.test

…

tkt3793.test

Added the tool/warnings-clang.sh script. Changes so that there are no

2011-10-15 00:16:30 +00:00

tkt3810.test

…

tkt3824.test

…

tkt3832.test

…

tkt3838.test

Fix ALTER TABLE RENAME so that it correctly handles triggers that attach

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

tkt3841.test

…

tkt3871.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

tkt3879.test

…

tkt3911.test

…

tkt3918.test

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

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

tkt3922.test

Changes to various test scripts so that they pass on windows.

2011-05-05 19:44:22 +00:00

tkt3929.test

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

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

tkt3935.test

…

tkt3992.test

…

tkt3997.test

…

tkt4018.test

Many more test cases fixed. Only a few remain.

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

tkt-2a5629202f.test

"make test" now passing.

2013-06-12 17:08:06 +00:00

tkt-2d1a5c67d.test

Make test_wholenumber.c into a loadable extension and move it to

2013-04-25 11:58:36 +00:00

tkt-2ea2425d34.test

…

tkt-3a77c9714e.test

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

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

tkt-3fe897352e.test

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

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

tkt-4a03edc4c8.test

Standardize the error messages generated by constraint failures to a format

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

tkt-4c86b126f2.test

Make sure that virtual WHERE-clause terms do not get transformed into real

2014-02-11 01:50:29 +00:00

tkt-4dd95f6943.test

Enhance tests for ticket [4dd95f6943].

2013-03-13 07:02:04 +00:00

tkt-4ef7e3cfca.test

Fix comment in test.

2014-03-04 12:07:24 +00:00

tkt-5d863f876e.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

tkt-5e10420e8d.test

…

tkt-5ee23731f.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

tkt-6bfb98dfc0.test

Candidate fix for ticket [6bfb98dfc0c]: Make sure invalid cursors drop all

2013-03-27 03:15:23 +00:00

tkt-7a31705a7e6.test

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

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

tkt-7bbfb7d442.test

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

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

tkt-8c63ff0ec.test

Do not allow temporary registers to be in use across an OP_Yield within a

2014-02-25 21:55:16 +00:00

tkt-9a8b09f8e6.test

Add some more IN operator tests.

2014-06-26 22:17:21 +00:00

tkt-9d68c883.test

…

tkt-9f2eb3abac.test

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

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

tkt-02a8e81d44.test

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

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

tkt-26ff0c2d1e.test

…

tkt-38cb5df375.test

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

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

tkt-78e04e52ea.test

Standardize the error messages generated by constraint failures to a format

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

tkt-80ba201079.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

tkt-80e031a00f.test

Enhancements to the code generator for the IN operator that result in much

2014-08-02 21:03:33 +00:00

tkt-91e2e8ba6f.test

Add a test for ticket [91e2e8ba6f]. No changes to code.

2011-06-23 16:40:26 +00:00

tkt-94c04eaadb.test

Make sure errors encountered while initializing extensions such as FTS4

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

tkt-385a5b56b9.test

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

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

tkt-752e1646fc.test

…

tkt-8454a207b9.test

…

tkt-31338dca7e.test

Add an optimization that attempts to run a subquery as a coroutine rather

2012-10-30 00:29:07 +00:00

tkt-54844eea3f.test

Fix for [54844eea3f]: Do not create automatic indexes on correlated sub-queries.

2011-07-08 16:10:54 +00:00

tkt-313723c356.test

…

tkt-868145d012.test

Add a missing test that prevented double LEFT JOINs with transitive

2013-07-01 17:27:19 +00:00

tkt-3998683a16.test

…

tkt-a7b7803e.test

A couple more test cases.

2012-12-19 16:32:33 +00:00

tkt-a8a0d2996a.test

Fix arithmetic operators so that they do not change the affinity of their

2014-03-24 15:00:15 +00:00

tkt-b1d3a2e531.test

Standardize the error messages generated by constraint failures to a format

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

tkt-b75a9ca6b0.test

Comment tweaks on the test case for the [b75a9ca6b0] bug fix.

2014-04-21 13:36:54 +00:00

tkt-b351d95f9.test

…

tkt-b72787b1.test

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

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

tkt-ba7cbfaedc.test

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

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

tkt-bd484a090c.test

Change the error message returned when localtime_r() fails to "local time unavailable".

2011-06-21 13:46:11 +00:00

tkt-bdc6bbbb38.test

Before running each test script, make sure the FTS enhanced query syntax is disabled.

2012-05-12 05:30:29 +00:00

tkt-c48d99d690.test

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

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

tkt-cbd054fa6b.test

If ENABLE_STAT3 is defined but ENABLE_STAT4 is not, have ANALYZE create and populate the sqlite_stat3 table instead of sqlite_stat4.

2013-08-12 20:14:04 +00:00

tkt-d11f09d36e.test

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

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

tkt-d82e3f3721.test

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

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

tkt-d635236375.test

Update the OP_Move opcode to shift the pScopyFrom pointer of aliases when

2011-08-03 16:40:15 +00:00

tkt-f3e5abed55.test

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

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

tkt-f7b4edec.test

…

tkt-f67b41381a.test

Allow the xfer optimization to proceed if the DEFAULT on the very first

2014-04-26 17:52:08 +00:00

tkt-f973c7ac31.test

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

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

tkt-f777251dc7a.test

This is a cherry-pick of version [b5df5ac052].

2014-11-11 22:55:26 +00:00

tkt-fa7bf5ec.test

Make sure the query optimizer for aggregate queries knows that expressions

2011-10-13 15:35:52 +00:00

tkt-fc7bd6358f.test

Fix a bug (ticket [fc7bd6358f59]) that caused incorrect query results in

2013-03-06 01:55:27 +00:00

tkt-fc62af4523.test

…

tokenize.test

…

tpch01.test

Allow an automatic index on a WHERE constraint where the RHS is does not

2014-06-17 09:00:54 +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

trace.test

Always invoke the profile callback even if the statement does not run to

2015-07-14 14:48:50 +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

This is a cherry-pick of version [b5df5ac052].

2014-11-11 22:55:26 +00:00

trans.test

…

transitive1.test

Refinements to the determination of when an A==B term is an equivalence.

2015-05-18 11:34:52 +00:00

trigger1.test

Ensure that when the VM applies TEXT affinity to a value it discards any existing REAL or INTEGER value.

2015-05-19 19:44:25 +00:00

trigger2.test

Standardize the error messages generated by constraint failures to a format

2013-11-05 13:33:55 +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

…

trigger6.test

…

trigger7.test

Add support for the SQLITE_SQLLOG_CONDITIONAL environment variable to the logging code in test_sqllog.c. When defined, logging is only performed if the "<database>-sqllog" file is present in the file system when the main database is opened.

2015-11-12 20:12:51 +00:00

trigger8.test

…

trigger9.test

Fix problems with running UPDATE and DELETE against a VIEW and referencing

2014-10-29 01:26:25 +00:00

triggerA.test

Add a test case for the problem fixed by the previous commit.

2013-03-09 14:49:07 +00:00

triggerB.test

…

triggerC.test

Ensure that tables names are dequoted exactly once by the trigger logic.

2015-04-21 16:38:49 +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

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

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

tt3_checkpoint.c

Update the threadtest3 test program so that its output summary is

2014-12-30 19:26:07 +00:00

tt3_index.c

Further enhancements to threadtest3 stress tests.

2014-12-13 17:41:48 +00:00

tt3_lookaside1.c

Further enhancements to threadtest3 stress tests.

2014-12-13 17:41:48 +00:00

tt3_stress.c

Changes to threadtest3 so that "stress2" is more similar to the SDS stress test.

2014-12-15 20:49:26 +00:00

tt3_vacuum.c

Further enhancements to threadtest3 stress tests.

2014-12-13 17:41:48 +00:00

types2.test

…

types3.test

Change a test case in types3.test slightly so that it works with the latest versions of Tcl.

2011-06-22 10:56:54 +00:00

types.test

…

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

If SQLITE_DEFAULT_WAL_SYNCHRONOUS is not the same value as

2016-03-08 15:14:26 +00:00

unordered.test

Update unordered.test to take into account for the fact that SQLite now prefers a full-table scan over a non-covering index scan that visits a large percentage of the table rows.

2014-04-28 15:11:25 +00:00

update.test

In the OP_Column opcode, when extracting a field that is past the end of

2014-10-29 01:13:58 +00:00

uri.test

Fix a typo in the previous check-in.

2015-10-07 04:20:34 +00:00

userauth01.test

Enhance the sqlite3_user_add() interface to initialize the user

2014-09-11 16:19:31 +00:00

utf16align.test

…

vacuum2.test

Test that if the definition of a collation sequence is changed and VACUUM run, the new database contains records sorted in the (new) correct order.

2015-04-13 14:08:27 +00:00

vacuum3.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

vacuum4.test

…

vacuum.test

Disable the xfer optimization if "PRAGMA count_changes=1" is configured. Ticket [c48d99d690].

2011-09-30 12:01:01 +00:00

varint.test

…

veryquick.test

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

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

view.test

Carry table column types through into VIEW definitions, where possible.

2016-04-05 20:59:12 +00:00

vtab1.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

vtab2.test

A few more test cases for the IS operator.

2015-05-14 14:03:21 +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

…

vtab6.test

Simplified error detection in the xBestIndex processing.

2016-03-08 02:59:33 +00:00

vtab7.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

vtab8.test

…

vtab9.test

…

vtab_alter.test

…

vtab_err.test

…

vtab_shared.test

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

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

vtabA.test

Bring comments on the INSERT code generator up-to-date. Fix the INSERT code

2015-04-19 18:32:43 +00:00

vtabB.test

…

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

vtabE.test

Add further tests and related fixes for GLOB/REGEXP/LIKE support in virtual tables.

2015-11-24 17:39:01 +00:00

vtabF.test

Make sure IS NOT NULL constraints work on virtual tables.

2011-08-02 01:57:39 +00:00

vtabH.test

Fix test file vtabH.test so that it works with SQLITE_ENABLE_ICU builds.

2016-01-08 08:35:14 +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

wal2.test

Fix some test cases so that they work under the Apple configuration.

2016-03-17 23:56:23 +00:00

wal3.test

Fix some test cases so that they work under the Apple configuration.

2016-03-17 23:56:23 +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

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

2016-02-05 16:46:09 +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

Disable the wal64k.test script for non-unix systems since it depends on

2014-03-28 14:41:35 +00:00

wal_common.tcl

…

wal.test

Many more test cases fixed. Only a few remain.

2016-03-14 18:34:42 +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

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

2016-02-04 17:31:03 +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

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

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

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

walfault.test

Make sure errors encountered while initializing extensions such as FTS4

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

walhook.test

…

walmode.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

walnoshm.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

waloverwrite.test

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

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

walpersist.test

Add code for a test that was failing before the persistent-wal related changes of [9ccc4a1be].

2011-12-16 17:01:04 +00:00

walprotocol.test

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

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

walro.test

Many more test cases fixed. Only a few remain.

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

walshared.test

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

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

walslow.test

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

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

walthread.test

Fix a bug in walthread.test causing intermittent failures.

2012-08-07 13:55:41 +00:00

where2.test

When optimizing expressions of the form "x IN (SELECT ...)" make sure that

2016-03-09 15:09:22 +00:00

where3.test

Changes to the way the planner calculates the costs of various table and index scans. Some test cases still failing.

2014-04-24 20:04:49 +00:00

where4.test

Improvements and simplifications to the equality seek logic. Tests are

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

where5.test

…

where6.test

…

where7.test

Add a test case of the form "WHERE a<2 OR a<3" using PRAGMA count_changes.

2015-12-08 04:18:33 +00:00

where8.test

Add the SQLITE_LIKE_DOESNT_MATCH_BLOBS compile-time option.

2015-12-01 21:23:07 +00:00

where9.test

Fix where9.test so that it works with the "no_optimization" permutation.

2014-08-12 20:13:22 +00:00

where.test

Remove a debuggin "exit" command mistakenly left in the "where.test" module.

2016-02-26 04:04:07 +00:00

whereA.test

Ignore IS NOT NULL and NOT NULL constraints on NOT NULL columns.

2013-08-20 17:00:55 +00:00

whereB.test

…

whereC.test

Simplified implementation of indexing with the IS operator.

2015-05-13 19:33:41 +00:00

whereD.test

Add tests for the change on this branch.

2016-01-29 21:16:13 +00:00

whereE.test

Fixes to EXPLAIN QUERY PLAN output. Change weights back to something closer

2013-06-11 02:32:50 +00:00

whereF.test

If the cost of two whereLoop objects is the same in every way except that

2013-08-30 17:35:44 +00:00

wherefault.test

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

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

whereG.test

Make sure that the likelihood() function does not mess up generation of

2015-06-20 13:18:34 +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

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

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

whereJ.test

Performance enhancement for single-table queries with many OR-connected

2014-12-04 20:24:50 +00:00

whereK.test

Extend [52e73eec] so that the IS optimization may be used on primary keys with more than 3 columns.

2015-03-25 15:23:00 +00:00

wherelimit.test

…

wild001.test

Re-enable test file wild001.test.

2013-08-28 19:01:07 +00:00

win32heap.test

Add experimental sqlite3_config option to control the native Win32 heap size.

2013-11-23 00:27:29 +00:00

win32lock.test

Revise Win32 locking test to account for recent log message changes.

2015-03-26 18:24:26 +00:00

win32longpath.test

Correct the VFS name as reported by the file control when explicitly using the 'win32-longpath' VFS.

2013-12-09 21:48:49 +00:00

with1.test

Add a missing memAboutToChange() macro to vdbe.c, the lack of which was causing an assert() to fail incorrectly. Problem found by libfuzzer.

2015-12-14 19:42:19 +00:00

with2.test

Enhances the parser so that it accepts arbitrary expressions for the arguments

2015-08-24 20:21:20 +00:00

with3.test

Proposed fix for an infinite loop bug in the WITH clause semantic analysis

2015-11-07 17:48:21 +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

CTEs have never add working rowids. So disallow the use of the "rowid" column

2015-05-27 13:06:55 +00:00

without_rowid2.test

Many new test cases added, that mostly work. Currently 18 errors in

2013-11-02 22:09:48 +00:00

without_rowid3.test

Fix the xfer optimization for WITHOUT ROWID tables so that it correctly

2015-07-28 18:53:37 +00:00

without_rowid4.test

Standardize the error messages generated by constraint failures to a format

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

without_rowid5.test

Bug fix: the conflict resolution behavior for the implied NOT NULL constraint

2016-01-03 18:07:57 +00:00

without_rowid6.test

Do not allow rowid in a UNIQUE or PRIMARY KEY constraint. (This restores the

2015-09-19 03:07:30 +00:00

wordcount.c

Fix uses of ctype functions (ex: isspace()) on signed characters in test

2015-10-29 13:48:15 +00:00

zeroblob.test

Fix the zeroblob.test script so that it works even on builds where the

2015-07-24 23:28:05 +00:00

zerodamage.test

If SQLITE_DEFAULT_WAL_SYNCHRONOUS is not the same value as

2016-03-08 15:14:26 +00:00