Details
-
Type:
Bug
-
Status: Closed (View Workflow)
-
Priority:
Critical
-
Resolution: Fixed
-
Affects Version/s: N/A
-
Fix Version/s: 10.8.1
-
Component/s: Storage Engine - Federated
-
Labels:None
Description
--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.
Attachments
Issue Links
- is caused by
-
MDEV-13756 Implement descending index: KEY (a DESC, b ASC)
-
- Closed
-