[PHOENIX-3832] Local Index - Empty resultset for multi-tenant tables

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 4.10.0
• Fix Version/s: 4.11.0
• Labels: localIndex
• Assignee: James R. Taylor
• Reporter: Mujtaba Chohan
• Created: 05/May/17 18:57
• Updated: 10/Jun/17 02:07
• Resolved: 17/May/17 01:10

Description

Schema

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

Query

SELECT * FROM T WHERE INDEXED_COL < 1

Resultset is empty for all columns other than PK and indexed column. This is on a single region table.

Issue Links

• relates to: PHOENIX-3898 Empty result set after split with local index on multi-tenant table