Bug #14219 Access violation when altering a bit column to boolean
Submitted: 21 Oct 2005 18:34 Modified: 9 Jan 2006 15:59
Reporter: Gregory Williams Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Administrator Severity:S3 (Non-critical)
Version:1.1.3/1.1.4 OS:Windows (Windows Server 2003 SP1)
Assigned to: Mike Lischke CPU Architecture:Any

[21 Oct 2005 18:34] Gregory Williams 
Description:
Changing a column of datatype bit to the boolean datatype using the MySQL Table Editor in MySQL Administrator causes an access violation, as detailed in "How to repeat".

This was performed against a MySQL 5.0.13-rc-nt database engine with the root user.

How to repeat:
(1) Execute the following, to create the table to be altered inside MySQL Administrator:

create table MyTable (
  MyColumn bit
);

(2) Locate the table MyTable in MySQL Administrator, and click Edit Table.
(3) Double-click the datatype value bit(1) in the list. Type "boolean", then press enter.
(4) Click the Apply Changes button at the bottom of the window. The following exception is shown:

---------------------------------------
MySQL Administrator Exception
---------------------------------------
Access violation at address 0071A9FB in module 'libmysqlx.dll'. Read of address 00000008

Suggested fix:
No access violation!
[9 Jan 2006 15:59] 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 bugfix, yourself. More information 
about accessing the source trees is available at
    http://www.mysql.com/doc/en/Installing_source_tree.html