phoenix-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Ankit Singhal (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (PHOENIX-2455) Partial results for a query when PHOENIX-2194 is applied
Date Fri, 11 Dec 2015 06:52:10 GMT

     [ https://issues.apache.org/jira/browse/PHOENIX-2455?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Ankit Singhal updated PHOENIX-2455:
-----------------------------------
    Attachment: PHOENIX-2455_UT.patch

[~jamestaylor], PFA a patch with unit test case.

> 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_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)

Mime
View raw message