Home
last modified time | relevance | path

Searched refs:child (Results 1 – 25 of 55) sorted by relevance

123

/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
23 "parent" for which the expression (child.d==parent.a AND child.e==parent.b)
26 requirement for the columns of the child table.
33 must be true for every row of the child table in the above example is
36 (child.d IS NULL) OR
37 (child.e IS NULL) OR
38 (child.d==parent.a AND child.e==parent.b)
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.
[all …]
H A Dshowdb.c913 u32 child; in page_usage_btree() local
928 child = decodeInt32(a+ofst); in page_usage_btree()
929 page_usage_btree(child, pgno, i, zName); in page_usage_btree()
931 child = decodeInt32(a+cellstart-4); in page_usage_btree()
932 page_usage_btree(child, pgno, i, zName); in page_usage_btree()
963 int child = decodeInt32(a + (i*4+8)); in page_usage_freelist() local
964 page_usage_msg(child, "freelist leaf, child %d of trunk page %d", in page_usage_freelist()
H A Dgenfkey.test333 CREATE TABLE child("b.2", FOREIGN KEY("b.2") REFERENCES parent("a.1"));
341 INSERT INTO child VALUES(1);
346 catchsql { UPDATE child SET "b.2"=7 }
351 SELECT * FROM child;
/sqlite-3.40.0/test/
H A De_fkey.test507 # for each row in the child table either one or more of the child key
510 # associated child key column.
1035 # SELECT rowid FROM <child-table> WHERE <child-key> = :parent_key_value
1041 # SELECT rowid FROM <child-table> WHERE <child-key> = :parent_key_value
1048 # SELECT rowid FROM <child-table> WHERE <child-key> = :parent_key_value
1089 execsql {DROP TABLE child}
1353 CREATE TABLE child(a, b,
1797 SELECT * FROM child;
2248 SELECT * FROM child;
2332 CREATE TABLE child(
[all …]
H A Dfkey7.test91 CREATE TABLE child(
97 INSERT OR FAIL INTO child VALUES(123), (123);
101 SELECT * FROM child;
110 INSERT OR FAIL INTO child VALUES(123), (123);
111 } {1 {UNIQUE constraint failed: child.c}}
114 SELECT * FROM child;
H A DcorruptB.test55 # Set the right-child of a B-Tree rootpage to refer to the root-page itself.
67 # Set the left-child of a cell in a B-Tree rootpage to refer to the
100 # Set the right-child pointer of the right-child of the root page to point
114 # Set the left-child pointer of a cell of the right-child of the root page to
142 # Set the left-child pointer of a cell of the right-child of the root page to
H A Dcrash.test76 } {1 {child process exited abnormally}}
85 } {1 {child process exited abnormally}}
93 } {1 {child process exited abnormally}}
152 } {1 {child process exited abnormally}}
160 } {1 {child process exited abnormally}}
199 } {1 {child process exited abnormally}}
249 } {1 {child process exited abnormally}}
281 } {1 {child process exited abnormally}}
304 } {1 {child process exited abnormally}}
366 } {1 {child process exited abnormally}}
[all …]
H A Dlock6.test22 # 'testfixture' to execute a command. The child testfixture process is shut
34 # Execute a command in a child testfixture process, connected by two-way
49 # Write the main loop for the child testfixture processes into file
50 # tf_main2.tcl. The parent (this script) interacts with the child processes
51 # via a two way pipe. The parent writes a script to the stdin of the child
52 # process, followed by the word "OVER" on a line of its own. The child
H A Dwalcrash.test49 } {1 {child process exited abnormally}}
62 } {1 {child process exited abnormally}}
86 } {1 {child process exited abnormally}}
99 } {1 {child process exited abnormally}}
128 # } {1 {child process exited abnormally}}
157 } {1 {child process exited abnormally}}
200 } {1 {child process exited abnormally}}
242 } {1 {child process exited abnormally}}
284 } {1 {child process exited abnormally}}
H A DcorruptJ.test12 # Corruption consisting of a database page that thinks it is a child
42 # Corrupt the root page of the t1 table such that the left-child pointer
67 # The table is three levels deep. Corrupt the left child of an intermediate
H A Dwalcrash4.test42 set msg "child killed: unknown signal"
44 set msg "child process exited abnormally"
H A Dfkey8.test207 CREATE TABLE child(
212 INSERT INTO child VALUES(123);
223 INSERT INTO child VALUES(456);
H A Dcrash7.test76 } {1 {child process exited abnormally}}
111 } {1 {child process exited abnormally}}
H A Dcorrupt.test199 # by a cell retrieved from the child page (a leaf) of the deleted cell.
201 # child page of the deleted cell is from a table (intkey) b-tree, not an
286 # to run. After copying the contents of the root page to the new child,
287 # btreeInitPage() is called on the child. This time, it detects corruption
H A Dcrash8.test71 } {1 {child process exited abnormally}}
110 } {1 {child process exited abnormally}}
305 } {1 {child process exited abnormally}}
326 } {1 {child process exited abnormally}}
H A Dcrash4.test90 set c [list 1 {child process exited abnormally}]
93 } {1 {child process exited abnormally}}
H A Dcrash2.test103 } {1 {child process exited abnormally}}
126 } {1 {child process exited abnormally}}
H A Dfkey3.test86 # table is the same as the child table. Especially cases where the
182 INSERT INTO TestTable VALUES (2, 'child', 1, 1);
H A Dfkey2.test45 # fkey2-7.*: Test using an IPK as the key in the child (referencing) table.
65 # table or deleting from a child table does not cause SQLite
205 # the IPK is not applied to the child key value before it is inserted
206 # into the child table.
248 # Use the parent key collation even if it is default and the child key
546 # Test that it is possible to use an INTEGER PRIMARY KEY as the child key
711 # "rowid" cannot be used as part of a child or parent key definition
1576 # An insert on the parent table must read the child key of any deferred
1584 # An insert on the child table of an immediate constraint must read the
1592 # As must an insert on the child table of a deferred constraint.
[all …]
H A Dwithout_rowid3.test46 # without_rowid3-7.*: Test using an IPK as the key in the child (referencing) table.
66 # table or deleting from a child table does not cause SQLite
205 # the IPK is not applied to the child key value before it is inserted
206 # into the child table.
248 # Use the parent key collation even if it is default and the child key
535 # Test that it is possible to use an INT PRIMARY KEY as the child key
692 # "rowid" cannot be used as part of a child or parent key definition
1638 # An insert on the parent table must read the child key of any deferred
1646 # An insert on the child table of an immediate constraint must read the
1654 # As must an insert on the child table of a deferred constraint.
[all …]
H A DcorruptN.test267 -- Set the root of table t2 to 137 - the leftmost child of the root of t1.
274 -- Run an UPDATE on t1 that will hit a child of page 136. Have the trigger
H A Dwritecrash.test48 if {[string match {1 {child killed:*}} $res]} {
H A Dfkey5.test119 # that contains the invalid REFERENCES clause, or NULL if the child
395 # Test using a WITHOUT ROWID table as the child table with an INTEGER
414 # that contains the invalid REFERENCES clause, or NULL if the child
/sqlite-3.40.0/ext/repair/test/
H A Dcheckfreelist01.test65 } {{leaf page 10092 is out of range (child 3 of trunk page 4860)}}
74 } {{leaf page 0 is out of range (child 3 of trunk page 4860)}}
83 } {{leaf page 0 is out of range (child 247 of trunk page 5)}}
/sqlite-3.40.0/ext/rtree/
H A Drtreedoc3.test34 # For internal (non-leaf) nodes, the rowid is replaced by the child node
165 # node (a subtree), then the next child of that node is passed to the
169 # xQueryCallback being called on a child - as is happening here.

123