Rafa,
- Original Message -
From: <[EMAIL PROTECTED]>
Newsgroups: mailing.database.mysql
Sent: Tuesday, November 05, 2002 11:00 AM
Subject: DeadLock bug using mysql/Innodb
> Description:
> Hi Heikki,
>
> In your case:
>
> >CREATE TABLE t (a INT NOT NULL, PRI
Description:
Hi Heikki,
In your case:
>CREATE TABLE t (a INT NOT NULL, PRIMARY KEY (a)) TYPE = INNODB;
>INSERT INTO t VALUES (90); INSERT INTO t VALUES (110);
>User 1:
>SELECT * FROM t WHERE a >= 100 FOR UPDATE;
>User 2:
>SELECT * FROM t WHERE a >= 100 FOR UPDATE;
>
>Now if user 1 tries to
Rafa,
- Original Message -
From: <[EMAIL PROTECTED]>
Newsgroups: mailing.database.mysql
Sent: Monday, November 04, 2002 6:06 PM
Subject: DeadLock bug using mysql/Innodb
> Description:
> Hello,
>
> I have a deadlock problem when I try to execute some update sentences
Description:
Hello,
I have a deadlock problem when I try to execute some update sentences
using 'Lock For Update'.
I need to create a new document which is identified by a unique number,
which is stored in the field 'Ped' of the table 'Pedidos'.
To obtain a new document number I add 1 to the co