[
https://issues.apache.org/jira/browse/PHOENIX-3348?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Julian Jaffe updated PHOENIX-3348:
----------------------------------
Summary: SELECT DISTINCT with a non-rowkey array and another column returns
incorrect results (was: SELECT DISTINCT with a non-rowkey array and an id
returns incorrect results)
> SELECT DISTINCT with a non-rowkey array and another column returns incorrect
> results
> ------------------------------------------------------------------------------------
>
> Key: PHOENIX-3348
> URL: https://issues.apache.org/jira/browse/PHOENIX-3348
> Project: Phoenix
> Issue Type: Bug
> Affects Versions: 4.6.0
> Reporter: Julian Jaffe
>
> Attempting to select distinct combinations from an array and another column
> returns incorrect results if the columns are not part of the primary key.
> {code:sql}
> CREATE TABLE IF NOT EXISTS TEST.DESERTEST (COLONE BIGINT NOT NULL PRIMARY
> KEY, COLTWO BIGINT, COLTHREE BIGINT[]);
> No rows affected (1.368 seconds)
> UPSERT INTO TEST.DESERTEST VALUES (10, 7, ARRAY[1,2]);
> 1 row affected (0.161 seconds)
> SELECT DISTINCT COLTWO, COLTHREE FROM TEST.DESERTEST WHERE COLONE = 10;
> +------------------------------------------+------------------------------------------+
> | COLTWO | COLTHREE
> |
> +------------------------------------------+------------------------------------------+
> | -9223372036854677504 | []
> |
> +------------------------------------------+------------------------------------------+
> 1 row selected (0.367 seconds)
> SELECT COLTWO, COLTHREE FROM TEST.DESERTEST WHERE COLONE = 10;
> +------------------------------------------+------------------------------------------+
> | COLTWO | COLTHREE
> |
> +------------------------------------------+------------------------------------------+
> | 7 | [1, 2]
> |
> +------------------------------------------+------------------------------------------+
> 1 row selected (0.336 seconds)
> SELECT DISTINCT COLONE, COLTHREE FROM TEST.DESERTEST WHERE COLONE = 10;
> +------------------------------------------+------------------------------------------+
> | COLONE | COLTHREE
> |
> +------------------------------------------+------------------------------------------+
> | 10 | [1, 2]
> |
> +------------------------------------------+------------------------------------------+
> 1 row selected (0.32 seconds)
> {code}
> We've confirmed this bug in 4.6, and confirmed that it does not occur in 4.8,
> although I haven't been able to locate a corresponding JIRA. However, it will
> occur if using the 4.6 client to talk to 4.8, so it appears to be at least
> partially client-side.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
