[MDEV-8033] foreign_key_checks disables ON UPDATE/ON DELETE actions (which are bit beyond a check) Created: 2015-04-22 Updated: 2017-06-01 |
|
| Status: | Open |
| Project: | MariaDB Server |
| Component/s: | Storage Engine - InnoDB, Storage Engine - XtraDB |
| Fix Version/s: | N/A |
| Type: | Task | Priority: | Minor |
| Reporter: | Daniel Black | Assignee: | Unassigned |
| Resolution: | Unresolved | Votes: | 0 |
| Labels: | foreign-keys | ||
| Description |
|
foreign_key_checks despite the description, also disables the ON UPDATE / ON DELETE behaviour. I think the description should be a bit more explicit about this. Also I think there should be a feature enhancement option to do the ON DELETE/UPDATE aspects but don't fail if the references don't exists. |
| Comments |
| Comment by Ian Gilfillan [ 2015-04-22 ] |
|
Which page on the knowledge base are you referring to? |
| Comment by Daniel Black [ 2015-04-22 ] |
|
probably just the vars page |
| Comment by Ian Gilfillan [ 2015-04-28 ] |
|
I have updated the documentation to specify that these clauses are also excluded. |