[jira] [Created] (PHOENIX-3954) Message displayed during "Alter view" is not correct

["Ethan Wang (JIRA)" <ji...@apache.org>]

Ethan Wang created PHOENIX-3954:
-----------------------------------

             Summary: Message displayed during "Alter view" is not correct 
                 Key: PHOENIX-3954
                 URL: https://issues.apache.org/jira/browse/PHOENIX-3954
             Project: Phoenix
          Issue Type: Bug
    Affects Versions: 4.8.0
         Environment: MacOS. Phoenix 4.8. Java 1.8
            Reporter: Ethan Wang
            Priority: Minor


When "Alter view" command failed, the error message refer view as "TABLE." example below:

ALTER VIEW V_T000002 ADD k3 VARCHAR PRIMARY KEY, k2 VARCHAR PRIMARY KEY, v2 INTEGER;


Error: ERROR 514 (42892): A duplicate column name was detected in the object definition or ALTER TABLE statement. columnName=V_T000002.K2 (state=42892,code=514)
org.apache.phoenix.schema.ColumnAlreadyExistsException: ERROR 514 (42892): A duplicate column name was detected in the object definition or ALTER TABLE statement. columnName=V_T000002.K2
	at org.apache.phoenix.schema.MetaDataClient.addColumn(MetaDataClient.java:3557)
	at org.apache.phoenix.schema.MetaDataClient.addColumn(MetaDataClient.java:3124)
	at org.apache.phoenix.jdbc.PhoenixStatement$ExecutableAddColumnStatement$1.execute(PhoenixStatement.java:1342)
	at org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:393)
	at org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:376)
	at org.apache.phoenix.call.CallRunner.run(CallRunner.java:53)
	at org.apache.phoenix.jdbc.PhoenixStatement.executeMutation(PhoenixStatement.java:375)
	at org.apache.phoenix.jdbc.PhoenixStatement.executeMutation(PhoenixStatement.java:363)
	at org.apache.phoenix.jdbc.PhoenixStatement.execute(PhoenixStatement.java:1707)
	at sqlline.Commands.execute(Commands.java:822)
	at sqlline.Commands.sql(Commands.java:732)
	at sqlline.SqlLine.dispatch(SqlLine.java:813)
	at sqlline.SqlLine.begin(SqlLine.java:686)
	at sqlline.SqlLine.start(SqlLine.java:398)
	at sqlline.SqlLine.main(SqlLine.java:291)




--
This message was sent by Atlassian JIRA
(v6.4.14#64029)