Home
last modified time | relevance | path

Searched refs:KEY (Results 1 – 25 of 550) sorted by relevance

12345678910>>...22

/sqlite-3.40.0/test/
H A Dfkey8.test29 CREATE TABLE p1(a PRIMARY KEY);
34 CREATE TABLE p1(a PRIMARY KEY);
38 CREATE TABLE p1(a PRIMARY KEY);
42 CREATE TABLE p1(a PRIMARY KEY);
47 CREATE TABLE p1(a PRIMARY KEY);
55 CREATE TABLE p1(a PRIMARY KEY);
61 CREATE TABLE p1(a PRIMARY KEY);
134 x PRIMARY KEY,
171 a PRIMARY KEY, b, c, d, e,
186 c1 PRIMARY KEY,
[all …]
H A Dfkey2.test92 CREATE TABLE t1(a PRIMARY KEY, b);
95 CREATE TABLE t3(a PRIMARY KEY, b);
218 } {1 {FOREIGN KEY constraint failed}}
288 nodeid PRIMARY KEY,
292 cellid PRIMARY KEY,
450 node PRIMARY KEY,
619 c INTEGER PRIMARY KEY,
691 CREATE TABLE p(a PRIMARY KEY, b);
852 PRIMARY KEY(c34, c35)
1860 FOREIGN KEY (h, i)
[all …]
H A Dwithout_rowid3.test218 } {1 {FOREIGN KEY constraint failed}}
288 nodeid PRIMARY KEY,
292 cellid PRIMARY KEY,
450 node PRIMARY KEY,
605 c INT PRIMARY KEY,
833 PRIMARY KEY(c34, c35)
1406 # FOREIGN KEY constraints.
1413 PRIMARY KEY (e,c),
1452 PRIMARY KEY (a,b),
1922 FOREIGN KEY (h, i)
[all …]
H A Dfkey3.test46 } {1 {FOREIGN KEY constraint failed}}
52 } {1 {FOREIGN KEY constraint failed}}
98 } {1 {FOREIGN KEY constraint failed}}
101 } {1 {FOREIGN KEY constraint failed}}
108 } {1 {FOREIGN KEY constraint failed}}
116 } {1 {FOREIGN KEY constraint failed}}
130 } {1 {FOREIGN KEY constraint failed}}
152 } {1 {FOREIGN KEY constraint failed}}
155 } {1 {FOREIGN KEY constraint failed}}
166 } {1 {FOREIGN KEY constraint failed}}
[all …]
H A Dwithout_rowid5.test55 word TEXT PRIMARY KEY,
70 word TEXT PRIMARY KEY,
80 word TEXT PRIMARY KEY,
90 word TEXT PRIMARY KEY,
119 # PRIMARY KEY.
166 # a PRIMARY KEY column.
203 PRIMARY KEY(a,b)
220 PRIMARY KEY(a,b)
238 PRIMARY KEY(a,b)
253 PRIMARY KEY(a,b)
[all …]
H A Dschema6.test80 CREATE TABLE t1(a INTEGER PRIMARY KEY, b UNIQUE);
89 CREATE TABLE t1(a INTEGER PRIMARY KEY ASC, b UNIQUE);
92 CREATE TABLE t1(a INTEGER PRIMARY KEY, b);
96 CREATE TABLE t1(a INTEGER PRIMARY KEY, b);
102 CREATE TABLE t1(a INTEGER PRIMARY KEY UNIQUE, b UNIQUE);
105 CREATE TABLE t1(a INTEGER UNIQUE PRIMARY KEY, b UNIQUE);
111 CREATE TABLE t1(a INTEGER UNIQUE PRIMARY KEY, b);
115 CREATE TABLE t1(a INTEGER UNIQUE PRIMARY KEY, b);
143 CREATE TABLE t1(a INTEGER PRIMARY KEY, b) WITHOUT ROWID;
147 CREATE TABLE t1(a INTEGER PRIMARY KEY, b) WITHOUT ROWID;
[all …]
H A De_fkey.test59 CREATE TABLE p(i PRIMARY KEY);
95 CREATE TABLE p(i PRIMARY KEY);
162 CREATE TABLE p(i PRIMARY KEY);
232 } {1 {FOREIGN KEY constraint failed}}
286 } {1 {FOREIGN KEY constraint failed}}
290 } {1 {FOREIGN KEY constraint failed}}
304 } {1 {FOREIGN KEY constraint failed}}
521 CREATE TABLE par(p PRIMARY KEY);
1168 CREATE TABLE p(x PRIMARY KEY);
1321 CREATE TABLE ll(k PRIMARY KEY);
[all …]
H A Dfuzz-oss1.test478 CREATE TABLE "nao:Tag" (ID INTEGER NOT NULL PRIMARY KEY,
509 KEY, "ncal:dir" INTEGER, "ncal:dir:graph" INTEGER,
561 KEY, "ncal:range" INTEGER, "ncal:range:graph" INTEGER,
605 KEY, "ncal:tzoffsetfrom" TEXT COLLATE NOCASE,
609 CREATE TABLE "ncal:Todo" (ID INTEGER NOT NULL PRIMARY KEY,
769 PRIMARY KEY);
774 KEY, "nco:logo" INTEGER, "nco:logo:graph" INTEGER);
841 CREATE TABLE "nfo:Audio" (ID INTEGER NOT NULL PRIMARY KEY,
907 CREATE TABLE "nfo:Font" (ID INTEGER NOT NULL PRIMARY KEY,
1203 CREATE TABLE "nmo:Call" (ID INTEGER NOT NULL PRIMARY KEY,
[all …]
H A Dfkey1.test30 a INTEGER PRIMARY KEY,
42 x INTEGER PRIMARY KEY,
52 FOREIGN KEY (a,b) REFERENCES t2(x,y)
77 CREATE TABLE t5(a PRIMARY KEY, b, c);
91 FOREIGN KEY (d, e) REFERENCES t5(a, b)
159 x INTEGER PRIMARY KEY,
172 } {1 {FOREIGN KEY constraint failed}}
193 Id INTEGER PRIMARY KEY,
203 } {1 {FOREIGN KEY constraint failed}}
254 CREATE TABLE sqlsim4(stat PRIMARY KEY);;
[all …]
H A Dunique2.test43 1 {CREATE TABLE t1(x TEXT PRIMARY KEY, y NOT NULL) WITHOUT ROWID}
44 2 {CREATE TABLE t1(x TEXT PRIMARY KEY, y NOT NULL)}
45 3 {CREATE TABLE t1(x TEXT PRIMARY KEY, y) WITHOUT ROWID}
46 4 {CREATE TABLE t1(x TEXT PRIMARY KEY, y)}
60 6 {CREATE TABLE t1(w,x,y NOT NULL,z NOT NULL,PRIMARY KEY(w,x))}
61 7 {CREATE TABLE t1(w,x,y NOT NULL,z,PRIMARY KEY(w,x)) WITHOUT ROWID}
62 8 {CREATE TABLE t1(w,x,y NOT NULL,z,PRIMARY KEY(w,x))}
64 10 {CREATE TABLE t1(w,x,y,z NOT NULL,PRIMARY KEY(w,x))}
65 11 {CREATE TABLE t1(w,x,y,z,PRIMARY KEY(w,x)) WITHOUT ROWID}
66 12 {CREATE TABLE t1(w,x,y,z,PRIMARY KEY(w,x))}
[all …]
H A Dshell6.test25 CREATE TABLE p1(a PRIMARY KEY, b);
32 CREATE TABLE p1(a PRIMARY KEY, b);
40 CREATE TABLE 'p 1'(a, b, c, PRIMARY KEY(c, b));
41 CREATE TABLE 'c 1'(x, y, z, FOREIGN KEY (z, y) REFERENCES 'p 1');
47 CREATE TABLE p1(a, 'b b b' PRIMARY KEY);
54 CREATE TABLE p1(a, 'b b b' PRIMARY KEY);
63 CREATE TABLE y1(a, b, c, FOREIGN KEY(b, a) REFERENCES x1(a, b));
77 CREATE TABLE x1(a PRIMARY KEY COLLATE nocase, b);
85 CREATE TABLE y1(d, e, f, FOREIGN KEY(d, e, f) REFERENCES x1);
92 CREATE TABLE c1(x INTEGER PRIMARY KEY REFERENCES p1(b));
[all …]
H A Dautoinc.test49 CREATE TABLE t1(x INTEGER PRIMARY KEY AUTOINCREMENT, y);
308 CREATE TABLE t3(g INTEGER PRIMARY KEY AUTOINCREMENT, h);
501 # on a separate PRIMARY KEY designation.
518 CREATE TABLE t8(x TEXT PRIMARY KEY AUTOINCREMENT);
534 x INTEGER PRIMARY KEY AUTOINCREMENT
540 x INTEGER PRIMARY KEY AUTOINCREMENT
558 CREATE TABLE t2(x INTEGER PRIMARY KEY AUTOINCREMENT, y);
560 CREATE TABLE t3(a INTEGER PRIMARY KEY AUTOINCREMENT, b);
863 CREATE TABLE t1(i INTEGER PRIMARY KEY AUTOINCREMENT, j);
864 CREATE TABLE t2(i INTEGER PRIMARY KEY AUTOINCREMENT, j);
[all …]
H A Dparser1.test20 a TEXT PRIMARY KEY,
22 FOREIGN KEY(b COLLATE nocase DESC) REFERENCES t1(a COLLATE binary ASC)
34 a TEXT PRIMARY KEY,
36 FOREIGN KEY(b) REFERENCES t1(a)
41 a TEXT PRIMARY KEY,
43 FOREIGN KEY(b COLLATE nocase) REFERENCES t1(a)
56 a TEXT PRIMARY KEY,
58 FOREIGN KEY(b ASC) REFERENCES t1(a)
88 CREATE TABLE t300(id INTEGER PRIMARY KEY);
90 id INTEGER PRIMARY KEY,
[all …]
H A Dfkey5.test36 CREATE TABLE p3(a TEXT PRIMARY KEY);
38 CREATE TABLE p4(a TEXT PRIMARY KEY COLLATE nocase);
46 CREATE TABLE c1(x INTEGER PRIMARY KEY references p1);
47 CREATE TABLE c2(x INTEGER PRIMARY KEY references p2);
48 CREATE TABLE c3(x INTEGER PRIMARY KEY references p3);
396 # PRIMARY KEY as the parent key.
400 CREATE TABLE p30 (id INTEGER PRIMARY KEY);
404 PRIMARY KEY(master)
442 CREATE TABLE main.t2(x TEXT PRIMARY KEY, y INT);
448 CREATE TABLE aux.t2(x TEXT PRIMARY KEY, y INT);
[all …]
H A Dupsert4.test19 1 { CREATE TABLE t1(a INTEGER PRIMARY KEY, b, c UNIQUE) }
20 2 { CREATE TABLE t1(a INT PRIMARY KEY, b, c UNIQUE) }
89 CREATE TABLE xyz(a INTEGER PRIMARY KEY, b, c, d);
94 CREATE TABLE xyz(a INT PRIMARY KEY, b, c, d);
134 CREATE TABLE abc(a INTEGER PRIMARY KEY, x, y);
138 CREATE TABLE abc(a INT PRIMARY KEY, x, y);
172 CREATE TABLE abc(a INTEGER PRIMARY KEY, x, y);
215 CREATE TABLE w1(a INT PRIMARY KEY, x, y);
227 CREATE TABLE t1(a INTEGER PRIMARY KEY, b UNIQUE, c);
230 CREATE TABLE t1(a INT PRIMARY KEY, b UNIQUE, c);
[all …]
H A Djoin9.test20 CREATE TABLE t3(id INTEGER PRIMARY KEY, w TEXT);
21 CREATE TABLE t4(id INTEGER PRIMARY KEY, x TEXT);
22 CREATE TABLE t5(id INTEGER PRIMARY KEY, y TEXT);
23 CREATE TABLE t6(id INTEGER PRIMARY KEY, z INT);
45 CREATE TABLE t3x(id INTEGER PRIMARY KEY, w TEXT);
46 CREATE TABLE t4x(id INTEGER PRIMARY KEY, x TEXT);
47 CREATE TABLE t5x(id INTEGER PRIMARY KEY, y TEXT);
48 CREATE TABLE t6x(id INTEGER PRIMARY KEY, z INT);
61 CREATE TABLE t3a(id INTEGER PRIMARY KEY, w TEXT);
67 CREATE TABLE t6a(id INTEGER PRIMARY KEY, z INT);
[all …]
H A Dwithout_rowid6.test12 # Verify that WITHOUT ROWID tables work correctly when the PRIMARY KEY
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>../}
[all …]
H A Dwithout_rowid1.test27 CREATE TABLE t1(a,b,c,d, PRIMARY KEY(c,a)) WITHOUT ROWID;
61 # Trying to insert a duplicate PRIMARY KEY fails.
163 a COLLATE nocase, b, c UNIQUE, PRIMARY KEY(b, a)
215 CREATE TABLE t3(a PRIMARY KEY);
216 CREATE TABLE t4(a PRIMARY KEY);
231 CREATE TABLE t41(a PRIMARY KEY) WITHOUT ROWID;
324 PRIMARY KEY(a),
341 b TEXT PRIMARY KEY
351 b TEXT PRIMARY KEY
446 PRIMARY KEY(c1, c1)
[all …]
H A Dtkt-b1d3a2e531.test29 CREATE TABLE pp(x PRIMARY KEY);
41 CREATE TABLE pp(x PRIMARY KEY);
54 CREATE TABLE pp(x PRIMARY KEY);
56 y INTEGER PRIMARY KEY REFERENCES pp DEFERRABLE INITIALLY DEFERRED
68 CREATE TABLE pp(x PRIMARY KEY);
70 y INTEGER PRIMARY KEY REFERENCES pp DEFERRABLE INITIALLY DEFERRED
83 CREATE TABLE pp1(x PRIMARY KEY);
86 CREATE TABLE pp2(x PRIMARY KEY);
101 } {1 {FOREIGN KEY constraint failed}}
H A Dfkey_malloc.test25 CREATE TABLE t1(a PRIMARY KEY, b UNIQUE);
40 FOREIGN KEY(x, y) REFERENCES t1(a, b) DEFERRABLE INITIALLY DEFERRED
54 CREATE TABLE t1(x INTEGER PRIMARY KEY);
73 || $msg eq "FOREIGN KEY constraint failed"
83 CREATE TABLE t1(x INTEGER PRIMARY KEY, y UNIQUE);
100 CREATE TABLE t1(x, y, PRIMARY KEY(x, y));
101 CREATE TABLE t2(a, b, FOREIGN KEY(a, b) REFERENCES t1 ON UPDATE CASCADE);
111 x PRIMARY KEY,
124 CREATE TABLE x(a, b, PRIMARY KEY(a, b));
126 FOREIGN KEY(d, c) REFERENCES x DEFERRABLE INITIALLY DEFERRED
[all …]
H A Dunionvtab.test33 CREATE TABLE t1(a INTEGER PRIMARY KEY, b TEXT);
34 CREATE TABLE t2(a INTEGER PRIMARY KEY, b TEXT);
35 CREATE TABLE aux.t3(a INTEGER PRIMARY KEY, b TEXT);
222 CREATE TABLE tbl1(a INTEGER PRIMARY KEY, b);
223 CREATE TABLE tbl2(a INTEGER PRIMARY KEY, b);
224 CREATE TABLE tbl3(a INTEGER PRIMARY KEY, b);
326 CREATE TABLE s1(k INTEGER PRIMARY KEY, v);
331 CREATE TABLE l1(k INTEGER PRIMARY KEY, v);
403 CREATE TABLE c0(one, two INTEGER PRIMARY KEY);
404 CREATE TABLE c1(one, two INTEGER PRIMARY KEY);
[all …]
/sqlite-3.40.0/ext/rbu/
H A Drbu1.test22 # CREATE TABLE t1(a INTEGER PRIMARY KEY, b, c);
39 # CREATE TABLE t1(a INTEGER PRIMARY KEY, b, c);
59 # CREATE TABLE t1(c, b, '(a)' INTEGER PRIMARY KEY);
79 # CREATE TABLE t1(a INTEGER PRIMARY KEY, b, c, d);
180 CREATE TABLE t1(a PRIMARY KEY, b, c);
311 CREATE TABLE t1(a PRIMARY KEY, b, c);
365 CREATE TABLE t1(a INT PRIMARY KEY, b, c);
495 CREATE TABLE t1(a PRIMARY KEY, b, c, d);
562 CREATE TABLE t1(a PRIMARY KEY, b);
636 CREATE TABLE t1(a PRIMARY KEY, b);
[all …]
/sqlite-3.40.0/ext/session/
H A Dsession3.test45 CREATE TABLE t1(a PRIMARY KEY, b);
74 CREATE TABLE t1(a, b PRIMARY KEY);
121 CREATE TABLE t2(a, b PRIMARY KEY);
130 CREATE TABLE t2(a, b PRIMARY KEY, c);
145 CREATE TABLE t2(a, b PRIMARY KEY, c);
151 CREATE TABLE t2(a, b PRIMARY KEY);
161 CREATE TABLE t2(a, b PRIMARY KEY, c);
178 CREATE TABLE t2(a, b PRIMARY KEY);
184 CREATE TABLE t2(a PRIMARY KEY, b);
194 CREATE TABLE t2(a, b PRIMARY KEY);
[all …]
H A DsessionD.test90 CREATE TABLE t2(a PRIMARY KEY, b);
95 CREATE TABLE aux.t2(a PRIMARY KEY, b);
114 CREATE TABLE aux.t1(x, y, PRIMARY KEY(y));
115 CREATE TABLE t1(x, y, PRIMARY KEY(y));
123 CREATE TABLE aux.t1(x, y, PRIMARY KEY(y));
124 CREATE TABLE t1(x, y, PRIMARY KEY(y));
132 CREATE TABLE aux.t1(a PRIMARY KEY, b TEXT);
133 CREATE TABLE t1(a PRIMARY KEY, b TEXT);
170 CREATE TABLE t1(a, b, c, PRIMARY KEY(a));
203 CREATE TABLE ixua.t2(a PRIMARY KEY, b, c);
[all …]
H A Dsession2.test38 CREATE TABLE t1(a INT PRIMARY KEY, b);
243 CREATE TABLE t1(a PRIMARY KEY);
290 CREATE TABLE t1(a PRIMARY KEY);
291 CREATE TABLE t2(x, y PRIMARY KEY);
327 CREATE TABLE t2(x PRIMARY KEY, y);
404 CREATE TABLE t3(a, b PRIMARY KEY);
405 CREATE TABLE t4(a, b PRIMARY KEY);
441 CREATE TABLE t1(a PRIMARY KEY, b);
545 CREATE TABLE t1(a PRIMARY KEY, b);
548 CREATE TABLE t1(a PRIMARY KEY, b);
[all …]

12345678910>>...22