Re: [Maria-developers] 43296f4: MDEV-17599 ALTER TABLE DROP CONSTRAINT does not work for foreign keys.

31 Jan
2019
31 Jan
'19
7:49 p.m.
Hi, Alexey! On Jan 31, Alexey Botchkov wrote:
Let's handle it separately. Could you please report it as a bug? A table shouldn't have two constraints with the same name.
By dropping the unique key, why, is there another option? UNIQUE index is a constraint, not just an optimization helper, like a non-unique index. You already have a loop over all drop constraints, checking for unique shouldn't be a problem. It should drop PRIMARY KEY too, I suppose. We allow ADD CONSTRAINT PRIMARY KEY. Regards, Sergei Chief Architect MariaDB and security@mariadb.org
2253
Age (days ago)
2253
Last active (days ago)
0 comments
1 participants
participants (1)
-
Sergei Golubchik