SetFirstResult and SetMaxResults do not work correctly on Oracle (ODP.NET)

Details

Description

Using ODP.NET, create an IQuery and invoke .SetFirstResult(3) and .SetMaxResults(5). This should fetch 8 records, then skip the first 3 records, and then take the next 5 records. Instead, it fetches only 5 records, then skips the first 3, and then returns only 2. The resulting query looks like this: