You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@phoenix.apache.org by "James Taylor (JIRA)" <ji...@apache.org> on 2014/03/13 20:07:56 UTC
[jira] [Updated] (PHOENIX-127) Query with pk IS NULL OR pk IN (1,2)
return incorrect results
[ https://issues.apache.org/jira/browse/PHOENIX-127?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
James Taylor updated PHOENIX-127:
---------------------------------
Summary: Query with pk IS NULL OR pk IN (1,2) return incorrect results (was: Confirm pk IS NULL OR pk IN (1,2) returns correct results)
> Query with pk IS NULL OR pk IN (1,2) return incorrect results
> -------------------------------------------------------------
>
> Key: PHOENIX-127
> URL: https://issues.apache.org/jira/browse/PHOENIX-127
> Project: Phoenix
> Issue Type: Bug
> Affects Versions: 3.0.0, 4.0.0
> 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)