Description Patric Rufflar 2011-11-03 11:02:50 EDT

Build Identifier: 2.1.3

The firstResult property of an EJBQueryImpl cannot be reset to 0 once it has been previously set to a value > 0.

Because setFirstResult(0) is internally represented by -1,
the condition "if (firstResultIndex > -1)" does not hold hence it will not
update the firstResult attribute of the database query:

    protected void propagateResultProperties() {
        DatabaseQuery databaseQuery = getDatabaseQueryInternal();
....
            if (firstResultIndex > -1) {
                cloneSharedQuery();
                readQuery = (ReadQuery) getDatabaseQueryInternal();
                readQuery.setFirstResult(firstResultIndex);
            }
        }
    }


Reproducible: Always

Steps to Reproduce:
1. Create a JPQL Query using EntityManager.createQuery()
2. call setFirstResult(5)
3. execute the query using getResultList().
4. call setFirstResult(0)
5. execute the query again using getResultList()

=> firstResult of 5 is still used