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

User bulk selection results in Orable database errors when more than 1000 users are selected

    XMLWordPrintable

    Details

    • Database:
      Oracle
    • Testing Instructions:
      1. Create an M course with the generator tool to have MORE than 1000 users in your platform.
      2. Go to User Bulk actions
      3. Select All the users (+1000) and Add as Selected
      4. No error should appear
    • Difficulty:
      Easy
    • Affected Branches:
      MOODLE_26_STABLE, MOODLE_27_STABLE, MOODLE_28_STABLE
    • Fixed Branches:
      MOODLE_26_STABLE, MOODLE_27_STABLE
    • Pull Master Branch:
      MDL-47227_master

      Description

      In User Bulk actions, when more than 1000 users are marked as selected, a dmlreadexception occurs:

      ORA-01795: maximum number of expressions in a list is 1000
      SELECT id, MOODLELIB.UNDO_MEGA_HACK(MOODLELIB.TRICONCAT(firstname, '*OCISP*', lastname)) AS fullname FROM m2user WHERE id IN (21,.......,1752) ORDER BY fullname
      [array (
      )]
      

      This is caused by the function get_selection_data because it uses directly an IN sentence without using get_in_or_equal function from the DML library.

        Attachments

          Issue Links

            Activity

              People

              • Votes:
                0 Vote for this issue
                Watchers:
                5 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:
                  Fix Release Date:
                  10/Nov/14