[
https://issues.apache.org/jira/browse/PHOENIX-4971?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16654569#comment-16654569
]
Geoffrey Jacoby commented on PHOENIX-4971:
------------------------------------------
The error message you added says "Disallow drop this table which has the same
name with parent tables", but the check appears to be broader than that. It
verifies that the parent table mentioned in the DROP statement matches the
parent table of the actual index. That broader check is better, but the error
message should match it.
> Drop index will execute successfully using Incorrect name of parent tables
> --------------------------------------------------------------------------
>
> Key: PHOENIX-4971
> URL: https://issues.apache.org/jira/browse/PHOENIX-4971
> Project: Phoenix
> Issue Type: Bug
> Reporter: Jaanai
> Assignee: Jaanai
> Priority: Critical
> Attachments: PHOENIX-4971-master.patch
>
>
> The blew SQL will be executed successfully, the name of data tables is
> incorrectly inputted that the parent table has the same name with index
> tables.
>
> {code:java}
> DROP INDEX INDEX_TABLE_X on INDEX_TABLE_X;
> {code}
> Some regions will not online and some queries will not normally execute after
> executing above SQL. Everything will be ok unless manually delete dirty
> metadata information in SYSTEM.CATALOG table.
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
