Debian Codegraph @

mysql-test/suite/sys_vars/t/binlog_annotate_row_events_basic.test

raw
1 # bool session
2
3 SET @start_global_value = @@global.binlog_annotate_row_events;
4
5 select @@global.binlog_annotate_row_events;
6 select @@session.binlog_annotate_row_events;
7 show global variables like 'binlog_annotate_row_events';
8 show session variables like 'binlog_annotate_row_events';
9 select * from information_schema.global_variables where variable_name='binlog_annotate_row_events';
10 select * from information_schema.session_variables where variable_name='binlog_annotate_row_events';
11
12 #
13 # show that it's writable
14 #
15 set global binlog_annotate_row_events=ON;
16 select @@global.binlog_annotate_row_events;
17 set global binlog_annotate_row_events=OFF;
18 select @@global.binlog_annotate_row_events;
19 set global binlog_annotate_row_events=1;
20 select @@global.binlog_annotate_row_events;
21
22 set session binlog_annotate_row_events=ON;
23 select @@session.binlog_annotate_row_events;
24 set session binlog_annotate_row_events=OFF;
25 select @@session.binlog_annotate_row_events;
26 set session binlog_annotate_row_events=1;
27 select @@session.binlog_annotate_row_events;
28 #
29 # incorrect types
30 #
31 --error ER_WRONG_TYPE_FOR_VAR
32 set global binlog_annotate_row_events=1.1;
33 --error ER_WRONG_TYPE_FOR_VAR
34 set session binlog_annotate_row_events=1e1;
35 --error ER_WRONG_VALUE_FOR_VAR
36 set session binlog_annotate_row_events="foo";
37
38 SET @@global.binlog_annotate_row_events = @start_global_value;
39