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 "Andreas Wurzer (JIRA)" <ji...@apache.org> on 2006/06/21 16:56:29 UTC
[jira] Created: (DDLUTILS-114) decimal scale never gets written to
schema-file in WriteSchema* Tasks
decimal scale never gets written to schema-file in WriteSchema* Tasks
---------------------------------------------------------------------
Key: DDLUTILS-114
URL: http://issues.apache.org/jira/browse/DDLUTILS-114
Project: DdlUtils
Type: Bug
Components: Core
Reporter: Andreas Wurzer
Assigned to: Thomas Dudziak
when doing writeSchemaToFile (or other writeSchema Task), the scale of a decimal column never gets written to the schema file
--
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
[jira] Commented: (DDLUTILS-114) decimal scale never gets written
to schema-file in WriteSchema* Tasks
Posted by "Andreas Wurzer (JIRA)" <ji...@apache.org>.
[ http://issues.apache.org/jira/browse/DDLUTILS-114?page=comments#action_12417250 ]
Andreas Wurzer commented on DDLUTILS-114:
-----------------------------------------
It's a DB2 Database i generate the schema-file from (I use the databaseToDdl-task with the writeSchemaToFile-subtask), the original table looks like:
CREATE TABLE "CONT_CONTRACTELEMENTPREMIUM" (
...
"F_NETANNUALSUBSCRIPTIONAMOUNT" DECIMAL(20,4) WITH DEFAULT NULL,
"F_BRUTTOANNUALPREMIUMAMOUNT" DECIMAL(20,4) WITH DEFAULT NULL,
"F_PAYMENTADDITIONRATE" DECIMAL(20,4) WITH DEFAULT NULL,
"F_BRUTTOPREMIUMPRORATAAMOUNT" DECIMAL(20,4) WITH DEFAULT NULL,
"F_NETPREMIUMPRORATAAMOUNT" DECIMAL(20,4) WITH DEFAULT NULL,
"F_NETPREMRISKOWNERPRAMOUNT" DECIMAL(20,4) WITH DEFAULT NULL,
"F_NETPREMSERVICEPRAMOUNT" DECIMAL(20,4) WITH DEFAULT NULL,
"F_NETPREMIUMSALEPRORATAAMOUNT" DECIMAL(20,4) WITH DEFAULT NULL,
"F_PREMIUMDISCOUNTRATEAMOUNT" DECIMAL(20,4) WITH DEFAULT NULL,
...
);
The generated schema-file for this table is:
<table name="CONT_CONTRACTELEMENTPREMIUM">
...
<column name="F_NETANNUALSUBSCRIPTIONAMOUNT" primaryKey="false" required="false" type="DECIMAL" size="20" default="NULL" autoIncrement="false"/>
<column name="F_BRUTTOANNUALPREMIUMAMOUNT" primaryKey="false" required="false" type="DECIMAL" size="20" default="NULL" autoIncrement="false"/>
<column name="F_PAYMENTADDITIONRATE" primaryKey="false" required="false" type="DECIMAL" size="20" default="NULL" autoIncrement="false"/>
<column name="F_BRUTTOPREMIUMPRORATAAMOUNT" primaryKey="false" required="false" type="DECIMAL" size="20" default="NULL" autoIncrement="false"/>
<column name="F_NETPREMIUMPRORATAAMOUNT" primaryKey="false" required="false" type="DECIMAL" size="20" default="NULL" autoIncrement="false"/>
<column name="F_NETPREMRISKOWNERPRAMOUNT" primaryKey="false" required="false" type="DECIMAL" size="20" default="NULL" autoIncrement="false"/>
<column name="F_NETPREMSERVICEPRAMOUNT" primaryKey="false" required="false" type="DECIMAL" size="20" default="NULL" autoIncrement="false"/>
<column name="F_NETPREMIUMSALEPRORATAAMOUNT" primaryKey="false" required="false" type="DECIMAL" size="20" default="NULL" autoIncrement="false"/>
<column name="F_PREMIUMDISCOUNTRATEAMOUNT" primaryKey="false" required="false" type="DECIMAL" size="20" default="NULL" autoIncrement="false"/>
...
</table>
Then i applied the schema-file to an empty derby database and the decimal-scales are gone (of course - they are not mentioned in the schema-file).
With the attached fix (scale-fix.diff), decimal-scales are exported and imported correctly.
> decimal scale never gets written to schema-file in WriteSchema* Tasks
> ---------------------------------------------------------------------
>
> Key: DDLUTILS-114
> URL: http://issues.apache.org/jira/browse/DDLUTILS-114
> Project: DdlUtils
> Type: Bug
> Components: Core
> Reporter: Andreas Wurzer
> Assignee: Thomas Dudziak
> Attachments: scale-fix.diff
>
> when doing writeSchemaToFile (or other writeSchema Task), the scale of a decimal column never gets written to the schema file
--
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
[jira] Updated: (DDLUTILS-114) decimal scale never gets written to
schema-file in WriteSchema* Tasks
Posted by "Andreas Wurzer (JIRA)" <ji...@apache.org>.
[ http://issues.apache.org/jira/browse/DDLUTILS-114?page=all ]
Andreas Wurzer updated DDLUTILS-114:
------------------------------------
Attachment: scale-fix.diff
this is a simple bug fix for this issue, which worked for me
> decimal scale never gets written to schema-file in WriteSchema* Tasks
> ---------------------------------------------------------------------
>
> Key: DDLUTILS-114
> URL: http://issues.apache.org/jira/browse/DDLUTILS-114
> Project: DdlUtils
> Type: Bug
> Components: Core
> Reporter: Andreas Wurzer
> Assignee: Thomas Dudziak
> Attachments: scale-fix.diff
>
> when doing writeSchemaToFile (or other writeSchema Task), the scale of a decimal column never gets written to the schema file
--
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
[jira] Updated: (DDLUTILS-114) decimal scale never gets written to
schema-file in WriteSchema* Tasks
Posted by "Thomas Dudziak (JIRA)" <ji...@apache.org>.
[ http://issues.apache.org/jira/browse/DDLUTILS-114?page=all ]
Thomas Dudziak updated DDLUTILS-114:
------------------------------------
Fix Version: 1.0
> decimal scale never gets written to schema-file in WriteSchema* Tasks
> ---------------------------------------------------------------------
>
> Key: DDLUTILS-114
> URL: http://issues.apache.org/jira/browse/DDLUTILS-114
> Project: DdlUtils
> Type: Bug
> Components: Core
> Reporter: Andreas Wurzer
> Assignee: Thomas Dudziak
> Fix For: 1.0
> Attachments: scale-fix.diff
>
> when doing writeSchemaToFile (or other writeSchema Task), the scale of a decimal column never gets written to the schema file
--
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
[jira] Resolved: (DDLUTILS-114) decimal scale never gets written to
schema-file in WriteSchema* Tasks
Posted by "Thomas Dudziak (JIRA)" <ji...@apache.org>.
[ http://issues.apache.org/jira/browse/DDLUTILS-114?page=all ]
Thomas Dudziak resolved DDLUTILS-114.
-------------------------------------
Resolution: Fixed
> decimal scale never gets written to schema-file in WriteSchema* Tasks
> ---------------------------------------------------------------------
>
> Key: DDLUTILS-114
> URL: http://issues.apache.org/jira/browse/DDLUTILS-114
> Project: DdlUtils
> Issue Type: Bug
> Components: Core (No specific database)
> Reporter: Andreas Wurzer
> Assigned To: Thomas Dudziak
> Fix For: 1.0
>
> Attachments: scale-fix.diff
>
>
> when doing writeSchemaToFile (or other writeSchema Task), the scale of a decimal column never gets written to the schema file
--
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
[jira] Commented: (DDLUTILS-114) decimal scale never gets written
to schema-file in WriteSchema* Tasks
Posted by "Thomas Dudziak (JIRA)" <ji...@apache.org>.
[ http://issues.apache.org/jira/browse/DDLUTILS-114?page=comments#action_12417198 ]
Thomas Dudziak commented on DDLUTILS-114:
-----------------------------------------
Could you please add the schema (snippet) where the problem occurs ? And for which database do you generate the SQL ?
> decimal scale never gets written to schema-file in WriteSchema* Tasks
> ---------------------------------------------------------------------
>
> Key: DDLUTILS-114
> URL: http://issues.apache.org/jira/browse/DDLUTILS-114
> Project: DdlUtils
> Type: Bug
> Components: Core
> Reporter: Andreas Wurzer
> Assignee: Thomas Dudziak
> Attachments: scale-fix.diff
>
> when doing writeSchemaToFile (or other writeSchema Task), the scale of a decimal column never gets written to the schema file
--
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