Uploaded image for project: 'Doctrine 2 - ORM'
  1. Doctrine 2 - ORM
  2. DDC-1564

MySQL Failure when using setFirstResult() and omitting setMaxResults()

    Details

    • Type: Improvement
    • Status: Open
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 2.1.4
    • Fix Version/s: None
    • Component/s: None
    • Security Level: All
    • Labels:
      None

      Description

      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.

        Activity

        felicitus Timo A. Hummel created issue -
        Hide
        beberlei Benjamin Eberlei added a comment -

        Changed into improvement, i am not sure how this relates to other databases.

        You can just use this workaround yourself so long.

        Show
        beberlei Benjamin Eberlei added a comment - Changed into improvement, i am not sure how this relates to other databases. You can just use this workaround yourself so long.
        beberlei Benjamin Eberlei made changes -
        Field Original Value New Value
        Issue Type Bug [ 1 ] Improvement [ 4 ]
        beberlei Benjamin Eberlei made changes -
        Workflow jira [ 13308 ] jira-feedback [ 14006 ]
        beberlei Benjamin Eberlei made changes -
        Workflow jira-feedback [ 14006 ] jira-feedback2 [ 15870 ]
        beberlei Benjamin Eberlei made changes -
        Workflow jira-feedback2 [ 15870 ] jira-feedback3 [ 18126 ]

        This list may be incomplete, as errors occurred whilst retrieving source from linked applications:

        • Request to http://www.doctrine-project.org/fisheye/ failed: Error in remote call to 'FishEye 0 (http://www.doctrine-project.org/fisheye/)' (http://www.doctrine-project.org/fisheye) [AbstractRestCommand{path='/rest-service-fe/search-v1/crossRepositoryQuery', params={expand=changesets[0:20].revisions[0:29],reviews, query=DDC-1564}, methodType=GET}] : Received status code 503 (Service Temporarily Unavailable)

          People

          • Assignee:
            beberlei Benjamin Eberlei
            Reporter:
            felicitus Timo A. Hummel
          • Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

            • Created:
              Updated: