DDC-705: Using a named parameter in multiple places doesn't work #871

New Issue

admin · 2026-01-22T12:53:20+01:00

admin commented

2026-01-22 12:53:20 +01:00

Originally created by @doctrinebot on GitHub (Jul 20, 2010).

Jira issue originally created by user jakajancar:

The following won't work:

$qb->andWhere('(a.campaign IS NOT NULL AND (cmp.user IS NULL OR cmp.user = :currentUser) OR a.previewTarget IS NOT NULL AND pt.user = :currentUser)')
   ->setParameter('currentUser', $currentUser);

The following will, but seems needlessly complex:

$qb->andWhere('(a.campaign IS NOT NULL AND (cmp.user IS NULL OR cmp.user = :currentUserA) OR a.previewTarget IS NOT NULL AND pt.user = :currentUserB)')
   ->setParameter('currentUserA', $currentUser)
   ->setParameter('currentUserB', $currentUser);

I would expect a named parameter to behave like a constant. I should be able to define it once, and then use it multiple times.

Also, I would like to be able to set the same parameter multiple times, so if multiple pieces of code set :currentUser that isn't a problem, unless they're different (in which case I'd expect an error like ":currentUser bound to two different values").

Originally created by @doctrinebot on GitHub (Jul 20, 2010). Jira issue originally created by user jakajancar: The following won't work: ``` $qb->andWhere('(a.campaign IS NOT NULL AND (cmp.user IS NULL OR cmp.user = :currentUser) OR a.previewTarget IS NOT NULL AND pt.user = :currentUser)') ->setParameter('currentUser', $currentUser); ``` The following will, but seems needlessly complex: ``` $qb->andWhere('(a.campaign IS NOT NULL AND (cmp.user IS NULL OR cmp.user = :currentUserA) OR a.previewTarget IS NOT NULL AND pt.user = :currentUserB)') ->setParameter('currentUserA', $currentUser) ->setParameter('currentUserB', $currentUser); ``` I would expect a named parameter to behave like a constant. I should be able to define it once, and then use it multiple times. Also, I would like to be able to set the same parameter multiple times, so if multiple pieces of code set :currentUser that isn't a problem, unless they're different (in which case I'd expect an error like ":currentUser bound to two different values").

admin added the Bug label 2026-01-22 12:53:20 +01:00

admin referenced this issue

2026-01-22 16:01:53 +01:00

[PR #871] [MERGED] XCache cannot be flushed on the CLI -> for pretty much the same reason as APC #8830

admin referenced this issue

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

[PR #871] XCache cannot be flushed on the CLI -> for pretty much the same reason as APC #8833

admin referenced this issue

2026-01-22 16:03:05 +01:00

[PR #1040] [CLOSED] Entity manager interface #9076

Sign in to join this conversation.