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

Store foreign keys, even not supported

    XMLWordPrintable

Details

    • New Feature
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Duplicate
    • N/A
    • Server
    • None

    Description

      At the moment foreign key constraints are only stored, if the table engine supports foreign keys.
      E.g. for Aria or MyISAM you can define them, they are not respected nor stored.

      If at least the information is stored, applications could use this information to visualize dependend tables or to manually check some constraints by querying the "Information Schema" before/after delete.

      This could help making the database more consistent while Aria does not support transaction (and maybe never will). An offline job could also be used to check for consistency breaks.

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              mokraemer Marc
              Votes:
              0 Vote for this issue
              Watchers:
              3 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.