ShardingSphere 4.1.1版本 使用Group Up时，sql解析错误

[masaka]

Springboot项目，Mysql数据库，Mybatis数据中间件
原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 gpsalarm a
LEFT JOIN mediaitem m on a.plateNo = m.plateNo and a.alarmTime = m.sendTime
order by a.createDate desc
其中gpsalarm为分表，正常状态下可以走sharding的sql解析

但是加上 Group By a.createDate 之后就报错
控制台显示报错信息

[strongduanmu]

请提供下使用的 SS 版本，分片配置，以及表初始化语句。

[tuichenchuxin]

@masaka

a.createDate

This sql can not be supported
SELECT count(0) FROM (SELECT a.id, a.createDate, a.remark, a.ackSn, a.alarmSource, a.alarmTime, a.alarmType, a.descr FROM gpsalarm a GROUP BY a.createDate) table_count
You can try 5.x calcite sql.

[zhangliang]

能改标题么，拼错了的group up不利于以后检索呀

[masaka]

已解决，4.1版本不支持sql子查询，当语句中存在聚合函数时分页插件的count方法会执行一条类似
SELECT count(0) FROM (SELECT a.xxx,a.xxx,a.xxx group by a.type) table_count的语句
注意不执行count方法就可以