DDC-1494: Query results are overwritten by previous query. #1874

New Issue

Closed

opened 2026-01-22 13:29:13 +01:00 by admin · 8 comments

admin commented 2026-01-22 13:29:13 +01:00

Owner

Copy Link

Originally created by @doctrinebot on GitHub (Nov 15, 2011).

Originally assigned to: @Ocramius on GitHub.

Jira issue originally created by user monk.e.boy:

I am running a query that JOINs three tables, with a simple WHERE:

$q = $em->createQuery("

SELECT cat, n, c
FROM Project*Model*NoticeCategory cat
JOIN cat.notices n
JOIN n.chapters c
WHERE
c.id = :chapter_id

");

When I do this:

  $q->setParameter('chapter_id', 1);
  $a = $q->getResult();

  $q->setParameter('chapter_id', 2);
  $b = $q->getResult();

$b always has the wrong results. Running the following code:

  $q->setParameter('chapter_id', 1);
  $a = $q->getResult();

  $q->setParameter('chapter_id', 2);
  $b = $q->getResult();
  $z = $q->getArrayResult();

BUG Results: $b != $z (getArrayResult IS CORRECT, it refreshes the results) Note: $a==$b (which is wrong)

Explanation:

There is a chapter table, this has a many-to-many join to notices (these are meta info
about the chapter -- a little like tagging a blog post) the notices are grouped into
categories.

Data model:

/****
 * @Entity
 * @Table(name="chapter")
 */
class Project*Model*Chapter
{
    /****
     * @Id @Column(type="integer")
     * @GeneratedValue(strategy="AUTO")
     */
    private $id;

    /*** @Column(type="string") **/
    private $title;

    /****
     * @ManyToMany(targetEntity="Project*Model*Notice", mappedBy="chapters")
     */
    private $notices;

    .... /lots of code snipped/ ....

}


/****
 * @Entity
 * @Table(name="notice")
 */
class Project*Model*Notice
{
    /****
     * @Id @Column(type="integer")
     * @GeneratedValue(strategy="AUTO")
     */
    private $id;

    /*** @Column(type="string") **/
    private $title;

    /****
     * @ManyToMany(targetEntity="Project*Model*Chapter", inversedBy="notices")
     * @JoinTable(name="chapter_notice")
     */
    private $chapters;

    /****
     * @ManyToOne(targetEntity="Project*Model*NoticeCategory", inversedBy="notices")
     */
    private $notice_category;

    .... /lots of code snipped/ ....

}

/****
 * @Entity
 * @Table(name="notice_category")
 */
class Project*Model*NoticeCategory
{
    /****
     * @Id @Column(type="integer")
     * @GeneratedValue(strategy="AUTO")
     */
    private $id;
    /*** @Column(type="string") **/
    private $title;

    /****
     * Bidirectional - One-To-Many (INVERSE SIDE)
     *
     * @OneToMany(targetEntity="Project*Model_Notice", mappedBy="notice*category", cascade={"persist", "remove"})
     */
    private $notices;

    .... /lots of code snipped/ ....

}

Data fixtures:

$tools = new \Project*Model*NoticeCategory;
$tools->setTitle('Tools');

$spanner = new \Project*Model*Notice;
$spanner->setTitle('spanner');
$tools->addNotice($spanner);

$drill = new \Project*Model*Notice;
$drill->setTitle('power drill');
$tools->addNotice($drill);

$this->em->persist($tools);
$this->em->flush();

$tools = new \Project*Model*NoticeCategory;
$tools->setTitle('Safety');

$gloves = new \Project*Model*Notice;
$gloves->setTitle('gloves');
$tools->addNotice($gloves);

$goggles = new \Project*Model*Notice;
$goggles->setTitle('goggles');
$tools->addNotice($goggles);

$this->em->persist($tools);
$this->em->flush();

$chapter1 = new \Project*Model*Chapter;
$chapter1->setTitle('Chapter 1');
$this->em->persist($chapter1);

$chapter2 = new \Project*Model*Chapter;
$chapter2->setTitle('Chapter 2');
$this->em->persist($chapter2);

$chapter1->addNotice($spanner);
$chapter1->addNotice($gloves);

$chapter2->addNotice($spanner);
$chapter2->addNotice($gloves);
$chapter2->addNotice($drill);
$chapter2->addNotice($goggles);

// now persist and flush everything

Initial investigation:

I think it has something to do with HINT_REFRESH ? Stepping through:

ObjectHydrator->_hydrateRow
ObjectHydrator->_getEntity

when it requests the Project_Model_Category from the unit of work, it
seems that the second query is simply grabbing the cached results from
the first results. This MUST be wrong as the second query uses a
different query (the ID changes) and all the results are wrong.

Originally created by @doctrinebot on GitHub (Nov 15, 2011). Originally assigned to: @Ocramius on GitHub. Jira issue originally created by user monk.e.boy: I am running a query that JOINs three tables, with a simple WHERE: ``` $q = $em->createQuery(" SELECT cat, n, c FROM Project*Model*NoticeCategory cat JOIN cat.notices n JOIN n.chapters c WHERE c.id = :chapter_id "); ``` When I do this: ``` $q->setParameter('chapter_id', 1); $a = $q->getResult(); $q->setParameter('chapter_id', 2); $b = $q->getResult(); ``` $b always has the wrong results. Running the following code: ``` $q->setParameter('chapter_id', 1); $a = $q->getResult(); $q->setParameter('chapter_id', 2); $b = $q->getResult(); $z = $q->getArrayResult(); ``` BUG Results: $b != $z (getArrayResult IS CORRECT, it refreshes the results) Note: $a==$b (which is wrong) Explanation: There is a chapter table, this has a many-to-many join to notices (these are meta info about the chapter -- a little like tagging a blog post) the notices are grouped into categories. Data model: ``` /**** * @Entity * @Table(name="chapter") */ class Project*Model*Chapter { /**** * @Id @Column(type="integer") * @GeneratedValue(strategy="AUTO") */ private $id; /*** @Column(type="string") **/ private $title; /**** * @ManyToMany(targetEntity="Project*Model*Notice", mappedBy="chapters") */ private $notices; .... /lots of code snipped/ .... } /**** * @Entity * @Table(name="notice") */ class Project*Model*Notice { /**** * @Id @Column(type="integer") * @GeneratedValue(strategy="AUTO") */ private $id; /*** @Column(type="string") **/ private $title; /**** * @ManyToMany(targetEntity="Project*Model*Chapter", inversedBy="notices") * @JoinTable(name="chapter_notice") */ private $chapters; /**** * @ManyToOne(targetEntity="Project*Model*NoticeCategory", inversedBy="notices") */ private $notice_category; .... /lots of code snipped/ .... } /**** * @Entity * @Table(name="notice_category") */ class Project*Model*NoticeCategory { /**** * @Id @Column(type="integer") * @GeneratedValue(strategy="AUTO") */ private $id; /*** @Column(type="string") **/ private $title; /**** * Bidirectional - One-To-Many (INVERSE SIDE) * * @OneToMany(targetEntity="Project*Model_Notice", mappedBy="notice*category", cascade={"persist", "remove"}) */ private $notices; .... /lots of code snipped/ .... } ``` Data fixtures: ``` $tools = new \Project*Model*NoticeCategory; $tools->setTitle('Tools'); $spanner = new \Project*Model*Notice; $spanner->setTitle('spanner'); $tools->addNotice($spanner); $drill = new \Project*Model*Notice; $drill->setTitle('power drill'); $tools->addNotice($drill); $this->em->persist($tools); $this->em->flush(); $tools = new \Project*Model*NoticeCategory; $tools->setTitle('Safety'); $gloves = new \Project*Model*Notice; $gloves->setTitle('gloves'); $tools->addNotice($gloves); $goggles = new \Project*Model*Notice; $goggles->setTitle('goggles'); $tools->addNotice($goggles); $this->em->persist($tools); $this->em->flush(); $chapter1 = new \Project*Model*Chapter; $chapter1->setTitle('Chapter 1'); $this->em->persist($chapter1); $chapter2 = new \Project*Model*Chapter; $chapter2->setTitle('Chapter 2'); $this->em->persist($chapter2); $chapter1->addNotice($spanner); $chapter1->addNotice($gloves); $chapter2->addNotice($spanner); $chapter2->addNotice($gloves); $chapter2->addNotice($drill); $chapter2->addNotice($goggles); // now persist and flush everything ``` Initial investigation: I think it has something to do with HINT_REFRESH ? Stepping through: ObjectHydrator->_hydrateRow ObjectHydrator->_getEntity when it requests the Project_Model_Category from the unit of work, it seems that the second query is simply grabbing the cached results from the first results. This MUST be wrong as the second query uses a different query (the ID changes) and all the results are wrong.

admin added the BugInvalid labels 2026-01-22 13:29:13 +01:00

admin closed this issue 2026-01-22 13:29:14 +01:00

admin commented 2026-01-22 13:29:15 +01:00

Author

Owner

Copy Link

@doctrinebot commented on GitHub (Nov 15, 2011):

Comment created by @beberlei:

Fixed formatting

@doctrinebot commented on GitHub (Nov 15, 2011): Comment created by @beberlei: Fixed formatting

admin commented 2026-01-22 13:29:16 +01:00

Author

Owner

Copy Link

@doctrinebot commented on GitHub (Nov 18, 2011):

Comment created by @beberlei:

are you using result caching?

@doctrinebot commented on GitHub (Nov 18, 2011): Comment created by @beberlei: are you using result caching?

admin commented 2026-01-22 13:29:17 +01:00

Author

Owner

Copy Link

@doctrinebot commented on GitHub (Nov 21, 2011):

Comment created by monk.e.boy:

This is part of my bootstrap
,
,

$config = new \Doctrine\ORM\Configuration();

$cache = new \Doctrine\Common\Cache\ArrayCache;
$config->setMetadataCacheImpl($cache);
$config->setQueryCacheImpl($cache);

// driver: schema
$driver = $config->newDefaultAnnotationDriver(
    APPLICATION_PATH . '/models'
);
$config->setMetadataDriverImpl($driver);

@doctrinebot commented on GitHub (Nov 21, 2011): Comment created by monk.e.boy: This is part of my bootstrap , , ``` java $config = new \Doctrine\ORM\Configuration(); $cache = new \Doctrine\Common\Cache\ArrayCache; $config->setMetadataCacheImpl($cache); $config->setQueryCacheImpl($cache); // driver: schema $driver = $config->newDefaultAnnotationDriver( APPLICATION_PATH . '/models' ); $config->setMetadataDriverImpl($driver); ```

admin commented 2026-01-22 13:29:19 +01:00

Author

Owner

Copy Link

@doctrinebot commented on GitHub (Dec 15, 2011):

Comment created by @beberlei:

Cannot reproduce it with the script attached. Can you try to modify this to fail or write your own testcase?

@doctrinebot commented on GitHub (Dec 15, 2011): Comment created by @beberlei: Cannot reproduce it with the script attached. Can you try to modify this to fail or write your own testcase?

admin commented 2026-01-22 13:29:20 +01:00

Author

Owner

Copy Link

@doctrinebot commented on GitHub (Dec 15, 2011):

Comment created by @beberlei:

Downgraded

@doctrinebot commented on GitHub (Dec 15, 2011): Comment created by @beberlei: Downgraded

admin commented 2026-01-22 13:29:22 +01:00

Author

Owner

Copy Link

@doctrinebot commented on GitHub (Feb 9, 2013):

Comment created by @asm89:

Please provide extra feedback.

@doctrinebot commented on GitHub (Feb 9, 2013): Comment created by @asm89: Please provide extra feedback.

admin commented 2026-01-22 13:29:22 +01:00

Author

Owner

Copy Link

@doctrinebot commented on GitHub (Dec 13, 2015):

Imported 1 attachments from Jira into https://gist.github.com/569badd09f4b0e7bbb2c

• 11131_DDC1494Test.php

@doctrinebot commented on GitHub (Dec 13, 2015): Imported 1 attachments from Jira into https://gist.github.com/569badd09f4b0e7bbb2c - [11131_DDC1494Test.php](https://gist.github.com/569badd09f4b0e7bbb2c#file-11131_DDC1494Test-php)

admin commented 2026-01-22 13:29:22 +01:00

Author

Owner

Copy Link

@malukenho commented on GitHub (Jan 5, 2017):

@Ocramius @lcobucci can't reproduce bug with the provided file. Can be closed as invalid IMO as no feedback was provided since then.

@malukenho commented on GitHub (Jan 5, 2017): @Ocramius @lcobucci can't reproduce bug with the provided file. Can be closed as invalid IMO as no feedback was provided since then.

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 Invalid

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#1874