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

Cross-engine foreign keys support

    XMLWordPrintable

Details

    Description

      Implement cross-engine foreign keys check at SQL layer.

      TODO:

      • Referenced/foreign key lookup procedure
      • Recursive table open (new FK structure for TABLE optimized for DML, FKs in TABLE point to parent TABLEs)
      • Recursive prelocking: write-locking for CASCADE actions
      • DML changes:
        UPDATE, Multi-UPDATE
        DELETE, Multi-DELETE
        REPLACE
        INSERT ODKU
        IGNORE clause
        Ignore ‘DELAYED’
      • DDL changes:
        DROP TABLE (DATABASE)

      Attachments

        Issue Links

          includes

          Task - A task that needs to be done. MDEV-10393 Foreign keys SET DEFAULT action

          • Major - Major loss of function.
          • Open

          Task - A task that needs to be done. MDEV-19191 FK support for CURRENT partition of versioned tables

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

          Task - A task that needs to be done. MDEV-16417 Store Foreign Key metadata outside of InnoDB

          • Critical - Crashes, loss of data, severe memory leak.
          • In Review
          relates to

          Task - A task that needs to be done. MDEV-17598 InnoDB index option for per-record transaction ID

          • Major - Major loss of function.
          • Open

          Task - A task that needs to be done. MDEV-20777 Foreign keys without indexes

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Open

          Bug - A problem which impairs or prevents the functions of the product. MDEV-26554 Table-rebuilding DDL on parent table causes crash for INSERT into child table

          • Blocker - Blocks development and/or testing work, production could not run.
          • Closed

          Task - A task that needs to be done. MDEV-12483 Add foreign keys support for partitioned tables

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

          Bug - A problem which impairs or prevents the functions of the product. MDEV-13538 better error reporting when FOREIGN KEY CONSTRAINT fails

          • Major - Major loss of function.
          • Closed

          Task - A task that needs to be done. MDEV-22363 Reimplement the InnoDB virtual column code

          • Major - Major loss of function.
          • Open

          Bug - A problem which impairs or prevents the functions of the product. MDEV-23716 FK validate data but in select join tables parent and child don't search data

          • Major - Major loss of function.
          • Closed

          Task - A task that needs to be done. MDEV-26097 Constraints: support deferred constraints

          • Major - Major loss of function.
          • Open
          links to

          Web Link MySQL Bug#11472 Triggers not executed following foreign key updates/deletes

          Activity

            People

              midenok Aleksey Midenkov
              midenok Aleksey Midenkov
              Votes:
              7 Vote for this issue
              Watchers:
              9 Start watching this issue

              Dates

                Created:
                Updated:

                Git Integration

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