MariaDB [test]> create or replace table t1 (i int);

Query OK, 0 rows affected (0,046 sec)

MariaDB [test]> insert into t1 values (1),(2);

Query OK, 2 rows affected (0,014 sec)

Records: 2  Duplicates: 0  Warnings: 0

MariaDB [test]> create table t ENGINE=FEDERATED    CONNECTION="mysql://root@127.0.0.1:3315/test/t1";

Query OK, 0 rows affected (0,025 sec)

MariaDB [test]> set global federated_pushdown=1;

Query OK, 0 rows affected (0,000 sec)

MariaDB [test]> select * from t;

ERROR 1030 (HY000): Got error 10000 "Unknown error 10000" from storage engine FEDERATED

MariaDB [test]> set global federated_pushdown=0;

Query OK, 0 rows affected (0,000 sec)

MariaDB [test]> select * from t;

+------+

| i    |

+------+

|    1 |

|    2 |

+------+

2 rows in set (0,003 sec)

--source have_federatedx.inc

--source include/federated.inc

connection slave;

create table t1(i int);

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

--replace_result $SLAVE_MYPORT SLAVE_PORT

eval

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

set global federated_pushdown=0;

select * from t1_fed;

set global federated_pushdown=1;

select * from t1_fed;

source include/federated_cleanup.inc;