Crash during optimization for insert or create table with select

create table t1 (f1 int,f2 int, primary key (f1));

insert into t1 values(1,10),(2,20);

create table t2 (f1 int,f3 int, primary key (f1));

insert into t2 values(1,100),(2,200);

create table t3 (f1 int ,f2 int ,f3 int, primary key(f1,f2) );

insert into t3 values (1,10,100),(2,20,200);

create temporary table temp

(

select * from

(select  A.f1

   from  

     ( select f1 , f3   from t3 where  f2 in 

       ( select  t2.f3  from t1  ,t2  

          where  t1.f1 = t2.f1 ) 

       group by f1  ) A  ,

       t3     

 where  t3.f1=A.f1 

 group by A.f1) D

 ) ;