Debian Codegraph @

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

raw
1 include/master-slave.inc
2 [connection master]
3 #
4 # Ensure initial CREATE TABLE with partitioned data is replicated
5 # correctly
6 connection master;
7 create table t (a int, b int, key(a)) engine=innodb partition by range (b) (partition p1 values less than (10), partition pn values less than (maxvalue));
8 insert into t values (1,5),(2,100);
9 include/save_master_gtid.inc
10 connection slave;
11 include/sync_with_master_gtid.inc
12 include/diff_tables.inc [master:test.t,slave:test.t]
13 #
14 # Ensure ALTER TABLE .. CONVERT PARTITION .. TO TABLE replicates
15 # correctly
16 connection master;
17 alter table t convert partition p1 to table offspring;
18 include/save_master_gtid.inc
19 connection slave;
20 include/sync_with_master_gtid.inc
21 include/diff_tables.inc [master:test.t,slave:test.t]
22 include/diff_tables.inc [master:test.offspring,slave:test.offspring]
23 #
24 # Ensure data can be inserted into existing table after
25 # ALTER TABLE .. CONVERT PARTITION .. TO TABLE
26 connection master;
27 insert into t values (3, 6);
28 include/save_master_gtid.inc
29 connection slave;
30 include/sync_with_master_gtid.inc
31 include/diff_tables.inc [master:test.t,slave:test.t]
32 #
33 # Ensure data can be inserted into offspring table after
34 # ALTER TABLE .. CONVERT PARTITION .. TO TABLE
35 connection master;
36 insert into offspring values (4, 101);
37 include/save_master_gtid.inc
38 connection slave;
39 include/sync_with_master_gtid.inc
40 include/diff_tables.inc [master:test.offspring,slave:test.offspring]
41 #
42 # Ensure data can be updated in existing table after
43 # ALTER TABLE .. CONVERT PARTITION .. TO TABLE
44 connection master;
45 update t set b=b+1 where a=3;
46 include/save_master_gtid.inc
47 connection slave;
48 include/sync_with_master_gtid.inc
49 include/diff_tables.inc [master:test.t,slave:test.t]
50 #
51 # Ensure data can be updated in offspring table after
52 # ALTER TABLE .. CONVERT PARTITION .. TO TABLE
53 connection master;
54 update offspring set b=b+1 where a=4;
55 include/save_master_gtid.inc
56 connection slave;
57 include/sync_with_master_gtid.inc
58 include/diff_tables.inc [master:test.offspring,slave:test.offspring]
59 #
60 # Ensure data can be deleted in existing table after
61 # ALTER TABLE .. CONVERT PARTITION .. TO TABLE
62 connection master;
63 delete from t;
64 include/save_master_gtid.inc
65 connection slave;
66 include/sync_with_master_gtid.inc
67 include/diff_tables.inc [master:test.t,slave:test.t]
68 #
69 # Ensure data can be deleted in offspring table after
70 # ALTER TABLE .. CONVERT PARTITION .. TO TABLE
71 connection master;
72 delete from offspring;
73 include/save_master_gtid.inc
74 connection slave;
75 include/sync_with_master_gtid.inc
76 include/diff_tables.inc [master:test.offspring,slave:test.offspring]
77 connection master;
78 drop table t, offspring;
79 include/rpl_end.inc
80 # End of rpl_alter_convert_partition