[jira] [Created] (PHOENIX-3014) SELECT DISTINCT pk ORDER BY pk DESC gives the wrong results

[Lars Hofhansl (JIRA)]

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)