You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@phoenix.apache.org by "James Taylor (JIRA)" <ji...@apache.org> on 2014/03/26 16:25:15 UTC
[jira] [Resolved] (PHOENIX-891) Multi-tenant - Upserting values
without specifying columns names upserts values in wrong columns
[ 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)