[MDEV-22880] Honor constraints on UPDATE CASCADE Created: 2020-06-12  Updated: 2023-12-30

Status: Open
Project: MariaDB Server
Component/s: None
Fix Version/s: None

Type: New Feature Priority: Major
Reporter: Aleksey Midenkov Assignee: Aleksey Midenkov
Resolution: Unresolved Votes: 0
Labels: None

Issue Links:
Blocks
is blocked by MDEV-22361 Cross-engine foreign keys support Open
is blocked by MDEV-29181 Potential corruption on Foreign key u... In Review
Duplicate
is duplicated by MDEV-30606 Foreign key cannot be used in the che... Closed
is duplicated by MDEV-30674 Implement CHECK constraints validatio... Closed
Relates
relates to MDEV-22602 WITHOUT OVERLAPS constraint is ignore... Closed

 Description   

This will fix

  • CHECK constraints
  • UNIQUE constraints WITHOUT OVERLAP
  • UNIQUE constraints that are USING HASH (a.k.a. "long unique")

Existing cases for WITHOUT OVERLAPS, CHECK are in MDEV-22602 (762bf7a03b6214f091a66ca8683df341112d7d4a) as well as disabled long-uniques (see test case of commit).

UPDATE must abort if the constraints fail. Long uniques must be rehashed and updated.
Generated at Thu Feb 08 09:18:10 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.