为提高效率，提问时请提供以下信息，问题描述清晰可优先响应。
【DM版本】:DM8
【操作系统】：WIN64
【CPU】:X86
【问题描述】*：在Mysql迁移达梦过程中,表都可以正常迁移,部分视图迁移报错,下面是迁移报错截取的sql,帮忙看看有没有明显的错误

SELECT
			"E"."ID" AS "OBJECTID",
			max("A"."STATUS") AS "CURRENTSTATUS",
			'group' AS "TYPES"
		FROM
							"V_LASTSTATUS" "A"
							JOIN "ITEMS" "B"
						JOIN "DEVICES" "C"
					JOIN "MONITORVIEW" "D"
				JOIN "MONITORVIEW" "E"
		ON
			(
				("A"."ITEMSID" = "B"."ID")
				AND ("B"."DEVICEID" = "C"."ID")
				AND ("C"."VIEWID" = "D"."ID")
				AND (
					(
						(
							length("D"."PIDS") - length(REPLACE("D"."PIDS", ',', ''))
						) > (
							length("E"."PIDS") - length(REPLACE("E"."PIDS", ',', ''))
						)
					)
					OR ("E"."PIDS" = "D"."PIDS")
				)
				AND (
					locate("E"."PIDS", "D"."PIDS") = 1
				)
			)
		GROUP BY
			"E"."ID"