| /sqlite-3.40.0/ext/rtree/ |
| H A D | rtree1.test | 22 # Test plan:
29 # rtree-4.*: Test INSERT
30 # rtree-5.*: Test DELETE
31 # rtree-6.*: Test UPDATE
32 # rtree-7.*: Test renaming an r-tree table.
181 # Test cases rtree-2.*
371 # Test cases rtree-8.*
422 # Test cases rtree-9.*
424 # Test that ticket #3549 is fixed.
463 # Test last_insert_rowid().
[all …]
|
| H A D | rtree3.test | 30 # Test summary:
32 # rtree3-1: Test OOM in simple CREATE TABLE, INSERT, DELETE and SELECT
35 # rtree3-2: Test OOM in a DROP TABLE command.
37 # rtree3-3a: Test OOM during a transaction to insert 100 pseudo-random rows.
39 # rtree3-3b: Test OOM during a transaction deleting all entries in the
46 # rtree3-5: Test OOM while inserting rows into a big table.
48 # rtree3-6: Test OOM while deleting all rows of a table, one at a time.
52 # rtree3-8: Test OOM while registering the r-tree module with sqlite.
|
| /sqlite-3.40.0/test/ |
| H A D | avfs.test | 15 # avfs-1.0. Test that an appendvfs DB can be added to an empty (ZLF) file.
16 # avfs-1.1. Test that the DB can be read with correct content upon reopen.
17 # avfs-1.2. Test that an appendvfs DB can be added to a simple text file.
18 # avfs-1.3. Test that the DB can be read with correct content upon reopen.
19 # avfs-1.4. Test that appended DB is aligned to default page boundary.
20 # avfs-2.1. Test that the simple text file retains its initial text.
23 # avfs-3.3. Test that appendvfs can grow by many pages and be written.
24 # avfs-3.4. Test that grown appendvfs can be reopened and appear intact.
25 # avfs-3.5. Test that much grown appendvfs can shrink and reopen intact.
26 # avfs-4.1. Test shell's ability to append to a non-appendvfs file.
[all …]
|
| H A D | fts2token.test | 41 # Test cases fts2token-1.* are the warm-body test for the SQL scalar
49 # 3: Test that the value returned for tokenizer 'blah' is now the
52 # 4: Test that it is now possible to create an fts2 table using
55 # 5: Test that the table created to use tokenizer 'blah' is usable.
87 # Test cases fts2token-2.* test error cases in the scalar function based
97 # Test cases fts2token-3.* test the three built-in tokenizers with a
120 # Test cases fts2token-4.* test the ICU tokenizer. In practice, this
135 do_icu_test fts2token-4.2 en_US {Test cases fts2} [list \
136 0 test Test 1 cases cases 2 fts2 fts2
|
| H A D | shell2.test | 17 # Test plan:
51 # Test a problem reported on the mailing list. The shell was at one point
73 # Test with echo off
82 # Test with echo on using command line option
94 # Test with echo on using dot command
107 # Test with echo on using dot command and
121 # Test with echo on using dot command and
150 # Test with echo on and headers on using dot command and
185 # Test for rejection of incomplete input at EOF.
|
| H A D | fts3b.test | 117 # Test that the table-named column still works.
124 # Test that the column doesn't appear when selecting all columns.
131 # Test that the column doesn't conflict with inserts that don't name
150 # Test that docid is present and identical to rowid.
157 # Test that docid is hidden.
164 # Test that docid can be selected.
171 # Test that docid can be used in WHERE.
178 # Test that the column doesn't conflict with inserts that don't name
187 # Test that the docid can be forced on insert.
195 # Test that rowid can also be forced.
|
| H A D | fts4merge.test | 35 # Test cases 1.*
76 # Test cases 2.* test that errors in the xxx part of the 'merge=xxx' are
96 # Test cases 3.*
122 # Test cases 4.*
168 # Test cases 5.*
170 # Test that if a crisis-merge occurs that disrupts an ongoing incremental
259 # Test cases 6.*
291 # Test cases 7.*
293 # Test that the value returned by sqlite3_total_changes() increases by
332 # Test cases 8.* - ticket [bf1aab89].
|
| H A D | fts3atoken.test | 43 # Test cases fts3atoken-1.* are the warm-body test for the SQL scalar
51 # 3: Test that the value returned for tokenizer 'blah' is now the
54 # 4: Test that it is now possible to create an fts3 table using
57 # 5: Test that the table created to use tokenizer 'blah' is usable.
156 # Test cases fts3atoken-2.* test error cases in the scalar function based
166 # Test cases fts3atoken-3.* test the three built-in tokenizers with a
190 # Test cases fts3atoken-4.* test the ICU tokenizer. In practice, this
205 do_icu_test fts3atoken-4.2 en_US {Test cases fts3} [list \
206 0 test Test 1 cases cases 2 fts3 fts3
262 # Test empty tokenizer names.
|
| H A D | func6.test | 12 # Test cases for the sqlite_offset() function.
117 # Test the sanity of the tests.
133 # Test offsets within table b-tree t1.
143 # Test offsets within index b-tree t1a.
148 # Test offsets within table b-tree t1 with a temp b-tree ORDER BY.
153 # Test offsets from both index t1a and table t1 in the same query.
160 # Test offsets from both index t1bc and table t1 in the same query.
169 # Test offsets in WITHOUT ROWID table t2.
|
| H A D | io.test | 25 # Test summary:
27 # io-1.* - Test that quick-balance does not journal pages unnecessarily.
29 # io-2.* - Test the "atomic-write optimization".
31 # io-3.* - Test the IO traffic enhancements triggered when the
35 # io-4.* - Test the IO traffic enhancements triggered when the
40 # io-5.* - Test that the default page size is selected and used
125 # Test cases io-2.* test the atomic-write optimization.
164 # Test that the journal file is not created and the change-counter is
333 # Test a couple of the more specific IOCAP_ATOMIC flags
381 # Test cases io-3.* test the IOCAP_SEQUENTIAL optimization.
[all …]
|
| H A D | alter4.test | 30 # Test Organisation:
33 # alter4-1.*: Test that ALTER TABLE correctly modifies the CREATE TABLE sql.
34 # alter4-2.*: Test error messages.
35 # alter4-3.*: Test adding columns with default value NULL.
36 # alter4-4.*: Test adding columns with default values other than NULL.
37 # alter4-5.*: Test adding columns to tables in ATTACHed databases.
38 # alter4-6.*: Test that temp triggers are not accidentally dropped.
39 # alter4-7.*: Test that VACUUM resets the file-format.
304 # Test that the table schema is correctly reloaded when a column
359 # Test that a default value equal to -1 multipied by the smallest possible
|
| H A D | ctime.test | 20 # Test organization:
22 # ctime-1.*: Test pragma support.
23 # ctime-2.*: Test function support.
32 # ctime-1.*: Test pragma support.
132 # ctime-2.*: Test function support.
247 # Test that SQLITE_DIRECT_OVERFLOW_READ is reflected in the output of
|
| H A D | fts3ak.test | 29 # Test that possibly-buffered inserts went through after commit.
40 # Test that buffered inserts are seen by selects in the same
52 # Test that buffered inserts are seen within a transaction. This is
72 # Test it all together.
83 # Test that the obvious case works.
|
| H A D | fts2k.test | 29 # Test that possibly-buffered inserts went through after commit.
40 # Test that buffered inserts are seen by selects in the same
52 # Test that buffered inserts are seen within a transaction. This is
72 # Test it all together.
83 # Test that the obvious case works.
|
| H A D | fts4check.test | 37 # Test cases 1.*
80 # Test cases 2.*
114 # Test cases 3.*
159 # Test case 4.*
161 # Test that the integrity-check works if there are "notindexed" columns.
187 # Test case 5.*
189 # Test that the integrity-check works if there is uncommitted data.
|
| H A D | errmsg.test | 11 # Test that if sqlite3_prepare_v2() is used to prepare a query, the
22 # Test organization:
54 # Test error messages returned by user-defined SQL functions.
70 # Test error messages generated directly by VDBE code (e.g. constraint
93 # Test SQLITE_SCHEMA errors. And, for _v2(), test that if the schema
|
| H A D | backup.test | 22 # Test organization:
26 # backup-2.*: Test backup under various conditions. To and from in-memory
31 # backup-4.*: Test various error conditions.
33 # backup-5.*: Test the source database being modified during a backup.
35 # backup-6.*: Test the backup_remaining() and backup_pagecount() APIs.
37 # backup-7.*: Test SQLITE_BUSY and SQLITE_LOCKED errors.
39 # backup-8.*: Test multiple simultaneous backup operations.
41 # backup-9.*: Test that passing a negative argument to backup_step() is
44 # backup-10.*: Test writing the source database mid backup.
182 puts -nonewline "Test $iTest: src=$zSrcFile dest=$zDestFile"
[all …]
|
| H A D | uri.test | 16 # Test organization:
22 # 5.*: Test using a different VFS with an attached database.
23 # 6.*: Test that authorities other than "" and localhost cause errors.
24 # 7.*: Test that a read-write db can be attached to a read-only connection.
33 # Test that file names are correctly extracted from URIs.
103 # Test that URI query parameters are passed through to the VFS layer
154 # Test that specifying a non-existent VFS raises an error.
161 # Test some of the other options (other than "vfs").
237 # Test that things work if an ATTACHed database uses a different VFS than
|
| H A D | alter3.test | 36 # Test Organisation:
39 # alter3-1.*: Test that ALTER TABLE correctly modifies the CREATE TABLE sql.
40 # alter3-2.*: Test error messages.
41 # alter3-3.*: Test adding columns with default value NULL.
42 # alter3-4.*: Test adding columns with default values other than NULL.
43 # alter3-5.*: Test adding columns to tables in ATTACHed databases.
44 # alter3-6.*: Test that temp triggers are not accidentally dropped.
45 # alter3-7.*: Test that VACUUM resets the file-format.
306 # Test that the table schema is correctly reloaded when a column
|
| H A D | notify1.test | 27 # Warm body test. Test that an unlock-notify callback can be registered
102 # Test for simple deadlock involving two database connections.
137 # Test for slightly more complex deadlock involving three database
277 # Test cases notify1-6.* test cases where the following occur:
279 # notify1-6.1.*: Test encountering an SQLITE_LOCKED error when the
283 # notify1-6.2.*: Test encountering an SQLITE_LOCKED error when already
286 # notify1-6.3.*: Test that if an SQLITE_LOCKED error is encountered while
376 # Test cases notify1-7.* tests that when more than one distinct
411 # Test cases notify1-8.* tests that the correct SQLITE_LOCKED extended
441 # Test cases notify1-9.* test the shared-cache 'pending-lock' feature.
|
| H A D | vacuum.test | 240 CREATE TABLE Test (TestID int primary key);
241 INSERT INTO Test VALUES (NULL);
242 CREATE VIEW viewTest AS SELECT * FROM Test;
246 INSERT INTO tempTest SELECT TestID, 1 FROM Test;
247 DROP TABLE Test;
248 CREATE TABLE Test(TestID int primary key, Test2 int NULL);
249 INSERT INTO Test SELECT * FROM tempTest;
388 # Test that "PRAGMA count_changes" does not interfere with VACUUM or cause
|
| H A D | tkt3357.test | 24 insert into a(b_id, myvalue) values(1,'Test');
40 } {1 1 Test btest 2 1 Test2 btest 3 1 Test3 btest}
51 } {1 1 Test 2 1 Test2 3 1 Test3}
62 } {1 1 Test 2 1 Test2 3 1 Test3}
|
| H A D | incrblob3.test | 32 # Test the sqlite3_blob_reopen()/read()/write() functions.
56 # Test some error conditions.
108 # Test that passing NULL to sqlite3_blob_XXX() APIs returns SQLITE_MISUSE.
131 # Test out-of-range reading and writing
158 # Test that modifying the row a blob handle points to aborts the blob.
169 # Test various errors that can occur in sqlite3_blob_open():
241 # Test that sqlite3_blob_open() handles transient and persistent schema
|
| H A D | symlink.test | 31 # Test that SQLite follows symlinks when opening files.
59 # Test that if the symlink points to a file that does not exists, it is
77 # Test that a loop of symlinks cannot be opened.
86 # Test that overly large paths cannot be opened.
99 # Test that journal and wal files are created next to the real file,
159 # Test that relative symlinks that are not located in the cwd work.
|
| /sqlite-3.40.0/ext/rbu/ |
| H A D | rbu3.test | 35 # Test that for an RBU to be applied, no corruption results if the
59 # Test that NULL values may not be inserted into INTEGER PRIMARY KEY
95 # Test that missing columns are detected.
143 # Test that sqlite3rbu_create_vfs() returns an error if the requested
160 # Test that it is an error to specify an explicit VFS that does not
174 # Test a large rbu update to ensure that wal_autocheckpoint does not get
|