MySQL Bugs: #46848: data type mix by using wrong name for column

Bug #46848	data type mix by using wrong name for column
Submitted:	21 Aug 2009 4:03	Modified:	11 Nov 2009 13:05
Reporter:	Susanne Ebrecht	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Workbench	Severity:	S3 (Non-critical)
Version:	5.1	OS:	Linux
Assigned to:		CPU Architecture:	Any

Description:
Try the following by drawing/clicking:

CREATE TABLE t(i integer, j integer, j integer);

Consider, it is not a valid syntax.

But see what happens in diagram:

1) Open Workbench

2) Model -> Add diagram

3) Place a new table

4) double click table for getting edit mode

5) Rename table to t

6) click on column tab in table editor

7) Add columns and look what happens in diagram:

i, integer => placed into diagram correctly
j, integer => placed into diagram correctly
j, integer => in diagram you will see: j, varchar(45)

Even when this is not valid there should not be a automatic change to varchar(45) in diagram. Also in table editor it will stay integer.

You also can test this with other data types. Doesn't matter what you are using here. Always when there are two columns with same name the second will get data type varchar(45) in diagram.

How to repeat:
See above

Suggested fix:
...

what version of WB and what platform? (i wasn't able to repeat that)

Seems I forgot to fill out version here.

I tested with actual version/source tree and with Ubuntu.

Thank you for your bug report. This issue has already been fixed in the latest released version of Workbench 5.2, which you can download at

  http://www.mysql.com/downloads/