Lines Matching refs:execsql

23   execsql {
30       execsql "INSERT INTO t1 VALUES([expr {$i}],[expr {$j}])"
33   execsql {
41   execsql { CREATE TABLE t1(x, y) }
76   execsql { DROP TABLE t1 }
81     execsql {SELECT count(*) FROM t1}
84     execsql {DELETE FROM t1}
85     execsql {SELECT count(*) FROM t1}
89     execsql {DELETE FROM t1 LIMIT 5}
90     execsql {SELECT count(*) FROM t1}
94     execsql {DELETE FROM t1 ORDER BY x LIMIT 5}
95     execsql {SELECT count(*) FROM t1}
100     execsql {DELETE FROM t1 RETURNING x, y, '|' ORDER BY x, y LIMIT 5}
103     execsql {SELECT count(*) FROM t1}
107     execsql {DELETE FROM t1 RETURNING x, y, '|' ORDER BY x  LIMIT 5 OFFSET 2}
110     execsql {SELECT count(*) FROM t1}
114     execsql {DELETE FROM t1 ORDER BY x LIMIT 5 OFFSET -2}
115     execsql {SELECT count(*) FROM t1}
119     execsql {DELETE FROM t1 ORDER BY x LIMIT 2, -5}
120     execsql {SELECT count(*) FROM t1}
124     execsql {DELETE FROM t1 ORDER BY x LIMIT -2, 5}
125     execsql {SELECT count(*) FROM t1}
130     execsql {DELETE FROM t1 ORDER BY x LIMIT -2, -5}
131     execsql {SELECT count(*) FROM t1}
136     execsql {DELETE FROM t1 ORDER BY x LIMIT 2, 5}
137     execsql {SELECT count(*) FROM t1}
141     execsql {DELETE FROM t1 ORDER BY x LIMIT 5 OFFSET 5}
142     execsql {SELECT count(*) FROM t1}
146     execsql {DELETE FROM t1 ORDER BY x LIMIT 50 OFFSET 30}
147     execsql {SELECT count(*) FROM t1}
151     execsql {DELETE FROM t1 ORDER BY x LIMIT 30, 50}
152     execsql {SELECT count(*) FROM t1}
155     execsql {DELETE FROM t1 ORDER BY x LIMIT 50 OFFSET 50}
156     execsql {SELECT count(*) FROM t1}
162     execsql {SELECT count(*) FROM t1}
165     execsql {DELETE FROM t1 WHERE x=1}
166     execsql {SELECT count(*) FROM t1}
170     execsql {DELETE FROM t1 WHERE x=1 LIMIT 5}
171     execsql {SELECT count(*) FROM t1}
175     execsql {DELETE FROM t1 WHERE x=1 ORDER BY x LIMIT 5}
176     execsql {SELECT count(*) FROM t1}
180     execsql {DELETE FROM t1 WHERE x=2 ORDER BY x LIMIT 5 OFFSET 2}
181     execsql {SELECT count(*) FROM t1}
185     execsql {DELETE FROM t1 WHERE x=2 ORDER BY x LIMIT 5 OFFSET -2}
186     execsql {SELECT count(*) FROM t1}
190     execsql {DELETE FROM t1 WHERE x=3 ORDER BY x LIMIT 2, -5}
191     execsql {SELECT count(*) FROM t1}
195     execsql {DELETE FROM t1 WHERE x=3 ORDER BY x LIMIT -2, 5}
196     execsql {SELECT count(*) FROM t1}
200     execsql {DELETE FROM t1 WHERE x=4 ORDER BY x LIMIT -2, -5}
201     execsql {SELECT count(*) FROM t1}
206     execsql {DELETE FROM t1 WHERE x=5 ORDER BY x LIMIT 2, 5}
207     execsql {SELECT count(*) FROM t1}
211     execsql {DELETE FROM t1 WHERE x=6 ORDER BY x LIMIT 5 OFFSET 5}
212     execsql {SELECT count(*) FROM t1}
216     execsql {DELETE FROM t1 WHERE x=1 ORDER BY x LIMIT 50 OFFSET 30}
217     execsql {SELECT count(*) FROM t1}
221     execsql {DELETE FROM t1 WHERE x=2 ORDER BY x LIMIT 30, 50}
222     execsql {SELECT count(*) FROM t1}
225     execsql {DELETE FROM t1 WHERE x=3 ORDER BY x LIMIT 50 OFFSET 50}
226     execsql {SELECT count(*) FROM t1}
232     execsql {SELECT count(*) FROM t1}
235     execsql {UPDATE t1 SET y=1 WHERE x=1}
236     execsql {SELECT count(*) FROM t1 WHERE y=1}
240     execsql {UPDATE t1 SET y=1 WHERE x=1 RETURNING x, y, '|' LIMIT 5}
243     execsql {SELECT count(*) FROM t1 WHERE y=1}
247     execsql {UPDATE t1 SET y=2 WHERE x=2 ORDER BY x LIMIT 5}
248     execsql {SELECT count(*) FROM t1 WHERE y=2}
253     execsql {UPDATE t1 SET y=2 WHERE x=2 ORDER BY x LIMIT 5 OFFSET 2}
254     execsql {SELECT count(*) FROM t1 WHERE y=1}
258     execsql {UPDATE t1 SET y=2 WHERE x=2 ORDER BY x LIMIT 5 OFFSET -2}
259     execsql {SELECT count(*) FROM t1 WHERE y=1}
263     execsql {UPDATE t1 SET y=3 WHERE x=3 ORDER BY x LIMIT 2, -5}
264     execsql {SELECT count(*) FROM t1 WHERE y=3}
268     execsql {UPDATE t1 SET y=3 WHERE x=3 ORDER BY x LIMIT -2, 5}
269     execsql {SELECT count(*) FROM t1 WHERE y=3}
274     execsql {UPDATE t1 SET y=4 WHERE x=4 ORDER BY x LIMIT -2, -5}
275     execsql {SELECT count(*) FROM t1 WHERE y=4}
280     execsql {UPDATE t1 SET y=4 WHERE x=5 ORDER BY x LIMIT 2, 5}
281     execsql {SELECT count(*) FROM t1 WHERE y=4}
285     execsql {UPDATE t1 SET y=4 WHERE x=6 ORDER BY x LIMIT 5 OFFSET 5}
286     execsql {SELECT count(*) FROM t1 WHERE y=1}
290     execsql {UPDATE t1 SET y=1 WHERE x=1 ORDER BY x LIMIT 50 OFFSET 30}
291     execsql {SELECT count(*) FROM t1 WHERE y=1}
295     execsql {UPDATE t1 SET y=1 WHERE x=2 ORDER BY x LIMIT 30, 50}
296     execsql {SELECT count(*) FROM t1 WHERE y=1}
299     execsql {UPDATE t1 SET y=1 WHERE x=3 ORDER BY x LIMIT 50 OFFSET 50}
300     execsql {SELECT count(*) FROM t1 WHERE y=1}