with rollup执行出来结果不一致

select F_SubID, F_CircuitID,F_IsIncoming, max(F_CircuitName) F_CircuitName, max(F_CircuitName_EN)
        F_CircuitName_EN, F_StartHour, sum(F_HourValue)
        F_HourValue,sum(F_Price) F_Price,F_ApartMentName,F_LocalCode
        from (select T_BD_Circuit.F_SubID, T_BD_Circuit.F_CircuitID,T_BD_Circuit.F_IsIncoming,
        T_BD_Circuit.F_CircuitName, T_BD_Circuit.F_CircuitName_EN, F_StartHour,
        F_HourValue,F_HourValue*F_EpiSinglePrice F_Price,F_ApartMentName,F_LocalCode
        from T_BD_Circuit
        inner join T_EC_EnergyHourResult on T_BD_Circuit.F_SubID = T_EC_EnergyHourResult.F_SubID and
        T_BD_Circuit.F_MeterCode = T_EC_EnergyHourResult.F_MeterCode
        inner join T_BD_Substation on T_BD_Substation.F_SubID=T_BD_Circuit.F_SubID
        where F_CircuitID in
('100110880001')
        and date_format(F_StartHour, '%Y-%m-%d %H:00:00') between date_format('2025-07-24 00:00:00','%Y-%m-%d
        %H:00:00') and
        date_format('2025-07-24 08:00:00','%Y-%m-%d %H:00:00')
        union all
        select F_SubID,
        F_CircuitID,
        F_IsIncoming,
        F_CircuitName,
        F_CircuitName_EN,
        str_to_date(concat('2025-07-24 00:00:00',''),'%Y-%m-%d %H:00:00') F_StartHour,
        null F_HourValue,
        null F_Price,
        F_ApartMentName,
        F_LocalCode
        from T_BD_Circuit
        where F_CircuitID in
('100110880001')

) a 
        group by F_SubID, F_CircuitID, F_StartHour
        with rollup
        having F_CircuitID is not null
mysql结果：
![输入图片说明](https://foruda.gitee.com/images/1753357850392757264/cbfc4802_3047171.png "屏幕截图")
greatsql结果：
![输入图片说明](https://foruda.gitee.com/images/1753357831266953023/c474cd82_3047171.png "屏幕截图")

万里数据库/GreatSQL-Doc

Content Risk Flag

Comments (1)

万里数据库/GreatSQL-Doc .gitee-modal { width: 500px !important; }

Content Risk Flag