[jira] [Commented] (PHOENIX-6421) Selecting an indexed array value from an uncovered column with local index returns NULL

["Lars Hofhansl (Jira)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/PHOENIX-6421?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17304573#comment-17304573 ] 

Lars Hofhansl commented on PHOENIX-6421:
----------------------------------------

Not a blocker for 5.1.1, since this has not worked before.

> Selecting an indexed array value from an uncovered column with local index returns NULL
> ---------------------------------------------------------------------------------------
>
>                 Key: PHOENIX-6421
>                 URL: https://issues.apache.org/jira/browse/PHOENIX-6421
>             Project: Phoenix
>          Issue Type: Bug
>            Reporter: Lars Hofhansl
>            Priority: Major
>
> Another one of these:
> {code:java}
> > create table test1(pk1 integer not null primary key, v1 float, v2 float[10]);
> No rows affected (0.673 seconds)
> > create local index l2 on test1(v1);                       
> No rows affected (10.889 seconds)
> > upsert into test1 values(rand() * 10000000, rand(), ARRAY[rand(),rand(), rand()]);
> 1 row affected (0.045 seconds)
> > select /*+ NO_INDEX */ v2[1] from test1 where v1 < 1;
> +-------------------+
> | ARRAY_ELEM(V2, 1) |
> +-------------------+
> | 0.49338496        |
> +-------------------+
> 1 row selected (0.037 seconds)
> > select v2[1] from test1 where v1 < 1;
> +---------------------+
> | ARRAY_ELEM("V2", 1) |
> +---------------------+
> | null                |
> +---------------------+
> 1 row selected (0.062 seconds)
> {code}
>  



--
This message was sent by Atlassian Jira
(v8.3.4#803005)