Why won't createNativeQuery return records containing null value? #5407

New Issue

Closed

opened 2026-01-22 15:06:54 +01:00 by admin · 15 comments

admin commented 2026-01-22 15:06:54 +01:00

Owner

Copy Link

Originally created by @dipens on GitHub (Feb 3, 2017).

I have two identical Symfony 2.8 projects. The only difference in these two projects is that one is running Doctrine ORM version v2.4.8 and the other is running v2.5.5

The problem

I have this following piece of code in both Symfony projects.

$rsm = new ResultSetMapping();
$rsm->addEntityResult('EntityBundle:New', 'u');
$rsm->addFieldResult('u', 'newPK', 'newPK');
$rsm->addFieldResult('u', 'msg', 'msg');
$query = $em->createNativeQuery('StoredProcedureName @a= :a, @b= :b, @c= :c', $rsm);
$query->setParameter('a', 'a');
$query->setParameter('b', 'b');
$query->setParameter('c', 'c');
$result = $query->getArrayResult();
var_dump($result);

My Entity looks like this:

use Doctrine\ORM\Mapping as ORM;

/**
 * New
 *
 * @ORM\Table(name="dbo.New")
 * @ORM\Entity()
 */
class New
{
    /**
     * @var string
     *
     * @ORM\Column(name="newPK", type="string", length=255, unique=false)
     */
    private $newPK;
    /**
     * @var string
     *
     * @ORM\Column(name="msg", type="string", length=255, unique=false)
     */
    private $msg;
    /**
     * @return string
     */
    public function getNewPK()
    {
        return $this->newPK;
    }

    /**
     * @param string $newPK
     */
    public function setNewPK($newPK)
    {
        $this->newPK = $newPK;
    }
    /**
     * @return string
     */
    public function getMsg()
    {
        return $this->msg;
    }

    /**
     * @param string $msg
     */
    public function setMsg($msg)
    {
        $this->msg = $msg;
    }
}

In my StoredProcedure all I have is this:

CREATE PROCEDURE [dbo].[StoredProcedureName] 
AS
SELECT null as newPK, 'aaa' As msg
GO

This code works perfectly fine on version v2.4.8 returning me null value perfectly. However this doesn't work on v2.5.5. All it returns is an array with NULL inside it and not the newPK AND msg value. If I remove the null and replace it with an empty string or anything else for that matter, it works. But for some god forsaken reason, it does not like the NULL value. All I want is to check if null is returned or not but I can't seem to check without doctrine returning me proper values.

Is there anything that changed between these versions that I am not aware of? What do I need to do in order to read NULL values from a native query?

Originally created by @dipens on GitHub (Feb 3, 2017). I have two identical Symfony 2.8 projects. The only difference in these two projects is that one is running Doctrine ORM version `v2.4.8` and the other is running `v2.5.5` **The problem** I have this following piece of code in both Symfony projects. $rsm = new ResultSetMapping(); $rsm->addEntityResult('EntityBundle:New', 'u'); $rsm->addFieldResult('u', 'newPK', 'newPK'); $rsm->addFieldResult('u', 'msg', 'msg'); $query = $em->createNativeQuery('StoredProcedureName @a= :a, @b= :b, @c= :c', $rsm); $query->setParameter('a', 'a'); $query->setParameter('b', 'b'); $query->setParameter('c', 'c'); $result = $query->getArrayResult(); var_dump($result); My Entity looks like this: use Doctrine\ORM\Mapping as ORM; /** * New * * @ORM\Table(name="dbo.New") * @ORM\Entity() */ class New { /** * @var string * * @ORM\Column(name="newPK", type="string", length=255, unique=false) */ private $newPK; /** * @var string * * @ORM\Column(name="msg", type="string", length=255, unique=false) */ private $msg; /** * @return string */ public function getNewPK() { return $this->newPK; } /** * @param string $newPK */ public function setNewPK($newPK) { $this->newPK = $newPK; } /** * @return string */ public function getMsg() { return $this->msg; } /** * @param string $msg */ public function setMsg($msg) { $this->msg = $msg; } } In my StoredProcedure all I have is this: CREATE PROCEDURE [dbo].[StoredProcedureName] AS SELECT null as newPK, 'aaa' As msg GO This code works perfectly fine on version `v2.4.8` returning me null value perfectly. However this doesn't work on `v2.5.5`. All it returns is an array with NULL inside it and not the `newPK` AND `msg` value. If I remove the null and replace it with an empty string or anything else for that matter, it works. But for some god forsaken reason, it does not like the `NULL` value. All I want is to check if null is returned or not but I can't seem to check without doctrine returning me proper values. Is there anything that changed between these versions that I am not aware of? What do I need to do in order to read `NULL` values from a native query?

admin added the BugMissing Tests labels 2026-01-22 15:06:54 +01:00

admin closed this issue 2026-01-22 15:06:55 +01:00

admin commented 2026-01-22 15:06:56 +01:00

Author

Owner

Copy Link

@Ocramius commented on GitHub (Feb 3, 2017):

@dipens are the DBAL versions also different?

@Ocramius commented on GitHub (Feb 3, 2017): @dipens are the DBAL versions also different?

admin commented 2026-01-22 15:06:56 +01:00

Author

Owner

Copy Link

@dipens commented on GitHub (Feb 3, 2017):

@Ocramius Yes sorry should have mentioned that. The one with v2.4.8 has v2.5.4 installed. The one with v2.5.5 has v2.5.5 installed.

@dipens commented on GitHub (Feb 3, 2017): @Ocramius Yes sorry should have mentioned that. The one with `v2.4.8` has `v2.5.4` installed. The one with `v2.5.5` has `v2.5.5` installed.

admin commented 2026-01-22 15:06:57 +01:00

Author

Owner

Copy Link

@Ocramius commented on GitHub (Feb 4, 2017):

@dipens did you try running this with DBAL only? Did the results change? What DB/adapter are you using?

@Ocramius commented on GitHub (Feb 4, 2017): @dipens did you try running this with DBAL only? Did the results change? What DB/adapter are you using?

admin commented 2026-01-22 15:06:57 +01:00

Author

Owner

Copy Link

@dipens commented on GitHub (Feb 7, 2017):

@Ocramius With DBAL I am getting the results. I am using freeTDS on Ubuntu 14.04.

@dipens commented on GitHub (Feb 7, 2017): @Ocramius With DBAL I am getting the results. I am using freeTDS on Ubuntu 14.04.

admin commented 2026-01-22 15:06:57 +01:00

Author

Owner

Copy Link

@Ocramius commented on GitHub (Feb 7, 2017):

Ping @deeky665 could our changes in prepared statements in 2.5 affect this?

@Ocramius commented on GitHub (Feb 7, 2017): Ping @deeky665 could our changes in prepared statements in 2.5 affect this?

admin commented 2026-01-22 15:07:00 +01:00

Author

Owner

Copy Link

@deeky666 commented on GitHub (Feb 7, 2017):

@Ocramius the prepared statement stuff was released with 2.5.11, not 2.5.5. We'll have to take a look at the differences between DBAL 2.5.4 and 2.5.5 if I understand correctly.

@deeky666 commented on GitHub (Feb 7, 2017): @Ocramius the prepared statement stuff was released with `2.5.11`, not `2.5.5`. We'll have to take a look at the differences between DBAL `2.5.4` and `2.5.5` if I understand correctly.

admin commented 2026-01-22 15:07:00 +01:00

Author

Owner

Copy Link

@Ocramius commented on GitHub (Feb 7, 2017):

@dipens can you try adding a test case meanwhile?

@Ocramius commented on GitHub (Feb 7, 2017): @dipens can you try adding a test case meanwhile?

admin commented 2026-01-22 15:07:00 +01:00

Author

Owner

Copy Link

@dipens commented on GitHub (Feb 9, 2017):

@Ocramius Sorry how do I do that?

@dipens commented on GitHub (Feb 9, 2017): @Ocramius Sorry how do I do that?

admin commented 2026-01-22 15:07:00 +01:00

Author

Owner

Copy Link

@Ocramius commented on GitHub (Feb 9, 2017):

See https://github.com/doctrine/doctrine2/tree/master/tests/Doctrine/Tests/ORM/Functional/Ticket for examples

@Ocramius commented on GitHub (Feb 9, 2017): See https://github.com/doctrine/doctrine2/tree/master/tests/Doctrine/Tests/ORM/Functional/Ticket for examples

admin commented 2026-01-22 15:07:00 +01:00

Author

Owner

Copy Link

@dipens commented on GitHub (Aug 17, 2017):

I did a work around with this one using addScalarResult instead of addFieldResult. The modified code looks like this:

$rsm = new ResultSetMapping();
$rsm->addScalarResult( 'newPK', 'newPK');
$rsm->addScalarResult( 'msg', 'msg');
$query = $em->createNativeQuery('StoredProcedureName @a= :a, @b= :b, @c= :c', $rsm);
$query->setParameter('a', 'a');
$query->setParameter('b', 'b');
$query->setParameter('c', 'c');
$result = $query->getArrayResult();
var_dump($result);

@dipens commented on GitHub (Aug 17, 2017): I did a work around with this one using `addScalarResult` instead of `addFieldResult`. The modified code looks like this: $rsm = new ResultSetMapping(); $rsm->addScalarResult( 'newPK', 'newPK'); $rsm->addScalarResult( 'msg', 'msg'); $query = $em->createNativeQuery('StoredProcedureName @a= :a, @b= :b, @c= :c', $rsm); $query->setParameter('a', 'a'); $query->setParameter('b', 'b'); $query->setParameter('c', 'c'); $result = $query->getArrayResult(); var_dump($result);

admin commented 2026-01-22 15:07:00 +01:00

Author

Owner

Copy Link

@Ocramius commented on GitHub (Aug 17, 2017):

What is the resolution here?

@Ocramius commented on GitHub (Aug 17, 2017): What is the resolution here?

admin commented 2026-01-22 15:07:00 +01:00

Author

Owner

Copy Link

@dipens commented on GitHub (Aug 18, 2017):

I just edited my close comment. Please have a look

@dipens commented on GitHub (Aug 18, 2017): I just edited my close comment. Please have a look

admin commented 2026-01-22 15:07:02 +01:00

Author

Owner

Copy Link

@Ocramius commented on GitHub (Aug 18, 2017):

@dipens that still doesn't say much to me - is this therefore a bug? Can it be reproduced?

@Ocramius commented on GitHub (Aug 18, 2017): @dipens that still doesn't say much to me - is this therefore a bug? Can it be reproduced?

admin commented 2026-01-22 15:07:02 +01:00

Author

Owner

Copy Link

@potievdev commented on GitHub (Dec 12, 2017):

@Ocramius After upgrading from 2.4 to 2.5 I have the same problem. Late I can send example how reproduce this bug.

@potievdev commented on GitHub (Dec 12, 2017): @Ocramius After upgrading from 2.4 to 2.5 I have the same problem. Late I can send example how reproduce this bug.

admin commented 2026-01-22 15:07:02 +01:00

Author

Owner

Copy Link

@piedrucci commented on GitHub (Dec 25, 2019):

@dipens this one

I did a work around with this one using addScalarResult instead of addFieldResult. The modified code looks like this:

$rsm = new ResultSetMapping();
$rsm->addScalarResult( 'newPK', 'newPK');
$rsm->addScalarResult( 'msg', 'msg');
$query = $em->createNativeQuery('StoredProcedureName @a= :a, @b= :b, @c= :c', $rsm);
$query->setParameter('a', 'a');
$query->setParameter('b', 'b');
$query->setParameter('c', 'c');
$result = $query->getArrayResult();
var_dump($result);

this one work for me!! thankful....

@piedrucci commented on GitHub (Dec 25, 2019): @dipens this one > I did a work around with this one using `addScalarResult` instead of `addFieldResult`. The modified code looks like this: > > ``` > $rsm = new ResultSetMapping(); > $rsm->addScalarResult( 'newPK', 'newPK'); > $rsm->addScalarResult( 'msg', 'msg'); > $query = $em->createNativeQuery('StoredProcedureName @a= :a, @b= :b, @c= :c', $rsm); > $query->setParameter('a', 'a'); > $query->setParameter('b', 'b'); > $query->setParameter('c', 'c'); > $result = $query->getArrayResult(); > var_dump($result); > ``` this one work for me!! thankful....

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 Bug Missing Tests

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