[ https://issues.apache.org/jira/browse/PHOENIX-5209?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Toshihiro Suzuki updated PHOENIX-5209: -------------------------------------- Attachment: PHOENIX-5209.master.v1.patch > 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.master.v1.patch > > Time Spent: 1h 10m > 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)