DROP DATABASE IF EXISTS mcol_5522;
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;
a	a
1	1
2	2
3	3
4	4
select * from t3, t4 where t3.a = t4.a;
a	a
one	one
two	two
three	three
set session columnstore_max_pm_join_result_count=1048576;
select * from t1, t2 where t1.a = t2.a;
a	a
1	1
2	2
3	3
4	4
select * from t3, t4 where t3.a = t4.a;
a	a
one	one
two	two
three	three
DROP DATABASE mcol_5522;