summaryrefslogtreecommitdiff
path: root/mysql-test/main/no-threads.test
diff options
context:
space:
mode:
Diffstat (limited to 'mysql-test/main/no-threads.test')
-rw-r--r--mysql-test/main/no-threads.test17
1 files changed, 17 insertions, 0 deletions
diff --git a/mysql-test/main/no-threads.test b/mysql-test/main/no-threads.test
new file mode 100644
index 00000000000..a2936abf784
--- /dev/null
+++ b/mysql-test/main/no-threads.test
@@ -0,0 +1,17 @@
+--source include/one_thread_per_connection.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';