summaryrefslogtreecommitdiff
path: root/mysql-test/t/blackhole_plugin.test
diff options
context:
space:
mode:
authorAlexander Nozdrin <alexander.nozdrin@oracle.com>2011-03-14 14:03:08 +0300
committerAlexander Nozdrin <alexander.nozdrin@oracle.com>2011-03-14 14:03:08 +0300
commit2f5a462fdd9d9b591732dd59d2037a6fbc331142 (patch)
tree12728e0091cac43a53904c33ba251914270dffa9 /mysql-test/t/blackhole_plugin.test
parent5e2c0f82c1047a95bb3bab0d784b17a24c9915d0 (diff)
downloadmariadb-git-2f5a462fdd9d9b591732dd59d2037a6fbc331142.tar.gz
A patch for Bug#11765297 (58251 - archive_plugin and blackhole_plugin
fails when running with ps-protocol). The problem was that when running in --ps-protocol mode mysqltest.cc didn't close created prepared statements. So, the plugins could not be unistalled because there was a prepared statement using them. A fix is to add a dummy statement that forces mysqltest.cc to close the last prepared statement (which uses a plugin-defined table).
Diffstat (limited to 'mysql-test/t/blackhole_plugin.test')
-rw-r--r--mysql-test/t/blackhole_plugin.test8
1 files changed, 8 insertions, 0 deletions
diff --git a/mysql-test/t/blackhole_plugin.test b/mysql-test/t/blackhole_plugin.test
index 1de5b2d0499..448104bed2b 100644
--- a/mysql-test/t/blackhole_plugin.test
+++ b/mysql-test/t/blackhole_plugin.test
@@ -20,6 +20,14 @@ CREATE TABLE t1(a int) ENGINE=BLACKHOLE;
DROP TABLE t1;
+# This dummy statement is required for --ps-protocol mode.
+# The thing is that last prepared statement is "cached" in mysqltest.cc
+# (unless "reconnect" is enabled, and that's not the case here).
+# This statement forces mysqltest.cc to close prepared "DROP TABLE t1".
+# Otherwise, the plugin can not be uninstalled because there is an active
+# prepared statement using it.
+SELECT 1;
+
UNINSTALL PLUGIN blackhole;
--error ER_SP_DOES_NOT_EXIST
UNINSTALL PLUGIN blackhole;