summaryrefslogtreecommitdiff
path: root/mysql-test/r/skip_name_resolve.result
diff options
context:
space:
mode:
Diffstat (limited to 'mysql-test/r/skip_name_resolve.result')
-rw-r--r--mysql-test/r/skip_name_resolve.result27
1 files changed, 27 insertions, 0 deletions
diff --git a/mysql-test/r/skip_name_resolve.result b/mysql-test/r/skip_name_resolve.result
index 8aa9877a8e9..1d92d52110d 100644
--- a/mysql-test/r/skip_name_resolve.result
+++ b/mysql-test/r/skip_name_resolve.result
@@ -9,3 +9,30 @@ SELECT USER();
USER()
#
SHOW PROCESSLIST;
+#
+# Bug #37168: Missing variable - skip_name_resolve
+#
+SHOW VARIABLES LIKE 'skip_name_resolve';
+Variable_name Value
+skip_name_resolve ON
+SHOW GLOBAL VARIABLES LIKE 'skip_name_resolve';
+Variable_name Value
+skip_name_resolve ON
+SHOW SESSION VARIABLES LIKE 'skip_name_resolve';
+Variable_name Value
+skip_name_resolve ON
+SELECT @@skip_name_resolve;
+@@skip_name_resolve
+1
+SELECT @@LOCAL.skip_name_resolve;
+ERROR HY000: Variable 'skip_name_resolve' is a GLOBAL variable
+SELECT @@GLOBAL.skip_name_resolve;
+@@GLOBAL.skip_name_resolve
+1
+SET @@skip_name_resolve=0;
+ERROR HY000: Variable 'skip_name_resolve' is a read only variable
+SET @@LOCAL.skip_name_resolve=0;
+ERROR HY000: Variable 'skip_name_resolve' is a read only variable
+SET @@GLOBAL.skip_name_resolve=0;
+ERROR HY000: Variable 'skip_name_resolve' is a read only variable
+End of 5.1 tests