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

Hudson commented on PHOENIX-2455:
---------------------------------

SUCCESS: Integrated in Phoenix-master #1022 (See 
[https://builds.apache.org/job/Phoenix-master/1022/])
PHOENIX-2455 Partial results for a query when PHOENIX-2194 is applied (jtaylor: 
rev e6ae7465ace8ccf281c175b8e44d105f5072d485)
* phoenix-core/src/test/java/org/apache/phoenix/filter/SkipScanFilterTest.java
* phoenix-core/src/main/java/org/apache/phoenix/filter/SkipScanFilter.java
* phoenix-core/src/it/java/org/apache/phoenix/end2end/SkipScanQueryIT.java
* phoenix-core/src/main/java/org/apache/phoenix/util/ScanUtil.java
* phoenix-core/src/main/java/org/apache/phoenix/query/KeyRange.java


> Partial results for a query when PHOENIX-2194 is applied
> --------------------------------------------------------
>
>                 Key: PHOENIX-2455
>                 URL: https://issues.apache.org/jira/browse/PHOENIX-2455
>             Project: Phoenix
>          Issue Type: Bug
>            Reporter: Ankit Singhal
>            Assignee: James Taylor
>             Fix For: 4.7.0
>
>         Attachments: PHOENIX-2455.patch, PHOENIX-2455_UT.patch
>
>
> Hi [~giacomotaylor],
> can you please look into the below test case, why it is failing after 
> applying PHOENIX-2194
> {code}
> drop table test;
> CREATE TABLE IF NOT EXISTS Test
>  (col1 VARCHAR,  
>  col2 VARCHAR,  
>  col3 VARCHAR,  
>  col4 UNSIGNED_LONG NOT NULL,   
>  CONSTRAINT pk  
>  PRIMARY KEY (col1,col2,col3,col4));
> upsert into test values('a','b','',1);
> upsert into test values('e.f','b','',1);
> upsert into test values('f.g','b','',1);
> upsert into test values('g.h','b','',1);
> upsert into test values('f','b','',1);
> upsert into test values('h.e','b','',1);
> SELECT  col1, col2, col3, col4 FROM test WHERE (col1 IN 
> ('a','e','f','g','h')) AND col2 = 'b' AND col4 >= 0 AND col4 < 2 ;
> {code}
> expected(AND getting without PHOENIX-2194);- 
> |                   COL1                   |                   COL2           
>         |                   COL3                   |                   COL4   
>                 |
> | a                                        | b                                
>         |                                          | 1                        
>                 |
> | f                                        | b                                
>         |                                          | 1                        
>                 |
> Getting with PHOENIX-2194(Which is partial).
> |                   COL1                   |                   COL2           
>         |                   COL3                   |                   COL4   
>                 |
> | a                                        | b                                
>         |                                          | 1                        
>                 |



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Reply via email to