[ https://issues.apache.org/jira/browse/TRAFODION-1751?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15092244#comment-15092244 ]
Anoop Sharma commented on TRAFODION-1751: ----------------------------------------- There is typo of the column name in the store by clause. It should be "store by (ReportDateID)". That will fix the crash. But we should fix code so it doesn't crash and instead return an error message. > create table crash > ------------------ > > Key: TRAFODION-1751 > URL: https://issues.apache.org/jira/browse/TRAFODION-1751 > Project: Apache Trafodion > Issue Type: Bug > Reporter: liu ming > Priority: Critical > > The following create table DDL will crash Trafodion instance. > Tested in two different systems and can reproduce: > in sqlci > CREATE TABLE FactJCSales > ( > ReportDateID int NOT NULL, > FinanceDateID int NULL, > ProvinceCenterID int NULL, > CityCenterID int NULL, > OrgKey int NULL, > GameKey int NULL, > DrawKey int NULL, > TerminalKey int NULL, > BranchID int NULL, > ShopKey int NULL, > LogonID int NULL, > AccountID int NULL, > TechSystemID int NULL, > ChannelTypeCode int NULL, > SaleLotteryCnt int NULL, > SaleStakeCnt int NULL, > SaleAmount decimal (18, 4) NULL, > SaleLotteryCntSettled int NULL, > SaleStakeCntSettled int NULL, > SaleAmountSettled decimal (18, 4) NULL, > CancelLotteryCnt int NULL, > CancelStakeCnt int NULL, > CancelAmount decimal (18, 4) NULL, > ProvCancelLotteryCnt int NULL, > ProvCancelStakeCnt int NULL, > ProvCancelAmount decimal (18, 4) NULL, > BranchCancelLotteryCnt int NULL, > BranchCancelStakeCnt int NULL, > BranchCancelAmount decimal (18, 4) NULL > ) > store by (ReprotDateID) > SALT USING 80 PARTITIONS > HBASE_OPTIONS > ( > DATA_BLOCK_ENCODING = 'FAST_DIFF', > COMPRESSION = 'SNAPPY', > MEMSTORE_FLUSH_SIZE = '1073741824' > ) > ; > *** EXECUTOR ASSERTION FAILURE > *** Time: Mon Jan 11 08:57:50 2016 > *** Process: 6860 > *** File: ../common/Collections.cpp > *** Line: 874 > *** Message: List index exceeds # of entries > Aborted -- This message was sent by Atlassian JIRA (v6.3.4#6332)