[jira] [Resolved] (TRAFODION-2467) HBase region start key straddling a datetime key value gives error or crashes

["Hans Zeller (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/TRAFODION-2467?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Hans Zeller resolved TRAFODION-2467.
------------------------------------
    Resolution: Fixed

> HBase region start key straddling a datetime key value gives error or crashes
> -----------------------------------------------------------------------------
>
>                 Key: TRAFODION-2467
>                 URL: https://issues.apache.org/jira/browse/TRAFODION-2467
>             Project: Apache Trafodion
>          Issue Type: Bug
>          Components: sql-cmp
>    Affects Versions: 2.0-incubating
>         Environment: Any
>            Reporter: Hans Zeller
>            Assignee: Hans Zeller
>
> There is no simple test case for this, but Wei-Shiun has observed a problem that fits the theory, and I was able to force a problem in a debugger.
> The issue is this: HBase creates region start keys, and the length of those keys may provide only a part (a prefix) of a column value. So, HBase may have a 2 byte region start key of \x07\xCE for a table with a DATE key. This provides the year, 1998 in this case, but not month or day. Normally, we extend this partial key with zeroes for most data types, including date/time/timestamp. However, for these datetime types we need to add logic that set the year, month and day fields to 1 if extending the key with zeroes would make it 0 otherwise.



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)