DDC-3364: QueryBuilder fails when using alias in having with like expr #3883

New Issue

Open

opened 2026-01-22 14:30:21 +01:00 by admin · 11 comments

admin commented 2026-01-22 14:30:21 +01:00

Owner

Copy Link

Originally created by @doctrinebot on GitHub (May 21, 2014).

Jira issue originally created by user webdevilopers:

In my select I create an alias. I use a like expr on this alias in the having clause.

Trying several variations I still get the following error:
Expected '.' or '(', got 'long_name'

My example including variations inside comments:

$having = $qb->expr()->like('long_name', $qb->expr()->literal('%' . $term . '%'));

$qb->select(array(
    'b.id', 'b.name AS branch_name',
    'c.name AS company_name',
    'GroupConcat(b.name, \', \', c.name) AS long*name' // same for 'c.name AS long*name'
))
->from('Application\Entity\Branch', 'b')
->join('b.company', 'c')
->where('b.compartment = 1')
->having('(' . $having . ')') // same for having($having)
->groupBy('c.id')
->orderBy('c.name')
->addOrderBy('b.name');

I use a Doctrine Extension for the MySQL GROUP_CONCAT functionality:
https://github.com/beberlei/DoctrineExtensions/blob/master/lib/DoctrineExtensions/Query/Mysql/GroupConcat.php

This should have no effect on the result since I tried a simple alias - see comment - instead of it.

The problem seems to be using an alias inside the having clause when adding the like expr.
The following clause would work:

$having = $qb->expr()->like('c.name', $qb->expr()->literal('%' . $term . '%'));

I also tried this workaround using the GROUP_CONCAT method inside the where part:

->andWhere($qb->expr()->like('GroupConcat(b.name, \', \', c.name)', $qb->expr()->literal('%' . $term . '%')))

Allthough I used the groupBy part I got this error:
General error: 1111 Invalid use of group function

Originally created by @doctrinebot on GitHub (May 21, 2014). Jira issue originally created by user webdevilopers: In my select I create an alias. I use a like expr on this alias in the having clause. Trying several variations I still get the following error: **Expected '.' or '(', got 'long_name'** My example including variations inside comments: ``` $having = $qb->expr()->like('long_name', $qb->expr()->literal('%' . $term . '%')); $qb->select(array( 'b.id', 'b.name AS branch_name', 'c.name AS company_name', 'GroupConcat(b.name, \', \', c.name) AS long*name' // same for 'c.name AS long*name' )) ->from('Application\Entity\Branch', 'b') ->join('b.company', 'c') ->where('b.compartment = 1') ->having('(' . $having . ')') // same for having($having) ->groupBy('c.id') ->orderBy('c.name') ->addOrderBy('b.name'); ``` I use a Doctrine Extension for the _MySQL_ _GROUP_CONCAT_ functionality: https://github.com/beberlei/DoctrineExtensions/blob/master/lib/DoctrineExtensions/Query/Mysql/GroupConcat.php This should have no effect on the result since I tried a simple alias - see comment - instead of it. The problem seems to be using an alias inside the having clause when adding the like expr. The following clause would work: ``` $having = $qb->expr()->like('c.name', $qb->expr()->literal('%' . $term . '%')); ``` I also tried this workaround using the _GROUP_CONCAT_ method inside the _where_ part: ``` ->andWhere($qb->expr()->like('GroupConcat(b.name, \', \', c.name)', $qb->expr()->literal('%' . $term . '%'))) ``` Allthough I used the _groupBy_ part I got this error: **General error: 1111 Invalid use of group function**

admin added the BugMissing Tests labels 2026-01-22 14:30:21 +01:00

admin commented 2026-01-22 14:30:21 +01:00

Author

Owner

Copy Link

@doctrinebot commented on GitHub (Jun 26, 2014):

Comment created by @ocramius:

What is the actual failure/exception type? What about the generated SQL?

@doctrinebot commented on GitHub (Jun 26, 2014): Comment created by @ocramius: What is the actual failure/exception type? What about the generated SQL?

admin commented 2026-01-22 14:30:22 +01:00

Author

Owner

Copy Link

@doctrinebot commented on GitHub (Oct 26, 2014):

Comment created by @deeky666:

Moved to ORM, the error and use case is ORM related.

@doctrinebot commented on GitHub (Oct 26, 2014): Comment created by @deeky666: Moved to ORM, the error and use case is ORM related.

admin commented 2026-01-22 14:30:22 +01:00

Author

Owner

Copy Link

@doctrinebot commented on GitHub (Aug 4, 2015):

Comment created by kryniol:

Same here. It has nothing in common with usage of GROUP_CONCAT. The simpliest example I can think of:

public function test()
{
    return $this->createQueryBuilder('b')
        ->select('b.id AS id')
        ->having('id LIKE :foobar')
        ->setParameter('foobar', 'foobar')
        ->getQuery()
        ->getResult();
}

This produces following error (full stacktrace from Symfony2 app):

{quote}
[1] Doctrine\ORM\Query\QueryException: [Syntax Error] line 0, col 73: Error: Expected '.' or '(', got 'id'
at n/a
in /var/www/myproject/vendor/doctrine/orm/lib/Doctrine/ORM/Query/QueryException.php line 52

at Doctrine\ORM\Query\QueryException::syntaxError('line 0, col 73: Error: Expected '.' or '(', got 'id'', object(QueryException))
    in /var/www/myproject/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php line 448

at Doctrine\ORM\Query\Parser->syntaxError(''.' or '('')
    in /var/www/myproject/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php line 2821

at Doctrine\ORM\Query\Parser->StringPrimary()
    in /var/www/myproject/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php line 2798

at Doctrine\ORM\Query\Parser->StringExpression()
    in /var/www/myproject/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php line 3085

at Doctrine\ORM\Query\Parser->LikeExpression()
    in /var/www/myproject/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php line 2478

at Doctrine\ORM\Query\Parser->SimpleConditionalExpression()
    in /var/www/myproject/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php line 2384

at Doctrine\ORM\Query\Parser->ConditionalPrimary()
    in /var/www/myproject/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php line 2360

at Doctrine\ORM\Query\Parser->ConditionalFactor()
    in /var/www/myproject/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php line 2328

at Doctrine\ORM\Query\Parser->ConditionalTerm()
    in /var/www/myproject/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php line 2303

at Doctrine\ORM\Query\Parser->ConditionalExpression()
    in /var/www/myproject/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php line 1339

at Doctrine\ORM\Query\Parser->HavingClause()
    in /var/www/myproject/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php line 878

at Doctrine\ORM\Query\Parser->SelectStatement()
    in /var/www/myproject/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php line 843

at Doctrine\ORM\Query\Parser->QueryLanguage()
    in /var/www/myproject/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php line 268

at Doctrine\ORM\Query\Parser->getAST()
    in /var/www/myproject/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php line 351

at Doctrine\ORM\Query\Parser->parse()
    in /var/www/myproject/vendor/doctrine/orm/lib/Doctrine/ORM/Query.php line 255

at Doctrine\ORM\Query->_parse()
    in /var/www/myproject/vendor/doctrine/orm/lib/Doctrine/ORM/Query.php line 267

at Doctrine\ORM\Query->_doExecute()
    in /var/www/myproject/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php line 794

at Doctrine\ORM\AbstractQuery->execute(null, '1')
    in /var/www/myproject/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php line 574

at Doctrine\ORM\AbstractQuery->getResult()
    in /var/www/myproject/src/MyProject/MyBundle/Repository/MyEntityRepository.php line 94

at MyProject\MyBundle\Repository\MyEntityRepository->test()
    in /var/www/myproject/src/MyProject/MyEntityBundle/Controller/MyEntityController.php line 146

at MyProject\MyEntityBundle\Controller\MyEntityController->listResultAction(object(Request))
    in  line 

at call*user_func*array(array(object(MyEntityController), 'listResultAction'), array(object(Request)))
    in /var/www/myproject/app/bootstrap.php.cache line 3094

at Symfony\Component\HttpKernel\HttpKernel->handleRaw(object(Request), '1')
    in /var/www/myproject/app/bootstrap.php.cache line 3056

at Symfony\Component\HttpKernel\HttpKernel->handle(object(Request), '1', true)
    in /var/www/myproject/app/bootstrap.php.cache line 3207

at Symfony\Component\HttpKernel\DependencyInjection\ContainerAwareHttpKernel->handle(object(Request), '1', true)
    in /var/www/myproject/app/bootstrap.php.cache line 2429

at Symfony\Component\HttpKernel\Kernel->handle(object(Request))
    in /var/www/myproject/web/app_dev.php line 28

[2] Doctrine\ORM\Query\QueryException: SELECT b.id AS id FROM MyProject\MyBundle\Entity\MyEntity b HAVING id LIKE foobar
at n/a
in /var/www/myproject/vendor/doctrine/orm/lib/Doctrine/ORM/Query/QueryException.php line 41

at Doctrine\ORM\Query\QueryException::dqlError('SELECT b.id AS id FROM MyProject\MyBundle\Entity\MyEntity b HAVING id LIKE foobar')
    in /var/www/myproject/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php line 448

at Doctrine\ORM\Query\Parser->syntaxError(''.' or '('')
    in /var/www/myproject/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php line 2821

at Doctrine\ORM\Query\Parser->StringPrimary()
    in /var/www/myproject/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php line 2798

at Doctrine\ORM\Query\Parser->StringExpression()
    in /var/www/myproject/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php line 3085

at Doctrine\ORM\Query\Parser->LikeExpression()
    in /var/www/myproject/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php line 2478

at Doctrine\ORM\Query\Parser->SimpleConditionalExpression()
    in /var/www/myproject/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php line 2384

at Doctrine\ORM\Query\Parser->ConditionalPrimary()
    in /var/www/myproject/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php line 2360

at Doctrine\ORM\Query\Parser->ConditionalFactor()
    in /var/www/myproject/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php line 2328

at Doctrine\ORM\Query\Parser->ConditionalTerm()
    in /var/www/myproject/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php line 2303

at Doctrine\ORM\Query\Parser->ConditionalExpression()
    in /var/www/myproject/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php line 1339

at Doctrine\ORM\Query\Parser->HavingClause()
    in /var/www/myproject/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php line 878

at Doctrine\ORM\Query\Parser->SelectStatement()
    in /var/www/myproject/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php line 843

at Doctrine\ORM\Query\Parser->QueryLanguage()
    in /var/www/myproject/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php line 268

at Doctrine\ORM\Query\Parser->getAST()
    in /var/www/myproject/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php line 351

at Doctrine\ORM\Query\Parser->parse()
    in /var/www/myproject/vendor/doctrine/orm/lib/Doctrine/ORM/Query.php line 255

at Doctrine\ORM\Query->_parse()
    in /var/www/myproject/vendor/doctrine/orm/lib/Doctrine/ORM/Query.php line 267

at Doctrine\ORM\Query->_doExecute()
    in /var/www/myproject/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php line 794

at Doctrine\ORM\AbstractQuery->execute(null, '1')
    in /var/www/myproject/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php line 574

at Doctrine\ORM\AbstractQuery->getResult()
    in /var/www/myproject/src/MyProject/MyBundle/Repository/MyEntityRepository.php line 94

at MyProject\MyBundle\Repository\MyEntityRepository->test()
    in /var/www/myproject/src/MyProject/MyEntityBundle/Controller/MyEntityController.php line 146

at MyProject\MyEntityBundle\Controller\MyEntityController->listResultAction(object(Request))
    in  line 

at call*user_func*array(array(object(MyEntityController), 'listResultAction'), array(object(Request)))
    in /var/www/myproject/app/bootstrap.php.cache line 3094

at Symfony\Component\HttpKernel\HttpKernel->handleRaw(object(Request), '1')
    in /var/www/myproject/app/bootstrap.php.cache line 3056

at Symfony\Component\HttpKernel\HttpKernel->handle(object(Request), '1', true)
    in /var/www/myproject/app/bootstrap.php.cache line 3207

at Symfony\Component\HttpKernel\DependencyInjection\ContainerAwareHttpKernel->handle(object(Request), '1', true)
    in /var/www/myproject/app/bootstrap.php.cache line 2429

at Symfony\Component\HttpKernel\Kernel->handle(object(Request))
    in /var/www/myproject/web/app_dev.php line 28

{quote}

Note that the following example works like a charm:

public function test()
{
    return $this->createQueryBuilder('b')
        ->select('b.id AS id')
        ->having('id = :foobar')
        ->setParameter('foobar', 'foobar')
        ->getQuery()
        ->getResult();
}

Has anyone by any chance found any, even temporary workaround for this issue?

@doctrinebot commented on GitHub (Aug 4, 2015): Comment created by kryniol: Same here. It has nothing in common with usage of GROUP_CONCAT. The simpliest example I can think of: ``` public function test() { return $this->createQueryBuilder('b') ->select('b.id AS id') ->having('id LIKE :foobar') ->setParameter('foobar', 'foobar') ->getQuery() ->getResult(); } ``` This produces following error (full stacktrace from Symfony2 app): {quote} [1] Doctrine\ORM\Query\QueryException: [Syntax Error] line 0, col 73: Error: Expected '.' or '(', got 'id' at n/a in /var/www/myproject/vendor/doctrine/orm/lib/Doctrine/ORM/Query/QueryException.php line 52 ``` at Doctrine\ORM\Query\QueryException::syntaxError('line 0, col 73: Error: Expected '.' or '(', got 'id'', object(QueryException)) in /var/www/myproject/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php line 448 at Doctrine\ORM\Query\Parser->syntaxError(''.' or '('') in /var/www/myproject/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php line 2821 at Doctrine\ORM\Query\Parser->StringPrimary() in /var/www/myproject/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php line 2798 at Doctrine\ORM\Query\Parser->StringExpression() in /var/www/myproject/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php line 3085 at Doctrine\ORM\Query\Parser->LikeExpression() in /var/www/myproject/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php line 2478 at Doctrine\ORM\Query\Parser->SimpleConditionalExpression() in /var/www/myproject/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php line 2384 at Doctrine\ORM\Query\Parser->ConditionalPrimary() in /var/www/myproject/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php line 2360 at Doctrine\ORM\Query\Parser->ConditionalFactor() in /var/www/myproject/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php line 2328 at Doctrine\ORM\Query\Parser->ConditionalTerm() in /var/www/myproject/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php line 2303 at Doctrine\ORM\Query\Parser->ConditionalExpression() in /var/www/myproject/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php line 1339 at Doctrine\ORM\Query\Parser->HavingClause() in /var/www/myproject/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php line 878 at Doctrine\ORM\Query\Parser->SelectStatement() in /var/www/myproject/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php line 843 at Doctrine\ORM\Query\Parser->QueryLanguage() in /var/www/myproject/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php line 268 at Doctrine\ORM\Query\Parser->getAST() in /var/www/myproject/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php line 351 at Doctrine\ORM\Query\Parser->parse() in /var/www/myproject/vendor/doctrine/orm/lib/Doctrine/ORM/Query.php line 255 at Doctrine\ORM\Query->_parse() in /var/www/myproject/vendor/doctrine/orm/lib/Doctrine/ORM/Query.php line 267 at Doctrine\ORM\Query->_doExecute() in /var/www/myproject/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php line 794 at Doctrine\ORM\AbstractQuery->execute(null, '1') in /var/www/myproject/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php line 574 at Doctrine\ORM\AbstractQuery->getResult() in /var/www/myproject/src/MyProject/MyBundle/Repository/MyEntityRepository.php line 94 at MyProject\MyBundle\Repository\MyEntityRepository->test() in /var/www/myproject/src/MyProject/MyEntityBundle/Controller/MyEntityController.php line 146 at MyProject\MyEntityBundle\Controller\MyEntityController->listResultAction(object(Request)) in line at call*user_func*array(array(object(MyEntityController), 'listResultAction'), array(object(Request))) in /var/www/myproject/app/bootstrap.php.cache line 3094 at Symfony\Component\HttpKernel\HttpKernel->handleRaw(object(Request), '1') in /var/www/myproject/app/bootstrap.php.cache line 3056 at Symfony\Component\HttpKernel\HttpKernel->handle(object(Request), '1', true) in /var/www/myproject/app/bootstrap.php.cache line 3207 at Symfony\Component\HttpKernel\DependencyInjection\ContainerAwareHttpKernel->handle(object(Request), '1', true) in /var/www/myproject/app/bootstrap.php.cache line 2429 at Symfony\Component\HttpKernel\Kernel->handle(object(Request)) in /var/www/myproject/web/app_dev.php line 28 ``` [2] Doctrine\ORM\Query\QueryException: SELECT b.id AS id FROM MyProject\MyBundle\Entity\MyEntity b HAVING id LIKE foobar at n/a in /var/www/myproject/vendor/doctrine/orm/lib/Doctrine/ORM/Query/QueryException.php line 41 ``` at Doctrine\ORM\Query\QueryException::dqlError('SELECT b.id AS id FROM MyProject\MyBundle\Entity\MyEntity b HAVING id LIKE foobar') in /var/www/myproject/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php line 448 at Doctrine\ORM\Query\Parser->syntaxError(''.' or '('') in /var/www/myproject/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php line 2821 at Doctrine\ORM\Query\Parser->StringPrimary() in /var/www/myproject/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php line 2798 at Doctrine\ORM\Query\Parser->StringExpression() in /var/www/myproject/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php line 3085 at Doctrine\ORM\Query\Parser->LikeExpression() in /var/www/myproject/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php line 2478 at Doctrine\ORM\Query\Parser->SimpleConditionalExpression() in /var/www/myproject/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php line 2384 at Doctrine\ORM\Query\Parser->ConditionalPrimary() in /var/www/myproject/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php line 2360 at Doctrine\ORM\Query\Parser->ConditionalFactor() in /var/www/myproject/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php line 2328 at Doctrine\ORM\Query\Parser->ConditionalTerm() in /var/www/myproject/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php line 2303 at Doctrine\ORM\Query\Parser->ConditionalExpression() in /var/www/myproject/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php line 1339 at Doctrine\ORM\Query\Parser->HavingClause() in /var/www/myproject/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php line 878 at Doctrine\ORM\Query\Parser->SelectStatement() in /var/www/myproject/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php line 843 at Doctrine\ORM\Query\Parser->QueryLanguage() in /var/www/myproject/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php line 268 at Doctrine\ORM\Query\Parser->getAST() in /var/www/myproject/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php line 351 at Doctrine\ORM\Query\Parser->parse() in /var/www/myproject/vendor/doctrine/orm/lib/Doctrine/ORM/Query.php line 255 at Doctrine\ORM\Query->_parse() in /var/www/myproject/vendor/doctrine/orm/lib/Doctrine/ORM/Query.php line 267 at Doctrine\ORM\Query->_doExecute() in /var/www/myproject/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php line 794 at Doctrine\ORM\AbstractQuery->execute(null, '1') in /var/www/myproject/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php line 574 at Doctrine\ORM\AbstractQuery->getResult() in /var/www/myproject/src/MyProject/MyBundle/Repository/MyEntityRepository.php line 94 at MyProject\MyBundle\Repository\MyEntityRepository->test() in /var/www/myproject/src/MyProject/MyEntityBundle/Controller/MyEntityController.php line 146 at MyProject\MyEntityBundle\Controller\MyEntityController->listResultAction(object(Request)) in line at call*user_func*array(array(object(MyEntityController), 'listResultAction'), array(object(Request))) in /var/www/myproject/app/bootstrap.php.cache line 3094 at Symfony\Component\HttpKernel\HttpKernel->handleRaw(object(Request), '1') in /var/www/myproject/app/bootstrap.php.cache line 3056 at Symfony\Component\HttpKernel\HttpKernel->handle(object(Request), '1', true) in /var/www/myproject/app/bootstrap.php.cache line 3207 at Symfony\Component\HttpKernel\DependencyInjection\ContainerAwareHttpKernel->handle(object(Request), '1', true) in /var/www/myproject/app/bootstrap.php.cache line 2429 at Symfony\Component\HttpKernel\Kernel->handle(object(Request)) in /var/www/myproject/web/app_dev.php line 28 ``` {quote} Note that the following example works like a charm: ``` public function test() { return $this->createQueryBuilder('b') ->select('b.id AS id') ->having('id = :foobar') ->setParameter('foobar', 'foobar') ->getQuery() ->getResult(); } ``` Has anyone by any chance found any, even temporary workaround for this issue?

admin commented 2026-01-22 14:30:23 +01:00

Author

Owner

Copy Link

@doctrinebot commented on GitHub (Aug 5, 2015):

Comment created by kryniol:

My temp solution is to use custom function which is being resolved to LIKE expression: https://gist.github.com/Kryniol/901255742078bdb8aa1d
And the possible bug is that Doctrine\ORM\Query\Parser::LikeExpression() matches StringExpression instead of ArithmeticExpression (as for the ComparisonExpression) in the first part of LIKE. When changed to ArithmeticExpression in the Parser class itself, my code started working. But I'm not sure what this change could break...

@doctrinebot commented on GitHub (Aug 5, 2015): Comment created by kryniol: My temp solution is to use custom function which is being resolved to LIKE expression: https://gist.github.com/Kryniol/901255742078bdb8aa1d And the possible bug is that Doctrine\ORM\Query\Parser::LikeExpression() matches StringExpression instead of ArithmeticExpression (as for the ComparisonExpression) in the first part of LIKE. When changed to ArithmeticExpression in the Parser class itself, my code started working. But I'm not sure what this change could break...

admin commented 2026-01-22 14:30:23 +01:00

Author

Owner

Copy Link

@doctrinebot commented on GitHub (Aug 27, 2015):

Comment created by Raphi:

I have the same issue.
In DQL, it's possible to get around this bug by writing CONCAT in like condition too.
For example :
{quote}SELECT *, CONCAT('', field1, '')
FROM *
GROUP BY ******
HAVING CONCAT('', field1, '') LIKE ******{quote}
Please replace the stars with the right values.

@doctrinebot commented on GitHub (Aug 27, 2015): Comment created by Raphi: I have the same issue. In DQL, it's possible to get around this bug by writing CONCAT in like condition too. For example : {quote}SELECT *****_, CONCAT('__', field1, '__') FROM *_**** GROUP BY ****** HAVING CONCAT('__', field1, '__') LIKE ******{quote} Please replace the stars with the right values.

admin commented 2026-01-22 14:30:23 +01:00

Author

Owner

Copy Link

@qferr commented on GitHub (Apr 1, 2016):

Have you fix this bug ? I have the same error. Thank you.

@qferr commented on GitHub (Apr 1, 2016): Have you fix this bug ? I have the same error. Thank you.

admin commented 2026-01-22 14:30:24 +01:00

Author

Owner

Copy Link

@kimpixel commented on GitHub (Jul 14, 2016):

Hi
This Bug is still present!

The custom like extension from "kryniol" is also not working or i unable to setup it right.
And the workaround from "Raphi" is no option for me (have some auto generated code)

can someone help to get this working?

I am in the Flow 3.0 Framework:
$this->getEntityManager()->getConfiguration()->addCustomStringFunction('like', 'XXX\YYYYY\Doctrine\Functions\Like');

@kimpixel commented on GitHub (Jul 14, 2016): Hi This Bug is still present! The custom like extension from "kryniol" is also not working or i unable to setup it right. And the workaround from "Raphi" is no option for me (have some auto generated code) can someone help to get this working? I am in the Flow 3.0 Framework: `$this->getEntityManager()->getConfiguration()->addCustomStringFunction('like', 'XXX\YYYYY\Doctrine\Functions\Like');`

admin commented 2026-01-22 14:30:28 +01:00

Author

Owner

Copy Link

@Ocramius commented on GitHub (Jul 15, 2016):

Write a failing test case, then the fix becomes easier to find.

@Ocramius commented on GitHub (Jul 15, 2016): Write a failing test case, then the fix becomes easier to find.

admin commented 2026-01-22 14:30:29 +01:00

Author

Owner

Copy Link

@kimpixel commented on GitHub (Jul 15, 2016):

hi the bug is very simple to reproduce as "kryniol" wrote above

public function test()
{
    return $this->createQueryBuilder('b')
        ->select('b.id AS id')
        ->having('id LIKE :foobar')
        ->setParameter('foobar', 'foobar')
        ->getQuery()
        ->getResult();
}

@kimpixel commented on GitHub (Jul 15, 2016): hi the bug is very simple to reproduce as "kryniol" wrote above ``` public function test() { return $this->createQueryBuilder('b') ->select('b.id AS id') ->having('id LIKE :foobar') ->setParameter('foobar', 'foobar') ->getQuery() ->getResult(); } ```

admin commented 2026-01-22 14:30:31 +01:00

Author

Owner

Copy Link

@Ocramius commented on GitHub (Jul 15, 2016):

Yes, which means that it is simple to send a pull request with a failing test case ;-)

@Ocramius commented on GitHub (Jul 15, 2016): Yes, which means that it is simple to send a pull request with a failing test case ;-)

admin commented 2026-01-22 14:30:31 +01:00

Author

Owner

Copy Link

@romaricdrigon commented on GitHub (Oct 1, 2019):

I just tried as I was investing #7846, I could not reproduce.

@romaricdrigon commented on GitHub (Oct 1, 2019): I just tried as I was investing #7846, I could not reproduce.

Sign in to join this conversation.

No Branch/Tag Specified

Branches Tags

3.6.x

2.20.x

dependabot/github_actions/2.20.x/doctrine/dot-github/dot-github/workflows/composer-lint.yml-14.0.0

3.7.x

4.0.x

2.21.x

old-prototype-3.x

3.6.2

3.6.1

3.6.0

2.20.9

3.5.8

3.5.7

3.5.6

3.5.5

2.20.8

3.5.4

3.5.3

2.20.7

3.5.2

2.20.6

3.5.1

3.5.0

3.4.4

3.4.3

3.4.2

2.20.5

3.4.1

3.4.0

3.3.4

2.20.4

3.3.3

2.20.3

3.3.2

2.20.2

3.3.1

2.20.1

3.3.0

3.2.3

2.20.0

2.19.8

3.2.2

2.19.7

3.2.1

2.19.6

3.2.0

3.1.4

3.1.3

2.19.5

3.1.2

2.19.4

3.1.1

2.19.3

2.19.2

2.19.1

3.1.0

2.19.0

3.0.3

2.18.3

3.0.2

2.18.2

3.0.1

2.18.1

3.0.0

2.18.0

2.17.5

3.0.0-RC1

2.17.4

2.17.3

2.17.2

2.17.1

3.0.0-beta2

2.17.0

2.16.3

3.0.0-beta1

2.16.2

2.16.1

2.16.0

2.15.5

2.15.4

2.15.3

2.15.2

2.15.1

2.15.0

2.14.3

2.14.2

2.14.1

2.14.0

2.13.5

2.13.4

2.13.3

2.13.2

2.13.1

2.13.0

2.12.4

2.12.3

2.12.2

2.12.1

2.12.0

2.11.3

2.11.2

2.11.1

2.11.0

2.10.5

2.10.4

2.10.3

2.10.2

2.10.1

2.10.0

2.9.6

2.9.5

2.9.4

2.9.3

2.9.2

2.9.1

2.9.0

2.8.5

2.8.4

2.8.3

2.8.2

2.8.1

2.8.0

2.7.5

2.7.4

v2.7.3

v2.7.2

v2.7.1

v2.7.0

v2.6.6

v2.6.5

v2.6.4

v2.6.3

v2.6.2

v2.6.1

v2.6.0

v2.5.14

v2.5.13

v2.5.12

v2.5.11

v2.5.10

v2.5.9

v2.5.8

v2.5.7

v2.5.6

v2.5.5

v2.5.4

v2.5.3

v2.5.2

v2.4.8

v2.5.1

v2.5.0

v2.5.0-RC2

v2.5.0-RC1

v2.5.0-beta1

v2.5.0-alpha2

v2.5.0-alpha1

v2.4.7

v2.4.6

v2.4.5

v2.4.4

v2.4.3

v2.3.6

v2.4.2

2.3.5

v2.4.1

v2.4.0

2.4.0-RC2

2.4.0-RC1

2.4.0-BETA2

2.3.4

2.3.3

2.4.0-BETA1

2.3.2

2.3.1

2.3.0

2.3.0-RC4

2.3.0-RC3

2.3.0-RC2

2.2.3

2.3.0-RC1

2.3.0-BETA1

2.1.7

2.2.2

2.2.1

2.1.6

2.2.0

2.2.0-RC1

2.2.0-BETA2

2.2.0-BETA1

2.1.5

2.1.4

2.1.3

2.1.2

2.1.1

2.0.7

2.1.0

2.1.0RC3

2.1.0RC2

2.1.0RC1

2.0.6

2.1.0BETA1

2.0.5

2.0.4

2.0.3

2.0.2

2.0.1

2.0.0

2.0.0RC2

2.0.0RC1

2.0.0-BETA4

2.0.0-BETA3

2.0.0-BETA2

2.0.0-BETA1

Labels

Clear labels

BC Break

Bug

Can't Fix

Deprecation

Documentation

DQL

Duplicate

Failing Test

Hacktoberfest

Improvement

Improvement

Incomplete

Invalid

Missing Tests

New Feature

PR Created

pull-request

Mirrored from GitHub Pull Request

Question

Regression

Status: Waiting feedback

Waiting feedback

WIP

Won't Fix

No Label Bug Missing Tests

Milestone

No items

No Milestone

Projects

Clear projects

No project

Assignees

Clear assignees

admin

No Assignees

1 Participants

Notifications

Subscribe

Due Date

No due date set.

Dependencies

No dependencies set.

Reference: doctrine/archived-orm#3883