在mysql 8.0.26 执行查询插入语句
```sql
insert into table1
select
id,
sum(bal) as a1,
sum(bal) as a2,
sum(bal) as a3,
....
省略80个
from table2
group by id;
该语句在mysql8.0.28版本执行无问题,算是版本bug.
可以在mysql8.0.26版本添加如下配置解决。
vim /etc/my.cnf
internal_tmp_mem_storage_engine=MEMORY