-
Bug
-
Resolution: Fixed
-
Major
-
2.6.5, 2.7.2, 2.8
-
Oracle DB
-
Oracle
-
MOODLE_26_STABLE, MOODLE_27_STABLE, MOODLE_28_STABLE
-
MOODLE_26_STABLE, MOODLE_27_STABLE
-
MDL-47227_master -
Easy
-
- Create an M course with the generator tool to have MORE than 1000 users in your platform.
- Go to User Bulk actions
- Select All the users (+1000) and Add as Selected
- No error should appear
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.
- will help resolve
-
MDL-39193 ORA-01795 in Bulk User action when selecting more than 1000 users
-
- Closed
-