DDC-1823: Error with IN and UPPER in the same line #2300

Closed
opened 2026-01-22 13:47:43 +01:00 by admin · 2 comments
Owner

Originally created by @doctrinebot on GitHub (May 17, 2012).

Originally assigned to: @guilhermeblanco on GitHub.

Jira issue originally created by user patxi1980:

I have a problem making a DQL query

{quote}
SELECT c.id, c.name
FROM BrandBundle:Brand c
WHERE UPPER(c.name) IN (:values)
{quote}

:values is an array of possible names of brands.

The error shown is
{quote}
[Syntax Error] line 0, col 109: Error: Expected Doctrine\ORM\Query\Lexer::T_IN, got '('
{quote}

Originally created by @doctrinebot on GitHub (May 17, 2012). Originally assigned to: @guilhermeblanco on GitHub. Jira issue originally created by user patxi1980: I have a problem making a DQL query {quote} SELECT c.id, c.name FROM BrandBundle:Brand c WHERE UPPER(c.name) IN (:values) {quote} :values is an array of possible names of brands. The error shown is {quote} [Syntax Error] line 0, col 109: Error: Expected Doctrine\ORM\Query\Lexer::T_IN, got '(' {quote}
admin added the Bug label 2026-01-22 13:47:43 +01:00
admin closed this issue 2026-01-22 13:47:43 +01:00
Author
Owner

@doctrinebot commented on GitHub (May 27, 2012):

Comment created by @guilhermeblanco:

This is already fixed in master for a long time and should be available in 2.3, since it requires major changes in DQL.

@doctrinebot commented on GitHub (May 27, 2012): Comment created by @guilhermeblanco: This is already fixed in master for a long time and should be available in 2.3, since it requires major changes in DQL.
Author
Owner

@doctrinebot commented on GitHub (May 27, 2012):

Issue was closed with resolution "Fixed"

@doctrinebot commented on GitHub (May 27, 2012): Issue was closed with resolution "Fixed"
Sign in to join this conversation.
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: doctrine/archived-orm#2300