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