Same problem in 3.6 and Oracle
A workaround is build the query in this manner:

– between 101 and 200
select * from ( select row_., rownum rownum_ from ( / criteria query */ select this_.field as ...., ... from TABLE this_ where this_...=filter
order by this_.orderColumn asc
) row_ )
where rownum_ > 100 and rownum <= 200;

instead of:
select * from ( select row_., rownum rownum_ from ( / criteria query */ select this_.field as ...., ... from TABLE this_ where this_...=filter
order by this_.orderColumn asc ) row_ where rownum <= 200) where rownum_ > 100;

Will it be fixed?