如题, 在数据集使用多个UNION后, 预览时崩溃, SQL在其余软件中验证过无问题

数据库 MYSQL8

SQL: 

CREATE VIEW ProjectStepDurations AS

WITH StepDurations AS (

    SELECT 

        bp.PROJECTID,

        bp.GRAPH_NO,

        TIMESTAMPDIFF(HOUR, pd.P_S, pd.P_QZL) AS N1,

        TIMESTAMPDIFF(HOUR, pd.P_QZL, pd.P_CLZ) AS N2, 

        TIMESTAMPDIFF(HOUR, pd.P_CLZ, pd.P_PQ) AS N3, 

        TIMESTAMPDIFF(HOUR, pd.P_PQ, pd.P_JXZP) AS N4, 

        TIMESTAMPDIFF(HOUR, pd.P_JXZP, pd.P_YYZP) AS N5, 

        TIMESTAMPDIFF(HOUR, pd.P_YYZP, pd.P_DQZP) AS N6, 

        TIMESTAMPDIFF(HOUR, pd.P_DQZP, pd.P_SY) AS N7, 

        TIMESTAMPDIFF(HOUR, pd.P_SY, pd.P_BQ) AS N8, 

        TIMESTAMPDIFF(HOUR, pd.P_BQ, pd.P_HZ) AS N9 

    FROM OMC_PROJECT_DT pd

    INNER JOIN OMC_BD_PROJECT bp ON pd.PROJECTID = bp.projectID

    WHERE pd.P_HZ IS NOT NULL -- 已完工

)

SELECT 

    PROJECTID,

    GRAPH_NO,

    '*' AS NAME,

    ROUND(N1, 2) AS VALUE

FROM StepDurations

UNION ALL

SELECT 

    PROJECTID,

    GRAPH_NO,

    '*' AS NAME,

    ROUND(N2, 2) AS VALUE

FROM StepDurations

UNION ALL

SELECT 

    PROJECTID,

    GRAPH_NO,

    '*' AS NAME,

    ROUND(N3, 2) AS VALUE

FROM StepDurations

UNION ALL

SELECT 

    PROJECTID,

    GRAPH_NO,

    '*' AS NAME,

    ROUND(N4, 2) AS VALUE

FROM StepDurations

UNION ALL

SELECT 

    PROJECTID,

    GRAPH_NO,

    '*' AS NAME,

    ROUND(N5, 2) AS VALUE

FROM StepDurations

UNION ALL

SELECT 

    PROJECTID,

    GRAPH_NO,

    '*' AS NAME,

    ROUND(N6, 2) AS VALUE

FROM StepDurations

UNION ALL

SELECT 

    PROJECTID,

    GRAPH_NO,

    '*' AS NAME,

    ROUND(N7, 2) AS VALUE

FROM StepDurations

UNION ALL

SELECT 

    PROJECTID,

    GRAPH_NO,

    '*' AS NAME,

    ROUND(N8, 2) AS VALUE

FROM StepDurations

UNION ALL

SELECT 

    PROJECTID,

    GRAPH_NO,

    '*' AS NAME,

    ROUND(N9, 2) AS VALUE

FROM StepDurations;