[
https://issues.apache.org/jira/browse/PHOENIX-5209?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16875889#comment-16875889
]
Hudson commented on PHOENIX-5209:
---------------------------------
FAILURE: Integrated in Jenkins build Phoenix-4.x-HBase-1.3 #459 (See
[https://builds.apache.org/job/Phoenix-4.x-HBase-1.3/459/])
PHOENIX-5209 Cannot add non-PK column to table when the last PK column
(s.kadam: rev e728720a8c7e8e50d5f464eabca1eea3ac476e86)
* (edit) phoenix-core/src/it/java/org/apache/phoenix/end2end/AlterTableIT.java
* (edit)
phoenix-core/src/main/java/org/apache/phoenix/schema/MetaDataClient.java
> Cannot add non-PK column to table when the last PK column is of type
> VARBINARY or ARRAY
> ---------------------------------------------------------------------------------------
>
> Key: PHOENIX-5209
> URL: https://issues.apache.org/jira/browse/PHOENIX-5209
> Project: Phoenix
> Issue Type: Bug
> Reporter: Toshihiro Suzuki
> Assignee: Toshihiro Suzuki
> Priority: Major
> Attachments: PHOENIX-5209.4.x-HBase-1.3.v1.patch,
> PHOENIX-5209.4.x-HBase-1.3.v2.patch, PHOENIX-5209.4.x-HBase-1.4.v1.patch,
> PHOENIX-5209.4.x-HBase-1.4.v2.patch, PHOENIX-5209.4.x-HBase-1.5.v1.patch,
> PHOENIX-5209.4.x-HBase-1.5.v2.patch, PHOENIX-5209.master.v1.patch,
> PHOENIX-5209.master.v2.patch
>
> Time Spent: 1.5h
> Remaining Estimate: 0h
>
> Let's see we have the following table:
> {code}
> CREATE TABLE tbl (id VARBINARY PRIMARY KEY, col1 INTEGER)
> {code}
> The type of the primary key of this table is VARBINARY.
> And when we alter this table to add a new column:
> {code}
> ALTER TABLE tbl ADD col2 INTEGER
> {code}
> we are facing the following error:
> {code}
> java.sql.SQLException: ERROR 1015 (42J04): Cannot add column to table when
> the last PK column is of type VARBINARY or ARRAY. columnName=ID
> {code}
> I think we should be able to do it without the above error because we don't
> try to add a PK column.
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
