diff options
author | Michael Widenius <monty@askmonty.org> | 2012-04-04 00:16:38 +0300 |
---|---|---|
committer | Michael Widenius <monty@askmonty.org> | 2012-04-04 00:16:38 +0300 |
commit | b04c4801b0529aebb39c8d9be95c123d2f3b7d46 (patch) | |
tree | 0a4f72935b5ac6816996172ae412b62327b4caf4 /mysql-test/suite/maria/maria-partitioning.test | |
parent | 34ed8f33795b639d21817003236ce0f6c069481d (diff) | |
download | mariadb-git-b04c4801b0529aebb39c8d9be95c123d2f3b7d46.tar.gz |
Created suites for heap, archive and csv.
Moved test from main suite to the new suites.
Move tests from maria/t and maria/r to maria
mysql-test/mysql-test-run.pl:
Added support for the new suites
Diffstat (limited to 'mysql-test/suite/maria/maria-partitioning.test')
-rw-r--r-- | mysql-test/suite/maria/maria-partitioning.test | 42 |
1 files changed, 42 insertions, 0 deletions
diff --git a/mysql-test/suite/maria/maria-partitioning.test b/mysql-test/suite/maria/maria-partitioning.test new file mode 100644 index 00000000000..612c44be57e --- /dev/null +++ b/mysql-test/suite/maria/maria-partitioning.test @@ -0,0 +1,42 @@ +# +# Testing of potential problems in Aria with partitioning +# + +--source include/have_maria.inc +--source include/have_partition.inc + +let $default_engine=`select @@global.storage_engine`; +let $default_checksum=`select @@global.aria_page_checksum`; +set global storage_engine=aria; +set session storage_engine=aria; + +# +# Test outer join const propagation +# +DROP TABLE if exists t1,t2; +create table t2(a blob) engine=aria; +create table t1(a int primary key) engine=aria; +insert into t2 values ('foo'),('bar'); +select * from t2 left join t1 on (t2.a=t1.a) where t2.a='bbb'; +insert into t1 values (1); +select * from t2 left join t1 on (t2.a=t1.a) where t2.a='bbb'; +insert into t1 values (2); +select * from t2 left join t1 on (t2.a=t1.a) where t2.a='bbb'; +drop table t1,t2; + +create table t2(a blob) engine= aria; +create table t1(a int primary key) engine= aria PARTITION BY HASH (a) PARTITIONS 2; +insert into t2 values ('foo'),('bar'); +select * from t2 left join t1 on (t2.a=t1.a) where t2.a='bbb'; +insert into t1 values (1); +select * from t2 left join t1 on (t2.a=t1.a) where t2.a='bbb'; +insert into t1 values (2); +select * from t2 left join t1 on (t2.a=t1.a) where t2.a='bbb'; +drop table t1,t2; + +# Set defaults back +--disable_result_log +--disable_query_log +eval set global storage_engine=$default_engine; +--enable_result_log +--enable_query_log |