Lines Matching refs:parent

64 #             constraint violations in the database, inserting into a parent
204 # Special test: When the parent key is an IPK, make sure the affinity of
236 # 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"
386 fkey2-2-test 74 0   "INSERT INTO node(nodeid) SELECT DISTINCT parent 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;
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
1585   # parent key columns (to see if it is a violation or not).
1628   # Return SQLITE_IGNORE to requests to read from the parent table. This