1
0
mirror of https://github.com/MariaDB/server.git synced 2025-08-08 11:22:35 +03:00
Files
mariadb/mysql-test/suite/rpl/r/last_insert_id.result
2016-03-31 10:11:16 +04:00

23 lines
416 B
Plaintext

include/rpl_init.inc [topology=1->2->3]
connection server_1;
create table t1 (id int not null auto_increment primary key, i int) engine=InnoDB;
insert into t1 (i) values (-1);
insert into t1 (i) values (LAST_INSERT_ID());
select * from t1;
id i
1 -1
2 1
connection server_2;
select * from t1;
id i
1 -1
2 1
connection server_3;
select * from t1;
id i
1 -1
2 1
connection server_1;
drop table t1;
include/rpl_end.inc