Lines Matching refs:key

28 # without_rowid3-1.*: Simple tests to check that immediate and deferred foreign key 
35 #            immediate foreign key constraint is violated.
46 # without_rowid3-7.*: Test using an IPK as the key in the child (referencing) table.
48 # without_rowid3-8.*: Test that enabling/disabling foreign key support while a 
64 # without_rowid3-15.*: Test that if there are no (known) outstanding foreign key 
143                             {1 {foreign key mismatch - "t10" referencing "t9"}}
204 # Special test: When the parent key is an IPK, make sure the affinity of
205 # the IPK is not applied to the child key value before it is inserted
220 # Same test using a regular primary key with integer affinity.
236 # Use a collation sequence on the parent key.
248 # Use the parent key collation even if it is default and the child key
270 # deferred foreign key constraint logic works.
365 # multiple rows violates some foreign key constraints, then strikes a 
390 # Test cases without_rowid3-3.* test that a program that executes foreign key
443 # Test cases without_rowid3-4.* test that recursive foreign key actions 
500 # write to a foreign key column while foreign-keys are enabled.
509       INSERT INTO t2 VALUES('key', 'hello');
535 # Test that it is possible to use an INT PRIMARY KEY as the child key
667 # The following tests, without_rowid3-10.*, test "foreign key mismatch" and 
689   } {/1 {foreign key mismatch - "c" referencing "."}/}
692 # "rowid" cannot be used as part of a child or parent key definition 
701 } {1 {unknown column "rowid" in foreign key definition}}
717 } {1 {foreign key mismatch - "t2" referencing "t1"}}
911 # TABLE" commands work as expected wrt foreign key constraints.
1236 } {1 {foreign key mismatch - "cc" referencing "pp"}}
1638   # An insert on the parent table must read the child key of any deferred
1639   # foreign key constraints. But not the child key of immediate constraints.
1647   # parent key columns (to see if it is a violation or not).
1835 # by the shell tool. So these tests show that the built-in foreign key