Debian Codegraph @

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

raw
1 --source include/have_innodb.inc
2 --source include/have_binlog_format_mixed_or_statement.inc
3 --let $rpl_topology=1->2->3
4 --source include/rpl_init.inc
5
6 connection server_1;
7
8 create table t1 (id int not null auto_increment primary key, i int) engine=InnoDB;
9 insert into t1 (i) values (-1);
10 insert into t1 (i) values (LAST_INSERT_ID());
11 select * from t1;
12
13 save_master_pos;
14
15 connection server_2;
16
17 sync_with_master;
18 select * from t1;
19 save_master_pos;
20
21 connection server_3;
22
23 sync_with_master;
24 select * from t1;
25
26 connection server_1;
27 drop table t1;
28
29 --source include/rpl_end.inc
30