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

Implement CHECK constraints validation on cascading updates

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

          • Major - Major loss of function.
          • 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

            Ascending order - Click to sort in descending order
            marko Marko Mäkelä added a comment -

            I believe that this could be fixed as a consequence of fixing MDEV-12302.

            marko Marko Mäkelä added a comment - I believe that this could be fixed as a consequence of fixing MDEV-12302 .
            serg Sergei Golubchik added a comment -

            marko, yes, that's exactly what I meant. CHECK constraints, long uniques, unique constraints WITHOUT OVERLAP, system versioning — this will all be possible after MDEV-12302. I suppose InnoDB handles generated columns (stored and indexed virtual) internally already.

            serg Sergei Golubchik added a comment - marko , yes, that's exactly what I meant. CHECK constraints, long uniques, unique constraints WITHOUT OVERLAP, system versioning — this will all be possible after MDEV-12302 . I suppose InnoDB handles generated columns (stored and indexed virtual) internally already.
            monty Michael Widenius added a comment -

            MDEV-12302 was created 6 years ago. We have to re-prioritize this one and fix this.
            This is not hard to do.
            At the same time we should also ensure, it not already done, that all generated stored columns are updated as part of foreign key updates.

            monty Michael Widenius added a comment - MDEV-12302 was created 6 years ago. We have to re-prioritize this one and fix this. This is not hard to do. At the same time we should also ensure, it not already done, that all generated stored columns are updated as part of foreign key updates.

            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.