MySQL Bugs: #24411: Remove ZEROFILL on INT column code generation wrong

Bug #24411	Remove ZEROFILL on INT column code generation wrong
Submitted:	18 Nov 2006 11:08	Modified:	24 Nov 2006 9:13
Reporter:	Matthew Morrissette	Email Updates:
Status:	Can't repeat	Impact on me:	None
Category:	MySQL Administrator	Severity:	S3 (Non-critical)
Version:	1.2.5rc	OS:	MacOS (Mac OS X 10.4)
Assigned to:		CPU Architecture:	Any
Tags:	INT, ZEROFILL

Description:
When attempting to remove the ZEROFILL option from an INT column, after you click apply the generated SQL still includes the ZEROFILL option.

How to repeat:
1. Create a table.

2. Add an column of type INT with ZEROFILL and UNSIGNED both selected

3. Click apply

4. Select the column and uncheck ZEROFILL

5. Click Apply

The command does generate SQL, however the ZEROFILL option is still specified.

Suggested fix:
Fix the generated SQL

Downgrading to P3 since work around is available.  Simply edit the SQL by hand.

Thank you for a problem report. Please, send exact initial CREATE TABLE statement generated. What version of MySQL server are you connecting to?

The create table statement is:
CREATE TABLE `t_test` (
  `i_test_id` int(11) NOT NULL auto_increment,
  PRIMARY KEY  (`i_test_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 

However I used MySql Administrator to create it.

I then add a colun named I_TEST_COL with UNSIGNED and ZEROFILL checked. I then click apply.  The table updates with the new column.  I then uncheck ZEROFILL and click Apply.  The SQL generated still has the ZEROFILL option specified.  

I also noticed that if you uncheck UNSIGNED, the SQL says:
ALTER TABLE `movie`.`t_test` MODIFY COLUMN `i_text_col` INTEGER ZEROFILL ZEROFILL DEFAULT NULL;

This also seems to be partly wrong.

If I also go back to the state when the table is NOT specified UNSIGNED or ZEROFILL and then just check  the ZEROFILL option, the sql generated is:
ALTER TABLE `movie`.`t_test` MODIFY COLUMN `i_text_col` INTEGER ZEROFILL DEFAULT NULL;

However, when the table reloads, both ZEROFILL and UNSIGNED are selected.

I am using SQL Server version 5.0.16 for Mac OS X.

Thank you for the report.

I can not repeat it on Mac OS X using MySQL Administrator 1.2.5rc