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:Microsoft Windows (Win 2000)
Assigned to: Bugs System CPU Architecture:Any

[17 Jul 2003 12:20] [ name withheld ]
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.
[21 Aug 2003 0:46] Jorge del Conde
I was unable to reproduce this.  Can you please send me the structure of the table you encountered this problem in ?
[11 Dec 2003 23:56] [ name withheld ]
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)