Doctrine 2 Native Query ResultSetMapping doesn't return joined object #5797

New Issue

admin · 2026-01-22T15:18:14+01:00

admin commented

2026-01-22 15:18:14 +01:00

Originally created by @Inmmelman on GitHub (Dec 7, 2017).

I have 3 entities. And try to load data by native SQL with ResultSetMapping. My question is abount why all times profile is null. Code is under text. Please help to resolve this((( I try to join table by addFieldResult and fill columns from this table, but it's doen't has any effects. Domain entity load fine.
I thinking this problem can be because account and profile entitites have the same name of relation field and profile "inversedBy="account""

If I try to use
$rsm->addFieldResult('p', 'first_name', 'firstName', Profile::class);
for load specified field for Profile hydration doesn't work. ObjectHydrator.php in hydrateRowData checks hydrateRowData that must contains isIdentifier fields, in my case first_name it's not identifier and after this check finally set value to null.

Fetching data code

$sql = 'SELECT a.*, p.*, p.account_id as p_account FROM account AS a JOIN profile AS p ON a.account_id = p.account_id WHERE a.domain_id = ? ORDER BY a.account_id DESC LIMIT 0, 25';

$rsm = new ResultSetMapping();
$rsm->addEntityResult(\App\Entity\Account::class, 'account');
$rsm->addJoinedEntityResult(Domain::class, 'd', 'account', 'domain');
$rsm->addJoinedEntityResult(Profile::class, 'p', 'account', 'profile');
$rsm->addFieldResult('account', 'account_id', 'accountId');
$rsm->addFieldResult('account', 'created_date', 'createdDate');
$rsm->addFieldResult('account', 'zendesk_user_id', 'zendeskUserId');
$rsm->addFieldResult('d', 'domain_id', 'id', Domain::class);
$query = $this->em->createNativeQuery($sql, $rsm);
$query->setParameter(1, 1);
$users = $query->getResult();

Account:

/**
 * Class Account
 * @package App\Entity
 * @ORM\Entity(repositoryClass="App\Entity\Repository\AccountRepository")
 * @ORM\Table(name="account")
 */
class Account 
{
    /**
     * @var Domain
     * @ORM\ManyToOne(targetEntity="Domain")
     * @ORM\JoinColumns({
     *   @ORM\JoinColumn(name="domain_id", referencedColumnName="id")
     * })
     */
    protected $domain;

    /**
     * @var Profile
     *
     * @ORM\OneToOne(targetEntity="Profile", inversedBy="account", fetch="LAZY", cascade={"all"})
     * @ORM\JoinColumn(name="account_id", referencedColumnName="account_id")
     */
    protected $profile;
}

Profile:

/**
 * Class Profile
 * @package App\Entity
 *
 * @ORM\Entity
 * @ORM\Table(name="profile")
 */
class Profile 
{

    /**
     * @var Account
     *
     * @ORM\Id
     * @ORM\GeneratedValue(strategy="NONE")
     * @ORM\OneToOne(targetEntity="Account", mappedBy="profile", fetch="EAGER")
     * @ORM\JoinColumns({
     *   @ORM\JoinColumn(name="account_id", referencedColumnName="account_id")
     * })
     */
    private $account;
    
    /**
     * @var string
     * @ORM\Column(name="first_name", type="string", length=127, nullable=false)
     * @Restricted()
     */
    private $firstName;

    /**
     * @var string
     *
     * @ORM\Column(name="last_name", type="string", length=127, nullable=false)
     * @Restricted()
     */
    private $lastName;

Domain:

/**
 * Domain
 *
 * @ORM\Table(name="domain")
 * @ORM\Entity
 */
class Domain
{
    /**
     * @var integer
     *
     * @ORM\Id
     * @ORM\Column(name="id", type="integer", nullable=false)
     */
    protected $id;

    /**
     * @var string
     *
     * @ORM\Column(name="name", type="string", length=255, nullable=false)
     */
    protected $name;
}

Originally created by @Inmmelman on GitHub (Dec 7, 2017). I have 3 entities. And try to load data by native SQL with ResultSetMapping. My question is abount why all times *profile* is null. Code is under text. Please help to resolve this((( I try to join table by addFieldResult and fill columns from this table, but it's doen't has any effects. Domain entity load fine. I thinking this problem can be because account and profile entitites have the same name of relation field and profile **"inversedBy="account""** If I try to use `$rsm->addFieldResult('p', 'first_name', 'firstName', Profile::class);` for load specified field for Profile hydration doesn't work. ObjectHydrator.php in _hydrateRowData_ checks _hydrateRowData_ that must contains _isIdentifier_ fields, in my case _first_name_ it's not identifier and after this check finally set value to null. **Fetching data code** $sql = 'SELECT a.*, p.*, p.account_id as p_account FROM account AS a JOIN profile AS p ON a.account_id = p.account_id WHERE a.domain_id = ? ORDER BY a.account_id DESC LIMIT 0, 25'; $rsm = new ResultSetMapping(); $rsm->addEntityResult(\App\Entity\Account::class, 'account'); $rsm->addJoinedEntityResult(Domain::class, 'd', 'account', 'domain'); $rsm->addJoinedEntityResult(Profile::class, 'p', 'account', 'profile'); $rsm->addFieldResult('account', 'account_id', 'accountId'); $rsm->addFieldResult('account', 'created_date', 'createdDate'); $rsm->addFieldResult('account', 'zendesk_user_id', 'zendeskUserId'); $rsm->addFieldResult('d', 'domain_id', 'id', Domain::class); $query = $this->em->createNativeQuery($sql, $rsm); $query->setParameter(1, 1); $users = $query->getResult(); **Account:** /** * Class Account * @package App\Entity * @ORM\Entity(repositoryClass="App\Entity\Repository\AccountRepository") * @ORM\Table(name="account") */ class Account { /** * @var Domain * @ORM\ManyToOne(targetEntity="Domain") * @ORM\JoinColumns({ * @ORM\JoinColumn(name="domain_id", referencedColumnName="id") * }) */ protected $domain; /** * @var Profile * * @ORM\OneToOne(targetEntity="Profile", inversedBy="account", fetch="LAZY", cascade={"all"}) * @ORM\JoinColumn(name="account_id", referencedColumnName="account_id") */ protected $profile; } **Profile:** /** * Class Profile * @package App\Entity * * @ORM\Entity * @ORM\Table(name="profile") */ class Profile { /** * @var Account * * @ORM\Id * @ORM\GeneratedValue(strategy="NONE") * @ORM\OneToOne(targetEntity="Account", mappedBy="profile", fetch="EAGER") * @ORM\JoinColumns({ * @ORM\JoinColumn(name="account_id", referencedColumnName="account_id") * }) */ private $account; /** * @var string * @ORM\Column(name="first_name", type="string", length=127, nullable=false) * @Restricted() */ private $firstName; /** * @var string * * @ORM\Column(name="last_name", type="string", length=127, nullable=false) * @Restricted() */ private $lastName; **Domain:** /** * Domain * * @ORM\Table(name="domain") * @ORM\Entity */ class Domain { /** * @var integer * * @ORM\Id * @ORM\Column(name="id", type="integer", nullable=false) */ protected $id; /** * @var string * * @ORM\Column(name="name", type="string", length=255, nullable=false) */ protected $name; }

admin added the Bug label 2026-01-22 15:18:15 +01:00

admin commented

2026-01-22 15:18:16 +01:00

@lcobucci commented on GitHub (Dec 19, 2017):

@Inmmelman do you really need to use the native API on that case? I mean, do you have what you need when not using it?

@lcobucci commented on GitHub (Dec 19, 2017): @Inmmelman do you really need to use the native API on that case? I mean, do you have what you need when not using it?

admin commented

2026-01-22 15:18:16 +01:00

@popovserhii commented on GitHub (Dec 11, 2018):

Is there any news about this issue?

@popovserhii commented on GitHub (Dec 11, 2018): Is there any news about this issue?

admin commented

2026-01-22 15:18:16 +01:00

@Halanson commented on GitHub (Dec 19, 2018):

I run into a very similar issue. I ended up with just
$rsm->addRootEntityFromClassMetadata(\App\Entity\Account::class, 'a');

@Halanson commented on GitHub (Dec 19, 2018): I run into a very similar issue. I ended up with just `$rsm->addRootEntityFromClassMetadata(\App\Entity\Account::class, 'a');`

Sign in to join this conversation.

Branches Tags

1 Participants

Notifications

Due Date

No due date set.

Dependencies

No dependencies set.

Reference: doctrine/archived-orm#5797