summaryrefslogtreecommitdiff
path: root/mysql-test/main/plugin.result
diff options
context:
space:
mode:
authorSergey Vojtovich <svoj@mariadb.org>2019-02-06 11:41:36 +0400
committerSergey Vojtovich <svoj@mariadb.org>2019-04-03 16:47:25 +0400
commit1dac55cf0ef4a412d56ea870835e1e199a400820 (patch)
treeb6c24683247c7657fd24592e110d6639da9f050d /mysql-test/main/plugin.result
parent3638636f9b0c07665c5df498c31ae9c6ccac0b34 (diff)
downloadmariadb-git-1dac55cf0ef4a412d56ea870835e1e199a400820.tar.gz
Removed redundant SE lock for tmp tables
CREATE TEMPORARY TABLE locks SE plugin 6 times. 5 of these locks are released by the end of the statement. And only 1 acquired by init_from_binary_frm_image() / plugin_lock() remains. The lock removed in this patch was clearly redundant. Part of MDEV-17805 - Remove InnoDB cache for temporary tables.
Diffstat (limited to 'mysql-test/main/plugin.result')
-rw-r--r--mysql-test/main/plugin.result15
1 files changed, 15 insertions, 0 deletions
diff --git a/mysql-test/main/plugin.result b/mysql-test/main/plugin.result
index 947a2b6bd7a..49342705289 100644
--- a/mysql-test/main/plugin.result
+++ b/mysql-test/main/plugin.result
@@ -378,3 +378,18 @@ select PLUGIN_NAME,PLUGIN_STATUS,PLUGIN_TYPE from information_schema.plugins whe
PLUGIN_NAME PLUGIN_STATUS PLUGIN_TYPE
UNINSTALL SONAME 'ha_example';
ERROR 42000: SONAME ha_example.so does not exist
+#
+# Make sure temporary tables maintain plugin references properly
+#
+INSTALL PLUGIN example SONAME 'ha_example';
+CREATE TEMPORARY TABLE t1(a INT) ENGINE=example;
+UNINSTALL PLUGIN example;
+Warnings:
+Warning 1620 Plugin is busy and will be uninstalled on shutdown
+INSTALL PLUGIN example SONAME 'ha_example';
+ERROR HY000: Plugin 'example' already installed
+DROP TABLE t1;
+INSTALL PLUGIN example SONAME 'ha_example';
+CREATE TEMPORARY TABLE t1(a INT) ENGINE=example;
+DROP TABLE t1;
+UNINSTALL PLUGIN example;