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)