[ 
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:02 AM:
---------------------------------------------------------------------

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?


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

> 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, DROP COLUMN IF EXISTS doesn't work as expected.
> Executing "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)

Reply via email to