有需求需要按照首字母大小排序 navicat上没问题 放到服务上就出问题了 包这个错
搜了很多 @InterceptorIgnore(tenantLine = "true") @SqlParser 这两个注解都试了 都没用
AND (type <> ? AND del_flag = ? AND is_verify = ? AND org_id IN (?,?,?,?,?,?,?)) ORDER BY create_time ASC,CONVERT(name USING gbk) ASC", exception:
net.sf.jsqlparser.parser.ParseException: Encountered unexpected token: "(" "("
at line 4, column 114.
Was expecting one of:
"&"
"&&"
","
"::"
";"
"<<"
">>"
"AND"
"ASC"
"COLLATE"
"DESC"
"EXCEPT"
"FOR"
"INTERSECT"
"MINUS"
"NULLS"
"OR"
"ORDER"
"UNION"
"["
"^"
"|"
<EOF>