MySQL Bugs: #7444: access violation in MySQL Query Browser

Bug #7444	access violation in MySQL Query Browser
Submitted:	20 Dec 2004 21:36	Modified:	14 Apr 2005 22:50
Reporter:	Dave Sowers	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Query Browser	Severity:	S2 (Serious)
Version:	1.1.4	OS:	Windows (Windows 2000)
Assigned to:	Alfredo Kojima	CPU Architecture:	Any

Description:
looks like this is repeatable.

Use selected columns instead of * and try to edit a field of the record.  When you try to apply changes is when I get the error.

perhaps it does not have the field it needs to update when there is a change

How to repeat:
create 2 column table

keyid int autoincrement
 name varchar

add some records

select only the name field in the query

edit a record and try to apply changes

I get an error even if I have selected all fields of the record

i.e.  select key,name from table t  (apply changes gets the error)

 select * from table t (apply changes works just fine)

also.  once you have received the access violation you must close and reopen MySQL Query Browser

I work on XP Home and get the same behaviour when trying to do the described things. Version of QB is 1.1.4

Thanks for reporting.

I was able to repeat with 

DROP TABLE IF EXISTS `test`.`bug7444`;
CREATE TABLE `bug7444` (
  `keyid` int(10) unsigned NOT NULL auto_increment,
  `name` varchar(45) NOT NULL default '',
  PRIMARY KEY  (`keyid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

The first select works

SELECT b.name FROM bug7444 b

If you do not use the alias, it raises the AV.

SELECT name FROM bug7444

This is causing me enless grief. Any idea when it may be fixed?

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