DBAL-829: binding with PARAM_INT_ARRAY does not convert the values to integer #2063

Closed
doctrinebot opened this Issue Mar 4, 2014 · 2 comments

2 participants

@doctrinebot

Jira issue originally created by user anandagra:

When using PARAMINTARRAY to bind values for 'in' clause
the resulting sql has quotes around the numbers

e.g. using query builder I have

$qb->setParameters(
array('id' => $pnums),
array('id' => Connection::PARAMINTARRAY)
);

produces

"select .... from tableName where id in ('123','456','789')"

given that the array had numeric value as strings,
$ids = array('123','456','789');

but since we are specifying PARAMINTARRAY, I think this should be taken care of by doctrine

@doctrinebot

Comment created by anandagra:

looks like PDO issue

@doctrinebot

Issue was closed with resolution "Won't Fix"

@doctrinebot doctrinebot added the Bug label Dec 7, 2015
@beberlei beberlei was assigned by doctrinebot Dec 7, 2015
@doctrinebot doctrinebot added this to the 2.3 milestone Dec 7, 2015
@doctrinebot doctrinebot closed this Dec 7, 2015
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment