summaryrefslogtreecommitdiff
path: root/mysql-test/suite/handler
diff options
context:
space:
mode:
authorSergei Golubchik <serg@mariadb.org>2016-05-03 20:31:02 +0200
committerSergei Golubchik <serg@mariadb.org>2016-05-05 01:05:05 +0200
commit153259874bfb32c9d1f89a682b96897e32a61986 (patch)
tree8735a88f80dd97bbc21d14a91478eca6b6145015 /mysql-test/suite/handler
parent5ef0ce4131c9e5ebd2e09907a6a89b6c9d6c5afe (diff)
downloadmariadb-git-153259874bfb32c9d1f89a682b96897e32a61986.tar.gz
MDEV-9155 Enabling Defragmenting in 10.1.8 still causes OPTIMIZE TABLE to take metadatalocks
take MDL_SHARED_WRITE instead of MDL_SHARED_NO_READ_WRITE for OPTIMIZE TABLE. For engines that need a stronger lock (like MyISAM), reopen the table with MDL_SHARED_NO_READ_WRITE.
Diffstat (limited to 'mysql-test/suite/handler')
-rw-r--r--mysql-test/suite/handler/innodb.result1
1 files changed, 0 insertions, 1 deletions
diff --git a/mysql-test/suite/handler/innodb.result b/mysql-test/suite/handler/innodb.result
index 78660b0ef9c..617b74ca714 100644
--- a/mysql-test/suite/handler/innodb.result
+++ b/mysql-test/suite/handler/innodb.result
@@ -543,7 +543,6 @@ optimize table t1;
proceed with the normal connection
handler t1 read next;
c1
-1
handler t1 close;
read the result from the other connection
Table Op Msg_type Msg_text