Lines Matching refs:execsql
24 execsql {
32 set r [execsql {SELECT rowid FROM t1 ORDER BY x}]
43 execsql $sql
48 execsql $sql
53 execsql $sql
58 execsql $sql
63 execsql $sql
70 execsql "SELECT x FROM t1 WHERE rowid=$norow"
74 set v [execsql {SELECT x, oid FROM t1 order by x}]
80 set v [execsql {SELECT x, RowID FROM t1 order by x}]
86 set v [execsql {SELECT x, _rowid_ FROM t1 order by x}]
136 execsql $sql
137 execsql {SELECT x FROM t1 ORDER BY x}
142 execsql $sql
143 execsql {SELECT x FROM t1 ORDER BY x}
149 set v [catch {execsql {CREATE INDEX idxt1 ON t1(rowid)}} msg]
153 set v [catch {execsql {CREATE INDEX idxt1 ON t1(_rowid_)}} msg]
157 set v [catch {execsql {CREATE INDEX idxt1 ON t1(oid)}} msg]
161 set v [catch {execsql {CREATE INDEX idxt1 ON t1(x, rowid)}} msg]
169 execsql {
178 execsql {SELECT * FROM t2 ORDER BY rowid}
181 execsql {SELECT rowid, x, y FROM t2 ORDER BY rowid}
184 set r1 [execsql {SELECT _rowid_, rowid FROM t2 ORDER BY rowid}]
186 set r2 [execsql {SELECT _rowid_, rowid FROM t2 ORDER BY x DESC}]
191 set r1 [execsql {SELECT _rowid_, rowid FROM t2 ORDER BY rowid}]
199 execsql {
204 execsql "INSERT INTO t1(x,y) VALUES($i,[expr {$i*$i}])"
206 execsql {INSERT INTO t2 SELECT _rowid_, x*y, y*y FROM t1}
207 execsql {SELECT t2.y FROM t1, t2 WHERE t1.x==4 AND t1.rowid==t2.rowid}
210 execsql {SELECT t2.y FROM t2, t1 WHERE t1.x==4 AND t1.rowid==t2.rowid}
213 execsql {SELECT t2.y FROM t2, t1 WHERE t1.x==4 AND t1.oid==t2.rowid}
216 execsql {SELECT t2.y FROM t2, t1 WHERE t1.x==4 AND t1._rowid_==t2.rowid}
219 execsql {SELECT t2.y FROM t2, t1 WHERE t1.x==4 AND t2.rowid==t1.rowid}
222 execsql {SELECT t2.y FROM t2, t1 WHERE t2.rowid==t1.oid AND t1.x==4}
225 execsql {SELECT t2.y FROM t1, t2 WHERE t1.x==4 AND t1._rowid_==t2.rowid}
228 execsql {SELECT t2.y FROM t1, t2 WHERE t1.x==4 AND t2.rowid==t1.rowid}
231 execsql {SELECT t2.y FROM t1, t2 WHERE t2.rowid==t1.oid AND t1.x==4}
234 execsql {CREATE INDEX idxt1 ON t1(x)}
235 execsql {SELECT t2.y FROM t1, t2 WHERE t1.x==4 AND t1.rowid==t2.rowid}
238 execsql {SELECT t2.y FROM t1, t2 WHERE t1.x==4 AND t1._rowid_==t2.rowid}
241 execsql {SELECT t2.y FROM t1, t2 WHERE t2.rowid==t1.oid AND 4==t1.x}
244 execsql {SELECT t2.y FROM t2, t1 WHERE t1.x==4 AND t1.rowid==t2.rowid}
247 execsql {SELECT t2.y FROM t2, t1 WHERE t1.x==4 AND t1._rowid_==t2.rowid}
250 execsql {SELECT t2.y FROM t2, t1 WHERE t2.rowid==t1.oid AND 4==t1.x}
253 execsql {CREATE INDEX idxt2 ON t2(y)}
255 concat [execsql {
262 concat [execsql {
268 execsql {
275 execsql {DELETE FROM t1 WHERE _rowid_ IN (SELECT oid FROM t1 WHERE x>8)}
276 execsql {SELECT max(x) FROM t1}
282 execsql {
288 if {[execsql "SELECT x FROM t1 WHERE rowid=$::norow"]==""} break
290 execsql [subst {
295 execsql {
306 execsql {
315 execsql {
321 execsql {
328 execsql {
334 execsql {
341 execsql {
348 execsql {
353 execsql {
362 execsql {
373 execsql {
384 execsql {
389 execsql {
395 execsql {
400 execsql {
405 execsql {
411 execsql {
416 execsql {
425 execsql {
430 execsql {
435 execsql {
440 execsql {
445 execsql {
450 execsql {
455 execsql {
460 execsql {
465 execsql {
470 execsql {
479 execsql {
489 execsql {SELECT rowid, a FROM t5 WHERE rowid>=5.5}
492 execsql {SELECT rowid, a FROM t5 WHERE rowid>=5.0}
495 execsql {SELECT rowid, a FROM t5 WHERE rowid>5.5}
498 execsql {SELECT rowid, a FROM t5 WHERE rowid>5.0}
501 execsql {SELECT rowid, a FROM t5 WHERE 5.5<=rowid}
504 execsql {SELECT rowid, a FROM t5 WHERE 5.5<rowid}
507 execsql {SELECT rowid, a FROM t5 WHERE rowid<=5.5}
510 execsql {SELECT rowid, a FROM t5 WHERE rowid<5.5}
513 execsql {SELECT rowid, a FROM t5 WHERE 5.5>=rowid}
516 execsql {SELECT rowid, a FROM t5 WHERE 5.5>rowid}
519 execsql {SELECT rowid, a FROM t5 WHERE rowid>=5.5 ORDER BY rowid DESC}
522 execsql {SELECT rowid, a FROM t5 WHERE rowid>=5.0 ORDER BY rowid DESC}
525 execsql {SELECT rowid, a FROM t5 WHERE rowid>5.5 ORDER BY rowid DESC}
528 execsql {SELECT rowid, a FROM t5 WHERE rowid>5.0 ORDER BY rowid DESC}
531 execsql {SELECT rowid, a FROM t5 WHERE 5.5<=rowid ORDER BY rowid DESC}
534 execsql {SELECT rowid, a FROM t5 WHERE 5.5<rowid ORDER BY rowid DESC}
537 execsql {SELECT rowid, a FROM t5 WHERE rowid<=5.5 ORDER BY rowid DESC}
540 execsql {SELECT rowid, a FROM t5 WHERE rowid<5.5 ORDER BY rowid DESC}
543 execsql {SELECT rowid, a FROM t5 WHERE 5.5>=rowid ORDER BY rowid DESC}
546 execsql {SELECT rowid, a FROM t5 WHERE 5.5>rowid ORDER BY rowid DESC}
550 execsql {
557 execsql {SELECT rowid, a FROM t6 WHERE rowid>=-5.5}
560 execsql {SELECT rowid, a FROM t6 WHERE rowid>=-5.0}
563 execsql {SELECT rowid, a FROM t6 WHERE rowid>=-5.5 ORDER BY rowid DESC}
566 execsql {SELECT rowid, a FROM t6 WHERE rowid>=-5.0 ORDER BY rowid DESC}
569 execsql {SELECT rowid, a FROM t6 WHERE -5.5<=rowid}
572 execsql {SELECT rowid, a FROM t6 WHERE -5.5<=rowid ORDER BY rowid DESC}
575 execsql {SELECT rowid, a FROM t6 WHERE rowid>-5.5}
578 execsql {SELECT rowid, a FROM t6 WHERE rowid>-5.0}
581 execsql {SELECT rowid, a FROM t6 WHERE rowid>-5.5 ORDER BY rowid DESC}
584 execsql {SELECT rowid, a FROM t6 WHERE rowid>-5.0 ORDER BY rowid DESC}
587 execsql {SELECT rowid, a FROM t6 WHERE -5.5<rowid}
590 execsql {SELECT rowid, a FROM t6 WHERE -5.5<rowid ORDER BY rowid DESC}
593 execsql {SELECT rowid, a FROM t6 WHERE rowid<=-5.5}
596 execsql {SELECT rowid, a FROM t6 WHERE rowid<=-5.5 ORDER BY rowid DESC}
599 execsql {SELECT rowid, a FROM t6 WHERE -5.5>=rowid}
602 execsql {SELECT rowid, a FROM t6 WHERE -5.5>=rowid ORDER BY rowid DESC}
605 execsql {SELECT rowid, a FROM t6 WHERE rowid<-5.5}
608 execsql {SELECT rowid, a FROM t6 WHERE rowid<-5.5 ORDER BY rowid DESC}
611 execsql {SELECT rowid, a FROM t6 WHERE -5.5>rowid}
614 execsql {SELECT rowid, a FROM t6 WHERE -5.5>rowid ORDER BY rowid DESC}
620 execsql {SELECT rowid, a FROM t5 WHERE rowid>'abc'}
623 execsql {SELECT rowid, a FROM t5 WHERE rowid>='abc'}
626 execsql {SELECT rowid, a FROM t5 WHERE rowid<'abc'}
629 execsql {SELECT rowid, a FROM t5 WHERE rowid<='abc'}