Details
-
Bug
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Fixed
-
10.2.18, 10.3.7
-
None
Description
The syntax is supported in MariaDB 10.2.1 (https://mariadb.com/kb/en/library/alter-table/#drop-constraint), but it doesn't work for foreign key constraints:
MariaDB [test]> create table tpk(id int primary key, c1 int);
|
Query OK, 0 rows affected (0.646 sec)
|
|
MariaDB [test]> create table tfk(id int primary key, c1 int, constraint `_________fk_transaction_111_11111_1111_111_id` FOREIGN KEY (`c1`) REFERENCES tpk (`id`)
|
ON DELETE NO ACTION ON UPDATE NO ACTION);
|
Query OK, 0 rows affected (0.416 sec)
|
|
MariaDB [test]> show create table tfk\G
|
*************************** 1. row ***************************
|
Table: tfk
|
Create Table: CREATE TABLE `tfk` (
|
`id` int(11) NOT NULL,
|
`c1` int(11) DEFAULT NULL,
|
PRIMARY KEY (`id`),
|
KEY `_________fk_transaction_111_11111_1111_111_id` (`c1`),
|
CONSTRAINT `_________fk_transaction_111_11111_1111_111_id` FOREIGN KEY (`c1`)
|
REFERENCES `tpk` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
|
) ENGINE=InnoDB DEFAULT CHARSET=latin1
|
1 row in set (0.007 sec)
|
|
MariaDB [test]> alter table tfk drop constraint `_________fk_transaction_111_111
|
11_1111_111_id`;
|
ERROR 1091 (42000): Can't DROP CONSTRAINT `_________fk_transaction_111_11111_111
|
1_111_id`; check that it exists
|
MariaDB [test]> alter table tfk drop foreign key `_________fk_transaction_111_11
|
111_1111_111_id`;
|
Query OK, 0 rows affected (0.129 sec)
|
Records: 0 Duplicates: 0 Warnings: 0
|
See also MDEV-14873.
Attachments
Issue Links
- duplicates
-
MDEV-17579 DROP CONSTRAINT implementation is incomplete
- Closed