Debian Codegraph @

mysql-test/suite/rpl/t/rpl_extra_col_slave_minimal.test

raw
1 --source include/have_binlog_format_row.inc
2 --source include/have_innodb.inc
3 --source include/master-slave.inc
4
5 set binlog_row_image=minimal;
6
7 connection slave;
8 stop slave;
9 set global binlog_row_image=minimal;
10 --source include/reset_slave.inc
11
12 create table t1 (
13 a int key, b blob, c char(5),
14 d char(10) as (concat(trim(c), '-U')) unique,
15 e char(10) as (concat('S', b)) stored) engine=innodb;
16
17 connection master;
18 create table t1 (a int primary key, b blob, c char(5)) engine=innodb;
19 reset master;
20
21 connection slave;
22 start slave;
23
24 connection master;
25 set timestamp=unix_timestamp('2010-10-10 10:10:10');
26 insert t1 values (1,'.','Kyle'),(2,'?','JOE'),(3,'!','QA'), (4, '$', '4TH');
27 update t1 set c='UPD' where a=3;
28 update t1 set b='#' where a=2;
29 delete from t1 where a=4;
30 --sorted_result
31 select * from t1;
32 --sorted_result
33 sync_slave_with_master;
34 --sorted_result
35 select * from t1;
36 select d from t1; # no --sorted_result here, this must be KEYREAD, so must be sorted
37 select * from t1 where d='JOE-U';
38
39 connection master;
40 drop table t1;
41 sync_slave_with_master;
42 set global binlog_row_image=full;
43
44 --source include/rpl_end.inc