/illumos-gate/usr/src/lib/libsqlite/test/ |
H A D | notnull.test | 36 INSERT INTO t1(a,b,c,d,e) VALUES(1,2,3,4,5); 43 INSERT INTO t1(b,c,d,e) VALUES(2,3,4,5); 50 INSERT OR IGNORE INTO t1(b,c,d,e) VALUES(2,3,4,5); 57 INSERT OR REPLACE INTO t1(b,c,d,e) VALUES(2,3,4,5); 64 INSERT OR ABORT INTO t1(b,c,d,e) VALUES(2,3,4,5); 71 INSERT INTO t1(a,c,d,e) VALUES(1,3,4,5); 78 INSERT OR IGNORE INTO t1(a,c,d,e) VALUES(1,3,4,5); 85 INSERT OR REPLACE INTO t1(a,c,d,e) VALUES(1,3,4,5); 92 INSERT OR ABORT INTO t1(a,c,d,e) VALUES(1,3,4,5); 99 INSERT INTO t1(a,b,c,d,e) VALUES(1,null,3,4,5); [all …]
|
H A D | insert.test | 23 set v [catch {execsql {INSERT INTO test1 VALUES(1,2,3)}} msg] 30 set v [catch {execsql {INSERT INTO sqlite_master VALUES(1,2,3,4)}} msg] 38 set v [catch {execsql {INSERT INTO test1 VALUES(1,2)}} msg] 42 set v [catch {execsql {INSERT INTO test1 VALUES(1,2,3,4)}} msg] 46 set v [catch {execsql {INSERT INTO test1(one,two) VALUES(1,2,3,4)}} msg] 50 set v [catch {execsql {INSERT INTO test1(one,two) VALUES(1)}} msg] 57 set v [catch {execsql {INSERT INTO test1(one,four) VALUES(1,2)}} msg] 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)} [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 | 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 | trigger2.test | 77 INSERT INTO tbl VALUES(1, 2); 78 INSERT INTO tbl VALUES(3, 4); 85 INSERT INTO rlog VALUES ( (SELECT coalesce(max(idx),0) + 1 FROM rlog), 93 INSERT INTO rlog VALUES ( (SELECT coalesce(max(idx),0) + 1 FROM rlog), 102 INSERT INTO clog VALUES ( (SELECT coalesce(max(idx),0) + 1 FROM clog), 124 INSERT INTO tbl VALUES (100, 100); 125 INSERT INTO tbl VALUES (300, 200); 128 INSERT INTO rlog VALUES ( (SELECT coalesce(max(idx),0) + 1 FROM rlog), 136 INSERT INTO rlog VALUES ( (SELECT coalesce(max(idx),0) + 1 FROM rlog), 156 INSERT INTO rlog VALUES ( (SELECT coalesce(max(idx),0) + 1 FROM rlog), [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); 82 INSERT INTO tbl VALUES (4, 5, 6); 95 execsql {INSERT INTO tbl VALUES(1, 2, 3);} 96 execsql {INSERT INTO tbl VALUES(4, 5, 6);} [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) 151 INSERT INTO t3(a,b,c,d) VALUES(1,2,3,4); 157 INSERT INTO t3(a,b,c,d) VALUES(1,2,3,5); [all …]
|
H A D | misc1.test | 32 set cmd "INSERT INTO manycol VALUES(0" 45 set cmd "INSERT INTO manycol VALUES($j" 93 INSERT INTO agger VALUES(1, 'one', 'hello', 'yes'); 94 INSERT INTO agger VALUES(2, 'two', 'howdy', 'no'); 95 INSERT INTO agger VALUES(3, 'thr', 'howareya', 'yes'); 96 INSERT INTO agger VALUES(4, 'two', 'lothere', 'yes'); 97 INSERT INTO agger VALUES(5, 'one', 'atcha', 'yes'); 98 INSERT INTO agger VALUES(6, 'two', 'hello', 'no'); 118 INSERT INTO t1 VALUES('hi'); 132 INSERT INTO t2 VALUES('This is a long string to use up a lot of disk -'); [all …]
|
H A D | index.test | 111 execsql "INSERT INTO test1 VALUES($i,[expr {int(pow(2,$i))}])" 212 execsql "INSERT INTO test1 VALUES($i,[expr {int(pow(2,$i))}])" 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); [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 | misc3.test | 29 VALUES(1,'a23456789_b23456789_c23456789_d23456789_e23456789_'); 35 INSERT INTO t1 VALUES(2,'x'); 53 VALUES(1,'a23456789_b23456789_c23456789_d23456789_e23456789_'); 66 INSERT INTO t1 VALUES(200,'hello out there'); 116 INSERT INTO t2 VALUES(2147483648); 122 INSERT INTO t2 VALUES(-2147483649); 128 INSERT INTO t2 VALUES(+2147483649); 134 INSERT INTO t2 VALUES(+2147483647); 135 INSERT INTO t2 VALUES(-2147483648); 136 INSERT INTO t2 VALUES(-2147483647); [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 | conflict.test | 66 INSERT INTO t1 VALUES(1,2,3); 68 INSERT INTO t2 VALUES(1); 69 $cmd INTO t1 VALUES(1,2,4); 124 INSERT INTO t1 VALUES(1,2,3); 126 INSERT INTO t2 VALUES(1); 127 $cmd INTO t1 VALUES(1,2,4); 182 INSERT INTO t1 VALUES(1,2,3); 184 INSERT INTO t2 VALUES(1); 185 $cmd INTO t1 VALUES(1,2,4); 241 INSERT INTO t1 VALUES(1,2,3); [all …]
|
H A D | trigger1.test | 217 INSERT INTO t2 VALUES(NEW.a,NEW.b); 223 INSERT INTO t1 VALUES(1,2); 235 INSERT INTO t1 VALUES(1,2); 242 INSERT INTO t1 VALUES(1,2); 250 INSERT INTO t2 VALUES(NEW.a,NEW.b); 252 INSERT INTO t1 VALUES(1,2); 265 INSERT INTO t1 VALUES(3,4); 273 INSERT INTO t1 VALUES(5,6); 281 INSERT INTO t2 VALUES(NEW.a,NEW.b); 283 INSERT INTO t1 VALUES(7,8); [all …]
|
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); 71 INSERT INTO t1 VALUES(4000000000,'a','b'); 77 INSERT INTO t1 VALUES(2147483648,'b2','c2'); 78 INSERT INTO t1 VALUES(2147483647,'b3','c3'); 128 INSERT INTO t1 VALUES(1,2); 143 INSERT INTO t1 VALUES(1); 155 db eval "INSERT INTO t1 VALUES(3)" [all …]
|
H A D | insert2.test | 27 execsql "INSERT INTO d1 VALUES($i,$j)" 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); 138 INSERT INTO t4 VALUES(9,18); [all …]
|
H A D | bind.test | 25 set VM [sqlite_compile $DB {INSERT INTO t1 VALUES(?,?,?)} TAIL] 29 sqlite_step $VM N VALUES COLNAMES 37 sqlite_step $VM N VALUES COLNAMES 45 sqlite_step $VM N VALUES COLNAMES 57 sqlite_step $VM N VALUES COLNAMES 63 sqlite_step $VM N VALUES COLNAMES
|
H A D | select6.test | 25 INSERT INTO t1 VALUES(1,1); 26 INSERT INTO t1 VALUES(2,2); 27 INSERT INTO t1 VALUES(3,2); 28 INSERT INTO t1 VALUES(4,3); 29 INSERT INTO t1 VALUES(5,3); 30 INSERT INTO t1 VALUES(6,3); 31 INSERT INTO t1 VALUES(7,3); 32 INSERT INTO t1 VALUES(8,4); 33 INSERT INTO t1 VALUES(9,4); 34 INSERT INTO t1 VALUES(10,4); [all …]
|
H A D | temptable.test | 32 execsql {INSERT INTO t1 VALUES(1,2,3);} 52 INSERT INTO t2 VALUES(4,5,6); 61 catchsql {INSERT INTO t2 VALUES(8,9,0);} 64 db2 eval {INSERT INTO t2 VALUES(8,9,0);} 77 INSERT INTO t2 VALUES(7,6,5); 78 INSERT INTO t2 VALUES(4,3,2); 94 INSERT INTO t2 VALUES(1,2); 106 INSERT INTO t2 VALUES(1,2); 154 INSERT INTO t2 VALUES(10,20); 161 INSERT INTO t2 VALUES(9,8,7); [all …]
|
H A D | rowid.test | 26 INSERT INTO t1 VALUES(1,2); 27 INSERT INTO t1 VALUES(3,4); 95 INSERT INTO t1(rowid,x,y) VALUES(1234,5,6); 107 INSERT INTO t1(y,x,oid) VALUES(8,7,1235); 119 INSERT INTO t1(x,_rowid_,y) VALUES(9,1236,10); 171 INSERT INTO t2 VALUES(0,2,3); 172 INSERT INTO t2 VALUES(4,5,6); 173 INSERT INTO t2 VALUES(7,8,9); 204 execsql "INSERT INTO t1(x,y) VALUES($i,[expr {$i*$i}])" 310 INSERT INTO t1 VALUES(1,2); [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)} 41 execsql {INSERT INTO table1 VALUES(4,16)} 92 execsql "INSERT INTO table1 VALUES($i,[expr {$i*$i}])" 103 execsql "INSERT INTO table1 VALUES($i,[expr {$i*$i}])" 118 execsql "INSERT INTO table1 VALUES($i,[expr {$i*$i}])" 190 execsql {INSERT INTO table1 VALUES(2,3)} 198 execsql {INSERT INTO table2 VALUES(2,3)} 206 INSERT INTO t3 VALUES(1); [all …]
|
H A D | in.test | 150 INSERT INTO t1 VALUES('hello', 'world'); 165 INSERT INTO ta VALUES(1,1); 166 INSERT INTO ta VALUES(2,2); 167 INSERT INTO ta VALUES(3,3); 168 INSERT INTO ta VALUES(4,4); 169 INSERT INTO ta VALUES(6,6); 170 INSERT INTO ta VALUES(8,8); 171 INSERT INTO ta VALUES(10, 179 INSERT INTO tb VALUES(1,1); 180 INSERT INTO tb VALUES(2,2); [all …]
|
H A D | view.test | 22 INSERT INTO t1 VALUES(1,2,3); 23 INSERT INTO t1 VALUES(4,5,6); 24 INSERT INTO t1 VALUES(7,8,9); 76 INSERT INTO t1 VALUES(1,2,3,4); 77 INSERT INTO t1 VALUES(4,5,6,7); 78 INSERT INTO t1 VALUES(7,8,9,10); 100 INSERT INTO v2 VALUES(1,2,3,4); 115 INSERT INTO t1 VALUES(11,12,13,14); 191 INSERT INTO t2 VALUES(22,2); 192 INSERT INTO t2 VALUES(33,3); [all …]
|
H A D | sort.test | 143 INSERT INTO t2 VALUES('AGLIENTU',1); 144 INSERT INTO t2 VALUES('AGLIE`',2); 145 INSERT INTO t2 VALUES('AGNA',3); 157 INSERT INTO t2 VALUES('aglientu',1); 158 INSERT INTO t2 VALUES('aglie`',2); 159 INSERT INTO t2 VALUES('agna',3); 173 INSERT INTO t1 VALUES(9,'x2.7',3,'IX',4.0e5); 174 INSERT INTO t1 VALUES(10,'x5.0e10',3,'X',-4.0e5); 175 INSERT INTO t1 VALUES(11,'x-4.0e9',3,'XI',4.1e4); 176 INSERT INTO t1 VALUES(12,'x01234567890123456789',3,'XII',-4.2e3); [all …]
|
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);
|