summaryrefslogtreecommitdiff
path: root/mysql-test/main/partition_pruning.result
diff options
context:
space:
mode:
authorAlexey Botchkov <holyfoot@askmonty.org>2019-11-20 00:33:32 +0400
committerAlexey Botchkov <holyfoot@askmonty.org>2019-11-20 00:33:32 +0400
commit7b5654f3e987dcbaa8cb0fdfd3486ffb3fc4f8e3 (patch)
tree03b0b862168b625e83c8573204e507cb8156beae /mysql-test/main/partition_pruning.result
parent39d8652ca529e712430f57addc098b71521449e3 (diff)
downloadmariadb-git-7b5654f3e987dcbaa8cb0fdfd3486ffb3fc4f8e3.tar.gz
MDEV-14667 Assertion `used_parts > 0' failed in ha_partition::init_record_priority_queue.
Do not fail fi all the partitions were pruned out.
Diffstat (limited to 'mysql-test/main/partition_pruning.result')
-rw-r--r--mysql-test/main/partition_pruning.result10
1 files changed, 10 insertions, 0 deletions
diff --git a/mysql-test/main/partition_pruning.result b/mysql-test/main/partition_pruning.result
index 00bd24101d6..6a97541f2db 100644
--- a/mysql-test/main/partition_pruning.result
+++ b/mysql-test/main/partition_pruning.result
@@ -3485,6 +3485,16 @@ a b c d
1 a b 1
drop table t1;
#
+# MDEV-14667 Assertion `used_parts > 0' failed in ha_partition::init_record_priority_queue.
+#
+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;
+a b c
+drop table t1, t2;
+#
# MDEV-17493: Partition pruning doesn't work for nested outer joins
#
create table t0(a int);