[jira] [Closed] (TRAFODION-3005) CREATE INDEX on certain long chars fails with Java exceptions

["David Wayne Birdsall (JIRA)" <ji...@apache.org>]

     [ 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)