Lines Matching refs:execsql

28   execsql {
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]
103   execsql {
110   execsql {
117   execsql {
125   execsql {
129   execsql {SELECT b FROM t1 ORDER BY b}
132   execsql {
135   execsql {SELECT a FROM t1 ORDER BY a}
138   execsql {
141   execsql {SELECT a FROM t1 ORDER BY a}
149   execsql {
163   execsql {
177   execsql {
191   execsql {
196   execsql {
201   execsql {
206   execsql {
211   execsql {
216   execsql {
221   execsql {
226   execsql {
234   execsql {
239   execsql {
244   execsql {
249   execsql {
254   execsql {
259   execsql {
264   execsql {
270   execsql {
275   execsql {
283   execsql {
289   execsql {
294   execsql {