数据中心查询配置MySQL原生SQL查询，是不是有些语句不支持?
比如with as语句。下面这段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中运行正确，在数据中心里测试提示：
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'}
有替代方案吗？
这个就递归去查就可以了，不用在sql 里去递归，在代码里递归
页:
[1]