Lines Matching refs:FROM
32 SELECT b FROM one ORDER BY a;
41 SELECT b FROM two ORDER BY a;
46 execsql {SELECT b FROM one ORDER BY a} altdb
49 execsql {SELECT b FROM two ORDER BY a} altdb
82 SELECT a FROM one ORDER BY a;
83 SELECT a FROM two ORDER BY a;
94 SELECT a FROM one ORDER BY a;
99 SELECT a FROM two ORDER BY a;
105 SELECT a FROM one ORDER BY a;
117 SELECT a FROM two ORDER BY a;
123 SELECT a FROM one ORDER BY a;
135 SELECT a FROM two ORDER BY a;
141 SELECT a FROM one ORDER BY a;
150 SELECT a FROM two ORDER BY a;
156 SELECT a FROM one ORDER BY a;
162 SELECT a FROM two ORDER BY a;
168 SELECT a FROM one ORDER BY a;
189 SELECT a FROM two ORDER BY a;
195 SELECT a FROM two ORDER BY a;
201 SELECT a FROM one ORDER BY a;
208 SELECT a FROM one ORDER BY a;
214 SELECT a FROM two ORDER BY a;
220 SELECT a FROM one ORDER BY a;
227 SELECT a FROM two ORDER BY a;
233 SELECT a FROM two ORDER BY a;
239 SELECT a FROM one ORDER BY a;
256 execsql {SELECT name FROM sqlite_master WHERE type='table' ORDER BY name}
260 execsql {SELECT name FROM sqlite_master WHERE type='table' ORDER BY name}
264 execsql {SELECT name FROM sqlite_master WHERE type='table' ORDER BY name}
267 execsql {SELECT a,b FROM one ORDER BY b}
271 execsql {SELECT a,b FROM one ORDER BY b}
275 execsql {SELECT name FROM sqlite_master WHERE type='table' ORDER BY name}
279 execsql {SELECT a,b FROM one ORDER BY b}
379 SELECT * FROM t2;
384 SELECT x FROM t2 WHERE y=2;
399 SELECT * FROM t2
413 SELECT * FROM t2;
429 SELECT * FROM t1;
439 SELECT * FROM t1;
445 SELECT * FROM t1;
454 SELECT * FROM t1;
461 SELECT * FROM t1;
470 SELECT * FROM t1;
477 SELECT * FROM t1;
491 SELECT * FROM t1;
500 SELECT * FROM t1;
506 SELECT * FROM t1;
515 SELECT * FROM t1;
522 SELECT * FROM t1;
531 SELECT * FROM t1;
538 SELECT * FROM t1;
547 SELECT * FROM t1;
553 SELECT * FROM t1 WHERE b<1;
560 SELECT * FROM t1 WHERE b<1;
566 SELECT * FROM t1 WHERE b<1;
574 SELECT * FROM t1 WHERE b<1;
583 SELECT * FROM t1 WHERE b<1;
588 SELECT * FROM t1 WHERE c<1;
594 SELECT * FROM t1 WHERE b<1;
599 SELECT * FROM t1 WHERE c<1;
615 SELECT * FROM t1 ORDER BY a;
621 SELECT * FROM t1 WHERE b<1;
628 SELECT * FROM t1 WHERE b<1;
634 SELECT * FROM t1 WHERE b<1;
642 SELECT * FROM t1 WHERE b<1;
651 SELECT * FROM t1 WHERE b<1;
656 SELECT * FROM t1 WHERE c<1;
662 SELECT * FROM t1 WHERE c<1;
668 SELECT * FROM t1 WHERE b<1;
673 SELECT * FROM t1 WHERE c<1;
690 set ::checksum [execsql {SELECT md5sum(x,y,z) FROM t2}]
692 execsql {SELECT md5sum(type,name,tbl_name,rootpage,sql) FROM sqlite_master}
694 execsql {SELECT count(*) FROM t2}
697 execsql {SELECT md5sum(x,y,z) FROM t2}
700 execsql {SELECT md5sum(type,name,tbl_name,rootpage,sql) FROM sqlite_master}
705 DELETE FROM t2;
707 SELECT md5sum(x,y,z) FROM t2;
713 INSERT INTO t2 SELECT * FROM t2;
715 SELECT md5sum(x,y,z) FROM t2;
721 DELETE FROM t2;
723 SELECT md5sum(x,y,z) FROM t2;
729 INSERT INTO t2 SELECT * FROM t2;
731 SELECT md5sum(x,y,z) FROM t2;
737 CREATE TABLE t3 AS SELECT * FROM t2;
738 INSERT INTO t2 SELECT * FROM t3;
740 SELECT md5sum(x,y,z) FROM t2;
744 execsql {SELECT md5sum(type,name,tbl_name,rootpage,sql) FROM sqlite_master}
749 CREATE TEMP TABLE t3 AS SELECT * FROM t2;
750 INSERT INTO t2 SELECT * FROM t3;
752 SELECT md5sum(x,y,z) FROM t2;
756 execsql {SELECT md5sum(type,name,tbl_name,rootpage,sql) FROM sqlite_master}
761 CREATE TEMP TABLE t3 AS SELECT * FROM t2;
762 INSERT INTO t2 SELECT * FROM t3;
767 SELECT md5sum(x,y,z) FROM t2;
771 execsql {SELECT md5sum(type,name,tbl_name,rootpage,sql) FROM sqlite_master}
778 SELECT md5sum(x,y,z) FROM t2;
782 execsql {SELECT md5sum(type,name,tbl_name,rootpage,sql) FROM sqlite_master}
797 CREATE TABLE t3 AS SELECT * FROM t2;
798 DELETE FROM t2;
805 execsql {SELECT md5sum(x,y,z) FROM t2}
808 execsql {SELECT md5sum(type,name,tbl_name,rootpage,sql) FROM sqlite_master}
827 INSERT INTO t3 SELECT randstr(10,400) FROM t3;
828 INSERT INTO t3 SELECT randstr(10,400) FROM t3;
829 INSERT INTO t3 SELECT randstr(10,400) FROM t3;
830 INSERT INTO t3 SELECT randstr(10,400) FROM t3;
831 INSERT INTO t3 SELECT randstr(10,400) FROM t3;
832 INSERT INTO t3 SELECT randstr(10,400) FROM t3;
833 INSERT INTO t3 SELECT randstr(10,400) FROM t3;
834 INSERT INTO t3 SELECT randstr(10,400) FROM t3;
835 INSERT INTO t3 SELECT randstr(10,400) FROM t3;
837 SELECT count(*) FROM t3;
849 return [db eval {SELECT count(*), md5sum(x) FROM t3}]
877 DELETE FROM t3 WHERE random()%10!=0;
878 INSERT INTO t3 SELECT randstr(10,10)||x FROM t3;
879 INSERT INTO t3 SELECT randstr(10,10)||x FROM t3;
887 DELETE FROM t3 WHERE random()%10!=0;
888 INSERT INTO t3 SELECT randstr(10,10)||x FROM t3;
889 DELETE FROM t3 WHERE random()%10!=0;
890 INSERT INTO t3 SELECT randstr(10,10)||x FROM t3;
898 INSERT INTO t3 SELECT randstr(10,400) FROM t3 WHERE random()%10==0;