Problem: Internal caching of temporary results depends on the buffer size
determined by the variable read_rnd_buffer_size. If this value is too small,
we fail to execute the query.

Fix: Ignore the error if we cannot cache intermediate results,
and read directly from the temporary file.