Re: File full error in simple select statement

[Derek McKinnon]

Hi Peter

Thank you for your investigation.

It now works with the setting
SET SESSION internal_tmp_mem_storage_engine=MEMORY;

The OR join is a problem. It is only taking 30 seconds to run on my machine (8 minutes for a much bigger database), but as I move this into a longer term environment I will have to consider an intermediate step to improve the performance.

Thank you very much for your time. It is greatly appreciated.

Cheers
Derek