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

• Type: Bug
• Status: Patch Available
• Priority: Major
• Resolution: Unresolved
• Assignee: Toshihiro Suzuki
• Reporter: Toshihiro Suzuki
• Created: 23/Mar/19 00:28
• Updated: 02/Dec/19 06:01

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.

Issue Links

• relates to: PHOENIX-1614 ALTER TABLE ADD IF NOT EXISTS doesn't work as expected