Affects Version/s: 2.1.4
Fix Version/s: None
Security Level: All
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.
|Field||Original Value||New Value|
|Issue Type||Bug [ 1 ]||Improvement [ 4 ]|
|Workflow||jira [ 13308 ]||jira-feedback [ 14006 ]|
|Workflow||jira-feedback [ 14006 ]||jira-feedback2 [ 15870 ]|
|Workflow||jira-feedback2 [ 15870 ]||jira-feedback3 [ 18126 ]|