summaryrefslogtreecommitdiffstats
path: root/mysql-test/main/no-threads.test
diff options
context:
space:
mode:
Diffstat (limited to '')
-rw-r--r--mysql-test/main/no-threads.test20
1 files changed, 20 insertions, 0 deletions
diff --git a/mysql-test/main/no-threads.test b/mysql-test/main/no-threads.test
new file mode 100644
index 00000000..8235ff67
--- /dev/null
+++ b/mysql-test/main/no-threads.test
@@ -0,0 +1,20 @@
+# Tests will be skipped for the view protocol because the view protocol creates
+# an additional util connection and other statistics data
+-- source include/no_view_protocol.inc
+
+#
+# Test the --thread-handler=no-threads option
+#
+select 1+1;
+select 1+2;
+SHOW GLOBAL VARIABLES LIKE 'thread_handling';
+
+#
+# Bug #30651 Problems with thread_handling system variable
+#
+
+--error ER_INCORRECT_GLOBAL_LOCAL_VAR
+select @@session.thread_handling;
+
+--error ER_INCORRECT_GLOBAL_LOCAL_VAR
+set GLOBAL thread_handling='one-thread';