| 1 |
SET @innodb_lock_wait_timeout_saved = @@global.innodb_lock_wait_timeout; |
| 2 |
SET @@global.innodb_lock_wait_timeout = 100000; |
| 3 |
CREATE TABLE t1 ( |
| 4 |
id INT PRIMARY KEY, |
| 5 |
val VARCHAR(50) NOT NULL COLLATE utf8mb4_0900_ai_ci, |
| 6 |
KEY(val) |
| 7 |
); |
| 8 |
INSERT INTO t1 (id,val) VALUES (1,"a"), (2,"a"); |
| 9 |
BEGIN; |
| 10 |
UPDATE t1 SET val="A" WHERE id=2; |
| 11 |
SELECT index_name, lock_type, lock_mode, lock_status, lock_data |
| 12 |
FROM performance_schema.data_locks |
| 13 |
WHERE object_schema="test" AND object_name="t1" |
| 14 |
ORDER BY 1, 2, 3, 4, 5; |
| 15 |
index_name lock_type lock_mode lock_status lock_data |
| 16 |
NULL TABLE IX GRANTED NULL |
| 17 |
PRIMARY RECORD X,REC_NOT_GAP GRANTED 2 |
| 18 |
BEGIN; |
| 19 |
SET DEBUG_SYNC = 'lock_wait_will_wait SIGNAL con2_will_wait'; |
| 20 |
SELECT COUNT(1) FROM t1 WHERE val="a" AND CONVERT(val,binary)="A" FOR SHARE; |
| 21 |
SET DEBUG_SYNC = 'now WAIT_FOR con2_will_wait'; |
| 22 |
COMMIT; |
| 23 |
COUNT(1) |
| 24 |
1 |
| 25 |
COMMIT; |
| 26 |
DROP TABLE t1; |
| 27 |
SET @@global.innodb_lock_wait_timeout = @innodb_lock_wait_timeout_saved; |