Doctrine DBAL
  1. Doctrine DBAL
  2. DBAL-858

oracle IN statement with more than 1000 values

    Details

    • Type: Improvement Improvement
    • Status: Open
    • Priority: Minor Minor
    • Resolution: Unresolved
    • Affects Version/s: 2.2.2
    • Fix Version/s: None
    • Component/s: Drivers, Platforms
    • Security Level: All
    • Labels:
      None

      Description

      If I have a query with a IN statement with more tahn 1000 values I get an sql error.

      I've try IN with implode:
      select * from test where id IN(' . implode(',', $values) . ')
      and I've also try with executeQuery:
      select * from test where id IN(:test)
      executeQuery($sql, array($values), array(\Doctrine\DBAL\Connection::PARAM_INT_ARRAY))

        Activity

          People

          • Assignee:
            Benjamin Eberlei
            Reporter:
            Marc Drolet
          • Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

            • Created:
              Updated: