Bug #7322 Changing column type from TEXT to INTEGER creates bad SQL
Submitted: 15 Dec 2004 15:56 Modified: 16 Feb 2005 12:38
Reporter: Mark Junker Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Query Browser Severity:S2 (Serious)
Version:1.1.3 OS:Windows (WinXP Pro SP2)
Assigned to: Mike Lischke CPU Architecture:Any

[15 Dec 2004 15:56] Mark Junker 
Description:
Hi,

when changing the column type from TEXT to INTEGER, I get the following SQL statement:

ALTER TABLE `xoa`.`text` MODIFY COLUMN `text` INTEGER UNSIGNED CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL;

How to repeat:
Just create a tabe with a TEXT column.
Then change the column type from TEXT to INTEGER.
[15 Dec 2004 16:18] Mark Junker 
I forgot to tell you that you have to close the "Table Editor" Window between table creation and alteration. Sorry.

Regards,
Mark
[16 Feb 2005 12:38] 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