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