8s不同版本语法是否存在差异

开发环境使用GBase8sV8.8_TL_3.6.3_3X2_1_783c8d版本

生产环境使用GBase8sV8.8_AEE_3.5.1_3_6a4e30版本，在执行语句时，在开发环境可以正常执行，在生产环境报错

SELECT
   d.day_dt,
   t.GS1,
   t.GS2,
   t.GS3,
   t.GS4,
   t.GS5,
   t.GS6,
   t.GS7,
   t.GS8,
   t.GS9
FROM
   (
       SELECT '2026-03-31 00:00:00' day_dt UNION ALL
       SELECT '2026-04-01 00:00:00' day_dt UNION ALL
       SELECT '2026-04-02 00:00:00' day_dt UNION ALL
       SELECT '2026-04-03 00:00:00' day_dt UNION ALL
       SELECT '2026-04-04 00:00:00' day_dt UNION ALL
       SELECT '2026-04-05 00:00:00' day_dt UNION ALL
       SELECT '2026-04-06 00:00:00' day_dt UNION ALL
       SELECT '2026-04-07 00:00:00' day_dt UNION ALL
       SELECT '2026-04-08 00:00:00' day_dt UNION ALL
       SELECT '2026-04-09 00:00:00' day_dt UNION ALL
       SELECT '2026-04-10 00:00:00' day_dt UNION ALL
       SELECT '2026-04-11 00:00:00' day_dt UNION ALL
       SELECT '2026-04-12 00:00:00' day_dt UNION ALL
       SELECT '2026-04-13 00:00:00' day_dt UNION ALL
       SELECT '2026-04-14 00:00:00' day_dt UNION ALL
       SELECT '2026-04-15 00:00:00' day_dt UNION ALL
       SELECT '2026-04-16 00:00:00' day_dt UNION ALL
       SELECT '2026-04-17 00:00:00' day_dt UNION ALL
       SELECT '2026-04-18 00:00:00' day_dt UNION ALL
       SELECT '2026-04-19 00:00:00' day_dt UNION ALL
       SELECT '2026-04-20 00:00:00' day_dt UNION ALL
       SELECT '2026-04-21 00:00:00' day_dt UNION ALL
       SELECT '2026-04-22 00:00:00' day_dt UNION ALL
       SELECT '2026-04-23 00:00:00' day_dt UNION ALL
       SELECT '2026-04-24 00:00:00' day_dt UNION ALL
       SELECT '2026-04-25 00:00:00' day_dt UNION ALL
       SELECT '2026-04-26 00:00:00' day_dt UNION ALL
       SELECT '2026-04-27 00:00:00' day_dt UNION ALL
       SELECT '2026-04-28 00:00:00' day_dt UNION ALL
       SELECT '2026-04-29 00:00:00' day_dt UNION ALL
       SELECT '2026-04-30 00:00:00' day_dt UNION ALL
       SELECT '2026-04-31 00:00:00' day_dt
   ) d
LEFT JOIN (
   SELECT
       rea_dt,
       MAX(CASE WHEN m_id = 20 THEN rea_pp_0 END) GS1,
       MAX(CASE WHEN m_id = 21 THEN rea_pp_0 END) GS2,
       MAX(CASE WHEN m_id = 23 THEN rea_pp_0 END) GS3,
       MAX(CASE WHEN m_id = 24 THEN rea_pp_0 END) GS4,
       MAX(CASE WHEN m_id = 26 THEN rea_pp_0 END) GS5,
       MAX(CASE WHEN m_id = 27 THEN rea_pp_0 END) GS6,
       MAX(CASE WHEN m_id = 29 THEN rea_pp_0 END) GS7,
       MAX(CASE WHEN m_id = 30 THEN rea_pp_0 END) GS8,
       MAX(CASE WHEN m_id = 33 THEN rea_pp_0 END) GS9
   FROM rd_e_accu
   GROUP BY rea_dt
) t 
ON d.day_dt = t.rea_dt
ORDER BY d.day_dt asc

【GBase版本】:

【操作系统】:

【CPU】:

【问题描述】*: