Debian Codegraph @

mysql-test/suite/innodb/t/innodb_mysql_rbk.test

raw
1 --source include/have_innodb.inc
2
3 --disable_query_log
4 call mtr.add_suppression("InnoDB: Transaction was aborted due to ");
5 --enable_query_log
6
7 #
8 # Bug #41453: Assertion `m_status == DA_ERROR' failed in
9 # Diagnostics_area::sql_errno
10 #
11
12 CREATE TABLE t1(a INT, b INT NOT NULL, PRIMARY KEY (a)) ENGINE=innodb
13 DEFAULT CHARSET=latin1;
14 INSERT INTO t1 VALUES (1,1),(2,2),(3,3),(4,4),(5,5),(6,6),(7,7);
15 CONNECT (con1,localhost,root,,);
16 CONNECT (con2,localhost,root,,);
17
18 CONNECTION con1;
19 START TRANSACTION;
20 SELECT * FROM t1 WHERE b=3 LIMIT 1 FOR UPDATE;
21 CONNECTION con2;
22 START TRANSACTION;
23 --error ER_LOCK_WAIT_TIMEOUT
24 UPDATE t1 SET b=b+12 WHERE a > 2 ORDER BY a;
25 ROLLBACK;
26
27 CONNECTION con1;
28 START TRANSACTION;
29 SELECT * FROM t1 WHERE b=3 LIMIT 1 FOR UPDATE;
30 CONNECTION con2;
31 START TRANSACTION;
32 --error ER_LOCK_WAIT_TIMEOUT
33 UPDATE t1 SET b=10 WHERE a > 1 ORDER BY a;
34 SELECT * FROM t1 WHERE b = 10;
35
36 CONNECTION default;
37 DISCONNECT con1;
38 DISCONNECT con2;
39 DROP TABLE t1;