Edit File: innodb_mysql_rbk.test
-- source include/have_innodb.inc # # Bug #41453: Assertion `m_status == DA_ERROR' failed in # Diagnostics_area::sql_errno # CREATE TABLE t1(a INT, b INT NOT NULL, PRIMARY KEY (a)) ENGINE=innodb DEFAULT CHARSET=latin1; INSERT INTO t1 VALUES (1,1),(2,2),(3,3),(4,4),(5,5),(6,6),(7,7); CONNECT (con1,localhost,root,,); CONNECT (con2,localhost,root,,); CONNECTION con1; START TRANSACTION; SELECT * FROM t1 WHERE b=3 LIMIT 1 FOR UPDATE; CONNECTION con2; START TRANSACTION; --error ER_LOCK_WAIT_TIMEOUT UPDATE t1 SET b=b+12 WHERE a > 2 ORDER BY a; ROLLBACK; CONNECTION con1; START TRANSACTION; SELECT * FROM t1 WHERE b=3 LIMIT 1 FOR UPDATE; CONNECTION con2; START TRANSACTION; --error ER_LOCK_WAIT_TIMEOUT UPDATE t1 SET b=10 WHERE a > 1 ORDER BY a; SELECT * FROM t1 WHERE b = 10; CONNECTION default; DISCONNECT con1; DISCONNECT con2; DROP TABLE t1;
Back to File Manager