-
Improvement
-
Resolution: Fixed
-
Minor
-
3.10, 3.11, 4.0
-
PostgreSQL
-
MOODLE_310_STABLE, MOODLE_311_STABLE, MOODLE_400_STABLE
-
MOODLE_311_STABLE
-
MDL-70055-master -
When querying/deleting records by bulk, we can get errors when the values array becomes too large (i.e. > 65535 parameters for PostgreSQL). This patch adds a solution for Postgres that allows overriding IN statement limit of 16bit (65535 values) by wrapping items in VALUES list. This only takes place in number of items exceeds 65535, otherwise parent class get_in_or_equal() function is used.
- has a clone
-
MDL-69404 Cron task error for large site global forum
-
- Open
-
- has a non-specific relationship to
-
MDL-27071 Oracle cannot cope withan IN operator with more than 1000 conditions in it
-
- Closed
-
- has been marked as being related by
-
MDL-71433 Having trouble performing certain actions with courses with more than 65,000 participants.
-
- Open
-
-
MDL-75160 Really support large number of SQL-IN parameters in Postgres
-
- Open
-
- will help resolve
-
MDL-53735 Split very large SQL-IN parameters to chunks
-
- Closed
-