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

[MySQL (Oracle)] Cannot parse user variable in EXPLAIN INTO #4420

Open
OnMYLai opened this issue Feb 21, 2025 · 1 comment
Open

[MySQL (Oracle)] Cannot parse user variable in EXPLAIN INTO #4420

OnMYLai opened this issue Feb 21, 2025 · 1 comment

Comments

@OnMYLai
Copy link

OnMYLai commented Feb 21, 2025

My SQL, copying from MySQL doc with changes of the select sql to sth in my db:
EXPLAIN FORMAT=JSON INTO @myselect SELECT a FROM ab1;
Parsing return error msg line 1:25 mismatched input '@myselect' expecting '@', and unable to parse the 'myselect' as an ID.

the rule for the INTO part:
explainInto
: INTO_SYMBOL AT_SIGN_SYMBOL textOrIdentifier
;
maybe need to recognize AT_TEXT_SUFFIX?

@mike-lischke
Copy link
Member

Good find @OnMYLai!

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

No branches or pull requests

3 participants