Bug #13539 Access violation on editing data
Submitted: 27 Sep 2005 20:10 Modified: 27 Sep 2005 20:25
Reporter: Daniel Rairigh Email Updates:
Status: Can't repeat Impact on me:
None 
Category:MySQL Query Browser Severity:S2 (Serious)
Version:1.1.15 OS:Windows (Win Xp)
Assigned to: MySQL Verification Team CPU Architecture:Any

[27 Sep 2005 20:10] Daniel Rairigh 
Description:
Access violation thrown when I try and edit a sorted query.

I saw another error report that suggested making sure that "Enforce queries  to be editable by adding primary key columns to the select" was checked.  I do have it checked.

I also saw this bug in Release 1.1.14

How to repeat:
After a simple query like: "SELECT * FROM location l" I can switch to edit mode, make changes and apply the changes with out any trouble.

However, if I sort my query: "SELECT * FROM location l ORDER BY loc_name" Then when I try to apply my changes it throws the following error:
"Access Violation at address 0035FA63 in module 'libmysqlx.dll'.  Read  of address 00000020"

Once the error has been thrown, I can not edit anything until I quit and restart the application.
[27 Sep 2005 20:25] MySQL Verification Team 
I was unable to repeat with a simples table with 2 columns,
could you please shows the table definition which causing
this issue.

Thanks.
[27 Sep 2005 20:33] Daniel Rairigh 
Here is the SQL to create the table:
CREATE TABLE `location` (
  `loc_id` tinyint(2) unsigned NOT NULL auto_increment,
  `loc_name` varchar(40) NOT NULL default '',
  `building_name` varchar(50) default '',
  `room_number` varchar(5) default '',
  `loc_zone` tinyint(1) unsigned NOT NULL default '0',
  PRIMARY KEY  (`loc_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='List of rooms (incl. building) tasks may meet in';

I have 29 records in the table all fields in the records are populated, except for 2 records which have nulls in 'building_name' and 'room_number'.

If it helps the MySQL server I am using is:
mysql  Ver 14.7 Distrib 4.1.10, for sun-solaris2.9 (sparc)