setMaxResults does not return specified number of records

[Patel, Sanjay]

Hi, All

my query is like this.

String queryString = "SELECT a FROM Table_A a LEFT JOIN FETCH
a.collection_of_b WHERE my_condition
Query q = em.createQuery(queryString);
                q.setFirstResult(0);
                q.setMaxResults(25);
q.getResultList()


above query does not return 25 records but it returns random number of
records.

If I remove FETCH and just do LEFT JOIN, instead of returning
collection_of_b, it returns 25 but duplicate records.

any help will be appreciated

thanks,

-sanjay