Re: Innodb Lock bug with select for update ?
I am making a guess.
If you select for updata a row, lets say value 100, if the row does not exist, it still need to to make sure that other transaction does not insert value 100 into the table. So, it proabably has to lock the gap before and after the value 100. If the table is empty, then there is no gap to work with, so have to lock the whole table.
Subject
Views
Written By
Posted
5354
July 08, 2008 03:21AM
2012
July 08, 2008 04:30AM
2193
July 08, 2008 06:11AM
Re: Innodb Lock bug with select for update ?
2286
July 08, 2008 09:00AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.