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