Skip to content

Update ignore and delete ignore not parseable #1254

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

Closed
Todd102030 opened this issue Jul 5, 2021 · 1 comment · Fixed by #1396
Closed

Update ignore and delete ignore not parseable #1254

Todd102030 opened this issue Jul 5, 2021 · 1 comment · Fixed by #1396

Comments

@Todd102030
Copy link

Todd102030 commented Jul 5, 2021

Describe the bug
Update ignore and delete ignore statements throw exception when parsing.

To Reproduce
Steps to reproduce the behavior:

  1. Example SQL
    update ignore tRequirement set VendorItem=? where cn=@cn and VendorItem=?

  2. Parsing this SQL using JSqlParser with this statements
    SimpleNode node = (SimpleNode) CCJSqlParserUtil.parseAST(sqlInput);

  3. Exception
    Encountered unexpected token: "ignore" "IGNORE"
    at line 1, column 8.

Expected behavior
Expected to parse similarly to statements without the "ignore" keyword

System

  • MySQL 8.0
  • Java Version - JDK 8
  • JSqlParser version - 4.1

Thanks for all your work on this library, it's really great!

@wumpz
Copy link
Member

wumpz commented Jul 16, 2021

So this is only about update statements? PRs are welcome. Grammar line 950 should be the start.

OlivierCavadenti added a commit to OlivierCavadenti/JSqlParser that referenced this issue Nov 1, 2021
wumpz pushed a commit that referenced this issue Nov 19, 2021
* Add Delete / Update modifiers for MySQL #1254

* fix codacy issues + pr return

* simplify low_priority
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 a pull request may close this issue.

2 participants