Debian Codegraph @

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

raw
1
2 CREATE TABLE t1 (a INT) ENGINE = InnoDB PARTITION BY HASH(a);
3 INSERT INTO t1 VALUES (0), (1), (2);
4 START TRANSACTION;
5 UPDATE t1 SET a = 5 WHERE a = 1;
6 connect (con1, localhost, root,,);
7 --echo # Connection con1
8 --echo # InnoDB lock timeout and monitor thread runs every 15 seconds
9 SET innodb_lock_wait_timeout = 20;
10 START TRANSACTION;
11 --error ER_LOCK_WAIT_TIMEOUT
12 UPDATE t1 SET a = 3 WHERE a = 1;
13 COMMIT;
14 disconnect con1;
15 connection default;
16 --echo # Connection default
17 COMMIT;
18 DROP TABLE t1;