MySQL Bugs: #12665: Edit Mode Fails When Not Querying an Entire Table

Bug #12665	Edit Mode Fails When Not Querying an Entire Table
Submitted:	19 Aug 2005 5:06	Modified:	23 Aug 2005 12:58
Reporter:	Josh Martin	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Query Browser	Severity:	S2 (Serious)
Version:	1.1.6	OS:	Windows (Windows XP SP2)
Assigned to:		CPU Architecture:	Any

Description:
The Edit/Apply Changes feature works when I run a query that returns all fields for a table.  In the following query, my user record is returned and I can edit any of the fields and hit Apply - works great.  However, if I change the query to include only some of the fields, or if the query involves multiple tables, I receive an error: "Access violation at address 0035CFC3 in module 'libmysqlx.dll'.  Read of address 00000020."

  EDIT WORKS: select * from user where id = 5
  EDIT DOES NOT WORK: select first_name from user where id = 5

I've tried several different variations and the only thing that seems to work is when an entire, single table is queried.

How to repeat:
See description.

I found a duplicate bug (#8573), but I'm going to leave this open since the other is marked as a low priority.  This is a key functionality when testing (the ability to quickly change data) and I think the #8573 should be escalated.

I tried to reproduce the bug using MQB 1.1.13 on the same OS.
Everything is working as expected if you query a single table as long as the "enforce queries to be editable by adding a primary key columns to the select" option is checked (Tools > Options... > Browser > Query Options).

Try to upgrade your version of MQB since 1.1.6 is a bit old.

Thanks, Thomas.  I upgraded to 1.1.13 and the problem disappeared.  Marking as closed.