MySQL Bugs: #65892: Data Types are wrong in alter table screen.

Bug #65892	Data Types are wrong in alter table screen.
Submitted:	13 Jul 2012 13:31	Modified:	2 Aug 2012 14:11
Reporter:	Cem Incecinar	Email Updates:
Status:	Duplicate	Impact on me:	None
Category:	MySQL Workbench: SQL Editor	Severity:	S1 (Critical)
Version:	5.2.40	OS:	Windows (Windows 7 32bit)
Assigned to:		CPU Architecture:	Any
Tags:	data types, sql editor

Description:
When i alter table all datatypes of colums are looking wrong.

Forexample integers are "(11)", datetimes are emtpy. Also becasue of wrong data type its can't show primary index as AI.

At the left side, information box show correct values for data types but in the editor all are wrong.

Here is the screenshot : http://i48.tinypic.com/1py0bb.jpg

How to repeat:
Just open software and right click one of the table in database and click alter table.

Suggested fix:
It should show correct values at the edit screen.

Changed severity to critical, software unusable like this, you can alter only by sql command.

What exact server version, 5.x.y, are you working with? Please, send also CREATE TABLE statement for the table.

Valeriy Kravchuk, i already type my exact version you can see the top of this page (Version: 5.2.40). The table was already there, i didn't create using this version of Workbench. I was using 5.2.34 and it was fine. After upgrade to 5.2.40 alter tables are not working. If you can look screenshot carefully you can see the left information panel shows the correct values of table and columns. But the edit panel at the center is broken.

I've seen your screenshot and problem there is clearly visible. Question is how to reproduce this problem, so that developers are able to debug it and find the root cause.

I've asked about *server version*, not Workbench. Please, send the output of:

show create table project.bakiyelistesi;

also. Just copy entire result from the "Create Table" column in the grid and paste it here.

Sorry my mistake,

Server version is : 5.1.63 but i tried to connect 5.5.x version was same result.
I can try with latest version of mysql if you need.

Here is the result of create table :

CREATE TABLE `bakiyelistesi` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `firmalar_firmalar_id` int(10) unsigned DEFAULT NULL,
  `wf_id` int(10) unsigned DEFAULT NULL,
  `adi` varchar(255) DEFAULT NULL,
  `deliverydate` datetime DEFAULT NULL,
  `siparissayisi` int(10) unsigned DEFAULT NULL,
  `borc` float DEFAULT NULL,
  `odenen` float DEFAULT NULL,
  `sonodemetarihi` datetime DEFAULT NULL,
  `zamanigecmis` float DEFAULT ''0'',
  `busenekisayi` int(11) DEFAULT ''0'',
  `buhaftakiodeme` float DEFAULT ''0'',
  PRIMARY KEY (`id`),
  KEY `firmalar_firmalar_id` (`firmalar_firmalar_id`),
  KEY `wf_id` (`wf_id`)
) ENGINE=MyISAM AUTO_INCREMENT=28990 DEFAULT CHARSET=utf8

This is not happening only for this table. Its happening on the all tables on all databases i have.

Also, i just test to create new table:

CREATE  TABLE `project`.`test` (
  `idtest` INT UNSIGNED NOT NULL AUTO_INCREMENT ,
  `den` TINYINT NULL ,
  PRIMARY KEY (`idtest`) );

Just after i create datatpe of 'idtest' was '(10)', AI removed and datatype of 'den' was '(4)'.

What locale are you using? Turkish by any chance?

OS is windows 7 English but yes locale is Turkish.

Is it possible to run Workbench in Windows with its required locale (en_US.UTF-8) without change the system locale for temporary solution until it fixed?

Like run it with "env LANG="en_US.UTF-8" /usr/bin/mysql-workbench" command in linux/ubuntu.

duplicate of bug #63872