1SET @start_global_value = @@global.slave_transaction_retry_interval; 2SELECT @start_global_value; 3@start_global_value 40 5'#--------------------FN_DYNVARS_149_01-------------------------#' 6SET @@global.slave_transaction_retry_interval = 50; 7SET @@global.slave_transaction_retry_interval = DEFAULT; 8SELECT @@global.slave_transaction_retry_interval; 9@@global.slave_transaction_retry_interval 100 11'#--------------------FN_DYNVARS_149_02-------------------------#' 12SET @@global.slave_transaction_retry_interval = DEFAULT; 13SELECT @@global.slave_transaction_retry_interval = 10; 14@@global.slave_transaction_retry_interval = 10 150 16'#--------------------FN_DYNVARS_149_03-------------------------#' 17SET @@global.slave_transaction_retry_interval = 0; 18SELECT @@global.slave_transaction_retry_interval; 19@@global.slave_transaction_retry_interval 200 21SET @@global.slave_transaction_retry_interval = 1; 22SELECT @@global.slave_transaction_retry_interval; 23@@global.slave_transaction_retry_interval 241 25SET @@global.slave_transaction_retry_interval = 15; 26SELECT @@global.slave_transaction_retry_interval; 27@@global.slave_transaction_retry_interval 2815 29SET @@global.slave_transaction_retry_interval = 1024; 30SELECT @@global.slave_transaction_retry_interval; 31@@global.slave_transaction_retry_interval 321024 33SET @@global.slave_transaction_retry_interval = 2147483648; 34Warnings: 35Warning 1292 Truncated incorrect slave_transaction_retry_interval value: '2147483648' 36SELECT @@global.slave_transaction_retry_interval; 37@@global.slave_transaction_retry_interval 383600 39SET @@global.slave_transaction_retry_interval = 2147483648*2-1; 40Warnings: 41Warning 1292 Truncated incorrect slave_transaction_retry_interval value: '4294967295' 42SELECT @@global.slave_transaction_retry_interval; 43@@global.slave_transaction_retry_interval 443600 45SET @@global.slave_transaction_retry_interval = 2147483649*2; 46Warnings: 47Warning 1292 Truncated incorrect slave_transaction_retry_interval value: '4294967298' 48SELECT @@global.slave_transaction_retry_interval; 49@@global.slave_transaction_retry_interval 503600 51SET @@global.slave_transaction_retry_interval = 4294967295; 52Warnings: 53Warning 1292 Truncated incorrect slave_transaction_retry_interval value: '4294967295' 54SELECT @@global.slave_transaction_retry_interval; 55@@global.slave_transaction_retry_interval 563600 57'#--------------------FN_DYNVARS_149_04-------------------------#' 58SET @@slave_transaction_retry_interval = 2; 59ERROR HY000: Variable 'slave_transaction_retry_interval' is a GLOBAL variable and should be set with SET GLOBAL 60SET @@session.slave_transaction_retry_interval = 3; 61ERROR HY000: Variable 'slave_transaction_retry_interval' is a GLOBAL variable and should be set with SET GLOBAL 62SET @@local.slave_transaction_retry_interval = 4; 63ERROR HY000: Variable 'slave_transaction_retry_interval' is a GLOBAL variable and should be set with SET GLOBAL 64'#------------------FN_DYNVARS_149_05-----------------------#' 65SET @@global.slave_transaction_retry_interval = -1; 66Warnings: 67Warning 1292 Truncated incorrect slave_transaction_retry_interval value: '-1' 68SELECT @@global.slave_transaction_retry_interval; 69@@global.slave_transaction_retry_interval 700 71SET @@global.slave_transaction_retry_interval = 2147483649*2147483649; 72Warnings: 73Warning 1292 Truncated incorrect slave_transaction_retry_interval value: '4611686022722355201' 74SELECT @@global.slave_transaction_retry_interval; 75@@global.slave_transaction_retry_interval 763600 77SET @@global.slave_transaction_retry_interval = 65530.34; 78ERROR 42000: Incorrect argument type to variable 'slave_transaction_retry_interval' 79SET @@global.slave_transaction_retry_interval = '100'; 80ERROR 42000: Incorrect argument type to variable 'slave_transaction_retry_interval' 81SET @@global.slave_transaction_retry_interval = 7483649.56; 82ERROR 42000: Incorrect argument type to variable 'slave_transaction_retry_interval' 83SET @@global.slave_transaction_retry_interval = ON; 84ERROR 42000: Incorrect argument type to variable 'slave_transaction_retry_interval' 85SET @@global.slave_transaction_retry_interval = OFF; 86ERROR 42000: Incorrect argument type to variable 'slave_transaction_retry_interval' 87'#------------------FN_DYNVARS_149_06-----------------------#' 88SET @@global.slave_transaction_retry_interval = 3000; 89SELECT @@global.slave_transaction_retry_interval = VARIABLE_VALUE 90FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES 91WHERE VARIABLE_NAME='slave_transaction_retry_interval'; 92@@global.slave_transaction_retry_interval = VARIABLE_VALUE 931 94'#------------------FN_DYNVARS_149_07-----------------------#' 95SELECT count(VARIABLE_VALUE) 96FROM INFORMATION_SCHEMA.SESSION_VARIABLES 97WHERE VARIABLE_NAME='slave_transaction_retry_interval'; 98count(VARIABLE_VALUE) 991 100'#------------------FN_DYNVARS_149_08-----------------------#' 101SET @@global.slave_transaction_retry_interval = TRUE; 102SELECT @@global.slave_transaction_retry_interval; 103@@global.slave_transaction_retry_interval 1041 105SET @@global.slave_transaction_retry_interval = FALSE; 106SELECT @@global.slave_transaction_retry_interval; 107@@global.slave_transaction_retry_interval 1080 109'#---------------------FN_DYNVARS_149_09----------------------#' 110SET @@global.slave_transaction_retry_interval = 60*60; 111SELECT @@slave_transaction_retry_interval = @@global.slave_transaction_retry_interval; 112@@slave_transaction_retry_interval = @@global.slave_transaction_retry_interval 1131 114'#---------------------FN_DYNVARS_149_10----------------------#' 115SET slave_transaction_retry_interval = 2048; 116ERROR HY000: Variable 'slave_transaction_retry_interval' is a GLOBAL variable and should be set with SET GLOBAL 117SELECT slave_transaction_retry_interval; 118ERROR 42S22: Unknown column 'slave_transaction_retry_interval' in 'field list' 119SELECT @@slave_transaction_retry_interval; 120@@slave_transaction_retry_interval 1213600 122SET global slave_transaction_retry_interval = 99; 123SET @@global.slave_transaction_retry_interval = @start_global_value; 124SELECT @@global.slave_transaction_retry_interval; 125@@global.slave_transaction_retry_interval 1260 127