Doctrine 2 - ORM

Error with IN and UPPER in the same line

Details

  • Type: Bug Bug
  • Status: Resolved Resolved
  • Priority: Major Major
  • Resolution: Fixed
  • Affects Version/s: 2.1.6
  • Fix Version/s: 2.3
  • Component/s: DQL
  • Security Level: All
  • Labels:
    None

Description

I have a problem making a DQL query

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

:values is an array of possible names of brands.

The error shown is

[Syntax Error] line 0, col 109: Error: Expected Doctrine\ORM\Query\Lexer::T_IN, got '('

Activity

Hide
Permalink
Guilherme Blanco added a comment -

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

Show
Guilherme Blanco added a comment - This is already fixed in master for a long time and should be available in 2.3, since it requires major changes in DQL.

People

  • Assignee:
    Guilherme Blanco
    Reporter:
    Aitor Suso
Vote (0)
Watch (0)

Dates

  • Created:
    Updated:
    Resolved: