Uploaded image for project: 'Moodle'
  1. Moodle
  2. MDL-53735

Split very large SQL-IN parameters to chunks

    XMLWordPrintable

Details

    • Improvement
    • Status: Open
    • Minor
    • Resolution: Unresolved
    • 2.9.5, 3.0.3, 3.1
    • None
    • Database SQL/XMLDB

    Description

      When querying/deleting records by bulk, we can get errors when the values array becomes too large (i.e. > 65535 parameters for PostgreSQL, >1000 for Oracle). Basically, this involves the \moodle_database methods that use where_clause_list(), such as \moodle_database::get_recordset_list(), \moodle_database::get_records_list(), and \moodle_database::delete_records_list().

      We need to split the values array into chunks in order to avoid these errors.

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              jpataleta Jun Pataleta
              David Woloszyn, Huong Nguyen, Jake Dallimore, Michael Hawkins, Stevani Andolo
              Votes:
              4 Vote for this issue
              Watchers:
              13 Start watching this issue

              Dates

                Created:
                Updated: