--source have_federatedx.inc

--source include/federated.inc

connection default;

set global federated_pushdown=1;

connection slave;

DROP TABLE IF EXISTS federated.t1;

CREATE TABLE federated.t1 (

  a  int(20) NOT NULL

);

INSERT INTO federated.t1 VALUES (0),(1),(2),(3),(4),(5),(6),(7),(8),(9);

connection master;

DROP TABLE IF EXISTS federated.t1;

--replace_result $SLAVE_MYPORT SLAVE_PORT

eval

CREATE TABLE federated.t1 (

  a int(20) NOT NULL

)

ENGINE="FEDERATED" CONNECTION='mysql://root@127.0.0.1:$SLAVE_MYPORT/federated/t1';

analyze format=json

select * from (select * from federated.t1 where a<3 union 

               select * from federated.t1 where a>=3) T;

set global federated_pushdown=0;

source include/federated_cleanup.inc;

{

  "query_block": {

    "select_id": 1,

    "r_loops": 1,

    "r_total_time_ms": 0.548587957,

    "table": {

      "table_name": "<derived2>",

      "access_type": "ALL",

      "r_loops": 1,

      "rows": 20,

      "r_rows": 0,

      "r_table_time_ms": 1.660416e-4,

      "r_other_time_ms": 0.005957995,

      "filtered": 100,

      "r_filtered": 100,

      "materialized": {

        "query_block": {

          "select_id": 2,

          "table": {

            "message": "Pushed derived"

          }

        }

      }

    }

  }

}