My code above no longer applies in Hibernate 4.2.5.

However, the following test still does not pass:

1. select as below (where User is pretty any entity i believe) with offset 0 and limit 2

   SELECT o.id AS userId FROM User o ORDER BY userId, o.id

   • with Hibernate 4.2.5 this throws

     com.microsoft.sqlserver.jdbc.SQLServerException: A column has been specified more than once in the order by list. Columns in the order by list must be unique.