Home
last modified time | relevance | path

Searched refs:table (Results 1 – 25 of 545) sorted by relevance

12345678910>>...22

/sqlite-3.40.0/test/
H A Dtable.test20 do_test table-1.1 {
38 do_test table-1.3 {
40 } {test1 test1 table}
45 do_test table-1.4 {
49 } {test1 test1 table}
53 do_test table-1.5 {
61 do_test table-1.6 {
69 do_test table-1.10 {
73 do_test table-1.11 {
77 do_test table-1.12 {
[all …]
H A DcorruptM.test13 # sqlite_master table are validated and errors are reported if they
45 } {table t1 t1 | index i1 t1 | view v2 v2 | trigger r1 t1 |}
50 } {table t1 {} | index i1 t1 | view v2 v2 | trigger r1 t1 |}
60 } {table t1 tx | index i1 t1 | view v2 v2 | trigger r1 t1 |}
78 } {table t9 t9 | index i1 t1 | view v2 v2 | trigger r1 t1 |}
88 } {table t1 T1 | index i1 t1 | view v2 v2 | trigger r1 t1 |}
111 } {table t1 t1 | index i1 tx | view v2 v2 | trigger r1 t1 |}
122 } {table t1 t1 | table i1 t1 | view v2 v2 | trigger r1 t1 |}
133 } {table t1 t1 | view i1 t1 | view v2 v2 | trigger r1 t1 |}
145 } {table t1 t1 | index i1 t1 | table v2 v2 | trigger r1 t1 |}
[all …]
H A DcorruptF.test28 # Create a 6 page database containing a single table - t1. Table t1
73 # Now create a new table in the database file. The root of the new table
74 # is page 6, which is also the right-most leaf page in table t1.
80 table t1 t1 2 {CREATE TABLE t1(x)}
81 table t4 t4 6 {CREATE TABLE t4(x)}
86 # This statement opens a cursor on table t1 and does a full table scan. As
88 # table.
126 # Now create a new table in the database file. The root of the new table
127 # is page 5, which is also the right-most leaf page in table t1.
133 table t1 t1 2 {CREATE TABLE t1(x)}
[all …]
H A Ddelete2.test16 # removed an index entry by not the main table entry. To recreate the
19 # (1) Create a table with an index. Insert some data into that table.
20 # (2) Start a query on the table but do not complete the query.
21 # (3) Try to delete a single entry from the table.
27 # the table.
29 # The solution to the problem was to detect that the table is locked
38 # Create a table that has an index.
59 # Start a query on the table. The query should not use the index.
60 # Do not complete the query, thus leaving the table locked.
68 # Try to delete a row from the table while a read is in process.
[all …]
H A Dfts3shared.test31 # Create a virtual FTS3 table. Populate it with some initial data.
44 # a write-lock on the underlying t1_content table.
53 # on that table and so the SELECT fails.
60 } {1 {database table is locked}}
81 # table is first read/written within a transaction, not later on.
83 set LOCKED {1 {database table is locked}}
101 # from the FTS or fts4aux table.
117 # Same test as 2.2.*, except with a content= table.
132 # Test that once a connection has read from the FTS or fts4aux table,
133 # another connection may not write to the FTS table.
[all …]
H A Dvtab_alter.test28 # of the virtual table is a prefix of the name of the underlying
29 # real table (for example if the v-table is "tbl" and the real table
30 # is "tbl_base"), then the name of the real table is modified
31 # when an "ALTER TABLE ... RENAME TO" is executed on the v-table.
44 # Try to rename an echo table. Make sure nothing terrible happens.
60 } {1 {no such table: t1echo}}
65 # Try to rename an echo table that renames its base table. Make
93 # backing store table.
H A Dtemptable.test32 # Create a permanent table.
63 } {1 {no such table: t2}}
66 } {1 {no such table: t2}}
90 } {1 {no such table: t2}}
105 } {1 {no such table: t2}}
121 } {1 {no such table: t2}}
152 # creates a permanent table also named T. The temp table in process A
153 # hides the existence of the permanent table.
223 } {1 {no such table: t2}}
289 # be updated when its corresponding table changes.
[all …]
H A Dlaststmtchanges.test34 create table t0 (x);
82 # changes() set properly after delete from table
106 create table t1 (k integer primary key);
107 create table t2 (k integer primary key, v1, v2);
215 drop table t0; drop table t1; drop table t2;
216 create temp table t0(x);
217 create temp table t1 (k integer primary key);
218 create temp table t2 (k integer primary key);
221 create temp table n1 (k integer primary key, n);
222 create temp table n2 (k integer primary key, n);
[all …]
H A Dalter.test35 # table name and left parenthesis token. i.e:
62 CREATE INDEX i2 ON [temp table](f);
63 INSERT INTO [temp table] VALUES(5,6,7);
68 SELECT * FROM [temp table];
95 table {temp table} {temp table} \
107 ALTER TABLE [temp table] RENAME to TempTab;
145 # (The TEMP table will not persist, of course.)
298 } {1 {no such table: none}}
316 } {1 {table sqlite_master may not be altered}}
865 } [list 1 "table $tbl may not be altered"]
[all …]
H A Dnotify1.test41 } {1 {database table is locked}}
72 } {1 {database table is locked}}
124 } {1 {database table is locked: t1}}
130 } {1 {database table is locked: t2}}
162 } {1 {database table is locked: t2}}
165 } {1 {database table is locked: t3}}
168 } {1 {database table is locked: t1}}
317 } {1 {database table is locked: t2}}
320 } {1 {database table is locked: t1}}
461 } {1 {database table is locked}}
[all …]
H A Dspeed2.test82 # 50000 INSERTs on an unindexed table
93 # 50000 INSERTs on an indexed table
107 # a full table scan is required.
118 # table scan is required.
131 # a full table scan is required.
142 # table scan is required.
280 # Delete all content in a table.
284 # Copy one table into another
292 # Refill the table yet again
310 # Select 20000 rows from the table at random.
[all …]
H A Dshared6.test46 } {1 {database table is locked}}
83 } {1 {database table is locked: t1}}
86 } {1 {database table is locked}}
97 } {1 {database table is locked: t1}}
122 } {1 {database table is locked}}
130 } {1 {database table is locked: t1}}
153 } {1 {database table is locked: t1}}
162 } {1 {database table is locked: t1}}
196 } {1 {database table is locked: t1}}
212 } {1 {database table is locked}}
[all …]
H A Dspeed1p.test83 # 50000 INSERTs on an unindexed table
100 # 50000 INSERTs on an indexed table
120 # a full table scan is required.
138 # table scan is required.
285 # Delete all content in a table.
289 # Copy one table into another
293 # Delete all content in a table, one row at a time.
297 # Refill the table yet again
315 # Select 20000 rows from the table at random.
321 # Delete 20000 random rows from the table.
[all …]
H A Dspeed1.test86 # 50000 INSERTs on an unindexed table
97 # 50000 INSERTs on an indexed table
111 # a full table scan is required.
124 # table scan is required.
235 # Delete all content in a table.
239 # Copy one table into another
243 # Delete all content in a table, one row at a time.
247 # Refill the table yet again
265 # Select 20000 rows from the table at random.
271 # Delete 20000 random rows from the table.
[all …]
H A Dvtab7.test13 # virtual table xSync() callback.
38 # In each case, $tablename is replaced by the name of the real table (not
81 # Write to an existing database table from within an xSync callback.
105 # Create a database table from within xSync callback.
116 # Drop a database table from within xSync callback.
131 } {1 {database table is locked}}
168 # if an attempt to write to a virtual module table or create a new
169 # virtual table from within an xSync() callback.
182 } {1 {database table is locked}}
191 } {1 {database table is locked}}
[all …]
H A Dlastinsert.test13 # Note 1: insert into table is now the only statement which changes LIRID
28 # LIRID changed properly after an insert into a table
31 create table t1 (k integer primary key);
44 create table t1w (k integer primary key) WITHOUT ROWID;
50 # LIRID unchanged after an update on a table
58 # LIRID unchanged after a delete from a table
66 # LIRID unchanged after create table/view statements
69 create table t2 (k integer primary key, val1, val2, val3);
300 drop table t1; drop table t2; drop trigger r1;
301 create temp table t1 (k integer primary key);
[all …]
H A Davtrans.test275 } {1 {no such table: one}}
283 WHERE type='table' OR type='index'
292 WHERE type='table' OR type='index'
300 WHERE type='table' OR type='index'
308 WHERE type='table' OR type='index'
320 WHERE type='table' OR type='index'
328 WHERE type='table' OR type='index'
395 } {1 {no such table: t2}}
472 } {1 {no such table: t1}}
533 } {1 {no such table: t1}}
[all …]
H A Dtrans.test313 } {1 {no such table: one}}
321 WHERE type='table' OR type='index'
330 WHERE type='table' OR type='index'
338 WHERE type='table' OR type='index'
346 WHERE type='table' OR type='index'
358 WHERE type='table' OR type='index'
366 WHERE type='table' OR type='index'
433 } {1 {no such table: t2}}
510 } {1 {no such table: t1}}
571 } {1 {no such table: t1}}
[all …]
H A Dfkey5.test16 # schema.foreign_key_check(table-name);
19 # database, or the table called "table-name", for foreign key
111 } {1 {no such table: temp.c2}}
120 # table is a WITHOUT ROWID table.
290 lappend res [list $table $rowid $fkid $parent]
395 # Test using a WITHOUT ROWID table as the child table with an INTEGER
415 # table is a WITHOUT ROWID table.
462 } {1 {no such table: main.t1}}
482 WHERE type='table'
483 ORDER BY x."table";
[all …]
H A Dautovacuum.test40 # 1. A table with a single indexed field is created.
41 # 2. Approximately 20 rows are inserted into the table. Each row is long
61 # The length of each table entry.
77 # Set up the table.
94 # Delete one set of rows from the table.
109 # Ensure the data remaining in the table is what was expected.
156 # Create a table and put some data in it.
363 # after each table is dropped (i.e. as test cases 2.5.*.[1..4]).
415 # Drop table av1:
437 # Drop table av4:
[all …]
/sqlite-3.40.0/ext/fts3/
H A DREADME.content6 database table.
12 at all (a "contentless" FTS4 table), or
41 table. Attempting to do so is an error.
68 An "external content" FTS4 table is similar to a contentless table, except
72 table"). The FTS4 module never writes to the content table, and writing
78 to the name of a table (or view, or virtual table) that may be queried by
81 a contentless table. For example:
116 -- table have been modified.
123 -- a row with rowid=3 within the content table.
164 content table, for the same reasons.
[all …]
/sqlite-3.40.0/tool/
H A Dgenfkey.README16 the "child" table corresponds to a row in the "parent" table. For
22 implies that for each row in table "child", there must be a row in
24 is true. The columns in the parent table are required to be either the
26 requirement for the columns of the child table.
40 Attempting to insert or update a row in the child table so that the
54 the child table is not allowed. An exception is thrown.
62 all corresponding child table rows are set to NULL.
69 a parent table has a composite primary key, then any child table
71 the following definition of table "parent":
89 is indirect (for example if table A references table B which references
[all …]
/sqlite-3.40.0/ext/fts5/test/
H A Dfts5content.test87 } {1 {cannot UPDATE contentless fts5 table: f1}}
106 -- Create a table. And an external content fts5 table to index it.
257 # Check that an fts5 table cannot be its own content table.
266 } {1 {recursively defined fts5 content table}}
269 } {1 {recursively defined fts5 content table}}
272 } {1 {recursively defined fts5 content table}}
275 } {1 {recursively defined fts5 content table}}
285 } {1 {recursively defined fts5 content table}}
288 } {1 {recursively defined fts5 content table}}
291 } {1 {recursively defined fts5 content table}}
[all …]
H A Dfts5rank.test172 INSERT INTO "My.Table" VALUES ('rank on an fts5 table');
174 INSERT INTO "My.Table" VALUES ('the table names.');
175 INSERT INTO "My.Table" VALUES ('table table table');
178 SELECT * FROM "My.Table" WHERE Text MATCH 'table' ORDER BY rank;
180 {table table table} {the table names.} {rank on an fts5 table}
/sqlite-3.40.0/ext/rtree/
H A Drtreedoc.test331 table demo_index_rowid
333 table demo_index_node
335 table demo_index_parent
449 # Create a regular table and an rtree table. Perform INSERT, UPDATE and
751 } {6 1 {database table is locked}}
783 } {6 1 {database table is locked}}
829 } {1 {database table is locked}}
934 # demo_data table.
943 # small subset of the entire table.
1562 # %_rowid table.
[all …]

12345678910>>...22