Lines Matching refs:f2

21 execsql {CREATE TABLE tbl1(f1 int, f2 int)}
37     set sql2 "SELECT f2 FROM tbl1 WHERE f1=$f1 ORDER BY f2"
39       lappend r $d2(f2)
51     set sql2 "SELECT f2 FROM tbl1 WHERE f1=$f1 ORDER BY f2"
53       lappend r $d2(f2)
67       execsql {CREATE TABLE tbl2(f1 int, f2 int, f3 int); BEGIN;}
82     execsql {CREATE TABLE tbl2(f1 int, f2 int, f3 int); BEGIN;}
103   execsql {SELECT count(*) FROM tbl2 WHERE f2>1000}
107   execsql {SELECT f1 FROM tbl2 WHERE 1000=f2}
111   execsql {CREATE INDEX idx1 ON tbl2(f2)}
114   execsql {SELECT f1 FROM tbl2 WHERE 1000=f2}
117   execsql {SELECT f1 FROM tbl2 WHERE f2=1000}
121   execsql {SELECT * FROM tbl2 WHERE 1000=f2}
126   execsql {SELECT * FROM tbl2 WHERE f2=1000}
135   execsql {SELECT f1 FROM tbl2 WHERE f2==2000}