Bug #10270 edit function produces illegal syntax
Submitted: 29 Apr 2005 17:42 Modified: 29 Apr 2005 19:53
Reporter: Jens Christian Blix Email Updates:
Status: Can't repeat Impact on me:
None 
Category:MySQL Query Browser Severity:S3 (Non-critical)
Version:1.1.7 OS:Windows (Windows XP Home SP-2 Norwegian)
Assigned to: CPU Architecture:Any

[29 Apr 2005 17:42] Jens Christian Blix 
Description:
When you try to edit the returned results from a select(using the edit button at the bottom), you can not edit the field twice- i.e. enter any value , press enter, and re enter any value and again, press enter.

If you do so, and press the button "Apply Changes" the following error message is displayed: Column '<columnname>' is specified twice. Error no: 1110

How to repeat:
Do any select query. Alter a value anywhere in the result set twice before applying the change.
[29 Apr 2005 19:53] MySQL Verification Team 
I was unable to repeat. Notice that by design you need to have a
primary key in your table.
[29 Jun 2005 1:48] Mark McAulay 
This is a duplicate of http://bugs.mysql.com/bug.php?id=11241 and has been flagged as being fixed by Vladimir Kolesnikov.

The bug was for editing a new row, not an existing one, which is probably why Miguel couldn't repeat it.