You've already forked mariadb-columnstore-engine
mirror of
https://github.com/mariadb-corporation/mariadb-columnstore-engine.git
synced 2025-07-30 19:23:07 +03:00
1283f1fc4d
* Added order by clause to keep results consistent over test runs * Updated test result for the merging of MCOL-5519 * Updated test results for the merging of MCOL-4632 * Updated test result for the merging of MCOL-5519 * Added missing / to path * Improved few tests cases * Fixed test case name --------- Co-authored-by: root <root@rocky8.localdomain>
30 lines
953 B
Plaintext
30 lines
953 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 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
|