dotnetcore / dotnetcore/FreeSql
gbase8s查询条件转换问题
- Dominant language
- C#
- Stars
- 4.4k
- Forks
- 910
- PR merge metrics
- No merged PRs in 30d
Description
#### 问题描述及重现代码:
下列查询中查询条件被翻译为NULL IS NOT NULL AND ((a.id) in NULL)),将生成的sql语句取出来放到dbeaver中去执行也会报错:SQL 错误 [IX000]: IN 表达式右边必须是 COLLECTION 类型。
```c#
[Table(Name = "Shift")]
public class Shift
{
///
/// 自增主键
///
[Column(IsPrimary = true, IsIdentity = true, CanUpdate = false, Position = 1)]
public int Id { get; set; }
}
int[]? currentIds = null;
var list = _freeSql.select().Where(a => currentIds != null && currentIds.Contains(a.Id)).ToList();
```
#### 数据库版本
gbase8s
#### 安装的Nuget包
FreeSql 3.5.213
FreeSql.Provider.GBase 3.5.213
#### .net framework/. net core? 及具体版本
.net 8.0
Contributor guide
No contributing guide indexed for this repository
Assessment
This issue has not been assessed yet.