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