Description Willie Loyd Tandingan 2012-01-27 00:16:49 EST

Build Identifier: 2.3.0.v20110604-r9504

The following code throws a MySQLSyntaxErrorException on query.getResultList():

Query query = em.createQuery("SELECT p FROM WorkUnit p WHERE p.worker IS NULL");
query.setLockMode(LockModeType.PESSIMISTIC_FORCE_INCREMENT);
query.setMaxResults(workUnitsToGive);
List<WorkUnit> workUnits = query.getResultList();


Exception thrown:

Internal Exception: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'LIMIT 0, 2' at line 1
Error Code: 1064
Call: SELECT ID AS a1, DATA AS a2, RESULT AS a3, VERSION AS a4, PROJECT_ID AS a5, WORKER_ID AS a6 FROM WORKUNIT WHERE (WORKER_ID IS NULL) FOR UPDATE LIMIT ?, ?
	bind => [2 parameters bound]


I believe that LIMIT ?, ? should come before FOR UPDATE.

Reproducible: Always