Details
-
Bug
-
Status: Closed (View Workflow)
-
Minor
-
Resolution: Fixed
-
N/A
-
None
Description
preview-10.8-MDEV-13756-desc-indexes 49b38c82a |
MariaDB [test]> create or replace table t (a int, key(a desc)) engine=Memory; |
Query OK, 0 rows affected (0.040 sec) |
|
MariaDB [test]> show create table t; |
+-------+------------------------------------------------------------------------------------------------------------+ |
| Table | Create Table | |
+-------+------------------------------------------------------------------------------------------------------------+ |
| t | CREATE TABLE `t` ( |
`a` int(11) DEFAULT NULL, |
KEY `a` (`a` DESC) |
) ENGINE=MEMORY DEFAULT CHARSET=latin1 | |
+-------+------------------------------------------------------------------------------------------------------------+ |
1 row in set (0.001 sec) |
|
MariaDB [test]> show index in t; |
+-------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+---------+ |
| Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment | Ignored | |
+-------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+---------+ |
| t | 1 | a | 1 | a | NULL | 0 | NULL | NULL | YES | HASH | | | NO | |
+-------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+---------+ |
1 row in set (0.001 sec) |
Attachments
Issue Links
- is caused by
-
MDEV-13756 Implement descending index: KEY (a DESC, b ASC)
- Closed