[
https://issues.apache.org/jira/browse/PHOENIX-1083?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
James Taylor updated PHOENIX-1083:
----------------------------------
Attachment: InListIT.java
Attaching simple test case. Based on my debugging, the skip scan *is not* being
used, so that part is WAD. Note that it's possible that the skip scan could be
used, but if the user can also re-write the query to put all columns in the RVC
and then it will be used.
Instead, the bug appears to be an issue with the evaluation of an IN in
combination with a RVC. Will debug further and hopefully have a fix later this
afternoon.
> IN list of RVC combined with AND doesn't return expected rows
> -------------------------------------------------------------
>
> Key: PHOENIX-1083
> URL: https://issues.apache.org/jira/browse/PHOENIX-1083
> Project: Phoenix
> Issue Type: Bug
> Affects Versions: 3.0.0, 4.0.0, 5.0.0
> Reporter: Samarth Jain
> Assignee: James Taylor
> Attachments: InListIT.java
>
>
> {code}
> CREATE TABLE in_test ( user VARCHAR, tenant_id VARCHAR(5) NOT
> NULL,tenant_type_id VARCHAR(3) NOT NULL, id INTEGER NOT NULL CONSTRAINT pk
> PRIMARY KEY (tenant_id, tenant_type_id, id))
> upsert into in_test (tenant_id, tenant_type_id, id, user) values ('a', 'a',
> 1, 'BonA')
> upsert into in_test (tenant_id, tenant_type_id, id, user) values ('a', 'a',
> 2, 'BonB')
> select id from in_test WHERE tenant_id = 'a' and tenant_type_id = 'a' and
> ((id, user) IN ((1, 'BonA'),(1, 'BonA')))
> Rows returned - none. Should have returned one row.
> {code}
--
This message was sent by Atlassian JIRA
(v6.2#6252)
