Bug #91049 | deleting duplicate complains about foreign key | ||
---|---|---|---|
Submitted: | 28 May 2018 17:38 | Modified: | 6 Jun 2018 17:34 |
Reporter: | Don Cohen | Email Updates: | |
Status: | Not a Bug | Impact on me: | |
Category: | MySQL Server | Severity: | S3 (Non-critical) |
Version: | 5.5.38 | OS: | Any |
Assigned to: | MySQL Verification Team | CPU Architecture: | Any |
[28 May 2018 17:38]
Don Cohen
[6 Jun 2018 17:34]
MySQL Verification Team
Hi, I disagree this is a bug. Standard is a bit sketchy here but this is how we implemented it. In most RDBMS you would not be able to create a reference to a column that's not unique (that could be considered a bug in mysql that it allow you to reference a non-unique column) so the way it's implemented now you have this behavior. Thanks for your report Bogdan
[6 Jun 2018 17:48]
MySQL Verification Team
Just a quick update, I did send this to my dev/standard colleagues for review as they might add something to my notes. kind regards Bogdan
[8 Jun 2018 14:02]
MySQL Verification Team
Update Feature request created from this bug report https://bugs.mysql.com/bug.php?id=91186 Thanks Bogdan