[ 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 Updated unit test to repro this issue. > 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, 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)