sql-tests/inputs/columnresolution-views.sql

0001 -- Tests for qualified column names for the view code-path
0002 -- Test scenario with Temporary view
0003 CREATE OR REPLACE TEMPORARY VIEW view1 AS SELECT 2 AS i1;
0004 SELECT view1.* FROM view1;
0005 SELECT * FROM view1;
0006 SELECT view1.i1 FROM view1;
0007 SELECT i1 FROM view1;
0008 SELECT a.i1 FROM view1 AS a;
0009 SELECT i1 FROM view1 AS a;
0010 -- cleanup
0011 DROP VIEW view1;
0012
0013 -- Test scenario with Global Temp view
0014 CREATE OR REPLACE GLOBAL TEMPORARY VIEW view1 as SELECT 1 as i1;
0015 SELECT * FROM global_temp.view1;
0016 SELECT global_temp.view1.* FROM global_temp.view1;
0017 SELECT i1 FROM global_temp.view1;
0018 SELECT global_temp.view1.i1 FROM global_temp.view1;
0019 SELECT view1.i1 FROM global_temp.view1;
0020 SELECT a.i1 FROM global_temp.view1 AS a;
0021 SELECT i1 FROM global_temp.view1 AS a;
0022 -- cleanup
0023 DROP VIEW global_temp.view1;