[BUG] JSQLParser Version : Mysql: for update Confused

[nieqiurong]

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

Failing SQL Feature:

• Wrong result : SELECT * FROM t_demo WHERE a = 1 FOR UPDATE ORDER BY b ASC LIMIT 1

SQL Example:

• Simplified Query Example, focusing on the failing feature

  select * from t_demo where a = 1 order by b asc limit 1 for update

Software Information:

• JSqlParser 4.9
• Database Mysql

Tips:

An incorrect sql was returned through the parser，and this sql could not be executed correctly.

[manticore-projects]

Thank you for reporting, I can confirm that the Deparser is not putting this at the right position.
I am going fix this eventually.

[nieqiurong]

Thank you, looking forward to your updates