#
# Test based on Jira MCOL-5061
# Reduced customer test case.
#

--source ../include/have_columnstore.inc

--disable_warnings
DROP DATABASE IF EXISTS mcol_5061;
--enable_warnings

CREATE DATABASE mcol_5061;
USE mcol_5061;

create table t1 (a int, b int) engine=columnstore;
create table t2 (a int, b int) engine=columnstore;

insert into t1 values (1, 3), (2, 3), (3, 4);
insert into t2 values (1, 2), (2, 4), (4, 5);
select t1.a as a, t1.b as b, t2.a as c, t2.b as d, t2_1.a as e, t2_1.b as f from t1 left join t2 on (t1.a = t2.a and t2.a > 1) left join t2 as t2_1 on (t1.b = t2_1.b and t2_1.a > 1);

create or replace view view_test as
select t1.a as a, t1.b as b, t2.a as c, t2.b as d, t2_1.a as e, t2_1.b as f from t1 left join t2 on (t1.a = t2.a and t2.a > 1) left join t2 as t2_1 on (t1.b = t2_1.b and t2_1.a > 1);
select * from view_test;

DROP DATABASE mcol_5061;