geiyelui opened a new issue #13606: URL: https://github.com/apache/shardingsphere/issues/13606
## Question 原sql，已模糊掉部分字段 select a.id, a.createDate, a.remark, a.ackSn, a.alarmSource, a.alarmTime, a.alarmType, a.descr (case when a.attachmentCount = 0 then count(m.mediaitemid) else a.attachmentCount end) as attachmentCount from testA a LEFT JOIN mediaitem m on a.plateNo = m.plateNo and a.alarmTime = m.sendTime order by a.createDate desc 其中testA 为分表，正常状态下可以走sharding的sql解析，但是加上 Group By a.createDate 之后就报错 控制台显示报错信息 [https://images.gitee.com/uploads/images/2021/1115/115840_9375c7fc_5101220.png](url) -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
