mysql-test/suite/innodb/t/index-lock-mode.test
raw| 1 | --source include/have_debug.inc |
| 2 | |
| 3 | create table t1 (f1 int primary key, f2 int, unique key k1(f2)) engine=innodb; |
| 4 | show create table t1; |
| 5 | |
| 6 | insert into t1(f1, f2) values (1, 10); |
| 7 | insert into t1(f1, f2) values (2, 55); |
| 8 | |
| 9 | set debug = '+d,idx_mimic_not_committed'; |
| 10 | |
| 11 | --error ER_DUP_ENTRY |
| 12 | update t1 set f2 = 55 where f1 = 1; |
| 13 | |
| 14 | set debug = '-d,idx_mimic_not_committed'; |
| 15 | |
| 16 | drop table t1; |
| 17 |