|
--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;
|
|
preview-10.8-MDEV-13756-desc-indexes 383b51d689
|
select * from tf where a > 2;
|
a
|
select * from tf where a < 3;
|
a
|
drop table tf, t;
|
Same for Federated and FederatedX.
With an ascending index the results are correct.
|