1SELECT @@GLOBAL.binlog_format; 2@@GLOBAL.binlog_format 3STATEMENT 4'#---------------------BS_STVARS_002_01----------------------#' 5SET @start_value= @@global.binlog_format; 6SELECT COUNT(@@GLOBAL.binlog_format); 7COUNT(@@GLOBAL.binlog_format) 81 91 Expected 10SELECT COUNT(@@SESSION.binlog_format); 11COUNT(@@SESSION.binlog_format) 121 131 Expected 14'#---------------------BS_STVARS_002_02----------------------#' 15SET @@GLOBAL.binlog_format=1; 16SELECT @@GLOBAL.binlog_format; 17@@GLOBAL.binlog_format 18STATEMENT 19SET @@SESSION.binlog_format=1; 20SELECT @@SESSION.binlog_format; 21@@SESSION.binlog_format 22STATEMENT 23'#---------------------BS_STVARS_002_03----------------------#' 24SELECT @@GLOBAL.binlog_format = VARIABLE_VALUE 25FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES 26WHERE VARIABLE_NAME='binlog_format'; 27@@GLOBAL.binlog_format = VARIABLE_VALUE 281 291 Expected 30SELECT COUNT(@@GLOBAL.binlog_format); 31COUNT(@@GLOBAL.binlog_format) 321 331 Expected 34SELECT COUNT(VARIABLE_VALUE) 35FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES 36WHERE VARIABLE_NAME='binlog_format'; 37COUNT(VARIABLE_VALUE) 381 391 Expected 40'#---------------------BS_STVARS_002_04----------------------#' 41SELECT @@SESSION.binlog_format = VARIABLE_VALUE 42FROM INFORMATION_SCHEMA.SESSION_VARIABLES 43WHERE VARIABLE_NAME='binlog_format'; 44@@SESSION.binlog_format = VARIABLE_VALUE 451 461 Expected 47SELECT COUNT(@@SESSION.binlog_format); 48COUNT(@@SESSION.binlog_format) 491 501 Expected 51SELECT COUNT(VARIABLE_VALUE) 52FROM INFORMATION_SCHEMA.SESSION_VARIABLES 53WHERE VARIABLE_NAME='binlog_format'; 54COUNT(VARIABLE_VALUE) 551 561 Expected 57'#---------------------BS_STVARS_002_05----------------------#' 58SELECT COUNT(@@binlog_format); 59COUNT(@@binlog_format) 601 611 Expected 62SELECT COUNT(@@local.binlog_format); 63COUNT(@@local.binlog_format) 641 651 Expected 66SELECT COUNT(@@SESSION.binlog_format); 67COUNT(@@SESSION.binlog_format) 681 691 Expected 70SELECT COUNT(@@GLOBAL.binlog_format); 71COUNT(@@GLOBAL.binlog_format) 721 731 Expected 74SET @@global.binlog_format= @start_value; 75