Hibernate pagination generated script execution return incorrect data.

I found this when I have retrieved data from a view. I have created table, data, view generation script for you to reproduce this bug.

According to hibernate sources getLimitString method from org.hibernate.dialect.Oracle9iDialect

Lets first select all rows from view:

select * from v_mytable_last order by status desc

Result:

After that is we are using hibernate pagination for first page then we have an appended code at first and last line of request:

select * from ( 
select * from v_mytable_last order by status desc
 ) where rownum <= 5

Result:

And for second page we are having offset so hibernate execute:

select * from ( 
select * from v_mytable_last order by status desc
 ) where rownum <= 5

Result:

You can see for the second page ROWNUM_ seem to be correct but the data is not.
I was wonder to find this bug. I found it reproducible only for my view, not for table.

To solve this issue I has to override dialect and use my own implementation:

    final StringBuilder pagingSelect = new StringBuilder( sql.length() + 100 )
    pagingSelect.append( "select * from ( select row_.*, rownum rownum_ from ( " )
    pagingSelect.append( sql )
    if (hasOffset) {
      pagingSelect.append( " ) row_ ) where rownum_ <= ? and rownum_ > ? " )
    }
    else {
      pagingSelect.append( " ) row_ ) where rownum_ <= ?" )
    }

This code is working correct for views as well as for tables.