Debian Codegraph @

mysql-test/suite/federated/indexes.test

raw
1 --source include/not_embedded.inc
2 --source suite/federated/have_federatedx.inc
3
4 --echo #
5 --echo # MDEV-27398 DESC index causes wrong (empty) result on Federated tables
6 --echo #
7
8 create table t (a int);
9 insert into t values (1),(5),(2),(3),(4);
10
11 --evalp create table tf (a int, key(a desc)) connection 'mysql://[email protected]:$MASTER_MYPORT/test/t' engine=Federated
12 --sorted_result
13 select * from tf;
14 --sorted_result
15 select * from tf where a > 2;
16 --sorted_result
17 select * from tf where a < 3;
18 --sorted_result
19 select * from tf where a >= 3;
20 --sorted_result
21 select * from tf where a <= 3;
22 drop table tf, t;