|
After implementation of MDEV-13756 DESC attribute of an index in table definition is discarded/stored conditionally, depending on index type and such. For ARCHIVE tables, it is now stored, even though apparently it is not anyhow supported. Probably it would be better to keep discarding it, to avoid confusion.
|
preview-10.8-MDEV-13756-desc-indexes 383b51d68
|
MariaDB [test]> create or replace table t (t int auto_increment, key (t desc)) engine=Archive;
|
Query OK, 0 rows affected (0.045 sec)
|
|
MariaDB [test]> show create table t;
|
+-------+------------------------------------------------------------------------------------------------------------------------+
|
| Table | Create Table |
|
+-------+------------------------------------------------------------------------------------------------------------------------+
|
| t | CREATE TABLE `t` (
|
`t` int(11) NOT NULL AUTO_INCREMENT,
|
KEY `t` (`t` DESC)
|
) ENGINE=ARCHIVE DEFAULT CHARSET=latin1 |
|
+-------+------------------------------------------------------------------------------------------------------------------------+
|
1 row in set (0.016 sec)
|
|