MySQL Bugs: #38310: Changing field from tinyint(1) type to BOOL type

Bug #38310	Changing field from tinyint(1) type to BOOL type
Submitted:	23 Jul 2008 11:53	Modified:	24 Feb 2009 10:33
Reporter:	Floris Groenendijk	Email Updates:
Status:	Won't fix	Impact on me:	None
Category:	MySQL Query Browser	Severity:	S3 (Non-critical)
Version:	1.2.12	OS:	MacOS (version 10.5.4)
Assigned to:		CPU Architecture:	Any
Tags:	change, field

Description:
I tried to change a field in the database from tinyint(1) to bool type.
When I clicked on the apply button, the program crashed.

How to repeat:
Create field in table with boolean type, this will add a tinyint(1) field in the table. Use the not null and default value false.
Then press apply.
Now change the field to BOOL type.
The program will now crash.

Thank you for the report.

Verified as described.

I repeated this bug on Linux, too.

Observations:

1) It is not necessary that the field is NOT NULL and default value is FALSE to make the program crash
2) If you change the type writing BOOL in the grid (not data type menu below) the program doesn't crash, but you can't apply changes

Many thanks for writing a bug report. We are on the way to implement full functionality of MySQL Query Browser into MySQL Workbench. Unfortunately you are using an unsupported platform. More informations about supported platforms you will find here:

http://www.mysql.com/support/supportedplatforms/tools.html

More informations about MySQL Workbench you will find here:

http://dev.mysql.com/workbench/