upsert using load generator error when default values used

Bug #1460717 reported by Suresh Subbiah on 2015-06-01
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Trafodion
New
High
Suresh Subbiah

Bug Description

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;

To post a comment you must log in.
This report contains Public information  Edit
Everyone can see this information.

Other bug subscribers