[PHOENIX-3898] Empty result set after split with local index on multi-tenant table

• Type: Bug
• Status: Resolved
• Priority: Blocker
• Resolution: Fixed
• Fix Version/s: 4.11.0
• Labels: localIndex
• Assignee: Rajeshbabu Chintaguntla
• Reporter: Ankit Singhal
• Created: 31/May/17 09:09
• Updated: 10/Jun/17 06:56
• Resolved: 09/Jun/17 21:35

Description

While testing encounters this(seems related to PHOENIX-3832):-

CREATE TABLE IF NOT EXISTS TM (PKA CHAR(15) NOT NULL, PKF CHAR(3) NOT NULL,PKP CHAR(15) NOT NULL, CRD DATE NOT NULL, EHI CHAR(15) NOT NULL, FID CHAR(15), CREATED_BY_ID VARCHAR,FH VARCHAR, DT VARCHAR, OS VARCHAR, NS VARCHAR, OFN VARCHAR CONSTRAINT PK PRIMARY KEY ( PKA, PKF, PKP, CRD DESC, EHI ))  VERSIONS=1 ,MULTI_TENANT=true;
CREATE LOCAL INDEX IF NOT EXISTS TIDX ON TM (PKF, CRD, PKP, EHI);

0: jdbc:phoenix:localhost> select count(*) from tidx;
+-----------+
| COUNT(1)  |
+-----------+
| 300000    |
+-----------+

hbase(main):002:0> split 'TM'

0: jdbc:phoenix:localhost> select count(*) from tidx;
+-----------+
| COUNT(1)  |
+-----------+
| 0         |
+-----------+

Issue Links

• is related to: PHOENIX-3832 Local Index - Empty resultset for multi-tenant tables