Mujtaba Chohan created PHOENIX-3832:
---------------------------------------
Summary: Local Index - Empty resultset for multi-tenant tables
Key: PHOENIX-3832
URL: https://issues.apache.org/jira/browse/PHOENIX-3832
Project: Phoenix
Issue Type: Bug
Affects Versions: 4.10.0
Reporter: Mujtaba Chohan
Assignee: Rajeshbabu Chintaguntla
Fix For: 4.11
Schema
{noformat}
CREATE TABLE IF NOT EXISTS T (PKA CHAR(15) NOT NULL, PKF CHAR(3) NOT NULL,
PKP CHAR(15) NOT NULL, CRD DATE NOT NULL, EHI CHAR(15) NOT NULL, STD_COL
VARCHAR, INDEXED_COL INTEGER,
CONSTRAINT PK PRIMARY KEY ( PKA, PKF, PKP, CRD DESC, EHI))
VERSIONS=1,MULTI_TENANT=true,IMMUTABLE_ROWS=true;
CREATE LOCAL INDEX IF NOT EXISTS TIDX ON T (INDEXED_COL);
{noformat}
Query
{noformat}
SELECT * FROM T WHERE INDEXED_COL < 1
{noformat}
Resultset is empty for all columns other than PK and indexed column. This is on
a single region table.
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
