Passing an integer array as parameter to doctrine SQL filter failes #5122

New Issue

Open

opened 2026-01-22 14:58:56 +01:00 by admin · 11 comments

admin commented 2026-01-22 14:58:56 +01:00

Owner

Copy Link

Originally created by @Nepoh on GitHub (May 9, 2016).

I tried to pass an array of integers to Doctrine\ORM\Query\Filter\SQLFilter::setParameter with the Doctrine\DBAL\Connection::PARAM_INT_ARRAY parameter type as I did with regular queries many times before to use the parameter in SQL IN() statements.

The documentation says Doctrine\ORM\Query\Filter\SQLFilter::getParameter takes care of parameter quoting:

The function is responsible for the right output escaping to use the value in a query.

but it looks like the parameter type is not handled correctly and an exception is thrown:

Warning: PDO::quote() expects parameter 1 to be string, array given

Is this a bug or why are array parameters not allowed?

---

Some code snippets of what I did: I have a filter class

use Doctrine\ORM\Query\Filter\SQLFilter;
use Doctrine\ORM\Mapping\ClassMetadata;

class UserGroupAwareFilter extends SQLFilter
{
    public function addFilterConstraint(ClassMetadata $targetEntity, $targetTableAlias)
    {
        $this->getParameter('ids')

        // ...
    }
}

and a configurator class to pass some parameters

class UserGroupAwareFilterConfigurator
{
    public function onKernelRequest()
    {
        $ids = // get ids ...

        $this->em->getFilters()->enable('UserGroupAware');
        $filter->setParameter(
            'ids',
            $ids,
            Connection::PARAM_INT_ARRAY
        );
    }
}

Originally created by @Nepoh on GitHub (May 9, 2016). I tried to pass an array of integers to `Doctrine\ORM\Query\Filter\SQLFilter::setParameter` with the `Doctrine\DBAL\Connection::PARAM_INT_ARRAY` parameter type as I did with regular queries many times before to use the parameter in SQL IN() statements. The documentation says `Doctrine\ORM\Query\Filter\SQLFilter::getParameter` takes care of parameter quoting: > The function is responsible for the right output escaping to use the value in a query. but it looks like the parameter type is not handled correctly and an exception is thrown: > Warning: PDO::quote() expects parameter 1 to be string, array given Is this a bug or why are array parameters not allowed? --- Some code snippets of what I did: I have a filter class ``` use Doctrine\ORM\Query\Filter\SQLFilter; use Doctrine\ORM\Mapping\ClassMetadata; class UserGroupAwareFilter extends SQLFilter { public function addFilterConstraint(ClassMetadata $targetEntity, $targetTableAlias) { $this->getParameter('ids') // ... } } ``` and a configurator class to pass some parameters ``` class UserGroupAwareFilterConfigurator { public function onKernelRequest() { $ids = // get ids ... $this->em->getFilters()->enable('UserGroupAware'); $filter->setParameter( 'ids', $ids, Connection::PARAM_INT_ARRAY ); } } ```

admin added the BugMissing Tests labels 2026-01-22 14:58:56 +01:00

admin commented 2026-01-22 14:58:57 +01:00

Author

Owner

Copy Link

@stedekay commented on GitHub (Nov 16, 2016):

Any news on this issue? Also trying to use an array for an IN-statement.

@stedekay commented on GitHub (Nov 16, 2016): Any news on this issue? Also trying to use an array for an IN-statement.

admin commented 2026-01-22 14:58:58 +01:00

Author

Owner

Copy Link

@dimkasta commented on GitHub (Jul 21, 2017):

Any news?
How this should be handled?

Would FIND_IN_SET be a legit solution?

@dimkasta commented on GitHub (Jul 21, 2017): Any news? How this should be handled? Would FIND_IN_SET be a legit solution?

admin commented 2026-01-22 14:58:58 +01:00

Author

Owner

Copy Link

@24HOURSMEDIA commented on GitHub (Oct 9, 2017):

I have problems with this too, I implemented multiple indexed parameters for the use case but that is definitely not scalable. I don't see why a custom filter is not allowed to accept the raw parameter value..

$this->em->getFilters()->enable('CountryFilter');
$filter->setParameter('country0', 'nl');
$filter->setParameter('country1', 'uk');
// (up to 4 countries)

very bad solution.

Another, perhaps better workaround, would be to create a custom method in your filter, and then take care of escaping etc in the filter yourself:

$filter->setCountries(['nl','uk']);

// then, let the filter implementation handle the countries and escaping instead of using the regular parameters
``

@24HOURSMEDIA commented on GitHub (Oct 9, 2017): I have problems with this too, I implemented multiple indexed parameters for the use case but that is definitely not scalable. I don't see why a custom filter is not allowed to accept the raw parameter value.. ``` $this->em->getFilters()->enable('CountryFilter'); $filter->setParameter('country0', 'nl'); $filter->setParameter('country1', 'uk'); // (up to 4 countries) ``` very bad solution. Another, perhaps better workaround, would be to create a custom method in your filter, and then take care of escaping etc in the filter yourself: ``` $filter->setCountries(['nl','uk']); // then, let the filter implementation handle the countries and escaping instead of using the regular parameters ``

admin commented 2026-01-22 14:58:59 +01:00

Author

Owner

Copy Link

@lcobucci commented on GitHub (Oct 9, 2017):

That's kind of weird, what version of the ORM are you using? The last stable version uses the ParameterTypeInferer to use the correct type, which behaves properly with arrays.

Could you please send us a failing test case that reproduces that behaviour? It would help us a lot to identify and fix the issue you're describing.

You can find examples on 388afb46d0/tests/Doctrine/Tests/ORM/Functional/Ticket

@lcobucci commented on GitHub (Oct 9, 2017): That's kind of weird, what version of the ORM are you using? The last stable version uses the [`ParameterTypeInferer` to use the correct type](https://github.com/doctrine/doctrine2/blob/249b737094f1e7cba4f0a8d19acf5be6cf3ed504/lib/Doctrine/ORM/Query/Filter/SQLFilter.php#L75), which behaves [properly with arrays](https://github.com/doctrine/doctrine2/blob/249b737094f1e7cba4f0a8d19acf5be6cf3ed504/lib/Doctrine/ORM/Query/ParameterTypeInferer.php#L60). Could you please send us a failing test case that reproduces that behaviour? It would help us a lot to identify and fix the issue you're describing. You can find examples on https://github.com/doctrine/doctrine2/tree/388afb46d0cb3ed0c51332e8df0de9e942c2690b/tests/Doctrine/Tests/ORM/Functional/Ticket

admin commented 2026-01-22 14:58:59 +01:00

Author

Owner

Copy Link

@24HOURSMEDIA commented on GitHub (Oct 9, 2017):

Hi I don't have too much time but I ran this short test code which illustrates the problem.
Best I could get in the filter was a quoted php serialized object..
(strings are used instead of the integer mentioned in the issue but the error messages are the same)

The context is within Symfony 3.3 framework, library versions are:

doctrine/annotations                 v1.2.7             Docblock Annotations Parser
doctrine/cache                       v1.6.2             Caching library offering an object-oriented API for many cache backends
doctrine/collections                 v1.3.0             Collections Abstraction library
doctrine/common                      v2.6.2             Common Library for Doctrine projects
doctrine/dbal                        v2.5.13            Database Abstraction Layer
doctrine/doctrine-bundle             1.6.8              Symfony DoctrineBundle
doctrine/doctrine-cache-bundle       1.3.0              Symfony Bundle for Doctrine Cache
doctrine/inflector                   v1.1.0             Common String Manipulations with regard to casing and singular/plural rules.
doctrine/instantiator                1.0.5              A small, lightweight utility to instantiate objects in PHP without invoki...
doctrine/lexer                       v1.0.1             Base library for a lexer that can be used in Top-Down, Recursive Descent ...
doctrine/orm                         v2.5.10            Object-Relational-Mapper for PHP

Test code:

<?php
/**
 * Date: 09/10/2017
 */
namespace Doctrine\Tests\ORM\Functional\Ticket;

use Doctrine\DBAL\Connection;
use Doctrine\ORM\Query\Filter\SQLFilter;
use Doctrine\Tests\OrmFunctionalTestCase;
use Doctrine\ORM\Mapping\ClassMetadata;
use Doctrine\Tests\Models\CMS\CmsArticle;


class _ArrayFilter5811 extends SQLFilter {

    public function addFilterConstraint(ClassMetadata $targetEntity, $targetTableAlias)
    {

        if ($this->hasParameter('myarray')) {
            $v = $this->getParameter('myarray');
            if (!is_array($v)) {
                throw new \LogicException('$v is expected to be some array or clause that can be used in an IN conditon.. got ' . $v);
            }
        }
        // return nothing as constraint for the test 
        return '';
    }
}

class GithubIssue5811Test extends OrmFunctionalTestCase
{

    public function setUp()
    {
        $this->useModelSet('cms');
        parent::setUp();
    }

    /**
     * fails: PDO::quote() expects parameter 1 to be string, array given
     */
    public function testIssueVariant1()
    {
        $em = $this->_em;
        /* @var $em \Doctrine\ORM\EntityManagerInterface */
        $em->getConfiguration()->addFilter('arrayfilter', 'Doctrine\Tests\ORM\Functional\Ticket\_ArrayFilter5811');

        $filter = $em->getFilters()->enable("arrayfilter");

        // fails: PDO::quote() expects parameter 1 to be string, array given
        $filter->setParameter('myarray', ['value1', 'value2']);
        $em->getRepository(CmsArticle::class)->findAll();

    }

    /**
     * fails: PDO::quote() expects parameter 1 to be string, array given
     */
    public function testIssueVariant2()
    {
        $em = $this->_em;
        /* @var $em \Doctrine\ORM\EntityManagerInterface */
        $em->getConfiguration()->addFilter('arrayfilter', 'Doctrine\Tests\ORM\Functional\Ticket\_ArrayFilter5811');

        $filter = $em->getFilters()->enable("arrayfilter");


        // fails: PDO::quote() expects parameter 1 to be string, array given
        $filter->setParameter('myarray', ['value1', 'value2'], Connection::PARAM_STR_ARRAY);
        $em->getRepository(CmsArticle::class)->findAll();

    }

    /**
     * No exception but within the filter we end up with a quoted php serialized object
     */
    public function testIssueVariant3()
    {
        $em = $this->_em;
        /* @var $em \Doctrine\ORM\EntityManagerInterface */
        $em->getConfiguration()->addFilter('arrayfilter', 'Doctrine\Tests\ORM\Functional\Ticket\_ArrayFilter5811');

        $filter = $em->getFilters()->enable("arrayfilter");


        // the value passed in the filter is a serialized and quoted php array
        // we just want an array that can be used in an 'in' clause
        $filter->setParameter('myarray', ['value1', 'value2'], 'array');
        $em->getRepository(CmsArticle::class)->findAll();
    }

}

@24HOURSMEDIA commented on GitHub (Oct 9, 2017): Hi I don't have too much time but I ran this short test code which illustrates the problem. Best I could get in the filter was a quoted php serialized object.. (strings are used instead of the integer mentioned in the issue but the error messages are the same) The context is within Symfony 3.3 framework, library versions are: ``` doctrine/annotations v1.2.7 Docblock Annotations Parser doctrine/cache v1.6.2 Caching library offering an object-oriented API for many cache backends doctrine/collections v1.3.0 Collections Abstraction library doctrine/common v2.6.2 Common Library for Doctrine projects doctrine/dbal v2.5.13 Database Abstraction Layer doctrine/doctrine-bundle 1.6.8 Symfony DoctrineBundle doctrine/doctrine-cache-bundle 1.3.0 Symfony Bundle for Doctrine Cache doctrine/inflector v1.1.0 Common String Manipulations with regard to casing and singular/plural rules. doctrine/instantiator 1.0.5 A small, lightweight utility to instantiate objects in PHP without invoki... doctrine/lexer v1.0.1 Base library for a lexer that can be used in Top-Down, Recursive Descent ... doctrine/orm v2.5.10 Object-Relational-Mapper for PHP ``` Test code: ``` <?php /** * Date: 09/10/2017 */ namespace Doctrine\Tests\ORM\Functional\Ticket; use Doctrine\DBAL\Connection; use Doctrine\ORM\Query\Filter\SQLFilter; use Doctrine\Tests\OrmFunctionalTestCase; use Doctrine\ORM\Mapping\ClassMetadata; use Doctrine\Tests\Models\CMS\CmsArticle; class _ArrayFilter5811 extends SQLFilter { public function addFilterConstraint(ClassMetadata $targetEntity, $targetTableAlias) { if ($this->hasParameter('myarray')) { $v = $this->getParameter('myarray'); if (!is_array($v)) { throw new \LogicException('$v is expected to be some array or clause that can be used in an IN conditon.. got ' . $v); } } // return nothing as constraint for the test return ''; } } class GithubIssue5811Test extends OrmFunctionalTestCase { public function setUp() { $this->useModelSet('cms'); parent::setUp(); } /** * fails: PDO::quote() expects parameter 1 to be string, array given */ public function testIssueVariant1() { $em = $this->_em; /* @var $em \Doctrine\ORM\EntityManagerInterface */ $em->getConfiguration()->addFilter('arrayfilter', 'Doctrine\Tests\ORM\Functional\Ticket\_ArrayFilter5811'); $filter = $em->getFilters()->enable("arrayfilter"); // fails: PDO::quote() expects parameter 1 to be string, array given $filter->setParameter('myarray', ['value1', 'value2']); $em->getRepository(CmsArticle::class)->findAll(); } /** * fails: PDO::quote() expects parameter 1 to be string, array given */ public function testIssueVariant2() { $em = $this->_em; /* @var $em \Doctrine\ORM\EntityManagerInterface */ $em->getConfiguration()->addFilter('arrayfilter', 'Doctrine\Tests\ORM\Functional\Ticket\_ArrayFilter5811'); $filter = $em->getFilters()->enable("arrayfilter"); // fails: PDO::quote() expects parameter 1 to be string, array given $filter->setParameter('myarray', ['value1', 'value2'], Connection::PARAM_STR_ARRAY); $em->getRepository(CmsArticle::class)->findAll(); } /** * No exception but within the filter we end up with a quoted php serialized object */ public function testIssueVariant3() { $em = $this->_em; /* @var $em \Doctrine\ORM\EntityManagerInterface */ $em->getConfiguration()->addFilter('arrayfilter', 'Doctrine\Tests\ORM\Functional\Ticket\_ArrayFilter5811'); $filter = $em->getFilters()->enable("arrayfilter"); // the value passed in the filter is a serialized and quoted php array // we just want an array that can be used in an 'in' clause $filter->setParameter('myarray', ['value1', 'value2'], 'array'); $em->getRepository(CmsArticle::class)->findAll(); } }

admin commented 2026-01-22 14:58:59 +01:00

Author

Owner

Copy Link

@spackmat commented on GitHub (Apr 11, 2018):

Any news on that? I can confirm this problem with doctrine/orm 2.6.1 and doctrine/dbal 2.7.0 in a Symfony 4 application. The code calls the PDO quote method, where the value of 101 (from Connection::PARAM_INT_ARRAY) is ignored, PDO has no param type for arrays, at least not as a const with that value.

@spackmat commented on GitHub (Apr 11, 2018): Any news on that? I can confirm this problem with doctrine/orm 2.6.1 and doctrine/dbal 2.7.0 in a Symfony 4 application. The code calls the PDO quote method, where the value of 101 (from Connection::PARAM_INT_ARRAY) is ignored, PDO has no param type for arrays, at least not as a const with that value.

admin commented 2026-01-22 14:58:59 +01:00

Author

Owner

Copy Link

@videni commented on GitHub (Sep 12, 2018):

I also have this problem

@videni commented on GitHub (Sep 12, 2018): I also have this problem

admin commented 2026-01-22 14:59:00 +01:00

Author

Owner

Copy Link

@Ocramius commented on GitHub (Sep 12, 2018):

Send a test, then we can patch it, if applicable.

@Ocramius commented on GitHub (Sep 12, 2018): Send a test, then we can patch it, if applicable.

admin commented 2026-01-22 14:59:00 +01:00

Author

Owner

Copy Link

@guillaumebdx commented on GitHub (Feb 27, 2019):

To figure this out, I have made an implode/explode of my array.

Now, I can set an array in filter setParameter like this

<?php 

namespace Acme\AcmeBundle\Filter;

use Doctrine\Common\Persistence\ObjectManager;
use Doctrine\Common\Annotations\Reader;
use Symfony\Component\DependencyInjection\ContainerInterface;

class Configurator
{


    protected $em;
    protected $reader;
    protected $container;
    
    public function __construct(ObjectManager $em, Reader $reader, ContainerInterface $container)
    {
        $this->em              = $em;
        $this->reader          = $reader;
        $this->container       = $container;
    }
    
    public function onKernelRequest()
    {
        $filter = $this->em->getFilters()->enable('customer_filter');
        $customerIds = implode(",",$this->container->get('acme.manager.session')->getCustomerIds());
        $filter->setParameter('id', $customerIds);
        $filter->setAnnotationReader($this->reader);
    }
    

}

<?php 
namespace Acme\AcmeBundle\Filter;

use Doctrine\ORM\Mapping\ClassMetaData;
use Doctrine\ORM\Query\Filter\SQLFilter;
use Doctrine\Common\Annotations\Reader; 

class CustomerFilter extends SQLFilter
{


    protected $reader; 


    public function addFilterConstraint(ClassMetaData $targetEntity, $targetTableAlias)
    {
        if (empty($this->reader)) {
            return '';
        }
        $customerCheck = $this->reader->getClassAnnotation(
            $targetEntity->getReflectionClass(),
            'Acme\\AcmeBundle\\Annotation\\CustomerCheck'
            );
        if (!$customerCheck) {
            return '';
        }
        $customer = $customerCheck->customer;
        try {
             $customerIds = $this->getParameter('id');
             $customerIds = explode(",", substr($customerIds, 1, -1));
             
        } catch (\InvalidArgumentException $e) {
            return '';
        }
        if (empty($customer)) {
            return '';
        }
        if(count($customerIds) === 1) {
            $query = sprintf('(%s.%s = %s)', $targetTableAlias, $customer, intval($customerIds[0]), $targetTableAlias, $customer);
        } else {
            $query = sprintf('(%s.%s = %s OR', $targetTableAlias, $customer, intval($customerIds[0]), $targetTableAlias, $customer);
            for ($i = 1; $i < count($customerIds); $i++) {
                if($i < count($customerIds) -1) {
                    $query .= sprintf(' %s.%s = %s OR', $targetTableAlias, $customer, intval($customerIds[$i]), $targetTableAlias, $customer);
                } else {
                    $query .= sprintf(' %s.%s = %s)', $targetTableAlias, $customer, intval($customerIds[$i]), $targetTableAlias, $customer);
                }
            }
        }
        return $query;
    }

    public function setAnnotationReader(Reader $reader)
    {
        $this->reader = $reader;
    }


}

Hope this can help somebody

@guillaumebdx commented on GitHub (Feb 27, 2019): To figure this out, I have made an implode/explode of my array. Now, I can set an array in filter setParameter like this ``` <?php namespace Acme\AcmeBundle\Filter; use Doctrine\Common\Persistence\ObjectManager; use Doctrine\Common\Annotations\Reader; use Symfony\Component\DependencyInjection\ContainerInterface; class Configurator { protected $em; protected $reader; protected $container; public function __construct(ObjectManager $em, Reader $reader, ContainerInterface $container) { $this->em = $em; $this->reader = $reader; $this->container = $container; } public function onKernelRequest() { $filter = $this->em->getFilters()->enable('customer_filter'); $customerIds = implode(",",$this->container->get('acme.manager.session')->getCustomerIds()); $filter->setParameter('id', $customerIds); $filter->setAnnotationReader($this->reader); } } ``` ``` <?php namespace Acme\AcmeBundle\Filter; use Doctrine\ORM\Mapping\ClassMetaData; use Doctrine\ORM\Query\Filter\SQLFilter; use Doctrine\Common\Annotations\Reader; class CustomerFilter extends SQLFilter { protected $reader; public function addFilterConstraint(ClassMetaData $targetEntity, $targetTableAlias) { if (empty($this->reader)) { return ''; } $customerCheck = $this->reader->getClassAnnotation( $targetEntity->getReflectionClass(), 'Acme\\AcmeBundle\\Annotation\\CustomerCheck' ); if (!$customerCheck) { return ''; } $customer = $customerCheck->customer; try { $customerIds = $this->getParameter('id'); $customerIds = explode(",", substr($customerIds, 1, -1)); } catch (\InvalidArgumentException $e) { return ''; } if (empty($customer)) { return ''; } if(count($customerIds) === 1) { $query = sprintf('(%s.%s = %s)', $targetTableAlias, $customer, intval($customerIds[0]), $targetTableAlias, $customer); } else { $query = sprintf('(%s.%s = %s OR', $targetTableAlias, $customer, intval($customerIds[0]), $targetTableAlias, $customer); for ($i = 1; $i < count($customerIds); $i++) { if($i < count($customerIds) -1) { $query .= sprintf(' %s.%s = %s OR', $targetTableAlias, $customer, intval($customerIds[$i]), $targetTableAlias, $customer); } else { $query .= sprintf(' %s.%s = %s)', $targetTableAlias, $customer, intval($customerIds[$i]), $targetTableAlias, $customer); } } } return $query; } public function setAnnotationReader(Reader $reader) { $this->reader = $reader; } } ``` Hope this can help somebody

admin commented 2026-01-22 14:59:01 +01:00

Author

Owner

Copy Link

@ghost commented on GitHub (Sep 12, 2019):

<?php
declare(strict_types=1);

namespace App\Filter;

use Doctrine\ORM\Mapping\ClassMetadata;
use Doctrine\ORM\Query\Filter\SQLFilter;
use Doctrine\DBAL\Query\Expression\ExpressionBuilder;
use Prophecy\Exception\InvalidArgumentException;

class CustomFilter extends SQLFilter
{
    public function addFilterConstraint(ClassMetadata $targetEntity, $targetTableAlias)
    {
        if($targetEntity->getReflectionClass()->name !== 'App\Entity\MyEntity')
        {
            return '';
        }

        // unfortunately setParameter('ids', $array, \Doctrine\DBAL\Connection::PARAM_STR_ARRAY) is not supported
        // by PDO driver, use setParameter('ids', $array, \Doctrine\DBAL\Types\Type::SIMPLE_ARRAY) instead
        try
        {
            $ids = explode(',', substr($this->getParameter('ids'), 1, -1));
        }
        catch(\Exception $e)
        {
            throw new InvalidArgumentException('given value for parameter "ids" is invalid, array of strings expected');
        }

        $connection = $this->getConnection();
        $builder = new ExpressionBuilder($connection);
        return $builder->in('id', array_map([$connection, 'quote'], $ids));
    }
}

For

$filter->setParameter('ids', ['foo', 'bar'], \Doctrine\DBAL\Types\Type::SIMPLE_ARRAY);

Expression should result in

id IN ('foo', 'bar')

@ghost commented on GitHub (Sep 12, 2019): ``` <?php declare(strict_types=1); namespace App\Filter; use Doctrine\ORM\Mapping\ClassMetadata; use Doctrine\ORM\Query\Filter\SQLFilter; use Doctrine\DBAL\Query\Expression\ExpressionBuilder; use Prophecy\Exception\InvalidArgumentException; class CustomFilter extends SQLFilter { public function addFilterConstraint(ClassMetadata $targetEntity, $targetTableAlias) { if($targetEntity->getReflectionClass()->name !== 'App\Entity\MyEntity') { return ''; } // unfortunately setParameter('ids', $array, \Doctrine\DBAL\Connection::PARAM_STR_ARRAY) is not supported // by PDO driver, use setParameter('ids', $array, \Doctrine\DBAL\Types\Type::SIMPLE_ARRAY) instead try { $ids = explode(',', substr($this->getParameter('ids'), 1, -1)); } catch(\Exception $e) { throw new InvalidArgumentException('given value for parameter "ids" is invalid, array of strings expected'); } $connection = $this->getConnection(); $builder = new ExpressionBuilder($connection); return $builder->in('id', array_map([$connection, 'quote'], $ids)); } } ``` For ``` $filter->setParameter('ids', ['foo', 'bar'], \Doctrine\DBAL\Types\Type::SIMPLE_ARRAY); ``` Expression should result in ``` id IN ('foo', 'bar') ```

admin commented 2026-01-22 14:59:01 +01:00

Author

Owner

Copy Link

@edigu commented on GitHub (Oct 6, 2019):

I hit the same issue today when implementing a custom filter. For my use case it looks like a weird PDO behavior, reported as bug here in 2009.

Doctrine\ORM\Query\Filter\SQLFilter::getParameter retrieves a \Doctrine\DBAL\Connection instance from EntityManager to quote parameter value through it.

Connection::quote only proxies the parent's interface ():

public function quote($input, $type = ParameterType::STRING)
{
    return parent::quote($input, $type); // parent is PDO here
}

So in my case, the PDO driver was failing, even doctrine properly passes value and type information to underlying layers.

Since MySQL is also happy when parsing such statement on status_id (int) column:

select * from comments where status_id = '2'

I stopped annoying from this.

@edigu commented on GitHub (Oct 6, 2019): I hit the same issue today when implementing a custom filter. For my use case it looks like a weird PDO behavior, reported as bug [here in 2009](https://bugs.php.net/bug.php?id=50206). `Doctrine\ORM\Query\Filter\SQLFilter::getParameter` retrieves a `\Doctrine\DBAL\Connection` instance from `EntityManager` to quote parameter value through it. `Connection::quote` only proxies the parent's interface (): ``` public function quote($input, $type = ParameterType::STRING) { return parent::quote($input, $type); // parent is PDO here } ``` So in my case, the PDO driver was failing, even doctrine properly passes value and type information to underlying layers. Since MySQL is also happy when parsing such statement on `status_id (int)` column: ``` select * from comments where status_id = '2' ``` I stopped annoying from this.

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