Lines Matching refs:sql
60 return [list sql "SELECT rowid, a, b FROM $src order by 2, 3"]
62 return [list sql "SELECT rowid, a, b FROM $src"]
81 foreach {tn sql bDistinct idxinsert bConsumed res} {
97 do_execsql_test 1.$tn.1 $sql $res
102 expr {[lsearch [execsql "explain $sql"] IdxInsert]>=0}
137 return [list sql "SELECT rowid, a, b FROM $src"]
203 return [list sql "SELECT rowid, a, b FROM $src"]
217 foreach {tn sql lfa} {
234 execsql $sql
263 return [list sql "SELECT rowid, a, b, c FROM $src"]
276 foreach {tn sql lbir} {
285 execsql $sql
360 set sql "SELECT $selectlist FROM $src$where$order$L$O"
362 lappend ret idxStr $sql
369 set sql $idxstr
371 set sql [string map [list %$ii% $a] $sql]
372 set sql [string map [list %I$ii% [join $a ,]] $sql]
375 lappend ::lFilterSql $sql
377 if {[regexp {OFFSET (.*)$} $sql -> off]} {
382 $sql
386 set real_sql $sql
389 return [list sql $real_sql]
410 proc do_vtab_test {tn sql vtsql {res {}}} {
412 uplevel [list do_execsql_test $tn.1 $sql $res]