Ankit Singhal created PHOENIX-3898:
--------------------------------------
Summary: Empty result set after split with local index on
multi-tenant table
Key: PHOENIX-3898
URL: https://issues.apache.org/jira/browse/PHOENIX-3898
Project: Phoenix
Issue Type: Bug
Reporter: Ankit Singhal
Fix For: 4.11.0
While testing encounters this(seems related to PHOENIX-3832):-
{code}
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);
{code}
{code}
0: jdbc:phoenix:localhost> select count(*) from tidx;
+-----------+
| COUNT(1) |
+-----------+
| 300000 |
+-----------+
{code}
{code}
hbase(main):002:0> split 'T
{code}
{code}
0: jdbc:phoenix:localhost> select count(*) from tidx;
+-----------+
| COUNT(1) |
+-----------+
| 0 |
+-----------+
{code}
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
