1SET @session_start_value = @@session.sql_log_bin; 2SELECT @session_start_value; 3@session_start_value 41 5'#--------------------FN_DYNVARS_156_01------------------------#' 6SET @@session.sql_log_bin = 0; 7SET @@session.sql_log_bin = DEFAULT; 8SELECT @@session.sql_log_bin; 9@@session.sql_log_bin 101 11SET @@session.sql_log_bin = 1; 12SET @@session.sql_log_bin = DEFAULT; 13SELECT @@session.sql_log_bin; 14@@session.sql_log_bin 151 16'#---------------------FN_DYNVARS_156_02-------------------------#' 17SET sql_log_bin = 1; 18SELECT @@sql_log_bin; 19@@sql_log_bin 201 21SELECT session.sql_log_bin; 22ERROR 42S02: Unknown table 'session' in field list 23SELECT local.sql_log_bin; 24ERROR 42S02: Unknown table 'local' in field list 25SET session sql_log_bin = 0; 26SELECT @@session.sql_log_bin; 27@@session.sql_log_bin 280 29'#--------------------FN_DYNVARS_156_03------------------------#' 30SET @@session.sql_log_bin = 0; 31SELECT @@session.sql_log_bin; 32@@session.sql_log_bin 330 34SET @@session.sql_log_bin = 1; 35SELECT @@session.sql_log_bin; 36@@session.sql_log_bin 371 38'#--------------------FN_DYNVARS_156_04-------------------------#' 39SET @@session.sql_log_bin = -1; 40ERROR 42000: Variable 'sql_log_bin' can't be set to the value of '-1' 41SET @@session.sql_log_bin = 2; 42ERROR 42000: Variable 'sql_log_bin' can't be set to the value of '2' 43SET @@session.sql_log_bin = "T"; 44ERROR 42000: Variable 'sql_log_bin' can't be set to the value of 'T' 45SET @@session.sql_log_bin = "Y"; 46ERROR 42000: Variable 'sql_log_bin' can't be set to the value of 'Y' 47SET @@session.sql_log_bin = TR�E; 48ERROR 42000: Variable 'sql_log_bin' can't be set to the value of 'TR�E' 49SET @@session.sql_log_bin = �N; 50ERROR 42000: Variable 'sql_log_bin' can't be set to the value of '�N' 51SET @@session.sql_log_bin = OF; 52ERROR 42000: Variable 'sql_log_bin' can't be set to the value of 'OF' 53SET @@session.sql_log_bin = �FF; 54ERROR 42000: Variable 'sql_log_bin' can't be set to the value of '�FF' 55SET @@session.sql_log_bin = '�'; 56ERROR 42000: Variable 'sql_log_bin' can't be set to the value of '�' 57SET @@session.sql_log_bin = NO; 58ERROR 42000: Variable 'sql_log_bin' can't be set to the value of 'NO' 59'#-------------------FN_DYNVARS_156_05----------------------------#' 60SELECT @@global.sql_log_bin; 61@@global.sql_log_bin 621 63Warnings: 64Warning 1287 '@@global.sql_log_bin' is deprecated and will be removed in a future release. Please use the constant 1 (since @@global.sql_log_bin is always equal to 1) instead 65SET @@global.sql_log_bin = 0; 66ERROR 42000: Variable 'sql_log_bin' can't be set to the value of '0' 67SELECT @@global.sql_log_bin; 68@@global.sql_log_bin 691 70Warnings: 71Warning 1287 '@@global.sql_log_bin' is deprecated and will be removed in a future release. Please use the constant 1 (since @@global.sql_log_bin is always equal to 1) instead 72SET @@global.sql_log_bin = 1; 73ERROR 42000: Variable 'sql_log_bin' can't be set to the value of '1' 74'#----------------------FN_DYNVARS_156_06------------------------#' 75SELECT count(VARIABLE_VALUE) FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES WHERE VARIABLE_NAME='sql_log_bin'; 76count(VARIABLE_VALUE) 771 78'#----------------------FN_DYNVARS_156_07------------------------#' 79SELECT IF(@@session.sql_log_bin, "ON", "OFF") = VARIABLE_VALUE 80FROM INFORMATION_SCHEMA.SESSION_VARIABLES 81WHERE VARIABLE_NAME='sql_log_bin'; 82IF(@@session.sql_log_bin, "ON", "OFF") = VARIABLE_VALUE 831 84SELECT @@session.sql_log_bin; 85@@session.sql_log_bin 861 87SELECT VARIABLE_VALUE 88FROM INFORMATION_SCHEMA.SESSION_VARIABLES 89WHERE VARIABLE_NAME='sql_log_bin'; 90VARIABLE_VALUE 91ON 92'#---------------------FN_DYNVARS_156_08-------------------------#' 93SET @@session.sql_log_bin = OFF; 94SELECT @@session.sql_log_bin; 95@@session.sql_log_bin 960 97SET @@session.sql_log_bin = ON; 98SELECT @@session.sql_log_bin; 99@@session.sql_log_bin 1001 101'#---------------------FN_DYNVARS_156_09----------------------#' 102SET @@session.sql_log_bin = TRUE; 103SELECT @@session.sql_log_bin; 104@@session.sql_log_bin 1051 106SET @@session.sql_log_bin = FALSE; 107SELECT @@session.sql_log_bin; 108@@session.sql_log_bin 1090 110SET @@session.sql_log_bin = @session_start_value; 111SELECT @@session.sql_log_bin; 112@@session.sql_log_bin 1131 114