[ 
https://issues.apache.org/jira/browse/PHOENIX-127?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13937123#comment-13937123
 ] 

Hudson commented on PHOENIX-127:
--------------------------------

SUCCESS: Integrated in Apache Phoenix - Branch:3.0 #36 (See 
[https://builds.apache.org/job/Phoenix-3.0/36/])
PHOENIX-127 Query with pk IS NULL OR pk IN (1,2) return incorrect results 
(JamesTaylor) (jamestaylor: rev 9b034c03ac5579e2a945a57b40f97eeaa13ade02)
* 
phoenix-core/src/main/java/org/apache/phoenix/expression/ComparisonExpression.java
* phoenix-core/src/it/java/org/apache/phoenix/end2end/IsNullIT.java
* 
phoenix-core/src/it/java/org/apache/phoenix/end2end/TenantSpecificTablesDDLIT.java
* phoenix-core/src/main/java/org/apache/phoenix/compile/ExpressionCompiler.java
* phoenix-core/src/test/java/org/apache/phoenix/util/ScanUtilTest.java
* phoenix-core/src/main/java/org/apache/phoenix/query/KeyRange.java
* phoenix-core/src/it/java/org/apache/phoenix/end2end/QueryIT.java


> 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
>             Fix For: 3.0.0, 4.0.0
>
>         Attachments: PHOENIX-127.patch
>
>
> 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)

Reply via email to