Debian Codegraph @

mysql-test/suite/innodb/r/lock_impl_to_expl_case_sensitivity.result

raw
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;