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
|
<?php
declare(strict_types=1);
namespace Doctrine\Tests\ORM\Functional\Ticket;
use Doctrine\Common\Collections\Collection;
use Doctrine\ORM\Mapping\Column;
use Doctrine\ORM\Mapping\Entity;
use Doctrine\ORM\Mapping\Id;
use Doctrine\ORM\Mapping\InverseJoinColumn;
use Doctrine\ORM\Mapping\JoinColumn;
use Doctrine\ORM\Mapping\JoinTable;
use Doctrine\ORM\Mapping\ManyToMany;
use Doctrine\ORM\Mapping\Table;
use Doctrine\Tests\OrmFunctionalTestCase;
use PHPUnit\Framework\Attributes\Group;
class DDC809Test extends OrmFunctionalTestCase
{
protected function setUp(): void
{
parent::setUp();
$this->createSchemaForModels(
DDC809Variant::class,
DDC809SpecificationValue::class,
);
$conn = $this->_em->getConnection();
$conn->insert('specification_value_test', ['specification_value_id' => 94589]);
$conn->insert('specification_value_test', ['specification_value_id' => 94593]);
$conn->insert('specification_value_test', ['specification_value_id' => 94606]);
$conn->insert('specification_value_test', ['specification_value_id' => 94607]);
$conn->insert('specification_value_test', ['specification_value_id' => 94609]);
$conn->insert('specification_value_test', ['specification_value_id' => 94711]);
$conn->insert('variant_test', ['variant_id' => 545208]);
$conn->insert('variant_test', ['variant_id' => 545209]);
$conn->insert('var_spec_value_test', ['variant_id' => 545208, 'specification_value_id' => 94606]);
$conn->insert('var_spec_value_test', ['variant_id' => 545208, 'specification_value_id' => 94607]);
$conn->insert('var_spec_value_test', ['variant_id' => 545208, 'specification_value_id' => 94609]);
$conn->insert('var_spec_value_test', ['variant_id' => 545208, 'specification_value_id' => 94711]);
$conn->insert('var_spec_value_test', ['variant_id' => 545209, 'specification_value_id' => 94589]);
$conn->insert('var_spec_value_test', ['variant_id' => 545209, 'specification_value_id' => 94593]);
$conn->insert('var_spec_value_test', ['variant_id' => 545209, 'specification_value_id' => 94606]);
$conn->insert('var_spec_value_test', ['variant_id' => 545209, 'specification_value_id' => 94607]);
}
#[Group('DDC-809')]
public function testIssue(): void
{
$result = $this->_em->createQueryBuilder()
->select('Variant, SpecificationValue')
->from(DDC809Variant::class, 'Variant')
->leftJoin('Variant.specificationValues', 'SpecificationValue')
->getQuery()
->getResult();
self::assertCount(4, $result[0]->getSpecificationValues(), 'Works in test-setup.');
self::assertCount(4, $result[1]->getSpecificationValues(), 'Only returns 2 in the case of the hydration bug.');
}
}
#[Table(name: 'variant_test')]
#[Entity]
class DDC809Variant
{
/** @var int */
#[Column(name: 'variant_id', type: 'integer')]
#[Id]
protected $variantId;
/** @phpstan-var Collection<int, DDC809SpecificationValue> */
#[JoinTable(name: 'var_spec_value_test')]
#[JoinColumn(name: 'variant_id', referencedColumnName: 'variant_id')]
#[InverseJoinColumn(name: 'specification_value_id', referencedColumnName: 'specification_value_id')]
#[ManyToMany(targetEntity: 'DDC809SpecificationValue', inversedBy: 'Variants')]
protected $specificationValues;
/** @phpstan-return Collection<int, DDC809SpecificationValue> */
public function getSpecificationValues(): Collection
{
return $this->specificationValues;
}
}
#[Table(name: 'specification_value_test')]
#[Entity]
class DDC809SpecificationValue
{
/** @var int */
#[Column(name: 'specification_value_id', type: 'integer')]
#[Id]
protected $specificationValueId;
/** @phpstan-var Collection<int,DDC809Variant> */
#[ManyToMany(targetEntity: 'DDC809Variant', mappedBy: 'SpecificationValues')]
protected $variants;
}
|