MySQL Bugs: #867: MySQL Control Center double row delete

Bug #867	MySQL Control Center double row delete
Submitted:	17 Jul 2003 12:20	Modified:	21 Aug 2003 16:18
Reporter:	[ name withheld ]	Email Updates:
Status:	Can't repeat	Impact on me:	None
Category:	MySQLCC	Severity:	S2 (Serious)
Version:	0.9.2-beta	OS:	Windows (Win 2000)
Assigned to:	Bugs System	CPU Architecture:	Any

Description:
When deleting a row from a result set, the program deletes the intended row and an additional row.

How to repeat:
1) Create a query that display two or more rows.
2) Select a row from the result set.
3) Press the DELETE key.

The program deletes the selected row and the last row in the result set.

Suggested fix:
Make it only delete the selected row.

I was unable to reproduce this.  Can you please send me the structure of the table you encountered this problem in ?

To reproduce this error, use the following table
mysql> explain Users;
+-----------+-------------+------+-----+---------+----------------+
| Field     | Type        | Null | Key | Default | Extra          |
+-----------+-------------+------+-----+---------+----------------+
| id        | int(11)     |      | PRI | NULL    | auto_increment |
| username  | varchar(15) | YES  | MUL | NULL    |                |
| password  | varchar(15) | YES  |     | NULL    |                |
| name      | varchar(50) | YES  |     | NULL    |                |
| email     | varchar(50) | YES  |     | NULL    |                |
| ipmask    | varchar(15) | YES  |     | NULL    |                |
| siteAdmin | tinyint(4)  |      |     | 0       |                |
| session   | varchar(32) | YES  |     |         |                |
+-----------+-------------+------+-----+---------+----------------+
This is a MyISAM table

Insert five rows using mysqlcc by double-clicking the table name to open the table view screen and then right-clicking on the display as select 'insert record'
Once you have five records displayed, left-click on row number three to hilight it and then press the DELETE key.
I have noticed that when the DELETE key is pressed and the dialog pops-up to confirm the delete action, one of the cells on an apparently random row and column will be hilighted.  The selected row, and this row that the randomly hilighted cell appears on will be the rows deleted.

I have just reproduced this error in 0.9.3 beta
mysql  Ver 11.18 Distrib 3.23.58, for redhat-linux-gnu (i386)