dotnetcore / dotnetcore/FreeSql

开窗函数问题

Open
#2,209 1 comment 0 reactions 0 assignees View on GitHub
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.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.