Home
last modified time | relevance | path

Searched refs:parent (Results 1 – 25 of 46) sorted by relevance

12

/sqlite-3.40.0/test/
H A De_fkey.test750 # parent table does not exist, or The parent key columns named in the
904 # <parent-table>.
1051 # of the parent key is modified or a new row is inserted into the parent
1351 CREATE TABLE parent(x, y);
1670 # the parent table (ON DELETE), or modifying the parent key values of
2255 SELECT * FROM parent;
2345 UPDATE parent SET x = 22;
2352 DELETE FROM parent;
2355 UPDATE parent SET x = 22;
2368 # values of the parent key are modified so that the new parent key
[all …]
H A Dcrashtest1.c27 static void do_some_sql(int parent){ in do_some_sql() argument
46 kill(parent, SIGKILL); in do_some_sql()
60 kill(parent, SIGKILL); in do_some_sql()
72 int parent = getpid(); in main() local
87 do_some_sql(parent); in main()
H A Dfkey8.test176 INSERT INTO t2 VALUES(1, 'one', 'one', 'one', 'one'); -- row is parent of self
177 INSERT INTO t2 VALUES(2, 'one', 'one', 'one', NULL); -- parent is row 1
204 CREATE TABLE parent(
209 FOREIGN KEY(c) REFERENCES parent(p) DEFERRABLE INITIALLY DEFERRED
213 INSERT INTO parent VALUES('123');
221 INSERT INTO parent VALUES(1200);
224 UPDATE parent SET p = '456' WHERE p=1200;
H A Dwhere3.test301 fk INTEGER DEFAULT NULL, parent INTEGER,
306 CREATE INDEX aaa_222 ON aaa (parent, position);
314 CREATE INDEX bbb_222 ON bbb (parent, position);
319 FROM aaa JOIN bbb ON bbb.id = aaa.parent
322 AND bbb.parent = 4
332 FROM aaa JOIN aaa AS bbb ON bbb.id = aaa.parent
335 AND bbb.parent = 4
345 FROM bbb JOIN aaa ON bbb.id = aaa.parent
348 AND bbb.parent = 4
358 FROM aaa AS bbb JOIN aaa ON bbb.id = aaa.parent
[all …]
H A Dthread001.test78 #sqlthread parent {puts STARTING..}
82 #sqlthread parent "puts \"OPEN $::DB\""
101 #sqlthread parent "puts \"CLOSE $::DB\""
104 #sqlthread parent "puts \"DONE\""
H A Dfkey7.test88 CREATE TABLE parent(
92 c UNIQUE REFERENCES parent(p)
109 INSERT INTO parent VALUES(123);
H A Dshell6.test97 CREATE TABLE parent (id INTEGER PRIMARY KEY);
98 CREATE TABLE child2 (id INT PRIMARY KEY, parentID INT REFERENCES parent)
101 CREATE INDEX 'child2_parentID' ON 'child2'('parentID'); --> parent(id)
H A Dvt02.c188 sqlite3_vtab parent; /* Base clase. Must be first. */ member
203 sqlite3_vtab_cursor parent; /* Base class. Must be first */ member
245 *ppVTab = &pVtab->parent; in vt02Connect()
277 *ppCursor = &pCur->parent; in vt02Open()
H A Dfkey2.test236 # Use a collation sequence on the parent key.
248 # Use the parent key collation even if it is default and the child key
289 parent REFERENCES node DEFERRABLE INITIALLY DEFERRED
293 parent REFERENCES node DEFERRABLE INITIALLY DEFERRED
300 fkey2-2-test 4 0 "UPDATE node SET parent = NULL"
307 fkey2-2-test 10 0 "UPDATE node SET parent = 1 WHERE nodeid = 2"
377 catchsql "INSERT INTO node SELECT parent, 3 FROM leaf"
451 parent REFERENCES t1 ON DELETE CASCADE
453 CREATE TABLE t2(node PRIMARY KEY, parent);
455 DELETE FROM t2 WHERE parent = old.node;
[all …]
H A Dwithout_rowid3.test236 # Use a collation sequence on the parent key.
248 # Use the parent key collation even if it is default and the child key
289 parent REFERENCES node DEFERRABLE INITIALLY DEFERRED
293 parent REFERENCES node DEFERRABLE INITIALLY DEFERRED
300 without_rowid3-2-test 4 0 "UPDATE node SET parent = NULL"
377 catchsql "INSERT INTO node SELECT parent, 3 FROM leaf"
451 parent REFERENCES t1 ON DELETE CASCADE
453 CREATE TABLE t2(node PRIMARY KEY, parent) WITHOUT rowid;
455 DELETE FROM t2 WHERE parent = old.node;
692 # "rowid" cannot be used as part of a child or parent key definition
[all …]
H A Dfkey1.test160 parent REFERENCES t11 ON DELETE CASCADE
167 # would have been the parent of the new row being inserted. Causing an
207 # on the parent table.
H A Dlock6.test50 # 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
H A Dfkey3.test85 # inserting rows into tables that have foreign keys where the parent
181 INSERT INTO TestTable VALUES (1, 'parent', 1, null);
H A Dfkey5.test290 lappend res [list $table $rowid $fkid $parent]
362 # Tests 9.* verify that missing parent tables are handled correctly.
396 # PRIMARY KEY as the parent key.
H A Dfuzz.test110 # extra value on the VDBE stack. This is confusing the parent and
131 # clause was flattened into the parent, but the code was not repairng
H A Dfts3ac.test36 …will now respect the minimum volume and volume increment settings on the parent product. See rules…
38 ? If the transaction volume on the child is less than half of the parent''s minimum volume no hedge…
39 …e than half the parent''s minimum volume but less than half the volume increment on the parent, th…
40 …er volumes, the same rounding rules will apply based on the volume increment on the parent product.
H A Dfts2c.test36 …will now respect the minimum volume and volume increment settings on the parent product. See rules…
38 ? If the transaction volume on the child is less than half of the parent''s minimum volume no hedge…
39 …e than half the parent''s minimum volume but less than half the volume increment on the parent, th…
40 …er volumes, the same rounding rules will apply based on the volume increment on the parent product.
H A Dfts1c.test36 …will now respect the minimum volume and volume increment settings on the parent product. See rules…
38 ? If the transaction volume on the child is less than half of the parent''s minimum volume no hedge…
39 …e than half the parent''s minimum volume but less than half the volume increment on the parent, th…
40 …er volumes, the same rounding rules will apply based on the volume increment on the parent product.
/sqlite-3.40.0/tool/
H A Dgenfkey.README16 the "child" table corresponds to a row in the "parent" table. For
19 CREATE TABLE parent(a, b, c, PRIMARY KEY(a, b));
23 "parent" for which the expression (child.d==parent.a AND child.e==parent.b)
24 is true. The columns in the parent table are required to be either the
38 (child.d==parent.a AND child.e==parent.b)
58 or updated to match the new parent key values (if the parent
69 a parent table has a composite primary key, then any child table
71 the following definition of table "parent":
73 CREATE TABLE parent(a, b, c, PRIMARY KEY(a, b));
103 a foreign key that refers to a parent table that does not exist, or
[all …]
H A Dfragck.tcl66 a(parent) \
116 if {$ci(parent)} {
124 while {$ci(parent)} {
H A Dshowdb.c864 int parent, /* Parent of this page. 0 for root pages */ in page_usage_btree() argument
881 }else if( parent<0 ){ in page_usage_btree()
893 if( parent<0 ) return; in page_usage_btree()
903 if( parent>0 ){ in page_usage_btree()
905 zType, zName, idx, parent, zEntry); in page_usage_btree()
906 }else if( parent==0 ){ in page_usage_btree()
955 int parent = 1; in page_usage_freelist() local
958 page_usage_msg(pgno, "freelist trunk #%d child of %d", cnt, parent); in page_usage_freelist()
968 parent = pgno; in page_usage_freelist()
H A Dgenfkey.test332 CREATE TABLE parent("a.1", PRIMARY KEY("a.1"));
333 CREATE TABLE child("b.2", FOREIGN KEY("b.2") REFERENCES parent("a.1"));
340 INSERT INTO parent VALUES(1);
343 catchsql { UPDATE parent SET "a.1"=0 }
350 SELECT * FROM parent;
/sqlite-3.40.0/src/
H A Dtest_thread.c38 Tcl_ThreadId parent; /* Thread id of parent thread */ member
107 Tcl_ThreadQueueEvent(p->parent, (Tcl_Event *)pEvent, TCL_QUEUE_TAIL); in postToParent()
108 Tcl_ThreadAlert(p->parent); in postToParent()
203 pNew->parent = Tcl_GetCurrentThread(); in sqlthread_spawn()
253 Tcl_ThreadQueueEvent(p->parent, (Tcl_Event *)pEvent, TCL_QUEUE_TAIL); in sqlthread_parent()
254 Tcl_ThreadAlert(p->parent); in sqlthread_parent()
/sqlite-3.40.0/ext/rtree/
H A Drtreedoc3.test170 foreach {rParentScore parent} [pq_extract] {}
171 array set P $parent ;# "Parent" - as in parent of expected cell
/sqlite-3.40.0/ext/rbu/
H A Drbu3.test144 # parent VFS is unknown.

12