Debian Codegraph @

mysql-test/suite/sql_sequence/replication_mixed.result

raw
1 include/master-slave.inc
2 [connection master]
3 #
4 # MDEV-16234
5 # CREATE TABLE .. SELECT LASTVAL is written to binlog as single
6 # statement, causes discrepancy between master and slave
7 #
8 CREATE SEQUENCE s1 ENGINE=InnoDB;
9 SELECT NEXTVAL(s1);
10 NEXTVAL(s1)
11 1
12 CREATE TABLE t1 ENGINE=InnoDB SELECT LASTVAL(s1) AS a;
13 INSERT INTO t1 VALUES (NEXTVAL(s1));
14 INSERT INTO t1 VALUES (LASTVAL(s1));
15 SELECT * FROM t1;
16 a
17 1
18 2
19 2
20 SELECT * from s1;
21 next_not_cached_value minimum_value maximum_value start_value increment cache_size cycle_option cycle_count
22 1001 1 9223372036854775806 1 1 1000 0 0
23 connection slave;
24 SELECT * FROM t1;
25 a
26 1
27 2
28 2
29 SELECT * from s1;
30 next_not_cached_value minimum_value maximum_value start_value increment cache_size cycle_option cycle_count
31 1001 1 9223372036854775806 1 1 1000 0 0
32 connection master;
33 DROP TABLE t1;
34 DROP SEQUENCE s1;
35 include/rpl_end.inc