You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@phoenix.apache.org by "Lars Hofhansl (Jira)" <ji...@apache.org> on 2021/03/19 01:27:00 UTC
[jira] [Updated] (PHOENIX-6421) Selecting an indexed array value
from an uncovered column with local index returns NULL
[ https://issues.apache.org/jira/browse/PHOENIX-6421?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Lars Hofhansl updated PHOENIX-6421:
-----------------------------------
Description:
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}
> 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)