DDC-1815: using aliases from select clause in having clause does not work #2472

Closed
doctrinebot opened this Issue May 8, 2012 · 3 comments

2 participants

@doctrinebot

Jira issue originally created by user burgov:

I have the following DQL:

SELECT e, count(s) AS shiftsTooLate FROM RAI\ShifterBundle\Entity\Worker e INNER JOIN e.person person LEFT JOIN e.shifts s 
WITH s.reasonTooLate IS NOT NULL LEFT JOIN e.person a96582 LEFT JOIN e.person a31040 LEFT JOIN e.person a49970 
LEFT JOIN e.pools a30107 LEFT JOIN e.person a12776 LEFT JOIN a12776.qualifications a78193 LEFT JOIN e.person a38925 
WHERE (e.blacklist = :f0) AND (e.haccpInstruction = :f1) AND (e.introductoryMaterial = :f2) GROUP BY e.id HAVING (shiftsTooLate = :f3) 
ORDER BY e.id ASC

When I try to execute this query, I get an undefined index error:

https://gist.github.com/139220fe4ef7097d05d5

@doctrinebot

Comment created by @beberlei:

can you execute the query without being wrapped into KNP Paginator?

@doctrinebot

Comment created by @beberlei:

No feedback given and executed in context of knp paginator, which probably is the source of the error.

@doctrinebot

Issue was closed with resolution "Cannot Reproduce"

@beberlei beberlei was assigned by doctrinebot Dec 6, 2015
@doctrinebot doctrinebot closed this Dec 6, 2015
@doctrinebot doctrinebot added the Bug label Dec 7, 2015
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment