update.test - OpenGrok cross reference for /titanic_41/usr/src/lib/libsqlite/test/update.test

Lines Matching refs:FROM
45   execsql {SELECT * FROM test1 ORDER BY f1}
69   execsql {SELECT * FROM test1 ORDER BY f1}
76   execsql {SELECT * FROM test1 ORDER BY f1}
82   execsql {SELECT * FROM test1 ORDER BY f1}
91   execsql {SELECT * FROM test1 ORDER BY F1}
98   execsql {SELECT * FROM test1 ORDER BY F1}
106     DELETE FROM test1 WHERE f1<=5;
112   execsql {SELECT * FROM test1 ORDER BY f1,f2}
116   execsql {SELECT * FROM test1 ORDER BY f1,f2}
120   execsql {SELECT * FROM test1 ORDER BY f1,f2}
124   execsql {SELECT * FROM test1 ORDER BY f1,f2}
128   execsql {SELECT * FROM test1 ORDER BY f1,f2}
132   execsql {SELECT * FROM test1 ORDER BY f1,f2}
143     SELECT * FROM test1 ORDER BY f1,f2
151   execsql {SELECT * FROM test1 ORDER BY f1,f2}
155   execsql {SELECT * FROM test1 ORDER BY f1,f2}
159   execsql {SELECT * FROM test1 ORDER BY f1,f2}
163   execsql {SELECT * FROM test1 ORDER BY f1,f2}
167   execsql {SELECT * FROM test1 ORDER BY f1,f2}
170   execsql {SELECT * FROM test1 WHERE f1==78 ORDER BY f1,f2}
173   execsql {SELECT * FROM test1 WHERE f1==778 ORDER BY f1,f2}
176   execsql {SELECT * FROM test1 WHERE f1==8 ORDER BY f1,f2}
182   execsql {SELECT * FROM test1 ORDER BY f1,f2}
185   execsql {SELECT * FROM test1 WHERE f1==78 ORDER BY f1,f2}
188   execsql {SELECT * FROM test1 WHERE f1==778 ORDER BY f1,f2}
191   execsql {SELECT * FROM test1 WHERE f1==777 ORDER BY f1,f2}
194   execsql {SELECT * FROM test1 WHERE f1==8 ORDER BY f1,f2}
205     SELECT * FROM test1 ORDER BY f1,f2
209   execsql {SELECT * FROM test1 WHERE f1==77 ORDER BY f1,f2}
212   execsql {SELECT * FROM test1 WHERE f1==778 ORDER BY f1,f2}
215   execsql {SELECT * FROM test1 WHERE f1==777 ORDER BY f1,f2}
218   execsql {SELECT * FROM test1 WHERE f1==8 ORDER BY f1,f2}
227   execsql {SELECT * FROM test1 ORDER BY f1,f2}
231   execsql {SELECT * FROM test1 ORDER BY f1,f2}
234   execsql {SELECT * FROM test1 WHERE f1==8 ORDER BY f1,f2}
237   execsql {SELECT * FROM test1 WHERE f2==89 ORDER BY f1,f2}
240   execsql {SELECT * FROM test1 WHERE f1==88 ORDER BY f1,f2}
244   execsql {SELECT * FROM test1 ORDER BY f1,f2}
248   execsql {SELECT * FROM test1 ORDER BY f1,f2}
251   execsql {SELECT * FROM test1 WHERE f1==8 ORDER BY f1,f2}
254   execsql {SELECT * FROM test1 WHERE f2==89 ORDER BY f1,f2}
257   execsql {SELECT * FROM test1 WHERE f2==88 ORDER BY f1,f2}
261   execsql {SELECT * FROM test1 ORDER BY f1,f2}
264   execsql {SELECT * FROM test1 WHERE f1==78 ORDER BY f1,f2}
267   execsql {SELECT * FROM test1 WHERE f1==778 ORDER BY f1,f2}
270   execsql {SELECT * FROM test1 WHERE f1==8 ORDER BY f1,f2}
274   execsql {SELECT * FROM test1 ORDER BY f1,f2}
277   execsql {SELECT * FROM test1 WHERE f1==78 ORDER BY f1,f2}
280   execsql {SELECT * FROM test1 WHERE f1==778 ORDER BY f1,f2}
283   execsql {SELECT * FROM test1 WHERE f1==777 ORDER BY f1,f2}
286   execsql {SELECT * FROM test1 WHERE f1==8 ORDER BY f1,f2}
290   execsql {SELECT * FROM test1 ORDER BY f1,f2}
293   execsql {SELECT * FROM test1 WHERE f1==77 ORDER BY f1,f2}
296   execsql {SELECT * FROM test1 WHERE f1==778 ORDER BY f1,f2}
299   execsql {SELECT * FROM test1 WHERE f1==777 ORDER BY f1,f2}
302   execsql {SELECT * FROM test1 WHERE f1==8 ORDER BY f1,f2}
311   execsql {SELECT * FROM test1 ORDER BY f1,f2}
315   execsql {SELECT * FROM test1 ORDER BY f1,f2}
318   execsql {SELECT * FROM test1 WHERE f1==8 ORDER BY f1,f2}
321   execsql {SELECT * FROM test1 WHERE f2==89 ORDER BY f1,f2}
324   execsql {SELECT * FROM test1 WHERE f1==88 ORDER BY f1,f2}
328   execsql {SELECT * FROM test1 ORDER BY f1,f2}
333   execsql {SELECT * FROM test1 ORDER BY f1,f2}
336   execsql {SELECT * FROM test1 WHERE f1==8 ORDER BY f1,f2}
339   execsql {SELECT * FROM test1 WHERE f2==89 ORDER BY f1,f2}
342   execsql {SELECT * FROM test1 WHERE f2==88 ORDER BY f1,f2}
346   execsql {SELECT * FROM test1 ORDER BY f1,f2}
349   execsql {SELECT * FROM test1 WHERE f1==78 ORDER BY f1,f2}
352   execsql {SELECT * FROM test1 WHERE f1==778 ORDER BY f1,f2}
355   execsql {SELECT * FROM test1 WHERE f1==8 ORDER BY f1,f2}
359   execsql {SELECT * FROM test1 ORDER BY f1,f2}
362   execsql {SELECT * FROM test1 WHERE f1==78 ORDER BY f1,f2}
365   execsql {SELECT * FROM test1 WHERE f1==778 ORDER BY f1,f2}
368   execsql {SELECT * FROM test1 WHERE f1==777 ORDER BY f1,f2}
371   execsql {SELECT * FROM test1 WHERE f1==8 ORDER BY f1,f2}
375   execsql {SELECT * FROM test1 ORDER BY f1,f2}
378   execsql {SELECT * FROM test1 WHERE f1==77 ORDER BY f1,f2}
381   execsql {SELECT * FROM test1 WHERE f1==778 ORDER BY f1,f2}
384   execsql {SELECT * FROM test1 WHERE f1==777 ORDER BY f1,f2}
387   execsql {SELECT * FROM test1 WHERE f1==8 ORDER BY f1,f2}
432     SELECT * FROM t1
438     SELECT * FROM t1;
444     SELECT * FROM t1;
449     SELECT * FROM t1;
455     SELECT * FROM t1;
461     SELECT * FROM t1;
466     SELECT * FROM t1;
472     SELECT * FROM t1;
478     SELECT * FROM t1;
483     SELECT * FROM t1;
491     UPDATE t1 SET e=e+1 WHERE b IN (SELECT b FROM t1);
492     SELECT b,e FROM t1;
497     UPDATE t1 SET e=e+1 WHERE a IN (SELECT a FROM t1);
498     SELECT a,e FROM t1;
513     INSERT INTO t2 SELECT a+2 FROM t2;
514     INSERT INTO t2 SELECT a+4 FROM t2;
515     INSERT INTO t2 SELECT a+8 FROM t2;
516     INSERT INTO t2 SELECT a+16 FROM t2;
517     INSERT INTO t2 SELECT a+32 FROM t2;
518     INSERT INTO t2 SELECT a+64 FROM t2;
519     INSERT INTO t2 SELECT a+128 FROM t2;
520     INSERT INTO t2 SELECT a+256 FROM t2;
521     INSERT INTO t2 SELECT a+512 FROM t2;
522     INSERT INTO t2 SELECT a+1024 FROM t2;
524     SELECT count(*) FROM t2;
529     SELECT count(*) FROM t2 WHERE a=rowid;
535     SELECT count(*) FROM t2 WHERE a=rowid+1;
542     SELECT count(*) FROM t2 WHERE a=rowid;
548     INSERT INTO t2 SELECT a+2048 FROM t2;
549     INSERT INTO t2 SELECT a+4096 FROM t2;
550     INSERT INTO t2 SELECT a+8192 FROM t2;
551     SELECT count(*) FROM t2 WHERE a=rowid;
558     SELECT count(*) FROM t2 WHERE a=rowid+1;