summaryrefslogtreecommitdiff
path: root/mysql-test/suite/parts/r/partition_open.result
diff options
context:
space:
mode:
authorAlexey Botchkov <holyfoot@askmonty.org>2018-01-29 11:01:14 +0400
committerAlexey Botchkov <holyfoot@askmonty.org>2018-01-29 11:01:14 +0400
commitb4a2baffa82e5c07b96a1c752228560dcac1359b (patch)
tree5520b02f5c3bd21bf36f1fdf00a85dc9143c7fe5 /mysql-test/suite/parts/r/partition_open.result
parent041a32abcdd9791761a15d93e77ff2ea7dbc9d7c (diff)
downloadmariadb-git-b4a2baffa82e5c07b96a1c752228560dcac1359b.tar.gz
MDEV-11084 Select statement with partition selection against MyISAM table opens all partitions.
Now we don't open partitions if it was explicitly cpecified. ha_partition::m_opened_partition bitmap added to track partitions that were actually opened.
Diffstat (limited to 'mysql-test/suite/parts/r/partition_open.result')
-rw-r--r--mysql-test/suite/parts/r/partition_open.result8
1 files changed, 8 insertions, 0 deletions
diff --git a/mysql-test/suite/parts/r/partition_open.result b/mysql-test/suite/parts/r/partition_open.result
new file mode 100644
index 00000000000..98600d98ce3
--- /dev/null
+++ b/mysql-test/suite/parts/r/partition_open.result
@@ -0,0 +1,8 @@
+select * from t1 partition (p1);
+x
+300
+select * from t1 partition (p0);
+ERROR HY000: Can't find file: './test/t1.MYI' (errno: 2 "No such file or directory")
+drop table t1;
+Warnings:
+Warning 1017 Can't find file: './test/t1.MYI' (errno: 2 "No such file or directory")