Debian Codegraph @

mysql-test/suite/sys_vars/r/binlog_rows_query_log_events_basic.result

raw
1 SELECT @@GLOBAL.binlog_rows_query_log_events;
2 @@GLOBAL.binlog_rows_query_log_events
3 0
4 '#---------------------BS_STVARS_002_01----------------------#'
5 SET @start_value= @@global.binlog_rows_query_log_events;
6 SELECT COUNT(@@GLOBAL.binlog_rows_query_log_events);
7 COUNT(@@GLOBAL.binlog_rows_query_log_events)
8 1
9 1 Expected
10 SELECT COUNT(@@SESSION.binlog_rows_query_log_events);
11 COUNT(@@SESSION.binlog_rows_query_log_events)
12 1
13 1 Expected
14 '#---------------------BS_STVARS_002_02----------------------#'
15 SET @@GLOBAL.binlog_rows_query_log_events=TRUE;
16 SELECT @@GLOBAL.binlog_rows_query_log_events;
17 @@GLOBAL.binlog_rows_query_log_events
18 1
19 SET @@SESSION.binlog_rows_query_log_events=TRUE;
20 SELECT @@SESSION.binlog_rows_query_log_events;
21 @@SESSION.binlog_rows_query_log_events
22 1
23 '#---------------------BS_STVARS_002_03----------------------#'
24 SELECT
25 IF(@@GLOBAL.binlog_rows_query_log_events, "ON", "OFF") = VARIABLE_VALUE
26 FROM performance_schema.global_variables
27 WHERE VARIABLE_NAME='binlog_rows_query_log_events';
28 IF(@@GLOBAL.binlog_rows_query_log_events, "ON", "OFF") = VARIABLE_VALUE
29 1
30 1 Expected
31 SELECT COUNT(@@GLOBAL.binlog_rows_query_log_events);
32 COUNT(@@GLOBAL.binlog_rows_query_log_events)
33 1
34 1 Expected
35 SELECT COUNT(VARIABLE_VALUE)
36 FROM performance_schema.global_variables
37 WHERE VARIABLE_NAME='binlog_rows_query_log_events';
38 COUNT(VARIABLE_VALUE)
39 1
40 1 Expected
41 '#---------------------BS_STVARS_002_04----------------------#'
42 SELECT
43 IF(@@SESSION.binlog_rows_query_log_events, "ON", "OFF") = VARIABLE_VALUE
44 FROM performance_schema.session_variables
45 WHERE VARIABLE_NAME='binlog_rows_query_log_events';
46 IF(@@SESSION.binlog_rows_query_log_events, "ON", "OFF") = VARIABLE_VALUE
47 1
48 1 Expected
49 SELECT COUNT(@@SESSION.binlog_rows_query_log_events);
50 COUNT(@@SESSION.binlog_rows_query_log_events)
51 1
52 1 Expected
53 SELECT COUNT(VARIABLE_VALUE)
54 FROM performance_schema.session_variables
55 WHERE VARIABLE_NAME='binlog_rows_query_log_events';
56 COUNT(VARIABLE_VALUE)
57 1
58 1 Expected
59 '#---------------------BS_STVARS_002_05----------------------#'
60 SELECT COUNT(@@binlog_rows_query_log_events);
61 COUNT(@@binlog_rows_query_log_events)
62 1
63 1 Expected
64 SELECT COUNT(@@local.binlog_rows_query_log_events);
65 COUNT(@@local.binlog_rows_query_log_events)
66 1
67 1 Expected
68 SELECT COUNT(@@SESSION.binlog_rows_query_log_events);
69 COUNT(@@SESSION.binlog_rows_query_log_events)
70 1
71 1 Expected
72 SELECT COUNT(@@GLOBAL.binlog_rows_query_log_events);
73 COUNT(@@GLOBAL.binlog_rows_query_log_events)
74 1
75 1 Expected
76 SET @@global.binlog_rows_query_log_events= @start_value;