[
https://issues.apache.org/jira/browse/PHOENIX-891?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
James Taylor resolved PHOENIX-891.
----------------------------------
Resolution: Fixed
> 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)
