--source suite/federated/have_federatedx.inc

create table t (a int) engine=MyISAM;

insert into t values (1),(5),(2),(3),(4);

--eval create table tf (a int, key(a desc)) connection 'mysql://root@127.0.0.1:$MASTER_MYPORT/test/t' engine=Federated

select * from tf;

select * from tf where a > 2;

select * from tf where a < 3;

# Cleanup

drop table tf, t;

select * from tf where a > 2;

a

select * from tf where a < 3;

a

drop table tf, t;