Debian Codegraph @

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

raw
1 SET @start_global_value = @@global.binlog_annotate_row_events;
2 select @@global.binlog_annotate_row_events;
3 @@global.binlog_annotate_row_events
4 1
5 select @@session.binlog_annotate_row_events;
6 @@session.binlog_annotate_row_events
7 1
8 show global variables like 'binlog_annotate_row_events';
9 Variable_name Value
10 binlog_annotate_row_events ON
11 show session variables like 'binlog_annotate_row_events';
12 Variable_name Value
13 binlog_annotate_row_events ON
14 select * from information_schema.global_variables where variable_name='binlog_annotate_row_events';
15 VARIABLE_NAME VARIABLE_VALUE
16 BINLOG_ANNOTATE_ROW_EVENTS ON
17 select * from information_schema.session_variables where variable_name='binlog_annotate_row_events';
18 VARIABLE_NAME VARIABLE_VALUE
19 BINLOG_ANNOTATE_ROW_EVENTS ON
20 set global binlog_annotate_row_events=ON;
21 select @@global.binlog_annotate_row_events;
22 @@global.binlog_annotate_row_events
23 1
24 set global binlog_annotate_row_events=OFF;
25 select @@global.binlog_annotate_row_events;
26 @@global.binlog_annotate_row_events
27 0
28 set global binlog_annotate_row_events=1;
29 select @@global.binlog_annotate_row_events;
30 @@global.binlog_annotate_row_events
31 1
32 set session binlog_annotate_row_events=ON;
33 select @@session.binlog_annotate_row_events;
34 @@session.binlog_annotate_row_events
35 1
36 set session binlog_annotate_row_events=OFF;
37 select @@session.binlog_annotate_row_events;
38 @@session.binlog_annotate_row_events
39 0
40 set session binlog_annotate_row_events=1;
41 select @@session.binlog_annotate_row_events;
42 @@session.binlog_annotate_row_events
43 1
44 set global binlog_annotate_row_events=1.1;
45 ERROR 42000: Incorrect argument type to variable 'binlog_annotate_row_events'
46 set session binlog_annotate_row_events=1e1;
47 ERROR 42000: Incorrect argument type to variable 'binlog_annotate_row_events'
48 set session binlog_annotate_row_events="foo";
49 ERROR 42000: Variable 'binlog_annotate_row_events' can't be set to the value of 'foo'
50 SET @@global.binlog_annotate_row_events = @start_global_value;