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