Jira issue originally created by user felicitus:
When using setFirstResult() and omitting setMaxResults(), MySQL throws an error. This was very confusing for me until I dumped the SQL statements and found out the reason.
I know that MySQL doesn't directly support this, their manual says that you should set the second parameter to LIMIT to a very high number (18446744073709551615 in their example).
I'd recommend that either throwing an error in the specific platform driver or follow the MySQL example.
Comment created by @beberlei:
Changed into improvement, i am not sure how this relates to other databases.
You can just use this workaround yourself so long.