Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-30674

Implement CHECK constraints validation on cascading updates

    XMLWordPrintable

Details

    Description

      If a field is a part of a foreign key with a ON UPDATE CASCADE action, it can be updated internally by InnoDB without informing the server and without validating the CHECK constraint. In other words, such cascading updates can invalidate the constraint and that's why they are not supported since MDEV-30606.

      It was stated that It's possible to implement CHECK constraint validation on cascading updates, hence this task to do this in version 11.1+ at least.

      Attachments

        Issue Links

          duplicates

          New Feature - A new feature of the product, which has yet to be developed. MDEV-22880 Honor constraints on UPDATE CASCADE

          • Major - Major loss of function.
          • Open
          is blocked by

          New Feature - A new feature of the product, which has yet to be developed. MDEV-12302 Execute triggers for foreign key updates/deletes

          • Major - Major loss of function.
          • Confirmed
          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-18114 Foreign Key Constraint actions don't affect Virtual Column

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-22602 WITHOUT OVERLAPS constraint is ignored when update is performed via foreign key cascade

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-29181 Potential corruption on Foreign key update on a table with vcol index

          • Critical - Crashes, loss of data, severe memory leak.
          • Stalled

          Bug - A problem which impairs or prevents the functions of the product. MDEV-30606 Foreign key cannot be used in the check constraint

          • Major - Major loss of function.
          • Closed

          Activity

            People

              Unassigned Unassigned
              valerii Valerii Kravchuk
              Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.