Doctrine return error with "eq", no with "in"

Question

With Symfony and Doctrine, I have an error with "eq" subquery :

It's OK, no error :

public function getForums()
{
    $qb = $this->createQueryBuilder('fc');

    return $qb
        ->innerJoin('fc.versions', 'fcv')
        ->innerJoin('fc.versions', 'fcvl', 'WITH', $qb->expr()->in(
            'fcvl.id',
            $this->_em->createQueryBuilder()
                ->select('MAX(v.id)')
                ->from(ForumCategoryVersion::class, 'v')
                ->where('v.forumCategory = fc')
                ->getDQL()
        ))
        ->select('fc, fcv')
        ->getQuery()
        ->getResult();
}

Replace in by eq :

public function getForums()
{
    $qb = $this->createQueryBuilder('fc');

    return $qb
        ->innerJoin('fc.versions', 'fcv')
        ->innerJoin('fc.versions', 'fcvl', 'WITH', $qb->expr()->eq(
            'fcvl.id',
            $this->_em->createQueryBuilder()
                ->select('MAX(v.id)')
                ->from(ForumCategoryVersion::class, 'v')
                ->where('v.forumCategory = fc')
                ->getDQL()
        ))
        ->select('fc, fcv')
        ->getQuery()
        ->getResult();
}

I have this error :

[Syntax Error] line 0, col 208: Error: Expected Literal, got 'SELECT'

Actually, on a 2nd thought, you could create an enhancement issue on doctrine `s github repo and ask to make the use of parenthesis optional. It is weird to be supported on one case and not the other. — Jannes Botis, Dec 08 '18 at 13:06

score 0 · Accepted Answer · answered Dec 04 '18 at 11:08

You need to use parenthesis () for the subquery:

->innerJoin('fc.versions', 'fcvl', 'WITH', $qb->expr()->eq(
        'fcvl.id',
        '(' . $this->_em->createQueryBuilder()
            ->select('MAX(v.id)')
            ->from(ForumCategoryVersion::class, 'v')
            ->where('v.forumCategory = fc')
            ->getDQL() . ')'
    ))

References

Doctrine return error with "eq", no with "in"

1 Answers1

Linked