create table with nullable primary key of varchar type causes assertion failure
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Trafodion |
Fix Committed
|
Medium
|
Suresh Subbiah |
Bug Description
cqd ALLOW_NULLABLE_
CREATE TABLE TRAFODION.
(
COUNTRY_NAME VARCHAR(40 BYTES) CHARACTER SET UTF8
NOT NULL NOT DROPPABLE
, ISO_CODE VARCHAR(3 BYTES) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT NULL
, HP_CODE VARCHAR(4 BYTES) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT NULL
, REGION VARCHAR(30 BYTES) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT NULL
, SUBREGION VARCHAR(30 BYTES) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT NULL
, IN_BACKLOG_SHIP VARCHAR(1 BYTE) CHARACTER SET UTF8 COLLATE
DEFAULT DEFAULT NULL
, ISO3_CODE VARCHAR(3 BYTES) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT NULL
, HP_REGION VARCHAR(6 BYTES) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT NULL
)
STORE BY (COUNTRY_NAME ASC)
SALT USING 16 PARTITIONS
;
gives
*** ERROR[2006] Internal error: assertion failure (keyColOffset == encodedKeyLen) in file ../optimizer/
tags: | added: sql-cmp |
Changed in trafodion: | |
milestone: | r1.0 → r1.1 |
This problem was addressed some time ago. The problem no longer shows in a recent build.