[PHOENIX-1614] ALTER TABLE ADD IF NOT EXISTS doesn't work as expected

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 4.15.0, 5.1.0
• Labels: argus
• Assignee: Toshihiro Suzuki
• Reporter: Gabriel Reid
• Created: 28/Jan/15 19:44
• Updated: 15/Jan/21 09:05
• Resolved: 24/Mar/19 01:19

Description

On an existing table table, executing "ALTER TABLE ADD IF NOT EXISTS
thisColAlreadyExists varchar, thisColDoesNotExist varchar", then
nothing will be changed in the table because thisColAlreadyExists
already exists.

Omitting the already-existing column from the statement, all new columns
do get created.

The general expectation would be that when you use ADD IF NOT EXISTS, all
non-existent columns will be added, and all existing columns in the
statement will just be ignored. There is already an integration test
(AlterTableIT#testAddVarCols) that actually demonstrates the current
behavior, although this is probably not correct.

As pointed out in the related mailing list thread [1], ALTER TABLE DROP COLUMN likely suffers from the same issue.

1. http://s.apache.org/LMT

Issue Links

• is related to: PHOENIX-5208 Add a test case of "ALTER TABLE DROP COLUMN IF EXISTS" with multiple columns