1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
|
<?php
declare(strict_types=1);
namespace Doctrine\Tests\ORM\Functional\Ticket;
use Doctrine\Common\Collections\ArrayCollection;
use Doctrine\ORM\Mapping\Column;
use Doctrine\ORM\Mapping\Entity;
use Doctrine\ORM\Mapping\GeneratedValue;
use Doctrine\ORM\Mapping\Id;
use Doctrine\ORM\Mapping\JoinColumn;
use Doctrine\ORM\Mapping\ManyToOne;
use Doctrine\ORM\Mapping\OneToMany;
use Doctrine\ORM\Mapping\OneToOne;
use Doctrine\ORM\Mapping\Table;
use Doctrine\Tests\OrmFunctionalTestCase;
use PHPUnit\Framework\Attributes\Group;
#[Group('GH-9579')]
class GH9579Test extends OrmFunctionalTestCase
{
protected function setUp(): void
{
parent::setUp();
$this->createSchemaForModels(
GH9579Container::class,
GH9579Item::class,
GH9579Part::class,
);
$container = new GH9579Container();
$item = new GH9579Item();
$item->container = $container;
$container->currentItem = $item;
$part = new GH9579Part();
$part->item = $item;
$this->_em->persist($item);
$this->_em->persist($container);
$this->_em->persist($part);
$this->_em->flush();
$this->_em->clear();
}
#[Group('GH-9579')]
public function testIssue(): void
{
$dql = <<<'DQL'
SELECT container, currentItem, currentItemPart, item, itemPart
FROM Doctrine\Tests\ORM\Functional\Ticket\GH9579Container container
LEFT JOIN container.currentItem currentItem
LEFT JOIN currentItem.parts currentItemPart
LEFT JOIN container.items item
LEFT JOIN item.parts itemPart
DQL;
$containers = $this->_em->createQuery($dql)->execute();
self::assertCount(1, $containers);
self::assertCount(1, $containers[0]->items);
self::assertCount(1, $containers[0]->items[0]->parts);
}
}
#[Table(name: 'GH9579_containers')]
#[Entity]
class GH9579Container
{
/** @var int */
#[Id]
#[Column(type: 'integer')]
#[GeneratedValue]
public $id;
/** @var Collection<int, GH9579Item> */
#[OneToMany(targetEntity: 'GH9579Item', mappedBy: 'container')]
public $items;
public function __construct()
{
$this->items = new ArrayCollection();
}
/** @var GH9579Item */
#[OneToOne(targetEntity: 'GH9579Item')]
#[JoinColumn(name: 'item_id', referencedColumnName: 'id')]
public $currentItem;
}
#[Table(name: 'GH9579_items')]
#[Entity]
class GH9579Item
{
public function __construct()
{
$this->parts = new ArrayCollection();
}
/** @var int */
#[Id]
#[Column(type: 'integer')]
#[GeneratedValue]
public $id;
/** @var Collection<int, GH9579Part> */
#[OneToMany(targetEntity: 'GH9579Part', mappedBy: 'item')]
public $parts;
/** @var GH9579Container */
#[ManyToOne(targetEntity: 'GH9579Container', inversedBy: 'items')]
#[JoinColumn(name: 'container_id', referencedColumnName: 'id')]
public $container;
}
#[Table(name: 'GH9579_parts')]
#[Entity]
class GH9579Part
{
/** @var int */
#[Id]
#[Column(type: 'integer')]
#[GeneratedValue]
public $id;
/** @var GH9579Item */
#[ManyToOne(targetEntity: 'GH9579Item', inversedBy: 'parts')]
#[JoinColumn(name: 'item_id', referencedColumnName: 'id')]
public $item;
}
|
