Lines Matching refs:sql
33 proc sql {sql} {
34 puts $::fd $sql
72 sql "PRAGMA synchronous = OFF;"
73 sql "DROP TABLE IF EXISTS t1;"
74 sql "CREATE VIRTUAL TABLE t1 USING fts4;"
77 sql "INSERT INTO t1 VALUES('$doc');"
82 sql "INSERT INTO t1(t1) VALUES('optimize');"
87 sql "SELECT count(*) FROM t1 WHERE t1 MATCH '[select_term]';"
93 sql "SELECT count(*) FROM t1 WHERE t1 MATCH '[select_term] [select_term]';"
101 set ::fd [open fts3speed_insert.sql w]
105 set ::fd [open fts3speed_select.sql w]
109 set ::fd [open fts3speed_select2.sql w]
113 set ::fd [open fts3speed_optimize.sql w]
118 puts " fts3speed_insert.sql"
119 puts " fts3speed_select.sql"
120 puts " fts3speed_select2.sql"
121 puts " fts3speed_optimize.sql"