Lines Matching refs:t1
29 CREATE TABLE t1(a int, b int);
30 COPY t1 FROM 'data1.txt';
33 execsql {SELECT count(*) FROM t1}
39 execsql {SELECT a FROM t1 WHERE b BETWEEN 10 AND 50 ORDER BY a}
42 execsql {SELECT a FROM t1 WHERE b NOT BETWEEN 10 AND 50 ORDER BY a}
45 execsql {SELECT a FROM t1 WHERE b BETWEEN a AND a*5 ORDER BY a}
48 execsql {SELECT a FROM t1 WHERE b NOT BETWEEN a AND a*5 ORDER BY a}
51 execsql {SELECT a FROM t1 WHERE b BETWEEN a AND a*5 OR b=512 ORDER BY a}
54 execsql {SELECT a+ 100*(a BETWEEN 1 and 3) FROM t1 ORDER BY b}
61 execsql {SELECT a FROM t1 WHERE b IN (8,12,16,24,32) ORDER BY a}
64 execsql {SELECT a FROM t1 WHERE b NOT IN (8,12,16,24,32) ORDER BY a}
67 execsql {SELECT a FROM t1 WHERE b IN (8,12,16,24,32) OR b=512 ORDER BY a}
70 execsql {SELECT a FROM t1 WHERE b NOT IN (8,12,16,24,32) OR b=512 ORDER BY a}
73 execsql {SELECT a+100*(b IN (8,16,24)) FROM t1 ORDER BY b}
77 set v [catch {execsql {SELECT a FROM t1 WHERE b IN (b+10,20)}} msg]
81 set v [catch {execsql {SELECT a FROM t1 WHERE b IN (max(5,10,b),20)}} msg]
85 execsql {SELECT a FROM t1 WHERE b IN (8*2,64/2) ORDER BY b}
88 set v [catch {execsql {SELECT a FROM t1 WHERE b IN (max(5,10),20)}} msg]
92 set v [catch {execsql {SELECT a FROM t1 WHERE min(0,b IN (a,30))}} msg]
96 set v [catch {execsql {SELECT a FROM t1 WHERE c IN (10,20)}} msg]
104 SELECT a FROM t1
105 WHERE b IN (SELECT b FROM t1 WHERE a<5)
111 SELECT a FROM t1
112 WHERE b IN (SELECT b FROM t1 WHERE a<5) OR b==512
118 SELECT a + 100*(b IN (SELECT b FROM t1 WHERE a<5)) FROM t1 ORDER BY b
126 UPDATE t1 SET b=b*2
127 WHERE b IN (SELECT b FROM t1 WHERE a>8)
129 execsql {SELECT b FROM t1 ORDER BY b}
133 DELETE FROM t1 WHERE b IN (SELECT b FROM t1 WHERE a>8)
135 execsql {SELECT a FROM t1 ORDER BY a}
139 DELETE FROM t1 WHERE b NOT IN (SELECT b FROM t1 WHERE a>4)
141 execsql {SELECT a FROM t1 ORDER BY a}
150 INSERT INTO t1 VALUES('hello', 'world');
151 SELECT * FROM t1
235 SELECT a FROM t1 WHERE a IN ();
240 SELECT a FROM t1 WHERE a IN (5);
245 SELECT a FROM t1 WHERE a NOT IN () ORDER BY a;
250 SELECT a FROM t1 WHERE a IN (5) AND b IN ();
255 SELECT a FROM t1 WHERE a IN (5) AND b NOT IN ();
271 SELECT b FROM t1 WHERE a IN ('hello','there')
276 SELECT b FROM t1 WHERE a IN ("hello",'there')
290 SELECT b FROM t1 WHERE a IN t4;
295 SELECT b FROM t1 WHERE a NOT IN t4;
300 SELECT b FROM t1 WHERE a NOT IN tb;