[jira] [Created] (PHOENIX-127) Confirm pk IS NULL OR pk IN (1,2) returns correct results

["James Taylor (JIRA)" <ji...@apache.org>]

James Taylor created PHOENIX-127:
------------------------------------

             Summary: Confirm pk IS NULL OR pk IN (1,2) returns correct results
                 Key: PHOENIX-127
                 URL: https://issues.apache.org/jira/browse/PHOENIX-127
             Project: Phoenix
          Issue Type: Bug
            Reporter: James Taylor
            Assignee: James Taylor


Write unit tests for the following query:
{code}
SELECT count(*) FROM aTable 
WHERE organization_id=? 
AND (a_integer IN (5,6) OR a_integer IS NULL) 
GROUP BY a_integer=6
{code}
The GROUP BY is likely not relevant.




--
This message was sent by Atlassian JIRA
(v6.2#6252)