Debian Codegraph @

mysql-test/suite/rpl/include/start_alter_basic.inc

raw
1 #
2 # Run start alter basic tests (CA/RA with given engine)
3 # Params:-
4 # $engine
5 # $sync_slave
6 # master_node and slave_node connection should be defined
7
8 --echo # $engine
9 --connection master_node
10 --eval create table t1(a int, b int) engine=$engine;
11 insert into t1 values(1,1);
12 insert into t1 values(2,2);
13 --echo # Normal Alter
14 alter table t1 add column c int;
15 show create table t1;
16 --echo # Failed Alter
17 insert into t1 values(1,1, NULL);
18 --error ER_DUP_ENTRY
19 alter table t1 change a a int unique;
20 set @@session.binlog_alter_two_phase = 0;
21 alter table t1 change a a int;
22 set @@session.binlog_alter_two_phase = 1;
23 alter table t1 change a a int;
24 show create table t1;
25
26 # The following restriction should be removed post MDEV-26005 fix.
27 # TODO MDEV-26130 , should be removed after fixing
28 #if ($engine != 'aria')
29 #{
30 #--eval create temporary table tmp_tbl(a int, b int) engine=$engine;
31 #insert into tmp_tbl values(1,1);
32 #insert into tmp_tbl values(2,2);
33 #--echo # Normal Alter
34 #alter table tmp_tbl add column c int;
35 #--echo # Failed Alter
36 #insert into tmp_tbl values(1,1, NULL);
37 #--error ER_DUP_ENTRY
38 #alter table tmp_tbl change a a int unique ;
39 #show create table tmp_tbl;
40 #}
41 if ($sync_slave)
42 {
43 --source include/save_master_gtid.inc
44 --connection slave_node
45 --source include/sync_with_master_gtid.inc
46 show create table t1;
47 }
48
49 --connection master_node
50 drop table t1;
51 #if ($engine != 'aria')
52 #{
53 #drop temporary table tmp_tbl;
54 #}
55 if ($sync_slave)
56 {
57 --source include/save_master_gtid.inc
58 --connection slave_node
59 --source include/sync_with_master_gtid.inc
60 }