为提高效率，提问时请提供以下信息，问题描述清晰可优先响应。
【DM版本】: 05134283950-20221121-175072-20024
【操作系统】：麒麟v10
【CPU】:kunpeng920
【问题描述】*：多表关联查询，不加group by时可以正常查询，结果集只有100条，加一个group by或者distinct后直接变成报错数据溢出，求大佬解答，sql如下；

SELECT
    ip.advance_Id AS 事前单ID
   
FROM
    inc_payee ip
INNER JOIN Relevant_Ba rb ON ip.bill_id = rb.BUSINESS_ID and rb.ba_num = REGEXP_SUBSTR(ip.ba_name, '[^.]+')
INNER JOIN inc_entity ie ON rb.BUSINESS_ID = ie.bizid
--INNER JOIN ba_entity be ON rb.ba_id = be.bizid
INNER JOIN sq_entity se ON ip.advance_Id = se.bizid
WHERE
         ip.pay_status = '已支付'
    AND ip.advance_Id != '' -- 事前id不为空
    AND rb.ba_Source_Type = '事前申请单' -- 来源是事前申请单
    AND rb.ba_Source_ID != '' -- 来源id不为空
    AND ie.source_bill_id = ''
    AND ie.status not in ( '草稿','已作废')
    AND ip.fiscal_Year = 2025
    AND ip.is_deleted = 2
    AND rb.fiscal_Year = 2025
    AND rb.is_deleted = 2
    AND ie.fiscal_Year = 2025
    AND ie.is_deleted = 2
    --AND be.fiscal_Year = 2025
    --AND be.is_deleted = 2
    AND se.fiscal_Year = 2025
    AND se.is_deleted = 2
GROUP BY
    ip.advance_Id