You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@trafodion.apache.org by "Hans Zeller (JIRA)" <ji...@apache.org> on 2016/05/20 01:20:18 UTC
[jira] [Updated] (TRAFODION-1252) LP Bug: 1460717 - upsert using
load generator error when default values used
[ https://issues.apache.org/jira/browse/TRAFODION-1252?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Hans Zeller updated TRAFODION-1252:
-----------------------------------
Fix Version/s: (was: 2.0-incubating)
2.1-incubating
> LP Bug: 1460717 - upsert using load generator error when default values used
> ----------------------------------------------------------------------------
>
> Key: TRAFODION-1252
> URL: https://issues.apache.org/jira/browse/TRAFODION-1252
> Project: Apache Trafodion
> Issue Type: Bug
> Components: sql-cmp
> Reporter: Suresh Subbiah
> Assignee: Suresh Subbiah
> Priority: Critical
> Fix For: 2.1-incubating
>
>
> upsert using load into BR_PHONE_T_PX(CITY_CODE, RES_ID, INST_ID, PHONE_NUMERIC, SERVICE_KIND, NUMERIC_TYPE, RESHOUSE_CODE, STOCK_STATUS, NO_COOP_FLAG, MAJOR_TYPE, BEFOREHAND_FEE, NUM_RULE_KIND, IF_VIRTUAL, IN_OPTION, OUT_OPTION) Values('910',11111111,11111111,'2',3,3,3,3,3,3,3,3,3,3,3);
> gives this error
> *** ERROR[7000] An internal error occurred in the code generator in file ../generator/Generator.cpp at line 1777:
> ValueId 8 (TRAFODION.SEABASE.BR_PHONE_T_PX.BELONGS_TO...) not found in MapTable 0x7f678363a8b0. [2015-05-30 22:15:39]
> *** ERROR[2235] Compiler Internal Error: An unknown error, originated from file ../generator/Generator.cpp at line 2142. [2015-05-30 22:15:39]
> Issue has been worked around by providing the default value NULL explicitly in the values clause.
> DDL is
> CREATE TABLE TRAFODION.SEABASE.BR_PHONE_T_PX
> (
> CITY_CODE VARCHAR(8 CHARS) CHARACTER SET UTF8
> COLLATE DEFAULT NO DEFAULT NOT NULL NOT DROPPABLE
> , RES_ID NUMERIC(9, 0) NO DEFAULT NOT NULL NOT
> DROPPABLE
> , INST_ID NUMERIC(12, 0) NO DEFAULT NOT NULL NOT
> DROPPABLE
> , PHONE_NUMERIC VARCHAR(15 CHARS) CHARACTER SET UTF8
> COLLATE DEFAULT NO DEFAULT NOT NULL NOT DROPPABLE
> , SERVICE_KIND NUMERIC(4, 0) NO DEFAULT NOT NULL NOT
> DROPPABLE
> , NUMERIC_TYPE NUMERIC(2, 0) DEFAULT 0
> , RESHOUSE_CODE NUMERIC(9, 0) DEFAULT NULL
> , BELONGS_TO VARCHAR(30 CHARS) CHARACTER SET UTF8
> COLLATE DEFAULT DEFAULT NULL
> , STOCK_STATUS NUMERIC(4, 0) NO DEFAULT NOT NULL NOT
> DROPPABLE
> , NO_COOP_FLAG NUMERIC(2, 0) DEFAULT 0
> , USED_DATE TIMESTAMP(6) DEFAULT NULL
> , OPERATE_DATE TIMESTAMP(6) DEFAULT NULL
> , OPERATOR VARCHAR(64 CHARS) CHARACTER SET UTF8
> COLLATE DEFAULT DEFAULT NULL
> , NOTE VARCHAR(60 CHARS) CHARACTER SET UTF8
> COLLATE DEFAULT DEFAULT NULL
> , MAJOR_TYPE NUMERIC(1, 0) DEFAULT 0 NOT NULL NOT
> DROPPABLE
> , YIDI_ACCEPT NUMERIC(4, 0) DEFAULT NULL
> , ADJUST_KIND NUMERIC(2, 0) DEFAULT NULL
> , ADJUST_MONTHS NUMERIC(4, 0) DEFAULT NULL
> , ADJUST_PERIOD NUMERIC(4, 0) DEFAULT NULL
> , ADJUST_FEE NUMERIC(122, 0) DEFAULT NULL
> , F_LEVEL NUMERIC(2, 0) DEFAULT NULL
> , BEFOREHAND_FEE NUMERIC(122, 0) DEFAULT NULL
> , NUM_RULE_KIND NUMERIC(8, 0) DEFAULT NULL
> , IF_VIRTUAL NUMERIC(2, 0) DEFAULT NULL
> , IN_OPTION NUMERIC(4, 0) DEFAULT NULL
> , OUT_OPTION NUMERIC(4, 0) DEFAULT NULL
> , PRIMARY KEY (INST_ID ASC, PHONE_NUMERIC ASC, CITY_CODE ASC, STOCK_STATUS
> ASC)
> )
> SALT USING 2 PARTITIONS
> ON (INST_ID)
> ;
> CREATE INDEX BR_PHONE_BELONGS_I_PX ON TRAFODION.SEABASE.BR_PHONE_T_PX
> (
> BELONGS_TO ASC
> , CITY_CODE ASC
> )
> HBASE_OPTIONS
> (
> DATA_BLOCK_ENCODING = 'FAST_DIFF',
> COMPRESSION = 'GZ'
> )
> salt like table;
> CREATE INDEX BR_PHONE_BLNGS_FLG_I_PX ON TRAFODION.SEABASE.BR_PHONE_T_PX
> (
> BELONGS_TO ASC
> , CITY_CODE ASC
> , STOCK_STATUS ASC
> , NO_COOP_FLAG ASC
> , IF_VIRTUAL ASC
> )
> HBASE_OPTIONS
> (
> DATA_BLOCK_ENCODING = 'FAST_DIFF',
> COMPRESSION = 'GZ'
> )
> salt like table;
> CREATE INDEX BR_PHONE_I_PX ON TRAFODION.SEABASE.BR_PHONE_T_PX
> (
> INST_ID ASC
> )
> HBASE_OPTIONS
> (
> DATA_BLOCK_ENCODING = 'FAST_DIFF',
> COMPRESSION = 'GZ'
> )
> salt like table;
> CREATE INDEX BR_PHONE_II_PX ON TRAFODION.SEABASE.BR_PHONE_T_PX
> (
> PHONE_NUMERIC ASC
> )
> HBASE_OPTIONS
> (
> DATA_BLOCK_ENCODING = 'FAST_DIFF',
> COMPRESSION = 'GZ'
> )
> salt like table;
> CREATE INDEX BR_PHONE_III_PX ON TRAFODION.SEABASE.BR_PHONE_T_PX
> (
> RESHOUSE_CODE ASC
> , CITY_CODE ASC
> )
> HBASE_OPTIONS
> (
> DATA_BLOCK_ENCODING = 'FAST_DIFF',
> COMPRESSION = 'GZ'
> )
> salt like table;
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)