[hibernate-issues] [Hibernate-JIRA] Created: (HHH-6914) SQL Server: Query with limit fails for HQL with ORDER BY over select clause alias

SQL Server: Query with limit fails for HQL with ORDER BY over select clause alias --------------------------------------------------------------------------------- Key: HHH-6914 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-6914 Project: Hibernate Core Issue Type: Bug Components: core Affects Versions: 3.6.7 Environment: MS SQL Server 2008 Reporter: Piotr Findeisen If the HQL like: {code} SELECT u.id AS id, u.login AS login FROM User u {code} is executed with limit and offset, then {{SQLServer2008Dialect}} produces SQL like {code} WITH query AS (select ROW_NUMBER() OVER (order by col_1) as __hibernate_row_nr__, user.id as col_0, user.login as col_1 from users user ) SELECT * FROM query WHERE __hibernate_row_nr__ BETWEEN ? AND ? {code} This fails, as one select clause expression {{(select ROW_NUMBER() OVER (order by col_1) as __hibernate_row_nr__}} refers to another useing {{col_1}} alias. -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira