Skip to content

Loading…

DDC-1803: Paginator usage with a DQL query that is using 2 time the same named binded value failed #2459

Open
doctrinebot opened this Issue · 3 comments

2 participants

@doctrinebot

Jira issue originally created by user mdrolet:

I use a dql query where I bind a named parameter 2 time in the same query for different joined fields. The query work but the count query failed saying that there are missing bind variable.

ex:
$qb = $this->getQueryBuilder()
->select('
partial fl.{id, title, listing_date, abstract},
partial fla.{id},
partial ca.{id},
partial ds.{id}
')
->from('Fo_Listing', 'fl')
->join('fl.listing_properties', 'flp')
->join('flp.property', 'fp')
->leftjoin('fl.listing_assets', 'fla')
->leftjoin('fla.asset', 'ca')
->leftjoin('ca.ds', 'ds')
->where('fp.id = :propertyId')
->setParameter('propertyId', $id)
->andWhere('fl.objectstatusid <> :deleted')
->setParameter('deleted', CoRefObjectStatus::DELETE)
->andWhere('fl.publishingstatusid = :published')
->setParameter('published', CoRefPublishingStatus::PUBLISHED)
->andWhere('fp.objectstatusid <> :deleted')
->setParameter('deleted', CoRefObjectStatus::DELETE)
->andWhere('fp.publishingstatusid = :published')
->setParameter('published', CoRefPublishingStatus::PUBLISHED)
->add('orderBy', 'fl.listingdate DESC, fl.publisheddate DESC')
->setMaxResults($onTheMarketLimit);

    $onTheMarket = new Paginator($qb, $fetchJoin = true);

To make it work, I've renamed the second usage of the named variable with a 2 at the end. deleted2 and published2.

@doctrinebot

Comment created by @ocramius:

This seems to be quite old. [~mdrolet] is it still valid with the latest ORM?

@doctrinebot

Comment created by mdrolet:

I'll try to test this problem on an updated version and I'll let you know.
The bug entry is also quite old and I've a local modified version of the paginator here to make it work with oracle, so it can take some time before I can test this out on the current doctrine version.

@doctrinebot

Comment created by @ocramius:

Ok, marking as awaiting feedback

@beberlei beberlei was assigned by doctrinebot
@doctrinebot doctrinebot added the Bug label
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Something went wrong with that request. Please try again.