Foreign Key's do not require unique constraint
Bug #664820 reported by
Brian Aker
This bug affects 1 person
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Drizzle |
New
|
Low
|
Unassigned |
Bug Description
From the MySQL manual:
"Additionally, MySQL and InnoDB require that the referenced columns be indexed for performance. However, the system does not enforce a requirement that the referenced columns be UNIQUE or be declared NOT NULL. The handling of foreign key references to nonunique keys or keys that contain NULL values is not well defined for operations such as UPDATE or DELETE CASCADE. You are advised to use foreign keys that reference only UNIQUE and NOT NULL keys."
This is a bug, not a feature, that was never fixed. We should fix it.
Changed in drizzle: | |
importance: | Undecided → Low |
To post a comment you must log in.
I would like to work on this thing..how should i start ?