Lines Matching refs:primary

24 # Create a table with a primary key and a datatype other than
33 # There should be an index associated with the primary key
42 # Now create a table with an integer primary key and verify that
54 # Insert some records into the new table.  Specify the primary key
74 # Attempting to insert a duplicate primary key should give a constraint
104 # the integer primary key.
122 # Make sure SELECT statements are able to use the primary key column
131 # Try to insert a non-integer value into the primary key field.  This
163 # Check to make sure indices work correctly with integer primary keys
253 # Create indices that include the integer primary key as one of their
303 # Test inequality constraints on integer primary keys and rowids
384 # table that contains an integer primary key.
451 # Check insert of NULL for primary key
475 # to reference an integer primary key.