DDC-1572: LIKE expressions doesn't allow the matching pattern to be a string function #1971

Closed
opened 2026-01-22 13:34:51 +01:00 by admin · 5 comments
Owner

Originally created by @doctrinebot on GitHub (Dec 29, 2011).

Originally assigned to: @guilhermeblanco on GitHub.

Jira issue originally created by user adrive:

Like expressions doesn't allow the matching apttern to be a function returning string like LOWER(column) LIKE LOWER(:param)

Query parsers is returning exception like this:
{quote}
[Syntax Error] line 0, col 82: Error: Expected Doctrine\ORM\Query\Lexer::T_STRING, got 'LOWER'
{quote}

It is not possible to construct queries like this:
{quote}
SELECT u.name FROM Doctrine\Tests\Models\CMS\CmsUser u WHERE UPPER(u.name) LIKE UPPER(:str)
{quote}

I'll create a pull request on github for this issue.

Originally created by @doctrinebot on GitHub (Dec 29, 2011). Originally assigned to: @guilhermeblanco on GitHub. Jira issue originally created by user adrive: Like expressions doesn't allow the matching apttern to be a function returning string like LOWER(column) LIKE LOWER(:param) Query parsers is returning exception like this: {quote} [Syntax Error] line 0, col 82: Error: Expected Doctrine\ORM\Query\Lexer::T_STRING, got 'LOWER' {quote} It is not possible to construct queries like this: {quote} SELECT u.name FROM Doctrine\Tests\Models\CMS\CmsUser u WHERE UPPER(u.name) LIKE UPPER(:str) {quote} I'll create a pull request on github for this issue.
admin added the Improvement label 2026-01-22 13:34:51 +01:00
admin closed this issue 2026-01-22 13:34:53 +01:00
Author
Owner

@doctrinebot commented on GitHub (Dec 29, 2011):

Comment created by @beberlei:

Assigned to Guilherme

@doctrinebot commented on GitHub (Dec 29, 2011): Comment created by @beberlei: Assigned to Guilherme
Author
Owner

@doctrinebot commented on GitHub (Dec 29, 2011):

Comment created by @beberlei:

This issue is referenced in Github Pull-Request GH-245
https://github.com/doctrine/doctrine2/pull/245

@doctrinebot commented on GitHub (Dec 29, 2011): Comment created by @beberlei: This issue is referenced in Github Pull-Request GH-245 https://github.com/doctrine/doctrine2/pull/245
Author
Owner

@doctrinebot commented on GitHub (Dec 31, 2011):

Comment created by @beberlei:

This was merged

@doctrinebot commented on GitHub (Dec 31, 2011): Comment created by @beberlei: This was merged
Author
Owner

@doctrinebot commented on GitHub (Dec 31, 2011):

Issue was closed with resolution "Fixed"

@doctrinebot commented on GitHub (Dec 31, 2011): Issue was closed with resolution "Fixed"
Author
Owner

@doctrinebot commented on GitHub (Feb 11, 2014):

Comment created by @doctrinebot:

A related Github Pull-Request [GH-245] was closed:
https://github.com/doctrine/dbal/pull/245

@doctrinebot commented on GitHub (Feb 11, 2014): Comment created by @doctrinebot: A related Github Pull-Request [GH-245] was closed: https://github.com/doctrine/dbal/pull/245
Sign in to join this conversation.
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: doctrine/archived-orm#1971