Mujtaba Chohan created PHOENIX-891:
--------------------------------------

             Summary: Multi-tenant - Upserting values without specifying 
columns names upserts values in wrong columns
                 Key: PHOENIX-891
                 URL: https://issues.apache.org/jira/browse/PHOENIX-891
             Project: Phoenix
          Issue Type: Bug
    Affects Versions: 3.0.0, 4.0.0
            Reporter: Mujtaba Chohan
            Assignee: James Taylor
             Fix For: 3.0.0, 4.0.0


Base table:
CREATE TABLE base.mt (tenant_id VARCHAR not null, event_type VARCHAR not null, 
mycol varchar CONSTRAINT pk PRIMARY KEY(tenant_id,event_type)) 
MULTI_TENANT=true;

Tenant specific table:
CREATE VIEW acme.mt AS SELECT * FROM base.mt;

Upsert statement:
upsert into acme.mt values ('foo','bar')

Result:
Values are upserted in wrong columns:
tenant_id: foo, event_id: bar, mycol: acme



--
This message was sent by Atlassian JIRA
(v6.2#6252)

Reply via email to