Using PHP 4.2.3 with MySQL 3.23.52

Report:
-------
- Table has 2 keys: 'account' as PRIMARY and 'id' as unique
- I make an SQL update on an existing a record with id="anid" setting
id="anotherid" but another record exists with id ="anotherid"
- The update is performed and the record already existing with
id="anotherid" is deleted!!!

Expected behavior:
------------------
- Update failed with "Duplicate key attempt message"
I guess it's a bug, isn't it?

The workaround is very easy but I really guess the behavior is weird.

Greetings from France,
JM


---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Reply via email to