Joel Palmert created PHOENIX-3382:
-------------------------------------
Summary: Paging with Row Value Constructors is broken
Key: PHOENIX-3382
URL: https://issues.apache.org/jira/browse/PHOENIX-3382
Project: Phoenix
Issue Type: Bug
Affects Versions: 4.8.0
Reporter: Joel Palmert
Priority: Critical
I'm trying to use Row Value Constructors to do paging in a query in the below
table:
# TABLE #
CREATE TABLE IF NOT EXISTS COMMUNITIES.TEST (
ORGANIZATION_ID CHAR(15) NOT NULL,
SCORE DOUBLE NOT NULL,
ENTITY_ID CHAR(15) NOT NULL
CONSTRAINT TEST_PK PRIMARY KEY (
ORGANIZATION_ID,
SCORE DESC,
ENTITY_ID DESC
)
) VERSIONS=1, MULTI_TENANT=TRUE, REPLICATION_SCOPE=1, TTL=43200
UPSERT INTO COMMUNITIES.TEST VALUES ('org1',3,'01');
UPSERT INTO COMMUNITIES.TEST VALUES ('org1',2,'04');
UPSERT INTO COMMUNITIES.TEST VALUES ('org1',2,'03');
UPSERT INTO COMMUNITIES.TEST VALUES ('org1',1,'02');
# QUERY #
SELECT entity_id, score
FROM communities.test
WHERE organization_id = 'org1'
AND (score, entity_id) < (2, '04')
ORDER BY score DESC, entity_id DESC
LIMIT 3
I'm specifying the score and entity_id of the second row so I'm expecting it to
return the 2 last values (with id 03 and 02). However, it returns the 3 first
values (and if it wasn't for the LIMIT 3 it would just return all).
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
