summaryrefslogtreecommitdiffstats
path: root/mysql-test/suite/sys_vars/r/skip_name_resolve_basic.result
blob: d22a39b32a0bee1f1a386c2730e75f0c12622212 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
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