DDC-2422: HIDDEN fileds doesn't work in subqueries #3037

New Issue

admin · 2026-01-22T14:10:28+01:00

admin commented

2026-01-22 14:10:28 +01:00

Originally created by @doctrinebot on GitHub (Apr 29, 2013).

Originally assigned to: @Ocramius on GitHub.

Jira issue originally created by user yetanotherape:

I trying to execute query with subquery, which contains GROUP BY:

$subqueryBuilder = $repository->createQueryBuilder('l2')
    ->select('l2.id, DATE(l2.created) AS HIDDEN created_date')
    ->groupBy('created_date');

$qb = $repository->createQueryBuilder('l');
$qb->andWhere($qb->expr()->in('l.id', $subqueryBuilder->getDQL()));
$result = $qb->getQuery()->getArrayResult();

And got error:

[Syntax Error] line 0, col 80: Error: Expected Doctrine\ORM\Query\Lexer::T_FROM, got ','

If I group simply by "l2.created" without adding it to selected fields, all works fine. But I must use "DATE(l2.created) AS HIDDEN created_date" in selected statement to specify it in GROUP BY statement.

Originally created by @doctrinebot on GitHub (Apr 29, 2013). Originally assigned to: @Ocramius on GitHub. Jira issue originally created by user yetanotherape: I trying to execute query with subquery, which contains GROUP BY: ``` $subqueryBuilder = $repository->createQueryBuilder('l2') ->select('l2.id, DATE(l2.created) AS HIDDEN created_date') ->groupBy('created_date'); $qb = $repository->createQueryBuilder('l'); $qb->andWhere($qb->expr()->in('l.id', $subqueryBuilder->getDQL())); $result = $qb->getQuery()->getArrayResult(); ``` And got error: ``` [Syntax Error] line 0, col 80: Error: Expected Doctrine\ORM\Query\Lexer::T_FROM, got ',' ``` If I group simply by "l2.created" without adding it to selected fields, all works fine. But I must use "DATE(l2.created) AS HIDDEN created_date" in selected statement to specify it in GROUP BY statement.

admin added the Bug label 2026-01-22 14:10:28 +01:00

admin referenced this issue

2026-01-22 14:20:45 +01:00

DDC-2785: spl_object_hash_collisions #3481

admin referenced this issue

2026-01-22 14:47:38 +01:00

DDC-3827: [GH-1461] Spl_object_hash conflict on Merge #4686

admin referenced this issue

2026-01-22 14:59:13 +01:00

spl_object_hash() re-using hashes after garbage collection runs - reproducable test included #5135

admin referenced this issue

2026-01-22 16:07:39 +01:00