Lines Matching refs:FROM

35   execsql {SELECT * FROM t1}
38   catch {db2 eval {SELECT * FROM sqlite_master}}
39   db2 eval {SELECT * FROM t1}
42   execsql {SELECT name FROM sqlite_master}
45   db2 eval {SELECT name FROM sqlite_master}
56   db2 eval {SELECT * FROM t2}
59   catch {execsql {SELECT * FROM sqlite_master}}
60   catchsql {SELECT * FROM t2}
67   db2 eval {SELECT * FROM t2 ORDER BY x}
70   db2 eval {DELETE FROM t2 WHERE x==8}
71   db2 eval {SELECT * FROM t2 ORDER BY x}
74   db2 eval {DELETE FROM t2}
75   db2 eval {SELECT * FROM t2}
81      SELECT * FROM t2 ORDER BY x;
86   set r [catch {db2 eval {SELECT * FROM t2}} msg]
97     SELECT * FROM t2;
102   catchsql {SELECT * FROM t2}
109     SELECT * FROM t2;
114   catchsql {SELECT * FROM t2}
117   set r [catch {db2 eval {SELECT * FROM t2}} msg]
126     SELECT name FROM sqlite_master WHERE type='index';
131     SELECT y FROM t2 WHERE x=1;
137     SELECT y FROM t2 WHERE x=1;
157     SELECT * FROM t2;
164     SELECT * FROM t2;
169     SELECT * FROM t2;
174     SELECT * FROM temp.t2;
179     SELECT * FROM main.t2;
184 #    SELECT name FROM main.sqlite_master WHERE type='table';
189     SELECT name FROM main.sqlite_master WHERE type='table';
194     SELECT * FROM main.t2;
200     SELECT * FROM t2;
206     SELECT * FROM t2;  -- data should be from MAIN
213     SELECT * FROM t2;
219     SELECT * FROM t2;
228     SELECT * FROM t2;
235     SELECT * FROM t2;
240     SELECT * FROM t2;
245 #    SELECT name FROM sqlite_master WHERE type='table'
250     SELECT name FROM sqlite_master WHERE type='table'
255     SELECT * FROM t2;
260     SELECT * FROM t2;
266     SELECT * FROM t2;  -- uses MAIN.T2
271     SELECT * FROM t2;
278     SELECT * FROM t2;
293     SELECT * FROM t2;
298 #    SELECT * FROM t2;
303     SELECT * FROM t2;
308     SELECT y FROM t2 WHERE x=3
313     SELECT y FROM t2 WHERE x=3
319     SELECT y FROM t2 WHERE x=1;
324     SELECT y FROM t2 WHERE x=3
329     SELECT y FROM t2 WHERE x=1;
334     SELECT y FROM t2 WHERE x=3
346     SELECT * FROM t8;
358     SELECT * FROM t8;
377     SELECT * FROM t9;
386     SELECT * FROM t8;
391     SELECT * FROM t8,t9;
398     SELECT * FROM t8,t9;