Lines Matching refs:t1
50 CREATE TABLE t1(a,b,c);
51 INSERT INTO t1 VALUES(1,2,3);
58 SELECT rowid, * FROM (SELECT * FROM t1, t2);
61 SELECT 'rowid', * FROM (SELECT * FROM t1, t2);
67 CREATE VIEW v1 AS SELECT * FROM t1, t2;
79 SELECT * FROM (SELECT a, b AS 'a', c AS 'a', 4 AS 'a' FROM t1)
88 SELECT t1.b+t2.b AS a, t1.a, t2.a FROM t1, t2 WHERE a==10
97 INSERT INTO t1 VALUES(4000000000,'a','b');
98 SELECT a FROM t1 WHERE a>1;
103 INSERT INTO t1 VALUES(2147483648,'b2','c2');
104 INSERT INTO t1 VALUES(2147483647,'b3','c3');
105 SELECT a FROM t1 WHERE a>2147483647;
110 SELECT a FROM t1 WHERE a<2147483648;
115 SELECT a FROM t1 WHERE a<=2147483648;
120 SELECT a FROM t1 WHERE a<10000000000;
125 SELECT a FROM t1 WHERE a<1000000000000 ORDER BY 1;
155 CREATE TABLE t1(a,b);
156 INSERT INTO t1 VALUES(1,2);
157 SELECT * FROM t1;
174 CREATE TABLE t1(x);
175 INSERT INTO t1 VALUES(1);
176 INSERT INTO t1 VALUES(2);
177 INSERT INTO t1 VALUES(3);
178 SELECT * FROM t1;
183 db eval {SELECT rowid FROM t1} {} {
184 db eval "DELETE FROM t1 WHERE rowid=$rowid"
190 execsql {SELECT * FROM t1}
194 DELETE FROM t1;
195 INSERT INTO t1 VALUES(1);
196 INSERT INTO t1 VALUES(2);
197 INSERT INTO t1 VALUES(3);
198 INSERT INTO t1 VALUES(4);
200 db eval {SELECT rowid, x FROM t1} {
202 db eval {DELETE FROM t1 WHERE rowid=$rowid}
205 execsql {SELECT * FROM t1}
209 DELETE FROM t1;
210 INSERT INTO t1 VALUES(1);
211 INSERT INTO t1 VALUES(2);
212 INSERT INTO t1 VALUES(3);
213 INSERT INTO t1 VALUES(4);
215 db eval {SELECT rowid, x FROM t1} {
217 db eval {DELETE FROM t1 WHERE rowid=$rowid+1}
220 execsql {SELECT * FROM t1}
224 DELETE FROM t1;
225 INSERT INTO t1 VALUES(1);
226 INSERT INTO t1 VALUES(2);
227 INSERT INTO t1 VALUES(3);
228 INSERT INTO t1 VALUES(4);
230 db eval {SELECT rowid, x FROM t1} {
232 db eval {DELETE FROM t1}
235 execsql {SELECT * FROM t1}
239 DELETE FROM t1;
240 INSERT INTO t1 VALUES(1);
241 INSERT INTO t1 VALUES(2);
242 INSERT INTO t1 VALUES(3);
243 INSERT INTO t1 VALUES(4);
245 db eval {SELECT rowid, x FROM t1} {
247 db eval {UPDATE t1 SET x=x+100 WHERE rowid=$rowid}
250 execsql {SELECT * FROM t1}
254 DELETE FROM t1;
255 INSERT INTO t1 VALUES(1);
257 db eval {SELECT rowid, x FROM t1} {
259 db eval {INSERT INTO t1 VALUES($x+1)}
262 execsql {SELECT * FROM t1}
274 CREATE TABLE t1(x);
275 INSERT INTO t1 VALUES(1);
276 INSERT INTO t1 VALUES(2);
277 INSERT INTO t1 VALUES(3);
278 SELECT * FROM t1;
283 db eval {SELECT rowid FROM t1 ORDER BY rowid DESC} {} {
284 db eval "DELETE FROM t1 WHERE rowid=$rowid"
290 execsql {SELECT * FROM t1}
294 DELETE FROM t1;
295 INSERT INTO t1 VALUES(1);
296 INSERT INTO t1 VALUES(2);
297 INSERT INTO t1 VALUES(3);
298 INSERT INTO t1 VALUES(4);
300 db eval {SELECT rowid, x FROM t1 ORDER BY rowid DESC} {
302 db eval {DELETE FROM t1 WHERE rowid=$rowid}
305 execsql {SELECT * FROM t1}
309 DELETE FROM t1;
310 INSERT INTO t1 VALUES(1);
311 INSERT INTO t1 VALUES(2);
312 INSERT INTO t1 VALUES(3);
313 INSERT INTO t1 VALUES(4);
315 db eval {SELECT rowid, x FROM t1} {
317 db eval {DELETE FROM t1 WHERE rowid=$rowid+1}
320 execsql {SELECT * FROM t1}
324 DELETE FROM t1;
325 INSERT INTO t1 VALUES(1);
326 INSERT INTO t1 VALUES(2);
327 INSERT INTO t1 VALUES(3);
328 INSERT INTO t1 VALUES(4);
330 db eval {SELECT rowid, x FROM t1 ORDER BY rowid DESC} {
332 db eval {DELETE FROM t1}
335 execsql {SELECT * FROM t1}
339 DELETE FROM t1;
340 INSERT INTO t1 VALUES(1);
341 INSERT INTO t1 VALUES(2);
342 INSERT INTO t1 VALUES(3);
343 INSERT INTO t1 VALUES(4);
345 db eval {SELECT rowid, x FROM t1 ORDER BY rowid DESC} {
347 db eval {UPDATE t1 SET x=x+100 WHERE rowid=$rowid}
350 execsql {SELECT * FROM t1}
354 DELETE FROM t1;
355 INSERT INTO t1(rowid,x) VALUES(10,10);
357 db eval {SELECT rowid, x FROM t1 ORDER BY rowid DESC} {
359 db eval {INSERT INTO t1(rowid,x) VALUES($x-1,$x-1)}
362 execsql {SELECT * FROM t1}