Debian Codegraph @

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

raw
1 #
2 # binlog_alter_two_phase system variable
3 # Session as well as global
4 # Allowed values NO_SPLIT, SPLIT, BINLOG_ONLY (0,1,2)
5
6 --source include/not_embedded.inc
7
8 --let $binlog_alter_two_phase= `select @@binlog_alter_two_phase`
9 set binlog_alter_two_phase = OFF;
10 select @@binlog_alter_two_phase;
11
12 set binlog_alter_two_phase = ON;
13 select @@binlog_alter_two_phase;
14
15 --echo # wrong value
16 --error ER_WRONG_VALUE_FOR_VAR
17 set binlog_alter_two_phase=BINLOG_OY;
18 select @@binlog_alter_two_phase;
19
20 --echo #true and false
21 set binlog_alter_two_phase=false;
22 select @@binlog_alter_two_phase;
23
24 set binlog_alter_two_phase=true;
25 select @@binlog_alter_two_phase;
26
27 set binlog_alter_two_phase=0;
28 select @@binlog_alter_two_phase;
29
30 set binlog_alter_two_phase=1;
31 select @@binlog_alter_two_phase;
32
33 --echo ##wrong value
34 --error ER_WRONG_VALUE_FOR_VAR
35 set binlog_alter_two_phase=2;
36 select @@binlog_alter_two_phase;
37
38
39 --echo #Global value
40 set global binlog_alter_two_phase = OFF;
41 connect (con1,localhost,root,,);
42 select @@binlog_alter_two_phase;
43 disconnect con1;
44
45 connection default;
46 set global binlog_alter_two_phase = ON;
47 connect (con1,localhost,root,,);
48 select @@binlog_alter_two_phase;
49 disconnect con1;
50
51 connection default;
52 --eval set global binlog_alter_two_phase=$binlog_alter_two_phase