db-ddlutils-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Andreas Wurzer (JIRA)" <j...@apache.org>
Subject [jira] Commented: (DDLUTILS-114) decimal scale never gets written to schema-file in WriteSchema* Tasks
Date Thu, 22 Jun 2006 06:07:30 GMT
    [ 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


Mime
View raw message