Details
-
Type:
Bug
-
Status:
Reopened
-
Priority:
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
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 ] |