【DM版本】:DM8
【操作系统】：麒麟10
【CPU】:Hygon C86 5280 16-core Processor
【问题描述】*：为什么一下语句执行报错“-2007: 第 1 行, 第 15 列[split]附近出现错误: 语法分析出错”

WITH RECURSIVE split AS (
SELECT 1 AS level,
SUBSTR('1,2,3,4', 1, INSTR('1,2,3,4' || ',', ',', 1) - 1) AS part,
SUBSTR('1,2,3,4', INSTR('1,2,3,4' || ',', ',', 1) + 1) AS rest
FROM dual
UNION ALL
SELECT level + 1,
SUBSTR(rest, 1, INSTR(rest || ',', ',', 1) - 1),
SUBSTR(rest, INSTR(rest || ',', ',', 1) + 1)
FROM split
WHERE rest IS NOT NULL AND rest != ''
)
SELECT level, part FROM split