Debian Codegraph @

mysql-test/suite/versioning/r/rpl_stmt.result

raw
1 include/master-slave.inc
2 [connection master]
3 #
4 # MDEV-25347 DML events for auto-partitioned tables are written into binary log twice
5 #
6 flush binary logs;
7 create table t1 (a int) with system versioning
8 partition by system_time limit 1 auto;
9 insert into t1 values (1);
10 update t1 set a= a + 1;
11 update t1 set a= a + 2;
12 show create table t1;
13 Table Create Table
14 t1 CREATE TABLE `t1` (
15 `a` int(11) DEFAULT NULL
16 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci WITH SYSTEM VERSIONING
17 PARTITION BY SYSTEM_TIME LIMIT 1 AUTO
18 PARTITIONS 3
19 select * from t1;
20 a
21 4
22 include/show_binlog_events.inc
23 Log_name Pos Event_type Server_id End_log_pos Info
24 master-bin.000002 # Binlog_checkpoint # # master-bin.000002
25 master-bin.000002 # Gtid # # GTID #-#-#
26 master-bin.000002 # Query # # use `test`; create table t1 (a int) with system versioning
27 partition by system_time limit 1 auto
28 master-bin.000002 # Gtid # # BEGIN GTID #-#-#
29 master-bin.000002 # Query # # use `test`; insert into t1 values (1)
30 master-bin.000002 # Query # # COMMIT
31 master-bin.000002 # Gtid # # BEGIN GTID #-#-#
32 master-bin.000002 # Query # # use `test`; update t1 set a= a + 1
33 master-bin.000002 # Query # # COMMIT
34 master-bin.000002 # Gtid # # BEGIN GTID #-#-#
35 master-bin.000002 # Query # # use `test`; update t1 set a= a + 2
36 master-bin.000002 # Query # # COMMIT
37 connection slave;
38 show create table t1;
39 Table Create Table
40 t1 CREATE TABLE `t1` (
41 `a` int(11) DEFAULT NULL
42 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci WITH SYSTEM VERSIONING
43 PARTITION BY SYSTEM_TIME LIMIT 1 AUTO
44 PARTITIONS 3
45 select * from t1;
46 a
47 4
48 connection master;
49 drop table t1;
50 include/rpl_end.inc