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

Bug Report: Query not normalized properly #14769

Closed
GuptaManan100 opened this issue Dec 13, 2023 · 0 comments · Fixed by #14764
Closed

Bug Report: Query not normalized properly #14769

GuptaManan100 opened this issue Dec 13, 2023 · 0 comments · Fixed by #14764

Comments

@GuptaManan100
Copy link
Member

Overview of the Issue

It was noticed that we aren't normalizing all the queries properly. Specifically for a query like select a, b from t group by 1, field(a,1,2,3) order by 1 asc, field(a,1,2,3), we should be converting all the literal values in the field function call to bind variables, but we aren't doing that.

Reproduction Steps

Start a vitess cluster and execute the query listed. See the query plans in vtgate dashboard.

Binary Version

main and all other releases

Operating System and Environment details

-

Log Fragments

No response

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

Successfully merging a pull request may close this issue.

1 participant