1SET @session_start_value = @@session.pseudo_slave_mode; 2SELECT @session_start_value; 3@session_start_value 40 5'#--------------------FN_DYNVARS_156_01------------------------#' 6SET @@session.pseudo_slave_mode = 0; 7Warnings: 8Warning 1231 'pseudo_slave_mode' change was ineffective. 9SET @@session.pseudo_slave_mode = DEFAULT; 10Warnings: 11Warning 1231 'pseudo_slave_mode' change was ineffective. 12SELECT @@session.pseudo_slave_mode; 13@@session.pseudo_slave_mode 140 15SET @@session.pseudo_slave_mode = 1; 16SET @@session.pseudo_slave_mode = DEFAULT; 17Warnings: 18Warning 1231 Slave applier execution mode not active, statement ineffective. 19SELECT @@session.pseudo_slave_mode; 20@@session.pseudo_slave_mode 210 22'#---------------------FN_DYNVARS_156_02-------------------------#' 23SET pseudo_slave_mode = 1; 24SELECT @@pseudo_slave_mode; 25@@pseudo_slave_mode 261 27SELECT session.pseudo_slave_mode; 28ERROR 42S02: Unknown table 'session' in field list 29SELECT local.pseudo_slave_mode; 30ERROR 42S02: Unknown table 'local' in field list 31SET session pseudo_slave_mode = 0; 32Warnings: 33Warning 1231 Slave applier execution mode not active, statement ineffective. 34SELECT @@session.pseudo_slave_mode; 35@@session.pseudo_slave_mode 360 37'#--------------------FN_DYNVARS_156_03------------------------#' 38SET @@session.pseudo_slave_mode = 0; 39Warnings: 40Warning 1231 'pseudo_slave_mode' change was ineffective. 41SELECT @@session.pseudo_slave_mode; 42@@session.pseudo_slave_mode 430 44SET @@session.pseudo_slave_mode = 1; 45SELECT @@session.pseudo_slave_mode; 46@@session.pseudo_slave_mode 471 48'#--------------------FN_DYNVARS_156_04-------------------------#' 49SET @@session.pseudo_slave_mode = -1; 50ERROR 42000: Variable 'pseudo_slave_mode' can't be set to the value of '-1' 51SET @@session.pseudo_slave_mode = 2; 52ERROR 42000: Variable 'pseudo_slave_mode' can't be set to the value of '2' 53SET @@session.pseudo_slave_mode = "T"; 54ERROR 42000: Variable 'pseudo_slave_mode' can't be set to the value of 'T' 55SET @@session.pseudo_slave_mode = "Y"; 56ERROR 42000: Variable 'pseudo_slave_mode' can't be set to the value of 'Y' 57SET @@session.pseudo_slave_mode = TR�E; 58ERROR 42000: Variable 'pseudo_slave_mode' can't be set to the value of 'TR�E' 59SET @@session.pseudo_slave_mode = �N; 60ERROR 42000: Variable 'pseudo_slave_mode' can't be set to the value of '�N' 61SET @@session.pseudo_slave_mode = OF; 62ERROR 42000: Variable 'pseudo_slave_mode' can't be set to the value of 'OF' 63SET @@session.pseudo_slave_mode = �FF; 64ERROR 42000: Variable 'pseudo_slave_mode' can't be set to the value of '�FF' 65SET @@session.pseudo_slave_mode = '�'; 66ERROR 42000: Variable 'pseudo_slave_mode' can't be set to the value of '�' 67SET @@session.pseudo_slave_mode = NO; 68ERROR 42000: Variable 'pseudo_slave_mode' can't be set to the value of 'NO' 69'#-------------------FN_DYNVARS_156_05----------------------------#' 70SET @@global.pseudo_slave_mode = 0; 71ERROR HY000: Variable 'pseudo_slave_mode' is a SESSION variable and can't be used with SET GLOBAL 72SELECT @@global.pseudo_slave_mode; 73ERROR HY000: Variable 'pseudo_slave_mode' is a SESSION variable 74'#----------------------FN_DYNVARS_156_06------------------------#' 75SELECT count(VARIABLE_VALUE) FROM INFORMATION_SCHEMA.SESSION_VARIABLES WHERE VARIABLE_NAME='pseudo_slave_mode'; 76count(VARIABLE_VALUE) 771 78'#----------------------FN_DYNVARS_156_07------------------------#' 79SELECT IF(@@session.pseudo_slave_mode, "ON", "OFF") = VARIABLE_VALUE 80FROM INFORMATION_SCHEMA.SESSION_VARIABLES 81WHERE VARIABLE_NAME='pseudo_slave_mode'; 82IF(@@session.pseudo_slave_mode, "ON", "OFF") = VARIABLE_VALUE 831 84SELECT @@session.pseudo_slave_mode; 85@@session.pseudo_slave_mode 861 87SELECT VARIABLE_VALUE 88FROM INFORMATION_SCHEMA.SESSION_VARIABLES 89WHERE VARIABLE_NAME='pseudo_slave_mode'; 90VARIABLE_VALUE 91ON 92'#---------------------FN_DYNVARS_156_08-------------------------#' 93SET @@session.pseudo_slave_mode = OFF; 94Warnings: 95Warning 1231 Slave applier execution mode not active, statement ineffective. 96SELECT @@session.pseudo_slave_mode; 97@@session.pseudo_slave_mode 980 99SET @@session.pseudo_slave_mode = ON; 100SELECT @@session.pseudo_slave_mode; 101@@session.pseudo_slave_mode 1021 103'#---------------------FN_DYNVARS_156_09----------------------#' 104SET @@session.pseudo_slave_mode = TRUE; 105SELECT @@session.pseudo_slave_mode; 106@@session.pseudo_slave_mode 1071 108SET @@session.pseudo_slave_mode = FALSE; 109Warnings: 110Warning 1231 Slave applier execution mode not active, statement ineffective. 111SELECT @@session.pseudo_slave_mode; 112@@session.pseudo_slave_mode 1130 114SET @@session.pseudo_slave_mode = @session_start_value; 115Warnings: 116Warning 1231 'pseudo_slave_mode' change was ineffective. 117SELECT @@session.pseudo_slave_mode; 118@@session.pseudo_slave_mode 1190 120