[DDC-1564] MySQL Failure when using setFirstResult() and omitting setMaxResults() Created: 25/Dec/11 Updated: 28/Dec/11
|Project:||Doctrine 2 - ORM|
|Reporter:||Timo A. Hummel||Assignee:||Benjamin Eberlei|
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 by Benjamin Eberlei [ 28/Dec/11 ]|
Changed into improvement, i am not sure how this relates to other databases.
You can just use this workaround yourself so long.