--source ../include/have_columnstore.inc

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

create table t1 (a int) engine=columnstore;
create table t2 (a int) engine=columnstore;
insert into t1 values (1), (2), (3), (4);
insert into t2 values (1), (2), (3), (4);

create table t3 (a varchar(200)) engine=columnstore;
create table t4 (a varchar(200)) engine=columnstore;
insert into t3 values ("one"), ("two"), ("three");
insert into t4 values ("one"), ("two"), ("three");

set session columnstore_max_pm_join_result_count=1;
select * from t1, t2 where t1.a = t2.a order by t1.a, t2.a;
select * from t3, t4 where t3.a = t4.a order by t3.a, t4.a;

set session columnstore_max_pm_join_result_count=1048576;
select * from t1, t2 where t1.a = t2.a order by t1.a, t2.a;
select * from t3, t4 where t3.a = t4.a order by t3.a, t4.a;

--disable_warnings
DROP DATABASE mcol_5522;
--enable_warnings