ArrayCollection of root entity not filled with related entities. #7486

New Issue

Closed

opened 2026-01-22 15:52:14 +01:00 by admin · 1 comment

admin commented 2026-01-22 15:52:14 +01:00

Owner

Copy Link

Originally created by @AndreRudolph on GitHub (Mar 10, 2025).

Bug Report

Many To Many by using Pivot entity as One To Many <-> Many To One does not fill ArrayCollection with entities.

Q	A
Version	3.3.2

Summary

I have a N:M relation which I split up into One To Many <-> Many to One by adding a pivot entity. More precisely I have the pivot Entity TeamUsers which references both sides, the Team and the User.

Current behavior

I have these entities:

`#[Entity]
#[Table(name: 'teams')]
#[HasLifecycleCallbacks]
class Team implements TeamInterface {

#[Id]
#[GeneratedValue(strategy: 'CUSTOM')]
#[CustomIdGenerator(class: UuidGenerator::class)]
#[Column(type: 'string', length: 36, unique: true)]
private string $id;

#[Column(type: 'string', length: 255, nullable: false)]
private string $name;

#[ManyToOne(targetEntity: Tenant::class, cascade: ['remove'])]
#[JoinColumn(name: 'tenant_id', referencedColumnName: 'id', nullable: false)]
private TenantInterface $tenant;

#[ManyToOne(targetEntity: User::class, cascade: ['remove'])]
#[JoinColumn(name: 'owner_id', referencedColumnName: 'id', nullable: false)]
private UserInterface $owner;

#[OneToMany(targetEntity: TeamUser::class, mappedBy: 'team')]
private Collection $teamUsers;

#[Column(type: 'datetime', nullable: false)]
public DateTimeInterface $createdAt;

public function __construct() {
    $this->teamUsers = new ArrayCollection();
}

public function getTeamUsers(): Collection {
    return $this->teamUsers;
}

public function setTeamUsers(Collection $teamUsers): TeamInterface {
    $this->teamUsers = $teamUsers;
    return $this;
}

public function addTeamUser(TeamUser $teamUser): self {
    if (!$this->teamUsers->contains($teamUser)) {
        $this->teamUsers->add($teamUser);
        $teamUser->setTeam($this);
    }
    return $this;
}

public function removeTeamUser(TeamUser $teamUser): self {
    if ($this->teamUsers->contains($teamUser)) {
        $this->teamUsers->removeElement($teamUser);
        if ($teamUser->getTeam() === $this) {
            $teamUser->setTeam(null);
        }
    }
    return $this;
}

}`

`
#[Entity]
#[Table(name: 'team_users')]
#[HasLifecycleCallbacks]
class TeamUser implements TeamUserInterface {

#[Id]
#[ManyToOne(targetEntity: User::class)]
#[JoinColumn(name: 'user_id', referencedColumnName: 'id', nullable: false)]
private UserInterface $user;

#[Id]
#[ManyToOne(targetEntity: Team::class, inversedBy: 'teamUsers')]
#[JoinColumn(name: 'team_id', referencedColumnName: 'id', nullable: false)]
private TeamInterface $team;

#[Column(type: 'datetime', nullable: false)]
private DateTimeInterface $joinedAt;

// setters & getters

}`

`
#[Entity]
#[Table(name: 'users')]
#[HasLifecycleCallbacks]
class User implements UserInterface
{
#[Id]
#[GeneratedValue(strategy: 'CUSTOM')]
#[CustomIdGenerator(class: UuidGenerator::class)]
#[Column(type: 'string', length: 36, unique: true)]
private string $id;

#[Column(type: 'string', unique: true, nullable: false)]
public string $name;

#[Column(type: 'string', unique: true, nullable: false)]
public string $email;

#[Column(type: 'string', nullable: false)]
public string $password;

#[Column(type: 'boolean')]
public bool $active = true;

#[Column(type: 'datetime', nullable: false)]
public DateTime $createdAt;

#[Column(name: 'profile_photo_path', type: 'string', nullable: true)]
public ?string $profilePhotoPath = null;

#[ManyToOne(targetEntity: Tenant::class)]
#[JoinColumn(name: 'tenant_id', referencedColumnName: 'id', nullable: false)]
public TenantInterface $tenant;

// getter & setter

}`

When I run this following query

SELECT team, teamUser FROM App\Infrastructure\Entities\Team team LEFT JOIN team.teamUsers teamUser

Then I get the root entity (team) but with an empty TeamUser collection. I ran the actual SQL query and it returns the expected results and after some debugging I figured out that doctrine correctly creates the entities (Team, TeamUser) but it does not link them, so somehow it does not add the TeamUser entries to the ArrayCollection of the root entity.

Am I doing something wrong with the mapping or do I oversee something?

PS: The doctrine command for schema validation also gives feedback, that the mapping files are correct.

Originally created by @AndreRudolph on GitHub (Mar 10, 2025). ### Bug Report Many To Many by using Pivot entity as One To Many <-> Many To One does not fill ArrayCollection with entities. | Q | A |-------------------------------------------- | ------ | Version | 3.3.2 #### Summary I have a N:M relation which I split up into One To Many <-> Many to One by adding a pivot entity. More precisely I have the pivot Entity TeamUsers which references both sides, the Team and the User. #### Current behavior I have these entities: `#[Entity] #[Table(name: 'teams')] #[HasLifecycleCallbacks] class Team implements TeamInterface { #[Id] #[GeneratedValue(strategy: 'CUSTOM')] #[CustomIdGenerator(class: UuidGenerator::class)] #[Column(type: 'string', length: 36, unique: true)] private string $id; #[Column(type: 'string', length: 255, nullable: false)] private string $name; #[ManyToOne(targetEntity: Tenant::class, cascade: ['remove'])] #[JoinColumn(name: 'tenant_id', referencedColumnName: 'id', nullable: false)] private TenantInterface $tenant; #[ManyToOne(targetEntity: User::class, cascade: ['remove'])] #[JoinColumn(name: 'owner_id', referencedColumnName: 'id', nullable: false)] private UserInterface $owner; #[OneToMany(targetEntity: TeamUser::class, mappedBy: 'team')] private Collection $teamUsers; #[Column(type: 'datetime', nullable: false)] public DateTimeInterface $createdAt; public function __construct() { $this->teamUsers = new ArrayCollection(); } public function getTeamUsers(): Collection { return $this->teamUsers; } public function setTeamUsers(Collection $teamUsers): TeamInterface { $this->teamUsers = $teamUsers; return $this; } public function addTeamUser(TeamUser $teamUser): self { if (!$this->teamUsers->contains($teamUser)) { $this->teamUsers->add($teamUser); $teamUser->setTeam($this); } return $this; } public function removeTeamUser(TeamUser $teamUser): self { if ($this->teamUsers->contains($teamUser)) { $this->teamUsers->removeElement($teamUser); if ($teamUser->getTeam() === $this) { $teamUser->setTeam(null); } } return $this; } }` ` #[Entity] #[Table(name: 'team_users')] #[HasLifecycleCallbacks] class TeamUser implements TeamUserInterface { #[Id] #[ManyToOne(targetEntity: User::class)] #[JoinColumn(name: 'user_id', referencedColumnName: 'id', nullable: false)] private UserInterface $user; #[Id] #[ManyToOne(targetEntity: Team::class, inversedBy: 'teamUsers')] #[JoinColumn(name: 'team_id', referencedColumnName: 'id', nullable: false)] private TeamInterface $team; #[Column(type: 'datetime', nullable: false)] private DateTimeInterface $joinedAt; // setters & getters }` ` #[Entity] #[Table(name: 'users')] #[HasLifecycleCallbacks] class User implements UserInterface { #[Id] #[GeneratedValue(strategy: 'CUSTOM')] #[CustomIdGenerator(class: UuidGenerator::class)] #[Column(type: 'string', length: 36, unique: true)] private string $id; #[Column(type: 'string', unique: true, nullable: false)] public string $name; #[Column(type: 'string', unique: true, nullable: false)] public string $email; #[Column(type: 'string', nullable: false)] public string $password; #[Column(type: 'boolean')] public bool $active = true; #[Column(type: 'datetime', nullable: false)] public DateTime $createdAt; #[Column(name: 'profile_photo_path', type: 'string', nullable: true)] public ?string $profilePhotoPath = null; #[ManyToOne(targetEntity: Tenant::class)] #[JoinColumn(name: 'tenant_id', referencedColumnName: 'id', nullable: false)] public TenantInterface $tenant; // getter & setter }` When I run this following query `SELECT team, teamUser FROM App\Infrastructure\Entities\Team team LEFT JOIN team.teamUsers teamUser` Then I get the root entity (team) but with an empty TeamUser collection. I ran the actual SQL query and it returns the expected results and after some debugging I figured out that doctrine correctly creates the entities (Team, TeamUser) but it does not link them, so somehow it does not add the TeamUser entries to the ArrayCollection of the root entity.    Am I doing something wrong with the mapping or do I oversee something? PS: The doctrine command for schema validation also gives feedback, that the mapping files are correct.

admin closed this issue 2026-01-22 15:52:14 +01:00

admin commented 2026-01-22 15:52:14 +01:00

Author

Owner

Copy Link

@AndreRudolph commented on GitHub (Mar 10, 2025):

After some more debugging I figured out that the issue was that the already created (and thus managed) entities did have not the same state as the retrieved ones by the query. A call $em->clear() worked and revealed that there was a stale state of the original entities.

@AndreRudolph commented on GitHub (Mar 10, 2025): After some more debugging I figured out that the issue was that the already created (and thus managed) entities did have not the same state as the retrieved ones by the query. A call `$em->clear()` worked and revealed that there was a stale state of the original entities.

admin referenced this issue 2026-01-22 16:09:12 +01:00

[PR #8376] [GH-7486] Bugfix: failing when clearing empty cache is wrong semantics #10954

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

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