Simplify ON keyword check to only needed case by predictor2718 · Pull Request #652 · phpmyadmin/sql-parser · GitHub
Skip to content

Simplify ON keyword check to only needed case#652

Open
predictor2718 wants to merge 2 commits into
phpmyadmin:5.11.xfrom
predictor2718:fix/627-set-variable-on
Open

Simplify ON keyword check to only needed case#652
predictor2718 wants to merge 2 commits into
phpmyadmin:5.11.xfrom
predictor2718:fix/627-set-variable-on

Conversation

@predictor2718

Copy link
Copy Markdown
Contributor

Summary

  • SET @@variable = ON failed with "Missing expression" because ON is a reserved keyword that
    Expression::parse() rejected
  • OFF worked because it is not a reserved keyword
  • Fix: in SetOperation::parse(), after Expression::parse() returns null, accept ON as a literal value since
    it is valid in SET statements

Fixes #627

Signed-off-by: Nicolai Ehrhardt <245527909+predictor2718@users.noreply.github.com>
@codecov

codecov Bot commented Apr 13, 2026

Copy link
Copy Markdown

Signed-off-by: Nicolai Ehrhardt <245527909+predictor2718@users.noreply.github.com>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Labels

None yet

Projects

None yet

Development

Successfully merging this pull request may close these issues.

1 participant