[jira] [Created] (PHOENIX-5476) Multiple EMPTY_COLUMN cells exists when column families of include columns are different.

[Jacob Isaac (Jira)]

Jacob Isaac created PHOENIX-5476:
------------------------------------

             Summary: Multiple EMPTY_COLUMN cells exists when column families 
of include columns are different.
                 Key: PHOENIX-5476
                 URL: https://issues.apache.org/jira/browse/PHOENIX-5476
             Project: Phoenix
          Issue Type: Bug
    Affects Versions: 4.15.0
            Reporter: Jacob Isaac


To reproduce -

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

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

CREATE INDEX IF NOT EXISTS IDX_V_T000004 ON "TEST_ENTITY"."V_T000004"(COL4) 
INCLUDE (COL6) ;

CREATE VIEW IF NOT EXISTS "TEST_ENTITY"."0EC"(B.COL7 VARCHAR,COL8 VARCHAR,COL9 
VARCHAR) AS SELECT * FROM "TEST_ENTITY"."V_T000004" ;
CREATE INDEX IF NOT EXISTS IDX_0EC ON "TEST_ENTITY"."0EC"(COL9) INCLUDE (COL7) ;


UPSERT INTO "TEST_ENTITY"."0EC" 
(OID,ID,COL1,COL2,COL3,COL4,COL5,COL6,COL7,COL8,COL9) 
VALUES('o1','1','a','b','c','d','e','f','g','h','i');

scan "_IDX_TEST_ENTITY.T_T000004"

Multiple EMPTY_COLUMNS are created with different values
\x00\x00\x00\x00\x00\x00\x00\x00o1             d\x001                   
column=A:A:COL6, timestamp=1568578126086, value=f                               
                                                                                
                                                      
 \x00\x00\x00\x00\x00\x00\x00\x00o1             d\x001                   
column=A:_0, timestamp=1568578126086, value=x                                   
                                                                                
                                                      
 \x00\x00\x00\x00\x00\x00\x00\x00o1             d\x001                   
column=B:_0, timestamp=1568578126086, value=\x01                                
                                                                                
                                                      
 \x00\x00\x00\x00\x00\x00\x00\x01o1             i\x001                   
column=B:B:COL7, timestamp=1568578126086, value=g                               
                                                                                
                                                      
 \x00\x00\x00\x00\x00\x00\x00\x01o1             i\x001                   
column=B:_0, timestamp=1568578126086, value=\x01                                
                                                                                
                                                      






--
This message was sent by Atlassian Jira
(v8.3.2#803003)