[
https://issues.apache.org/jira/browse/TRAFODION-612?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Suresh Subbiah closed TRAFODION-612.
------------------------------------
> LP Bug: 1367936 - create table with nullable primary key of varchar type
> causes assertion failure
> -------------------------------------------------------------------------------------------------
>
> Key: TRAFODION-612
> URL: https://issues.apache.org/jira/browse/TRAFODION-612
> Project: Apache Trafodion
> Issue Type: Bug
> Components: sql-cmp
> Reporter: Suresh Subbiah
> Assignee: Suresh Subbiah
> Fix For: 0.9 (pre-incubation)
>
>
> cqd ALLOW_NULLABLE_UNIQUE_KEY_CONSTRAINT 'on' ;
> CREATE TABLE TRAFODION.OSSDBA.COUNTRY
> (
> 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/NATable.cpp at line 1553.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
