What query fails for you in 4.1.7? Current master transforms query posted by Piotr to the one below (which seems correct):

WITH query AS (
    SELECT inner_query.*
         , ROW_NUMBER() OVER (ORDER BY CURRENT_TIMESTAMP) as __hibernate_row_nr__
    FROM (
           SELECT u.id as page0_
                , ( SELECT COUNT(DISTINCT role.id) FROM Role role ) as page1_
             FROM User u
         ) inner_query
)
SELECT page0_, page1_ FROM query WHERE __hibernate_row_nr__ >= ? AND __hibernate_row_nr__ < ?

This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira