sql异常Encountered unexpected token BINARY

1.出现错误

2023-11-06 10:48:19.604 [http-nio-8091-exec-3] WARN   c.b.m.e.p.i.PaginationInnerInterceptor - [autoCountSql,343] - [e322891e-de87-4d98-8456-f6448d3c165e] - optimize this sql to a count sql has exception, sql:"selects.id,s.command,s.category,s.service_uuid,s.org_code,sum(s.used_total) used_total,sum(s.used_success) used_success,sum(s.used_failed) used_failed,s.extend1,s.extend2,s.extend3,s.update_by,s.update_on,s.create_by,s.create_onfrommytable_asleft join mytable_b c on s.command = c.commandWHERE  s.org_code = ? group by BINARY s.command", exception:
net.sf.jsqlparser.parser.ParseException: Encountered unexpected token: "BINARY" "BINARY"

问题在 BINARY s.command 这里, 不符合标准语法, 使用替换即可

CAST(value AS BINARY)