[ https://issues.apache.org/jira/browse/PHOENIX-4976?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Lars Hofhansl resolved PHOENIX-4976. ------------------------------------ Resolution: Duplicate > 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 > Priority: Major > Labels: DESC > Attachments: PHOENIX-4976-test.txt > > > 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)