Home
last modified time | relevance | path

Searched refs:INSERT (Results 1 – 25 of 82) sorted by relevance

1234

/illumos-gate/usr/src/lib/libsqlite/test/
H A Dconflict.test66 INSERT INTO t1 VALUES(1,2,3);
68 INSERT INTO t2 VALUES(1);
126 INSERT INTO t2 VALUES(1);
184 INSERT INTO t2 VALUES(1);
243 INSERT INTO t2 VALUES(1);
305 INSERT INTO t2 VALUES(1);
325 INSERT INTO t3 VALUES(1);
452 INSERT INTO t1 VALUES(1,2);
515 INSERT INTO t3 VALUES(1);
686 INSERT INTO t4 VALUES(1);
[all …]
H A Dtrigger2.test77 INSERT INTO tbl VALUES(1, 2);
78 INSERT INTO tbl VALUES(3, 4);
326 INSERT INTO log VALUES (0);
356 INSERT INTO log VALUES (0);
576 INSERT INTO ab VALUES (1, 2);
577 INSERT INTO ab VALUES (0, 0);
578 INSERT INTO cd VALUES (3, 4);
586 INSERT INTO tlog VALUES(NULL,
590 INSERT INTO tlog VALUES(NULL,
595 INSERT INTO tlog VALUES(NULL,
[all …]
H A Dmemdb.test126 INSERT INTO t4 VALUES(1,2,3,4);
194 INSERT INTO t2 VALUES(1);
209 INSERT INTO t2 VALUES(1,2,1);
210 INSERT INTO t2 VALUES(2,3,2);
211 INSERT INTO t2 VALUES(3,4,1);
212 INSERT INTO t2 VALUES(4,5,4);
215 INSERT INTO t3 VALUES(1);
321 INSERT INTO t5 VALUES(1,2);
349 INSERT INTO t5 VALUES(1,2);
350 INSERT INTO t5 VALUES(3,4);
[all …]
H A Dminmax.test26 INSERT INTO t1 VALUES(1,1);
27 INSERT INTO t1 VALUES(2,2);
28 INSERT INTO t1 VALUES(3,2);
29 INSERT INTO t1 VALUES(4,3);
30 INSERT INTO t1 VALUES(5,3);
31 INSERT INTO t1 VALUES(6,3);
32 INSERT INTO t1 VALUES(7,3);
33 INSERT INTO t1 VALUES(8,4);
34 INSERT INTO t1 VALUES(9,4);
35 INSERT INTO t1 VALUES(10,4);
[all …]
H A Dmisc3.test28 INSERT INTO t1
35 INSERT INTO t1 VALUES(2,'x');
52 INSERT INTO t1
190 INSERT INTO t3(b) VALUES(NULL);
191 INSERT INTO t3(b) VALUES(NULL);
217 INSERT INTO x1 VALUES('dog',3);
218 INSERT INTO x1 VALUES('cat',1);
219 INSERT INTO x1 VALUES('dog',4);
221 INSERT INTO x2 VALUES(1,'one');
267 INSERT INTO y1 VALUES(1);
[all …]
H A Dnotnull.test184 INSERT INTO t1 VALUES(1,2,3,4,5);
192 INSERT INTO t1 VALUES(1,2,3,4,5);
200 INSERT INTO t1 VALUES(1,2,3,4,5);
208 INSERT INTO t1 VALUES(1,2,3,4,5);
216 INSERT INTO t1 VALUES(1,2,3,4,5);
224 INSERT INTO t1 VALUES(1,2,3,4,5);
232 INSERT INTO t1 VALUES(1,2,3,4,5);
240 INSERT INTO t1 VALUES(1,2,3,4,5);
248 INSERT INTO t1 VALUES(1,2,3,4,5);
256 INSERT INTO t1 VALUES(1,2,3,4,5);
[all …]
H A Djoin.test24 INSERT INTO t1 VALUES(1,2,3);
25 INSERT INTO t1 VALUES(2,3,4);
26 INSERT INTO t1 VALUES(3,4,5);
33 INSERT INTO t2 VALUES(1,2,3);
34 INSERT INTO t2 VALUES(2,3,4);
35 INSERT INTO t2 VALUES(3,4,5);
112 INSERT INTO t3 VALUES(2,3,4);
113 INSERT INTO t3 VALUES(3,4,5);
114 INSERT INTO t3 VALUES(4,5,6);
131 INSERT INTO t4 VALUES(2,3,4);
[all …]
H A Dinsert.test13 # focus of this file is testing the INSERT statement.
64 execsql {INSERT INTO test1 VALUES(1,2,3)}
68 execsql {INSERT INTO test1 VALUES(4,5,6)}
72 execsql {INSERT INTO test1 VALUES(7,8,9)}
167 INSERT INTO t3 VALUES(1+2+3,4,5);
196 INSERT INTO t3 VALUES(notafunc(2,3),2,3);
212 INSERT INTO t4 VALUES(1);
218 INSERT INTO t4 SELECT x+1 FROM t4;
225 EXPLAIN INSERT INTO t4 SELECT x+2 FROM t4;
262 INSERT INTO t1 VALUES(1,2);
[all …]
H A Dinsert2.test52 INSERT INTO t1
67 INSERT INTO t1
94 INSERT INTO t4 VALUES(1,2);
131 INSERT INTO t4 VALUES(2,4);
132 INSERT INTO t4 VALUES(3,6);
133 INSERT INTO t4 VALUES(4,8);
134 INSERT INTO t4 VALUES(5,10);
135 INSERT INTO t4 VALUES(6,12);
136 INSERT INTO t4 VALUES(7,14);
137 INSERT INTO t4 VALUES(8,16);
[all …]
H A Dtrigger3.test36 INSERT INTO tbl VALUES (5, 5, 6);
37 INSERT INTO tbl VALUES (1, 5, 6);
54 INSERT INTO tbl VALUES (5, 5, 6);
55 INSERT INTO tbl VALUES (2, 5, 6);
68 INSERT INTO tbl VALUES (5, 5, 6);
69 INSERT INTO tbl VALUES (3, 5, 6);
81 INSERT INTO tbl VALUES (5, 5, 6);
129 INSERT INTO tbl2 VALUES (1, 2, 3);
147 INSERT INTO tbl_view VALUES(1, 2, 3);
152 INSERT INTO tbl_view VALUES(2, 2, 3);
[all …]
H A Dtrigger1.test54 INSERT INTO t1 values(1);
223 INSERT INTO t1 VALUES(1,2);
235 INSERT INTO t1 VALUES(1,2);
242 INSERT INTO t1 VALUES(1,2);
252 INSERT INTO t1 VALUES(1,2);
265 INSERT INTO t1 VALUES(3,4);
273 INSERT INTO t1 VALUES(5,6);
283 INSERT INTO t1 VALUES(7,8);
290 INSERT INTO t1 VALUES(9,10);
405 INSERT INTO t3 VALUES(1,2);
[all …]
H A Dmisc1.test118 INSERT INTO t1 VALUES('hi');
152 INSERT INTO t3 VALUES(1,2);
153 INSERT INTO t3 VALUES(3,4);
182 INSERT INTO t4
218 INSERT INTO t5 VALUES(1,2,3);
224 INSERT INTO t5 VALUES(1,2,4);
229 INSERT INTO t5 VALUES(0,2,4);
363 INSERT INTO t7 VALUES(0,0,1);
393 INSERT INTO t8 VALUES(0,0,1);
505 INSERT INTO test VALUES(1);
[all …]
H A Dprogress.test25 INSERT INTO t1 VALUES(1);
26 INSERT INTO t1 VALUES(2);
27 INSERT INTO t1 VALUES(3);
28 INSERT INTO t1 VALUES(4);
29 INSERT INTO t1 VALUES(5);
30 INSERT INTO t1 VALUES(6);
31 INSERT INTO t1 VALUES(7);
32 INSERT INTO t1 VALUES(8);
33 INSERT INTO t1 VALUES(9);
34 INSERT INTO t1 VALUES(10);
[all …]
H A Dunique.test44 INSERT INTO t1(a,b,c) VALUES(1,2,3)
49 INSERT INTO t1(a,b,c) VALUES(1,3,4)
59 INSERT INTO t1(a,b,c) VALUES(3,2,4)
69 INSERT INTO t1(a,b,c) VALUES(3,4,5)
83 INSERT INTO t2(a,b) VALUES(1,2);
84 INSERT INTO t2(a,b) VALUES(3,4);
100 INSERT INTO t2 VALUES(1,5);
116 INSERT INTO t2 VALUES(1,5)
175 INSERT INTO t4 VALUES(1,2,3);
182 INSERT INTO t4 VALUES(NULL, 3, 4);
[all …]
H A Dindex.test258 INSERT INTO t1 VALUES(1,2);
259 INSERT INTO t1 VALUES(2,4);
260 INSERT INTO t1 VALUES(3,8);
261 INSERT INTO t1 VALUES(1,12);
285 INSERT INTO t1 VALUES (1,1);
286 INSERT INTO t1 VALUES (1,2);
287 INSERT INTO t1 VALUES (1,3);
288 INSERT INTO t1 VALUES (1,4);
289 INSERT INTO t1 VALUES (1,5);
290 INSERT INTO t1 VALUES (1,6);
[all …]
H A Djoin2.test24 INSERT INTO t1 VALUES(1,11);
25 INSERT INTO t1 VALUES(2,22);
26 INSERT INTO t1 VALUES(3,33);
33 INSERT INTO t2 VALUES(11,111);
34 INSERT INTO t2 VALUES(33,333);
35 INSERT INTO t2 VALUES(44,444);
42 INSERT INTO t3 VALUES(111,1111);
43 INSERT INTO t3 VALUES(444,4444);
44 INSERT INTO t3 VALUES(555,5555);
H A Dcrashme2.off9 INSERT INTO t1 VALUES(1);
10 INSERT INTO t1 VALUES(2);
11 INSERT INTO t1 VALUES(3);
12 INSERT INTO t1 VALUES(4);
18 INSERT INTO t3 SELECT a FROM t1;
20 INSERT INTO t1 SELECT * FROM t1;
35 INSERT INTO t3 SELECT a FROM t1;
H A Dmisc2.test31 INSERT INTO foo(bar) VALUES (1);
36 INSERT INTO foo(bar) VALUES (111);
45 INSERT INTO t1 VALUES(1,2,3);
47 INSERT INTO t2 VALUES(7,8,9);
128 INSERT INTO t1 VALUES(1,2);
143 INSERT INTO t1 VALUES(1);
155 db eval "INSERT INTO t1 VALUES(3)"
166 INSERT INTO t1 VALUES(1);
178 db eval "INSERT INTO t1 VALUES(3)"
198 INSERT INTO counts VALUES(0);
[all …]
H A Dioerr.test42 INSERT INTO t1 VALUES(1,2,3);
43 INSERT INTO t1 VALUES(4,5,6);
47 INSERT INTO t1 VALUES(1,2,3);
48 INSERT INTO t1 VALUES(4,5,6);
84 INSERT INTO t1 VALUES(1, randstr(5,50), randstr(5,50));
85 INSERT INTO t1 SELECT a+2, b||'-'||rowid, c||'-'||rowid FROM t1;
86 INSERT INTO t1 SELECT a+4, b||'-'||rowid, c||'-'||rowid FROM t1;
87 INSERT INTO t1 SELECT a+8, b||'-'||rowid, c||'-'||rowid FROM t1;
88 INSERT INTO t1 SELECT a+16, b||'-'||rowid, c||'-'||rowid FROM t1;
89 INSERT INTO t1 SELECT a+32, b||'-'||rowid, c||'-'||rowid FROM t1;
[all …]
H A Dtrans.test27 INSERT INTO one VALUES(1,'one');
28 INSERT INTO one VALUES(2,'two');
29 INSERT INTO one VALUES(3,'three');
36 INSERT INTO two VALUES(1,'I');
37 INSERT INTO two VALUES(5,'V');
38 INSERT INTO two VALUES(10,'X');
127 INSERT INTO two VALUES(4,'IV');
361 INSERT INTO t2 VALUES(1,2,3);
422 INSERT INTO t1 VALUES(1,2,3);
432 INSERT INTO t1 VALUES(1,2,3);
[all …]
H A Ddelete.test38 execsql {INSERT INTO table1 VALUES(1,2)}
39 execsql {INSERT INTO table1 VALUES(2,4)}
40 execsql {INSERT INTO table1 VALUES(3,8)}
206 INSERT INTO t3 VALUES(1);
207 INSERT INTO t3 SELECT a+1 FROM t3;
208 INSERT INTO t3 SELECT a+2 FROM t3;
215 INSERT INTO cnt VALUES(0);
241 INSERT INTO t3 VALUES(1);
242 INSERT INTO t3 SELECT a+1 FROM t3;
243 INSERT INTO t3 SELECT a+2 FROM t3;
[all …]
H A Dvacuum.test36 INSERT INTO t1 VALUES(NULL,randstr(10,100),randstr(5,50));
37 INSERT INTO t1 VALUES(123456,randstr(10,100),randstr(5,50));
38 INSERT INTO t1 SELECT NULL, b||'-'||rowid, c||'-'||rowid FROM t1;
39 INSERT INTO t1 SELECT NULL, b||'-'||rowid, c||'-'||rowid FROM t1;
40 INSERT INTO t1 SELECT NULL, b||'-'||rowid, c||'-'||rowid FROM t1;
41 INSERT INTO t1 SELECT NULL, b||'-'||rowid, c||'-'||rowid FROM t1;
42 INSERT INTO t1 SELECT NULL, b||'-'||rowid, c||'-'||rowid FROM t1;
43 INSERT INTO t1 SELECT NULL, b||'-'||rowid, c||'-'||rowid FROM t1;
155 INSERT INTO Test VALUES (NULL);
160 INSERT INTO tempTest SELECT TestID, 1 FROM Test;
[all …]
H A Dversion.test29 INSERT INTO t1 VALUES(1);
30 INSERT INTO t1 SELECT x+1 FROM t1;
31 INSERT INTO t1 SELECT x+2 FROM t1;
32 INSERT INTO t1 SELECT x+4 FROM t1;
101 INSERT INTO cnt VALUES('t1',0,0);
102 INSERT INTO cnt VALUES('t2',0,0);
117 INSERT INTO t1 VALUES(1);
118 INSERT INTO t1 SELECT x+1 FROM t1;
119 INSERT INTO t1 SELECT x+2 FROM t1;
120 INSERT INTO t1 SELECT x+4 FROM t1;
[all …]
H A Drowid.test26 INSERT INTO t1 VALUES(1,2);
27 INSERT INTO t1 VALUES(3,4);
171 INSERT INTO t2 VALUES(0,2,3);
172 INSERT INTO t2 VALUES(4,5,6);
173 INSERT INTO t2 VALUES(7,8,9);
310 INSERT INTO t1 VALUES(1,2);
376 INSERT INTO t4 VALUES(1);
390 INSERT INTO t3 VALUES(123);
406 INSERT INTO t3 VALUES(NULL);
481 INSERT INTO t5 VALUES(1);
[all …]
H A Dattach.test30 INSERT INTO t1 VALUES(1,2);
31 INSERT INTO t1 VALUES(3,4);
39 INSERT INTO t2 VALUES(1,'x');
40 INSERT INTO t2 VALUES(2,'y');
385 INSERT INTO t3 VALUES(1,2);
393 INSERT INTO t3 VALUES(9,10);
410 INSERT INTO db2.t3 VALUES(9,10);
423 INSERT INTO t3 VALUES(6,7);
433 INSERT INTO main.t3 VALUES(11,12);
440 INSERT INTO db2.t3 VALUES(13,14);
[all …]

1234