phoenix-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jacob Isaac (Jira)" <j...@apache.org>
Subject [jira] [Created] (PHOENIX-5589) GlobalIndexChecker does not populate global index related attributes for certain queries
Date Tue, 26 Nov 2019 01:02:20 GMT
Jacob Isaac created PHOENIX-5589:
------------------------------------

             Summary: GlobalIndexChecker does not populate global index related attributes
for certain queries
                 Key: PHOENIX-5589
                 URL: https://issues.apache.org/jira/browse/PHOENIX-5589
             Project: Phoenix
          Issue Type: Bug
    Affects Versions: 4.15.0
            Reporter: Jacob Isaac


To reproduce:

CREATE TABLE IF NOT EXISTS "TEST_ENTITY"."T_T000001"(OID CHAR(15) NOT NULL,KP CHAR(3) NOT
NULL, COL1 VARCHAR,COL2 VARCHAR,COL3 VARCHAR CONSTRAINT pk PRIMARY KEY (OID,KP)) COLUMN_ENCODED_BYTES=0,
MULTI_TENANT=true,DEFAULT_COLUMN_FAMILY='Z';


CREATE VIEW IF NOT EXISTS "TEST_ENTITY"."V_T000001"(ID CHAR(15) NOT NULL,COL4 VARCHAR,COL5
VARCHAR,COL6 VARCHAR CONSTRAINT pk PRIMARY KEY (ID)) AS SELECT * FROM "TEST_ENTITY"."T_T000001"
WHERE KP = '0EC';

CREATE INDEX IF NOT EXISTS IDX_V_T000001 ON "TEST_ENTITY"."V_T000001"(COL4) INCLUDE (COL6)
;

CREATE VIEW IF NOT EXISTS "TEST_ENTITY"."0EC"(ZID CHAR(15),COL7 VARCHAR,COL8 VARCHAR,COL9
VARCHAR) AS SELECT * FROM "TEST_ENTITY"."V_T000001";

UPSERT INTO "TEST_ENTITY"."0EC" (ZID,ID,COL4,COL5,COL6) VALUES('z1','1','g1','h1','i1');
UPSERT INTO "TEST_ENTITY"."0EC" (ZID,ID,COL4,COL5,COL6) VALUES('z2','2','g2','h2','i2');
UPSERT INTO "TEST_ENTITY"."0EC" (ZID,ID,COL4,COL5,COL6) VALUES('z3','3','g3','h3','i3');
UPSERT INTO "TEST_ENTITY"."0EC" (ZID,ID,COL4,COL5,COL6) VALUES('z4','4','g4','h4','i4');
UPSERT INTO "TEST_ENTITY"."0EC" (ZID,ID,COL4,COL5,COL6) VALUES('z5','5','g5','h5','i5');


When running the following queries (COL6 is the included col, COL4 is the indexed column)

select COL6 from "TEST_ENTITY"."0EC" where COL4 = 'g3';

The scan attributes are not properly set. (i.e for eg CHECK_VERIFY_COLUMN is not set)

[~kadir]



--
This message was sent by Atlassian Jira
(v8.3.4#803005)

Mime
View raw message