Setting first result and max results on ICriteria creates a wrong sql which does not return any results.
will result in the following query
FROM (SELECT row_.*, ROWNUM rownum_
FROM (SELECT *
FROM table) row_
WHERE ROWNUM <= 100)
WHERE rownum_ > 400
which obviously wont return any rows except when first result < max results
the fix might not be the best solution but at least it works. (Oracle8iDialect.cs)
another thing i noticed while testing: setting only firstresult doesn't work (not fixed).