--source include/master-slave.inc

connection slave; 

CREATE TABLE t1 (id int);

INSERT INTO t1 VALUES (1),(2),(3);

connection master;

INSTALL SONAME 'ha_federatedx';

set global federated_pushdown=1;

--replace_result $SLAVE_MYPORT SLAVE_PORT

eval CREATE TABLE t1 ENGINE="FEDERATED" CONNECTION="mysql://root@127.0.0.1:$SLAVE_MYPORT/test/t1";

with cte as (select * from t1) select * from cte;