Skip to content

Loading…

DDC-2915: When there are 2 identical aliases in an object hydrated dql query tied to a relation, some times it retrives an empty relation #3674

Closed
doctrinebot opened this Issue · 2 comments

2 participants

@doctrinebot

Jira issue originally created by user willf1976:

Hi

I recently had a problem with a Dql query I wrote where when I had a typo in my select which resulted in a very odd behavior. At a predictable row number one of the relations wouldn't hydrate.

This resulted in the fatal error when I tried to access the relation like so: $row->getLolGameSize()->getName()

Call to a member function getName() on a non-object

Here is the query that causes the problem -- removing the second reference to lgs in the select fixes the problem.

SELECT lst, ls, lr, lt, lstlt, lgt, lgs, lgs, ats
FROM Team\Entity\Lolsummonertournament lst
INNER JOIN lst.lolSummoner ls
INNER JOIN ls.lolRank lr
INNER JOIN ls.lolTier lt
LEFT JOIN lst.lolTier lstlt
INNER JOIN lst.lolGameType lgt
INNER JOIN lst.lolGameSize lgs
INNER JOIN lst.attendanceStatus ats
WHERE lst.tournament = :tournamentId
AND ls.summonerId IS NOT NULL
AND ls.mmr IS NOT NULL
ORDER BY ls.mmr desc

All the best

@doctrinebot

Comment created by @ocramius:

Fetch joining on filtered associations is very dangerous and unsupported.

@doctrinebot

Issue was closed with resolution "Invalid"

@Ocramius Ocramius was assigned by doctrinebot
@doctrinebot doctrinebot closed this
@doctrinebot doctrinebot added the Bug label
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Something went wrong with that request. Please try again.