Debian Codegraph @

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

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