Description:
Using both MySQL GUI interfaces: MySQL Administrator (version 1.0.19) and MySQL Query Browser (version 1.1.6). After creating a new table with the first field been of data type 'INTEGER' and is a primary key. I can't get to edit the table giving the error "Access violation at address 0034C200 in module 'libmysqlx.dll'".
Workaround: Using the "Alter Table", then you can change the field data type to varchar(xx). Only then I gain back the functionality to edit the table from the MySQL GUI applications.
How to repeat:
Using both MySQL GUI interfaces: MySQL Administrator (version 1.0.19) and MySQL Query Browser (version 1.1.6).
1. Connect to the a database
2. From the Schemata, right click on the database and select "Create new table".
3. Type tablename T1
4. Add column "t1ID", datatype "INTEGER", and accept default.
5. Add second column "t1Name", datatype "VARCHAR(45)", and accept default.
6. Apply changes, and close.
Now, to get the error:
"Access violation at address 0034C200 in module 'libmysqlx.dll'".
1. From the Schemata, right click on the database and select "Edit table".
2. Error shows in the bottom of the MySQL Query Browser application.
Suggested fix:
The Query application doesn't crash, so you can type the SQL "Alter Table" to change the field and the able to edit the table.
