Details
-
Bug
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Fixed
-
N/A
-
None
Description
--source include/have_innodb.inc
|
|
|
create or replace table t (pk int primary key, i int, key idx(i)) engine=InnoDB; |
show create table t; |
alter table t drop key idx, add key idx(i desc); |
show create table t; |
|
|
# This works:
|
alter table t drop key idx; |
alter table t add key idx(i desc); |
show create table t; |
|
|
# Cleanup
|
drop table t; |
|
preview-10.8-MDEV-13756-desc-indexes 383b51d68 |
alter table t drop key idx, add key idx(i desc); |
show create table t; |
Table Create Table |
t CREATE TABLE `t` ( |
`pk` int(11) NOT NULL, |
`i` int(11) DEFAULT NULL, |
PRIMARY KEY (`pk`), |
KEY `idx` (`i`) |
) ENGINE=InnoDB DEFAULT CHARSET=latin1 |
Not reproducible with MyISAM, Aria.
When the two ALTERs are executed separately, it works:
alter table t drop key idx; |
alter table t add key idx(i desc); |
show create table t; |
Table Create Table |
t CREATE TABLE `t` ( |
`pk` int(11) NOT NULL, |
`i` int(11) DEFAULT NULL, |
PRIMARY KEY (`pk`), |
KEY `idx` (`i` DESC) |
) ENGINE=InnoDB DEFAULT CHARSET=latin1 |
Attachments
Issue Links
- is caused by
-
MDEV-13756 Implement descending index: KEY (a DESC, b ASC)
-
- Closed
-
Activity
Right, it was fixed by
commit 353c608db9663edc9e557270bae227c8fd25a7e7
|
Author: Thirunarayanan Balathandayuthapani
|
Date: Fri Jan 7 19:25:12 2022 +0530
|
|
|
MDEV-27432 ASC/DESC primary and unique keys cause index inconsistency between InnoDB and server
|
This is a bit disturbing because it was earlier said to be unrelated.
cannot repeat on c13c1079b7d, likely fixed by commit for
MDEV-27432