DDC-334: QueryBuilder throws QueryException when Expr\Comparison with 'LIKE' operator was added in where clause #411

New Issue

admin · 2026-01-22T12:37:27+01:00

admin commented

2026-01-22 12:37:27 +01:00

Originally created by @doctrinebot on GitHub (Feb 14, 2010).

Jira issue originally created by user ignat:

Example of code that throws exception:

$qb->select('e')->from('SomeEntity','e')
->add('where',$qb->expr()->like('LOWER(e.title)',':title'));
$result = $qb->getQuery()->execute(array('title' => $title),Doctrine\ORM\Query::HYDRATE_OBJECT); // exception throws here

Exception details:
Message: Doctrine\ORM\Query\QueryException: [Syntax Error] line 0, col 100: Error: Expected =, <, <=, <>, >, >=, !=, got 'LIKE'
Trace:
lib/Doctrine/ORM/Query/QueryException.php:41
lib/Doctrine/ORM/Query/Parser.php:346
lib/Doctrine/ORM/Query/Parser.php:2572
...

Originally created by @doctrinebot on GitHub (Feb 14, 2010). Jira issue originally created by user ignat: Example of code that throws exception: ``` $qb->select('e')->from('SomeEntity','e') ->add('where',$qb->expr()->like('LOWER(e.title)',':title')); $result = $qb->getQuery()->execute(array('title' => $title),Doctrine\ORM\Query::HYDRATE_OBJECT); // exception throws here ``` Exception details: Message: Doctrine\ORM\Query\QueryException: [Syntax Error] line 0, col 100: Error: Expected =, <, <=, <>, >, >=, !=, got 'LIKE' Trace: lib/Doctrine/ORM/Query/QueryException.php:41 lib/Doctrine/ORM/Query/Parser.php:346 lib/Doctrine/ORM/Query/Parser.php:2572 ...

admin added the Bug label 2026-01-22 12:37:27 +01:00

admin referenced this issue

2026-01-22 15:58:38 +01:00

[PR #411] [MERGED] Added the new DBAL 2.3 types in the EntityGenerator typehint map #8149

Sign in to join this conversation.

Branches Tags

1 Participants

Notifications

Due Date

No due date set.

Dependencies

No dependencies set.

Reference: doctrine/archived-orm#411