15 messages in com.mysql.lists.win32RE: MySql bug?
FromSent OnAttachments
Andrea16 Sep 2003 23:29 
Andrea16 Sep 2003 23:50 
Larr...@contractor.amat.com16 Sep 2003 23:55 
Andrea17 Sep 2003 00:10 
Larr...@contractor.amat.com17 Sep 2003 00:16 
Andrea17 Sep 2003 00:26 
Larr...@contractor.amat.com17 Sep 2003 00:28 
Larr...@contractor.amat.com17 Sep 2003 00:44 
Andrea17 Sep 2003 01:13 
PF: MySQL17 Sep 2003 06:32 
Andrea17 Sep 2003 07:43 
Mark Matthews17 Sep 2003 08:04 
PF: MySQL17 Sep 2003 08:09 
Paul DuBois17 Sep 2003 09:05 
Andrea17 Sep 2003 23:06 
Subject:RE: MySql bug?
From:PF: MySQL (ml.m@in-genius.com)
Date:09/17/2003 06:32:47 AM
List:com.mysql.lists.win32

UPDATE Prova SET Prog=Prog*-1 WHERE Gruppo=16 AND Prog>=1; UPDATE Prova SET Prog=ABS(Prog)+1 WHERE Gruppo=16 AND ABS(Prog)>=1;

This solve the problem but I continue to think that all this is a MySql bug or a MySql important malfunction!

It makes sense to me. Not a bug. The first record that is updated, creates a duplicate primary key, thus cannot be completed.

Generally, you don't do these types of operations on primary keys.

-Kevin