为提高效率，提问时请提供以下信息，问题描述清晰可优先响应。
【DM版本】:8.0
【操作系统】：
【CPU】:
【问题描述】：SELECT/+GROUP_OPT_FLAG(1)/
kr.iid krId,
kr.kr_name krName,
obj.creator_id userId,
obj.user_name userName,
CASE
WHEN obj.creator_id = '1'
OR (
SELECT/+GROUP_OPT_FLAG(1)/
COUNT(iid)
FROM
JPAAS_CT.okr_keyresult
WHERE
obj_id = obj.iid
AND kr_user_id = '1'
AND del_flag = '1' group by iid ) > 1
OR obj.obj_query = '1'
OR (
SELECT/+GROUP_OPT_FLAG(1)*/
COUNT(iid)
FROM
JPAAS_CT.okr_competence
WHERE
obj_id = obj.iid
AND (user_id = '1'
OR group_id = '1')
AND del_flag = '1' group by iid) > '1' THEN 1
ELSE 0
END visible
FROM
JPAAS_CT.okr_keyresult kr,
JPAAS_CT.okr_objective obj
WHERE
obj.iid = kr.obj_id
AND obj.del_flag = '1'
AND obj.obj_cycle = '1'
AND obj.obj_status = '1'
AND kr.del_flag = '1'
AND kr.kr_progress < 1
AND kr.iid NOT IN('1')
AND obj.creator_id IN('1')
GROUP BY
obj.creator_id,
kr.iid,
kr.kr_name ,
obj.user_name,
kr.ctime
ORDER BY
obj.creator_id ASC,
kr.ctime ASC
LIMIT 5;

不是 GROUP BY 表达式 ，这个问题很多回答都看过了。做过字段的检查，字段都加上了。是公司统一数据库，无法修改系统参数，有大神帮忙看看是啥问题嘛。