[PHOENIX-5486] Projections from local indexes return garbage.

• Type: Bug
• Status: Closed
• Priority: Blocker
• Resolution: Fixed
• Fix Version/s: 4.15.0, 5.1.0
• Assignee: Lars Hofhansl
• Reporter: Lars Hofhansl
• Created: 18/Sep/19 23:53
• Updated: 21/Dec/19 00:52
• Resolved: 10/Nov/19 16:40

Description

Script:

$ 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  |
+----+

 
Something is seriously broken.
Seems only when I build/run against latest HBase 1.5.0 SNAPSHOT. (not the one released to Maven)

apurtell, just FYI

Issue Links

• is related to: PHOENIX-5104 PHOENIX-3547 breaks client backwards compatability
• is related to: PHOENIX-3547 Promote CATALOG.VIEW_INDEX_ID to an int