DDC-4157: ManyToMany matching criteria set wrong expressions #4917

New Issue

Open

opened 2026-01-22 14:51:58 +01:00 by admin · 1 comment

admin commented 2026-01-22 14:51:58 +01:00

Owner

Copy Link

Originally created by @doctrinebot on GitHub (Dec 3, 2015).

Originally assigned to: @beberlei on GitHub.

Jira issue originally created by user eliotik:

I have two entities: User and Event, they are in ManyToMany relationship.
I try to match events by criteria from $user->getEvents() but get nothing. After checking profiler i saw that criteria did not work correctly while build sql, i used expression lte and gte but in sql doctrine continue to use =.

Here are my classes.
User:

    <?php

    namespace App\UserBundle\Entity;

    use App\CoreBundle\Entity\Event;
    use Doctrine\Common\Collections\ArrayCollection;
    use Doctrine\ORM\Mapping as ORM;
    use Symfony\Component\Validator\Constraints as Assert;
    use Symfony\Bridge\Doctrine\Validator\Constraints\UniqueEntity;
    use JMS\Serializer\Annotation as JMS;

    /****
     * @JMS\ExclusionPolicy("all")
     *
     * @ORM\Entity(repositoryClass="App\UserBundle\Repository\UserRepository")
     * @ORM\Table(name="users", uniqueConstraints={@ORM\UniqueConstraint(name="User",columns={"login", "email"})})
     * @UniqueEntity(fields={"login","email"})
     * @ORM\HasLifecycleCallbacks()
     */
    class User
    {
        /****
         * @var int
         *
         * @ORM\Column(name="id", type="integer")
         * @ORM\Id
         * @ORM\GeneratedValue(strategy="AUTO")
         */
        protected $id;

        /****
         * @ORM\Column(name="login", type="string", length=255, unique=true, nullable=false)
         * @Assert\NotBlank()
         */
        protected $login;

        /****
         * @JMS\Expose
         *
         * @ORM\Column(name="name", type="string", length=255, unique=true, nullable=false)
         * @Assert\NotBlank()
         */
        protected $name;

        /****
         * @JMS\Expose
         *
         * @ORM\Column(name="email", type="string", length=255, unique=true, nullable=false)
         * @Assert\NotBlank()
         */
        protected $email;

        /****
         * @ORM\Column(name="roles", type="array", nullable=false)
         * @Assert\NotBlank()
         */
        protected $roles;

        /****
         * @ORM\Column(name="blocked", type="boolean")
         * @Assert\NotBlank()
         */
        protected $blocked;

        /****
         * @ORM\Column(type="datetime")
         */
        protected $created;

        /****
         * @ORM\Column(type="datetime")
         */
        protected $updated;

        /****
         * @ORM\ManyToMany(targetEntity="App\CoreBundle\Entity\Event", inversedBy="users", cascade={"persist", "remove"})
         * @ORM\JoinTable(name="users_events",
         *      joinColumns={@ORM\JoinColumn(name="user_id", referencedColumnName="id", onDelete="cascade")},
         *      inverseJoinColumns={@ORM\JoinColumn(name="event_id", referencedColumnName="id", onDelete="cascade")}
         * )
         */
        protected $events;

        public function **construct()
        {
            $this->roles = array();
            $this->events = new ArrayCollection();
            $this->setCreated(new \DateTime());
            $this->setUpdated(new \DateTime());
        }

        public function **toString()
        {
            return (string) $this->id;
        }

        /****
         * @ORM\PreUpdate
         */
        public function setUpdatedValue()
        {
            $this->setUpdated(new \DateTime());
        }

        /****
         * Set created.
         *
         * @param \DateTime $created
         *
         * @return User
         */
        public function setCreated($created)
        {
            $this->created = $created;

            return $this;
        }

        /****
         * Get created.
         *
         * @return \DateTime
         */
        public function getCreated()
        {
            return $this->created;
        }

        /****
         * Set updated.
         *
         * @param \DateTime $updated
         *
         * @return User
         */
        public function setUpdated($updated)
        {
            $this->updated = $updated;

            return $this;
        }

        /****
         * Get updated.
         *
         * @return \DateTime
         */
        public function getUpdated()
        {
            return $this->updated;
        }

        public function getId()
        {
            return $this->id;
        }

        /****
         * Get Login.
         *
         * @return string
         */
        public function getLogin()
        {
            return $this->login;
        }

        /****
         * Set Login.
         *
         * @param $login
         *
         * @return User
         */
        public function setLogin($login)
        {
            $this->login = $login;

            return $this;
        }

        /****
         * Get Name.
         *
         * @return mixed
         */
        public function getName()
        {
            return $this->name;
        }

        /****
         * Set Name.
         *
         * @param string $name
         *
         * @return User
         */
        public function setName($name)
        {
            $this->name = $name;

            return $this;
        }

        /****
         * Get Email.
         *
         * @return mixed
         */
        public function getEmail()
        {
            return $this->email;
        }

        /****
         * Set Email.
         *
         * @param mixed $email
         *
         * @return User
         */
        public function setEmail($email)
        {
            $this->email = $email;

            return $this;
        }

        /****
         * Get roles.
         *
         * @return mixed
         */
        public function getRoles()
        {
            return $this->roles;
        }

        /****
         * Set Roles.
         *
         * @param mixed $roles
         *
         * @return User
         */
        public function setRoles($roles)
        {
            $this->roles = array();

            foreach ($roles as $role) {
                $this->addRole($role);
            }

            return $this;
        }

        /****
         * Add role to collection.
         *
         * @param $role
         *
         * @return User
         */
        public function addRole($role)
        {
            $role = strtoupper($role);

            if (!in_array($role, $this->roles, true)) {
                $this->roles[] = $role;
            }

            return $this;
        }

        /****
         * Get Blocked.
         *
         * @return boolean
         */
        public function getBlocked()
        {
            return $this->blocked;
        }

        /****
         * Set Blocked.
         *
         * @param boolean $blocked
         *
         * @return User
         */
        public function setBlocked($blocked)
        {
            $this->blocked = $blocked;

            return $this;
        }

        /****
         * Add event.
         *
         * @param Event $event
         *
         * @return User
         */
        public function addEvent(Event $event)
        {
            if (!$this->events->contains($event)) {
                $this->events[] = $event;
            }

            return $this;
        }

        /****
         * Remove event.
         *
         * @param Event $event
         *
         * @return User
         */
        public function removeEvent(Event $event)
        {
            if ($this->events->contains($event)) {
                $this->events->removeElement($event);
            }

            return $this;
        }

        /****
         * Get events.
         *
         * @return ArrayCollection
         */
        public function getEvents()
        {
            return $this->events;
        }
    }

Event:

    <?php

    namespace App\CoreBundle\Entity;

    use App\UserBundle\Entity\User;
    use Doctrine\Common\Collections\ArrayCollection;
    use Doctrine\ORM\Mapping as ORM;

    /****
     * Event
     *
     * @ORM\Table()
     * @ORM\Entity(repositoryClass="App\CoreBundle\Repository\EventRepository")
     */
    class Event
    {
        /****
         * @var integer
         *
         * @ORM\Column(name="id", type="integer")
         * @ORM\Id
         * @ORM\GeneratedValue(strategy="AUTO")
         */
        private $id;

        /****
         * @var string
         *
         * @ORM\Column(name="event_name", type="string", length=50)
         */
        private $eventName;

        /****
         * @var string
         *
         * @ORM\Column(name="event_description", type="string", length=160)
         */
        private $eventDescription;

        /****
         * @var string
         *
         * @ORM\Column(name="event_type", type="string", length=100)
         */
        private $eventType;

        /****
         * @var boolean
         *
         * @ORM\Column(name="visible", type="boolean")
         */
        private $visible;

        /****
         * @var \DateTime
         *
         * @ORM\Column(name="start_date", type="datetime")
         */
        private $startDate;

        /****
         * @var \DateTime
         *
         * @ORM\Column(name="end_date", type="datetime")
         */
        private $endDate;

        /****
         * @ORM\ManyToMany(targetEntity="App\UserBundle\Entity\User", mappedBy="events")
         */
        protected $users;

        public function **construct()
        {
            $this->users = new ArrayCollection();
        }

        /****
         * Get id
         *
         * @return integer 
         */
        public function getId()
        {
            return $this->id;
        }

        /****
         * Set eventName
         *
         * @param string $eventName
         * @return Event
         */
        public function setEventName($eventName)
        {
            $this->eventName = $eventName;

            return $this;
        }

        /****
         * Get eventName
         *
         * @return string 
         */
        public function getEventName()
        {
            return $this->eventName;
        }

        /****
         * Set eventDescription
         *
         * @param string $eventDescription
         * @return Event
         */
        public function setEventDescription($eventDescription)
        {
            $this->eventDescription = $eventDescription;

            return $this;
        }

        /****
         * Get eventDescription
         *
         * @return string 
         */
        public function getEventDescription()
        {
            return $this->eventDescription;
        }

        /****
         * Set eventType
         *
         * @param string $eventType
         * @return Event
         */
        public function setEventType($eventType)
        {
            $this->eventType = $eventType;

            return $this;
        }

        /****
         * Get eventType
         *
         * @return string
         */
        public function getEventType()
        {
            return $this->eventType;
        }

        /****
         * Set visible
         *
         * @param boolean $visible
         * @return Event
         */
        public function setVisible($visible)
        {
            $this->visible = $visible;

            return $this;
        }

        /****
         * Get visible
         *
         * @return boolean 
         */
        public function getVisible()
        {
            return $this->visible;
        }

        /****
         * Set startDate
         *
         * @param \DateTime $startDate
         * @return Event
         */
        public function setStartDate($startDate)
        {
            $this->startDate = $startDate;

            return $this;
        }

        /****
         * Get startDate
         *
         * @return \DateTime 
         */
        public function getStartDate()
        {
            return $this->startDate;
        }

        /****
         * Set endDate
         *
         * @param \DateTime $endDate
         * @return Event
         */
        public function setEndDate($endDate)
        {
            $this->endDate = $endDate;

            return $this;
        }

        /****
         * Get endData
         *
         * @return \DateTime 
         */
        public function getEndDate()
        {
            return $this->endDate;
        }

        /****
         * Set users.
         *
         * @param ArrayCollection $users
         *
         * @return Event
         */
        public function setUsers(ArrayCollection $users)
        {
            $this->users = $users;

            return $this;
        }

        /****
         * Add user.
         *
         * @param User $user
         *
         * @return Event
         */
        public function addUser(User $user)
        {
            if (!$this->users->contains($user)) {
                $this->users[] = $user;
            }

            return $this;
        }

        /****
         * Get user.
         *
         * @return User
         */
        public function getUsers()
        {
            return $this->users;
        }

        /****
         * Remove user
         *
         * @param User $user
         */
        public function removeUser(User $user)
        {
            $this->users->removeElement($user);
        }
    }

And here is how i try to find events related to user:

        private function getActiveEventsCriteria($camelStyle = true, $dateAsObject = true)
        {
            $currentDateTime = new \DateTime();

            $criteria = Criteria::create()
                ->where(
                    Criteria::expr()->andX(
                        Criteria::expr()->lte($camelStyle ? 'startDate' : 'start_date', $dateAsObject ? $currentDateTime : $currentDateTime->format("Y-m-d H:i:s")),
                        Criteria::expr()->gte($camelStyle ? 'endDate' : 'end_date', $dateAsObject ? $currentDateTime : $currentDateTime->format("Y-m-d H:i:s"))
                    )
                )
                ->andWhere(Criteria::expr()->eq('visible', 1));

            return $criteria;
        }

        public function getParticipatingEventsBy(User $user)
        {
            $userEvents = $user->getEvents();

            if (is_null($userEvents)) return [];

            return $userEvents->matching($this->getActiveEventsCriteria(false, false));
        }

        $this->getParticipatingEventsBy($user);

In profiler/debug i see next sql:

    SELECT 
      te.id AS id, 
      te.event*name AS event*name, 
      te.event*description AS event*description, 
      te.event*type AS event*type, 
      te.visible AS visible, 
      te.start*date AS start*date, 
      te.end*date AS end*date 
    FROM 
      event te 
      JOIN users*events t ON t.event*id = te.id 
    WHERE 
      t.user_id = ? 
      AND te.start_date = ? 
      AND te.end_date = ? 
      AND te.visible = ?

And with applied parameters:

    SELECT 
      te.id AS id, 
      te.event*name AS event*name, 
      te.event*description AS event*description, 
      te.event*type AS event*type, 
      te.visible AS visible, 
      te.start*date AS start*date, 
      te.end*date AS end*date 
    FROM 
      event te 
    JOIN users*events t ON t.event*id = te.id 
    WHERE 
      t.user_id = 14 AND 
      te.start_date = '2015-12-03 16:26:44' AND 
      te.end_date = '2015-12-03 16:26:44' AND 
      te.visible = 1;

I changed WHERE to next:

    WHERE 
      t.user_id = 14 AND 
      te.start_date <= '2015-12-03 16:26:44' AND 
      te.end_date >= '2015-12-03 16:26:44' AND 
      te.visible = 1;

And with that sql i got correct result.

When i use same criteria right with repository without relation to user - everything is ok:

    public function getActiveEvents() {
        return $this->matching($this->getActiveEventsCriteria());
    }

    public function matching(Criteria $criteria)
    {
        return $this->repository->matching($criteria);
    }

    $this->getActiveEvents();

This is formatted sql:

    SELECT 
      t0.id AS id_1, 
      t0.event*name AS event_name*2, 
      t0.event*description AS event_description*3, 
      t0.event*type AS event_type*4, 
      t0.visible AS visible_5, 
      t0.start*date AS start_date*6, 
      t0.end*date AS end_date*7 
    FROM 
      event t0 
    WHERE 
      (
        (
          t0.start_date <= ? 
          AND t0.end_date >= ?
        ) 
        AND t0.visible = ?
      )

And with applied parameters:

    SELECT 
      t0.id AS id_1, 
      t0.event*name AS event_name*2, 
      t0.event*description AS event_description*3, 
      t0.event*type AS event_type*4, 
      t0.visible AS visible_5, 
      t0.start*date AS start_date*6, 
      t0.end*date AS end_date*7 
    FROM 
      event t0 
    WHERE 
      ((t0.start*date <= '2015-12-03 17:01:47' AND t0.end*date >= '2015-12-03 17:01:47') AND 
      t0.visible = 1);

As you can see, for case when i dont try to search through relation - everything is ok, i get result. But when i try related events to user with use of Criteria - it fails and return empty result cause of incorrect sql.

I use php 5.6.*, symfony 2.8, doctrine 2.5.2, latest MySQL.

Any help will be very appreciated.
Thank you.

Originally created by @doctrinebot on GitHub (Dec 3, 2015). Originally assigned to: @beberlei on GitHub. Jira issue originally created by user eliotik: I have two entities: User and Event, they are in ManyToMany relationship. I try to match events by criteria from $user->getEvents() but get nothing. After checking profiler i saw that criteria did not work correctly while build sql, i used expression lte and gte but in sql doctrine continue to use =. Here are my classes. **User:** ``` <?php namespace App\UserBundle\Entity; use App\CoreBundle\Entity\Event; use Doctrine\Common\Collections\ArrayCollection; use Doctrine\ORM\Mapping as ORM; use Symfony\Component\Validator\Constraints as Assert; use Symfony\Bridge\Doctrine\Validator\Constraints\UniqueEntity; use JMS\Serializer\Annotation as JMS; /**** * @JMS\ExclusionPolicy("all") * * @ORM\Entity(repositoryClass="App\UserBundle\Repository\UserRepository") * @ORM\Table(name="users", uniqueConstraints={@ORM\UniqueConstraint(name="User",columns={"login", "email"})}) * @UniqueEntity(fields={"login","email"}) * @ORM\HasLifecycleCallbacks() */ class User { /**** * @var int * * @ORM\Column(name="id", type="integer") * @ORM\Id * @ORM\GeneratedValue(strategy="AUTO") */ protected $id; /**** * @ORM\Column(name="login", type="string", length=255, unique=true, nullable=false) * @Assert\NotBlank() */ protected $login; /**** * @JMS\Expose * * @ORM\Column(name="name", type="string", length=255, unique=true, nullable=false) * @Assert\NotBlank() */ protected $name; /**** * @JMS\Expose * * @ORM\Column(name="email", type="string", length=255, unique=true, nullable=false) * @Assert\NotBlank() */ protected $email; /**** * @ORM\Column(name="roles", type="array", nullable=false) * @Assert\NotBlank() */ protected $roles; /**** * @ORM\Column(name="blocked", type="boolean") * @Assert\NotBlank() */ protected $blocked; /**** * @ORM\Column(type="datetime") */ protected $created; /**** * @ORM\Column(type="datetime") */ protected $updated; /**** * @ORM\ManyToMany(targetEntity="App\CoreBundle\Entity\Event", inversedBy="users", cascade={"persist", "remove"}) * @ORM\JoinTable(name="users_events", * joinColumns={@ORM\JoinColumn(name="user_id", referencedColumnName="id", onDelete="cascade")}, * inverseJoinColumns={@ORM\JoinColumn(name="event_id", referencedColumnName="id", onDelete="cascade")} * ) */ protected $events; public function **construct() { $this->roles = array(); $this->events = new ArrayCollection(); $this->setCreated(new \DateTime()); $this->setUpdated(new \DateTime()); } public function **toString() { return (string) $this->id; } /**** * @ORM\PreUpdate */ public function setUpdatedValue() { $this->setUpdated(new \DateTime()); } /**** * Set created. * * @param \DateTime $created * * @return User */ public function setCreated($created) { $this->created = $created; return $this; } /**** * Get created. * * @return \DateTime */ public function getCreated() { return $this->created; } /**** * Set updated. * * @param \DateTime $updated * * @return User */ public function setUpdated($updated) { $this->updated = $updated; return $this; } /**** * Get updated. * * @return \DateTime */ public function getUpdated() { return $this->updated; } public function getId() { return $this->id; } /**** * Get Login. * * @return string */ public function getLogin() { return $this->login; } /**** * Set Login. * * @param $login * * @return User */ public function setLogin($login) { $this->login = $login; return $this; } /**** * Get Name. * * @return mixed */ public function getName() { return $this->name; } /**** * Set Name. * * @param string $name * * @return User */ public function setName($name) { $this->name = $name; return $this; } /**** * Get Email. * * @return mixed */ public function getEmail() { return $this->email; } /**** * Set Email. * * @param mixed $email * * @return User */ public function setEmail($email) { $this->email = $email; return $this; } /**** * Get roles. * * @return mixed */ public function getRoles() { return $this->roles; } /**** * Set Roles. * * @param mixed $roles * * @return User */ public function setRoles($roles) { $this->roles = array(); foreach ($roles as $role) { $this->addRole($role); } return $this; } /**** * Add role to collection. * * @param $role * * @return User */ public function addRole($role) { $role = strtoupper($role); if (!in_array($role, $this->roles, true)) { $this->roles[] = $role; } return $this; } /**** * Get Blocked. * * @return boolean */ public function getBlocked() { return $this->blocked; } /**** * Set Blocked. * * @param boolean $blocked * * @return User */ public function setBlocked($blocked) { $this->blocked = $blocked; return $this; } /**** * Add event. * * @param Event $event * * @return User */ public function addEvent(Event $event) { if (!$this->events->contains($event)) { $this->events[] = $event; } return $this; } /**** * Remove event. * * @param Event $event * * @return User */ public function removeEvent(Event $event) { if ($this->events->contains($event)) { $this->events->removeElement($event); } return $this; } /**** * Get events. * * @return ArrayCollection */ public function getEvents() { return $this->events; } } ``` **Event:** ``` <?php namespace App\CoreBundle\Entity; use App\UserBundle\Entity\User; use Doctrine\Common\Collections\ArrayCollection; use Doctrine\ORM\Mapping as ORM; /**** * Event * * @ORM\Table() * @ORM\Entity(repositoryClass="App\CoreBundle\Repository\EventRepository") */ class Event { /**** * @var integer * * @ORM\Column(name="id", type="integer") * @ORM\Id * @ORM\GeneratedValue(strategy="AUTO") */ private $id; /**** * @var string * * @ORM\Column(name="event_name", type="string", length=50) */ private $eventName; /**** * @var string * * @ORM\Column(name="event_description", type="string", length=160) */ private $eventDescription; /**** * @var string * * @ORM\Column(name="event_type", type="string", length=100) */ private $eventType; /**** * @var boolean * * @ORM\Column(name="visible", type="boolean") */ private $visible; /**** * @var \DateTime * * @ORM\Column(name="start_date", type="datetime") */ private $startDate; /**** * @var \DateTime * * @ORM\Column(name="end_date", type="datetime") */ private $endDate; /**** * @ORM\ManyToMany(targetEntity="App\UserBundle\Entity\User", mappedBy="events") */ protected $users; public function **construct() { $this->users = new ArrayCollection(); } /**** * Get id * * @return integer */ public function getId() { return $this->id; } /**** * Set eventName * * @param string $eventName * @return Event */ public function setEventName($eventName) { $this->eventName = $eventName; return $this; } /**** * Get eventName * * @return string */ public function getEventName() { return $this->eventName; } /**** * Set eventDescription * * @param string $eventDescription * @return Event */ public function setEventDescription($eventDescription) { $this->eventDescription = $eventDescription; return $this; } /**** * Get eventDescription * * @return string */ public function getEventDescription() { return $this->eventDescription; } /**** * Set eventType * * @param string $eventType * @return Event */ public function setEventType($eventType) { $this->eventType = $eventType; return $this; } /**** * Get eventType * * @return string */ public function getEventType() { return $this->eventType; } /**** * Set visible * * @param boolean $visible * @return Event */ public function setVisible($visible) { $this->visible = $visible; return $this; } /**** * Get visible * * @return boolean */ public function getVisible() { return $this->visible; } /**** * Set startDate * * @param \DateTime $startDate * @return Event */ public function setStartDate($startDate) { $this->startDate = $startDate; return $this; } /**** * Get startDate * * @return \DateTime */ public function getStartDate() { return $this->startDate; } /**** * Set endDate * * @param \DateTime $endDate * @return Event */ public function setEndDate($endDate) { $this->endDate = $endDate; return $this; } /**** * Get endData * * @return \DateTime */ public function getEndDate() { return $this->endDate; } /**** * Set users. * * @param ArrayCollection $users * * @return Event */ public function setUsers(ArrayCollection $users) { $this->users = $users; return $this; } /**** * Add user. * * @param User $user * * @return Event */ public function addUser(User $user) { if (!$this->users->contains($user)) { $this->users[] = $user; } return $this; } /**** * Get user. * * @return User */ public function getUsers() { return $this->users; } /**** * Remove user * * @param User $user */ public function removeUser(User $user) { $this->users->removeElement($user); } } ``` And here is how i try to find events related to user: ``` private function getActiveEventsCriteria($camelStyle = true, $dateAsObject = true) { $currentDateTime = new \DateTime(); $criteria = Criteria::create() ->where( Criteria::expr()->andX( Criteria::expr()->lte($camelStyle ? 'startDate' : 'start_date', $dateAsObject ? $currentDateTime : $currentDateTime->format("Y-m-d H:i:s")), Criteria::expr()->gte($camelStyle ? 'endDate' : 'end_date', $dateAsObject ? $currentDateTime : $currentDateTime->format("Y-m-d H:i:s")) ) ) ->andWhere(Criteria::expr()->eq('visible', 1)); return $criteria; } public function getParticipatingEventsBy(User $user) { $userEvents = $user->getEvents(); if (is_null($userEvents)) return []; return $userEvents->matching($this->getActiveEventsCriteria(false, false)); } $this->getParticipatingEventsBy($user); ``` In profiler/debug i see next sql: ``` SELECT te.id AS id, te.event*name AS event*name, te.event*description AS event*description, te.event*type AS event*type, te.visible AS visible, te.start*date AS start*date, te.end*date AS end*date FROM event te JOIN users*events t ON t.event*id = te.id WHERE t.user_id = ? AND te.start_date = ? AND te.end_date = ? AND te.visible = ? ``` And with applied parameters: ``` SELECT te.id AS id, te.event*name AS event*name, te.event*description AS event*description, te.event*type AS event*type, te.visible AS visible, te.start*date AS start*date, te.end*date AS end*date FROM event te JOIN users*events t ON t.event*id = te.id WHERE t.user_id = 14 AND te.start_date = '2015-12-03 16:26:44' AND te.end_date = '2015-12-03 16:26:44' AND te.visible = 1; ``` I changed WHERE to next: ``` WHERE t.user_id = 14 AND te.start_date <= '2015-12-03 16:26:44' AND te.end_date >= '2015-12-03 16:26:44' AND te.visible = 1; ``` And with that sql i got correct result. When i use same criteria right with repository without relation to user - everything is ok: ``` public function getActiveEvents() { return $this->matching($this->getActiveEventsCriteria()); } public function matching(Criteria $criteria) { return $this->repository->matching($criteria); } $this->getActiveEvents(); ``` This is formatted sql: ``` SELECT t0.id AS id_1, t0.event*name AS event_name*2, t0.event*description AS event_description*3, t0.event*type AS event_type*4, t0.visible AS visible_5, t0.start*date AS start_date*6, t0.end*date AS end_date*7 FROM event t0 WHERE ( ( t0.start_date <= ? AND t0.end_date >= ? ) AND t0.visible = ? ) ``` And with applied parameters: ``` SELECT t0.id AS id_1, t0.event*name AS event_name*2, t0.event*description AS event_description*3, t0.event*type AS event_type*4, t0.visible AS visible_5, t0.start*date AS start_date*6, t0.end*date AS end_date*7 FROM event t0 WHERE ((t0.start*date <= '2015-12-03 17:01:47' AND t0.end*date >= '2015-12-03 17:01:47') AND t0.visible = 1); ``` As you can see, for case when i dont try to search through relation - everything is ok, i get result. But when i try related events to user with use of Criteria - it fails and return empty result cause of incorrect sql. I use php 5.6.*, symfony 2.8, doctrine 2.5.2, latest MySQL. Any help will be very appreciated. Thank you.

admin added the Bug label 2026-01-22 14:51:58 +01:00

admin commented 2026-01-22 14:51:59 +01:00

Author

Owner

Copy Link

@DonCallisto commented on GitHub (Feb 12, 2016):

@beberlei I suppose that this http://stackoverflow.com/questions/35358597/in-predicate-with-criteria-filtering-isnt-working/35365985#35365985 is related with this bug. Don't know if it adds some details for resolution. If not, sorry for this post :)

@DonCallisto commented on GitHub (Feb 12, 2016): @beberlei I suppose that this http://stackoverflow.com/questions/35358597/in-predicate-with-criteria-filtering-isnt-working/35365985#35365985 is related with this bug. Don't know if it adds some details for resolution. If not, sorry for this post :)

Sign in to join this conversation.

No Branch/Tag Specified

Branches Tags

3.6.x

2.20.x

dependabot/github_actions/2.20.x/doctrine/dot-github/dot-github/workflows/composer-lint.yml-14.0.0

3.7.x

4.0.x

2.21.x

old-prototype-3.x

3.6.2

3.6.1

3.6.0

2.20.9

3.5.8

3.5.7

3.5.6

3.5.5

2.20.8

3.5.4

3.5.3

2.20.7

3.5.2

2.20.6

3.5.1

3.5.0

3.4.4

3.4.3

3.4.2

2.20.5

3.4.1

3.4.0

3.3.4

2.20.4

3.3.3

2.20.3

3.3.2

2.20.2

3.3.1

2.20.1

3.3.0

3.2.3

2.20.0

2.19.8

3.2.2

2.19.7

3.2.1

2.19.6

3.2.0

3.1.4

3.1.3

2.19.5

3.1.2

2.19.4

3.1.1

2.19.3

2.19.2

2.19.1

3.1.0

2.19.0

3.0.3

2.18.3

3.0.2

2.18.2

3.0.1

2.18.1

3.0.0

2.18.0

2.17.5

3.0.0-RC1

2.17.4

2.17.3

2.17.2

2.17.1

3.0.0-beta2

2.17.0

2.16.3

3.0.0-beta1

2.16.2

2.16.1

2.16.0

2.15.5

2.15.4

2.15.3

2.15.2

2.15.1

2.15.0

2.14.3

2.14.2

2.14.1

2.14.0

2.13.5

2.13.4

2.13.3

2.13.2

2.13.1

2.13.0

2.12.4

2.12.3

2.12.2

2.12.1

2.12.0

2.11.3

2.11.2

2.11.1

2.11.0

2.10.5

2.10.4

2.10.3

2.10.2

2.10.1

2.10.0

2.9.6

2.9.5

2.9.4

2.9.3

2.9.2

2.9.1

2.9.0

2.8.5

2.8.4

2.8.3

2.8.2

2.8.1

2.8.0

2.7.5

2.7.4

v2.7.3

v2.7.2

v2.7.1

v2.7.0

v2.6.6

v2.6.5

v2.6.4

v2.6.3

v2.6.2

v2.6.1

v2.6.0

v2.5.14

v2.5.13

v2.5.12

v2.5.11

v2.5.10

v2.5.9

v2.5.8

v2.5.7

v2.5.6

v2.5.5

v2.5.4

v2.5.3

v2.5.2

v2.4.8

v2.5.1

v2.5.0

v2.5.0-RC2

v2.5.0-RC1

v2.5.0-beta1

v2.5.0-alpha2

v2.5.0-alpha1

v2.4.7

v2.4.6

v2.4.5

v2.4.4

v2.4.3

v2.3.6

v2.4.2

2.3.5

v2.4.1

v2.4.0

2.4.0-RC2

2.4.0-RC1

2.4.0-BETA2

2.3.4

2.3.3

2.4.0-BETA1

2.3.2

2.3.1

2.3.0

2.3.0-RC4

2.3.0-RC3

2.3.0-RC2

2.2.3

2.3.0-RC1

2.3.0-BETA1

2.1.7

2.2.2

2.2.1

2.1.6

2.2.0

2.2.0-RC1

2.2.0-BETA2

2.2.0-BETA1

2.1.5

2.1.4

2.1.3

2.1.2

2.1.1

2.0.7

2.1.0

2.1.0RC3

2.1.0RC2

2.1.0RC1

2.0.6

2.1.0BETA1

2.0.5

2.0.4

2.0.3

2.0.2

2.0.1

2.0.0

2.0.0RC2

2.0.0RC1

2.0.0-BETA4

2.0.0-BETA3

2.0.0-BETA2

2.0.0-BETA1

Labels

Clear labels

BC Break

Bug

Can't Fix

Deprecation

Documentation

DQL

Duplicate

Failing Test

Hacktoberfest

Improvement

Improvement

Incomplete

Invalid

Missing Tests

New Feature

PR Created

pull-request

Mirrored from GitHub Pull Request

Question

Regression

Status: Waiting feedback

Waiting feedback

WIP

Won't Fix

No Label Bug

Milestone

No items

No Milestone

Projects

Clear projects

No project

Assignees

Clear assignees

admin

No Assignees

1 Participants

Notifications

Subscribe

Due Date

No due date set.

Dependencies

No dependencies set.

Reference: doctrine/archived-orm#4917