Lines Matching refs:execsql

30   execsql {
35   execsql {SELECT count(*) FROM t1}
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]
105   execsql {
112   execsql {
119   execsql {
127   execsql {
131   execsql {SELECT b FROM t1 ORDER BY b}
134   execsql {
137   execsql {SELECT a FROM t1 ORDER BY a}
140   execsql {
143   execsql {SELECT a FROM t1 ORDER BY a}
151   execsql {
165   execsql {
179   execsql {
193   execsql {
198   execsql {
203   execsql {
208   execsql {
213   execsql {
218   execsql {
223   execsql {
228   execsql {
236   execsql {
241   execsql {
246   execsql {
251   execsql {
256   execsql {
261   execsql {
266   execsql {
272   execsql {
277   execsql {
285   execsql {
291   execsql {
296   execsql {