Lines Matching refs:key

187 #   1:         Explicit parent-key columns.
188 #   2:         Implicit child-key columns.
1119 #     key is Ok, and two or more primary keys is an error.
1129   table "t5" has more than one primary key
1159 # column definition, then the primary key for the table consists of that
1165 # a table-constraint, then the primary key of the table consists of the
1183 # EVIDENCE-OF: R-59124-61339 Each row in a table with a primary key must
1184 # have a unique combination of values in its primary key columns.
1188 # primary key values, that is a constraint violation.
1252 # uniqueness of primary key values, NULL values are considered distinct
1280 #     If the column is an integer primary key, attempting to insert a NULL
1333 # EVIDENCE-OF: R-59124-61339 Each row in a table with a primary key must
1334 # have a unique combination of values in its primary key columns.
1704 # row key if the CREATE TABLE statement does not define a real column
1742 # table has a primary key that consists of a single column and the
1749 # primary key.
1756   1   "CREATE TABLE t5(pk integer primary key)"                         1
1757   2   "CREATE TABLE t5(pk integer, primary key(pk))"                    1
1758   3   "CREATE TABLE t5(pk integer, v integer, primary key(pk))"         1
1759   4   "CREATE TABLE t5(pk integer, v integer, primary key(pk, v))"      0
1760   5   "CREATE TABLE t5(pk int, v integer, primary key(pk, v))"          0
1761   6   "CREATE TABLE t5(pk int, v integer, primary key(pk))"             0
1762   7   "CREATE TABLE t5(pk int primary key, v integer)"                  0
1763   8   "CREATE TABLE t5(pk inTEger primary key)"                         1
1764   9   "CREATE TABLE t5(pk inteGEr, primary key(pk))"                    1
1765   10  "CREATE TABLE t5(pk INTEGER, v integer, primary key(pk))"         1
1770 # key column to behave as an ordinary table column with integer affinity
1774   CREATE TABLE t6(pk INT primary key);
1775   CREATE TABLE t7(pk BIGINT primary key);
1776   CREATE TABLE t8(pk SHORT INTEGER primary key);
1777   CREATE TABLE t9(pk UNSIGNED INTEGER primary key);
1810 # key): CREATE TABLE t(x INTEGER PRIMARY KEY ASC, y, z); CREATE TABLE
1832 # using an alias created by an integer primary key.
1882 # primary key or rowid column must contain integer values. Integer
1883 # primary key or rowid columns are not able to hold floating point
1898 # integer primary key or rowid column to a NULL or blob value, or to a
1927 # converted to an integer into an integer primary key or rowid column, a
1953 # NULL value into a rowid or integer primary key column, the system