hibernate/hibernate-orm — pull request #582 by findepi (2013-09-03 14:02:47+00:00)
Title: HHH-6914: Fix queries with ORDER BY over same column

Fix queries with ORDER BY over same column referenced under 2 different names on SQL Server.

Change in short: always use ROW_NUMBER OVER in SQL Server to guard against "SQLServerException: A column has been specified more than once in the order by list. Columns in the order by list must be unique".
This basically rolls back HHH-7370, so I removed the test case for that issue (it was failing, of course).