SQLServer2005Dialect changes the order of selected columns when using pagination

Description

The SQLServer2005Dialect uses ROW_NUMBER() to generate a limit string. However, it prepend the row number column instead of appending it (or not returning it at all). This let for example PaginationTest#testLimitOffset fail.
See also HHH-2655.

Environment

None

Status

Assignee

Hardy Ferentschik

Reporter

Hardy Ferentschik

Fix versions

Labels

backPortable

None

Suitable for new contributors

None

Requires Release Note

None

Pull Request

None

backportDecision

None

Components

Affects versions

Priority

Major
Configure