树形递归删除问题，数据库Mariadb(相当于mysql)

[s899000]

生成的sql在数据库中是执行成功的，但是代码确报错
DELETE FROM Dic WHERE (Id in (select * from (SELECT a.Id
FROM ( SELECT cte_tbc.cte_level, a.Id, a.Code, a.Pid, a.Text, a.Value
FROM (
SELECT @cte_ids as cte_ids, (
SELECT @cte_ids := group_concat(Id)
FROM Dic
WHERE find_in_set(Pid, @cte_ids)
) as cte_cids, @cte_level := @cte_idcte_levels + 1 as cte_level
FROM Dic, (
SELECT @cte_ids := a.Id, @cte_idcte_levels := 0
FROM Dic a
WHERE 1=1 AND (a.Id = 16)
LIMIT 1) cte_tbb
WHERE @cte_ids IS NOT NULL
) cte_tbc, Dic a
WHERE find_in_set(a.Id, cte_tbc.cte_ids) ) a
ORDER BY a.cte_level DESC) ftb_del))

[2881099]

使用极联删除文档，看一下

[2881099]

https://github.com/dotnetcore/FreeSql/wiki/%E8%81%94%E7%BA%A7%E5%88%A0%E9%99%A4

[s899000]

树形，不是级联

[s899000]

就是照文档来的写的，生成的sql执行没问题，但是代码会报错

[s899000]

https://freesql.net/guide/select-as-tree.html#_1%E3%80%81totreelist

[luoyunchong]

连接串增加 Allow User Variables=True

[s899000]

OK了

[2881099]

树形是可以极联删除的。

你用的递归查询可能 in 内部使用了参数变量，百度搜索一下错误关键字。