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:"select
s.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_on
from
mytable_a
s
left join mytable_b c on s.command = c.command
WHERE 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)