Home
last modified time | relevance | path

Searched refs:VALUES (Results 1 – 25 of 69) sorted by relevance

123

/illumos-gate/usr/src/lib/libsqlite/test/
H A Dnotnull.test36 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 Dinsert.test23 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 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 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 Dtrigger2.test77 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 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);
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 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)
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 Dmisc1.test32 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 Dindex.test111 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 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 Dmisc3.test29 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 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 Dconflict.test66 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 Dtrigger1.test217 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 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);
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 Dinsert2.test27 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 Dbind.test25 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 Dselect6.test25 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 Dtemptable.test32 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 Drowid.test26 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 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)}
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 Din.test150 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 Dview.test22 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 Dsort.test143 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 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);

123