[BUG] SQLParser is not support Pattern Matching predicate completely

[sunxien]

Database Type

MySQL

Database Version

MySQL 5.7, 8.0

Druid Version

1.2.24

JDK Version

JDK 1.8

Error SQL

表达式："name like '马%'"
百分号 % 表示模糊匹配任意个数字符

表达式："name like '马_'"
下划线： _ 表示仅模糊匹配一个字符，无法识别该表达式符号

Testcase Code

String sql = "? like '马_'"
List parameters = Lists.newArrayList("马某");
Object object = SQLEvalVisitorUtils.evalExpr(JdbcConstants.MYSQL,sql, parameters);
结果：false

List parameters = Lists.newArrayList("马某某");
Object object = SQLEvalVisitorUtils.evalExpr(JdbcConstants.MYSQL,sql, parameters);
结果：false

Stacktrace Info

No response

Error Info

No response