polardbxengine/mysql-test/suite/innodb/t/index-lock-mode.test

18 lines
374 B
Plaintext

--source include/have_debug.inc
create table t1 (f1 int primary key, f2 int, unique key k1(f2)) engine=innodb;
show create table t1;
insert into t1(f1, f2) values (1, 10);
insert into t1(f1, f2) values (2, 55);
set debug = '+d,idx_mimic_not_committed';
--error ER_DUP_ENTRY
update t1 set f2 = 55 where f1 = 1;
set debug = '-d,idx_mimic_not_committed';
drop table t1;