Lines Matching refs:sql

108 proc queryplan {sql} {
110   set data [execsql $sql]
111   set eqp [execsql "EXPLAIN QUERY PLAN $sql"]
403     set sql "SELECT * FROM t6w NATURAL JOIN t6x NATURAL JOIN t6y"
404     append sql " NATURAL JOIN t6z "
405     append sql $::predicate
406     db eval $sql
409     set sql "SELECT * FROM t6w JOIN t6x USING(a) JOIN t6y USING(a)"
410     append sql " JOIN t6z USING(a) "
411     append sql $::predicate
412     db eval $sql
415     set sql "SELECT * FROM t6w NATURAL JOIN t6x JOIN t6y USING(a)"
416     append sql " JOIN t6z USING(a) "
417     append sql $::predicate
418     db eval $sql
421     set sql "SELECT * FROM t6w JOIN t6x USING(a) NATURAL JOIN t6y"
422     append sql " JOIN t6z USING(a) "
423     append sql $::predicate
424     db eval $sql
427     set sql "SELECT * FROM t6w JOIN t6x USING(a) JOIN t6y USING(a)"
428     append sql " NATURAL JOIN t6z "
429     append sql $::predicate
430     db eval $sql
433     set sql "SELECT * FROM t6w JOIN t6x USING(a) NATURAL JOIN t6y"
434     append sql " NATURAL JOIN t6z "
435     append sql $::predicate
436     db eval $sql
439     set sql "SELECT * FROM t6w NATURAL JOIN t6x JOIN t6y USING(a)"
440     append sql " NATURAL JOIN t6z "
441     append sql $::predicate
442     db eval $sql
445     set sql "SELECT * FROM t6w NATURAL JOIN t6x NATURAL JOIN t6y"
446     append sql " JOIN t6z USING(a) "
447     append sql $::predicate
448     db eval $sql