Debian Codegraph @

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

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