Bug 328730

Description lists 2010-10-26 11:37:11 EDT

Build Identifier: EL 2.1.0

Probably easiest to point to the forum discussion:

http://www.eclipse.org/forums/index.php?t=msg&th=197236&start=0&S=d5dfec1e841c62517ccb6136e8aab980

Generally, on MySQL, if you setMaxResults() to 0, you end up losing the LIMIT portion of the query altogether, resulting in all results being returned. This is very counterintuitive. "LIMIT #, 0" works as expected in MySQL (it returns 0 results) and so it should with EL/JPA. I can understand that a negative entry for MaxResults is undefined, but 0 seems very obvious. It should be documented in the Javadocs in any case as to the behavior of negative values being passed (and 0 if you do not agree that it should behave as expected or for some reason need to make a special case due to some other requirements).

Reproducible: Always

Steps to Reproduce:
1. query.setFirstResult(1).setMaxResults(2).getResultList();
2. View the SQL generated. Should look like "...LIMIT ?, ?  bind => [1, 2]".
3. query.setFirstResult(1).setMaxResults(0).getResultList();
4. View the SQL generated. Should look like "..." with no LIMIT statement at all. Should look like "...LIMIT ?, ?  bind => [1, 0]".