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

New issue

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

#

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

Already on GitHub? # to your account

Jump to bottom

Open

littleniannian opened this issue Feb 17, 2025 · 0 comments

Assignees

Labels

bug

Milestone

Collaborator

littleniannian commented Feb 17, 2025

版本信息（Version）

SQLE: 4.2502.0-pre4-ee aae9866

问题描述（Describe）

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

截图或日志（Log）

如何复现（To Reproduce）

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

问题原因

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

解决方案

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

变更影响面

受影响的模块或功能

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

版本兼容性

测试建议

The text was updated successfully, but these errors were encountered:

littleniannian added the bug label

littleniannian assigned ColdWaterLW

ColdWaterLW modified the milestones: v4.2502.0, v4.2503.0

ColdWaterLW modified the milestones: v4.2503.0, 4.2504.0

ColdWaterLW modified the milestones: v4.2504.0, v4.2505.0

# for free to join this conversation on GitHub. Already have an account? # to comment