[
https://issues.apache.org/jira/browse/PHOENIX-5208?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Toshihiro Suzuki updated PHOENIX-5208:
--------------------------------------
Description:
-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.
was:
-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, 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.
> 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)
