oceanbase不支持WITH RECURSIVE递归语法

[AntTech_VDAJNC]

WITH RECURSIVE org_data AS (
SELECT o.orgid, o.orgid_parent
FROM org o
JOIN org od_parents ON o.orgid_parent = od_parents.orgid
)
SELECT * FROM org_data;
报错

去掉RECURSIVE 就可以，但是不递归

[淇铭]

@AntTech_VDAJNC

WITH RECURSIVE

发一下 你的ob版本