only_full_group_by bug

sql执行报错：only_full_group_by

 select
        DATA_TYPE as taskType, BP_NO as bpNo , MAIN_COMPANY_CODE as mainCompanyCode, TRANDATE as transDate,
             FILE_BATCH_NO as fileBatchNo
        from cs_settle_detail
        where  DATA_TYPE= #{dataType,jdbcType=VARCHAR}
        AND TRANDATE = #{tranDate,jdbcType=DATE}
        group by FILE_BATCH_NO, DATA_TYPE

由于查询的字段必须也在 group by后面，故报错，改为：

  select
        DATA_TYPE as taskType, BP_NO as bpNo , MAIN_COMPANY_CODE as mainCompanyCode, TRANDATE as transDate,
             FILE_BATCH_NO as fileBatchNo
        from cs_settle_detail
        where  DATA_TYPE= #{dataType,jdbcType=VARCHAR}
        AND TRANDATE = #{tranDate,jdbcType=DATE}
        group by DATA_TYPE,BP_NO,MAIN_COMPANY_CODE,TRANDATE,FILE_BATCH_NO

查询的字段与group by后面的字段保持一致。