i found that Oracle9iDialect user different sql to implement the paging query between the first page(without offset) and the afters.
When query for the first page, the sql is "select * from (inner orderSql) where rownum < ?", but in fact ,i think this sql will not certainly select the first rows of the ordered results, is there any operation i skipped at the paging select ?