Lines Matching refs:sql

31 proc tracesql {sql} {
32   puts $::sqlout $sql\;
124 set sql "SELECT * FROM t1, t2, t3 WHERE t1.oid = t2.oid AND t2.oid = t3.oid"
125 speed_trial speed4-join1 50000 row $sql
128 set sql "SELECT * FROM t1, t2, t3 WHERE t1.t = t2.t AND t2.t = t3.t"
129 speed_trial speed4-join2 50000 row $sql
132 set sql ""
134   append sql "SELECT * FROM v[expr {($ii%3)+1}] WHERE rowid = [expr {$ii*3}];"
136 speed_trial speed4-view1 10000 stmt $sql
143 set sql ""
145   append sql "SELECT t FROM t[expr {($ii%3)+1}] WHERE rowid = [expr {$ii*3}];"
147 speed_trial speed4-table1 10000 stmt $sql
151 set sql ""
153   append sql "
159 speed_trial speed4-subselect1 10000 stmt $sql
178 set sql ""
180   append sql "INSERT INTO t4 VALUES(NULL, $ii, '[number_name $ii]');"
182 speed_trial speed4-trigger1 10000 stmt $sql
183 set sql ""
186   append sql "
190 speed_trial speed4-trigger2 10000 stmt $sql
191 set sql ""
193   append sql "DELETE FROM t4 WHERE rowid = $ii;"
195 speed_trial speed4-trigger3 10000 stmt $sql
210 set sql ""
212   append sql "INSERT INTO t4 VALUES(NULL, $ii, '[number_name $ii]');"
214 speed_trial speed4-notrigger1 10000 stmt $sql
215 set sql ""
218   append sql "
222 speed_trial speed4-notrigger2 10000 stmt $sql
223 set sql ""
225   append sql "DELETE FROM t4 WHERE rowid = $ii;"
227 speed_trial speed4-notrigger3 10000 stmt $sql