drh d6ee353c84 If the keyword "unordered" appears at the end of the SQLITE_STAT1.STAT ...

column for an index, then use that index for equality lookups only, never
for range queries or sorting.

FossilOrigin-Name: 3b964155f611c437d53d44feafa22f531942b1b4

2011-03-29 15:00:17 +00:00

..

aggerror.test

Faster :memory: database COMMITs. Ticket #1790. (CVS 3178)

2006-05-03 23:34:05 +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

Run some of the existing test scripts with optimizations disabled as part of all.test.

2010-12-07 14:32:28 +00:00

alter2.test

In the test scripts, changes instances of the TCL interface

2010-09-06 20:28:28 +00:00

alter3.test

In the test scripts, changes instances of the TCL interface

2010-09-06 20:28:28 +00:00

alter4.test

In the test scripts, changes instances of the TCL interface

2010-09-06 20:28:28 +00:00

alter.test

When commands such as ALTER TABLE and VACUUM use SQL internally, make sure

2010-04-24 14:02:59 +00:00

altermalloc.test

Fix a crash that can follow a malloc failure in sqlite3ValueFromExpr(). Ticket #3468. (CVS 5851)

2008-10-30 17:21:12 +00:00

analyze2.test

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

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

analyze3.test

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

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

analyze4.test

Fix the ANALYZE command so that it takes collating sequences into account

2011-01-04 19:01:26 +00:00

analyze5.test

Enhances to the query planner such that "x IS NULL" constraints take the

2011-03-17 01:34:26 +00:00

analyze6.test

Do a better job of choosing the join table order when the tables having

2011-03-04 00:56:58 +00:00

analyze.test

Enhance the ANALYZE command so that it gathers statistics in the sqlite_stat1

2010-09-25 22:32:56 +00:00

async2.test

Tests for the new asynchronous IO API. (CVS 6549)

2009-04-25 08:39:14 +00:00

async3.test

Tests for the new asynchronous IO API. (CVS 6549)

2009-04-25 08:39:14 +00:00

async4.test

Some changes to test scripts related to codec enabled versions of sqlite.

2010-06-22 13:46:43 +00:00

async5.test

When the asynchronous IO backend opens a file with the EXCLUSIVE flag set, make sure only a single file-descriptor is opened (not one for reading and one for writing). This change fixes #3978. (CVS 6905)

2009-07-18 11:52:04 +00:00

async.test

Fix problems with running the async.test script.

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

attach2.test

Change all instances of "it's" in comments to either "its" or "it is",

2007-12-13 21:54:09 +00:00

attach3.test

Change "PRAGMA disable_recursive_triggers" to "PRAGMA recursive_triggers". Also a fix for compiling with OMIT_TRIGGER defined.

2009-09-01 17:11:07 +00:00

attach.test

Increase the upper bound on SQLITE_MAX_ATTACHED from 30 to 62.

2011-03-23 18:22:34 +00:00

attachmalloc.test

Updates for Windows.

2010-11-04 20:46:09 +00:00

auth2.test

Make sure internal queries are well ordered, even when the

2010-01-12 23:54:14 +00:00

auth3.test

Work toward cleaning up the authorizer interface. Work is on-going. This

2009-05-04 01:58:31 +00:00

auth.test

Fix the ATTACH command so that the filename argument can be any expression

2011-02-04 00:51:16 +00:00

autoinc.test

Fix compilation with OMIT_TRIGGER defined. Ticket [1ff6d29030e9757d052af0f394e56bea96b8b59b|1ff6d29030].

2009-09-21 16:06:03 +00:00

autoindex1.test

Use the estimated number of rows computed for subqueries in the cost

2010-11-16 02:49:15 +00:00

autovacuum_ioerr2.test

Remove leftover debugging commands (breakpoint and btree_breakpoint) from

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

autovacuum.test

Changes to test scripts so that the "inmemory_journal" permutation works with [ef126e775a].

2010-07-08 09:44:42 +00:00

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

backcompat.test

Add tests for fts3 to backcompat.test.

2010-12-03 15:04:26 +00:00

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

backup_ioerr.test

Increase the error tolerance when verifying the approximate size of a pseudo-random database in backup_ioerr.test. Otherwise the test could fail depending on the PRNG seed. (CVS 6488)

2009-04-10 18:41:01 +00:00

backup_malloc.test

Fix test case numbering in backup_malloc.test and issue when running under Windows.

2010-07-08 18:32:18 +00:00

backup.test

Changes to test scripts to work with SQLITE_TEMP_STORE=2.

2010-09-20 14:55:33 +00:00

badutf2.test

Minor change to sqlite3Utf8Read() to make consistent with READ_UTF8() usage and avoid implementation defined usages of <<.

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

between.test

Test suite fixes for builds that define OMIT symbols. (CVS 2962)

2006-01-17 09:35:01 +00:00

bigfile.test

Some changes to test scripts related to codec enabled versions of sqlite.

2010-06-22 13:46:43 +00:00

bigrow.test

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

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

bind.test

Changes to test code (only) to allow veryquick.test to run with OMIT_UTF16 builsd. Ticket #3985. (CVS 6919)

2009-07-22 07:27:56 +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

boundary1.tcl

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

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

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

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

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

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

busy.test

Add tests to make sure the busy handler resets. (CVS 4865)

2008-03-15 02:09:21 +00:00

cache.test

Add tests for very small cache-sizes (less than 10 pages).

2010-11-29 16:10:01 +00:00

capi2.test

Add the SQLITE_OMIT_AUTORESET compile-time option which if enabled causes

2011-01-17 17:42:37 +00:00

capi3.test

Add a generation counter to the Schema object and enhance OP_VerifySchema

2011-03-18 21:55:46 +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

Changes to test scripts so that the "inmemory_journal" permutation works with [ef126e775a].

2010-07-08 09:44:42 +00:00

capi3d.test

Adding the sqlite3_stmt_readonly() interface.

2010-11-16 23:10:25 +00:00

capi3e.test

Skip some tests in capi3e.test when compiled with SQLITE_OMIT_UTF16.

2011-02-14 03:49:40 +00:00

cast.test

Fix a bug in the CAST operator associated with the column cache. (CVS 5866)

2008-11-06 15:33:03 +00:00

check.test

Minor changes to test scripts to support various SQLITE_OMIT options.

2009-12-31 19:48:29 +00:00

coalesce.test

Additional test cases for the coalesce() and ifnull() functions.

2009-11-11 01:14:17 +00:00

collate1.test

First cut at adding the COLLATE operator. Regression tests pass (or at least

2007-02-01 23:02:45 +00:00

collate2.test

Refactor the name resolution procedures in the code generator. (CVS 5569)

2008-08-20 16:35:10 +00:00

collate3.test

Refactor the name resolution procedures in the code generator. (CVS 5569)

2008-08-20 16:35:10 +00:00

collate4.test

Wrap all automatic index changes inside SQLITE_OMIT_AUTOMATIC_INDEX. Add

2010-04-07 16:54:58 +00:00

collate5.test

Add test case for ticket #3376. (CVS 5705)

2008-09-16 11:58:20 +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

Remove leftover debugging commands (breakpoint and btree_breakpoint) from

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

collate8.test

Additional coverage testing in the new name resolver module. (CVS 5608)

2008-08-25 12:14:08 +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

colmeta.test

Improvements to test coverage in the lemon-generated parser and in the

2008-01-23 12:52:40 +00:00

colname.test

Add a test case for ticket #3893 and ticket #3894. (CVS 6705)

2009-06-02 15:47:37 +00:00

conflict.test

Changes to test scripts to work with SQLITE_TEMP_STORE=2.

2010-09-20 14:55:33 +00:00

corrupt2.test

Changes to test scripts so that the "inmemory_journal" permutation works with [ef126e775a].

2010-07-08 09:44:42 +00:00

corrupt3.test

Add "do_not_use_codec" logic to some of the TCL based test cases that read/write directly to the DB.

2011-02-16 01:23:50 +00:00

corrupt4.test

Some changes to test scripts related to codec enabled versions of sqlite.

2010-06-22 13:46:43 +00:00

corrupt5.test

Minor updates to comments in test scripts. (CVS 6714)

2009-06-04 02:47:03 +00:00

corrupt6.test

Some changes to test scripts related to codec enabled versions of sqlite.

2010-06-22 13:46:43 +00:00

corrupt7.test

Some changes to test scripts related to codec enabled versions of sqlite.

2010-06-22 13:46:43 +00:00

corrupt8.test

Some changes to test scripts related to codec enabled versions of sqlite.

2010-06-22 13:46:43 +00:00

corrupt9.test

Some changes to test scripts related to codec enabled versions of sqlite.

2010-06-22 13:46:43 +00:00

corrupt.test

Some changes to test scripts related to codec enabled versions of sqlite.

2010-06-22 13:46:43 +00:00

corruptA.test

Add "do_not_use_codec" logic to some of the TCL based test cases that read/write directly to the DB.

2011-02-16 01:23:50 +00:00

corruptB.test

Some changes to test scripts related to codec enabled versions of sqlite.

2010-06-22 13:46:43 +00:00

corruptC.test

Some changes to test scripts related to codec enabled versions of sqlite.

2010-06-22 13:46:43 +00:00

corruptD.test

Add "do_not_use_codec" logic to some of the TCL based test cases that read/write directly to the DB.

2011-02-16 01:23:50 +00:00

corruptE.test

Some changes to test scripts related to codec enabled versions of sqlite.

2010-06-22 13:46:43 +00:00

count.test

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

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

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

Remove leftover debugging commands (breakpoint and btree_breakpoint) from

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

crash4.test

Get all tests running without memory leaks. (CVS 4714)

2008-01-16 17:46:38 +00:00

crash5.test

Remove leftover debugging commands (breakpoint and btree_breakpoint) from

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

crash6.test

Make sure the page size in crash6.test does not exceed the maximum

2008-04-14 15:27:19 +00:00

crash7.test

Avoid an out-of-bounds read in sqlite3_prepare() and fix a case where the output variable *pzTail was being set incorrectly. Fix for #3027. (CVS 4957)

2008-04-03 14:36:25 +00:00

crash8.test

Change the journal_mode pragma to remove the "default journal mode" concept.

2010-07-08 17:40:37 +00:00

crash.test

Add additional randomness to crash tests. (CVS 4694)

2008-01-08 15:18:52 +00:00

crashtest1.c

Add the crashtest1.c program used to test the ability of the database to

2004-02-08 06:06:37 +00:00

createtab.test

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

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

cse.test

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

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

ctime.test

Modify ctime.test to work with SQLITE_THREADSAFE=2.

2010-06-24 17:37:57 +00:00

date.test

Do correct affinity transformations on floating point values which have

2010-09-30 17:33:11 +00:00

dbstatus.test

Make sure memory statistics are enabled for the dbstatus.test script.

2010-09-09 17:43:06 +00:00

default.test

Changes to reduce the heap space consumed by triggers, views and tables in the in-memory representation of the schema. Also to reduce the space used by prepared statements slightly. (CVS 6305)

2009-02-19 14:39:25 +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

delete.test

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

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

descidx1.test

Some changes to test scripts related to codec enabled versions of sqlite.

2010-06-22 13:46:43 +00:00

descidx2.test

Some changes to test scripts related to codec enabled versions of sqlite.

2010-06-22 13:46:43 +00:00

descidx3.test

Some changes to test scripts related to codec enabled versions of sqlite.

2010-06-22 13:46:43 +00:00

diskfull.test

Remove leftover debugging commands (breakpoint and btree_breakpoint) from

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

distinctagg.test

Better error message when DISTINCT is used on an aggregate function that

2009-02-09 13:19:28 +00:00

e_createtable.test

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

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

e_delete.test

Modify some evidence tags to match updated gifs.

2010-09-24 19:14:42 +00:00

e_droptrigger.test

Add test file e_dropview.test.

2010-11-30 12:12:24 +00:00

e_dropview.test

Add test file e_dropview.test.

2010-11-30 12:12:24 +00:00

e_expr.test

Changes to test scripts so that they work with SQLITE_ENABLE_ICU.

2010-11-01 05:42:26 +00:00

e_fkey.test

Change the EXPLAIN QUERY PLAN output to use "USING INDEX" instead of "BY INDEX", and to use "SEARCH" instead of "SCAN" for loops that are not full-table scans.

2010-11-13 16:42:27 +00:00

e_fts3.test

Clear a global variable in e_fts3.test before it is used.

2010-04-12 19:43:43 +00:00

e_insert.test

Add new file e_createtable.test.

2010-09-25 17:29:57 +00:00

e_reindex.test

Add tests to file e_reindex.test.

2010-09-25 07:51:58 +00:00

e_resolve.test

Add test file e_resolve.test.

2010-12-01 11:46:53 +00:00

e_select2.test

Add new file e_vacuum.test. Move part of e_select.test into e_select2.test.

2010-09-24 18:04:22 +00:00

e_select.test

Add evidence marks for the sqlite3_blob_reopen() interface. Fix compiler

2010-11-02 15:26:24 +00:00

e_update.test

Modify some evidence tags to match updated gifs.

2010-09-24 19:14:42 +00:00

e_vacuum.test

Updates to e_vacuum.test so that it works when SQLITE_DEFAULT_AUTOVACUUM=1 is

2010-09-28 15:25:20 +00:00

enc2.test

Fixes to the test suite (no code changes) so that quick.test runs with OMIT_ATTACH builds. #2706. (CVS 4480)

2007-10-09 08:29:32 +00:00

enc3.test

Changes to lemon to generate additional comments in the output file and

2008-01-22 01:48:05 +00:00

enc4.test

Fix some matching issues in enc4.test affected by TCL versions.

2010-09-30 20:11:24 +00:00

enc.test

Add some code to MemTranslate() to prevent the READ_UTF8() macro from overreading a buffer. (CVS 4033)

2007-05-23 16:23:09 +00:00

eqp.test

Fix a problem with "EXPLAIN QUERY PLAN SELECT count(*) FROM tbl".

2011-02-21 17:49:49 +00:00

eval.test

If sqlite3_column_value() is called to obtain a value with the MEM_Static flag set, clear it and set the MEM_Ephem flag before returning. Otherwise, if the value is passed to sqlite3_bind_value() or sqlite3_result_value(), sqlite may attempt to use the buffer after the statement has been finalized. This is not always valid, as MEM_Static only guarantees that a MEM.z buffer will be valid for the lifetime of the owner statement, not that it is actually a static buffer. (CVS 5812)

2008-10-13 10:37:49 +00:00

exclusive2.test

Add "do_not_use_codec" logic to some of the TCL based test cases that read/write directly to the DB.

2011-02-16 01:23:50 +00:00

exclusive.test

Fix a broken test case in exclusive.test.

2010-11-01 05:54:06 +00:00

exec.test

Miscellaneous test coverage improvements. (CVS 4734)

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

expr.test

Fix all known instances of signed-integer overflow. Within SQL expressions,

2011-03-05 20:59:46 +00:00

fallocate.test

Fix some problems with running test scripts with the inmemory_journal permutation.

2010-08-06 14:37:13 +00:00

filectrl.test

Attempt to get the filectrl.test script running.

2010-06-01 00:28:42 +00:00

filefmt.test

Do not report corruption if the the db size header field is greater than the file size on disk unless the two change-counter header fields are identical. Fix for ticket [89b8c9ac54].

2011-02-09 18:19:20 +00:00

fkey1.test

Check in implementation of foreign key constraints.

2009-09-19 17:00:31 +00:00

fkey2.test

Add the SQLITE_OMIT_AUTORESET compile-time option which if enabled causes

2011-01-17 17:42:37 +00:00

fkey3.test

If an update does not modify any child or parent key columns, omit foreign key processing for the statement.

2009-10-01 16:09:04 +00:00

fkey4.test

If a deferred foreign key constraint fails on a statement that is not part

2011-02-04 05:47:51 +00:00

fkey_malloc.test

Remove unreachable branches from fkey.c. Add a few tests to cover the remaining branches.

2009-09-30 08:11:07 +00:00

format4.test

Get tests working with SQLITE_OMIT_AUTOVACUUM=1. (CVS 3918)

2007-05-04 14:36:22 +00:00

fts1a.test

Fix a bug in the handling of the OR operator in FTS1. Test cases added to

2006-09-28 19:43:31 +00:00

fts1b.test

Modify FTS1 so that the "magic" column has the same name as the virtual

2006-09-18 02:12:47 +00:00

fts1c.test

The snippet generator adds ellipsis between text from different columns. (CVS 3465)

2006-10-04 17:35:28 +00:00

fts1d.test

Add a Porter stemmer option to the FTS1 module. (CVS 3452)

2006-10-01 18:41:19 +00:00

fts1e.test

Add tests for delete and update in fts1. (CVS 3481)

2006-10-19 23:28:35 +00:00

fts1f.test

Fix typos in test naming (was using 'e' instead of 'f'). (CVS 3655)

2007-02-23 00:14:05 +00:00

fts1i.test

Do not run test fts1i.test if FTS1 is not installed. (CVS 3600)

2007-01-24 03:43:20 +00:00

fts1j.test

http://www.sqlite.org/cvstrac/tktview?tn=2219

2007-02-07 01:01:17 +00:00

fts1k.test

Change all instances of "it's" in comments to either "its" or "it is",

2007-12-13 21:54:09 +00:00

fts1l.test

Fix crash in delete when existing row has null fields. Previous code

2007-04-09 20:45:40 +00:00

fts1m.test

Apply change 4095 to fts1. Fix snippet generation when the left-most

2007-07-25 00:25:20 +00:00

fts1n.test

Replicates http://www.sqlite.org/cvstrac/chngview?cn=4151 which

2007-07-25 00:38:05 +00:00

fts1o.test

Fix discrepency in the test pointed out by a user. Was testing fts2 :-). (CVS 4348)

2007-08-30 20:01:32 +00:00

fts1porter.test

Make DL_POSITION the default mode in FTS1. Remove the need to compile

2006-10-03 19:37:37 +00:00

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

fts2a.test

Fix overzealous fts2 assertions WRT rowid 0 or lower. Only check that

2007-05-21 21:59:18 +00:00

fts2b.test

dup fts1 tests and edit for fts2. fts1porter.test omitted because it

2006-10-19 23:36:25 +00:00

fts2c.test

dup fts1 tests and edit for fts2. fts1porter.test omitted because it

2006-10-19 23:36:25 +00:00

fts2d.test

dup fts1 tests and edit for fts2. fts1porter.test omitted because it

2006-10-19 23:36:25 +00:00

fts2e.test

dup fts1 tests and edit for fts2. fts1porter.test omitted because it

2006-10-19 23:36:25 +00:00

fts2f.test

Fix typos in test naming (was using 'e' instead of 'f'). (CVS 3655)

2007-02-23 00:14:05 +00:00

fts2g.test

Don't do anything when input doclists are both empty. Ticket #2774 (CVS 4546)

2007-11-16 00:23:07 +00:00

fts2h.test

Test that terms longer than interior nodes work correctly. A bug

2006-11-29 21:03:00 +00:00

fts2i.test

Do not run the fts2i.test unless the FTS2 module is available. (CVS 3601)

2007-01-24 03:46:35 +00:00

fts2j.test

http://www.sqlite.org/cvstrac/tktview?tn=2219

2007-02-07 01:01:17 +00:00

fts2k.test

Convert fts2 to use sqlite3_prepare_v2() to prevent certain logic

2007-08-10 23:47:03 +00:00

fts2l.test

Change all instances of "it's" in comments to either "its" or "it is",

2007-12-13 21:54:09 +00:00

fts2m.test

Fix crash in delete when existing row has null fields. Previous code

2007-04-09 20:45:40 +00:00

fts2n.test

Change all instances of "it's" in comments to either "its" or "it is",

2007-12-13 21:54:09 +00:00

fts2o.test

Modify handling of SQLITE_SCHEMA in fts2 code. An SQLITE_SCHEMA error may cause SQLite to reload the internal schema, deleting and recreating v-table objects. So the sqlite3_vtab structure can be deleted out from under a v-table implementation. (CVS 4151)

2007-07-02 10:16:49 +00:00

fts2p.test

fts2 functions for testing scripts.

2008-07-22 23:32:27 +00:00

fts2q.test

Implement optimize() function.

2008-07-22 23:49:44 +00:00

fts2r.test

Backport http://www.sqlite.org/cvstrac/chngview?cn=5489 from fts3.

2008-07-29 20:38:17 +00:00

fts2token.test

Add a test that calls fts2_tokenizer() with an argument set via C code. (CVS 4118)

2007-06-25 12:05:40 +00:00

fts3_common.tcl

Fix a typo in walfault.test.

2010-05-04 11:06:03 +00:00

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 test file e_droptrigger.test.

2010-11-29 12:06:45 +00:00

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

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

Add extra tests for parsing of whitespace in tokenizer declarations,.

2009-12-07 16:23:42 +00:00

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

fts3af.test

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

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

fts3ag.test

Improved error message when the right-hand operand of MATCH in FTS3 is

2010-03-15 20:53:01 +00:00

fts3ah.test

Updates to FTS4 to improve performance and make more accurate cost estimates for prefix terms.

2010-10-20 18:56:04 +00:00

fts3ai.test

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

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

fts3aj.test

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

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

fts3ak.test

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

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

fts3al.test

Change the fts3 snippet function to return (hopefully) more relevant snippets in less time.

2010-01-06 17:19:21 +00:00

fts3am.test

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

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

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

fts3ao.test

Test coverage improvements for fts3.c.

2010-10-25 12:47:43 +00:00

fts3atoken.test

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

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

fts3aux1.test

Ensure fts4aux can handle a table name in single or double quotes as a constructor argument.

2011-02-05 15:47:12 +00:00

fts3b.test

Modify a test in fts3b.test to reflect the fact that the docid field may now be updated.

2009-12-02 16:09:16 +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

fts3corrupt2.test

Test cases and minor changes to make fts3 more robust in the face of a corrupt database.

2010-10-30 15:21:13 +00:00

fts3corrupt.test

Fix a case in fts4 where a corrupt %_stat table could lead to a crash.

2011-02-01 17:55:48 +00:00

fts3cov.test

More coverage tests for fts3.c.

2010-10-26 07:14:25 +00:00

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

fts3defer2.test

Fix a bug in fts4 to do with matchinfo and deferred tokens.

2011-03-23 17:10:43 +00:00

fts3defer.test

Changes to allow FTS4 tables to be created without the underlying %_docsize table (in order to save space).

2010-11-02 17:41:52 +00:00

fts3e.test

Add some simple tests to make sure that the different fulltextFilter

2008-07-29 20:24:46 +00:00

fts3expr2.test

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

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

fts3expr.test

Improved error message when the right-hand operand of MATCH in FTS3 is

2010-03-15 20:53:01 +00:00

fts3fault2.test

Add test cases for fts4aux. Fix a bug affecting fts3 tables with multiple columns.

2011-02-05 14:37:57 +00:00

fts3fault.test

Add coverage tests (and associated fixes) for new matchinfo() code.

2010-11-25 17:49:28 +00:00

fts3malloc.test

Test coverage improvements for fts3.c.

2010-10-25 12:47:43 +00:00

fts3matchinfo.test

Fix a couple of crashes in fts3 that can occur if the database contents are inconsistent.

2011-01-13 11:20:04 +00:00

fts3near.test

Change the fts3 snippet function to return (hopefully) more relevant snippets in less time.

2010-01-06 17:19:21 +00:00

fts3query.test

Experimental changes to fts3 function matchinfo().

2010-11-23 19:16:47 +00:00

fts3rnd.test

Fix a bug causing fts3 to incorrectly return SQLITE_CORRUPT.

2010-12-02 17:39:26 +00:00

fts3shared.test

Add new test file fts3shared.test to test the previous change.

2010-09-17 16:01:09 +00:00

fts3snippet.test

Test coverage improvements for fts3.c.

2010-10-25 12:47:43 +00:00

fts4aa.test

Check-in [87a6a9970b] did not completely disable FTS4. This check-in aims

2010-03-09 13:02:09 +00:00

func2.test

Update comment for substrFunc(). Added additional SUBSTR() test cases.

2009-11-12 05:04:50 +00:00

func3.test

Fix problem with func3.test.

2010-08-28 19:09:29 +00:00

func.test

More rounding tests.

2010-02-17 03:57:58 +00:00

fuzz2.test

Minor changes to test scripts to support various SQLITE_OMIT options.

2009-12-31 19:48:29 +00:00

fuzz3.test

Include fuzz3.test in all.test. Get fuzz3.test working again. (CVS 6110)

2009-01-05 17:19:03 +00:00

fuzz_common.tcl

Reenable fuzz testing for all.test. Make sure the query flattener copies

2009-01-05 19:36:30 +00:00

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

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

hook.test

Test that the rollback-hook is invoked if a commit-hook implementation returns non-zero (causing a rollback). Remove documentation comment that says otherwise from sqlite.h.in.

2010-04-13 06:18:02 +00:00

icu.test

Add tests to check that the ICU regexp() function can only be called with exactly two arguments.

2010-07-30 05:06:05 +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

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

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

in.test

Move the test for an (illegal) scalar sub-query that returns more than one column to earlier in SELECT processing in order to avoid an assert() that can happen later on.

2010-09-02 19:01:16 +00:00

incrblob2.test

Cause incremental-blob read/write operations lock shared-cache tables in the same way as normal SQL read/writes. Add complex assert statements to make sure tehe correct shared-cache locks are held when accessing the database. Eliminate some redundant checks from btree.c. (CVS 6830)

2009-06-29 06:00:37 +00:00

incrblob3.test

Have sqlite3_blob_bytes() return 0 following a failed call to sqlite3_reopen_blob().

2010-12-06 17:11:05 +00:00

incrblob_err.test

Fix SQLITE_OMIT_AUTOVACUUM so that it works again. Ticket #3228. (CVS 5439)

2008-07-18 17:16:26 +00:00

incrblob.test

Fix some segfaults that could occur in obscure circumstances where error messages contained characters that could be mistaken for printf format specifiers.

2010-10-21 15:12:44 +00:00

incrblobfault.test

Structural coverage tests for vdbeblob.c. Including experimental new API sqlite3_blob_reopen().

2010-10-26 18:42:52 +00:00

incrvacuum2.test

Remove the "proc zeroblob" implementation from incrvacuum2.test. It is no longer required as of (6906) and, as #3988 points out, unreliable. (CVS 6936)

2009-07-25 13:42:50 +00:00

incrvacuum_ioerr.test

Remove leftover debugging commands (breakpoint and btree_breakpoint) from

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

incrvacuum.test

Changes to test scripts so that the "inmemory_journal" permutation works with [ef126e775a].

2010-07-08 09:44:42 +00:00

index2.test

Ignore leading spaces on text to numeric conversions. Ticket #1662.

2006-03-03 19:12:29 +00:00

index3.test

Changes to test scripts so that the "inmemory_journal" permutation works with [ef126e775a].

2010-07-08 09:44:42 +00:00

index.test

Omit unnecessary OP_Next and OP_Prev operators when uniqueness constraints

2011-03-09 21:02:31 +00:00

indexedby.test

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

2011-01-28 01:57:41 +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

Use 1<<$x instead of pow(2,$x) in the test suite code. (CVS 4715)

2008-01-16 18:20:41 +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 expression comparison logic to take the COLLATE operator into account.

2010-01-07 15:17:02 +00:00

insert5.test

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

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

insert.test

Improvements to coverage testing. (CVS 3810)

2007-04-05 11:25:58 +00:00

intarray.test

Additional intarray test cases and tweaks to comments.

2009-11-10 17:55:47 +00:00

interrupt.test

Get all tests running without memory leaks. (CVS 4714)

2008-01-16 17:46:38 +00:00

intpkey.test

When using an index to scan a database table, read column data from the index in preference to the table. This increases the likelihood that the table will not be required at all. (CVS 4580)

2007-11-29 17:43:27 +00:00

io.test

Fix issues with the io.test script. There is still a problem with a

2010-03-29 19:36:52 +00:00

ioerr2.test

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

2009-06-05 17:09:11 +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

Fix the new ioerr4.test so that it plays well with others. (CVS 5103)

2008-05-08 01:11:42 +00:00

ioerr5.test

Disable the SQLITE_MAX_PAGE_SIZE compile time option (it is now always set to 65536). Fix some other problems in test files.

2010-08-18 15:25:17 +00:00

ioerr.test

Fix a couple of test script problems.

2010-10-04 16:06:11 +00:00

join2.test

Modify test scripts to work when SQLITE_OMIT_SUBQUERY (along with other OMIT macros) is defined. (CVS 2251)

2005-01-21 03:12:14 +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

Fix the query optimizer so that it correctly handles constant expressions

2007-06-08 00:20:47 +00:00

join6.test

Added test cases for the multi-way USING and NATURAL JOIN fix.

2009-12-09 18:22:25 +00:00

join.test

When generating WHERE clause terms internally for NATURAL and USING joins, identify the table by its position in the FROM list, not by its name or alias. Fix for [b73fb0bd64].

2009-10-19 15:52:32 +00:00

journal1.test

Do not attempt to read the journal file on windows because manditory locking

2005-03-20 22:54:56 +00:00

journal2.test

When creating a journal file on unix, attempt to create it with the same permissions as the associated database file.

2010-07-15 14:59:37 +00:00

journal3.test

When creating a journal file on unix, attempt to create it with the same permissions as the associated database file.

2010-07-15 14:59:37 +00:00

jrnlmode2.test

Fix jrnlmode2.test so that it works on systems where UNDELETABLE_WHEN_OPEN is defined.

2010-06-21 05:40:49 +00:00

jrnlmode3.test

Add the SQLITE_FCNTL_SYNC file-control.

2011-01-11 17:39:37 +00:00

jrnlmode.test

Fix a problem wherein changing the journal-mode immediately after leaving exclusive-locking mode could lead to the database being unlocked without clearing the changeCountDone flag.

2010-08-07 09:31:14 +00:00

keyword1.test

Add test cases to make sure that keywords that we say can be used as

2009-01-29 19:27:46 +00:00

lastinsert.test

Make the last_insert_rowid method in the TCL interface work with

2006-06-21 19:30:34 +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

like2.test

Fix the LIKE query optimizer so that it works with LIKE patterns

2008-05-26 18:33:40 +00:00

like.test

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

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

limit.test

Additional coverage testing. Fix a segfault following OOM in

2008-08-02 03:50:39 +00:00

loadext2.test

Move SQL functions used for testing only out of func.c and into a new

2008-03-19 16:08:53 +00:00

loadext.test

Fix a problem in loadext.test causing an error on OSX. This is not a real problem, just a case of the test script expecting a slightly different error message than the one returned. (CVS 6361)

2009-03-20 09:09:37 +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

Some changes to test scripts related to codec enabled versions of sqlite.

2010-06-22 13:46:43 +00:00

lock5.test

Fix to lock5.test so that it runs with the inmemory_journal permutation on osx.

2010-07-08 14:59:01 +00:00

lock6.test

Fix minor test suite problems causing errors on OSX.

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

lock7.test

Add a test to verify that 3.6.17 releases read-locks obtained to read the database schema even if the connection is not currently in auto-commit mode.

2009-08-17 09:29:09 +00:00

lock_common.tcl

Add the "valgrind" permutation. This is the same as veryquick.test except that it omits the multi-process tests that do not work under valgrind. No changes to production or existing test code.

2010-12-03 10:32:06 +00:00

lock.test

Changes to test scripts to work with SQLITE_TEMP_STORE=2.

2010-09-20 14:55:33 +00:00

lookaside.test

Add test cases for the new lookaside hit and miss status outputs. Add

2010-12-21 21:28:38 +00:00

main.test

Changes to test scripts so that the "inmemory_journal" permutation works with [ef126e775a].

2010-07-08 09:44:42 +00:00

make-where7.tcl

Attempt to optimize virtual table queries with 'OR' expressions in the WHERE clause. (CVS 6527)

2009-04-21 09:02:45 +00:00

malloc3.test

Have the pager change to at least WRITER_CACHEMOD state before marking any pages as dirty (instead of immediately after). Otherwise, if an error occurs, the pager may be left in WRITER_LOCKED state with dirty pages in the cache.

2010-10-05 17:02:47 +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

Fix malloc5.test so it work on both 64-bit and 32-bit systems. The

2009-04-11 19:09:53 +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

Add test infrastructure (and some tests) to inject faults into os_unix.c using the new xSetSystemCall interface.

2011-03-28 19:10:06 +00:00

malloc.test

Fix an assert() in pager.c added by the previous commit. And various problems with test scripts in autovacuum and in-memory journal mode.

2010-07-03 10:00:00 +00:00

mallocA.test

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

2008-02-18 22:24:57 +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

Fix problems in test scripts. Add new test cases to improve test coverage. (CVS 5521)

2008-08-01 18:47:01 +00:00

mallocH.test

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

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

mallocI.test

Fix issue in mallocI test script where db handle not released.

2010-07-07 20:00:04 +00:00

mallocJ.test

More coverage improvements. (CVS 6148)

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

mallocK.test

Increased test coverage in where.c. (CVS 6146)

2009-01-08 21:00:02 +00:00

manydb.test

Added support for proxy file locking style

2008-11-21 00:10:35 +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

memdb.test

Fix memdb.test so that it works when OMIT_AUTOVACUUM is defined. (CVS 6649)

2009-05-18 16:04:38 +00:00

memleak.test

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

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

memsubsys1.test

Fix a problem in memsubsys1.test. Modifications to test code only.

2011-01-25 09:54:53 +00:00

memsubsys2.test

Make sure SQLite is running with MEMSTATUS enabled at the beginning of

2010-09-10 13:22:59 +00:00

minmax2.test

First pass at optimizing max()/min() as described in #2853. Some refinements to come. (CVS 4687)

2008-01-05 17:39:29 +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

minmax.test

Improved testing of the min/max optimization. (CVS 5373)

2008-07-08 18:05:26 +00:00

misc1.test

Do create, open, or initialize the rollback journal until something actually

2010-03-19 15:48:13 +00:00

misc2.test

Change "PRAGMA disable_recursive_triggers" to "PRAGMA recursive_triggers". Also a fix for compiling with OMIT_TRIGGER defined.

2009-09-01 17:11:07 +00:00

misc3.test

Fix the test case misc3-6.11 so that it works correctly on UTF16 databases

2009-05-06 00:49:00 +00:00

misc4.test

Enhance the ANALYZE command so that it gathers statistics in the sqlite_stat1

2010-09-25 22:32:56 +00:00

misc5.test

Changes to test scripts so that the "inmemory_journal" permutation works with [ef126e775a].

2010-07-08 09:44:42 +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

Update misc7.test to account for EQP changes.

2010-12-02 06:08:53 +00:00

misuse.test

The sqlite TCL command no longer returns the hex address of the sqlite3*

2006-01-03 00:33:50 +00:00

multiplex.test

Exclude a test case from the inmemory_journal permutation of multiplex.test.

2010-12-02 14:47:06 +00:00

mutex1.test

Update test file mutex1.test to account for [e3b500fb5d].

2011-01-26 15:23:22 +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

Fix test numbering issue in nan.test.

2010-07-07 16:20:38 +00:00

notify1.test

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

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

notify2.test

Display a warning that the notify2-3 test sometimes fails on single-core

2009-03-30 11:59:30 +00:00

notify3.test

Do not run some tests in notify3.test with the inmemory_journal permutation. They do not pass as the tests assume that the database schema is not loaded until the first invocation of [db eval]. This is not true with the inmemory_journal permutation.

2010-08-06 13:50:07 +00:00

notnull.test

Add a test case to show that [/info/29ab7be99f|29ab7be99f] is fixed.

2009-09-09 11:43:43 +00:00

null.test

Adjust the test suite to account for recent changes related to #2822. Most changes are related to English language error messages only. (CVS 4622)

2007-12-13 07:58:50 +00:00

omitunique.test

More tests for SQLITE_OMIT_UNIQUE_ENFORCEMENT and minor change to implementation.

2011-03-12 04:58:55 +00:00

openv2.test

Honor the SQLITE_OPEN_READONLY flag even on a :memory: or temporary database,

2009-06-11 17:32:45 +00:00

oserror.test

Unix errno integer can vary from one system to the next. So do not

2011-03-08 14:05:07 +00:00

pager1.test

Merge in the blocking-checkpoint enhancement, including the new

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

pager2.test

Add the SQLITE_FCNTL_SYNC file-control.

2011-01-11 17:39:37 +00:00

pager3.test

Fix a bug to do with deleting the journal file when exiting exclusive-locking mode.

2010-08-06 06:54:47 +00:00

pagerfault2.test

Further changes to test scripts so that the "inmemory_journal" permutation works.

2010-07-03 16:37:45 +00:00

pagerfault3.test

Add test script pagerfault3.test. No changes to code or existing tests.

2011-01-28 16:45:42 +00:00

pagerfault.test

Another change for testing on Windows.

2010-11-04 21:13:56 +00:00

pageropt.test

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

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

pagesize.test

Make the TEMP file tables use the page size set for the main database.

2010-01-26 01:25:26 +00:00

pcache2.test

Add some code to sqlite3VdbeMemSetZeroBlob() so that it works (less efficiently) even when OMIT_INCRBLOB is defined. Ticket #3977. (CVS 6906)

2009-07-18 14:36:23 +00:00

pcache.test

Get all test cases working with the mutex-free-pcache implementation.

2011-01-18 16:13:27 +00:00

permutations.test

Fix some test cases in walfault.test. Extend one test case to restore code coverage. Add wal5.test to the "coverage-wal" permutation.

2011-02-07 16:24:39 +00:00

pragma2.test

Fixes to the test suite (no code changes) so that quick.test runs with OMIT_ATTACH builds. #2706. (CVS 4480)

2007-10-09 08:29:32 +00:00

pragma.test

Fix minor test suite problems causing errors on OSX.

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

printf.test

Enhance the %q, %Q, and %w printf conversions so that the precisions

2009-11-25 16:53:37 +00:00

progress.test

If the keyword "unordered" appears at the end of the SQLITE_STAT1.STAT

2011-03-29 15:00:17 +00:00

ptrchng.test

Remove leftover debugging commands (breakpoint and btree_breakpoint) from

2008-07-12 14:52:20 +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

quota.test

Add tests to quota.test.

2010-09-01 18:00:09 +00:00

quote.test

Fix duplicate test IDs in the test suite. No changes to code. Ticket #2319. (CVS 3869)

2007-04-25 11:32:30 +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

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

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

rdonly.test

Some changes to test scripts related to codec enabled versions of sqlite.

2010-06-22 13:46:43 +00:00

reindex.test

Remove leftover debugging commands (breakpoint and btree_breakpoint) from

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

releasetest.mk

Remove proprietary information from the releasetest.tcl script and add it

2010-09-06 18:44:14 +00:00

releasetest.tcl

Run the multi-threaded tests in test/threadtest3.c as part of releasetest.tcl. Remove the OMIT_BUILTIN_TEST symbol from the "Device-Two" configuration.

2010-09-13 12:15:36 +00:00

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

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

Remove the priorNewRowid field from the sqlite3 structure. Use the

2009-06-26 15:14:55 +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

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

savepoint3.test

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

2009-06-05 17:09:11 +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

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

savepoint.test

Add the SQLITE_FCNTL_SYNC file-control.

2011-01-11 17:39:37 +00:00

schema2.test

Simplify wording of backup API error message. Decapitalize some other

2009-02-04 17:40:57 +00:00

schema3.test

Remove debugging code from test script.

2010-06-28 11:06:53 +00:00

schema4.test

Fix some problems that can occur if a trigger has the same name as another database object.

2010-09-29 07:16:46 +00:00

schema.test

Fix an incorrect ALWAYS() macro in vdbeapi.c. Fix the output of a few

2010-02-24 18:40:39 +00:00

securedel.test

Enhancements to the secure_delete pragma to make it easier to use.

2010-02-12 19:46:26 +00:00

select1.test

Additional refinements to Expr handling. Restore compression of trigger

2009-05-28 01:00:55 +00:00

select2.test

Further refinements to table order selection on join query planning.

2010-04-15 01:04:54 +00:00

select3.test

Use 1<<$x instead of pow(2,$x) in the test suite code. (CVS 4715)

2008-01-16 18:20:41 +00:00

select4.test

In a 3-fold compound SELECT make sure early code generation of the SELECTs

2009-04-16 00:24:23 +00:00

select5.test

Reinsert an SCopy operation that was removed in (5523) because coverage

2008-08-21 14:15:59 +00:00

select6.test

Enhance the ANALYZE command so that it gathers statistics in the sqlite_stat1

2010-09-25 22:32:56 +00:00

select7.test

Modify the vdbe so that the comparison operator opcodes do not modify the data type of operands. Fix for [aa92c76cd4].

2010-03-05 16:32:12 +00:00

select8.test

Continuing work toward converting the VM into a register machine. (CVS 4707)

2008-01-12 12:48:07 +00:00

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

selectA.test

Add test cases to verify that ticket #3314 has been fixed. (CVS 5579)

2008-08-21 14:24:29 +00:00

selectB.test

Disable the query flattening optimization when the subquery is a compound

2009-04-02 16:59:47 +00:00

selectC.test

Do not apply the flattening optimization if the sub-query is DISTINCT. Fix for [e4b8a2ba6e].

2010-08-13 16:38:48 +00:00

server1.test

Fix a bug in test_server.c that resulted from the change in semantics

2007-08-29 18:20:16 +00:00

shared2.test

Add trivial test case to make sure shared-cache mode does not automatically turn on exclusive-locking mode.

2010-09-15 11:42:04 +00:00

shared3.test

Changes to test scripts so that the "inmemory_journal" permutation works with [ef126e775a].

2010-07-08 09:44:42 +00:00

shared4.test

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

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

shared6.test

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

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

shared7.test

Disallow attaching the same database multiple times to the same db connection

2009-04-30 13:30:32 +00:00

shared_err.test

Added SQLITE_OMIT_DEPRECATED compile time option to leave out deprecated functions. Updated test scripts to skip tests of deprecated functions if they are compiled out. (CVS 5808)

2008-10-12 00:27:53 +00:00

shared.test

Add a test case to shared.test. No changes to production code.

2010-07-23 15:55:31 +00:00

sharedlock.test

When a b-tree transaction is committed when there are open cursors, downgrade shared-cache write-locks to read-locks instead of relinquishing all locks. Fix for #3942. (CVS 6837)

2009-07-02 17:21:57 +00:00

shortread1.test

Add tests to prevent a regression of the short read problem discovered

2007-09-14 01:48:11 +00:00

sidedelete.test

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

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

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

softheap1.test

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

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

sort.test

Create separate affinities for INTEGER and REAL. (CVS 2766)

2005-11-14 22:29:05 +00:00

speed1.test

Enhance sqlite3_shutdown() so that it automatically invokes

2009-04-09 01:23:49 +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

Enhance sqlite3_shutdown() so that it automatically invokes

2009-04-09 01:23:49 +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

removed unused functions from test3.c (test code only); (CVS 6867)

2009-07-09 02:48:23 +00:00

speed4.test

Remove leftover debugging commands (breakpoint and btree_breakpoint) from

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

speed4p.explain

Add speed-test scripts that also show EXPLAIN output. (CVS 5017)

2008-04-16 12:57:48 +00:00

speed4p.test

Add three new test cases to speed4p.test. Two of the three do single-row

2008-04-10 13:32:36 +00:00

sqllimits1.test

Improved handling of oversize string and blob errors. Other simplifications

2009-06-25 01:47:11 +00:00

stat.test

Fix a couple of test files so that they work with DEFAULT_AUTOVACUUM.

2010-09-13 14:38:19 +00:00

stmt.test

Changes to test scripts to work with SQLITE_TEMP_STORE=2.

2010-09-20 14:55:33 +00:00

subquery.test

Increased test coverage. (CVS 6147)

2009-01-09 01:12:27 +00:00

subselect.test

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

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

substr.test

Check-in (6230) introduced a bugs in SUBSTR() which was caught by the fuzz

2009-02-03 13:10:54 +00:00

superlock.test

Change blocking-checkpoint tests so that they run once using "PRAGMA wal_checkpoint" and once using calls to sqlite3_wal_checkpoint_v2(). Also fix edge cases surrounding the output variables set by wal_checkpoint_v2().

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

sync.test

Fixes to the test suite (no code changes) so that quick.test runs with OMIT_ATTACH builds. #2706. (CVS 4480)

2007-10-09 08:29:32 +00:00

syscall.test

Fix a problem in the unix VFS implementation of xNextSystemCall(). Also some typos that prevent compilation when HAVE_POSIX_FALLOCATE is defined.

2011-03-29 10:04:23 +00:00

sysfault.test

Add test infrastructure (and some tests) to inject faults into os_unix.c using the new xSetSystemCall interface.

2011-03-28 19:10:06 +00:00

table.test

Unset some global TCL variables prior to use in test where prior tests can

2010-05-03 19:20:46 +00:00

tableapi.test

Fix problem with tableapi.test on Windows.

2011-03-24 17:37:24 +00:00

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

tempdb.test

Changes to test scripts to work with SQLITE_TEMP_STORE=2.

2010-09-20 14:55:33 +00:00

temptable.test

Changes sqlite3_prepare_v2() (and related routines) so that if it fails due

2009-06-16 17:49:36 +00:00

temptrigger.test

Disable the temptrigger.test test script when shared cache is disabled.

2009-04-15 13:07:19 +00:00

tester.tcl

Run some of the existing test scripts with optimizations disabled as part of all.test.

2010-12-07 14:32:28 +00:00

thread1.test

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

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

thread2.test

Simplify os_unix.c by removing support for LinuxThreads. Linux systems must

2010-05-14 12:43:01 +00:00

thread001.test

Prevent the tcl test suite from throwing an exception when a threadsafe SQLite is linked against a non-threadsafe Tcl for testing. Print a warning instead. Ticket #3753. (CVS 6389)

2009-03-26 14:48:07 +00:00

thread002.test

Prevent the tcl test suite from throwing an exception when a threadsafe SQLite is linked against a non-threadsafe Tcl for testing. Print a warning instead. Ticket #3753. (CVS 6389)

2009-03-26 14:48:07 +00:00

thread003.test

Prevent the tcl test suite from throwing an exception when a threadsafe SQLite is linked against a non-threadsafe Tcl for testing. Print a warning instead. Ticket #3753. (CVS 6389)

2009-03-26 14:48:07 +00:00

thread004.test

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

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

thread005.test

Prevent the tcl test suite from throwing an exception when a threadsafe SQLite is linked against a non-threadsafe Tcl for testing. Print a warning instead. Ticket #3753. (CVS 6389)

2009-03-26 14:48:07 +00:00

thread_common.tcl

Do not do the *-closeallfiles test for notify2.test. It uses multiple threads.

2010-07-06 11:26:15 +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

Get threadtest2.c working again after being long neglected. (CVS 3562)

2007-01-05 01:58:26 +00:00

threadtest3.c

Add file test/tt3_checkpoint.c that adds a multi-threaded test for blocking checkpoints to threadtest3.

2010-11-19 09:58:11 +00:00

tkt35xx.test

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

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

tkt1435.test

Test suite fixes for builds that define OMIT symbols. (CVS 2962)

2006-01-17 09:35:01 +00:00

tkt1443.test

Test suite fixes for builds that define OMIT symbols. (CVS 2962)

2006-01-17 09:35:01 +00:00

tkt1444.test

Modify the test cases in tkt1444.test that were failing. I am convinced that the test cases were incorrect. (CVS 3288)

2006-06-23 14:43:30 +00:00

tkt1449.test

Test suite fixes for builds that define OMIT symbols. (CVS 2962)

2006-01-17 09:35:01 +00:00

tkt1473.test

Test suite fixes for builds that define OMIT symbols. (CVS 2962)

2006-01-17 09:35:01 +00:00

tkt1501.test

Test suite fixes for builds that define OMIT symbols. (CVS 2962)

2006-01-17 09:35:01 +00:00

tkt1512.test

Get tests working with SQLITE_OMIT_AUTOVACUUM=1. (CVS 3918)

2007-05-04 14:36:22 +00:00

tkt1514.test

Simplifications to the Expr object: Remove Expr.span completely and convert

2009-05-27 10:31:29 +00:00

tkt1536.test

Fix incorrect type conversions when copying from a table into itself.

2005-11-24 13:15:32 +00:00

tkt1537.test

Fixes for OMIT_SUBQUERY builds: Disable where clause OR->IN optimization. Include EXISTS keyword (for new CREATE TABLE syntax). Test file fixes. (CVS 2943)

2006-01-14 08:02:28 +00:00

tkt1567.test

Tentative fix for ticket #1567: disable the sqlite3pager_dont_write()

2005-12-19 16:15:31 +00:00

tkt1644.test

Minor test file modifications for builds compiled with OMIT options. (CVS 3077)

2006-02-10 13:33:30 +00:00

tkt1667.test

Disable the legacy "sqlite" command in the TCL interface. Provide only

2010-08-25 19:39:19 +00:00

tkt1873.test

Fixes to the test suite (no code changes) so that quick.test runs with OMIT_ATTACH builds. #2706. (CVS 4480)

2007-10-09 08:29:32 +00:00

tkt2141.test

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

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

tkt2192.test

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

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

tkt2213.test

Remove leftover debugging commands (breakpoint and btree_breakpoint) from

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

tkt2251.test

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

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

tkt2285.test

Remove leftover debugging commands (breakpoint and btree_breakpoint) from

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

tkt2332.test

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

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

tkt2339.test

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

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

tkt2391.test

Consider explicit collate clauses when matching WHERE constraints to indices. Fix for #2391. (CVS 4040)

2007-05-29 12:11:29 +00:00

tkt2409.test

Partial fix for a bug in recovery from xStress failures in pcache. (CVS 5635)

2008-08-28 17:46:18 +00:00

tkt2450.test

When expanding '*' in the result set of a SELECT, quote the expanded identifiers. Fix for #2450. (CVS 4111)

2007-06-24 06:32:17 +00:00

tkt2565.test

Enhance sqlite3_shutdown() so that it automatically invokes

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

tkt2640.test

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

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

tkt2643.test

Fix incorrect index cost assumptions that occur after an ANALYZE.

2007-09-13 17:54:40 +00:00

tkt2686.test

Add more test cases to prove that ticket #2920 does not exist in

2008-02-02 02:48:52 +00:00

tkt2767.test

Fix compilation and testing when SQLITE_OMIT_TRIGGER is defined. Ticket #3786. (CVS 6464)

2009-04-07 14:14:22 +00:00

tkt2817.test

Remove leftover debugging commands (breakpoint and btree_breakpoint) from

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

tkt2820.test

Make sure statement journals are initiated when doing DROP operations

2007-12-04 16:54:52 +00:00

tkt2822.test

Refactor the name resolution procedures in the code generator. (CVS 5569)

2008-08-20 16:35:10 +00:00

tkt2832.test

Fix compilation and testing when SQLITE_OMIT_TRIGGER is defined. Ticket #3786. (CVS 6464)

2009-04-07 14:14:22 +00:00

tkt2854.test

Add the sqlite3_unlock_notify() API. (CVS 6348)

2009-03-16 13:19:36 +00:00

tkt2920.test

Add more test cases to prove that ticket #2920 does not exist in

2008-02-02 02:48:52 +00:00

tkt2927.test

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

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

tkt2942.test

Do not apply the query flattening optimization when the outer query is an

2008-02-15 14:33:03 +00:00

tkt3080.test

The COMMIT command now works even if there are pending queries, as long

2008-11-05 16:37:34 +00:00

tkt3093.test

Make sure that when a connection is blocking on a RESERVED lock that it

2008-05-02 14:23:54 +00:00

tkt3121.test

Remove leftover debugging commands (breakpoint and btree_breakpoint) from

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

tkt3201.test

Fix compilation with OMIT_TRIGGER defined. Ticket [1ff6d29030e9757d052af0f394e56bea96b8b59b|1ff6d29030].

2009-09-21 16:06:03 +00:00

tkt3292.test

A partial fix for ticket #3292. This fixes the original problem but there

2008-08-13 14:07:40 +00:00

tkt3298.test

Fix compilation and testing when SQLITE_OMIT_TRIGGER is defined. Ticket #3786. (CVS 6464)

2009-04-07 14:14:22 +00:00

tkt3334.test

Do not flatten subqueries where the subquery has a LIMIT and the outer

2008-08-26 12:56:14 +00:00

tkt3346.test

Additional test cases for nested subqueries in a WHERE clause. (CVS 5999)

2008-12-09 13:12:56 +00:00

tkt3357.test

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

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

tkt3419.test

Add a test script to verify that ticket #3419 stays fixed. (CVS 5771)

2008-10-06 15:31:13 +00:00

tkt3424.test

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

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

tkt3442.test

Change the EXPLAIN QUERY PLAN output to use "USING INDEX" instead of "BY INDEX", and to use "SEARCH" instead of "SCAN" for loops that are not full-table scans.

2010-11-13 16:42:27 +00:00

tkt3457.test

Avoid writing the 8-byte journal-header magic until the journal-header is synced. In persistent journal-mode, this prevents any old content that follows an unsynced journal-header from being interpreted as part of the rollback journal. (CVS 6817)

2009-06-26 07:12:06 +00:00

tkt3461.test

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

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

tkt3493.test

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

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

tkt3508.test

Additional refinements to Expr handling. Restore compression of trigger

2009-05-28 01:00:55 +00:00

tkt3522.test

Expand table.* properly on a USING or a NATURAL join. Ticket #3522. (CVS 5979)

2008-12-05 00:00:07 +00:00

tkt3527.test

Fix a segfault associated with the column cache that occurs on nested VIEWs.

2008-12-08 13:42:36 +00:00

tkt3541.test

Convert the "~" and "NOT" operators to be two-address instructions.

2008-12-15 15:27:51 +00:00

tkt3554.test

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

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

tkt3581.test

Here is the test case to prove that ticket #3581 is fixed. (CVS 6174)

2009-01-14 01:10:40 +00:00

tkt3630.test

Omit the TEMP keyword from the schema of TEMP tables created using

2009-02-02 18:03:21 +00:00

tkt3718.test

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

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

tkt3731.test

Change "PRAGMA disable_recursive_triggers" to "PRAGMA recursive_triggers". Also a fix for compiling with OMIT_TRIGGER defined.

2009-09-01 17:11:07 +00:00

tkt3757.test

Enhance the ANALYZE command so that it gathers statistics in the sqlite_stat1

2010-09-25 22:32:56 +00:00

tkt3761.test

Make sure a ROLLBACK that follows an incremental vacuum works. Ticket #3761. (CVS 6416)

2009-03-31 02:54:40 +00:00

tkt3762.test

Added a test case for ticket #3672. (CVS 6414)

2009-03-31 00:50:35 +00:00

tkt3773.test

Disable the query flattening optimization when the subquery is a compound

2009-04-02 16:59:47 +00:00

tkt3791.test

Do not attempt to walk a TokenOnly or SpanOnly expression tree node.

2009-04-08 12:21:30 +00:00

tkt3793.test

Fix a couple of Windows only issues with test scripts. (CVS 6698)

2009-06-01 16:42:17 +00:00

tkt3810.test

Fix compilation with OMIT_TRIGGER defined. Ticket [1ff6d29030e9757d052af0f394e56bea96b8b59b|1ff6d29030].

2009-09-21 16:06:03 +00:00

tkt3824.test

Allow an index paired with a NOT NULL constraint to be used for sorting

2011-02-11 03:56:11 +00:00

tkt3832.test

Fix compilation with OMIT_TRIGGER defined. Ticket [1ff6d29030e9757d052af0f394e56bea96b8b59b|1ff6d29030].

2009-09-21 16:06:03 +00:00

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

tkt3841.test

Fix a problem in vdbe.c that could cause a double-free of memory if the

2009-06-17 21:42:33 +00:00

tkt3871.test

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

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

tkt3879.test

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

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

tkt3911.test

Make sure nested queries with USING clauses do not leak memory.

2009-06-12 03:27:26 +00:00

tkt3918.test

Fix for #3918. Also, fix the TRACE macros in balance_nonroot(). (CVS 6772)

2009-06-17 11:13:28 +00:00

tkt3922.test

Skip a couple tests requiring working 64bit int support on platforms without that support. Test code change only. (CVS 6823)

2009-06-26 14:17:47 +00:00

tkt3929.test

Fix compilation with OMIT_TRIGGER defined. Ticket [1ff6d29030e9757d052af0f394e56bea96b8b59b|1ff6d29030].

2009-09-21 16:06:03 +00:00

tkt3935.test

Report an error if a USING or ON clause is specified following a from-list element that is not to the right of a join operator. Fix for #3846. (CVS 6832)

2009-07-01 16:12:07 +00:00

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

tkt3997.test

When flattening a SELECT query, do not discard collation sequences explicitly attached to expressions in the parent query. Fix for #3997. (CVS 6949)

2009-07-28 13:30:30 +00:00

tkt4018.test

Fix a problem in os_unix.c where a malloc failure could lead to a leaked file descriptor.

2009-08-22 11:39:46 +00:00

tkt-2ea2425d34.test

Do not reuse function parameters in subsequent expressions since the

2009-09-03 01:18:00 +00:00

tkt-3fe897352e.test

Minor changes to test scripts to support various SQLITE_OMIT options.

2009-12-31 19:48:29 +00:00

tkt-4a03edc4c8.test

Make sure a transaction is available for rollback whenever a REDUCE conflict

2009-09-24 00:09:58 +00:00

tkt-5d863f876e.test

Add a test case demonstrating the problem described by ticket [5d863f876e].

2011-01-15 16:52:10 +00:00

tkt-5e10420e8d.test

Fix for ticket [5e10420e8d].

2010-08-23 15:41:24 +00:00

tkt-5ee23731f.test

Fix a typo in the test script added for ticket [5ee23731f15].

2009-10-13 18:49:53 +00:00

tkt-9d68c883.test

Some changes to test scripts related to codec enabled versions of sqlite.

2010-06-22 13:46:43 +00:00

tkt-02a8e81d44.test

Disable query flattening when the outer query is a compound SELECT and

2010-04-15 23:24:29 +00:00

tkt-26ff0c2d1e.test

Remove the OP_Variable optimization of check-in [48b77b04935d894] since it

2010-05-12 13:50:23 +00:00

tkt-38cb5df375.test

Fix long-standing bugs with the handling of LIMIT clausing in

2010-10-06 18:55:37 +00:00

tkt-78e04e52ea.test

Change the EXPLAIN QUERY PLAN output to use "USING INDEX" instead of "BY INDEX", and to use "SEARCH" instead of "SCAN" for loops that are not full-table scans.

2010-11-13 16:42:27 +00:00

tkt-80ba201079.test

Add tests to tkt-80ba201079.test.

2010-12-07 07:57:49 +00:00

tkt-80e031a00f.test

Additional test cases and evidence marks for the empty RHS bug on the IN

2010-07-14 19:31:07 +00:00

tkt-94c04eaadb.test

Reset the state of the asynchronous IO module at the end of the tkt-94c04eaadb.test script.

2009-12-04 08:40:59 +00:00

tkt-752e1646fc.test

Skip flattening if subquery has LIMIT and outer query is DISTINCT. Fix for ticket 752e1646fc.

2011-02-11 20:52:20 +00:00

tkt-8454a207b9.test

Fix the handling of default values for ALTER TABLE ADD COLUMN columns so

2010-09-30 14:48:06 +00:00

tkt-31338dca7e.test

Ensure WHERE clause terms involving tables on the right end of a join

2009-12-16 22:10:49 +00:00

tkt-313723c356.test

Add a test case to verify that bug [313723c356] has been fixed.

2010-09-20 08:47:01 +00:00

tkt-3998683a16.test

Do correct affinity transformations on floating point values which have

2010-09-30 17:33:11 +00:00

tkt-b351d95f9.test

Test case and fix for the specific failure of ticket [b351d95f9cd5ef17e9d9dbae].

2010-09-28 04:14:03 +00:00

tkt-b72787b1.test

When a stale schema-cookie is seen, expire only the one statement that

2011-02-22 03:34:56 +00:00

tkt-cbd054fa6b.test

Fix OOM error on ANALYZE with STAT2 enabled with zero-length data. Ticket [cbd054fa6b].

2010-03-26 01:54:33 +00:00

tkt-d11f09d36e.test

Remove debugging code from test script.

2010-06-28 11:06:53 +00:00

tkt-d82e3f3721.test

Rename tkt-d82e3f3721.txt to use the (correct) .test suffix.

2009-12-12 13:58:18 +00:00

tkt-f3e5abed55.test

Fix a couple of test script problems.

2010-10-04 16:06:11 +00:00

tkt-f7b4edec.test

Add a test case to verify that ticket [f7b4edece25c994857] is fixed.

2011-03-19 02:04:02 +00:00

tkt-f973c7ac31.test

Fix for ticket [f973c7ac31].

2010-06-09 15:47:11 +00:00

tkt-f777251dc7a.test

Experimental fix for [f777251dc7]. This may be changed yet.

2009-10-16 14:55:03 +00:00

tkt-fc62af4523.test

Fix the tkt-fc62af4523.test to work around non-randomness of the

2010-06-17 16:08:53 +00:00

tokenize.test

Testing coverage enhancements. (CVS 5358)

2008-07-08 00:06:49 +00:00

trace2.test

Add virtual table module "fts4aux", used to inspect the full-text index of an fts4 table directly. Also add the "compress" and "uncompress" fts4 options.

2011-02-01 16:34:32 +00:00

trace.test

Fixed some TCL test cases to work if SQLITE_OMIT_TRIGGER is defined.

2009-12-17 22:12:51 +00:00

trans2.test

Add the trans2.test script designed to stress statement rollback and

2008-08-27 18:56:36 +00:00

trans3.test

The COMMIT command now works even if there are pending queries, as long

2008-11-05 16:37:34 +00:00

trans.test

Fix problems with running the async.test script.

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

trigger1.test

Changes to support recursive triggers.

2009-08-28 18:53:45 +00:00

trigger2.test

Change "PRAGMA disable_recursive_triggers" to "PRAGMA recursive_triggers". Also a fix for compiling with OMIT_TRIGGER defined.

2009-09-01 17:11:07 +00:00

trigger3.test

Check in implementation of foreign key constraints.

2009-09-19 17:00:31 +00:00

trigger4.test

Fix the trigger4 test so that it runs on windows. (CVS 3559)

2007-01-04 22:13:02 +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

Changes to test scripts so that the "inmemory_journal" permutation works with [ef126e775a].

2010-07-08 09:44:42 +00:00

trigger8.test

Changes to support recursive triggers.

2009-08-28 18:53:45 +00:00

trigger9.test

Fixes for new triggers scheme.

2009-08-30 11:42:51 +00:00

triggerA.test

Further refinements to table order selection on join query planning.

2010-04-15 01:04:54 +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

Avoid recursive calls to sqlite3VdbeMemRelease() when deleting VM frames used by trigger programs.

2010-12-01 08:04:47 +00:00

triggerD.test

When creating a trigger on a main database table when there is a TEMP table

2010-02-15 16:54:55 +00:00

tt3_checkpoint.c

Add file test/tt3_checkpoint.c that adds a multi-threaded test for blocking checkpoints to threadtest3.

2010-11-19 09:58:11 +00:00

types2.test

Clarify the documentation on how comparisons occur in an IN operator.

2007-02-23 03:00:44 +00:00

types3.test

Changes to test scripts to accommodate different architectures and different

2008-04-28 13:02:57 +00:00

types.test

Remove the sqlite3BtreeFactor() wrapper routine. All modules now call

2010-08-30 15:02:28 +00:00

unique.test

Simplifications to the uniqueness constraint failure error message

2009-05-02 15:46:46 +00:00

update.test

Enhancements to the change counter tests. Ticket #3013. (CVS 4986)

2008-04-10 18:44:36 +00:00

utf16align.test

Prevent buffer overruns when converting malformed UTF16 to UTF8. Ticket #3482. (CVS 5869)

2008-11-07 03:29:33 +00:00

vacuum2.test

Add "do_not_use_codec" logic to some of the TCL based test cases that read/write directly to the DB.

2011-02-16 01:23:50 +00:00

vacuum3.test

All the page_size pragma to change the page size on a new :memory: database,

2008-08-26 21:07:26 +00:00

vacuum4.test

Fix an assertion-fault/segfault problem that comes up when trying to

2010-02-22 23:17:42 +00:00

vacuum.test

Minor additions to vacuum.test.

2010-11-15 11:35:50 +00:00

varint.test

New varint encoding gives a maximum varint length of 9 instead of 10. (CVS 1395)

2004-05-18 15:57:42 +00:00

veryquick.test

Changes to the way tcl test scripts work. No changes to production code.

2010-06-15 06:56:37 +00:00

view.test

Add the example from #3359 to the test suite. (CVS 6027)

2008-12-14 14:45:20 +00:00

vtab1.test

Fix some segfaults that could occur in obscure circumstances where error messages contained characters that could be mistaken for printf format specifiers.

2010-10-21 15:12:44 +00:00

vtab2.test

If sqlite3_column_value() is called to obtain a value with the MEM_Static flag set, clear it and set the MEM_Ephem flag before returning. Otherwise, if the value is passed to sqlite3_bind_value() or sqlite3_result_value(), sqlite may attempt to use the buffer after the statement has been finalized. This is not always valid, as MEM_Static only guarantees that a MEM.z buffer will be valid for the lifetime of the owner statement, not that it is actually a static buffer. (CVS 5812)

2008-10-13 10:37:49 +00:00

vtab3.test

Remove leftover debugging commands (breakpoint and btree_breakpoint) from

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

vtab4.test

Remove leftover debugging commands (breakpoint and btree_breakpoint) from

2008-07-12 14:52:20 +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

Changes to the query planner that improve the order in which tables/indexes are scanned in join queries.

2009-08-13 07:09:33 +00:00

vtab7.test

Make sure statement journals are initiated when doing DROP operations

2007-12-04 16:54:52 +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

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

vtab_err.test

Enable threadsafe builds by default in configure. Ticket #2606.

2007-09-03 16:12:09 +00:00

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

vtabA.test

Fix an assertion fault that occurs when two different virtual tables are

2010-02-24 15:10:14 +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

Fix compilation and testing when SQLITE_OMIT_TRIGGER is defined. Ticket #3786. (CVS 6464)

2009-04-07 14:14:22 +00:00

vtabD.test

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

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

vtabE.test

Make sure registers computed for the VFilter opcode are marked invalid

2009-11-23 21:23:45 +00:00

wal2.test

Fix minor problems with the output of "PRAGMA wal_checkpoint". In both code and tests.

2011-02-02 19:17:39 +00:00

wal3.test

Merge in the blocking-checkpoint enhancement, including the new

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

wal4.test

Fix a problem with wal4.test caused by changes in the previous checkin.

2010-07-16 11:10:25 +00:00

wal5.test

Change blocking-checkpoint tests so that they run once using "PRAGMA wal_checkpoint" and once using calls to sqlite3_wal_checkpoint_v2(). Also fix edge cases surrounding the output variables set by wal_checkpoint_v2().

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

wal6.test

Added TCL test case for converting to WAL mode with multiple connections.

2010-12-01 20:49:42 +00:00

wal_common.tcl

Add experimental command "PRAGMA wal_blocking_checkpoint", which uses the busy-handler to block until all readers have finished in order to ensure the next writer will be able to wrap around to the start of the log file.

2010-11-16 18:56:51 +00:00

wal.test

Fixes for SQLITE_BUSY handling in blocking checkpoint code.

2010-11-18 19:28:01 +00:00

walbak.test

Do not attempt to open a WAL file for an in-memory or temporary database. Even if the database header suggests that it is a WAL database.

2010-07-03 08:01:24 +00:00

walbig.test

Fix a problem with writing to databases larger than 2^32 bytes with WAL mode.

2010-07-07 09:48:44 +00:00

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

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

walcrash.test

Fix test case number issue in walcrash.test.

2010-07-08 16:22:05 +00:00

walfault.test

Fix some test cases in walfault.test. Extend one test case to restore code coverage. Add wal5.test to the "coverage-wal" permutation.

2011-02-07 16:24:39 +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 walmode.test so that all tests pass with SQLITE_TEMP_STORE=3.

2010-09-13 19:03:38 +00:00

walnoshm.test

Add test cases to restore coverage of pager.c and wal.c.

2010-11-01 18:45:08 +00:00

walshared.test

Changes to support building with SQLITE_OMIT_WAL.

2010-08-24 18:35:12 +00:00

walslow.test

Add the "PRAGMA wal_autocheckpoint" command. Rename "PRAGMA checkpoint" to "PRAGMA wal_checkpoint".

2010-05-03 11:05:08 +00:00

walthread.test

If an attempt to get a read-lock on the WAL fails with SQLITE_BUSY_RECOVER, call the busy-handler at the btree level.

2010-06-01 14:12:45 +00:00

where2.test

Avoid assertion faults in queries using indices with redundant columns.

2010-04-30 21:03:24 +00:00

where3.test

Merge the stat2 query planner enhancements into the trunk.

2011-02-04 06:36:44 +00:00

where4.test

Fix compilation/testing with OMIT_SUBQUERY defined. Ticket #2828. (CVS 4603)

2007-12-10 05:03:46 +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

Change the EXPLAIN QUERY PLAN output to use "USING INDEX" instead of "BY INDEX", and to use "SEARCH" instead of "SCAN" for loops that are not full-table scans.

2010-11-13 16:42:27 +00:00

where8.test

Further refinements to table order selection on join query planning.

2010-04-15 01:04:54 +00:00

where8m.test

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

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

where9.test

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

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

where.test

Fix a bug reported on the mailing list triggered by the pattern "SELECT <col>, (SELECT ... FROM tbl WHERE rowid > <col>) FROM ...". (CVS 5855)

2008-11-03 09:06:05 +00:00

whereA.test

Make sure internal queries are well ordered, even when the

2010-01-12 23:54:14 +00:00

whereB.test

Tweak to the new whereB.test file to make it more consistent.

2009-08-13 19:54:26 +00:00

wherelimit.test

Further simplifications of the code for the LIMIT clause on an UPDATE or DELETE. Added a few test cases to wherelimit.test. (CVS 5797)

2008-10-10 18:25:45 +00:00

zeroblob.test

Make sure the IN operator works with zeroblobs. Ticket #3965.

2009-07-14 02:33:02 +00:00