[
https://issues.apache.org/jira/browse/TRAFODION-1909?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
liu ming reassigned TRAFODION-1909:
-----------------------------------
Assignee: liu ming
> Output of showddl differs from output of jdbc client (t4)
> ---------------------------------------------------------
>
> Key: TRAFODION-1909
> URL: https://issues.apache.org/jira/browse/TRAFODION-1909
> Project: Apache Trafodion
> Issue Type: Bug
> Components: client-jdbc-t4
> Affects Versions: 1.3-incubating
> Reporter: Pierre Smits
> Assignee: liu ming
>
> as per thread on the dev ml. See http://markmail.org/message/tw73lpq3k3fkldvr
> This is returned in the application (Apache OFBiz)
> {code}
> Column [ESTIMATED_COST] of table [OFBIZ.WORK_EFFORT_GOOD_STANDARD] of
> entity [WorkEffortGoodStandard] is of type [BIGINT] in the database, but is
> defined as type [NUMERIC] in the entity definition.
> {code}
> This is returned with the showddl command;
> {code}>>showddl table OFBIZ.WORK_EFFORT_GOOD_STANDARD;
> CREATE TABLE TRAFODION.OFBIZ.WORK_EFFORT_GOOD_STANDARD
> (
> WORK_EFFORT_ID VARCHAR(20) CHARACTER SET ISO88591
> COLLATE
> DEFAULT NO DEFAULT NOT NULL NOT DROPPABLE SERIALIZED
> , PRODUCT_ID VARCHAR(20) CHARACTER SET ISO88591
> COLLATE
> DEFAULT NO DEFAULT NOT NULL NOT DROPPABLE SERIALIZED
> , WORK_EFFORT_GOOD_STD_TYPE_ID VARCHAR(20) CHARACTER SET ISO88591
> COLLATE
> DEFAULT NO DEFAULT NOT NULL NOT DROPPABLE SERIALIZED
> , FROM_DATE TIMESTAMP(6) NO DEFAULT NOT NULL NOT
> DROPPABLE NOT SERIALIZED
> , THRU_DATE TIMESTAMP(6) DEFAULT NULL NOT
> SERIALIZED
> , STATUS_ID VARCHAR(20) CHARACTER SET ISO88591
> COLLATE
> DEFAULT DEFAULT NULL SERIALIZED
> , ESTIMATED_QUANTITY DOUBLE PRECISION DEFAULT NULL NOT
> SERIALIZED
> , ESTIMATED_COST NUMERIC(18, 2) DEFAULT NULL
> SERIALIZED
> , LAST_UPDATED_STAMP TIMESTAMP(6) DEFAULT NULL NOT
> SERIALIZED
> , LAST_UPDATED_TX_STAMP TIMESTAMP(6) DEFAULT NULL NOT
> SERIALIZED
> , CREATED_STAMP TIMESTAMP(6) DEFAULT NULL NOT
> SERIALIZED
> , CREATED_TX_STAMP TIMESTAMP(6) DEFAULT NULL NOT
> SERIALIZED
> , PRIMARY KEY (WORK_EFFORT_ID ASC, PRODUCT_ID ASC,
> WORK_EFFORT_GOOD_STD_TYPE_ID ASC, FROM_DATE ASC)
> )
> ;
> CREATE INDEX WKEFF_GDSTD_PROD ON
> TRAFODION.OFBIZ.WORK_EFFORT_GOOD_STANDARD
> (
> PRODUCT_ID ASC
> )
> ;
> CREATE INDEX WKEFF_GDSTD_STTS ON
> TRAFODION.OFBIZ.WORK_EFFORT_GOOD_STANDARD
> (
> STATUS_ID ASC
> )
> ;
> CREATE INDEX WKEFF_GDSTD_TYPE ON
> TRAFODION.OFBIZ.WORK_EFFORT_GOOD_STANDARD
> (
> WORK_EFFORT_GOOD_STD_TYPE_ID ASC
> )
> ;
> CREATE INDEX WKEFF_GDSTD_WEFF ON
> TRAFODION.OFBIZ.WORK_EFFORT_GOOD_STANDARD
> (
> WORK_EFFORT_ID ASC
> )
> ;
> {code}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
