[BUG] JSQLParser Version : 4.4 RDBMS : mysql Encountered unexpected token: "apply" "APPLY"

[zjmJavaByte]

Always check against the Latest SNAPSHOT of JSQLParser and the Syntax Diagram

Failing SQL Feature:

• Encountered unexpected token: "apply" "APPLY"
• When I remove the apply field and perform the parsing, no errors are reported

SQL Example:

• Simplified Query Example, focusing on the failing feature

  -- Replace with your ACTUAL example
  UPDATE om_calendar_act_info SET action_calendar_id =?,act_time =?,sys_code =?,apply =?,act_name =?,begin_date =?,end_date =?,STATUS =?,is_commit =?,activity_details =?,images =?,materials =?,hr_bh =?,hr_name =?,create_time =?,update_user =?,update_time =? WHEREid =? AND del =0

Software Information:

• JSqlParser version is 4.4
• Database is mysql

Tips:

Please write in English and avoid Screenshots (as we can't copy and paste content from it).
Try your example online with the latest JSQLParser and share the link in the error report.
Do provide Links or References to the specific Grammar and Syntax you are trying to use.

[manticore-projects]

Greetings.

please try JSQLParser 4.6 which parses your statement fine.

4.4 has had APPLY defined as a reserved keyword.

[zjmJavaByte]

Greetings.

please try JSQLParser 4.6 which parses your statement fine.

4.4 has had APPLY defined as a reserved keyword.

When I upgraded to version 4.6, the following error occurred Encountered unexpected token: "\n\n\n" <ST_SEMICOLON> . I was using the 'sql' generated automatically by the mybatisplus framework. and I did see a lot of' \n 'through debug

[manticore-projects]

Greetings!

That is correct, in JSQLParser 4.6, two empty rows .*\n\n\n terminate a statement.
(And I still will need a good argument why anyone would need 2 empty rows within one statement.)

select 1 from dual


select 2 from dual

gives 2 statements (without typing semicolons ;)