Home
last modified time | relevance | path

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

1234

/titanic_41/usr/src/lib/libsqlite/test/
H A Dtrigger2.test59 {CREATE TEMP TABLE tbl (a, b);}
60 {CREATE TABLE tbl (a, b);}
61 {CREATE TABLE tbl (a INTEGER PRIMARY KEY, b);}
62 {CREATE TEMPORARY TABLE tbl (a INTEGER PRIMARY KEY, b);}
63 {CREATE TABLE tbl (a, b PRIMARY KEY);}
64 {CREATE TABLE tbl (a, b); CREATE INDEX tbl_idx ON tbl(b);}
65 {CREATE TEMP TABLE tbl (a, b); CREATE INDEX tbl_idx ON tbl(b);}
82 CREATE TABLE rlog (idx, old_a, old_b, db_sum_a, db_sum_b, new_a, new_b);
83 CREATE TABLE clog (idx, old_a, old_b, db_sum_a, db_sum_b, new_a, new_b);
85 CREATE TRIGGER before_update_row BEFORE UPDATE ON tbl FOR EACH ROW
[all …]
H A Dtable.test15 # focus of this file is testing the CREATE TABLE statement.
26 CREATE TABLE test1 (
34 } {{CREATE TABLE test1 (
74 execsql {CREATE TABLE "create" (f1 int)}
82 execsql {CREATE TABLE test1("f1 ho" int)}
95 execsql {CREATE TABLE TEST2(one text)}
96 set v [catch {execsql {CREATE TABLE test2(two text)}} msg]
100 set v [catch {execsql {CREATE TABLE sqlite_master(two text)}} msg]
106 set v [catch {execsql {CREATE TABLE sqlite_master(two text)}} msg]
116 execsql {CREATE TABLE test2(one text); CREATE INDEX test3 ON test2(one)}
[all …]
H A Dmain.test78 CREATE TABLE abc(x,y);
83 CREATE TRIGGER xyz AFTER DELETE abc BEGIN UPDATE pqr;
88 CREATE TRIGGER xyz AFTER DELETE abc BEGIN UPDATE pqr; END;
93 CREATE TRIGGER xyz AFTER DELETE abc BEGIN
100 CREATE TRIGGER xyz AFTER DELETE backend BEGIN
106 CREATE TRIGGER xyz AFTER DELETE end BEGIN
112 CREATE TRIGGER xyz AFTER DELETE end BEGIN
119 CREATE TRIGGER xyz AFTER DELETE end BEGIN
127 CREATE TRIGGER xyz AFTER DELETE [;end;] BEGIN
133 CREATE TRIGGER xyz AFTER DELETE backend BEGIN
[all …]
H A Dtrigger1.test16 # 1. CREATE and DROP TRIGGER tests
38 CREATE TRIGGER trig UPDATE ON no_such_table BEGIN
45 CREATE TEMP TRIGGER trig UPDATE ON no_such_table BEGIN
52 CREATE TABLE t1(a);
55 CREATE TRIGGER tr1 INSERT ON t1 BEGIN
61 CREATE TRIGGER tr1 DELETE ON t1 BEGIN
70 CREATE TRIGGER tr2 INSERT ON t1 BEGIN
73 CREATE TRIGGER tr2 INSERT ON t1 BEGIN
81 CREATE TRIGGER tr1 DELETE ON t1 BEGIN
110 CREATE TEMP TABLE temp_table(a);
[all …]
H A Dindex.test15 # focus of this file is testing the CREATE INDEX statement.
25 execsql {CREATE TABLE test1(f1 int, f2 int, f3 int)}
26 execsql {CREATE INDEX index1 ON test1(f1)}
32 } {index1 {CREATE INDEX index1 ON test1(f1)} test1 index}
38 } {index1 {CREATE INDEX index1 ON test1(f1)} test1 index}
55 set v [catch {execsql {CREATE INDEX index1 ON test1(f1)}} msg]
63 execsql {CREATE TABLE test1(f1 int, f2 int, f3 int)}
64 set v [catch {execsql {CREATE INDEX index1 ON test1(f4)}} msg]
71 set v [catch {execsql {CREATE INDEX index1 ON test1(f1, f2, f4, f3)}} msg]
83 execsql {CREATE TABLE test1(f1 int, f2 int, f3 int, f4 int, f5 int)}
[all …]
H A Dview.test23 CREATE TABLE t1(a,b,c);
34 CREATE VIEW v1 AS SELECT a,b FROM t1;
46 CREATE VIEW v1 AS SELECT a,b FROM t1;
65 CREATE VIEW v1 AS SELECT a,b FROM t1;
77 CREATE TABLE t1(x,a,b,c);
94 CREATE VIEW v2 AS SELECT * FROM t1 WHERE a>5
142 CREATE VIEW v1 AS SELECT a AS 'xyz', b+c AS 'pqr', c-b FROM t1;
148 CREATE VIEW v3 AS SELECT a FROM t1 UNION SELECT b FROM t1 ORDER BY b;
154 CREATE VIEW v4 AS
186 CREATE INDEX i1v1 ON v1(xyz);
[all …]
H A Dvacuum.test37 CREATE TABLE t1(a INTEGER PRIMARY KEY, b, c);
47 CREATE INDEX i1 ON t1(b,c);
48 CREATE TABLE t2 AS SELECT * FROM t1;
68 CREATE TABLE t2 AS SELECT * FROM t1;
69 CREATE TABLE t3 AS SELECT * FROM t1;
70 CREATE VIEW v1 AS SELECT b, c FROM t3;
71 CREATE TRIGGER r1 AFTER DELETE ON t2 BEGIN
103 CREATE TABLE t4 AS SELECT * FROM t1;
104 CREATE TABLE t5 AS SELECT * FROM t1;
156 CREATE TABLE Test (TestID int primary key);
[all …]
H A Dattach.test31 CREATE TABLE t1(a,b);
40 CREATE TABLE t2(x,y);
212 CREATE TABLE tx(x1,x2,y1,y2);
213 CREATE TRIGGER r1 AFTER UPDATE ON t2 FOR EACH ROW BEGIN
227 CREATE TABLE tx(x1,x2,y1,y2);
257 CREATE INDEX i2 ON t2(x);
385 CREATE TABLE t3(x,y);
386 CREATE UNIQUE INDEX t3i1 ON t3(x);
393 CREATE TABLE t3(a,b);
394 CREATE UNIQUE INDEX t3i1b ON t3(a);
[all …]
H A Dtrigger3.test21 catchsql { CREATE TABLE tbl (a, b, c) }
24 CREATE TRIGGER before_tbl_insert BEFORE INSERT ON tbl BEGIN SELECT CASE
28 CREATE TRIGGER after_tbl_insert AFTER INSERT ON tbl BEGIN SELECT CASE
96 execsql {CREATE TABLE tbl (a, b, c);}
100 CREATE TRIGGER before_tbl_update BEFORE UPDATE ON tbl BEGIN
104 CREATE TRIGGER before_tbl_delete BEFORE DELETE ON tbl BEGIN
122 execsql {CREATE TABLE tbl2(a, b, c)}
124 CREATE TRIGGER after_tbl2_insert AFTER INSERT ON tbl2 BEGIN
138 execsql {CREATE VIEW tbl_view AS SELECT * FROM tbl}
140 CREATE TRIGGER tbl_view_insert INSTEAD OF INSERT ON tbl_view BEGIN
H A Dmisc2.test28 CREATE TABLE FOO(bar integer);
29 CREATE TRIGGER foo_insert BEFORE INSERT ON foo BEGIN
46 CREATE TABLE t1(a,b,c);
48 CREATE TABLE t2(a,b,c);
55 CREATE VIEW v1 AS SELECT * FROM t1, t2;
112 CREATE TABLE x(a,b);
113 CREATE VIEW y AS
115 CREATE VIEW z AS
129 CREATE TABLE t1(a,b);
144 CREATE TABLE t1(x);
[all …]
H A Dunique.test15 # focus of this file is testing the CREATE UNIQUE INDEX statement,
28 CREATE TABLE t1(
37 CREATE TABLE t1(
84 CREATE TABLE t2(a int, b int);
92 CREATE UNIQUE INDEX i2 ON t2(a)
128 CREATE UNIQUE INDEX i2 ON t2(a);
133 CREATE INDEX i2 ON t2(a);
142 CREATE TABLE t3(
176 CREATE TABLE t4(a UNIQUE, b, c, UNIQUE(b,c));
209 CREATE TABLE t5(
H A Dtrans.test28 CREATE TABLE one(a int PRIMARY KEY, b text);
37 CREATE TABLE two(a int PRIMARY KEY, b text);
263 execsql {CREATE TABLE one(a text, b int)}
284 # Test commits and rollbacks of table CREATE TABLEs, CREATE INDEXs
297 CREATE TABLE t1(a int, b int, c int);
305 CREATE INDEX i1 ON t1(a);
322 CREATE TABLE t2(a int, b int, c int);
323 CREATE INDEX i2a ON t2(a);
324 CREATE INDEX i2b ON t2(b);
360 CREATE TABLE t2(x int, y int, z int);
[all …]
H A Dtemptable.test33 execsql {CREATE TABLE t1(a,b,c);}
53 CREATE TEMP TABLE t2(x,y,z);
95 CREATE TEMPORARY TABLE t2(x,y);
107 CREATE TEMPORARY TABLE t2(x,y);
125 CREATE INDEX i2 ON t2(x);
142 CREATE INDEX i2 ON t2(x);
155 CREATE TEMP TABLE t2(x,y);
162 CREATE TABLE t2(x,y,z);
226 CREATE TEMP TABLE t2(x unique,y);
233 CREATE TABLE t2(x unique, y);
[all …]
H A Dversion.test30 CREATE TABLE t1(x);
99 CREATE INDEX i1 ON t1(x);
101 CREATE TABLE t2(a INTEGER PRIMARY KEY, b UNIQUE, c);
102 CREATE TABLE cnt(name,ins, del);
105 CREATE TRIGGER r1 AFTER INSERT ON t1 FOR EACH ROW BEGIN
108 CREATE TRIGGER r2 AFTER DELETE ON t1 FOR EACH ROW BEGIN
111 CREATE TRIGGER r3 AFTER INSERT ON t2 FOR EACH ROW BEGIN
114 CREATE TRIGGER r4 AFTER DELETE ON t2 FOR EACH ROW BEGIN
117 CREATE VIEW v1 AS SELECT x+100 FROM t1;
118 CREATE VIEW v2 AS SELECT sum(ins), sum(del) FROM cnt;
H A Dmisc1.test28 set cmd "CREATE TABLE manycol(x0 text"
66 execsql {CREATE INDEX manycol_idx1 ON manycol(x99)}
94 CREATE TABLE agger(one text, two text, three text, four text);
119 CREATE TABLE t1(a);
133 CREATE TABLE t2(a);
153 CREATE TABLE t3(a,b);
175 CREATE TABLE t4(
203 CREATE TABLE error1(
211 CREATE TABLE error1(
219 CREATE TABLE t5(a,b,c,PRIMARY KEY(a,b));
[all …]
H A Dinsert2.test26 execsql {CREATE TABLE d1(n int, log int);}
38 CREATE TABLE t1(log int, cnt int);
53 CREATE TABLE t1(log int, cnt int);
67 CREATE TABLE t1(log int, cnt int);
82 CREATE TABLE t1(log int, cnt int);
83 CREATE INDEX i1 ON t1(log);
84 CREATE INDEX i2 ON t1(cnt);
94 CREATE TABLE t3(a,b,c);
95 CREATE TABLE t4(x,y);
H A Dmalloc.test45 CREATE TABLE t1(
49 CREATE INDEX i1 ON t1(a,b);
89 CREATE TABLE t1(a int, b int, c int);
90 CREATE INDEX i1 ON t1(a,b);
135 CREATE TABLE t1(a int, b int, c int);
136 CREATE INDEX i1 ON t1(a,b);
170 CREATE TABLE t1(a int, b int, c int);
171 CREATE INDEX i1 ON t1(a,b);
206 CREATE TABLE t1(a,b);
207 CREATE TABLE t2(x,y);
[all …]
H A Dmisc3.test29 CREATE TABLE t1(a UNIQUE,b);
43 CREATE TABLE t2(x,y);
53 CREATE TABLE t1(a UNIQUE,b);
112 CREATE TABLE t2(a INT UNIQUE);
189 CREATE TABLE t3(a INTEGER PRIMARY KEY, b);
218 CREATE TABLE x1 (b, c);
222 CREATE TABLE x2 (c, e);
263 CREATE TABLE y1(a);
264 CREATE TABLE y2(b);
265 CREATE TABLE y3(c);
[all …]
H A Djoin.test25 CREATE TABLE t1(a,b,c);
34 CREATE TABLE t2(b,c,d);
113 CREATE TABLE t3(c,d,e);
132 CREATE TABLE t4(d,e,f);
230 CREATE TABLE t5(a INTEGER PRIMARY KEY);
231 CREATE TABLE t6(a INTEGER);
310 CREATE TABLE t7 (x, y);
319 CREATE TABLE t8 (a integer primary key, b);
337 CREATE TABLE t9(a INTEGER PRIMARY KEY, b);
340 CREATE TABLE t10(x INTEGER PRIMARY KEY, y);
[all …]
H A Dauth.test37 catchsql {CREATE TABLE t1(a,b,c)}
53 catchsql {CREATE TABLE t1(a,b,c)}
72 catchsql {CREATE TEMP TABLE t1(a,b,c)}
85 catchsql {CREATE TEMP TABLE t1(a,b,c)}
101 catchsql {CREATE TABLE t1(a,b,c)}
114 catchsql {CREATE TABLE t1(a,b,c)}
126 catchsql {CREATE TEMP TABLE t1(a,b,c)}
139 catchsql {CREATE TEMP TABLE t1(a,b,c)}
153 catchsql {CREATE TEMP TABLE t1(a,b,c)}
167 catchsql {CREATE TABLE t2(a,b,c)}
[all …]
H A Dfkey1.test26 CREATE TABLE t1(
38 CREATE TABLE t2(
46 CREATE TABLE t3(
H A Dconflict.test28 CREATE TABLE t1(a, b, c, UNIQUE(a,b));
29 CREATE TABLE t2(x);
86 CREATE TABLE t1(a INTEGER PRIMARY KEY, b, c, UNIQUE(a,b));
87 CREATE TABLE t2(x);
144 CREATE TABLE t1(a, b, c INTEGER, PRIMARY KEY(c), UNIQUE(a,b));
145 CREATE TABLE t2(x);
199 CREATE TABLE t2(x);
241 CREATE TABLE t1(a,b,c,UNIQUE(a,b) $conf1);
258 CREATE TABLE t2(x);
304 CREATE TABLE t1(a,b,c NOT NULL $conf1 DEFAULT 5);
[all …]
H A Dcopy.test72 execsql {CREATE TABLE test1(one int, two int, three int)}
107 execsql {CREATE INDEX index1 ON test1(one)}
108 execsql {CREATE INDEX index2 ON test1(two)}
109 execsql {CREATE INDEX index3 ON test1(three)}
131 execsql {CREATE TABLE test2(a int, x text)}
148 CREATE TABLE t1(a text, b text);
201 CREATE TABLE t1(a INTEGER PRIMARY KEY, b UNIQUE, c);
255 CREATE TABLE t2(a,b,c);
H A Dmemdb.test35 CREATE TABLE t3(x TEXT);
126 CREATE TABLE t4(a,b,c,d);
154 CREATE TABLE t1(a, b, c, UNIQUE(a,b));
155 CREATE TABLE t2(x);
210 CREATE TABLE t2(a,b,c);
216 CREATE TABLE t3(x);
265 CREATE TABLE t1(a,b,c, UNIQUE(a) $conf1);
310 CREATE INDEX i2 ON t2(c);
322 CREATE TABLE t5(x,y);
340 CREATE TABLE t5(x PRIMARY KEY, y UNIQUE);
[all …]
/titanic_41/usr/src/cmd/cmd-inet/usr.sbin/nwamcfg/
H A Dnwamcfg_grammar.y51 %token CANCEL CLEAR COMMIT CREATE DESTROY END EXIT EXPORT GET HELP
93 %type <cmd> create_command CREATE
206 create_command: CREATE
211 | CREATE TOKEN
216 | CREATE resource1_type
221 | CREATE resource2_type
226 | CREATE resource1_type TOKEN
239 | CREATE resource2_type ncu_class_type TOKEN
254 | CREATE OPTION TOKEN resource1_type TOKEN
269 | CREATE OPTION TOKEN resource2_type ncu_class_type TOKEN

1234