You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by GitBox <gi...@apache.org> on 2022/08/18 07:52:04 UTC
[GitHub] [shardingsphere] novice-gamer opened a new issue, #20266: Error deleting index
novice-gamer opened a new issue, #20266:
URL: https://github.com/apache/shardingsphere/issues/20266
Using version shardingsphere proxy 5.1.3
The index cannot be deleted when it is deleted, and an error is reported.
sql:
```
drop index complex_index on bid_purchaser_info_dis_approval_pro;
```
log:
```
[INFO ] 2022-08-18 15:41:36.864 [ShardingSphere-Command-778] ShardingSphere-SQL - Logic SQL: /* ApplicationName=DataGrip 2021.1 */ drop index complex_index on bid_purchaser_info_dis_approval_pro
[INFO ] 2022-08-18 15:41:36.864 [ShardingSphere-Command-778] ShardingSphere-SQL - SQLStatement: MySQLDropIndexStatement(table=Optional[SimpleTableSegment(tableName=TableNameSegment(startIndex=66, stopIndex=100, identifier=IdentifierValue(value=bid_purchaser_info_dis_approval_pro, quoteCharacter=NONE)), owner=Optional.empty, alias=Optional.empty)])
[INFO ] 2022-08-18 15:41:36.864 [ShardingSphere-Command-778] ShardingSphere-SQL - Actual SQL: ds_2 ::: /* ApplicationName=DataGrip 2021.1 */ drop index complex_index_bid_purchaser_info_dis_approval_pro on bid_purchaser_info_dis_approval_pro
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Can't DROP 'complex_index_bid_purchaser_info_dis_approval_pro'; check that column/key exists
```
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] novice-gamer closed issue #20266: Error deleting index
Posted by GitBox <gi...@apache.org>.
novice-gamer closed issue #20266: Error deleting index
URL: https://github.com/apache/shardingsphere/issues/20266
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] terrymanu commented on issue #20266: Error deleting index
Posted by GitBox <gi...@apache.org>.
terrymanu commented on issue #20266:
URL: https://github.com/apache/shardingsphere/issues/20266#issuecomment-1270313764
I just set the issue as `invalid` because the author close it without any reason.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org