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