You've already forked mariadb-columnstore-engine
mirror of
https://github.com/mariadb-corporation/mariadb-columnstore-engine.git
synced 2025-07-29 08:21:15 +03:00
5f07828619
This patch: 1. Properly processes situation when pm join result count is exceeded. 2. Adds session variable 'columnstore_max_pm_join_result_count` to control the limit.
37 lines
856 B
Plaintext
37 lines
856 B
Plaintext
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;
|