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