Fix pagination in Microsoft SQL Server when using alias columns

• Type: Regression Bug
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 5.1.2, 5.2.3, 6.0.5 GA
• Fix Version/s: --Sprint - SP, 6.0.6 GA, 6.1.0 CE RC1
• Component/s: Infrastructure > DBs
• Labels: None
• Branch Version/s:
  5.1.x, 5.2.x, 6.0.x
• Backported to Branch:
  Committed
• Similar Issues: Show 5 results ; ;

  LPS-15015	Fix pagination in Microsoft SQL Server for queries using UNION
  LPS-3228	UpgradeLayout throws SQLException when upgrading Microsoft SQL Server to v5_0_0
  LPS-3229	UpgradeDocumentLibrary throws SQLException when upgrading Microsoft SQL Server to v5_1_5
  LPS-12398	JDBC or Hibernate incompatibility with Kaleo and Microsoft SQL Server
  LPS-3234	UpgradeMessageBoards throws SQLException when upgrading Microsoft SQL Server to v5_1_5

In SQL Server 2008, even though ORDER BY recognizes column aliases, OVER(ORDER BY) does not. As a result of LPS-9903, pagination does not work if the ORDER BY uses column aliases.

[Minhchau Dang]

One solution is to replace column aliases with the real column name in the OVER(ORDER BY).

[Michael Hashimoto]

Backported to 6.0.6 at revision 71597.