Skip to content
New issue

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

在Select中使用子查询Any 生成SQL有语法错误 #1779

Open
LemonNoCry opened this issue Apr 12, 2024 · 2 comments
Open

在Select中使用子查询Any 生成SQL有语法错误 #1779

LemonNoCry opened this issue Apr 12, 2024 · 2 comments

Comments

@LemonNoCry
Copy link

问题描述及重现代码:

select 如果有使用了子查询Any 翻译错误

image
image

使用导航属性和直接freesql.Queryable 均错误
生成的SQL
image

该Sql执行后报错
image

数据库版本

SqlServer2012

安装的Nuget包

3.2.821

.net framework/. net core? 及具体版本

framework 4.8

@2881099
Copy link
Collaborator

2881099 commented Apr 12, 2024

写成 .Any(---)? true : false

@LemonNoCry
Copy link
Author

可行

这个bug也尽快修复一下

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants