[
https://issues.apache.org/jira/browse/PHOENIX-1083?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14073850#comment-14073850
]
Hudson commented on PHOENIX-1083:
---------------------------------
SUCCESS: Integrated in Phoenix | 3.0 | Hadoop1 #147 (See
[https://builds.apache.org/job/Phoenix-3.0-hadoop1/147/])
PHOENIX-1083 IN list of RVC combined with AND doesn't return expected rows
(jtaylor: rev d38c9f99a66f9beb97b43ec8974e9c1ffd1025f0)
* phoenix-core/src/test/java/org/apache/phoenix/compile/ScanRangesTest.java
*
phoenix-core/src/it/java/org/apache/phoenix/end2end/SkipRangeParallelIteratorRegionSplitterIT.java
* phoenix-core/src/main/java/org/apache/phoenix/query/KeyRange.java
* phoenix-core/src/it/java/org/apache/phoenix/end2end/QueryMoreIT.java
* phoenix-core/src/main/java/org/apache/phoenix/util/ScanUtil.java
* phoenix-core/src/main/java/org/apache/phoenix/filter/SkipScanFilter.java
* phoenix-core/src/test/java/org/apache/phoenix/util/ScanUtilTest.java
* phoenix-core/src/main/java/org/apache/phoenix/compile/WhereOptimizer.java
* phoenix-core/src/main/java/org/apache/phoenix/index/PhoenixIndexBuilder.java
* phoenix-core/src/main/java/org/apache/phoenix/compile/ScanRanges.java
* phoenix-core/src/main/java/org/apache/phoenix/util/IndexUtil.java
* phoenix-core/src/it/java/org/apache/phoenix/end2end/InListIT.java
* phoenix-core/src/test/java/org/apache/phoenix/compile/WhereOptimizerTest.java
> IN list 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
> Fix For: 5.0.0, 3.1, 4.1
>
> Attachments: InListIT.java, InListIT.java, PHOENIX-1083_3.0.patch,
> PHOENIX-1083_3.0_additionaltests.patch,
> PHOENIX-1083_AdditionalInListIT.patch, rvcBug-v1.patch, rvcBug-wip2.patch,
> rvcBug-wip3.patch
>
>
> {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)
