MySQL Bugs: #25268: Field type change from INTEGER to INTEGER(n) not possible

Bug #25268	Field type change from INTEGER to INTEGER(n) not possible
Submitted:	25 Dec 2006 10:04	Modified:	17 Jan 2007 16:46
Reporter:	Heinz Schweitzer (Gold Quality Contributor)	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Administrator	Severity:	S3 (Non-critical)
Version:	1.2.8	OS:	Windows (Windows XP)
Assigned to:	Mike Lischke	CPU Architecture:	Any

Description:
Field type change from INTEGER to INTEGER(n) not possible

This transition is not possible

MySQL Server Information
--------------------------------------------------------------------------------
Connected to MySQL Server Instance
  Username:                root
  Hostname:                localhost
  Port:                    3306
--------------------------------------------------------------------------------
Server Information
  MySQL Version:           MySQL 5.0.24a-community-nt via TCP/IP
  Network Name:            localhost
  IP:                      127.0.0.1
--------------------------------------------------------------------------------
Client Information
  Version:                 MySQL Client Version 5.1.11
  Network Name:            hgs
  IP:                      192.168.2.5
  Operating System:        Windows XP
  Hardware:                Intel(R) Pentium(R) 4 CPU 2.00GHz, 504 MB RAM

How to repeat:

Open MySQL Administrator 
In Catalogs select a schema you can fool around with.
Open the schema.
In the right pane select a table.
In the Table Editor create a new field with type INTEGER like in
screen shot i1.
Now try to change the type to INTEGER(4) and say apply change.
You will see the confirm tabel editor dialog like in screen shot
i2 indicating that nothing will be changed, and nothing is changed.

If you initially create a field with type INTEGER(4) this will
map to INT(4). In  this case you can change the (n) at will, but
going to type INTEGER you can't go back to type INTEGER(n)

i1

Attachment: i1.png (image/png, text), 108.40 KiB.

i2

Attachment: i2.png (image/png, text), 109.48 KiB.

Thank you for a bug report. Verified just as described.

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 bug fix. More information about accessing the source trees is available at

    http://dev.mysql.com/doc/en/installing-source.html