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

          Activity

            People

              midenok Aleksey Midenkov
              midenok Aleksey Midenkov
              Votes:
              9 Vote for this issue
              Watchers:
              11 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.