1SELECT @@GLOBAL.binlog_rows_query_log_events; 2@@GLOBAL.binlog_rows_query_log_events 30 4'#---------------------BS_STVARS_002_01----------------------#' 5SET @start_value= @@global.binlog_rows_query_log_events; 6SELECT COUNT(@@GLOBAL.binlog_rows_query_log_events); 7COUNT(@@GLOBAL.binlog_rows_query_log_events) 81 91 Expected 10SELECT COUNT(@@SESSION.binlog_rows_query_log_events); 11COUNT(@@SESSION.binlog_rows_query_log_events) 121 131 Expected 14'#---------------------BS_STVARS_002_02----------------------#' 15SET @@GLOBAL.binlog_rows_query_log_events=TRUE; 16SELECT @@GLOBAL.binlog_rows_query_log_events; 17@@GLOBAL.binlog_rows_query_log_events 181 19SET @@SESSION.binlog_rows_query_log_events=TRUE; 20SELECT @@SESSION.binlog_rows_query_log_events; 21@@SESSION.binlog_rows_query_log_events 221 23'#---------------------BS_STVARS_002_03----------------------#' 24SELECT 25IF(@@GLOBAL.binlog_rows_query_log_events, "ON", "OFF") = VARIABLE_VALUE 26FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES 27WHERE VARIABLE_NAME='binlog_rows_query_log_events'; 28IF(@@GLOBAL.binlog_rows_query_log_events, "ON", "OFF") = VARIABLE_VALUE 291 301 Expected 31SELECT COUNT(@@GLOBAL.binlog_rows_query_log_events); 32COUNT(@@GLOBAL.binlog_rows_query_log_events) 331 341 Expected 35SELECT COUNT(VARIABLE_VALUE) 36FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES 37WHERE VARIABLE_NAME='binlog_rows_query_log_events'; 38COUNT(VARIABLE_VALUE) 391 401 Expected 41'#---------------------BS_STVARS_002_04----------------------#' 42SELECT 43IF(@@SESSION.binlog_rows_query_log_events, "ON", "OFF") = VARIABLE_VALUE 44FROM INFORMATION_SCHEMA.SESSION_VARIABLES 45WHERE VARIABLE_NAME='binlog_rows_query_log_events'; 46IF(@@SESSION.binlog_rows_query_log_events, "ON", "OFF") = VARIABLE_VALUE 471 481 Expected 49SELECT COUNT(@@SESSION.binlog_rows_query_log_events); 50COUNT(@@SESSION.binlog_rows_query_log_events) 511 521 Expected 53SELECT COUNT(VARIABLE_VALUE) 54FROM INFORMATION_SCHEMA.SESSION_VARIABLES 55WHERE VARIABLE_NAME='binlog_rows_query_log_events'; 56COUNT(VARIABLE_VALUE) 571 581 Expected 59'#---------------------BS_STVARS_002_05----------------------#' 60SELECT COUNT(@@binlog_rows_query_log_events); 61COUNT(@@binlog_rows_query_log_events) 621 631 Expected 64SELECT COUNT(@@local.binlog_rows_query_log_events); 65COUNT(@@local.binlog_rows_query_log_events) 661 671 Expected 68SELECT COUNT(@@SESSION.binlog_rows_query_log_events); 69COUNT(@@SESSION.binlog_rows_query_log_events) 701 711 Expected 72SELECT COUNT(@@GLOBAL.binlog_rows_query_log_events); 73COUNT(@@GLOBAL.binlog_rows_query_log_events) 741 751 Expected 76SET @@global.binlog_rows_query_log_events= @start_value; 77