Lines Matching refs:a
7 # a legal notice, here is a blessing:
31 CREATE TABLE t1(a int, b int);
41 execsql {SELECT a FROM t1 WHERE b BETWEEN 10 AND 50 ORDER BY a}
44 execsql {SELECT a FROM t1 WHERE b NOT BETWEEN 10 AND 50 ORDER BY a}
47 execsql {SELECT a FROM t1 WHERE b BETWEEN a AND a*5 ORDER BY a}
50 execsql {SELECT a FROM t1 WHERE b NOT BETWEEN a AND a*5 ORDER BY a}
53 execsql {SELECT a FROM t1 WHERE b BETWEEN a AND a*5 OR b=512 ORDER BY a}
56 execsql {SELECT a+ 100*(a BETWEEN 1 and 3) FROM t1 ORDER BY b}
63 execsql {SELECT a FROM t1 WHERE b IN (8,12,16,24,32) ORDER BY a}
66 execsql {SELECT a FROM t1 WHERE b NOT IN (8,12,16,24,32) ORDER BY a}
69 execsql {SELECT a FROM t1 WHERE b IN (8,12,16,24,32) OR b=512 ORDER BY a}
72 execsql {SELECT a FROM t1 WHERE b NOT IN (8,12,16,24,32) OR b=512 ORDER BY a}
75 execsql {SELECT a+100*(b IN (8,16,24)) FROM t1 ORDER BY b}
79 set v [catch {execsql {SELECT a FROM t1 WHERE b IN (b+10,20)}} msg]
83 set v [catch {execsql {SELECT a FROM t1 WHERE b IN (max(5,10,b),20)}} msg]
87 execsql {SELECT a FROM t1 WHERE b IN (8*2,64/2) ORDER BY b}
90 set v [catch {execsql {SELECT a FROM t1 WHERE b IN (max(5,10),20)}} msg]
94 set v [catch {execsql {SELECT a FROM t1 WHERE min(0,b IN (a,30))}} msg]
98 set v [catch {execsql {SELECT a FROM t1 WHERE c IN (10,20)}} msg]
102 # Testing the IN operator where the right-hand side is a SELECT
106 SELECT a FROM t1
107 WHERE b IN (SELECT b FROM t1 WHERE a<5)
108 ORDER BY a
113 SELECT a FROM t1
114 WHERE b IN (SELECT b FROM t1 WHERE a<5) OR b==512
115 ORDER BY a
120 SELECT a + 100*(b IN (SELECT b FROM t1 WHERE a<5)) FROM t1 ORDER BY b
129 WHERE b IN (SELECT b FROM t1 WHERE a>8)
135 DELETE FROM t1 WHERE b IN (SELECT b FROM t1 WHERE a>8)
137 execsql {SELECT a FROM t1 ORDER BY a}
141 DELETE FROM t1 WHERE b NOT IN (SELECT b FROM t1 WHERE a>4)
143 execsql {SELECT a FROM t1 ORDER BY a}
146 # Do an IN with a constant RHS but where the RHS has many, many
154 WHERE a IN (
155 'Do','an','IN','with','a','constant','RHS','but','where','the',
166 CREATE TABLE ta(a INTEGER PRIMARY KEY, b);
174 'This is a key that is long enough to require a malloc in the VDBE');
175 SELECT * FROM ta WHERE a<10;
180 CREATE TABLE tb(a INTEGER PRIMARY KEY, b);
188 'This is a key that is long enough to require a malloc in the VDBE');
189 SELECT * FROM tb WHERE a<10;
194 SELECT a FROM ta WHERE b IN (SELECT a FROM tb);
199 SELECT a FROM ta WHERE b NOT IN (SELECT a FROM tb);
204 SELECT a FROM ta WHERE b IN (SELECT b FROM tb);
209 SELECT a FROM ta WHERE b NOT IN (SELECT b FROM tb);
214 SELECT a FROM ta WHERE a IN (SELECT a FROM tb);
219 SELECT a FROM ta WHERE a NOT IN (SELECT a FROM tb);
224 SELECT a FROM ta WHERE a IN (SELECT b FROM tb);
229 SELECT a FROM ta WHERE a NOT IN (SELECT b FROM tb);
237 SELECT a FROM t1 WHERE a IN ();
242 SELECT a FROM t1 WHERE a IN (5);
247 SELECT a FROM t1 WHERE a NOT IN () ORDER BY a;
252 SELECT a FROM t1 WHERE a IN (5) AND b IN ();
257 SELECT a FROM t1 WHERE a IN (5) AND b NOT IN ();
262 SELECT a FROM ta WHERE a IN ();
267 SELECT a FROM ta WHERE a NOT IN ();
273 SELECT b FROM t1 WHERE a IN ('hello','there')
278 SELECT b FROM t1 WHERE a IN ("hello",'there')
286 CREATE TABLE t4 AS SELECT a FROM tb;
292 SELECT b FROM t1 WHERE a IN t4;
297 SELECT b FROM t1 WHERE a NOT IN t4;
302 SELECT b FROM t1 WHERE a NOT IN tb;
304 } {1 {only a single result allowed for a SELECT that is part of an expression}}