Lines Matching refs:primary
22 # Create a table with a primary key and a datatype other than
31 # There should be an index associated with the primary key
40 # Now create a table with an integer primary key and verify that
52 # Insert some records into the new table. Specify the primary key
72 # Attempting to insert a duplicate primary key should give a constraint
102 # the integer primary key.
120 # Make sure SELECT statements are able to use the primary key column
129 # Try to insert a non-integer value into the primary key field. This
161 # Check to make sure indices work correctly with integer primary keys
251 # Create indices that include the integer primary key as one of their
301 # Test inequality constraints on integer primary keys and rowids
382 # table that contains an integer primary key.
449 # Check insert of NULL for primary key
473 # to reference an integer primary key.