Debian Codegraph @

mysql-test/suite/parts/t/partition_mdev6067.test

raw
1 --source include/have_innodb.inc
2 --source include/have_partition.inc
3 --source include/have_binlog_format_statement.inc
4
5 # Test binlogging of some transactions on a partitioned InnoDB table.
6 # The bug was seen as one of the inserts being logged with a COMMIT query
7 # event instead of the correct XID event.
8
9 CREATE TABLE t1 (a INT PRIMARY KEY, b INT) ENGINE=InnoDB
10 PARTITION BY KEY (a) PARTITIONS 2;
11 --let $binlog_file= query_get_value(SHOW MASTER STATUS, File, 1)
12 --let $binlog_start= query_get_value(SHOW MASTER STATUS, Position, 1)
13 INSERT INTO t1 VALUES (1,1);
14 INSERT INTO t1 VALUES (2,2), (3,8);
15 INSERT INTO t1 VALUES (4,16);
16
17 --source include/show_binlog_events.inc
18
19 # Same thing in row mode.
20 DROP TABLE t1;
21 SET binlog_format='row';
22 CREATE TABLE t1 (a INT PRIMARY KEY, b INT) ENGINE=InnoDB
23 PARTITION BY KEY (a) PARTITIONS 2;
24 --let $binlog_file= query_get_value(SHOW MASTER STATUS, File, 1)
25 --let $binlog_start= query_get_value(SHOW MASTER STATUS, Position, 1)
26 INSERT INTO t1 VALUES (1,1);
27 INSERT INTO t1 VALUES (2,2), (3,8);
28 INSERT INTO t1 VALUES (4,16);
29
30 --source include/show_binlog_events.inc
31
32 DROP TABLE t1;