Replication vs temporary table

[Francois Debly]

Do the replication support the creation of temporary table ?
Is there any particular configuration point to focus on ?

For instance:

create temporary table t1(ext int, index(ext)) type=HEAP;
create temporary table t2(ext int, index(ext)) type=HEAP;

insert into t1 select 0+substring(alias, 5) as val from User where (alias like 'CHAT%' and (0+substring(alias, 5) != 0) or alias='CHAT');
insert into t2 select t1.ext+1 from t1;
select t2.ext from t2 left join t1 on (t2.ext=t1.ext) where t1.ext is NULL order by t2.ext limit 1;
drop table t1; drop table t2;


What is executed on the slave side ?




Many thanks in advance,


François.