sql-tests/inputs/columnresolution-negative.sql

0001 -- Negative testcases for column resolution
0002 CREATE DATABASE mydb1;
0003 USE mydb1;
0004 CREATE TABLE t1 USING parquet AS SELECT 1 AS i1;
0005
0006 CREATE DATABASE mydb2;
0007 USE mydb2;
0008 CREATE TABLE t1 USING parquet AS SELECT 20 AS i1;
0009
0010 -- Negative tests: column resolution scenarios with ambiguous cases in join queries
0011 SET spark.sql.crossJoin.enabled = true;
0012 USE mydb1;
0013 SELECT i1 FROM t1, mydb1.t1;
0014 SELECT t1.i1 FROM t1, mydb1.t1;
0015 SELECT mydb1.t1.i1 FROM t1, mydb1.t1;
0016 SELECT i1 FROM t1, mydb2.t1;
0017 SELECT t1.i1 FROM t1, mydb2.t1;
0018 USE mydb2;
0019 SELECT i1 FROM t1, mydb1.t1;
0020 SELECT t1.i1 FROM t1, mydb1.t1;
0021 SELECT i1 FROM t1, mydb2.t1;
0022 SELECT t1.i1 FROM t1, mydb2.t1;
0023 SELECT db1.t1.i1 FROM t1, mydb2.t1;
0024 SET spark.sql.crossJoin.enabled = false;
0025
0026 -- Negative tests
0027 USE mydb1;
0028 SELECT mydb1.t1 FROM t1;
0029 SELECT t1.x.y.* FROM t1;
0030 SELECT t1 FROM mydb1.t1;
0031 USE mydb2;
0032 SELECT mydb1.t1.i1 FROM t1;
0033
0034 -- reset
0035 DROP DATABASE mydb1 CASCADE;
0036 DROP DATABASE mydb2 CASCADE;