#
# MCOL-5357 Fix TPC-DS query error "MCS-3009: Unknown column '.<colname>'"
#

--source ../include/have_columnstore.inc

--disable_warnings
DROP DATABASE IF EXISTS mcol_5357;
--enable_warnings
CREATE DATABASE mcol_5357;
USE mcol_5357;

CREATE TABLE t1 (a INT)engine=columnstore;
INSERT INTO t1 VALUES (1), (2), (3);

SELECT item FROM (
SELECT item FROM (SELECT a AS item FROM t1) tt
UNION ALL
SELECT item FROM (SELECT a AS item FROM t1) tt
) ttt;

--disable_warnings
DROP DATABASE mcol_5357;
--enable_warnings