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.
30 lines
873 B
Plaintext
30 lines
873 B
Plaintext
--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;
|
|
select * from t3, t4 where t3.a = t4.a;
|
|
|
|
set session columnstore_max_pm_join_result_count=1048576;
|
|
select * from t1, t2 where t1.a = t2.a;
|
|
select * from t3, t4 where t3.a = t4.a;
|
|
|
|
--disable_warnings
|
|
DROP DATABASE mcol_5522;
|
|
--enable_warnings
|