[Bug] Syntax compatibility issue. A simple test may be that the ESCAPE keyword is incompatible. The error is 'Encountered: IDENTIFIER'

[UoweMe]

Search before asking

• I had searched in the issues and found no similar issues.

Version

unknown

What's Wrong?

sql:
select org_id from pfma_ods_moon_org where org_lvl LIKE concat('123', '%') ESCAPE '@' LIMIT 0, 10

error message:
java.sql.SQLException: errCode = 2, detailMessage = Syntax error in line 1:
...l` LIKE concat('0', '%') ESCAPE '@' LIMIT 0, 10
^
Encountered: IDENTIFIER
Expected: ||, COMMA

at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:130)
at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:916)
at com.mysql.cj.jdbc.ClientPreparedStatement.executeQuery(ClientPreparedStatement.java:972)
at com.alibaba.druid.pool.DruidPooledPreparedStatement.executeQuery(DruidPooledPreparedStatement.java:213)

What You Expected?

I hope to solve this problem or provide a solution to circumvent it in the future.

How to Reproduce?

No response

Anything Else?

No response

Are you willing to submit PR?

• Yes I am willing to submit a PR!

Code of Conduct

• I agree to follow this project's Code of Conduct

[yx-keith]

I will pick this, please assign it to me, thanks!