delete.test - OpenGrok cross reference for /illumos-gate/usr/src/lib/libsqlite/test/delete.test

Lines Matching refs:f1
37   execsql {CREATE TABLE table1(f1 int, f2 int)}
42   execsql {SELECT * FROM table1 ORDER BY f1}
45   execsql {DELETE FROM table1 WHERE f1=3}
48   execsql {SELECT * FROM table1 ORDER BY f1}
51   execsql {CREATE INDEX index1 ON table1(f1)}
53   execsql {DELETE FROM 'table1' WHERE f1=3}
56   execsql {SELECT * FROM table1 ORDER BY f1}
59   execsql {DELETE FROM table1 WHERE f1=2}
62   execsql {SELECT * FROM table1 ORDER BY f1}
70   execsql {CREATE TABLE table2(f1 int, f2 int)}
76   set v [catch {execsql {DELETE FROM table2 WHERE xyzzy(f1+4)}} msg]
125      execsql "DELETE FROM table1 WHERE f1==$i"
130   execsql "DELETE FROM table1 WHERE f1>50"
135      execsql "DELETE FROM table1 WHERE f1==$i"
137   execsql {SELECT f1 FROM table1 ORDER BY f1}
141      execsql "DELETE FROM table1 WHERE f1==$i"
143   execsql {SELECT f1 FROM table1 ORDER BY f1}
146   execsql "DELETE FROM table1 WHERE f1!=48"
147   execsql {SELECT f1 FROM table1 ORDER BY f1}
172   execsql {SELECT f1 FROM table1 WHERE f1<10 ORDER BY f1}
175   execsql {SELECT f1 FROM table2 WHERE f1<10 ORDER BY f1}
178   execsql {DELETE FROM table1 WHERE f1>7}
179   execsql {SELECT f1 FROM table1 ORDER BY f1}
182   execsql {DELETE FROM table2 WHERE f1>7}
183   execsql {SELECT f1 FROM table2 ORDER BY f1}
187   execsql {SELECT f1 FROM table1}
191   execsql {SELECT f1 FROM table1}
195   execsql {SELECT f1 FROM table2}
199   execsql {SELECT f1 FROM table2}