1SELECT @@GLOBAL.binlog_row_image; 2@@GLOBAL.binlog_row_image 3FULL 4SELECT @@SESSION.binlog_row_image; 5@@SESSION.binlog_row_image 6FULL 7FULL Expected 8'#---------------------BS_STVARS_002_01----------------------#' 9SET @start_value= @@global.binlog_row_image; 10SELECT COUNT(@@GLOBAL.binlog_row_image); 11COUNT(@@GLOBAL.binlog_row_image) 121 131 Expected 14SELECT COUNT(@@SESSION.binlog_row_image); 15COUNT(@@SESSION.binlog_row_image) 161 171 Expected 18'#---------------------BS_STVARS_002_02----------------------#' 19SET @@GLOBAL.binlog_row_image=0; 20SELECT @@GLOBAL.binlog_row_image; 21@@GLOBAL.binlog_row_image 22MINIMAL 23MINIMAL Expected 24SET @@SESSION.binlog_row_image=0; 25SELECT @@SESSION.binlog_row_image; 26@@SESSION.binlog_row_image 27MINIMAL 28MINIMAL Expected 29SET @@GLOBAL.binlog_row_image=1; 30SELECT @@GLOBAL.binlog_row_image; 31@@GLOBAL.binlog_row_image 32NOBLOB 33NOBLOB Expected 34SET @@SESSION.binlog_row_image=1; 35SELECT @@SESSION.binlog_row_image; 36@@SESSION.binlog_row_image 37NOBLOB 38NOBLOB Expected 39SET @@GLOBAL.binlog_row_image=2; 40SELECT @@GLOBAL.binlog_row_image; 41@@GLOBAL.binlog_row_image 42FULL 43FULL Expected 44SET @@SESSION.binlog_row_image=2; 45SELECT @@SESSION.binlog_row_image; 46@@SESSION.binlog_row_image 47FULL 48FULL Expected 49'#---------------------BS_STVARS_002_03----------------------#' 50SELECT @@GLOBAL.binlog_row_image = VARIABLE_VALUE 51FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES 52WHERE VARIABLE_NAME='binlog_row_image'; 53@@GLOBAL.binlog_row_image = VARIABLE_VALUE 541 551 Expected 56SELECT COUNT(@@GLOBAL.binlog_row_image); 57COUNT(@@GLOBAL.binlog_row_image) 581 591 Expected 60SELECT COUNT(VARIABLE_VALUE) 61FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES 62WHERE VARIABLE_NAME='binlog_row_image'; 63COUNT(VARIABLE_VALUE) 641 651 Expected 66'#---------------------BS_STVARS_002_04----------------------#' 67SELECT @@SESSION.binlog_row_image = VARIABLE_VALUE 68FROM INFORMATION_SCHEMA.SESSION_VARIABLES 69WHERE VARIABLE_NAME='binlog_row_image'; 70@@SESSION.binlog_row_image = VARIABLE_VALUE 711 721 Expected 73SELECT COUNT(@@SESSION.binlog_row_image); 74COUNT(@@SESSION.binlog_row_image) 751 761 Expected 77SELECT COUNT(VARIABLE_VALUE) 78FROM INFORMATION_SCHEMA.SESSION_VARIABLES 79WHERE VARIABLE_NAME='binlog_row_image'; 80COUNT(VARIABLE_VALUE) 811 821 Expected 83'#---------------------BS_STVARS_002_05----------------------#' 84SELECT COUNT(@@binlog_row_image); 85COUNT(@@binlog_row_image) 861 871 Expected 88SELECT COUNT(@@local.binlog_row_image); 89COUNT(@@local.binlog_row_image) 901 911 Expected 92SELECT COUNT(@@SESSION.binlog_row_image); 93COUNT(@@SESSION.binlog_row_image) 941 951 Expected 96SELECT COUNT(@@GLOBAL.binlog_row_image); 97COUNT(@@GLOBAL.binlog_row_image) 981 991 Expected 100SET @@global.binlog_row_image= @start_value; 101