Biju Nair created PHOENIX-2809:
----------------------------------
Summary: Alter table doesn't take into account current table
definition
Key: PHOENIX-2809
URL: https://issues.apache.org/jira/browse/PHOENIX-2809
Project: Phoenix
Issue Type: Bug
Reporter: Biju Nair
{{Alter table}} to add a new column with the column definition as an existing
column in the table succeeds while the expectation will be that the alter will
fail. Following is an example.
{noformat}
0: jdbc:phoenix:localhost:2181:/hbase> create table test_alter (TI tinyint not
null primary key);
No rows affected (1.299 seconds)
0: jdbc:phoenix:localhost:2181:/hbase> alter table test_alter add if not exists
TI tinyint, col1 varchar;
No rows affected (15.962 seconds)
0: jdbc:phoenix:localhost:2181:/hbase> upsert into test_alter values
(1,2,'add');
1 row affected (0.008 seconds)
0: jdbc:phoenix:localhost:2181:/hbase> select * from test_alter;
+-----+-----+-------+
| TI | TI | COL1 |
+-----+-----+-------+
| 1 | 1 | add |
+-----+-----+-------+
{noformat}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
