[
https://issues.apache.org/jira/browse/PHOENIX-7760?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Viraj Jasani updated PHOENIX-7760:
----------------------------------
Summary: Incorrect scan range for RVC with overlapping constraints (was:
Incorrect scan range for RVC with overlapping constraint)
> Incorrect scan range for RVC with overlapping constraints
> ---------------------------------------------------------
>
> Key: PHOENIX-7760
> URL: https://issues.apache.org/jira/browse/PHOENIX-7760
> Project: Phoenix
> Issue Type: Bug
> Affects Versions: 5.3.0
> Reporter: Palash Chauhan
> Assignee: Viraj Jasani
> Priority: Major
>
> {code:java}
> CREATE TABLE test_table (
> hk VARCHAR NOT NULL,
> sk VARCHAR NOT NULL,
> ihk VARCHAR,
> isk VARCHAR,
> data VARCHAR
> CONSTRAINT pk PRIMARY KEY (hk, sk, ihk, isk)
> );{code}
> {code:java}
> -- Insert 20 rows with isk = isk01 through isk20
> UPSERT INTO test_table VALUES ('hk', 'sk100', 'idx', 'isk01', 'data01');
> UPSERT INTO test_table VALUES ('hk', 'sk100', 'idx', 'isk02', 'data01');
> ..
> UPSERT INTO test_table VALUES ('hk', 'sk100', 'idx', 'isk20', 'data01');{code}
> {code:java}
> -- This query WORKS correctly (returns rows after isk11):
> -- Scan "startRow":"hk\\x00sk100\\x00idx\\x00isk11\\x01"
> -- filter on non-PK row also works fine
> SELECT * FROM test_table
> WHERE hk = 'hk'
> AND (sk, ihk, isk) > ('sk100', 'idx', 'isk11')
> ORDER BY sk, ihk, isk LIMIT 5;{code}
> {code:java}
> -- This query FAILS (incorrectly includes row with isk11):
> -- Scan "startRow":"hk\\x00sk100\\x00idx\\x00isk11"
> SELECT * FROM test_table
> WHERE hk = 'hk'
> AND sk <= 'sk200'
> AND (sk, ihk, isk) > ('sk100', 'idx', 'isk11')
> ORDER BY sk, ihk, isk LIMIT 5;
> {code}
>
>
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
