Debian Codegraph @

mysql-test/suite/sql_sequence/replication_mixed.test

raw
1 --source include/have_innodb.inc
2 --source include/have_binlog_format_mixed.inc
3 --source include/master-slave.inc
4
5 --echo #
6 --echo # MDEV-16234
7 --echo # CREATE TABLE .. SELECT LASTVAL is written to binlog as single
8 --echo # statement, causes discrepancy between master and slave
9 --echo #
10
11 CREATE SEQUENCE s1 ENGINE=InnoDB;
12 --disable_ps2_protocol
13 SELECT NEXTVAL(s1);
14 --enable_ps2_protocol
15 CREATE TABLE t1 ENGINE=InnoDB SELECT LASTVAL(s1) AS a;
16 INSERT INTO t1 VALUES (NEXTVAL(s1));
17 INSERT INTO t1 VALUES (LASTVAL(s1));
18 SELECT * FROM t1;
19 SELECT * from s1;
20 --sync_slave_with_master
21 SELECT * FROM t1;
22 SELECT * from s1;
23
24 # Cleanup
25 --connection master
26 DROP TABLE t1;
27 DROP SEQUENCE s1;
28
29 --source include/rpl_end.inc