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}
153 set v [catch {execsql {CREATE INDEX idxt1 ON t1(rowid)}} msg]
157 set v [catch {execsql {CREATE INDEX idxt1 ON t1(_rowid_)}} msg]
161 set v [catch {execsql {CREATE INDEX idxt1 ON t1(oid)}} msg]
165 set v [catch {execsql {CREATE INDEX idxt1 ON t1(x, rowid)}} msg]
174 execsql {
183 execsql {SELECT * FROM t2 ORDER BY rowid}
186 execsql {SELECT rowid, x, y FROM t2 ORDER BY rowid}
189 set r1 [execsql {SELECT _rowid_, rowid FROM t2 ORDER BY rowid}]
191 set r2 [execsql {SELECT _rowid_, rowid FROM t2 ORDER BY x DESC}]
198 set r1 [execsql {SELECT _rowid_, rowid FROM t2 ORDER BY rowid}]
207 execsql {
212 execsql "INSERT INTO t1(x,y) VALUES($i,[expr {$i*$i}])"
214 execsql {INSERT INTO t2 SELECT _rowid_, x*y, y*y FROM t1}
215 execsql {SELECT t2.y FROM t1, t2 WHERE t1.x==4 AND t1.rowid==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 t1.oid==t2.rowid}
224 execsql {SELECT t2.y FROM t2, t1 WHERE t1.x==4 AND t1._rowid_==t2.rowid}
227 execsql {SELECT t2.y FROM t2, t1 WHERE t1.x==4 AND t2.rowid==t1.rowid}
230 execsql {SELECT t2.y FROM t2, t1 WHERE t2.rowid==t1.oid AND t1.x==4}
233 execsql {SELECT t2.y FROM t1, t2 WHERE t1.x==4 AND t1._rowid_==t2.rowid}
236 execsql {SELECT t2.y FROM t1, t2 WHERE t1.x==4 AND t2.rowid==t1.rowid}
239 execsql {SELECT t2.y FROM t1, t2 WHERE t2.rowid==t1.oid AND t1.x==4}
242 execsql {CREATE INDEX idxt1 ON t1(x)}
243 execsql {SELECT t2.y FROM t1, t2 WHERE t1.x==4 AND t1.rowid==t2.rowid}
246 execsql {SELECT t2.y FROM t1, t2 WHERE t1.x==4 AND t1._rowid_==t2.rowid}
249 execsql {SELECT t2.y FROM t1, t2 WHERE t2.rowid==t1.oid AND 4==t1.x}
252 execsql {SELECT t2.y FROM t2, t1 WHERE t1.x==4 AND t1.rowid==t2.rowid}
255 execsql {SELECT t2.y FROM t2, t1 WHERE t1.x==4 AND t1._rowid_==t2.rowid}
258 execsql {SELECT t2.y FROM t2, t1 WHERE t2.rowid==t1.oid AND 4==t1.x}
261 execsql {CREATE INDEX idxt2 ON t2(y)}
263 concat [execsql {
270 concat [execsql {
276 execsql {
284 execsql {DELETE FROM t1 WHERE _rowid_ IN (SELECT oid FROM t1 WHERE x>8)}
286 set oids [execsql {SELECT oid FROM t1 WHERE x>8}]
288 execsql "DELETE FROM t1 WHERE $where"
292 execsql {SELECT max(x) FROM t1}
298 execsql {
304 if {[execsql "SELECT x FROM t1 WHERE rowid=$::norow"]==""} break
306 execsql [subst {
311 execsql {
322 execsql {
331 execsql {
337 execsql {
344 execsql {
350 execsql {
357 execsql {
365 execsql {
370 execsql {
381 execsql {
393 execsql {
404 execsql {
409 execsql {
415 execsql {
420 execsql {
425 execsql {
431 execsql {
436 execsql {
445 execsql {
456 execsql {
461 execsql {
466 execsql {
471 execsql {
476 execsql {
481 execsql {
486 execsql {
491 execsql {
496 execsql {
501 execsql {
510 execsql {
520 execsql {SELECT rowid, a FROM t5 WHERE rowid>=5.5}
523 execsql {SELECT rowid, a FROM t5 WHERE rowid>=5.0}
526 execsql {SELECT rowid, a FROM t5 WHERE rowid>5.5}
529 execsql {SELECT rowid, a FROM t5 WHERE rowid>5.0}
532 execsql {SELECT rowid, a FROM t5 WHERE 5.5<=rowid}
535 execsql {SELECT rowid, a FROM t5 WHERE 5.5<rowid}
538 execsql {SELECT rowid, a FROM t5 WHERE rowid<=5.5}
541 execsql {SELECT rowid, a FROM t5 WHERE rowid<5.5}
544 execsql {SELECT rowid, a FROM t5 WHERE 5.5>=rowid}
547 execsql {SELECT rowid, a FROM t5 WHERE 5.5>rowid}
550 execsql {SELECT rowid, a FROM t5 WHERE rowid>=5.5 ORDER BY rowid DESC}
553 execsql {SELECT rowid, a FROM t5 WHERE rowid>=5.0 ORDER BY rowid DESC}
556 execsql {SELECT rowid, a FROM t5 WHERE rowid>5.5 ORDER BY rowid DESC}
559 execsql {SELECT rowid, a FROM t5 WHERE rowid>5.0 ORDER BY rowid DESC}
562 execsql {SELECT rowid, a FROM t5 WHERE 5.5<=rowid ORDER BY rowid DESC}
565 execsql {SELECT rowid, a FROM t5 WHERE 5.5<rowid ORDER BY rowid DESC}
568 execsql {SELECT rowid, a FROM t5 WHERE rowid<=5.5 ORDER BY rowid DESC}
571 execsql {SELECT rowid, a FROM t5 WHERE rowid<5.5 ORDER BY rowid DESC}
574 execsql {SELECT rowid, a FROM t5 WHERE 5.5>=rowid ORDER BY rowid DESC}
577 execsql {SELECT rowid, a FROM t5 WHERE 5.5>rowid ORDER BY rowid DESC}
581 execsql {
588 execsql {SELECT rowid, a FROM t6 WHERE rowid>=-5.5}
591 execsql {SELECT rowid, a FROM t6 WHERE rowid>=-5.0}
594 execsql {SELECT rowid, a FROM t6 WHERE rowid>=-5.5 ORDER BY rowid DESC}
597 execsql {SELECT rowid, a FROM t6 WHERE rowid>=-5.0 ORDER BY rowid DESC}
600 execsql {SELECT rowid, a FROM t6 WHERE -5.5<=rowid}
603 execsql {SELECT rowid, a FROM t6 WHERE -5.5<=rowid ORDER BY rowid DESC}
606 execsql {SELECT rowid, a FROM t6 WHERE rowid>-5.5}
609 execsql {SELECT rowid, a FROM t6 WHERE rowid>-5.0}
612 execsql {SELECT rowid, a FROM t6 WHERE rowid>-5.5 ORDER BY rowid DESC}
615 execsql {SELECT rowid, a FROM t6 WHERE rowid>-5.0 ORDER BY rowid DESC}
618 execsql {SELECT rowid, a FROM t6 WHERE -5.5<rowid}
621 execsql {SELECT rowid, a FROM t6 WHERE -5.5<rowid ORDER BY rowid DESC}
624 execsql {SELECT rowid, a FROM t6 WHERE rowid<=-5.5}
627 execsql {SELECT rowid, a FROM t6 WHERE rowid<=-5.5 ORDER BY rowid DESC}
630 execsql {SELECT rowid, a FROM t6 WHERE -5.5>=rowid}
633 execsql {SELECT rowid, a FROM t6 WHERE -5.5>=rowid ORDER BY rowid DESC}
636 execsql {SELECT rowid, a FROM t6 WHERE rowid<-5.5}
639 execsql {SELECT rowid, a FROM t6 WHERE rowid<-5.5 ORDER BY rowid DESC}
642 execsql {SELECT rowid, a FROM t6 WHERE -5.5>rowid}
645 execsql {SELECT rowid, a FROM t6 WHERE -5.5>rowid ORDER BY rowid DESC}
651 execsql {SELECT rowid, a FROM t5 WHERE rowid>'abc'}
654 execsql {SELECT rowid, a FROM t5 WHERE rowid>='abc'}
657 execsql {SELECT rowid, a FROM t5 WHERE rowid<'abc'}
660 execsql {SELECT rowid, a FROM t5 WHERE rowid<='abc'}
664 execsql {SELECT rowid, a FROM t5 WHERE rowid>'abc' ORDER BY 1 ASC}
667 execsql {SELECT rowid, a FROM t5 WHERE rowid>='abc' ORDER BY 1 ASC}
670 execsql {SELECT rowid, a FROM t5 WHERE rowid<'abc' ORDER BY 1 ASC}
673 execsql {SELECT rowid, a FROM t5 WHERE rowid<='abc' ORDER BY 1 ASC}
677 execsql {SELECT rowid, a FROM t5 WHERE rowid>'abc' ORDER BY 1 DESC}
680 execsql {SELECT rowid, a FROM t5 WHERE rowid>='abc' ORDER BY 1 DESC}
683 execsql {SELECT rowid, a FROM t5 WHERE rowid<'abc' ORDER BY 1 DESC}
686 execsql {SELECT rowid, a FROM t5 WHERE rowid<='abc' ORDER BY 1 DESC}
699 execsql {
710 execsql {
715 execsql {INSERT INTO t7 VALUES(2,'y');}
720 execsql {