PS 8.0 PERFORMANCE REGRESSION IN SELECT DISTINCT

Issue: PERFORMANCE REGRESSION IN SELECT DISTINCT ( using temporary) in the 8.0 version.

Steps to reproduce:

Test case  and data ref: https://bugs.mysql.com/bug.php?id=99593

Table count with same data and default configuration PS-5.7.29 vs PS-8.0.19

PS-5.7.29

PS-8.0.19

Workaround:

PS-5.7.29

PS-8.0.19 with SET GLOBAL internal_tmp_mem_storage_engine=MEMORY;