Invalid deadlock error when updating multiple rows to NULL without a PK
Bug #1372479 reported by
Philip Stoev
This bug affects 1 person
Affects | Status | Importance | Assigned to | Milestone | ||
---|---|---|---|---|---|---|
MySQL patches by Codership | Status tracked in 5.6 | |||||
5.6 |
Confirmed
|
Undecided
|
Unassigned |
Bug Description
This bug was previously filed as
https:/
but Alex thinks that it belongs to Launchpad:
create table t1(value integer) engine=innodb;
insert into t1 values (1), (2);
update t1 set value=NULL;
update t1 set value=NULL;
ERROR 1213 (40001): Deadlock found when trying to get lock; try restarting transaction
drop table t1;
This issue is not reproducible if a primary key is present or if the values being updated to are non-NULL.
To post a comment you must log in.