Querybuilder: Expected =, <, <=, <>, >, >=, !=, got 'IN' #7554

New Issue

admin · 2026-01-22T15:53:23+01:00

admin commented

2026-01-22 15:53:23 +01:00

Originally created by @PaulCombal on GitHub (Sep 24, 2025).

Bug Report

Q	A
Version	3.5.2

Summary

Using the querybuilder, using CASE WHEN + IN produces an error.
Using CASE WHEN with any other comparison works just fine

Current behavior

->andWhere("
CASE
  WHEN o.prop1 IS NOT NULL THEN o.propX
  WHEN o.prop2 IS NOT NULL THEN o.propY
  ELSE o.propZ
END IN (:values)
")

Produces:

[Syntax Error] line 0, col 911: Error: Expected =, <, <=, <>, >, >=, !=, got 'IN'

Indeed, using any of the listed operators work just fine.

I tried finding a workaround but didn't find any, all other alternative syntaxes produce the same issue.

Expected behavior

The above DQL works, as suggested by the SQL syntax.

How to reproduce

The first querybuilder works, where the second querybuilder doesn't:

        $this
            ->userRepository
            ->createQueryBuilder('u')
            ->andWhere('CASE WHEN u.email IS NULL THEN u.email ELSE u.email END = :value')
            ->setParameter('value', 'test')
            ->getQuery()
            ->getResult();

        $this
            ->userRepository
            ->createQueryBuilder('u')
            ->andWhere('CASE WHEN u.email IS NULL THEN u.email ELSE u.email END IN (:value)')
            ->setParameter('value', 'test')
            ->getQuery()
            ->getResult();

Thank you for the amazing work <3

Originally created by @PaulCombal on GitHub (Sep 24, 2025). ### Bug Report  | Q | A |-------------------------------------------- | ------ | Version | 3.5.2 #### Summary  Using the querybuilder, using CASE WHEN + IN produces an error. Using CASE WHEN with any other comparison works just fine #### Current behavior  ``` ->andWhere(" CASE WHEN o.prop1 IS NOT NULL THEN o.propX WHEN o.prop2 IS NOT NULL THEN o.propY ELSE o.propZ END IN (:values) ") ``` Produces: `[Syntax Error] line 0, col 911: Error: Expected =, <, <=, <>, >, >=, !=, got 'IN'` Indeed, using any of the listed operators work just fine. I tried finding a workaround but didn't find any, all other alternative syntaxes produce the same issue. #### Expected behavior  The above DQL works, as suggested by the SQL syntax. #### How to reproduce  The first querybuilder works, where the second querybuilder doesn't: ``` $this ->userRepository ->createQueryBuilder('u') ->andWhere('CASE WHEN u.email IS NULL THEN u.email ELSE u.email END = :value') ->setParameter('value', 'test') ->getQuery() ->getResult(); $this ->userRepository ->createQueryBuilder('u') ->andWhere('CASE WHEN u.email IS NULL THEN u.email ELSE u.email END IN (:value)') ->setParameter('value', 'test') ->getQuery() ->getResult(); ``` Thank you for the amazing work <3

admin commented

2026-01-22 15:53:23 +01:00

@Dinesh0204 commented on GitHub (Oct 4, 2025):

Hi @PaulCombal ! I’ve opened a PR that addresses this issue: (https://github.com/doctrine/orm/issues/12178).
It includes a test and fixes the parser problem.

@Dinesh0204 commented on GitHub (Oct 4, 2025): Hi @PaulCombal ! I’ve opened a PR that addresses this issue: (https://github.com/doctrine/orm/issues/12178). It includes a test and fixes the parser problem.

admin referenced this issue

2026-01-22 16:07:54 +01:00

[PR #7554] Allow all datetime types to be used as version #10540

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#7554