Lines Matching refs:execsql
26 execsql {
34 set r [execsql {SELECT rowid FROM t1 ORDER BY x}]
45 execsql $sql
50 execsql $sql
55 execsql $sql
60 execsql $sql
65 execsql $sql
72 execsql "SELECT x FROM t1 WHERE rowid=$norow"
76 set v [execsql {SELECT x, oid FROM t1 order by x}]
82 set v [execsql {SELECT x, RowID FROM t1 order by x}]
88 set v [execsql {SELECT x, _rowid_ FROM t1 order by x}]
138 execsql $sql
139 execsql {SELECT x FROM t1 ORDER BY x}
144 execsql $sql
145 execsql {SELECT x FROM t1 ORDER BY x}
151 set v [catch {execsql {CREATE INDEX idxt1 ON t1(rowid)}} msg]
155 set v [catch {execsql {CREATE INDEX idxt1 ON t1(_rowid_)}} msg]
159 set v [catch {execsql {CREATE INDEX idxt1 ON t1(oid)}} msg]
163 set v [catch {execsql {CREATE INDEX idxt1 ON t1(x, rowid)}} msg]
171 execsql {
180 execsql {SELECT * FROM t2 ORDER BY rowid}
183 execsql {SELECT rowid, x, y FROM t2 ORDER BY rowid}
186 set r1 [execsql {SELECT _rowid_, rowid FROM t2 ORDER BY rowid}]
188 set r2 [execsql {SELECT _rowid_, rowid FROM t2 ORDER BY x DESC}]
193 set r1 [execsql {SELECT _rowid_, rowid FROM t2 ORDER BY rowid}]
201 execsql {
206 execsql "INSERT INTO t1(x,y) VALUES($i,[expr {$i*$i}])"
208 execsql {INSERT INTO t2 SELECT _rowid_, x*y, y*y FROM t1}
209 execsql {SELECT t2.y FROM t1, t2 WHERE t1.x==4 AND t1.rowid==t2.rowid}
212 execsql {SELECT t2.y FROM t2, t1 WHERE t1.x==4 AND t1.rowid==t2.rowid}
215 execsql {SELECT t2.y FROM t2, t1 WHERE t1.x==4 AND t1.oid==t2.rowid}
218 execsql {SELECT t2.y FROM t2, t1 WHERE t1.x==4 AND t1._rowid_==t2.rowid}
221 execsql {SELECT t2.y FROM t2, t1 WHERE t1.x==4 AND t2.rowid==t1.rowid}
224 execsql {SELECT t2.y FROM t2, t1 WHERE t2.rowid==t1.oid AND t1.x==4}
227 execsql {SELECT t2.y FROM t1, t2 WHERE t1.x==4 AND t1._rowid_==t2.rowid}
230 execsql {SELECT t2.y FROM t1, t2 WHERE t1.x==4 AND t2.rowid==t1.rowid}
233 execsql {SELECT t2.y FROM t1, t2 WHERE t2.rowid==t1.oid AND t1.x==4}
236 execsql {CREATE INDEX idxt1 ON t1(x)}
237 execsql {SELECT t2.y FROM t1, t2 WHERE t1.x==4 AND t1.rowid==t2.rowid}
240 execsql {SELECT t2.y FROM t1, t2 WHERE t1.x==4 AND t1._rowid_==t2.rowid}
243 execsql {SELECT t2.y FROM t1, t2 WHERE t2.rowid==t1.oid AND 4==t1.x}
246 execsql {SELECT t2.y FROM t2, t1 WHERE t1.x==4 AND t1.rowid==t2.rowid}
249 execsql {SELECT t2.y FROM t2, t1 WHERE t1.x==4 AND t1._rowid_==t2.rowid}
252 execsql {SELECT t2.y FROM t2, t1 WHERE t2.rowid==t1.oid AND 4==t1.x}
255 execsql {CREATE INDEX idxt2 ON t2(y)}
257 concat [execsql {
264 concat [execsql {
270 execsql {
277 execsql {DELETE FROM t1 WHERE _rowid_ IN (SELECT oid FROM t1 WHERE x>8)}
278 execsql {SELECT max(x) FROM t1}
284 execsql {
290 if {[execsql "SELECT x FROM t1 WHERE rowid=$::norow"]==""} break
292 execsql [subst {
297 execsql {
308 execsql {
317 execsql {
323 execsql {
330 execsql {
336 execsql {
343 execsql {
350 execsql {
355 execsql {
364 execsql {
375 execsql {
386 execsql {
391 execsql {
397 execsql {
402 execsql {
407 execsql {
413 execsql {
418 execsql {
427 execsql {
432 execsql {
437 execsql {
442 execsql {
447 execsql {
452 execsql {
457 execsql {
462 execsql {
467 execsql {
472 execsql {
481 execsql {
491 execsql {SELECT rowid, a FROM t5 WHERE rowid>=5.5}
494 execsql {SELECT rowid, a FROM t5 WHERE rowid>=5.0}
497 execsql {SELECT rowid, a FROM t5 WHERE rowid>5.5}
500 execsql {SELECT rowid, a FROM t5 WHERE rowid>5.0}
503 execsql {SELECT rowid, a FROM t5 WHERE 5.5<=rowid}
506 execsql {SELECT rowid, a FROM t5 WHERE 5.5<rowid}
509 execsql {SELECT rowid, a FROM t5 WHERE rowid<=5.5}
512 execsql {SELECT rowid, a FROM t5 WHERE rowid<5.5}
515 execsql {SELECT rowid, a FROM t5 WHERE 5.5>=rowid}
518 execsql {SELECT rowid, a FROM t5 WHERE 5.5>rowid}
521 execsql {SELECT rowid, a FROM t5 WHERE rowid>=5.5 ORDER BY rowid DESC}
524 execsql {SELECT rowid, a FROM t5 WHERE rowid>=5.0 ORDER BY rowid DESC}
527 execsql {SELECT rowid, a FROM t5 WHERE rowid>5.5 ORDER BY rowid DESC}
530 execsql {SELECT rowid, a FROM t5 WHERE rowid>5.0 ORDER BY rowid DESC}
533 execsql {SELECT rowid, a FROM t5 WHERE 5.5<=rowid ORDER BY rowid DESC}
536 execsql {SELECT rowid, a FROM t5 WHERE 5.5<rowid ORDER BY rowid DESC}
539 execsql {SELECT rowid, a FROM t5 WHERE rowid<=5.5 ORDER BY rowid DESC}
542 execsql {SELECT rowid, a FROM t5 WHERE rowid<5.5 ORDER BY rowid DESC}
545 execsql {SELECT rowid, a FROM t5 WHERE 5.5>=rowid ORDER BY rowid DESC}
548 execsql {SELECT rowid, a FROM t5 WHERE 5.5>rowid ORDER BY rowid DESC}
552 execsql {
559 execsql {SELECT rowid, a FROM t6 WHERE rowid>=-5.5}
562 execsql {SELECT rowid, a FROM t6 WHERE rowid>=-5.0}
565 execsql {SELECT rowid, a FROM t6 WHERE rowid>=-5.5 ORDER BY rowid DESC}
568 execsql {SELECT rowid, a FROM t6 WHERE rowid>=-5.0 ORDER BY rowid DESC}
571 execsql {SELECT rowid, a FROM t6 WHERE -5.5<=rowid}
574 execsql {SELECT rowid, a FROM t6 WHERE -5.5<=rowid ORDER BY rowid DESC}
577 execsql {SELECT rowid, a FROM t6 WHERE rowid>-5.5}
580 execsql {SELECT rowid, a FROM t6 WHERE rowid>-5.0}
583 execsql {SELECT rowid, a FROM t6 WHERE rowid>-5.5 ORDER BY rowid DESC}
586 execsql {SELECT rowid, a FROM t6 WHERE rowid>-5.0 ORDER BY rowid DESC}
589 execsql {SELECT rowid, a FROM t6 WHERE -5.5<rowid}
592 execsql {SELECT rowid, a FROM t6 WHERE -5.5<rowid ORDER BY rowid DESC}
595 execsql {SELECT rowid, a FROM t6 WHERE rowid<=-5.5}
598 execsql {SELECT rowid, a FROM t6 WHERE rowid<=-5.5 ORDER BY rowid DESC}
601 execsql {SELECT rowid, a FROM t6 WHERE -5.5>=rowid}
604 execsql {SELECT rowid, a FROM t6 WHERE -5.5>=rowid ORDER BY rowid DESC}
607 execsql {SELECT rowid, a FROM t6 WHERE rowid<-5.5}
610 execsql {SELECT rowid, a FROM t6 WHERE rowid<-5.5 ORDER BY rowid DESC}
613 execsql {SELECT rowid, a FROM t6 WHERE -5.5>rowid}
616 execsql {SELECT rowid, a FROM t6 WHERE -5.5>rowid ORDER BY rowid DESC}
622 execsql {SELECT rowid, a FROM t5 WHERE rowid>'abc'}
625 execsql {SELECT rowid, a FROM t5 WHERE rowid>='abc'}
628 execsql {SELECT rowid, a FROM t5 WHERE rowid<'abc'}
631 execsql {SELECT rowid, a FROM t5 WHERE rowid<='abc'}