[jira] [Created] (PHOENIX-1083) IN liar of RVC combined with AND doesn't return expected rows

["Samarth Jain (JIRA)" <ji...@apache.org>]

Samarth Jain created PHOENIX-1083:
-------------------------------------

             Summary: IN liar 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


{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)