summaryrefslogtreecommitdiff
path: root/mysql-test/main/ps_not_windows.test
diff options
context:
space:
mode:
Diffstat (limited to 'mysql-test/main/ps_not_windows.test')
-rw-r--r--mysql-test/main/ps_not_windows.test29
1 files changed, 29 insertions, 0 deletions
diff --git a/mysql-test/main/ps_not_windows.test b/mysql-test/main/ps_not_windows.test
new file mode 100644
index 00000000000..2003251dc55
--- /dev/null
+++ b/mysql-test/main/ps_not_windows.test
@@ -0,0 +1,29 @@
+# doesn't work with embedded server
+--source include/not_embedded.inc
+# Non-windows specific ps tests.
+--source include/not_windows.inc
+# requires dynamic loading
+if (`SELECT @@have_dynamic_loading != 'YES'`) {
+ --skip ps_not_windows requires dynamic loading
+}
+
+#
+# Bug #20665: All commands supported in Stored Procedures should work in
+# Prepared Statements
+#
+
+create procedure proc_1() install plugin my_plug soname '/root/some_plugin.so';
+--error ER_UDF_NO_PATHS
+call proc_1();
+--error ER_UDF_NO_PATHS
+call proc_1();
+--error ER_UDF_NO_PATHS
+call proc_1();
+drop procedure proc_1;
+
+prepare abc from "install plugin my_plug soname '/root/some_plugin.so'";
+--error ER_UDF_NO_PATHS
+execute abc;
+--error ER_UDF_NO_PATHS
+execute abc;
+deallocate prepare abc;