Easily find issues by searching: #<Issue ID>
Example: #1832
Easily find members by searching in: <username>, <first name> and <last name>.
Example: Search smith, will return results smith and adamsmith
Version is 14.0.1 (this is a company side installation, I am not able to use another version)
I am currently using the ER modeller to model a database for MySQL 5.1. I was rather surprised that the datatype "double" seems to screwed up in the modeller as it always gets created with a precision like "double(10,5)". But I want to use double without precision, otherwise the type of my choice would be "numeric".
Screenshot p1 shows a field "foobar", simply modelled as type "double" without additional attributes. The SQL however looks like this:
CREATE TABLE `eom_adjustment_exch_proxy` (
`id` bigint(15) AUTO_INCREMENT NOT NULL,
`book` varchar(50) NOT NULL,
`bbg_code` varchar(50) NOT NULL,
`pnl_pre_tol` decimal(15,5) NOT NULL,
`pnl_post_tol` decimal(15,5) NOT NULL,
`term` date NULL,
`vega` decimal(15,5) NOT NULL,
`source` varchar(25) NOT NULL,
`foobar` double(10,0) NULL,
PRIMARY KEY(`id`)
)
COMMENT = 'Contains ATM portion of IPV adjustments for for most recent '
I fiddled around with attributes but was not able to create a simple "double" type without any precision. It sounds so basic to use double so I am wondering if this is really a bug or if I am too stupid to find the correct switch in ER modeller <g>?
Regards,
Soeren Gerlach
I forgot to mention that one is not able to change the "(10,0)" attribute in the ER modeller at all, so "double" and "float" effectively become completly unusable.
Checked in fix in :
14.0 - SVN #38508
15.0 - SVN #38507
Checked in fix in :
14.0 - SVN #38508
15.0 - SVN #38507
This is fixed and here is the patch :
http://dd1.aquafold.com/download/v14.0.0/ads-14.0.15-10-patch.zip
This is fixed and here is the patch :
http://dd1.aquafold.com/download/v14.0.0/ads-14.0.15-10-patch.zip
You should extend the fix for float as well.
If I use Schema Script generator to script the below tables in MySQL for Float and Double, there is no scale and precision.
If I use the ER Diagram Generator, there is still scale and precision for Float. The float(7,2) becomes float(10,0) See attached screenshot.
CREATE TABLE `eom_adjustment_exch_proxy` (
You should extend the fix for float as well.
If I use Schema Script generator to script the below tables in MySQL for Float and Double, there is no scale and precision.
If I use the ER Diagram Generator, there is still scale and precision for Float. The float(7,2) becomes float(10,0) See attached screenshot.
CREATE TABLE `eom_adjustment_exch_proxy` (
Issue #12278 |
| Closed |
| Fixed |
| Resolved |
Completion |
| No due date |
| Fixed Build 14.0.15-10 |
| No time estimate |
I forgot to mention that one is not able to change the "(10,0)" attribute in the ER modeller at all, so "double" and "float" effectively become completly unusable.