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

        Marc Drolet created issue -
        Steve Müller made changes -
        Field Original Value New Value
        Project Doctrine 2 - ORM [ 10032 ] Doctrine DBAL [ 10040 ]
        Key DDC-2237 DBAL-858
        Issue Type Bug [ 1 ] Improvement [ 4 ]
        Affects Version/s 2.2.2 [ 10197 ]
        Affects Version/s 2.2.2 [ 10195 ]
        Component/s Drivers [ 10055 ]
        Component/s Platforms [ 10056 ]
        Component/s ORM [ 10012 ]
        Steve Müller made changes -
        Priority Critical [ 2 ] Minor [ 4 ]

          People

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

            Dates

            • Created:
              Updated: