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.

Sign up for GitHub

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

Jump to bottom

审核没有WHERE的SQL，索引优化panic #2145

Closed
winfredLIN opened this issue Dec 12, 2023 · 2 comments
Closed

审核没有WHERE的SQL，索引优化panic #2145

winfredLIN opened this issue Dec 12, 2023 · 2 comments
Assignees
@winfredLIN
Labels
bug Something isn't working publish-pre1 verified the issue all pr is verified
Milestone
v3.2312.0

Comments

@winfredLIN
Copy link
Collaborator

winfredLIN commented Dec 12, 2023 •
edited
Loading

#2117
审核SQL

SELECT * FROM table_1;

索引优化Panic
@winfredLIN winfredLIN added the bug Something isn't working label Dec 12, 2023
@winfredLIN winfredLIN self-assigned this Dec 12, 2023
@winfredLIN winfredLIN mentioned this issue Dec 12, 2023
Merged
@winfredLIN
Copy link
Collaborator Author

解决方案

在给出优化建议前，先判断where存不存在，若不存在，无法给出建议

@hasa1K
Copy link
Contributor

hasa1K commented Dec 25, 2023

开启规则：索引创建建议
审核语句没有where条件，没有发生报错
image

@hasa1K hasa1K added the verified the issue all pr is verified label Dec 25, 2023
@ColdWaterLW ColdWaterLW added this to the v3.2312.0 milestone Dec 28, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@winfredLIN winfredLIN

Labels
bug Something isn't working publish-pre1 verified the issue all pr is verified
Projects
None yet
Milestone
v3.2312.0
Development

No branches or pull requests
3 participants
@winfredLIN @ColdWaterLW @hasa1K