Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Duplicate
-
10.2.29
-
None
-
CentOS release 6.8 (Final)
Mariadb 10.2.29
Description
MariaDB [mydb]> create table emp( name varchar(11), id int(11));
MariaDB [mydb]> ALTER TABLE emp
-> ADD CONSTRAINT websites_unique UNIQUE (id,name);
Query OK, 0 rows affected (0.01 sec)
Records: 0 Duplicates: 0 Warnings: 0
MariaDB [mydb]> desc emp;
-------------------------------------+
Field | Type | Null | Key | Default | Extra |
-------------------------------------+
name | varchar(11) | YES | NULL | ||
id | int(11) | YES | MUL | NULL |
-------------------------------------+
2 rows in set (0.00 sec)
MariaDB [mydb]> alter table emp drop column id;
*ERROR 1072 (42000): Key column 'id' doesn't exist in table
*MariaDB [mydb]>
Attachments
Issue Links
- is duplicated by
-
MDEV-14738 Replication breaks when dropping a column of a combined primary key (with a confusing error message)
- Confirmed
- relates to
-
MDEV-11114 Cannot drop column referenced by CHECK constraint
- Closed
-
MDEV-13613 Dropping column from table that is part of a key fails in 10.2.8
- Closed