Debian Codegraph @

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

raw
1 set binlog_alter_two_phase = OFF;
2 select @@binlog_alter_two_phase;
3 @@binlog_alter_two_phase
4 0
5 set binlog_alter_two_phase = ON;
6 select @@binlog_alter_two_phase;
7 @@binlog_alter_two_phase
8 1
9 # wrong value
10 set binlog_alter_two_phase=BINLOG_OY;
11 ERROR 42000: Variable 'binlog_alter_two_phase' can't be set to the value of 'BINLOG_OY'
12 select @@binlog_alter_two_phase;
13 @@binlog_alter_two_phase
14 1
15 #true and false
16 set binlog_alter_two_phase=false;
17 select @@binlog_alter_two_phase;
18 @@binlog_alter_two_phase
19 0
20 set binlog_alter_two_phase=true;
21 select @@binlog_alter_two_phase;
22 @@binlog_alter_two_phase
23 1
24 set binlog_alter_two_phase=0;
25 select @@binlog_alter_two_phase;
26 @@binlog_alter_two_phase
27 0
28 set binlog_alter_two_phase=1;
29 select @@binlog_alter_two_phase;
30 @@binlog_alter_two_phase
31 1
32 ##wrong value
33 set binlog_alter_two_phase=2;
34 ERROR 42000: Variable 'binlog_alter_two_phase' can't be set to the value of '2'
35 select @@binlog_alter_two_phase;
36 @@binlog_alter_two_phase
37 1
38 #Global value
39 set global binlog_alter_two_phase = OFF;
40 connect con1,localhost,root,,;
41 select @@binlog_alter_two_phase;
42 @@binlog_alter_two_phase
43 0
44 disconnect con1;
45 connection default;
46 set global binlog_alter_two_phase = ON;
47 connect con1,localhost,root,,;
48 select @@binlog_alter_two_phase;
49 @@binlog_alter_two_phase
50 1
51 disconnect con1;
52 connection default;
53 set global binlog_alter_two_phase=0;