[MDEV-10393] Foreign keys SET DEFAULT action Created: 2016-07-19  Updated: 2024-01-18

Status: Open
Project: MariaDB Server
Component/s: Data Manipulation - Delete, Data Manipulation - Update, Optimizer, Storage Engine - InnoDB
Fix Version/s: None

Type: Task Priority: Major
Reporter: Federico Razzoli Assignee: Aleksey Midenkov
Resolution: Unresolved Votes: 1
Labels: foreign-keys

Issue Links:
Blocks
is blocked by MDEV-20480 Obsolete internal parser for FK in In... Closed
PartOf
is part of MDEV-22361 Cross-engine foreign keys support Open
Relates
relates to MDEV-16417 Store Foreign Key metadata outside of... In Review
relates to MDEV-12483 Add foreign keys support for partitio... Stalled

 Description   

Now that the DEFAULT clause has been greatly improved (10.2), it would be desirable to be able to used the SET DEFAULT action in foreign keys:
ON DELETE SET DEFAULT
ON UPDATE SET DEFAULT

 Comments   
Comment by Marko Mäkelä [ 2019-03-22 ]

I think that this would be easiest to implement by moving both the FOREIGN KEY metadata storage and processing entirely out of InnoDB.

Generated at Thu Feb 08 07:41:53 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.