[ 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)