[ https://issues.apache.org/jira/browse/TRAFODION-3005?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
David Wayne Birdsall closed TRAFODION-3005. ------------------------------------------- > CREATE INDEX on certain long chars fails with Java exceptions > ------------------------------------------------------------- > > Key: TRAFODION-3005 > URL: https://issues.apache.org/jira/browse/TRAFODION-3005 > Project: Apache Trafodion > Issue Type: Bug > Components: sql-cmp > Affects Versions: 2.3 > Reporter: David Wayne Birdsall > Assignee: David Wayne Birdsall > Priority: Major > Fix For: 2.3 > > > The following session illustrates the issue. Creating an index on a > CHAR(32757) succeeds. Creating an index on a CHAR(32766) fails with a good > error message (1141). But creating an index on intermediate sizes fails with > a Java exception, pointing to some bug with near-boundary conditions. > {{>>drop table if exists mytable;}}{{--- SQL operation complete.}} > {{>>create table mytable (}} > {{+>c1 char(32757),}} > {{+>c2 char(32758),}} > {{+>c3 char(32765),}} > {{+>c4 char(32766));}}{{--- SQL operation complete.}} > {{>>insert into mytable values ('A','A','A','A');}}{{--- 1 row(s) inserted.}} > {{>>create index idx1 on mytable (c1);}}{{--- SQL operation complete.}} > {{>>create index idx2 on mytable (c2);}}{{*** ERROR[8448] Unable to access > Hbase interface. Call to ExpHbaseInterface::addToHFile returned error > HBASE_ADD_TO_HFILE_ERROR(-713). Cause: java.lang.NegativeArraySizeException}} > {{org.trafodion.sql.HBulkLoadClient.addToHFile(HBulkLoadClient.java:247).}} > {{*** ERROR[1081] Loading of index TRAFODION.SCH.IDX2 failed unexpectedly.}} > {{--- SQL operation failed with errors.}} > {{>>create index idx3 on mytable (c3);}} > {{*** ERROR[8448] Unable to access Hbase interface. Call to > ExpHbaseInterface::addToHFile returned error HBASE_ADD_TO_HFILE_ERROR(-713). > Cause: java.lang.NegativeArraySizeException}} > {{org.trafodion.sql.HBulkLoadClient.addToHFile(HBulkLoadClient.java:247).}} > {{*** ERROR[1081] Loading of index TRAFODION.SCH.IDX3 failed unexpectedly.}} > {{--- SQL operation failed with errors.}} > {{>>create index idx4 on mytable (c4);}} > {{*** ERROR[1141] Key length 32768 exceeds the maximum allowed key length of > 32767.}} > {{--- SQL operation failed with errors.}} > {{>>}} -- This message was sent by Atlassian JIRA (v7.6.3#76005)