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

goInception设置 sql_safe_updates=1有些mysql实例update语句where没有走索引检测通过 #557

Closed
liebao520 opened this issue Feb 23, 2023 · 2 comments
Labels
wontfix This will not be worked on

Comments

@liebao520
Copy link

描述
对问题简单清晰的描述
goInception设置 sql_safe_updates=1 ,两个相同版本,不同ip的mysql,update语句where条件都没有走索引,SQL检测时一个提示:You are using safe update mode and you tried to update a table without a WHERE that uses a KEY column. 一个提示pass
重现
模拟重现的步骤

环境

  • 数据库: [mysql]
  • 版本: [例如 5.7.36]

参数
可能与问题相关的设置参数
goInception sql_safe_updates=1

@hanchuanchuan
Copy link
Owner

这个提示是后端MySQL本身返回的.
请检查同样的SQL在两个MySQL上执行explain查看执行计划的差异.

@stale
Copy link

stale bot commented Mar 25, 2023

由于此问题没有最近的活动,因此已被自动标记为陈旧。如果没有进一步的活动,会作为不活跃issue关闭。感谢你对本项目的贡献。 This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions.

@stale stale bot added the wontfix This will not be worked on label Mar 25, 2023
@stale stale bot closed this as completed Apr 2, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
wontfix This will not be worked on
Projects
None yet
Development

No branches or pull requests

2 participants