search

dotnetcore / FreeSql

🦄 .NET aot orm, C# orm, VB.NET orm, Mysql orm, Postgresql orm, SqlServer orm, Oracle orm, Sqlite orm, Firebird orm, 达梦 orm, 人大金仓 orm, 神通 orm, 翰高 orm, 南大通用 orm, 虚谷 orm, 国产 orm, Clickhouse orm, QuestDB orm, MsAccess orm.
http://freesql.net
MIT License
3.99k stars 842 forks source link

树型向上查询并去重会报错 #1751

Open AN-535 opened 2 months ago

AN-535 commented 2 months ago

问题描述及重现代码：

_fsql.Select().Where(a => a.Status == GlobalEnum.DataStatus.Enable && !_fsql.Select().Where(b => b.RoleId == id && b.Status == GlobalEnum.DataStatus.Enable && a.Id == b.MenuId).Any()).AsTreeCte(null, true).Distinct().OrderBy(a => a.Order).ToListAsync() 执行时sql里面自动加了排序字段，导致sql报错 image

数据库版本

postgresql 10

安装的Nuget包

image

具体版本

.net 6.0

2881099 commented 2 months ago

递归查询不支持distinct