Debian Codegraph @

mysql-test/suite/binlog/t/binlog_innodb_row_myisam.test

raw
1 #
2 # Tests of innodb/binlog with the row binlog format
3 #
4 source include/force_myisam_default.inc;
5 source include/have_myisam.inc;
6 source include/have_log_bin.inc;
7 source include/have_binlog_format_row.inc;
8
9 --echo #
10 --echo # Bug#12346411 SQL/LOG.CC:6509: ASSERTION `PREPARED_XIDS > 0' FAILED
11 --echo #
12
13 CREATE TABLE t1(a INT PRIMARY KEY) engine=innodb;
14 CREATE TABLE t2(a INT) engine=myisam;
15
16 INSERT INTO t1 VALUES (1);
17 START TRANSACTION;
18 INSERT INTO t2 VALUES (1);
19 INSERT IGNORE INTO t1 VALUES (1);
20 COMMIT;
21
22 INSERT INTO t1 VALUES (2);
23 START TRANSACTION;
24 INSERT INTO t2 VALUES (2);
25 UPDATE IGNORE t1 SET a=1 WHERE a=2;
26 COMMIT;
27
28 DROP TABLE t1, t2;