Record locking INNODB

[Uwe Hennig]

Hi,

following problem:

start transaction

select client_number from client where client_number = 100 for update

another user send

start transaction

select client_number from client where client_number = 200

and the result is nothing
all selects with any client_number send as result nothing

the result is OK when the first transaction is finished but our application runs with
a lot of users and this problem is very often.

I hope for help

MySQL Version 4.0.20 with INNODB

greeting

Uwe