[hibernate-dev] SQLServer getLimitString() refactoring

Łukasz Antoniak lukasz.antoniak at gmail.com
Thu Jun 7 16:34:00 EDT 2012


Hello Guenther,

The following commit in general describes my thoughts: 
https://github.com/lukasz-antoniak/hibernate-core/commit/fa8427937f5751170714ec97ac059bee9efd8cff
It probably needs some more tuning. Feel free to modify and test. I'm not sure if adding "TOP(100)PERCENT" expression would not 
harm performance too much.

Totally agree that we should simplify things. This is why I wanted to change the query structure, so that aliases do not get 
stripped from the original query, DISTINCT is not simulated with GROUP BY etc.

Regards,
Lukasz


More information about the hibernate-dev mailing list