You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@phoenix.apache.org by "Hudson (JIRA)" <ji...@apache.org> on 2014/03/26 10:27:14 UTC
[jira] [Commented] (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:comment-tabpanel&focusedCommentId=13947716#comment-13947716 ]
Hudson commented on PHOENIX-891:
--------------------------------
SUCCESS: Integrated in Apache Phoenix - Branch:3.0 #55 (See [https://builds.apache.org/job/Phoenix-3.0/55/])
PHOENIX-891 Multi-tenant - Upserting values without specifying columns names upserts values in wrong columns (JamesTaylor) (jamestaylor: rev 4cb1dcb56827888277c0be7dd07226adc57a3d31)
* phoenix-core/src/it/java/org/apache/phoenix/end2end/BaseTenantSpecificTablesIT.java
* phoenix-core/src/main/java/org/apache/phoenix/compile/UpsertCompiler.java
* phoenix-core/src/it/java/org/apache/phoenix/end2end/TenantSpecificTablesDMLIT.java
> 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)