Comment 2 for bug 1964622

Revision history for this message
Craig Francis (craig.francis) wrote : Re: MariaDB limits to 1000 parameters

I suspect this might be related to `in_predicate_conversion_threshold`?

While I have fixed this elsewhere by using

  foreach (array_chunk($ids, 900) as $chunk_ids) {
  }

I've also been able to use the following as a temporary work around:

  SET in_predicate_conversion_threshold=2000;

I assume this config variable is used to protect against something, so I'm hesitant to apply it globally.