Home
last modified time | relevance | path

Searched refs:TABLE (Results 1 – 25 of 201) sorted by relevance

123456789

/illumos-gate/usr/src/lib/libsqlite/test/
H A Dtable.test13 # focus of this file is testing the CREATE TABLE statement.
24 CREATE TABLE test1 (
32 } {{CREATE TABLE test1 (
56 execsql {DROP TABLE test1}
72 execsql {CREATE TABLE "create" (f1 int)}
76 execsql {DROP TABLE "create"}
80 execsql {CREATE TABLE test1("f1 ho" int)}
84 execsql {DROP TABLE "TEST1"}
93 execsql {CREATE TABLE TEST2(one text)}
94 set v [catch {execsql {CREATE TABLE test2(two text)}} msg]
[all …]
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);}
68 DROP TABLE rlog;
69 DROP TABLE clog;
70 DROP TABLE tbl;
[all …]
H A Dvacuum.test35 CREATE TABLE t1(a INTEGER PRIMARY KEY, b, c);
46 CREATE TABLE t2 AS SELECT * FROM t1;
48 DROP TABLE t2;
66 CREATE TABLE t2 AS SELECT * FROM t1;
67 CREATE TABLE t3 AS SELECT * FROM t1;
73 DROP TABLE t2;
101 CREATE TABLE t4 AS SELECT * FROM t1;
102 CREATE TABLE t5 AS SELECT * FROM t1;
104 DROP TABLE t4;
105 DROP TABLE t5;
[all …]
H A Dmain.test41 db complete {DROP TABLE 'xyz;}
44 db complete {DROP TABLE 'xyz';}
47 db complete {DROP TABLE "xyz;}
50 db complete {DROP TABLE "xyz';}
53 db complete {DROP TABLE "xyz";}
56 db complete {DROP TABLE xyz; hi}
59 db complete {DROP TABLE xyz; }
62 db complete {DROP TABLE xyz; -- hi }
65 db complete {DROP TABLE xyz; -- hi
76 CREATE TABLE abc(x,y);
[all …]
H A Dtrans.test26 CREATE TABLE one(a int PRIMARY KEY, b text);
35 CREATE TABLE two(a int PRIMARY KEY, b text);
245 DROP TABLE one;
246 DROP TABLE two;
261 execsql {CREATE TABLE one(a text, b int)}
295 CREATE TABLE t1(a int, b int, c int);
320 CREATE TABLE t2(a int, b int, c int);
323 DROP TABLE t1;
358 CREATE TABLE t2(x int, y int, z int);
388 DROP TABLE t1;
[all …]
H A Dtemptable.test31 execsql {CREATE TABLE t1(a,b,c);}
51 CREATE TEMP TABLE t2(x,y,z);
83 db2 eval {DROP TABLE t2;}
93 CREATE TEMPORARY TABLE t2(x,y);
105 CREATE TEMPORARY TABLE t2(x,y);
141 DROP TABLE t2;
153 CREATE TEMP TABLE t2(x,y);
160 CREATE TABLE t2(x,y,z);
203 DROP TABLE t2; -- should drop TEMP
216 DROP TABLE t2;
[all …]
H A Dconflict.test26 CREATE TABLE t1(a, b, c, UNIQUE(a,b));
27 CREATE TABLE t2(x);
82 DROP TABLE t1;
83 DROP TABLE t2;
84 CREATE TABLE t1(a INTEGER PRIMARY KEY, b, c, UNIQUE(a,b));
85 CREATE TABLE t2(x);
140 DROP TABLE t1;
141 DROP TABLE t2;
142 CREATE TABLE t1(a, b, c INTEGER, PRIMARY KEY(c), UNIQUE(a,b));
143 CREATE TABLE t2(x);
[all …]
H A Dmisc2.test26 CREATE TABLE FOO(bar integer);
44 CREATE TABLE t1(a,b,c);
46 CREATE TABLE t2(a,b,c);
110 CREATE TABLE x(a,b);
127 CREATE TABLE t1(a,b);
142 CREATE TABLE t1(x);
165 CREATE TABLE t1(x);
197 CREATE TABLE counts(n INTEGER PRIMARY KEY);
205 CREATE TEMP TABLE x AS
215 DROP TABLE x;
[all …]
H A Dmisc1.test26 set cmd "CREATE TABLE manycol(x0 text"
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));
250 DROP TABLE t1;
[all …]
H A Dinsert2.test24 execsql {CREATE TABLE d1(n int, log int);}
36 CREATE TABLE t1(log int, cnt int);
49 catch {execsql {DROP TABLE t1}}
51 CREATE TABLE t1(log int, cnt int);
63 catch {execsql {DROP TABLE t1}}
65 CREATE TABLE t1(log int, cnt int);
78 catch {execsql {DROP TABLE t1}}
80 CREATE TABLE t1(log int, cnt int);
92 CREATE TABLE t3(a,b,c);
93 CREATE TABLE t4(x,y);
H A Dtrigger1.test50 CREATE TABLE t1(a);
102 DROP TABLE t1;
108 CREATE TEMP TABLE temp_table(a);
213 CREATE TEMP TABLE t2(x,y);
241 CREATE TEMP TABLE t2(x,y);
258 DROP TABLE t2;
259 CREATE TABLE t2(x,y);
299 DROP TABLE t1;
400 CREATE TABLE t3(a,b);
401 CREATE TABLE t4(x UNIQUE, b);
[all …]
H A Dindex.test23 execsql {CREATE TABLE test1(f1 int, f2 int, f3 int)}
46 execsql {DROP TABLE test1}
61 execsql {CREATE TABLE test1(f1 int, f2 int, f3 int)}
70 execsql {DROP TABLE test1}
81 execsql {CREATE TABLE test1(f1 int, f2 int, f3 int, f4 int, f5 int)}
95 execsql {DROP TABLE test1}
109 execsql {CREATE TABLE test1(cnt int, power int)}
155 execsql {DROP TABLE test1}
173 execsql {CREATE TABLE test1(f1 int, f2 int)}
174 execsql {CREATE TABLE test2(g1 real, g2 real)}
[all …]
H A Dselect4.test30 CREATE TABLE t1(n int, log int);
57 CREATE TABLE t2 AS
65 execsql {DROP TABLE t2}
68 CREATE TABLE t2 AS
76 execsql {DROP TABLE t2}
86 CREATE TABLE t2 AS
93 execsql {DROP TABLE t2}
152 CREATE TABLE t2 AS
160 execsql {DROP TABLE t2}
163 CREATE TABLE t2 AS
[all …]
H A Dtrigger3.test18 # catchsql { DROP TABLE tbl; }
19 catchsql { CREATE TABLE tbl (a, b, c) }
93 execsql {DROP TABLE tbl;}
94 execsql {CREATE TABLE tbl (a, b, c);}
120 execsql {CREATE TABLE tbl2(a, b, c)}
163 catchsql { DROP TABLE tbl; }
164 catchsql { DROP TABLE tbl2; }
H A Dmisc3.test27 CREATE TABLE t1(a UNIQUE,b);
41 CREATE TABLE t2(x,y);
48 DROP TABLE t1;
49 DROP TABLE t2;
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);
[all …]
H A Dmemdb.test33 CREATE TABLE t3(x TEXT);
124 CREATE TABLE t4(a,b,c,d);
137 DROP TABLE t4;
152 CREATE TABLE t1(a, b, c, UNIQUE(a,b));
153 CREATE TABLE t2(x);
206 DROP TABLE t2;
207 DROP TABLE t3;
208 CREATE TABLE t2(a,b,c);
214 CREATE TABLE t3(x);
262 DROP TABLE t1;
[all …]
/illumos-gate/usr/src/cmd/picl/plugins/sun4u/chalupa/frudr/
H A DSB-tables.info44 TABLE Devices
54 TABLE Devices
141 TABLE Devices
152 TABLE Devices
218 TABLE Devices
229 TABLE Devices
240 TABLE Devices
251 TABLE Devices
265 TABLE Devices
286 TABLE Devices
[all …]
/illumos-gate/usr/src/cmd/picl/plugins/sun4u/ents/frudr/
H A DSB-tables.info44 TABLE Devices
52 TABLE Devices
63 TABLE Devices
81 TABLE Devices
108 TABLE Devices
127 TABLE Devices
150 TABLE Devices
192 TABLE Devices
207 TABLE Devices
222 TABLE Devices
[all …]
H A Dfru_SC_data.info77 TABLE Devices
100 TABLE Devices
123 TABLE Devices
146 TABLE Devices
169 TABLE Devices
192 TABLE Devices
215 TABLE Devices
238 TABLE Devices
288 TABLE Devices
295 TABLE Devices
[all …]
/illumos-gate/usr/src/cmd/picl/plugins/sun4u/boston/frudr/
H A DSB-tables.info50 TABLE Devices
61 TABLE Devices
71 TABLE Devices
158 TABLE Devices
170 TABLE Devices
187 TABLE Devices
202 TABLE Devices
214 TABLE Devices
226 TABLE Devices
238 TABLE Devices
[all …]
/illumos-gate/usr/src/common/crypto/sha2/amd64/
H A Dsha512-x86_64.pl65 my ($code, $func, $TABLE, $SZ, @Sigma0, @Sigma1, @sigma0, @sigma1, $rounds,
85 $TABLE="K512";
97 $TABLE="K256";
252 lea $TABLE-.($Tbl),$Tbl
329 .type $TABLE,\@object
330 $TABLE:
352 .type $TABLE,\@object
353 $TABLE:
/illumos-gate/usr/src/cmd/picl/plugins/sun4u/seattle/frudr/
H A DSB-tables.info52 TABLE Devices
63 TABLE Devices
74 TABLE Devices
85 TABLE Devices
144 TABLE Devices
155 TABLE Devices
166 TABLE Devices
174 TABLE Devices
185 TABLE Devices
197 TABLE Devices
[all …]
/illumos-gate/usr/src/cmd/picl/plugins/sun4u/mpxu/frudr/
H A DSB-tables.info44 TABLE Devices
55 TABLE Devices
66 TABLE Devices
161 TABLE Devices
172 TABLE Devices
242 TABLE Devices
263 TABLE Devices
284 TABLE Devices
291 TABLE Devices
298 TABLE Devices
[all …]
H A Dfru_SC_data.info77 TABLE Devices
100 TABLE Devices
123 TABLE Devices
146 TABLE Devices
175 TABLE Devices
198 TABLE Devices
205 TABLE Devices
212 TABLE Devices
219 TABLE Devices
239 TABLE Devices
/illumos-gate/usr/src/cmd/lp/cmd/
H A Dlpfilter.c73 #define TABLE 0 macro
394 same_complaints (FILTERTABLE, TABLE);
422 same_complaints (FILTERTABLE, TABLE);
459 same_complaints (FILTERTABLE, TABLE);
562 same_complaints (FILTERTABLE, TABLE);
565 same_complaints (FILTERTABLE, TABLE);
675 same_complaints (FILTERTABLE, TABLE);
699 same_complaints (FILTERTABLE, TABLE);
734 same_complaints (FILTERTABLE, TABLE);
750 same_complaints (FILTERTABLE, TABLE);
[all …]

123456789