#10772: In ER-Modeler Precision and scale in Table Properties are different than Create Table GUI

nisha.gaikwad(*) reported 2013-11-15T04:04:05Z · last modified 2014-11-21T20:59:12Z

In ER-Modeler Precision and scale in Table Properties are different than Create Table GUI

Dev	JohnLH
QA	tariqrahiman

Priority	Low
Complexity	Unknown

Component	Tools - ER Modeler
Version	Future - .9

Aqua Data Studio 15.0.0-dev-34

Database - MYSQL

Connect to mysql

Go to Table tree node -> Right click -> Create table -> Add Column with integer,decimal,numeric,smallint,bigint datatype

Go to ER-Modeler menu -> Select Generate -> Select mysql database from database type -> Click on OK -> ER-Diagram Generator window open -> Click on NEXT

Add new table in ER-Modeler -> Open Table Properties window -> Add column with integer,decimal,numeric,smallint,bigint datatype

In ER-Modeler Table Properties for this all mentioned datatype display different Precision and scale in Column Parameters than Create Table GUI.

Please refer screen shot which i have attached.

1 attachment

MYSQL-ER.png

2013-11-15T04:04:05Z

89 KB

All Comments (0) Change History

Search Tips

Aqua Data Studio / nhilam

In ER-Modeler Precision and scale in Table Properties are different than Create Table GUI

1 attachment

Issue #10772

Completion

Search Tips

Aqua Data Studio / nhilam

Title

In ER-Modeler Precision and scale in Table Properties are different than Create Table GUI

1 attachment

Issue #10772

Completion