Lines Matching refs:tab1

693     CREATE TABLE tab1(col1, col2);
697   check_origins {SELECT col2, col1 FROM tab1}
698 } [list {main tab1 col2} {main tab1 col1}]
700   check_origins {SELECT col2 AS hello, col1 AS world FROM tab1}
701 } [list {main tab1 col2} {main tab1 col1}]
705     check_origins {SELECT b, a FROM (SELECT col1 AS a, col2 AS b FROM tab1)}
706   } [list {main tab1 col2} {main tab1 col1}]
708     check_origins {SELECT (SELECT col2 FROM tab1), (SELECT col1 FROM tab1)}
709   } [list {main tab1 col2} {main tab1 col1}]
711     check_origins {SELECT (SELECT col2), (SELECT col1) FROM tab1}
712   } [list {main tab1 col2} {main tab1 col1}]
714     check_origins {SELECT * FROM tab1}
715   } [list {main tab1 col1} {main tab1 col2}]
717     check_origins {SELECT * FROM (SELECT * FROM tab1)}
718   } [list {main tab1 col1} {main tab1 col2}]
724       CREATE VIEW view1 AS SELECT * FROM  tab1;
729   } [list {main tab1 col2} {main tab1 col1}]
732   } [list {main tab1 col2} {main tab1 col1}]
735   } [list {main tab1 col2} {main tab1 col1}]
738   } [list {main tab1 col2} {main tab1 col1}]
741   } [list {main tab1 col2} {main tab1 col1}]
744   } [list {main tab1 col1} {main tab1 col2}]
747   } [list {main tab1 col1} {main tab1 col2}]
750   } [list {main tab1 col1} {main tab1 col2}]
756   } [list {main tab1 col1} {main tab1 col2}]
761       CREATE VIEW view2 AS SELECT * FROM tab1 limit 10 offset 10;
766   } [list {main tab1 col2} {main tab1 col1}]
769   } [list {main tab1 col2} {main tab1 col1}]
772   } [list {main tab1 col2} {main tab1 col1}]
775   } [list {main tab1 col2} {main tab1 col1}]
778   } [list {main tab1 col2} {main tab1 col1}]
781   } [list {main tab1 col1} {main tab1 col2}]
784   } [list {main tab1 col1} {main tab1 col2}]
787   } [list {main tab1 col1} {main tab1 col2}]
793   } [list {main tab1 col1} {main tab1 col2}]
795     check_origins {select * from (select * from tab1 limit 10 offset 10)}
796   } [list {main tab1 col1} {main tab1 col2}]