数据中心查询配置MySQL原生SQL查询，是不是有些语句不支持?

IDEALIST

比如with as语句。
下面这段SQL：

[SQL] 纯文本查看 复制代码

WITH RECURSIVE folder_tree AS (
    SELECT 
        xid, 
        xparentId, 
        xname,
        xid as original_id,  -- 保存起始ID
        1 as level
    FROM QRY_DYN_OFFICEONLINE_FOLDER 
    
    UNION ALL
    
    SELECT 
        q.xid, 
        q.xparentId, 
        q.xname,
        ft.original_id,      -- 传递起始ID
        ft.level + 1
    FROM QRY_DYN_OFFICEONLINE_FOLDER q
    INNER JOIN folder_tree ft ON q.xid = ft.xparentId
    WHERE ft.xparentId != "-1"
)

SELECT xid, xname
FROM folder_tree
WHERE xparentId = '-1'
  AND original_id = 'da889e99-5e0b-4b0c-a530-4bde8169f1f3';
  

我在navicat中运行正确，在数据中心里测试提示：

[Bash shell] 纯文本查看 复制代码

org.apache.openjpa.persistence.PersistenceException: Table 'X1.folder_tree' doesn't exist {prepstmnt 894373952 SELECT COUNT(*) FROM folder_tree WHERE xparentId = '-1' AND original_id = 'da889e99-5e0b-4b0c-a530-4bde8169f1f3'} [code=1146, state=42S02]

有替代方案吗？

xadmin

这个就递归去查就可以了，不用在sql 里去递归，在代码里递归