[PHOENIX-3014] SELECT DISTINCT pk ORDER BY pk DESC gives the wrong results with salted tables

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 4.8.0
• Assignee: James R. Taylor
• Reporter: Lars Hofhansl
• Created: 21/Jun/16 06:38
• Updated: 11/Aug/16 08:28
• Resolved: 21/Jun/16 23:13

Description

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    |
+------+