upsert using load generator error when default values used
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Trafodion |
New
|
High
|
Suresh Subbiah |
Bug Description
upsert using load into BR_PHONE_
gives this error
*** ERROR[7000] An internal error occurred in the code generator in file ../generator/
ValueId 8 (TRAFODION.
*** ERROR[2235] Compiler Internal Error: An unknown error, originated from file ../generator/
Issue has been worked around by providing the default value NULL explicitly in the values clause.
DDL is
CREATE TABLE TRAFODION.
(
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_TO ASC
, CITY_CODE ASC
)
HBASE_OPTIONS
(
DATA_
COMPRESSION = 'GZ'
)
salt like table;
CREATE INDEX BR_PHONE_
(
BELONGS_TO ASC
, CITY_CODE ASC
, STOCK_STATUS ASC
, NO_COOP_FLAG ASC
, IF_VIRTUAL ASC
)
HBASE_OPTIONS
(
DATA_
COMPRESSION = 'GZ'
)
salt like table;
CREATE INDEX BR_PHONE_I_PX ON TRAFODION.
(
INST_ID ASC
)
HBASE_OPTIONS
(
DATA_
COMPRESSION = 'GZ'
)
salt like table;
CREATE INDEX BR_PHONE_II_PX ON TRAFODION.
(
PHONE_NUMERIC ASC
)
HBASE_OPTIONS
(
DATA_
COMPRESSION = 'GZ'
)
salt like table;
CREATE INDEX BR_PHONE_III_PX ON TRAFODION.
(
RESHOUSE_CODE ASC
, CITY_CODE ASC
)
HBASE_OPTIONS
(
DATA_
COMPRESSION = 'GZ'
)
salt like table;