1
SET @global_start_value = @@global.init_slave;
2
SELECT @global_start_value AS INIT_VALUE;
5
'#--------------------FN_DYNVARS_037_01------------------#'
7
ERROR 42S22: Unknown column 'init_slave' in 'field list'
11
SET @@global.init_slave='SET autocomit=0';
12
SELECT @@global.init_slave;
15
SET global init_slave='SET autocomit=0';
16
SELECT global init_slave;
17
ERROR 42S22: Unknown column 'global' in 'field list'
18
SELECT @@global init_slave;
19
ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'init_slave' at line 1
20
'#--------------------FN_DYNVARS_037_02-------------------------#'
21
SET @@global.init_slave = 'SET join_buffer_size=8200';
22
SET @@global.init_slave = DEFAULT;
23
SELECT @@global.init_slave;
26
'#--------------------FN_DYNVARS_037_03-------------------------#'
27
SET @@session.init_slave = '';
28
ERROR HY000: Variable 'init_slave' is a GLOBAL variable and should be set with SET GLOBAL
29
SET @@init_slave = "";
30
ERROR HY000: Variable 'init_slave' is a GLOBAL variable and should be set with SET GLOBAL
31
SELECT @@session.init_slave;
32
ERROR HY000: Variable 'init_slave' is a GLOBAL variable
33
SELECT @@local.init_slave;
34
ERROR HY000: Variable 'init_slave' is a GLOBAL variable
35
'#--------------------FN_DYNVARS_037_04-------------------------#'
36
SET @@global.init_slave="";
37
SELECT @@global.init_slave;
40
SET @@global.init_slave='SELECT 1,"abc"';
41
SELECT @@global.init_slave;
44
SET @@global.init_slave='SET @a="b"';
45
SELECT @@global.init_slave;
48
SET @@global.init_slave="SET autocomit=1;REVOKE ALL ON INFORMATION_SCHEMA.*";
49
SELECT @@global.init_slave;
51
SET autocomit=1;REVOKE ALL ON INFORMATION_SCHEMA.*
52
SET @@global.init_slave='SHOW VARIABLES';
53
SELECT @@global.init_slave;
56
SET @@global.init_slave = NULL;
57
SELECT @@global.init_slave;
60
SET @@global.init_slave='abc 123 +-*/';
61
SELECT @@global.init_slave;
64
SET @@global.init_slave=this_will_give_syntax_error;
65
SELECT @@global.init_slave;
67
this_will_give_syntax_error
68
SET @@global.init_slave = init_slave;
69
SELECT @@global.init_slave;
72
'#--------------------FN_DYNVARS_037_05-------------------------#'
73
SET @@global.init_slave = true;
74
ERROR 42000: Incorrect argument type to variable 'init_slave'
75
SET @@global.init_slave = false;
76
ERROR 42000: Incorrect argument type to variable 'init_slave'
77
SET @@global.init_slave = 1.1;
78
ERROR 42000: Incorrect argument type to variable 'init_slave'
79
SET @@global.init_slave = 0;
80
ERROR 42000: Incorrect argument type to variable 'init_slave'
81
SET @@global.init_slave = 1;
82
ERROR 42000: Incorrect argument type to variable 'init_slave'
83
SET @@global.init_slave = -1;
84
ERROR 42000: Incorrect argument type to variable 'init_slave'
85
SET @@global.init_slave = ON;
86
SELECT @@global.init_slave;
89
'#--------------------FN_DYNVARS_037_06-------------------------#'
90
SELECT @@global.init_slave = (SELECT VARIABLE_VALUE
91
FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
92
WHERE VARIABLE_NAME='init_slave') AS res;
95
SET @@global.init_slave = @global_start_value;
96
SELECT @@global.init_slave;