Lines Matching refs:key

27 # fkey2-1.*: Simple tests to check that immediate and deferred foreign key 
34 #            immediate foreign key constraint is violated.
45 # fkey2-7.*: Test using an IPK as the key in the child (referencing) table.
47 # fkey2-8.*: Test that enabling/disabling foreign key support while a 
63 # fkey2-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 fkey2-3.* test that a program that executes foreign key
443 # Test cases fkey2-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');
515   } {1 {cannot open foreign key column for writing}}
546 # Test that it is possible to use an INTEGER PRIMARY KEY as the child key
686 # The following tests, fkey2-10.*, test "foreign key mismatch" and 
708   } {/1 {foreign key mismatch - "c" referencing "."}/}
711 # "rowid" cannot be used as part of a child or parent key definition 
720 } {1 {unknown column "rowid" in foreign key definition}}
736 } {1 {foreign key mismatch - "t2" referencing "t1"}}
945 # TABLE" commands work as expected wrt foreign key constraints.
1261 } {1 {foreign key mismatch - "cc" referencing "pp"}}
1576   # An insert on the parent table must read the child key of any deferred
1577   # foreign key constraints. But not the child key of immediate constraints.
1585   # parent key columns (to see if it is a violation or not).
1773 # by the shell tool. So these tests show that the built-in foreign key 
2033 # 2015-04-16:  Foreign key errors propagate back up to the parser.
2045 } {1 {foreign key mismatch - "t" referencing "t0"}}