Lines Matching refs:from

56 # appears to have been left over from SQLite version 2.  This test
70         select count() from t0 where x=8;
82 # changes() set properly after delete from table
85         delete from t0 where x=2;
121         select v1 from t2;
128         select v2 from t2;
134 #   1 from "insert into t1 values(77)" + 
135 #   1 from "insert into t2 values (NULL, changes(), NULL);" +
136 #   5 from "update t0 set x=x;" +
137 #   1 from "update t2 set v2=changes();"
150         delete from t2; delete from t2;
153             delete from t0 where oid=1 or oid=2;
164         select v1 from t2;
171         select v2 from t2;
178 # changes() changed properly on delete from table containing before trigger
182         delete from t2; delete from t2;
188         delete from t1;
196         select v1 from t2;
203         select v2 from t2;
219         create temp view v1 as select * from t1;
220         create temp view v2 as select * from t2;
247             delete from t0 where x=2;
257         delete from t1 where k=88;
271         select n from n1;
277         select n from n2;