dotnetcore / dotnetcore/FreeSql
开窗函数问题
Open
- Dominant language
- C#
- Stars
- 4.4k
- Forks
- 910
- PR merge metrics
- No merged PRs in 30d
Description
#### 问题描述及重现代码:数据库分表后,跨表使用开窗函数按日期排序,每张表的第一个日期为1,不能顺序排序
```c#
// c# code
await fsql.Context.Postgresql.Queryable()
.Where(a => a.Date > DateTime.Parse("2023-12-1")
.ToListAsync(a => new {
a.Name,
a.Date,
ToRank = SqlExt.RowNumber().Over().OrderByDescending(a.Date).ToValue()
});
```
#### 数据库版本
pgsql 18.0
#### 安装的Nuget包
Freesql.provider.Postgresql 3.5.306
#### .net framework/. net core? 及具体版本
.net core, .net9
Contributor guide
No contributing guide indexed for this repository
Assessment
This issue has not been assessed yet.