Using row_number with the SQLServerDialect makes select distinct useless

Description

Given class A with one to many relations to class B, when trying to get paginated data with SQLServerDialect from class A with a join clause to class B will dublicated A instances. That is because the row_number function will introduce another value to the select statement which will alway be different for each row. I found a work around using group by. Did not have time finish the test cases yet.

Environment

None

Assignee

Strong Liu

Reporter

GeorgiosV

Fix versions

Labels

None

backPortable

None

Suitable for new contributors

None

Requires Release Note

None

Pull Request

None

backportDecision

None

Components

Priority

Major
Configure