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

规则:避免执行计划中 filter 次数过多审核出现异常 #2923

Open
littleniannian opened this issue Feb 17, 2025 · 0 comments
Open
Assignees
Labels
bug Something isn't working
Milestone

Comments

@littleniannian
Copy link
Collaborator

版本信息(Version)

SQLE: 4.2502.0-pre4-ee aae98666ee

问题描述(Describe)

-规则:避免执行计划中 filter 次数过多审核出现异常Error 1791 (HY000): Unknown EXPLAIN format name: 'TREE'

截图或日志(Log)

Image

如何复现(To Reproduce)

  1. 确保规则模版配置了规则:避免执行计划中 filter 次数过多
  2. 对mysql5.7的数据源执行快捷审核

问题原因

  • 规则:避免执行计划中 filter 次数过多中执行了EXPLAIN FORMAT=TREE,但是该语法在低于mysql8.0的数据库中不支持,导致报错。

解决方案

  • 该规则需要针对数据库的版本来判断是否执行

变更影响面

受影响的模块或功能

外部引用的潜在问题或风险

版本兼容性

测试建议

@littleniannian littleniannian added the bug Something isn't working label Feb 17, 2025
@ColdWaterLW ColdWaterLW modified the milestones: v4.2502.0, v4.2503.0 Feb 17, 2025
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working
Projects
None yet
Development

No branches or pull requests

2 participants