You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@phoenix.apache.org by "Chinmay Kulkarni (Jira)" <ji...@apache.org> on 2019/12/21 00:53:02 UTC
[jira] [Closed] (PHOENIX-5486) Projections from local indexes
return garbage.
[ https://issues.apache.org/jira/browse/PHOENIX-5486?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Chinmay Kulkarni closed PHOENIX-5486.
-------------------------------------
Bulk closing Jiras for the 4.15.0 release.
> Projections from local indexes return garbage.
> ----------------------------------------------
>
> Key: PHOENIX-5486
> URL: https://issues.apache.org/jira/browse/PHOENIX-5486
> Project: Phoenix
> Issue Type: Bug
> Reporter: Lars Hofhansl
> Assignee: Lars Hofhansl
> Priority: Blocker
> Fix For: 4.15.0, 5.1.0
>
> Attachments: 5486-4.x-hbase-1.5.txt, 5486-fix.txt, 5486-test.txt, 5486-v2-4.x-HBase-1.5.txt, 5486-v3-4.x-HBase-1.5.txt, 5486-v4-4.x-HBase-1.5.txt, 5486-v5-4.x-HBase-1.5.txt
>
>
> 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 HBase 1.5.0 SNAPSHOT. (not the one released to Maven)-
> [~apurtell], just FYI
--
This message was sent by Atlassian Jira
(v8.3.4#803005)