You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@phoenix.apache.org by "Hudson (JIRA)" <ji...@apache.org> on 2014/03/16 14:02:44 UTC
[jira] [Commented] (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: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)