create table ..select * from table...

MariaDB 10.5.5 single server.

create table t2 engine=columnstore... select * from t1

(regardless if t1 is innodb or columnstore)

is still slow.

100 rows / 80 columns in my tests take 8 minutes.
The same with t2 as innodb take a couple of seconds.

This is linear.

200 rows / 80 columns rows take 16 minutes.

199 row / 40 columns take 4 minutes.

Innodb on the same machine take 4 seconds.

A testcase with testdata is attached (p1.sql)