Doctrine 1
  1. Doctrine 1
  2. DC-81

Using WITH in combinations with LIMIT returns unexpected results

    Details

    • Type: Bug Bug
    • Status: Reopened
    • Priority: Major Major
    • Resolution: Unresolved
    • Affects Version/s: 1.2.0-ALPHA1
    • Fix Version/s: None
    • Component/s: None
    • Labels:
      None
    • Environment:
      Mac OS X 10.6.1

      Description

      When I try to limit left joined records with an additional WITH clause, it seems to be bugged when also specifying a LIMIT.

      My DQL:

      FROM Transporter t LEFT JOIN t.Profile p LEFT JOIN t.Requests r WITH (r.distributor_id = ?) WHERE t.is_active = ? ORDER BY p.company_country, p.company_name LIMIT 20

      This returns me 0 results, while removing the LIMIT (or the WITH) will return me 2 results.

        Activity

        Gerry Vandermaesen created issue -
        Jonathan H. Wage made changes -
        Field Original Value New Value
        Status Open [ 1 ] Resolved [ 5 ]
        Resolution Cannot Reproduce [ 5 ]
        Gerry Vandermaesen made changes -
        Resolution Cannot Reproduce [ 5 ]
        Status Resolved [ 5 ] Reopened [ 4 ]

          People

          • Assignee:
            Jonathan H. Wage
            Reporter:
            Gerry Vandermaesen
          • Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

            • Created:
              Updated: