Home
last modified time | relevance | path

Searched refs:CREATE (Results 1 – 25 of 118) sorted by relevance

12345

/illumos-gate/usr/src/tools/smatch/src/smatch_data/db/
H A Dbuild_early_index.sh14 CREATE INDEX caller_fn_idx on caller_info (function, call_id);
15 CREATE INDEX caller_ff_idx on caller_info (file, function, call_id);
16 CREATE INDEX common_fn_idx on common_caller_info (function, call_id);
17 CREATE INDEX common_ff_idx on common_caller_info (file, function, call_id);
18 CREATE INDEX call_implies_fn_idx on call_implies (function);
19 CREATE INDEX call_implies_ff_idx on call_implies (file, function);
20 CREATE INDEX return_implies_fn_idx on return_implies (function);
21 CREATE INDEX return_implies_ff_idx on return_implies (file, function);
22 CREATE INDEX data_file_info_idx on data_info (file, data);
23 CREATE INDEX data_info_idx on data_info (data);
[all …]
/illumos-gate/usr/src/lib/libsqlite/test/
H A Dtrigger2.test57 {CREATE TEMP TABLE tbl (a, b);}
58 {CREATE TABLE tbl (a, b);}
59 {CREATE TABLE tbl (a INTEGER PRIMARY KEY, b);}
60 {CREATE TEMPORARY TABLE tbl (a INTEGER PRIMARY KEY, b);}
61 {CREATE TABLE tbl (a, b PRIMARY KEY);}
62 {CREATE TABLE tbl (a, b); CREATE INDEX tbl_idx ON tbl(b);}
63 {CREATE TEMP TABLE tbl (a, b); CREATE INDEX tbl_idx ON tbl(b);}
80 CREATE TABLE rlog (idx, old_a, old_b, db_sum_a, db_sum_b, new_a, new_b);
81 CREATE TABLE clog (idx, old_a, old_b, db_sum_a, db_sum_b, new_a, new_b);
83 CREATE TRIGGER before_update_row BEFORE UPDATE ON tbl FOR EACH ROW
[all …]
H A Dmain.test76 CREATE TABLE abc(x,y);
81 CREATE TRIGGER xyz AFTER DELETE abc BEGIN UPDATE pqr;
86 CREATE TRIGGER xyz AFTER DELETE abc BEGIN UPDATE pqr; END;
91 CREATE TRIGGER xyz AFTER DELETE abc BEGIN
98 CREATE TRIGGER xyz AFTER DELETE backend BEGIN
104 CREATE TRIGGER xyz AFTER DELETE end BEGIN
110 CREATE TRIGGER xyz AFTER DELETE end BEGIN
117 CREATE TRIGGER xyz AFTER DELETE end BEGIN
125 CREATE TRIGGER xyz AFTER DELETE [;end;] BEGIN
131 CREATE TRIGGER xyz AFTER DELETE backend BEGIN
[all …]
H A Dtable.test13 # focus of this file is testing the CREATE TABLE statement.
24 CREATE TABLE test1 (
32 } {{CREATE TABLE test1 (
72 execsql {CREATE TABLE "create" (f1 int)}
80 execsql {CREATE TABLE test1("f1 ho" int)}
93 execsql {CREATE TABLE TEST2(one text)}
94 set v [catch {execsql {CREATE TABLE test2(two text)}} msg]
98 set v [catch {execsql {CREATE TABLE sqlite_master(two text)}} msg]
104 set v [catch {execsql {CREATE TABLE sqlite_master(two text)}} msg]
114 execsql {CREATE TABLE test2(one text); CREATE INDEX test3 ON test2(one)}
[all …]
H A Dtrigger1.test14 # 1. CREATE and DROP TRIGGER tests
36 CREATE TRIGGER trig UPDATE ON no_such_table BEGIN
43 CREATE TEMP TRIGGER trig UPDATE ON no_such_table BEGIN
50 CREATE TABLE t1(a);
53 CREATE TRIGGER tr1 INSERT ON t1 BEGIN
59 CREATE TRIGGER tr1 DELETE ON t1 BEGIN
68 CREATE TRIGGER tr2 INSERT ON t1 BEGIN
71 CREATE TRIGGER tr2 INSERT ON t1 BEGIN
79 CREATE TRIGGER tr1 DELETE ON t1 BEGIN
108 CREATE TEMP TABLE temp_table(a);
[all …]
H A Dview.test21 CREATE TABLE t1(a,b,c);
32 CREATE VIEW v1 AS SELECT a,b FROM t1;
44 CREATE VIEW v1 AS SELECT a,b FROM t1;
63 CREATE VIEW v1 AS SELECT a,b FROM t1;
75 CREATE TABLE t1(x,a,b,c);
92 CREATE VIEW v2 AS SELECT * FROM t1 WHERE a>5
140 CREATE VIEW v1 AS SELECT a AS 'xyz', b+c AS 'pqr', c-b FROM t1;
146 CREATE VIEW v3 AS SELECT a FROM t1 UNION SELECT b FROM t1 ORDER BY b;
152 CREATE VIEW v4 AS
184 CREATE INDEX i1v1 ON v1(xyz);
[all …]
H A Dindex.test13 # focus of this file is testing the CREATE INDEX statement.
23 execsql {CREATE TABLE test1(f1 int, f2 int, f3 int)}
24 execsql {CREATE INDEX index1 ON test1(f1)}
30 } {index1 {CREATE INDEX index1 ON test1(f1)} test1 index}
36 } {index1 {CREATE INDEX index1 ON test1(f1)} test1 index}
53 set v [catch {execsql {CREATE INDEX index1 ON test1(f1)}} msg]
61 execsql {CREATE TABLE test1(f1 int, f2 int, f3 int)}
62 set v [catch {execsql {CREATE INDEX index1 ON test1(f4)}} msg]
69 set v [catch {execsql {CREATE INDEX index1 ON test1(f1, f2, f4, f3)}} msg]
81 execsql {CREATE TABLE test1(f1 int, f2 int, f3 int, f4 int, f5 int)}
[all …]
H A Dvacuum.test35 CREATE TABLE t1(a INTEGER PRIMARY KEY, b, c);
45 CREATE INDEX i1 ON t1(b,c);
46 CREATE TABLE t2 AS SELECT * FROM t1;
66 CREATE TABLE t2 AS SELECT * FROM t1;
67 CREATE TABLE t3 AS SELECT * FROM t1;
68 CREATE VIEW v1 AS SELECT b, c FROM t3;
69 CREATE TRIGGER r1 AFTER DELETE ON t2 BEGIN
101 CREATE TABLE t4 AS SELECT * FROM t1;
102 CREATE TABLE t5 AS SELECT * FROM t1;
154 CREATE TABLE Test (TestID int primary key);
[all …]
H A Dattach.test29 CREATE TABLE t1(a,b);
38 CREATE TABLE t2(x,y);
210 CREATE TABLE tx(x1,x2,y1,y2);
211 CREATE TRIGGER r1 AFTER UPDATE ON t2 FOR EACH ROW BEGIN
225 CREATE TABLE tx(x1,x2,y1,y2);
255 CREATE INDEX i2 ON t2(x);
383 CREATE TABLE t3(x,y);
384 CREATE UNIQUE INDEX t3i1 ON t3(x);
391 CREATE TABLE t3(a,b);
392 CREATE UNIQUE INDEX t3i1b ON t3(a);
[all …]
H A Dmisc2.test26 CREATE TABLE FOO(bar integer);
27 CREATE TRIGGER foo_insert BEFORE INSERT ON foo BEGIN
44 CREATE TABLE t1(a,b,c);
46 CREATE TABLE t2(a,b,c);
53 CREATE VIEW v1 AS SELECT * FROM t1, t2;
110 CREATE TABLE x(a,b);
111 CREATE VIEW y AS
113 CREATE VIEW z AS
127 CREATE TABLE t1(a,b);
142 CREATE TABLE t1(x);
[all …]
H A Dtrigger3.test19 catchsql { CREATE TABLE tbl (a, b, c) }
22 CREATE TRIGGER before_tbl_insert BEFORE INSERT ON tbl BEGIN SELECT CASE
26 CREATE TRIGGER after_tbl_insert AFTER INSERT ON tbl BEGIN SELECT CASE
94 execsql {CREATE TABLE tbl (a, b, c);}
98 CREATE TRIGGER before_tbl_update BEFORE UPDATE ON tbl BEGIN
102 CREATE TRIGGER before_tbl_delete BEFORE DELETE ON tbl BEGIN
120 execsql {CREATE TABLE tbl2(a, b, c)}
122 CREATE TRIGGER after_tbl2_insert AFTER INSERT ON tbl2 BEGIN
136 execsql {CREATE VIEW tbl_view AS SELECT * FROM tbl}
138 CREATE TRIGGER tbl_view_insert INSTEAD OF INSERT ON tbl_view BEGIN
H A Dunique.test13 # focus of this file is testing the CREATE UNIQUE INDEX statement,
26 CREATE TABLE t1(
35 CREATE TABLE t1(
82 CREATE TABLE t2(a int, b int);
90 CREATE UNIQUE INDEX i2 ON t2(a)
126 CREATE UNIQUE INDEX i2 ON t2(a);
131 CREATE INDEX i2 ON t2(a);
140 CREATE TABLE t3(
174 CREATE TABLE t4(a UNIQUE, b, c, UNIQUE(b,c));
207 CREATE TABLE t5(
H A Dtrans.test26 CREATE TABLE one(a int PRIMARY KEY, b text);
35 CREATE TABLE two(a int PRIMARY KEY, b text);
261 execsql {CREATE TABLE one(a text, b int)}
282 # Test commits and rollbacks of table CREATE TABLEs, CREATE INDEXs
295 CREATE TABLE t1(a int, b int, c int);
303 CREATE INDEX i1 ON t1(a);
320 CREATE TABLE t2(a int, b int, c int);
321 CREATE INDEX i2a ON t2(a);
322 CREATE INDEX i2b ON t2(b);
358 CREATE TABLE t2(x int, y int, z int);
[all …]
H A Dtemptable.test31 execsql {CREATE TABLE t1(a,b,c);}
51 CREATE TEMP TABLE t2(x,y,z);
93 CREATE TEMPORARY TABLE t2(x,y);
105 CREATE TEMPORARY TABLE t2(x,y);
123 CREATE INDEX i2 ON t2(x);
140 CREATE INDEX i2 ON t2(x);
153 CREATE TEMP TABLE t2(x,y);
160 CREATE TABLE t2(x,y,z);
224 CREATE TEMP TABLE t2(x unique,y);
231 CREATE TABLE t2(x unique, y);
[all …]
H A Dmisc1.test26 set cmd "CREATE TABLE manycol(x0 text"
64 execsql {CREATE INDEX manycol_idx1 ON manycol(x99)}
92 CREATE TABLE agger(one text, two text, three text, four text);
117 CREATE TABLE t1(a);
131 CREATE TABLE t2(a);
151 CREATE TABLE t3(a,b);
173 CREATE TABLE t4(
201 CREATE TABLE error1(
209 CREATE TABLE error1(
217 CREATE TABLE t5(a,b,c,PRIMARY KEY(a,b));
[all …]
H A Dversion.test28 CREATE TABLE t1(x);
97 CREATE INDEX i1 ON t1(x);
99 CREATE TABLE t2(a INTEGER PRIMARY KEY, b UNIQUE, c);
100 CREATE TABLE cnt(name,ins, del);
103 CREATE TRIGGER r1 AFTER INSERT ON t1 FOR EACH ROW BEGIN
106 CREATE TRIGGER r2 AFTER DELETE ON t1 FOR EACH ROW BEGIN
109 CREATE TRIGGER r3 AFTER INSERT ON t2 FOR EACH ROW BEGIN
112 CREATE TRIGGER r4 AFTER DELETE ON t2 FOR EACH ROW BEGIN
115 CREATE VIEW v1 AS SELECT x+100 FROM t1;
116 CREATE VIEW v2 AS SELECT sum(ins), sum(del) FROM cnt;
H A Dinsert2.test24 execsql {CREATE TABLE d1(n int, log int);}
36 CREATE TABLE t1(log int, cnt int);
51 CREATE TABLE t1(log int, cnt int);
65 CREATE TABLE t1(log int, cnt int);
80 CREATE TABLE t1(log int, cnt int);
81 CREATE INDEX i1 ON t1(log);
82 CREATE INDEX i2 ON t1(cnt);
92 CREATE TABLE t3(a,b,c);
93 CREATE TABLE t4(x,y);
H A Dmalloc.test43 CREATE TABLE t1(
47 CREATE INDEX i1 ON t1(a,b);
87 CREATE TABLE t1(a int, b int, c int);
88 CREATE INDEX i1 ON t1(a,b);
133 CREATE TABLE t1(a int, b int, c int);
134 CREATE INDEX i1 ON t1(a,b);
168 CREATE TABLE t1(a int, b int, c int);
169 CREATE INDEX i1 ON t1(a,b);
204 CREATE TABLE t1(a,b);
205 CREATE TABLE t2(x,y);
[all …]
H A Djoin.test23 CREATE TABLE t1(a,b,c);
32 CREATE TABLE t2(b,c,d);
111 CREATE TABLE t3(c,d,e);
130 CREATE TABLE t4(d,e,f);
228 CREATE TABLE t5(a INTEGER PRIMARY KEY);
229 CREATE TABLE t6(a INTEGER);
308 CREATE TABLE t7 (x, y);
317 CREATE TABLE t8 (a integer primary key, b);
335 CREATE TABLE t9(a INTEGER PRIMARY KEY, b);
338 CREATE TABLE t10(x INTEGER PRIMARY KEY, y);
[all …]
H A Dauth.test35 catchsql {CREATE TABLE t1(a,b,c)}
51 catchsql {CREATE TABLE t1(a,b,c)}
70 catchsql {CREATE TEMP TABLE t1(a,b,c)}
83 catchsql {CREATE TEMP TABLE t1(a,b,c)}
99 catchsql {CREATE TABLE t1(a,b,c)}
112 catchsql {CREATE TABLE t1(a,b,c)}
124 catchsql {CREATE TEMP TABLE t1(a,b,c)}
137 catchsql {CREATE TEMP TABLE t1(a,b,c)}
151 catchsql {CREATE TEMP TABLE t1(a,b,c)}
165 catchsql {CREATE TABLE t2(a,b,c)}
[all …]
H A Dmisc3.test27 CREATE TABLE t1(a UNIQUE,b);
41 CREATE TABLE t2(x,y);
51 CREATE TABLE t1(a UNIQUE,b);
110 CREATE TABLE t2(a INT UNIQUE);
187 CREATE TABLE t3(a INTEGER PRIMARY KEY, b);
216 CREATE TABLE x1 (b, c);
220 CREATE TABLE x2 (c, e);
261 CREATE TABLE y1(a);
262 CREATE TABLE y2(b);
263 CREATE TABLE y3(c);
[all …]
H A Dconflict.test26 CREATE TABLE t1(a, b, c, UNIQUE(a,b));
27 CREATE TABLE t2(x);
84 CREATE TABLE t1(a INTEGER PRIMARY KEY, b, c, UNIQUE(a,b));
85 CREATE TABLE t2(x);
142 CREATE TABLE t1(a, b, c INTEGER, PRIMARY KEY(c), UNIQUE(a,b));
143 CREATE TABLE t2(x);
197 CREATE TABLE t2(x);
239 CREATE TABLE t1(a,b,c,UNIQUE(a,b) $conf1);
256 CREATE TABLE t2(x);
302 CREATE TABLE t1(a,b,c NOT NULL $conf1 DEFAULT 5);
[all …]
H A Dfkey1.test24 CREATE TABLE t1(
36 CREATE TABLE t2(
44 CREATE TABLE t3(
H A Dcopy.test70 execsql {CREATE TABLE test1(one int, two int, three int)}
105 execsql {CREATE INDEX index1 ON test1(one)}
106 execsql {CREATE INDEX index2 ON test1(two)}
107 execsql {CREATE INDEX index3 ON test1(three)}
129 execsql {CREATE TABLE test2(a int, x text)}
146 CREATE TABLE t1(a text, b text);
199 CREATE TABLE t1(a INTEGER PRIMARY KEY, b UNIQUE, c);
253 CREATE TABLE t2(a,b,c);
H A Dmemdb.test33 CREATE TABLE t3(x TEXT);
124 CREATE TABLE t4(a,b,c,d);
152 CREATE TABLE t1(a, b, c, UNIQUE(a,b));
153 CREATE TABLE t2(x);
208 CREATE TABLE t2(a,b,c);
214 CREATE TABLE t3(x);
263 CREATE TABLE t1(a,b,c, UNIQUE(a) $conf1);
308 CREATE INDEX i2 ON t2(c);
320 CREATE TABLE t5(x,y);
338 CREATE TABLE t5(x PRIMARY KEY, y UNIQUE);
[all …]

12345