phoenix-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Lars Hofhansl (Jira)" <j...@apache.org>
Subject [jira] [Updated] (PHOENIX-5486) Projections from local indexes are broken.
Date Thu, 19 Sep 2019 16:20:00 GMT

     [ https://issues.apache.org/jira/browse/PHOENIX-5486?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Lars Hofhansl updated PHOENIX-5486:
-----------------------------------
    Description: 
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

  was:
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]


> Projections from local indexes are broken.
> ------------------------------------------
>
>                 Key: PHOENIX-5486
>                 URL: https://issues.apache.org/jira/browse/PHOENIX-5486
>             Project: Phoenix
>          Issue Type: Bug
>            Reporter: Lars Hofhansl
>            Priority: Blocker
>         Attachments: 5486-test.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)

Mime
View raw message