MySQL Bugs: #4995: Updating rows in grid with restricted table

Bug #4995	Updating rows in grid with restricted table
Submitted:	11 Aug 2004 17:06	Modified:	16 Aug 2004 13:39
Reporter:	Chris Munasinha	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Query Browser	Severity:	S2 (Serious)
Version:	1.0.5 alpha	OS:	Windows (Win2K SP4)
Assigned to:		CPU Architecture:	Any

Description:
Cannot update row(s) using Edit/Apply Changes when a single table query is restricted with a WHERE. Results in "Error: NO PKS FOUND! aborting..." followed by an abnormal program termination. This seems to happen independent of any column type or value and with any number of rows returned with one or more rows/columns changed.

How to repeat:
 - Retrieve rows using "SELECT * FROM <table> WHERE <any column>=<any value>"
 - Select Edit mode
 - Change any row value(s) and click Apply Changes

Suggested fix:
If updates are not intended in this manner then the program should at least not fall over. Otherwise perhaps allow edits on 'simple' queries like SQL Server Enterprise manager does.

I got some different error message(s) but the end result was the same, the program crashed.  I 
got an assertion failure in myx_recordset.c: line 462.

I used our world database.

select * from world.city where district='new york';
-- click on edit button
-- change new york to new york city
-- click apply
-- crash

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 bugfix, yourself. More information 
about accessing the source trees is available at
    http://www.mysql.com/doc/en/Installing_source_tree.html