MySql bug?

"Andrea" <[email protected]> Wed, 17 Sep 2003 08:29:25 +0200

Newsgroups	gmane.comp.db.mysql.bugs
Message-ID	<[email protected]>

Hi.

In MySql I create this table:

CREATE TABLE `prova` (
  `Gruppo` int(11) NOT NULL default '0',
  `Prog` int(11) NOT NULL default '0',
  `Descrizione` varchar(100) default '',
  PRIMARY KEY  (`Gruppo`, `Prog`)
) TYPE=MyISAM;

Running this:
UPDATE Prog SET Prog=Prog+1 WHERE Gruppo=16 AND Prog>=1

I get "Duplicate entry".

Is this a MySql bug? How can I do this?

Tnx, bye.




-- 
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe:    http://lists.mysql.com/[email protected]