mysql group by cube_GROUPING函数来排除group by cube数据问题

起因：group by cube的结果中出现两条维度值一样，汇总值不一样的数据。

SELECT * FROM(

SELECT NVL(T.REG,'0000') AS REGION_ID,

NVL(T.PROJECT_TYPE, '0000') AS PROJECT_TYPE_ID,

NVL(T.VOLTAGE_LEVEL, '0000') AS VOL_CLASSIFY_ID,

NVL(T.CURRENT_NODE, '0000') AS NODE_ID,

NVL(T.TOTAL_CONTROL_INFO, '0000') AS TOTAL_CONTROL_TYPE_ID,

SUM(T.CN) AS CN,

SUM(T.AMT) AMT

FROM TMP T

WHERE 1 = 1

GROUP BY CUBE(T.REG,

T.PROJECT_TYPE,

T.VOLTAGE_LEVEL,

T.CURRENT_NODE,

T.TOTAL_CONTROL_INFO)) T

WHERE 1=1

AND T.REGION_ID='0000'

AND T.PROJECT_TYPE_ID='0000'

AND T.VOL_CLASSIFY_ID='0000'

AND T.TOTAL_CONTROL_TYPE_ID='75'

AND T.NODE_ID='9';