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-5208) Add a test case of "ALTER TABLE DROP COLUMN IF EXISTS" with multiple columns
Date Mon, 21 Oct 2019 03:11:00 GMT

     [ 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)

Mime
View raw message