Gabriel Reid created PHOENIX-1614:
-------------------------------------
Summary: ALTER TABLE ADD IF NOT EXISTS doesn't work as expected
Key: PHOENIX-1614
URL: https://issues.apache.org/jira/browse/PHOENIX-1614
Project: Phoenix
Issue Type: Bug
Reporter: Gabriel Reid
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
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
