Lines Matching refs:f2
24 execsql {CREATE TABLE tbl1(f1 int, f2 int)}
42 set sql2 "SELECT f2 FROM tbl1 WHERE f1=$f1 ORDER BY f2"
44 lappend r $d2(f2)
56 set sql2 "SELECT f2 FROM tbl1 WHERE f1=$f1 ORDER BY f2"
58 lappend r $d2(f2)
67 execsql {CREATE TABLE tbl2(f1 int, f2 int, f3 int)}
82 execsql {SELECT count(*) FROM tbl2 WHERE f2>1000}
86 execsql {SELECT f1 FROM tbl2 WHERE 1000=f2}
90 execsql {CREATE INDEX idx1 ON tbl2(f2)}
94 execsql {SELECT f1 FROM tbl2 WHERE 1000=f2}
97 execsql {SELECT f1 FROM tbl2 WHERE f2=1000}
101 execsql {SELECT * FROM tbl2 WHERE 1000=f2}
106 execsql {SELECT * FROM tbl2 WHERE f2=1000}
115 execsql {SELECT f1 FROM tbl2 WHERE f2==2000}