Details
-
Type:
Bug
-
Status: Closed (View Workflow)
-
Priority:
Major
-
Resolution: Fixed
-
Affects Version/s: N/A
-
Fix Version/s: 10.8.1
-
Component/s: Server, Storage Engine - MyISAM
-
Labels:None
Description
create table t (a int not null, primary key(a desc)) engine=MyISAM; |
create table tm (a int not null auto_increment, primary key(a desc)) engine=MERGE union=(t) insert_method=FIRST; |
|
insert into tm () values (); |
insert into tm () values (); |
insert into tm () values (); |
|
drop table tm, t; |
The third INSERT above fails with
preview-10.8-MDEV-13756-desc-indexes c10e10c6 |
At line 6: query 'insert into tm () values ()' failed: ER_DUP_ENTRY (1062): Duplicate entry '2' for key 'PRIMARY' |
Not reproducible with an ascending key.
Attachments
Issue Links
- is caused by
-
MDEV-13756 Implement descending index: KEY (a DESC, b ASC)
-
- Closed
-