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)

Reply via email to