Bug #20114 discard changes does not discard row deletion markers
Submitted: 28 May 2006 18:15 Modified: 20 Dec 2006 10:46
Reporter: Jozsef Marton Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Query Browser Severity:S2 (Serious)
Version:1.1.20 OS:Windows (WinXP SP2)
Assigned to: Mike Lischke CPU Architecture:Any
Tags: Result Set

[28 May 2006 18:15] Jozsef Marton 
Description:
After geting into table editing mode in the resultset viewer (edit button) I select some rows for deletion. Pressing 'Discard changes' does not make QB to forget about the deletion markers: as I press 'edit' again and make some field-edition then apply changes, the rows selected for deletion before are removed from the database table.

How to repeat:
Just start up the QB client and do what is in the description.
[30 May 2006 13:49] MySQL Verification Team 
Thank you for the bug report. Below the server log:

		      1 Query       UPDATE `db7`.`t` SET `name`='ccc' WHERE `id`=6
		      1 Query       DELETE FROM `db7`.`t` WHERE `id`=2
		      1 Query       DELETE FROM `db7`.`t` WHERE `id`=3
		      1 Query       UPDATE `db7`.`t` SET `name`='ccc' WHERE `id`=6
[20 Dec 2006 10:46] Mike Lischke 
Thank you for your bug report. This issue has been committed to our source repository of that product and will be incorporated into the next release.

If necessary, you can access the source repository and build the latest available version, including the bug fix. More information about accessing the source trees is available at

    http://dev.mysql.com/doc/en/installing-source.html