You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@phoenix.apache.org by "Toshihiro Suzuki (Jira)" <ji...@apache.org> on 2019/12/02 06:02:00 UTC

[jira] [Commented] (PHOENIX-5208) Add a test case of "ALTER TABLE DROP COLUMN IF EXISTS" with multiple columns

    [ https://issues.apache.org/jira/browse/PHOENIX-5208?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16985840#comment-16985840 ] 

Toshihiro Suzuki commented on PHOENIX-5208:
-------------------------------------------

[~swaroopa] Could you please review this patch?

> Add a test case of "ALTER TABLE DROP COLUMN IF EXISTS" with multiple columns
> ----------------------------------------------------------------------------
>
>                 Key: PHOENIX-5208
>                 URL: https://issues.apache.org/jira/browse/PHOENIX-5208
>             Project: Phoenix
>          Issue Type: Bug
>            Reporter: Toshihiro Suzuki
>            Assignee: Toshihiro Suzuki
>            Priority: Major
>         Attachments: PHOENIX-5208.master.v1.patch
>
>
> -Similar to PHOENIX-1614, ALTER TABLE DROP COLUMN IF EXISTS doesn't work as expected.-
> -Executing "ALTER TABLE DROP COLUMN IF EXISTS colAlreadyExists, colDoesNotExist", then nothing will be changed in the table because colDoesNotExist doesn't exists.-
> -The general expectation would be all non-existing columns in the statement will be just ignored.-
>  
> Unlike ALTER TABLE ADD IF NOT EXISTS (see PHOENIX-1614 for details), ALTER TABLE DROP COLUMN IF EXISTS works as expected. In this Jira, just add UT code for "ALTER TABLE DROP COLUMN IF EXISTS" with multiple columns.



--
This message was sent by Atlassian Jira
(v8.3.4#803005)