Re: File full error in simple select statement

[Peter Brawley]

That status was on a run that elicited the error?

Does innodb_thread_concurrency=0 change error behaviour?

The last script you posted commented out the change of internal_tmp_disk_storage_engine to myisam; what happens when you change that, using GLOBAL?

What is the result of ...

select @@innodb_temp_data_file_path ;

See https://www.percona.com/blog/2019/07/17/mysql-disk-space-exhaustion-for-implicit-temporary-tables/