[PHOENIX-4976] Comparisson on RVC are still incorrect

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Duplicate
• Labels: DESC
• Assignee: Unassigned
• Reporter: Lars Hofhansl
• Created: 16/Oct/18 16:41
• Updated: 22/Oct/18 19:17
• Resolved: 22/Oct/18 19:17

Description

See PHOENIX-3383

create table test(k1 integer not null, k2 integer not null, k3 integer not null, v integer, constraint pk primary key (k1, k2 desc, k3));

upsert into test values(1,1,1,2);
upsert into test values(1,2,1,2);
upsert into test values(1,3,1,2);
upsert into test values(1,4,1,2);

select * from test where (k1, k2, k3) = (1,2,1) order by k1, k2 desc, k3;
+-----+-----+-----+----+
| K1  | K2  | K3  | V  |
+-----+-----+-----+----+
| 1   | 2   | 1   | 2  |
+-----+-----+-----+----+

select * from test where (k1, k2, k3) > (1,2,1) order by k1, k2 desc, k3;
+-----+-----+-----+----+
| K1  | K2  | K3  | V  |
+-----+-----+-----+----+
| 1   | 4   | 1   | 2  |
| 1   | 3   | 1   | 2  |
| 1   | 2   | 1   | 2  |
| 1   | 1   | 1   | 2  |
+-----+-----+-----+----+

select * from test where (k1, k2, k3) < (1,2,1) order by k1, k2 desc, k3;
+-----+-----+-----+----+
| K1  | K2  | K3  | V  |
+-----+-----+-----+----+
| 1   | 4   | 1   | 2  |
| 1   | 3   | 1   | 2  |
| 1   | 2   | 1   | 2  |
| 1   | 1   | 1   | 2  |
+-----+-----+-----+----+

Looks like in this case each > or < comparison will simply return all rows. This does not happen when the second key part is not descending.

Edit: > and < return all rows with the same first key part (k1)

Issue Links

• is duplicated by: PHOENIX-4841 Filters that uses RVC with pk columns where with DESC sort order don't work correctly
• is related to: PHOENIX-3383 Comparison between descending row keys used in RVC is reverse