MySQL Forums
Forum List  »  InnoDB

Re: lock on row, so that select brings up no result
Posted by: Jürgen Rehkemper
Date: May 26, 2008 07:21AM

Hi Eric,

that was one of my first ideas and i found that in the manual too. But when i test it, a second user can do a select and gets a result anyway. This is how i tried:
user A
begin;
select * from tbl_kunde where kdnr=20 for update;

user B
select * from tbl_kunde where kdnr=20;

At this moment B gets a result although A didn't finish with commit.

I also tried several isolation levels, but didn't get the wanted result.

Any further ideas?

Jürgen

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: lock on row, so that select brings up no result
2650
May 26, 2008 07:21AM


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.