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

the Paginator does not support arbitrary join

    Details

    • Type: Improvement
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: Git Master, 2.3.4, 2.4.1
    • Fix Version/s: 2.5
    • Component/s: Tools
    • Security Level: All
    • Labels:

      Description

      Using the following query with the paginator fails:

      SELECT u
      FROM User u
      JOIN Message m WITH m.author = u
      WHERE m.status = 'draft' -- a condition justifying the join
      

      The CountWalker and the CountOutputWalker both throw a exception saying "Cannot count query which selects two FROM components, cannot make distinction"

      This message is wrong (I can make distinction here. Only User is selected in the result set) and confusing (I spent some time finding the second FROM before figuring it was related to the use of an arbitrary join instead of an association join).

        Issue Links

          Activity

          stof Christophe Coevoet created issue -
          ppinel Pierre-Antoine Pinel made changes -
          Field Original Value New Value
          Status Open [ 1 ] Awaiting Feedback [ 10000 ]
          beberlei Benjamin Eberlei made changes -
          Status Awaiting Feedback [ 10000 ] Open [ 1 ]
          ocramius Marco Pivetta made changes -
          Remote Link This issue links to "Merge commit (Web Link)" [ 10064 ]
          ocramius Marco Pivetta made changes -
          Status Open [ 1 ] Resolved [ 5 ]
          Assignee Benjamin Eberlei [ beberlei ] Marco Pivetta [ ocramius ]
          Fix Version/s 2.5 [ 10522 ]
          Resolution Fixed [ 1 ]
          ocramius Marco Pivetta made changes -
          Link This issue depends on DDC-3233 [ DDC-3233 ]
          ocramius Marco Pivetta made changes -
          Issue Type Bug [ 1 ] Improvement [ 4 ]

            People

            • Assignee:
              ocramius Marco Pivetta
              Reporter:
              stof Christophe Coevoet
            • Votes:
              3 Vote for this issue
              Watchers:
              7 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: