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>
37 lines
936 B
Plaintext
37 lines
936 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 order by t1.a, t2.a;
|
|
a a
|
|
1 1
|
|
2 2
|
|
3 3
|
|
4 4
|
|
select * from t3, t4 where t3.a = t4.a order by t3.a, t4.a;
|
|
a a
|
|
one one
|
|
three three
|
|
two two
|
|
set session columnstore_max_pm_join_result_count=1048576;
|
|
select * from t1, t2 where t1.a = t2.a order by t1.a, t2.a;
|
|
a a
|
|
1 1
|
|
2 2
|
|
3 3
|
|
4 4
|
|
select * from t3, t4 where t3.a = t4.a order by t3.a, t4.a;
|
|
a a
|
|
one one
|
|
three three
|
|
two two
|
|
DROP DATABASE mcol_5522;
|