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)