1SET @start_global_value = @@global.slave_transaction_retries; 2'#--------------------FN_DYNVARS_149_01-------------------------#' 3SET @@global.slave_transaction_retries = 50; 4SET @@global.slave_transaction_retries = DEFAULT; 5SELECT @@global.slave_transaction_retries; 6@@global.slave_transaction_retries 710 8'#--------------------FN_DYNVARS_149_02-------------------------#' 9SET @@global.slave_transaction_retries = DEFAULT; 10SELECT @@global.slave_transaction_retries = 10; 11@@global.slave_transaction_retries = 10 121 13'#--------------------FN_DYNVARS_149_03-------------------------#' 14SET @@global.slave_transaction_retries = 0; 15SELECT @@global.slave_transaction_retries; 16@@global.slave_transaction_retries 170 18SET @@global.slave_transaction_retries = 1; 19SELECT @@global.slave_transaction_retries; 20@@global.slave_transaction_retries 211 22SET @@global.slave_transaction_retries = 15; 23SELECT @@global.slave_transaction_retries; 24@@global.slave_transaction_retries 2515 26SET @@global.slave_transaction_retries = 1024; 27SELECT @@global.slave_transaction_retries; 28@@global.slave_transaction_retries 291024 30SET @@global.slave_transaction_retries = 2147483648; 31SELECT @@global.slave_transaction_retries; 32@@global.slave_transaction_retries 332147483648 34SET @@global.slave_transaction_retries = 2147483648*2-1; 35SELECT @@global.slave_transaction_retries; 36@@global.slave_transaction_retries 374294967295 38SET @@global.slave_transaction_retries = 2147483649*2; 39SELECT @@global.slave_transaction_retries; 40@@global.slave_transaction_retries 414294967298 42SET @@global.slave_transaction_retries = 4294967295; 43SELECT @@global.slave_transaction_retries; 44@@global.slave_transaction_retries 454294967295 46'#--------------------FN_DYNVARS_149_04-------------------------#' 47SET @@slave_transaction_retries = 2; 48ERROR HY000: Variable 'slave_transaction_retries' is a GLOBAL variable and should be set with SET GLOBAL 49SET @@session.slave_transaction_retries = 3; 50ERROR HY000: Variable 'slave_transaction_retries' is a GLOBAL variable and should be set with SET GLOBAL 51SET @@local.slave_transaction_retries = 4; 52ERROR HY000: Variable 'slave_transaction_retries' is a GLOBAL variable and should be set with SET GLOBAL 53'#------------------FN_DYNVARS_149_05-----------------------#' 54SET @@global.slave_transaction_retries = -1; 55Warnings: 56Warning 1292 Truncated incorrect slave_transaction_retries value: '-1' 57SELECT @@global.slave_transaction_retries; 58@@global.slave_transaction_retries 590 60SET @@global.slave_transaction_retries = 2147483649*2147483649; 61SELECT @@global.slave_transaction_retries; 62@@global.slave_transaction_retries 634611686022722355201 64SET @@global.slave_transaction_retries = 65530.34; 65ERROR 42000: Incorrect argument type to variable 'slave_transaction_retries' 66SET @@global.slave_transaction_retries = '100'; 67ERROR 42000: Incorrect argument type to variable 'slave_transaction_retries' 68SET @@global.slave_transaction_retries = 7483649.56; 69ERROR 42000: Incorrect argument type to variable 'slave_transaction_retries' 70SET @@global.slave_transaction_retries = ON; 71ERROR 42000: Incorrect argument type to variable 'slave_transaction_retries' 72SET @@global.slave_transaction_retries = OFF; 73ERROR 42000: Incorrect argument type to variable 'slave_transaction_retries' 74'#------------------FN_DYNVARS_149_06-----------------------#' 75SET @@global.slave_transaction_retries = 3000; 76SELECT @@global.slave_transaction_retries = VARIABLE_VALUE 77FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES 78WHERE VARIABLE_NAME='slave_transaction_retries'; 79@@global.slave_transaction_retries = VARIABLE_VALUE 801 81'#------------------FN_DYNVARS_149_07-----------------------#' 82SELECT count(VARIABLE_VALUE) 83FROM INFORMATION_SCHEMA.SESSION_VARIABLES 84WHERE VARIABLE_NAME='slave_transaction_retries'; 85count(VARIABLE_VALUE) 861 87'#------------------FN_DYNVARS_149_08-----------------------#' 88SET @@global.slave_transaction_retries = TRUE; 89SELECT @@global.slave_transaction_retries; 90@@global.slave_transaction_retries 911 92SET @@global.slave_transaction_retries = FALSE; 93SELECT @@global.slave_transaction_retries; 94@@global.slave_transaction_retries 950 96'#---------------------FN_DYNVARS_149_09----------------------#' 97SET @@global.slave_transaction_retries = 60*60; 98SELECT @@slave_transaction_retries = @@global.slave_transaction_retries; 99@@slave_transaction_retries = @@global.slave_transaction_retries 1001 101'#---------------------FN_DYNVARS_149_10----------------------#' 102SET slave_transaction_retries = 2048; 103ERROR HY000: Variable 'slave_transaction_retries' is a GLOBAL variable and should be set with SET GLOBAL 104SELECT slave_transaction_retries; 105ERROR 42S22: Unknown column 'slave_transaction_retries' in 'field list' 106SELECT @@slave_transaction_retries; 107@@slave_transaction_retries 1083600 109SET global slave_transaction_retries = 99; 110SET @@global.slave_transaction_retries = @start_global_value; 111