Home
last modified time | relevance | path

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

123

/titanic_44/usr/src/lib/libsqlite/test/
H A Dnotnull.test38 INSERT INTO t1(a,b,c,d,e) VALUES(1,2,3,4,5);
45 INSERT INTO t1(b,c,d,e) VALUES(2,3,4,5);
52 INSERT OR IGNORE INTO t1(b,c,d,e) VALUES(2,3,4,5);
59 INSERT OR REPLACE INTO t1(b,c,d,e) VALUES(2,3,4,5);
66 INSERT OR ABORT INTO t1(b,c,d,e) VALUES(2,3,4,5);
73 INSERT INTO t1(a,c,d,e) VALUES(1,3,4,5);
80 INSERT OR IGNORE INTO t1(a,c,d,e) VALUES(1,3,4,5);
87 INSERT OR REPLACE INTO t1(a,c,d,e) VALUES(1,3,4,5);
94 INSERT OR ABORT INTO t1(a,c,d,e) VALUES(1,3,4,5);
101 INSERT INTO t1(a,b,c,d,e) VALUES(1,null,3,4,5);
[all …]
H A Dinsert.test25 set v [catch {execsql {INSERT INTO test1 VALUES(1,2,3)}} msg]
32 set v [catch {execsql {INSERT INTO sqlite_master VALUES(1,2,3,4)}} msg]
40 set v [catch {execsql {INSERT INTO test1 VALUES(1,2)}} msg]
44 set v [catch {execsql {INSERT INTO test1 VALUES(1,2,3,4)}} msg]
48 set v [catch {execsql {INSERT INTO test1(one,two) VALUES(1,2,3,4)}} msg]
52 set v [catch {execsql {INSERT INTO test1(one,two) VALUES(1)}} msg]
59 set v [catch {execsql {INSERT INTO test1(one,four) VALUES(1,2)}} msg]
66 execsql {INSERT INTO test1 VALUES(1,2,3)}
70 execsql {INSERT INTO test1 VALUES(4,5,6)}
74 execsql {INSERT INTO test1 VALUES(7,8,9)}
[all …]
H A Dminmax.test28 INSERT INTO t1 VALUES(1,1);
29 INSERT INTO t1 VALUES(2,2);
30 INSERT INTO t1 VALUES(3,2);
31 INSERT INTO t1 VALUES(4,3);
32 INSERT INTO t1 VALUES(5,3);
33 INSERT INTO t1 VALUES(6,3);
34 INSERT INTO t1 VALUES(7,3);
35 INSERT INTO t1 VALUES(8,4);
36 INSERT INTO t1 VALUES(9,4);
37 INSERT INTO t1 VALUES(10,4);
[all …]
H A Djoin.test26 INSERT INTO t1 VALUES(1,2,3);
27 INSERT INTO t1 VALUES(2,3,4);
28 INSERT INTO t1 VALUES(3,4,5);
35 INSERT INTO t2 VALUES(1,2,3);
36 INSERT INTO t2 VALUES(2,3,4);
37 INSERT INTO t2 VALUES(3,4,5);
114 INSERT INTO t3 VALUES(2,3,4);
115 INSERT INTO t3 VALUES(3,4,5);
116 INSERT INTO t3 VALUES(4,5,6);
133 INSERT INTO t4 VALUES(2,3,4);
[all …]
H A Dtrigger3.test38 INSERT INTO tbl VALUES (5, 5, 6);
39 INSERT INTO tbl VALUES (1, 5, 6);
56 INSERT INTO tbl VALUES (5, 5, 6);
57 INSERT INTO tbl VALUES (2, 5, 6);
70 INSERT INTO tbl VALUES (5, 5, 6);
71 INSERT INTO tbl VALUES (3, 5, 6);
83 INSERT INTO tbl VALUES (5, 5, 6);
84 INSERT INTO tbl VALUES (4, 5, 6);
97 execsql {INSERT INTO tbl VALUES(1, 2, 3);}
98 execsql {INSERT INTO tbl VALUES(4, 5, 6);}
[all …]
H A Dtrigger2.test79 INSERT INTO tbl VALUES(1, 2);
80 INSERT INTO tbl VALUES(3, 4);
87 INSERT INTO rlog VALUES ( (SELECT coalesce(max(idx),0) + 1 FROM rlog),
95 INSERT INTO rlog VALUES ( (SELECT coalesce(max(idx),0) + 1 FROM rlog),
104 INSERT INTO clog VALUES ( (SELECT coalesce(max(idx),0) + 1 FROM clog),
126 INSERT INTO tbl VALUES (100, 100);
127 INSERT INTO tbl VALUES (300, 200);
130 INSERT INTO rlog VALUES ( (SELECT coalesce(max(idx),0) + 1 FROM rlog),
138 INSERT INTO rlog VALUES ( (SELECT coalesce(max(idx),0) + 1 FROM rlog),
158 INSERT INTO rlog VALUES ( (SELECT coalesce(max(idx),0) + 1 FROM rlog),
[all …]
H A Dunique.test46 INSERT INTO t1(a,b,c) VALUES(1,2,3)
51 INSERT INTO t1(a,b,c) VALUES(1,3,4)
61 INSERT INTO t1(a,b,c) VALUES(3,2,4)
71 INSERT INTO t1(a,b,c) VALUES(3,4,5)
85 INSERT INTO t2(a,b) VALUES(1,2);
86 INSERT INTO t2(a,b) VALUES(3,4);
102 INSERT INTO t2 VALUES(1,5);
118 INSERT INTO t2 VALUES(1,5)
153 INSERT INTO t3(a,b,c,d) VALUES(1,2,3,4);
159 INSERT INTO t3(a,b,c,d) VALUES(1,2,3,5);
[all …]
H A Djoin2.test26 INSERT INTO t1 VALUES(1,11);
27 INSERT INTO t1 VALUES(2,22);
28 INSERT INTO t1 VALUES(3,33);
35 INSERT INTO t2 VALUES(11,111);
36 INSERT INTO t2 VALUES(33,333);
37 INSERT INTO t2 VALUES(44,444);
44 INSERT INTO t3 VALUES(111,1111);
45 INSERT INTO t3 VALUES(444,4444);
46 INSERT INTO t3 VALUES(555,5555);
H A Dmisc1.test34 set cmd "INSERT INTO manycol VALUES(0"
47 set cmd "INSERT INTO manycol VALUES($j"
95 INSERT INTO agger VALUES(1, 'one', 'hello', 'yes');
96 INSERT INTO agger VALUES(2, 'two', 'howdy', 'no');
97 INSERT INTO agger VALUES(3, 'thr', 'howareya', 'yes');
98 INSERT INTO agger VALUES(4, 'two', 'lothere', 'yes');
99 INSERT INTO agger VALUES(5, 'one', 'atcha', 'yes');
100 INSERT INTO agger VALUES(6, 'two', 'hello', 'no');
120 INSERT INTO t1 VALUES('hi');
134 INSERT INTO t2 VALUES('This is a long string to use up a lot of disk -');
[all …]
H A Dindex.test113 execsql "INSERT INTO test1 VALUES($i,[expr {int(pow(2,$i))}])"
214 execsql "INSERT INTO test1 VALUES($i,[expr {int(pow(2,$i))}])"
260 INSERT INTO t1 VALUES(1,2);
261 INSERT INTO t1 VALUES(2,4);
262 INSERT INTO t1 VALUES(3,8);
263 INSERT INTO t1 VALUES(1,12);
287 INSERT INTO t1 VALUES (1,1);
288 INSERT INTO t1 VALUES (1,2);
289 INSERT INTO t1 VALUES (1,3);
290 INSERT INTO t1 VALUES (1,4);
[all …]
H A Dprogress.test27 INSERT INTO t1 VALUES(1);
28 INSERT INTO t1 VALUES(2);
29 INSERT INTO t1 VALUES(3);
30 INSERT INTO t1 VALUES(4);
31 INSERT INTO t1 VALUES(5);
32 INSERT INTO t1 VALUES(6);
33 INSERT INTO t1 VALUES(7);
34 INSERT INTO t1 VALUES(8);
35 INSERT INTO t1 VALUES(9);
36 INSERT INTO t1 VALUES(10);
[all …]
H A Dmisc3.test31 VALUES(1,'a23456789_b23456789_c23456789_d23456789_e23456789_');
37 INSERT INTO t1 VALUES(2,'x');
55 VALUES(1,'a23456789_b23456789_c23456789_d23456789_e23456789_');
68 INSERT INTO t1 VALUES(200,'hello out there');
118 INSERT INTO t2 VALUES(2147483648);
124 INSERT INTO t2 VALUES(-2147483649);
130 INSERT INTO t2 VALUES(+2147483649);
136 INSERT INTO t2 VALUES(+2147483647);
137 INSERT INTO t2 VALUES(-2147483648);
138 INSERT INTO t2 VALUES(-2147483647);
[all …]
H A Dconflict.test68 INSERT INTO t1 VALUES(1,2,3);
70 INSERT INTO t2 VALUES(1);
71 $cmd INTO t1 VALUES(1,2,4);
126 INSERT INTO t1 VALUES(1,2,3);
128 INSERT INTO t2 VALUES(1);
129 $cmd INTO t1 VALUES(1,2,4);
184 INSERT INTO t1 VALUES(1,2,3);
186 INSERT INTO t2 VALUES(1);
187 $cmd INTO t1 VALUES(1,2,4);
243 INSERT INTO t1 VALUES(1,2,3);
[all …]
H A Dtrigger1.test219 INSERT INTO t2 VALUES(NEW.a,NEW.b);
225 INSERT INTO t1 VALUES(1,2);
237 INSERT INTO t1 VALUES(1,2);
244 INSERT INTO t1 VALUES(1,2);
252 INSERT INTO t2 VALUES(NEW.a,NEW.b);
254 INSERT INTO t1 VALUES(1,2);
267 INSERT INTO t1 VALUES(3,4);
275 INSERT INTO t1 VALUES(5,6);
283 INSERT INTO t2 VALUES(NEW.a,NEW.b);
285 INSERT INTO t1 VALUES(7,8);
[all …]
H A Dmisc2.test33 INSERT INTO foo(bar) VALUES (1);
38 INSERT INTO foo(bar) VALUES (111);
47 INSERT INTO t1 VALUES(1,2,3);
49 INSERT INTO t2 VALUES(7,8,9);
73 INSERT INTO t1 VALUES(4000000000,'a','b');
79 INSERT INTO t1 VALUES(2147483648,'b2','c2');
80 INSERT INTO t1 VALUES(2147483647,'b3','c3');
130 INSERT INTO t1 VALUES(1,2);
145 INSERT INTO t1 VALUES(1);
157 db eval "INSERT INTO t1 VALUES(3)"
[all …]
H A Dinsert2.test29 execsql "INSERT INTO d1 VALUES($i,$j)"
96 INSERT INTO t4 VALUES(1,2);
133 INSERT INTO t4 VALUES(2,4);
134 INSERT INTO t4 VALUES(3,6);
135 INSERT INTO t4 VALUES(4,8);
136 INSERT INTO t4 VALUES(5,10);
137 INSERT INTO t4 VALUES(6,12);
138 INSERT INTO t4 VALUES(7,14);
139 INSERT INTO t4 VALUES(8,16);
140 INSERT INTO t4 VALUES(9,18);
[all …]
H A Dbind.test27 set VM [sqlite_compile $DB {INSERT INTO t1 VALUES(?,?,?)} TAIL]
31 sqlite_step $VM N VALUES COLNAMES
39 sqlite_step $VM N VALUES COLNAMES
47 sqlite_step $VM N VALUES COLNAMES
59 sqlite_step $VM N VALUES COLNAMES
65 sqlite_step $VM N VALUES COLNAMES
H A Dtemptable.test34 execsql {INSERT INTO t1 VALUES(1,2,3);}
54 INSERT INTO t2 VALUES(4,5,6);
63 catchsql {INSERT INTO t2 VALUES(8,9,0);}
66 db2 eval {INSERT INTO t2 VALUES(8,9,0);}
79 INSERT INTO t2 VALUES(7,6,5);
80 INSERT INTO t2 VALUES(4,3,2);
96 INSERT INTO t2 VALUES(1,2);
108 INSERT INTO t2 VALUES(1,2);
156 INSERT INTO t2 VALUES(10,20);
163 INSERT INTO t2 VALUES(9,8,7);
[all …]
H A Dselect6.test27 INSERT INTO t1 VALUES(1,1);
28 INSERT INTO t1 VALUES(2,2);
29 INSERT INTO t1 VALUES(3,2);
30 INSERT INTO t1 VALUES(4,3);
31 INSERT INTO t1 VALUES(5,3);
32 INSERT INTO t1 VALUES(6,3);
33 INSERT INTO t1 VALUES(7,3);
34 INSERT INTO t1 VALUES(8,4);
35 INSERT INTO t1 VALUES(9,4);
36 INSERT INTO t1 VALUES(10,4);
[all …]
H A Drowid.test28 INSERT INTO t1 VALUES(1,2);
29 INSERT INTO t1 VALUES(3,4);
97 INSERT INTO t1(rowid,x,y) VALUES(1234,5,6);
109 INSERT INTO t1(y,x,oid) VALUES(8,7,1235);
121 INSERT INTO t1(x,_rowid_,y) VALUES(9,1236,10);
173 INSERT INTO t2 VALUES(0,2,3);
174 INSERT INTO t2 VALUES(4,5,6);
175 INSERT INTO t2 VALUES(7,8,9);
206 execsql "INSERT INTO t1(x,y) VALUES($i,[expr {$i*$i}])"
312 INSERT INTO t1 VALUES(1,2);
[all …]
H A Din.test152 INSERT INTO t1 VALUES('hello', 'world');
167 INSERT INTO ta VALUES(1,1);
168 INSERT INTO ta VALUES(2,2);
169 INSERT INTO ta VALUES(3,3);
170 INSERT INTO ta VALUES(4,4);
171 INSERT INTO ta VALUES(6,6);
172 INSERT INTO ta VALUES(8,8);
173 INSERT INTO ta VALUES(10,
181 INSERT INTO tb VALUES(1,1);
182 INSERT INTO tb VALUES(2,2);
[all …]
H A Dsort.test145 INSERT INTO t2 VALUES('AGLIENTU',1);
146 INSERT INTO t2 VALUES('AGLIE`',2);
147 INSERT INTO t2 VALUES('AGNA',3);
159 INSERT INTO t2 VALUES('aglientu',1);
160 INSERT INTO t2 VALUES('aglie`',2);
161 INSERT INTO t2 VALUES('agna',3);
175 INSERT INTO t1 VALUES(9,'x2.7',3,'IX',4.0e5);
176 INSERT INTO t1 VALUES(10,'x5.0e10',3,'X',-4.0e5);
177 INSERT INTO t1 VALUES(11,'x-4.0e9',3,'XI',4.1e4);
178 INSERT INTO t1 VALUES(12,'x01234567890123456789',3,'XII',-4.2e3);
[all …]
H A Ddelete.test40 execsql {INSERT INTO table1 VALUES(1,2)}
41 execsql {INSERT INTO table1 VALUES(2,4)}
42 execsql {INSERT INTO table1 VALUES(3,8)}
43 execsql {INSERT INTO table1 VALUES(4,16)}
94 execsql "INSERT INTO table1 VALUES($i,[expr {$i*$i}])"
105 execsql "INSERT INTO table1 VALUES($i,[expr {$i*$i}])"
120 execsql "INSERT INTO table1 VALUES($i,[expr {$i*$i}])"
192 execsql {INSERT INTO table1 VALUES(2,3)}
200 execsql {INSERT INTO table2 VALUES(2,3)}
208 INSERT INTO t3 VALUES(1);
[all …]
H A Dcrashme2.off13 INSERT INTO t1 VALUES(1);
14 INSERT INTO t1 VALUES(2);
15 INSERT INTO t1 VALUES(3);
16 INSERT INTO t1 VALUES(4);
/titanic_44/usr/src/lib/common/
H A DMakefile.com32 VALUES = values-Xa.o values-Xc.o values-Xs.o values-Xt.o \
40 OBJECTS = $(VALUES) $(CRTI) $(CRTN)
51 $(VALUES) := CFLAGS += $(C_PICFLAGS)
52 $(VALUES) := CFLAGS64 += $(C_PICFLAGS64)

123