DDC-3346: findOneBy returns an object with partial collection for the properties with mapping oneToMany/Fetch Eager #4136

New Issue

admin · 2026-01-22T14:35:51+01:00

admin commented

2026-01-22 14:35:51 +01:00

Originally created by @doctrinebot on GitHub (Oct 10, 2014).

Originally assigned to: @Ocramius on GitHub.

Jira issue originally created by user adrienrusso:

findOneBy returns an object with partial collection for the properties with mapping oneToMany/Fetch Eager. This bug appear only for entities without inheritance.

Test\Bar:
    type: entity
    table: bar
    fields:
        code:
            type: string
    oneToMany:
        posts:
            targetEntity: Test\Post
            fetch: EAGER
            mappedBy: bar
            cascade: ['all']

Test\Post:
    type: entity
    table: post
    fields:
        content:
            type: text
    manyToOne:
        bar:
            targetEntity: Test\Bar
            cascade: []
            joinColumn:
                name: bar_id
                referencedColumnName: id

$bar = new \Test\Bar('foo');
$bar->addPost(
  new Test\Post('toto')
);
$bar->addPost(
  new Test\Post('tata')
);

$bar->getPosts()->count(); #value is 2
$manager->persist($bar);
$manager->flush();

$bar = $repository->findOneBy(['code' => 'foo']);
$bar->getPosts()->count(); #value is 1

$bar = $repository->findOneBy(['code' => 'foo']);
$bar->getPosts()->count(); #value is 2

I think this bug is due to the LIMIT 1 clause happening on findOneBy which also applies on joins generated here.

For instance, the generated SQL statement generated might look like

SELECT
    t0. ID AS id_1,
    t0.code AS code_2,
    t1. ID AS id_3,
    t1.content AS content_4,
    t1.bar*id AS bar_id*5
FROM
    bar t0
LEFT JOIN post t1 ON t1.bar_id = t0. ID
WHERE
    t0. code = 'foo'
LIMIT 1

Originally created by @doctrinebot on GitHub (Oct 10, 2014). Originally assigned to: @Ocramius on GitHub. Jira issue originally created by user adrienrusso: findOneBy returns an object with partial collection for the properties with mapping oneToMany/Fetch Eager. This bug appear only for entities without inheritance. ``` Test\Bar: type: entity table: bar fields: code: type: string oneToMany: posts: targetEntity: Test\Post fetch: EAGER mappedBy: bar cascade: ['all'] Test\Post: type: entity table: post fields: content: type: text manyToOne: bar: targetEntity: Test\Bar cascade: [] joinColumn: name: bar_id referencedColumnName: id ``` ``` $bar = new \Test\Bar('foo'); $bar->addPost( new Test\Post('toto') ); $bar->addPost( new Test\Post('tata') ); $bar->getPosts()->count(); #value is 2 $manager->persist($bar); $manager->flush(); ``` ``` $bar = $repository->findOneBy(['code' => 'foo']); $bar->getPosts()->count(); #value is 1 ``` ``` $bar = $repository->findOneBy(['code' => 'foo']); $bar->getPosts()->count(); #value is 2 ``` I think this bug is due to the `LIMIT 1` clause happening on `findOneBy` which also applies on joins generated [here](https://github.com/doctrine/doctrine2/blob/master/lib/Doctrine/ORM/Persisters/BasicEntityPersister.php#L1211-L1283). For instance, the generated SQL statement generated might look like ``` SELECT t0. ID AS id_1, t0.code AS code_2, t1. ID AS id_3, t1.content AS content_4, t1.bar*id AS bar_id*5 FROM bar t0 LEFT JOIN post t1 ON t1.bar_id = t0. ID WHERE t0. code = 'foo' LIMIT 1 ```

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

admin closed this issue

2026-01-22 14:35:51 +01:00

admin commented

2026-01-22 14:35:52 +01:00

@doctrinebot commented on GitHub (Oct 10, 2014):

@doctrinebot commented on GitHub (Oct 10, 2014): - depends on [DDC-3531: [GH-1277] [DDC-3346] Failing test for issue (bad findOneBy behaviour with eager fetch)](http://www.doctrine-project.org/jira/browse/DDC-3531) - depends on [DDC-3534: [GH-1280] [DDC-3346] #1277 find one with eager loads is failing](http://www.doctrine-project.org/jira/browse/DDC-3534)

admin commented

2026-01-22 14:35:53 +01:00

@doctrinebot commented on GitHub (Jan 22, 2015):

Comment created by scaytrase:

Still expiriencing it at 2.5.0-alpha (b889e18a9a). findOneBy cuts many-to-many association with fetch eager by 'LIMIT 1'

@doctrinebot commented on GitHub (Jan 22, 2015): Comment created by scaytrase: Still expiriencing it at 2.5.0-alpha (b889e18a9a15c36eac7349b06cb4b0f955a9da57). findOneBy cuts many-to-many association with fetch eager by 'LIMIT 1'

admin commented

2026-01-22 14:35:53 +01:00

@doctrinebot commented on GitHub (Jan 22, 2015):

Comment created by @ocramius:

[~scaytrase] yeah, we don't have a fix for it yet: I suggest providing a PR with the failing test first, and if we can't get to it, trying to patch it yourself, or at least find out which code bit affects this behavior.

@doctrinebot commented on GitHub (Jan 22, 2015): Comment created by @ocramius: [~scaytrase] yeah, we don't have a fix for it yet: I suggest providing a PR with the failing test first, and if we can't get to it, trying to patch it yourself, or at least find out which code bit affects this behavior.

admin commented

2026-01-22 14:35:53 +01:00

@doctrinebot commented on GitHub (Jan 22, 2015):

Comment created by scaytrase:

I'm finishing such PR now. Will supply it to github soon

@doctrinebot commented on GitHub (Jan 22, 2015): Comment created by scaytrase: I'm finishing such PR now. Will supply it to github soon

admin commented

2026-01-22 14:35:53 +01:00

@doctrinebot commented on GitHub (Jan 22, 2015):

Comment created by scaytrase:

here it is
https://github.com/doctrine/doctrine2/pull/1277
http://www.doctrine-project.org/jira/browse/DDC-3531

Here is the failed travis build
https://travis-ci.org/scaytrase/doctrine2/jobs/47921568

@doctrinebot commented on GitHub (Jan 22, 2015): Comment created by scaytrase: here it is https://github.com/doctrine/doctrine2/pull/1277 http://www.doctrine-project.org/jira/browse/[DDC-3531](http://www.doctrine-project.org/jira/browse/DDC-3531) Here is the failed travis build https://travis-ci.org/scaytrase/doctrine2/jobs/47921568

admin commented

2026-01-22 14:35:53 +01:00

@doctrinebot commented on GitHub (Jan 23, 2015):