We read every piece of feedback, and take your input very seriously.
To see all available qualifiers, see our documentation.
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
我在使用树形查询时,代码如下: root.Children = fsql.Select() .IncludeMany(t => t.Rules, then => then.IncludeMany(t => t.PreLinks)) .OrderBy(t => t.Order) .Where(t => t.Id != WkfConstant.ROOT_ID) .ToTreeList(); 这个树下的子节点过多(我这里有5000多个)就会报ORA-01795的错误。看了一下生成的sql语句,应该是把所有的id都放到一个in条件里面了,pg没有数量限制,当把数据迁移到Oracle里,就跑不过去了。 附件里是报错的日志信息,请帮忙解决下,多谢。 Error2021-08-06.log
Oracle11g
FreeSql.All(2.5.100)
.net framework 4.8
The text was updated successfully, but these errors were encountered:
有空提供一下直接运行的 demo ,谢谢
Sorry, something went wrong.
已经直接发给你qq了,麻烦看一下,谢谢。
- 修复 Oracle IncludeMany IN 元素超过 500 数目的问题;#843
6d53d3e
v2.6.100 #843 #816 #815 #804 #803 #802
e0f9db7
No branches or pull requests
问题描述及重现步骤:
我在使用树形查询时,代码如下:
root.Children = fsql.Select()
.IncludeMany(t => t.Rules, then => then.IncludeMany(t => t.PreLinks))
.OrderBy(t => t.Order)
.Where(t => t.Id != WkfConstant.ROOT_ID)
.ToTreeList();
这个树下的子节点过多(我这里有5000多个)就会报ORA-01795的错误。看了一下生成的sql语句,应该是把所有的id都放到一个in条件里面了,pg没有数量限制,当把数据迁移到Oracle里,就跑不过去了。
附件里是报错的日志信息,请帮忙解决下,多谢。
Error2021-08-06.log
数据库的具体版本
安装的包
.net framework/. net core? 及具体版本
The text was updated successfully, but these errors were encountered: