[jira] [Created] (PHOENIX-2455) Partial results for a query when PHOENIX-2194 is applied

["Ankit Singhal (JIRA)" <ji...@apache.org>]

Ankit Singhal created PHOENIX-2455:
--------------------------------------

             Summary: 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


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)