Debian Codegraph @

mysql-test/suite/rpl/r/rpl_extra_col_slave_minimal.result

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