Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

drop index 返回受影响行数为0 #571

Closed
KaiNiao opened this issue Apr 24, 2023 · 2 comments
Closed

drop index 返回受影响行数为0 #571

KaiNiao opened this issue Apr 24, 2023 · 2 comments

Comments

@KaiNiao
Copy link

KaiNiao commented Apr 24, 2023

描述
drop index 语法校验返回受影响行数为0,alter table drop index 返回不等于0

重现
drop index on

环境

  • 数据库: [mysql]
  • 版本: [例如 5.7.33]
  • goinception版本:1.3.0

参数
可能与问题相关的设置参数

参考issue https://github.com/hanchuanchuan/goInception/issues/445,其中作者回复:请升级到v1.2.5-35版本后重试。

查看1.3.0源码,checkDropIndex 方法中未调用 mysqlShowTableStatus 方法获取表大小,默认值等于0。

image

@hanchuanchuan
Copy link
Owner

请升级到 v1.3.0-72 版本后重试

@KaiNiao
Copy link
Author

KaiNiao commented May 18, 2023

重试验证显示符合预期,谢谢

@KaiNiao KaiNiao closed this as completed May 18, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants