[ https://issues.apache.org/jira/browse/PHOENIX-6421?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Lars Hofhansl updated PHOENIX-6421: ----------------------------------- Attachment: 6421-5.1.txt > 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 > Assignee: Lars Hofhansl > Priority: Major > Fix For: 4.16.1, 5.2.0, 5.1.2 > > Attachments: 6421-5.1.txt > > > 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)