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

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

Lars Hofhansl created PHOENIX-6400:
--------------------------------------

             Summary: 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
             Fix For: 5.1.1


{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)