sqlite

aggerror.test

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

2006-05-03 23:34:05 +00:00

all.test

Improvements to the speed tests recently added to the test suite. (CVS 3519)

2006-11-23 21:09:10 +00:00

alter2.test

Reactivate disabled "alter2" tests. (CVS 3553)

2007-01-04 14:36:01 +00:00

alter3.test

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

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

alter.test

Correctly handle COLLATE clauses in tables being modified by an

2006-02-09 02:56:02 +00:00

altermalloc.test

Fix a bug in the new misc6.test script. Fix error messages when not

2006-09-04 18:54:14 +00:00

analyze.test

The shell does not output the sqlite_stat1 table on .dump or .schema.

2005-09-10 22:40:53 +00:00

async2.test

Account for a malloc failure in the asynchronous writer thread in test_async.c (CVS 3096)

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

async.test

Increase test coverage to above 98%. (CVS 3144)

2006-03-19 13:00:25 +00:00

attach2.test

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

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

attach3.test

Modifications so that compilation and testing with the various OMIT macros defined works. (CVS 3276)

2006-06-20 11:01:07 +00:00

attach.test

Syntax errors override errors from the code generator, not the other

2006-05-25 12:17:31 +00:00

attachmalloc.test

Fix a bug in the new misc6.test script. Fix error messages when not

2006-09-04 18:54:14 +00:00

auth2.test

Enhance the sqlite3_set_authorizer() callback so that it provides callbacks

2006-08-24 14:59:45 +00:00

auth.test

Enhance the sqlite3_set_authorizer() callback so that it provides callbacks

2006-08-24 14:59:45 +00:00

autoinc.test

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

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

autovacuum_crash.test

…

autovacuum_ioerr2.test

…

autovacuum_ioerr.test

Run the tests in shared.test a second time using an autovacuum database. (CVS 2957)

2006-01-16 12:46:41 +00:00

autovacuum.test

Require whitespace or punctuation between a numeric literal and an

2006-08-12 12:33:14 +00:00

avtrans.test

Add support and documentation for the fullfsync pragma. Also include

2006-02-11 01:25:50 +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

If SQLITE_DISABLE_LFS is defined, omit the bigfile tests. (CVS 2781)

2005-11-25 09:01:23 +00:00

bigrow.test

…

bind.test

Move the sqlite3_sleep() and sqlite3_clear_bindings() interfaces into the

2006-06-27 20:06:44 +00:00

bindxfer.test

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

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

blob.test

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

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

btree2.test

Increase test coverage to above 98%. (CVS 3144)

2006-03-19 13:00:25 +00:00

btree4.test

…

btree5.test

…

btree6.test

…

btree7.test

…

btree8.test

…

btree.test

Clean up memory leaks and uninitialized variables detected by valgrind.

2007-01-03 23:37:28 +00:00

busy.test

Fix up the busy test so that it can be run multiple times in a row without

2005-09-17 18:02:36 +00:00

capi2.test

Clean up memory leaks and uninitialized variables detected by valgrind.

2007-01-03 23:37:28 +00:00

capi3.test

Clean up memory leaks and uninitialized variables detected by valgrind.

2007-01-03 23:37:28 +00:00

capi3b.test

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

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

capi3c.test

Fix a bug in sqlite3_prepare_v2() introduced by checkin (3578) and reported

2007-01-12 23:43:42 +00:00

cast.test

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

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

check.test

Modifications so that compilation and testing with the various OMIT macros defined works. (CVS 3276)

2006-06-20 11:01:07 +00:00

collate1.test

Omit the SQLITE_AFF_INTEGER type affinity. All numeric values are now

2005-11-01 15:48:24 +00:00

collate2.test

…

collate3.test

Optimizations and refinements. Improvements to test coverage. (CVS 2667)

2005-09-08 01:58:42 +00:00

collate4.test

…

collate5.test

More bug fixes. But there are still tests that fail. (CVS 2664)

2005-09-07 22:48:16 +00:00

collate6.test

…

colmeta.test

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

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

conflict.test

Clean up memory leaks and uninitialized variables detected by valgrind.

2007-01-03 23:37:28 +00:00

corrupt2.test

…

corrupt.test

…

crash.test

Change the OS interface layer to use traditional direct function call

2006-01-06 14:32:19 +00:00

crashtest1.c

…

date.test

Fix another round-off problem in strftime(). Ticket #2153 . (CVS 3574)

2007-01-08 16:19:07 +00:00

default.test

…

delete2.test

Allows UPDATE, INSERT, and DELETEs to occur while a SELECT is pending on

2006-08-16 16:42:48 +00:00

delete3.test

…

delete.test

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

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

descidx1.test

By default, new databases are now created in the legacy file format - the

2006-07-11 14:17:51 +00:00

descidx2.test

By default, new databases are now created in the legacy file format - the

2006-07-11 14:17:51 +00:00

descidx3.test

By default, new databases are now created in the legacy file format - the

2006-07-11 14:17:51 +00:00

diskfull.test

Enhanced disk-full tests. (CVS 2682)

2005-09-09 10:46:19 +00:00

distinctagg.test

Bug fix in the new COUNT(DISTINCT) logic. Ticket #1420 . (CVS 2689)

2005-09-12 23:03:16 +00:00

enc2.test

Be sure to ignore PRAGMA encoding pragmas if the encoding has already been

2006-09-23 20:36:01 +00:00

enc3.test

Automatically cast BLOBs to strings prior to handing them over to

2006-01-12 19:42:41 +00:00

enc.test

…

expr.test

Remove use of the "clock" command in the test suite so that the tests

2006-09-01 15:49:05 +00:00

fkey1.test

…

format4.test

By default, new databases are now created in the legacy file format - the

2006-07-11 14:17:51 +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

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

2006-10-19 23:28:35 +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

fts1porter.test

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

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

fts2a.test

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

2006-10-19 23:36:25 +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

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

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

fts2g.test

Test to force edge cases in query logic. Basically, exercise code to

2006-10-25 20:27:39 +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

func.test

Add the sqlite3_overload_function() API - part of the virtual table

2006-09-16 21:45:14 +00:00

hook.test

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

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

in.test

Additional tests for ticket #1821 . (CVS 3189)

2006-05-23 23:25:09 +00:00

index2.test

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

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

index3.test

…

index.test

Properly record the names of triggers even if the name is quoted.

2006-03-29 00:24:06 +00:00

insert2.test

Fix an assert or memory leak that occurs when trying to EXPLAIN a statement

2005-10-05 11:35:09 +00:00

insert3.test

Add support for INSERT INTO ... DEFAULT VALUES. Tickets #299 , #1940 . (CVS 3368)

2006-08-25 23:42:53 +00:00

insert.test

Progress toward CREATE VIRTUAL TABLE. Still not even close to working... (CVS 3211)

2006-06-11 23:41:55 +00:00

interrupt.test

Add the "interrupt" method to the TCL interface. Ticket #1889 . (CVS 3332)

2006-07-17 00:02:44 +00:00

intpkey.test

…

ioerr.test

Fix a memory leak introduced by the latest changes to pager.c. (CVS 3554)

2007-01-04 14:58:14 +00:00

join2.test

…

join3.test

…

join4.test

…

join5.test

ON-clause terms in a LEFT JOIN that restrict only the left table, should not

2005-09-19 21:05:48 +00:00

join.test

Modifications so that compilation and testing with the various OMIT macros defined works. (CVS 3276)

2006-06-20 11:01:07 +00:00

journal1.test

…

lastinsert.test

Make the last_insert_rowid method in the TCL interface work with

2006-06-21 19:30:34 +00:00

laststmtchanges.test

…

like.test

Add tests for the new MATCH operator. (CVS 3238)

2006-06-14 08:48:25 +00:00

limit.test

Modifications so that compilation and testing with the various OMIT macros defined works. (CVS 3276)

2006-06-20 11:01:07 +00:00

loadext2.test

Add the new experimental sqlite3_auto_extension() API. (CVS 3362)

2006-08-23 20:07:20 +00:00

loadext.test

Add the new experimental sqlite3_auto_extension() API. (CVS 3362)

2006-08-23 20:07:20 +00:00

lock2.test

Fix a bug in the lock2 test script introduced by check-in (2709) (CVS 2711)

2005-09-17 16:48:18 +00:00

lock3.test

…

lock.test

Allows UPDATE, INSERT, and DELETEs to occur while a SELECT is pending on

2006-08-16 16:42:48 +00:00

main.test

Allow '@' to introduce host parameter names for compatibility with

2006-02-09 22:24:41 +00:00

malloc2.test

Fix a bug in the new misc6.test script. Fix error messages when not

2006-09-04 18:54:14 +00:00

malloc3.test

Fixes for OMIT_UTF16 and OMIT_COMPOUND (CVS 2993)

2006-01-23 07:52:37 +00:00

malloc4.test

Fixes for OMIT_UTF16 and OMIT_COMPOUND (CVS 2993)

2006-01-23 07:52:37 +00:00

malloc5.test

Account for read-uncommitted cursors in sqlite3BtreeClearTable(). (CVS 2977)

2006-01-19 08:43:31 +00:00

malloc6.test

Fix a file descriptor leak following malloc failure on DROP TABLE IF EXISTS. (CVS 3296)

2006-06-26 12:50:09 +00:00

malloc7.test

Fix an overzealous assert() in the UTF-16 to UTF-8 converter. (CVS 3338)

2006-07-26 14:57:30 +00:00

malloc.test

Fix a problems that arise if malloc() fails while compiling SELECT

2006-10-18 23:26:38 +00:00

manydb.test

Prepare for the release of version 3.3.0. (CVS 2913)

2006-01-11 01:08:34 +00:00

memdb.test

Memory DB works with autovacuum. (CVS 3041)

2006-01-30 22:48:44 +00:00

memleak.test

…

minmax.test

SQLite now always chooses the column names for compound selects using

2006-03-26 01:21:22 +00:00

misc1.test

Move the sqlite3_sleep() and sqlite3_clear_bindings() interfaces into the

2006-06-27 20:06:44 +00:00

misc2.test

Make sure memory does not leak when patching up column names so that

2006-09-29 14:01:04 +00:00

misc3.test

…

misc4.test

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

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

misc5.test

Clean up memory leaks and uninitialized variables detected by valgrind.

2007-01-03 23:37:28 +00:00

misc6.test

Fix a bug in the new misc6.test script. Fix error messages when not

2006-09-04 18:54:14 +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

notnull.test

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

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

null.test

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

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

pager2.test

…

pager3.test

…

pager.test

Further coverage improvements for pager.c and another IO error bug fix. (CVS 3001)

2006-01-23 15:25:48 +00:00

pagesize.test

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

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

pragma.test

Adjustments to the pragma test for OS-X. (CVS 3615)

2007-01-27 14:26:07 +00:00

printf.test

Increase test coverage to above 98%. (CVS 3144)

2006-03-19 13:00:25 +00:00

progress.test

Allow SQL statements to be executed from within a progress callback.

2006-05-26 19:57:19 +00:00

quick.test

Improvements to the speed tests recently added to the test suite. (CVS 3519)

2006-11-23 21:09:10 +00:00

quote.test

Omit the SQLITE_AFF_INTEGER type affinity. All numeric values are now

2005-11-01 15:48:24 +00:00

reindex.test

…

rollback.test

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

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

rowid.test

…

safety.test

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

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

schema2.test

First cut at adding the sqlite3_prepare_v2() API. Test cases added, but

2006-11-09 00:24:53 +00:00

schema.test

Some elements of the new malloc() failure handling. Not all cases work properly yet. Also, library is not threadsafe if malloc() fails right now. (CVS 2800)

2005-12-06 12:52:59 +00:00

select1.test

Allow constant terms in the ORDER BY or GROUP BY clauses. Ticket #1768 . (CVS 3173)

2006-04-11 14:16:21 +00:00

select2.test

…

select3.test

Allow constant terms in the ORDER BY or GROUP BY clauses. Ticket #1768 . (CVS 3173)

2006-04-11 14:16:21 +00:00

select4.test

Modifications so that compilation and testing with the various OMIT macros defined works. (CVS 3276)

2006-06-20 11:01:07 +00:00

select5.test

Fix more problems with malloc() and IO failures. (CVS 2985)

2006-01-21 12:08:54 +00:00

select6.test

Improvements to the new performance tests. (CVS 3526)

2006-11-30 13:06:00 +00:00

select7.test

Make sure the names of all expressions in compound SELECT statements used

2006-10-13 15:34:16 +00:00

server1.test

Documentation updates. Fix to date.c. But most importantly: database

2006-01-15 00:13:15 +00:00

shared2.test

Add omittest.tcl script to automate testing compile-time OMIT symbols. (CVS 3031)

2006-01-26 13:11:36 +00:00

shared3.test

When opening a new connection on a shared cache, be careful not to

2006-05-24 12:43:26 +00:00

shared_err.test

Handle errors in saving cursor positions during a rollback by aborting all active statements. (CVS 3027)

2006-01-24 16:37:57 +00:00

shared.test

Fix the shared pager tests so that they work under windows. (CVS 3013)

2006-01-23 21:38:03 +00:00

sort.test

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

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

speed1.test

Improvements to the new performance tests. (CVS 3526)

2006-11-30 13:06:00 +00:00

subquery.test

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

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

subselect.test

The SUM() aggregate function returns an integer result if all inputs are

2005-09-08 10:37:01 +00:00

sync.test

Add support and documentation for the fullfsync pragma. Also include

2006-02-11 01:25:50 +00:00

table.test

Remove use of the "clock" command in the test suite so that the tests

2006-09-01 15:49:05 +00:00

tableapi.test

Fix a test case that changed due to (3560). Ticket #2143 (CVS 3561)

2007-01-05 00:14:27 +00:00

tclsqlite.test

Remove use of the "clock" command in the test suite so that the tests

2006-09-01 15:49:05 +00:00

temptable.test

More test script changes to get it to run without -DSQLITE_MEMDEBUG. (CVS 3018)

2006-01-24 00:15:15 +00:00

tester.tcl

Fix a memory leak introduced by the latest changes to pager.c. (CVS 3554)

2007-01-04 14:58:14 +00:00

thread1.test

…

thread2.test

Omit thread2.test if memory-management is enabled at compile time. (CVS 2975)

2006-01-18 18:33:42 +00:00

threadtest1.c

…

threadtest2.c

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

2007-01-05 01:58:26 +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

Changes to get tests to pass with OMIT_VIRTUALTABLE. Ticket #1877 . (CVS 3318)

2006-06-28 18:18:09 +00:00

tkt1514.test

Do not allow aggregate functions in a WHERE clause. Ticket #1514 . (CVS 2769)

2005-11-16 12:53:15 +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

Modifications so that compilation and testing with the various OMIT macros defined works. (CVS 3276)

2006-06-20 11:01:07 +00:00

tkt1873.test

Prevent databases from being DETACHed while they are in use. Fix for #1873 . (CVS 3312)

2006-06-27 16:34:56 +00:00

tkt2141.test

Fix for ticket #2141 . (CVS 3552)

2007-01-04 01:20:28 +00:00

tkt2192.test

Fix a (harmless) assertion fault on nested views where the inner views

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

trace.test

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

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

trans.test

Modifications so that compilation and testing with the various OMIT macros defined works. (CVS 3276)

2006-06-20 11:01:07 +00:00

trigger1.test

Add support for IF EXISTS on CREATE/DROP TRIGGER/VIEW. Ticket #1899 . (CVS 3406)

2006-09-11 23:45:48 +00:00

trigger2.test

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

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

trigger3.test

…

trigger4.test

Fix the trigger4 test so that it runs on windows. (CVS 3559)

2007-01-04 22:13:02 +00:00

trigger5.test

…

trigger6.test

…

trigger7.test

…

trigger8.test

The parser now permits very large triggers - triggers with 10000 or more

2006-02-27 22:22:27 +00:00

types2.test

Fix type coercion rules for the IN operator. Ticket #1821 . (CVS 3188)

2006-05-23 23:22:29 +00:00

types3.test

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

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

types.test

All tests pass even if compiled with -DSQLITE_DEFAULT_FILE_FORMAT=1. (CVS 3308)

2006-06-27 12:51:12 +00:00

unique.test

…

update.test

…

utf16.test

Disable the alter2.test on utf16 since the results of that test only

2007-01-04 16:37:03 +00:00

utf16align.test

Or the SQLITE_UTF16_ALIGNED with the encoding field in

2006-02-16 18:16:36 +00:00

vacuum2.test

Test file fixes for libaries compiled with various SQLITE_OMIT_ macros. (CVS 2961)

2006-01-16 16:24:25 +00:00

vacuum.test

Tests cases automatically remove many of their temporary files. (CVS 3463)

2006-10-04 11:55:49 +00:00

varint.test

…

view.test

Add support for IF EXISTS on CREATE/DROP TRIGGER/VIEW. Ticket #1899 . (CVS 3406)

2006-09-11 23:45:48 +00:00

vtab1.test

When an automatic re-prepare occurs, take care not to reset the internal

2007-01-09 14:01:13 +00:00

vtab2.test

Add vdbeaux.c to the list of files that must be compiled with -DSQLITE_TEST=1

2006-08-13 19:04:18 +00:00

vtab3.test

Modifications so that compilation and testing with the various OMIT macros defined works. (CVS 3276)

2006-06-20 11:01:07 +00:00

vtab4.test

Fix bugs in test scripts so that fulltest will pass. (CVS 3390)

2006-09-02 22:14:59 +00:00

vtab5.test

Add tests to make sure altering or adding an index to a virtual table is prohibited. (CVS 3280)

2006-06-21 12:36:25 +00:00

vtab6.test

Changes to get tests to pass with OMIT_VIRTUALTABLE. Ticket #1877 . (CVS 3318)

2006-06-28 18:18:09 +00:00

vtab7.test

Disallow writing to, creating or dropping virtual tables from within xSync() callbacks. (CVS 3339)

2006-07-26 16:22:14 +00:00

vtab9.test

Bug fix: Get INSERT INTO ... SELECT working when the target is a virtual

2006-08-29 18:46:14 +00:00

vtab_err.test

Update the vtab_err test to check for -DSQLITE_MEMDEBUG=1 and skip the tests

2007-01-02 18:41:54 +00:00

where2.test

Fix a bug in the optimizer that was causing it to miss an OR optimization

2006-11-06 15:10:05 +00:00

where3.test

Query optimizer enhancement: In "FROM a,b,c left join d" allow the C table

2006-12-16 16:25:15 +00:00

where4.test

Fix an additional problem with the IS NULL optimization on LEFT JOINs.

2007-01-25 16:56:06 +00:00

where.test

The query optimizer does a better job of optimizing out ORDER BY clauses

2006-12-20 03:24:19 +00:00