[jira] [Comment Edited] (PHOENIX-5208) ALTER TABLE DROP COLUMN IF EXISTS doesn't work as expected

["Toshihiro Suzuki (Jira)" <ji...@apache.org>]

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

Toshihiro Suzuki edited comment on PHOENIX-5208 at 10/21/19 3:04 AM:
---------------------------------------------------------------------

It looks like ALTER TABLE DROP COLUMN IF EXISTS works as expected unlike ALTER TABLE ADD IF NOT EXISTS. I just added UT code in the patch. Could someone please review it?


was (Author: brfrn169):
It looks like DROP COLUMN IF EXISTS works as expected unlike ALTER TABLE ADD IF NOT EXISTS. I just added UT code in the patch. Could someone please review it?

> ALTER TABLE DROP COLUMN IF EXISTS doesn't work as expected
> ----------------------------------------------------------
>
>                 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.



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