phoenix-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Lars Hofhansl (JIRA)" <j...@apache.org>
Subject [jira] [Created] (PHOENIX-4976) Comparisson on RVC are still incorrect
Date Tue, 16 Oct 2018 16:42:00 GMT
Lars Hofhansl created PHOENIX-4976:
--------------------------------------

             Summary: Comparisson on RVC are still incorrect
                 Key: PHOENIX-4976
                 URL: https://issues.apache.org/jira/browse/PHOENIX-4976
             Project: Phoenix
          Issue Type: Bug
            Reporter: Lars Hofhansl


See PHOENIX-3383

{code}
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);
{code}

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

{code}
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  |
+-----+-----+-----+----+
{code}

{code}
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  |
+-----+-----+-----+----+
{code}

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)



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

Mime
View raw message