Lines Matching refs:KEY

12 # Verify that WITHOUT ROWID tables work correctly when the PRIMARY KEY
24   CREATE TABLE t1(a,b,c,d,e, PRIMARY KEY(a,b,c,a,b,c,d,a,b,c)) WITHOUT ROWID;
48 # subsequently converted into a PRIMARY KEY.
56     PRIMARY KEY(b)
67 } {/SEARCH t1 USING PRIMARY KEY .b>../}
76     b PRIMARY KEY,
86 } {/SEARCH t1 USING PRIMARY KEY .b>../}
95     b UNIQUE PRIMARY KEY,
104 } {/SEARCH t1 USING PRIMARY KEY .b>../}
113     PRIMARY KEY(b,c)
124 } {/SEARCH t1 USING PRIMARY KEY .b>../}
130   CREATE TABLE t6(a,b,c,PRIMARY KEY(a,rowid,b))WITHOUT ROWID;