You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@phoenix.apache.org by "Lars Hofhansl (JIRA)" <ji...@apache.org> on 2016/06/21 06:38:57 UTC
[jira] [Created] (PHOENIX-3014) SELECT DISTINCT pk ORDER BY pk DESC
gives the wrong results
Lars Hofhansl created PHOENIX-3014:
--------------------------------------
Summary: SELECT DISTINCT pk ORDER BY pk DESC gives the wrong results
Key: PHOENIX-3014
URL: https://issues.apache.org/jira/browse/PHOENIX-3014
Project: Phoenix
Issue Type: Bug
Reporter: Lars Hofhansl
{code}
create table T(pk1 varchar not null, pk2 varchar not null, constraint pk primary key(pk1, pk2)) SALT_BUCKETS=8;
upsert into T values('1','1');
upsert into T values('1','2');
upsert into T values('2','1');
select /*+ RANGE_SCAN */ distinct(pk1) from T order by pk1 desc;
+------+
| PK1 |
+------+
| 1 |
| 2 |
| 1 |
select distinct(pk1) from T order by pk1 desc;
+------+
| PK1 |
+------+
| 1 |
| 2 |
| 1 |
+------+
{code}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)