path: root/sql/core/src/test/resources/sql-tests/results/columnresolution-views.sql.out

-- Automatically generated by SQLQueryTestSuite
-- Number of queries: 17


-- !query 0
CREATE OR REPLACE TEMPORARY VIEW view1 AS SELECT 2 AS i1
-- !query 0 schema
struct<>
-- !query 0 output



-- !query 1
SELECT view1.* FROM view1
-- !query 1 schema
struct<i1:int>
-- !query 1 output
2


-- !query 2
SELECT * FROM view1
-- !query 2 schema
struct<i1:int>
-- !query 2 output
2


-- !query 3
SELECT view1.i1 FROM view1
-- !query 3 schema
struct<i1:int>
-- !query 3 output
2


-- !query 4
SELECT i1 FROM view1
-- !query 4 schema
struct<i1:int>
-- !query 4 output
2


-- !query 5
SELECT a.i1 FROM view1 AS a
-- !query 5 schema
struct<i1:int>
-- !query 5 output
2


-- !query 6
SELECT i1 FROM view1 AS a
-- !query 6 schema
struct<i1:int>
-- !query 6 output
2


-- !query 7
DROP VIEW view1
-- !query 7 schema
struct<>
-- !query 7 output



-- !query 8
CREATE OR REPLACE GLOBAL TEMPORARY VIEW view1 as SELECT 1 as i1
-- !query 8 schema
struct<>
-- !query 8 output



-- !query 9
SELECT * FROM global_temp.view1
-- !query 9 schema
struct<i1:int>
-- !query 9 output
1


-- !query 10
SELECT global_temp.view1.* FROM global_temp.view1
-- !query 10 schema
struct<>
-- !query 10 output
org.apache.spark.sql.AnalysisException
cannot resolve 'global_temp.view1.*' give input columns 'i1';


-- !query 11
SELECT i1 FROM global_temp.view1
-- !query 11 schema
struct<i1:int>
-- !query 11 output
1


-- !query 12
SELECT global_temp.view1.i1 FROM global_temp.view1
-- !query 12 schema
struct<>
-- !query 12 output
org.apache.spark.sql.AnalysisException
cannot resolve '`global_temp.view1.i1`' given input columns: [i1]; line 1 pos 7


-- !query 13
SELECT view1.i1 FROM global_temp.view1
-- !query 13 schema
struct<i1:int>
-- !query 13 output
1


-- !query 14
SELECT a.i1 FROM global_temp.view1 AS a
-- !query 14 schema
struct<i1:int>
-- !query 14 output
1


-- !query 15
SELECT i1 FROM global_temp.view1 AS a
-- !query 15 schema
struct<i1:int>
-- !query 15 output
1


-- !query 16
DROP VIEW global_temp.view1
-- !query 16 schema
struct<>
-- !query 16 output