phoenix-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Toshihiro Suzuki (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (PHOENIX-5209) Cannot add non-PK column to table when the last PK column is of type VARBINARY or ARRAY
Date Fri, 14 Jun 2019 02:16:00 GMT

     [ 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.4.x-HBase-1.5.v2.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.4.x-HBase-1.3.v1.patch, PHOENIX-5209.4.x-HBase-1.4.v1.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: 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)

Mime
View raw message