我的sql类似这样:
SELECT CASE WHEN C.LOGONID IS NULL THEN 0 ELSE 1 END AS CHECKED
FROM ${schema}.ECAS_APPL A
JOIN ${schema}.ECAS_ROLE B
ON A.APPLID = B.APPLID
LEFT JOIN ${schema}.ECAS_USERROLE C
ON A.APPLID = C.APPLID
AND B.ROLEID = C.ROLEID
AND C.LOGONID = #loginId#
AND C.BANKID = #bankId#
GROUP BY CASE WHEN C.LOGONID IS NULL THEN 0 ELSE 1 END
报错’C.LOGONID’ is not in GROUP BY,报错图如下
按文档中提到的group by算子,HASH GROUP BY应该就支持才对吧,是需要做什么特殊配置嘛?求解~