注册

DM7.6执行CTE语句获取树形结构数据异常!

软件后端罗工 2025/05/26 192 2

为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】:DM Database Server x64 V7.6.1.60-Build(2020.06.02-122414)ENT
【操作系统】:windows
【CPU】:
【问题描述】*:
按顺序执行:
DROP TABLE MYEMPLOYEES;
CREATE TABLE MYEMPLOYEES(
EMPLOYEEID SMALLINT,
FIRST_NAME VARCHAR2 (30) NOT NULL,
LAST_NAME VARCHAR2 (40) NOT NULL,
TITLE VARCHAR2 (50) NOT NULL,
DEPTID SMALLINT NOT NULL,
MANAGERID INT NULL);

INSERT INTO MYEMPLOYEES VALUES (1, 'KEN', 'SANCHEZ', 'CHIEF EXECUTIVE OFFICER', 16, NULL);
INSERT INTO MYEMPLOYEES VALUES (273, 'BRIAN', 'WELCKER', 'VICE PRESIDENT OF SALES', 3, 1);
INSERT INTO MYEMPLOYEES VALUES (274, 'STEPHEN','JIANG', 'NORTH AMERICAN SALES MANAGER',3, 273);
INSERT INTO MYEMPLOYEES VALUES (275, 'MICHAEL', 'BLYTHE', 'SALES REPRESENTATIVE', 3, 274);
INSERT INTO MYEMPLOYEES VALUES (276, 'LINDA', 'MITCHELL', 'SALES REPRESENTATIVE', 3, 274);
INSERT INTO MYEMPLOYEES VALUES (285, 'SYED', 'ABBAS', 'PACIFIC SALES MANAGER', 3, 273);
INSERT INTO MYEMPLOYEES VALUES (286, 'LYNN', 'TSOFLIAS', 'SALES REPRESENTATIVE', 3, 285);
INSERT INTO MYEMPLOYEES VALUES (16, 'DAVID', 'BRADLEY', 'MARKETING MANAGER', 4, 273);
INSERT INTO MYEMPLOYEES VALUES (23, 'MARY', 'GIBSON', 'MARKETING SPECIALIST', 4, 16);

commit;
以上SQL执行正常.
WITH RECURSIVE DIRECTREPORTS AS
(SELECT MANAGERID, EMPLOYEEID, TITLE, DEPTID
FROM MYEMPLOYEES
WHERE MANAGERID IS NULL
UNION ALL
SELECT E.MANAGERID, E.EMPLOYEEID, E.TITLE, E.DEPTID
FROM MYEMPLOYEES E
INNER JOIN DIRECTREPORTS D
ON E.MANAGERID = D.EMPLOYEEID
)
SELECT MANAGERID, EMPLOYEEID, TITLE FROM DIRECTREPORTS;
报异常:执行失败(语句1)
-2007: 第 1 行, 第 41 列[DIRECTREPORTS]附近出现错误:
语法分析出错

回答 0
暂无回答
扫一扫
联系客服