Re: Innodb Lock bug with select for update ?

[Christophe Fondacci]

My initial "real" case used an index and the problem occurs.
I have simplified my test case to the minimal operations needed to reproduce.

However, I made a try with :
alter table lck add primary key (id)
;

and re-run the test case.
=> Exact same lock behaviour.

My workaround so far :
First simple select on the table (without the for update clause)
Only select for update if the first select returned a row.

Any other idea?
Thanks
Christophe.