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: max nesting level reached on query with many nested OR operators #13159

Closed
arthurschreiber opened this issue May 25, 2023 · 0 comments · Fixed by #13158
Closed

Bug Report: max nesting level reached on query with many nested OR operators #13159

arthurschreiber opened this issue May 25, 2023 · 0 comments · Fixed by #13158

Comments

@arthurschreiber
Copy link
Contributor

Overview of the Issue

We have encountered a case where a query that's supported fine by MySQL directly fails with max nesting level reached.

The query looks something like this: https://gist.github.com/arthurschreiber/a466518f2aea0a9547c39ad8654accae

This specific query doesn't make any sense and was generated by some buggy logic on our side, but MySQL was happy to parse and execute this query, while vtgate would fail to parse this query.

Reproduction Steps

{ "sharded": false }

Binary Version

Version 15 and up

Operating System and Environment details

N/A

Log Fragments

N/A
@arthurschreiber arthurschreiber added Type: Bug Needs Triage This issue needs to be correctly labelled and triaged Component: Query Serving and removed Needs Triage This issue needs to be correctly labelled and triaged labels May 25, 2023
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