Lars Hofhansl created PHOENIX-5486:
--------------------------------------
Summary: Local Indexes broken with latest HBase 1.5.0 snapshot
Key: PHOENIX-5486
URL: https://issues.apache.org/jira/browse/PHOENIX-5486
Project: Phoenix
Issue Type: Bug
Reporter: Lars Hofhansl
Script:
{code:java}
$ CREATE TABLE test (pk INTEGER PRIMARY KEY, v INTEGER);
$ CREATE LOCAL INDEX l1 on test(v);
$ UPSERT INTO tests VALUES(1,1);
$ SELECT * FROM test;
+--------------+-------+
| PK | V |
+--------------+-------+
| -2147483648 | null |
+--------------+-------+
$ SELECT /*+ NO_INDEX */ * FROM test;
+-----+----+
| PK | V |
+-----+----+
| 1 | 1 |
+-----+----+
$ SELECT v FROM test WHERE v < 2;
+-------+
| V |
+-------+
| null |
+-------+
$ SELECT /*+ NO_INDEX */ v FROM tests WHERE v < 2;
+----+
| V |
+----+
| 1 |
+----+
{code}
Something is seriously broken.
Seems only when I build/run against latest 1.5.0 SNAPSHOT.
[~apurtell]
--
This message was sent by Atlassian Jira
(v8.3.4#803005)