Debian Codegraph @

mysql-test/suite/parts/r/partition_mdev6067.result

raw
1 CREATE TABLE t1 (a INT PRIMARY KEY, b INT) ENGINE=InnoDB
2 PARTITION BY KEY (a) PARTITIONS 2;
3 INSERT INTO t1 VALUES (1,1);
4 INSERT INTO t1 VALUES (2,2), (3,8);
5 INSERT INTO t1 VALUES (4,16);
6 include/show_binlog_events.inc
7 Log_name Pos Event_type Server_id End_log_pos Info
8 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
9 master-bin.000001 # Query # # use `test`; INSERT INTO t1 VALUES (1,1)
10 master-bin.000001 # Xid # # COMMIT /* XID */
11 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
12 master-bin.000001 # Query # # use `test`; INSERT INTO t1 VALUES (2,2), (3,8)
13 master-bin.000001 # Xid # # COMMIT /* XID */
14 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
15 master-bin.000001 # Query # # use `test`; INSERT INTO t1 VALUES (4,16)
16 master-bin.000001 # Xid # # COMMIT /* XID */
17 DROP TABLE t1;
18 SET binlog_format='row';
19 CREATE TABLE t1 (a INT PRIMARY KEY, b INT) ENGINE=InnoDB
20 PARTITION BY KEY (a) PARTITIONS 2;
21 INSERT INTO t1 VALUES (1,1);
22 INSERT INTO t1 VALUES (2,2), (3,8);
23 INSERT INTO t1 VALUES (4,16);
24 include/show_binlog_events.inc
25 Log_name Pos Event_type Server_id End_log_pos Info
26 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
27 master-bin.000001 # Annotate_rows # # INSERT INTO t1 VALUES (1,1)
28 master-bin.000001 # Table_map # # table_id: # (test.t1)
29 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
30 master-bin.000001 # Xid # # COMMIT /* XID */
31 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
32 master-bin.000001 # Annotate_rows # # INSERT INTO t1 VALUES (2,2), (3,8)
33 master-bin.000001 # Table_map # # table_id: # (test.t1)
34 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
35 master-bin.000001 # Xid # # COMMIT /* XID */
36 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
37 master-bin.000001 # Annotate_rows # # INSERT INTO t1 VALUES (4,16)
38 master-bin.000001 # Table_map # # table_id: # (test.t1)
39 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
40 master-bin.000001 # Xid # # COMMIT /* XID */
41 DROP TABLE t1;