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