Doctrine 2 - ORM
  1. Doctrine 2 - ORM
  2. DDC-1803

Paginator usage with a DQL query that is using 2 time the same named binded value failed

    Details

    • Type: Bug Bug
    • Status: Awaiting Feedback
    • Priority: Major Major
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: ORM
    • Security Level: All
    • Labels:
      None
    • Environment:
      linux, oracle

      Description

      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.object_status_id <> :deleted')
      ->setParameter('deleted', CoRefObjectStatus::DELETE)
      ->andWhere('fl.publishing_status_id = :published')
      ->setParameter('published', CoRefPublishingStatus::PUBLISHED)
      ->andWhere('fp.object_status_id <> :deleted')
      ->setParameter('deleted', CoRefObjectStatus::DELETE)
      ->andWhere('fp.publishing_status_id = :published')
      ->setParameter('published', CoRefPublishingStatus::PUBLISHED)
      ->add('orderBy', 'fl.listing_date DESC, fl.published_date 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.

        Activity

        Hide
        Marco Pivetta added a comment -

        Ok, marking as awaiting feedback

        Show
        Marco Pivetta added a comment - Ok, marking as awaiting feedback
        Hide
        Marc Drolet added a comment -

        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.

        Show
        Marc Drolet added a comment - 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.
        Hide
        Marco Pivetta added a comment -

        This seems to be quite old. Marc Drolet is it still valid with the latest ORM?

        Show
        Marco Pivetta added a comment - This seems to be quite old. Marc Drolet is it still valid with the latest ORM?

          People

          • Assignee:
            Benjamin Eberlei
            Reporter:
            Marc Drolet
          • Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

            • Created:
              Updated: