Announcement

Announcement Module
Collapse
No announcement yet.

Problem with count() after upgrade to 5.6.17-66

Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • Problem with count() after upgrade to 5.6.17-66

    Queries that perform count() are not behaving correctly anymore after upgrading to 5.6.17-66 (no problems with 5.6.17-65).

    I'm using the Symfony2 framework and this is part of the query I'm executing:

    $queryBuilder = $this->doctrine->getRepository('LifestyleEngineSocialBundle:Rendezvous')->createQueryBuilder('r');
    $tRendezvous = $queryBuilder ->select('count(r)')
    ->leftJoin('r.Member', 'm')
    ->leftJoin('LifestyleEngineSocialBundle:Friendship', 'f', 'WITH', 'f.memberId = :memberId AND f.friendId = r.memberId AND f.status = :friendshipAccepted')
    ->leftJoin('LifestyleEngineSocialBundle:Friendship', 'ff', 'WITH', 'ff.friendId = r.memberId AND ff.status = :friendshipAccepted AND ff.memberId IN (SELECT g.friendId FROM LifestyleEngineSocialBundle:Friendship g WHERE g.memberId = :memberId AND g.status = :friendshipAccepted)')

    The count() now seems to return the number of records being selected on the 3rd join (SELECT g.friendId...) instead of the count() of the records being selected from the table Rendezvous.

    Is there any way to roll back this update easily?
Working...
X