[jira] [Created] (PHOENIX-5209) Cannot add non-PK column to table when the last PK column is of type VARBINARY or ARRAY

[Toshihiro Suzuki (JIRA)]

Toshihiro Suzuki created PHOENIX-5209:
-----------------------------------------

             Summary: 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


Let's see we have the following table:
{code}
CREATE TABLE tbl (id VARBINARY PRIMARY KEY, col1 INTEGER)
{code}

The type of the primary kay 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)