[jira] [Assigned] (TRAFODION-1446) End Key missing for simple scan scenario

["Suresh Subbiah (JIRA)" <ji...@apache.org>]

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

Suresh Subbiah reassigned TRAFODION-1446:
-----------------------------------------

    Assignee: Qifan Chen

> End Key missing for simple scan scenario
> ----------------------------------------
>
>                 Key: TRAFODION-1446
>                 URL: https://issues.apache.org/jira/browse/TRAFODION-1446
>             Project: Apache Trafodion
>          Issue Type: Bug
>          Components: sql-cmp
>    Affects Versions: 2.0-incubating
>         Environment: see on developer build
>            Reporter: Eric Owhadi
>            Assignee: Qifan Chen
>            Priority: Blocker
>
> Using a table a created with something like:
> Create table t131helper (a int not null, primary key(a));
> Insert into t131helper values(1);
> Create table t1311oneblock
> (uniq int not null,
> C100 int,
> Str1 varchar(4000),
> Primary key (uniq))
> Insert into t131oneblock
>   Select (100*x100)+(10*x10)+x1,
> (100*x100)+(10*x10)+x1,
> ‘xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx’
> From t131helper
> Transpose 0,1,2,3,4,5,6,7,8,9 as x100
> Transpose 0,1,2,3,4,5,6,7,8,9 as x10
> Transpose 0,1,2,3,4,5,6,7,8,9 as x1
> so basically creating a table with key 0,1,2,3,4 etc until 999.
> Then doing a 
> Select * from t131oneblock where uniq >2 and uniq < 5
> you will see that end key is not populated on the scan operator (use explain to notice the empty end key). I stepped in the code, and the error is not just a wrong display on the explain, the end key is not populated down to the java hbase scan invoke.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)