Doctrine DBAL
  1. Doctrine DBAL
  2. DBAL-829

binding with PARAM_INT_ARRAY does not convert the values to integer

    Details

    • Type: Bug Bug
    • Status: Resolved
    • Priority: Major Major
    • Resolution: Won't Fix
    • Affects Version/s: None
    • Fix Version/s: 2.3
    • Component/s: None
    • Security Level: All
    • Labels:
      None

      Description

      When using PARAM_INT_ARRAY 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::PARAM_INT_ARRAY)
      );

      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 PARAM_INT_ARRAY, I think this should be taken care of by doctrine

        Activity

        Hide
        Ananda Agrawal added a comment -

        looks like PDO issue

        Show
        Ananda Agrawal added a comment - looks like PDO issue

          People

          • Assignee:
            Benjamin Eberlei
            Reporter:
            Ananda Agrawal
          • Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved: