Doctrine 2 - ORM
  1. Doctrine 2 - ORM
  2. DDC-2794

the Paginator does not support arbitrary join


    • Type: Bug Bug
    • Status: Open
    • Priority: Major Major
    • Resolution: Unresolved
    • Affects Version/s: Git Master, 2.3.4, 2.4.1
    • Fix Version/s: None
    • Component/s: Tools
    • Security Level: All
    • Labels:


      Using the following query with the paginator fails:

      SELECT u
      FROM User u
      JOIN Message m WITH = 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).


        Christophe Coevoet created issue -
        Pierre-Antoine Pinel made changes -
        Field Original Value New Value
        Status Open [ 1 ] Awaiting Feedback [ 10000 ]
        Benjamin Eberlei made changes -
        Status Awaiting Feedback [ 10000 ] Open [ 1 ]


          • Assignee:
            Benjamin Eberlei
            Christophe Coevoet
          • Votes:
            3 Vote for this issue
            5 Start watching this issue


            • Created: