Debian Codegraph @

mysql-test/suite/federated/indexes.result

raw
1 #
2 # MDEV-27398 DESC index causes wrong (empty) result on Federated tables
3 #
4 create table t (a int);
5 insert into t values (1),(5),(2),(3),(4);
6 create table tf (a int, key(a desc)) connection 'mysql://[email protected]:$MASTER_MYPORT/test/t' engine=Federated;
7 select * from tf;
8 a
9 1
10 2
11 3
12 4
13 5
14 select * from tf where a > 2;
15 a
16 3
17 4
18 5
19 select * from tf where a < 3;
20 a
21 1
22 2
23 select * from tf where a >= 3;
24 a
25 3
26 4
27 5
28 select * from tf where a <= 3;
29 a
30 1
31 2
32 3
33 drop table tf, t;