Tmp table is full

from the Artful MySQL Tips List

Since 8.0.16, a query that may yield a big result can throw a "temp/#sql ... is full" error. The bug is reported here, which says that till the bug is fixed, a workaround is ...
set session internal_tmp_mem_storage_engine=Memory;
Also see

Last updated 25 Oct 2021

Return to the Artful MySQL Tips page