[jira] [Updated] (PHOENIX-6400) Local index query returns incorrect values with other columns in the WHERE clause

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

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

Lars Hofhansl updated PHOENIX-6400:
-----------------------------------
    Attachment: 6400-test-5.1.txt

> Local index query returns incorrect values with other columns in the WHERE clause
> ---------------------------------------------------------------------------------
>
>                 Key: PHOENIX-6400
>                 URL: https://issues.apache.org/jira/browse/PHOENIX-6400
>             Project: Phoenix
>          Issue Type: Bug
>            Reporter: Lars Hofhansl
>            Priority: Blocker
>             Fix For: 5.1.1
>
>         Attachments: 6400-test-5.1.txt
>
>
> {code}
> > create table test(pk1 integer not null primary key, v1 float, v2 float, v3 float);
> > create local index L1 on test (v1);
> > upsert into test values(1000, 0.01, 0.1, 0.5);
> > select * from test where v1 < 0.1;
> +------+------+-----+-----+
> | PK1  |  V1  | V2  | V3  |
> +------+------+-----+-----+
> | 1000 | 0.01 | 0.1 | 0.5 |
> +------+------+-----+-----+
> > select * from test where v1 < 0.1 and v2 < 10.0;
> +-----+----+----+----+
> | PK1 | V1 | V2 | V3 |
> +-----+----+----+----+
> > select /*+ NO_INDEX */ * from test where v1 < 0.1 and v2 < 10.0;
> +------+------+-----+-----+
> | PK1  |  V1  | V2  | V3  |
> +------+------+-----+-----+
> | 1000 | 0.01 | 0.1 | 0.5 |
> +------+------+-----+-----+
> {code}



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