You are viewing a plain text version of this content. The canonical link for it is here.
Posted to ddlutils-dev@db.apache.org by "Thomas Dudziak (JIRA)" <ji...@apache.org> on 2006/07/19 06:54:15 UTC
[jira] Resolved: (DDLUTILS-20) Oracle FLOAT and DOUBLE type
mappings have zero scale
[ http://issues.apache.org/jira/browse/DDLUTILS-20?page=all ]
Thomas Dudziak resolved DDLUTILS-20.
------------------------------------
Resolution: Fixed
DdlUtils now uses DOUBLE PRECISION, FLOAT and REAL respectively for these types as these are available at least in Oracle 8 and newer.
> Oracle FLOAT and DOUBLE type mappings have zero scale
> -----------------------------------------------------
>
> Key: DDLUTILS-20
> URL: http://issues.apache.org/jira/browse/DDLUTILS-20
> Project: DdlUtils
> Issue Type: Bug
> Components: Core - Oracle
> Reporter: Richard Bounds
> Assigned To: Thomas Dudziak
> Fix For: 1.0
>
> Attachments: metadata.xml
>
>
> In Oracle8Platform, the types FLOAT and DOUBLE are mapped to NUMBER(38). According to Oracle's docs, this type has zero scale. It looks like floating point numbers should be specified either as just NUMBER or FLOAT(n). See:
> http://oraclelon1.oracle.com/docs/cd/B19306_01/server.102/b14200/sql_elements001.htm#g196646
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira