Debian Codegraph @

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

raw
1 include/master-slave.inc
2 [connection master]
3 create table t1 (n int auto_increment primary key);
4 set insert_id = 2000;
5 insert into t1 values (NULL),(NULL),(NULL);
6 connection slave;
7 select * from t1;
8 n
9 2000
10 2001
11 2002
12 connection master;
13 show slave hosts;
14 Server_id Host Port Master_id
15 2 127.0.0.1 9999 1
16 drop table t1;
17 connection slave;
18 stop slave;
19 include/wait_for_slave_to_stop.inc
20 connection master;
21 create table t2(id int auto_increment primary key, created datetime);
22 SET TIME_ZONE= '+03:00';
23 set timestamp=12345;
24 insert into t2 set created=now();
25 select * from t2;
26 id created
27 1 1970-01-01 06:25:45
28 create table t3 like t2;
29 create temporary table t4 like t2;
30 create table t5 select * from t4;
31 connection slave;
32 start slave;
33 include/wait_for_slave_to_start.inc
34 select * from t2;
35 id created
36 1 1970-01-01 06:25:45
37 show create table t3;
38 Table Create Table
39 t3 CREATE TABLE `t3` (
40 `id` int(11) NOT NULL AUTO_INCREMENT,
41 `created` datetime DEFAULT NULL,
42 PRIMARY KEY (`id`)
43 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
44 show create table t5;
45 Table Create Table
46 t5 CREATE TABLE `t5` (
47 `id` int(11) NOT NULL DEFAULT 0,
48 `created` datetime DEFAULT NULL
49 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
50 connection master;
51 drop table t2,t3,t5;
52 drop temporary table t4;
53 connection slave;
54 include/rpl_end.inc