Details
-
Task
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Fixed
-
None
Description
in cases like
CREATE TABLE t1 (a INT, b INT, INDEX (a DESC, b ASC)); |
...
|
SELECT * FROM t1 ORDER BY a DESC, b ASC; |
In other cases descending indexes could be treated as disabled.
Attachments
Issue Links
- is part of
-
MDEV-13756 Implement descending index: KEY (a DESC, b ASC)
-
- Closed
-
- relates to
-
MDEV-26996 Support descending indexes in the range optimizer
-
- Closed
-
ORDER BY seems to be working already:
sql/sql_select.cc
23449
23450
(key_part->key_part_flag & HA_REVERSE_SORT) ?
23451
ORDER::ORDER_DESC : ORDER::ORDER_ASC;
23452
23453
flag= (order->direction == keypart_order) ? 1 : -1;