[jira] [Created] (PHOENIX-6659) RVC with AND clauses return incorrect result

[Xinyi Yan (Jira)]

Xinyi Yan created PHOENIX-6659:
----------------------------------

             Summary: RVC with AND clauses return incorrect result
                 Key: PHOENIX-6659
                 URL: https://issues.apache.org/jira/browse/PHOENIX-6659
             Project: Phoenix
          Issue Type: Bug
    Affects Versions: 4.16.1
            Reporter: Xinyi Yan
         Attachments: Screen Shot 2022-03-01 at 1.26.44 PM.png

CREATE TABLE DUMMY (PK1 VARCHAR NOT NULL, PK2 BIGINT NOT NULL, PK3 BIGINT NOT 
NULL CONSTRAINT PK PRIMARY KEY (PK1,PK2,PK3));

UPSERT INTO DUMMY VALUES ('a',0,1);
UPSERT INTO DUMMY VALUES ('a',1,1);
UPSERT INTO DUMMY VALUES ('a',2,1);
UPSERT INTO DUMMY VALUES ('a',3,1);
UPSERT INTO DUMMY VALUES ('a',3,2);
UPSERT INTO DUMMY VALUES ('a',4,1);

SELECT * FROM DUMMY WHERE (PK1 = 'a') AND (PK1,PK2,PK3) <= ('a',3,1);

 

!Screen Shot 2022-03-01 at 1.26.44 PM.png!



--
This message was sent by Atlassian Jira
(v8.20.1#820001)