diff options
| author | Marko Mäkelä <marko.makela@mariadb.com> | 2019-11-20 14:11:54 +0800 |
|---|---|---|
| committer | Marko Mäkelä <marko.makela@mariadb.com> | 2019-11-20 14:11:54 +0800 |
| commit | 1c9240633792ecce562358d86cd8d2c18b94ae32 (patch) | |
| tree | 0940c908260775decbabb3db78acfeef0fbe53ed /mysql-test/main/partition_pruning.test | |
| parent | 589a1235b64866c7bbe85da2a6f6bf19ee8282fe (diff) | |
| parent | aa3d28ac34322940c2ac59f74e50b450d2cff531 (diff) | |
| download | mariadb-git-1c9240633792ecce562358d86cd8d2c18b94ae32.tar.gz | |
Merge 10.3 into 10.4
Diffstat (limited to 'mysql-test/main/partition_pruning.test')
| -rw-r--r-- | mysql-test/main/partition_pruning.test | 13 |
1 files changed, 13 insertions, 0 deletions
diff --git a/mysql-test/main/partition_pruning.test b/mysql-test/main/partition_pruning.test index aea61a941f7..d59f52be313 100644 --- a/mysql-test/main/partition_pruning.test +++ b/mysql-test/main/partition_pruning.test @@ -1539,6 +1539,19 @@ select * from t1 where (a = 1 AND b < 'd' AND (c = 'b' OR (c = 'c' AND d = 1)) O drop table t1; --echo # +--echo # MDEV-14667 Assertion `used_parts > 0' failed in ha_partition::init_record_priority_queue. +--echo # + +create table t1 (a int); +insert into t1 values (1),(2); + +create table t2 (b int, c int, key(c,b)) partition by hash(b) partitions 2; +insert into t2 values (3,4),(5,6); + +select straight_join * from t1, t2 where b != NULL; +drop table t1, t2; + +--echo # --echo # MDEV-17493: Partition pruning doesn't work for nested outer joins --echo # |