/illumos-gate/usr/src/lib/libsqlite/test/ |
H A D | conflict.test | 66 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 D | trigger2.test | 77 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 D | memdb.test | 126 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 D | minmax.test | 26 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 D | misc3.test | 28 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 D | notnull.test | 184 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 D | join.test | 24 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 D | insert.test | 13 # 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 D | insert2.test | 52 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 D | trigger3.test | 36 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 D | trigger1.test | 54 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 D | misc1.test | 118 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 D | progress.test | 25 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 D | unique.test | 44 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 D | index.test | 258 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 D | join2.test | 24 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 D | crashme2.off | 9 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 D | misc2.test | 31 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 D | ioerr.test | 42 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 D | trans.test | 27 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 D | delete.test | 38 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 D | vacuum.test | 36 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 D | version.test | 29 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 D | rowid.test | 26 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 D | attach.test | 30 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 …]
|