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
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
|
<?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;
/** @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);
}
}
/**
* @Entity
* @Table(name="GH9579_containers")
*/
class GH9579Container
{
/**
* @Id
* @Column(type="integer")
* @GeneratedValue
* @var int
*/
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;
}
/**
* @Entity
* @Table(name="GH9579_items")
*/
class GH9579Item
{
public function __construct()
{
$this->parts = new ArrayCollection();
}
/**
* @Id
* @Column(type="integer")
* @GeneratedValue
* @var int
*/
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;
}
/**
* @Entity
* @Table(name="GH9579_parts")
*/
class GH9579Part
{
/**
* @Id
* @Column(type="integer")
* @GeneratedValue
* @var int
*/
public $id;
/**
* @var GH9579Item
* @ManyToOne (targetEntity="GH9579Item", inversedBy="parts")
* @JoinColumn(name="item_id", referencedColumnName="id")
*/
public $item;
}
|
