果糖Doris生成更新语句无法更新问题 返回

生成的SQL语句长这样，Doris上执行报错

UPDATE  `doris_test` S    INNER JOIN             (

 SELECT @Test1_1 AS `test1`,NULL AS `test2`,'2024-07-26 16:55:47.832' AS `test4`,160 AS `test5`,'0.5' AS `test6`,'99.99' AS `test7`,@Test8_2 AS `test8`,@Test9_3 AS `test9`,'2024-07-31 16:55:47.832' AS `test10`,'2024-08-01 16:55:47.832' AS `test11`,'2024-08-01 16:55:47.832' AS `test12`,18 AS `test13`,'56' AS `test14`,183 AS `test15`,'88.88' AS `test16`

UNION ALL

 SELECT @Test1_4 AS `test1`,NULL AS `test2`,'2024-07-26 16:55:49.105' AS `test4`,101 AS `test5`,'0.5' AS `test6`,'99.99' AS `test7`,@Test8_5 AS `test8`,@Test9_6 AS `test9`,'2024-08-04 16:55:49.105' AS `test10`,'2024-08-04 16:55:49.105' AS `test11`,'2024-07-27 16:55:49.105' AS `test12`,18 AS `test13`,'56' AS `test14`,110 AS `test15`,'88.88' AS `test16`

UNION ALL

 SELECT @Test1_7 AS `test1`,NULL AS `test2`,'2024-08-01 16:55:50.327' AS `test4`,199 AS `test5`,'0.9' AS `test6`,'99.99' AS `test7`,@Test8_8 AS `test8`,@Test9_9 AS `test9`,'2024-07-30 16:55:50.327' AS `test10`,'2024-08-04 16:55:50.327' AS `test11`,'2024-07-31 16:55:50.327' AS `test12`,18 AS `test13`,'56' AS `test14`,148 AS `test15`,'88.88' AS `test16`

            ) T ON S.`test5`=T.`test5`

                   SET S.`test1`=T.`test1`,S.`test2`=T.`test2`,S.`test4`=T.`test4`,S.`test6`=T.`test6`,S.`test7`=T.`test7`,S.`test8`=T.`test8`,S.`test9`=T.`test9`,S.`test10`=T.`test10`,S.`test11`=T.`test11`,S.`test12`=T.`test12`,S.`test13`=T.`test13`,S.`test14`=T.`test14`,S.`test15`=T.`test15`,S.`test16`=T.`test16` ;