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

CHECK TABLE should check that foreign key relations are correct

    XMLWordPrintable

Details

    • New Feature
    • Status: In Testing (View Workflow)
    • Critical
    • Resolution: Unresolved
    • 11.8
    • None
    • None

    Description

      Currently there is no easy way for a user to check if a database is consistent.
      One can check individual tables with CHECK TABLE but there is now to check that
      all foreign key tables has all the required keys and that the original table has all the rows
      expected by the foreign key table.

      We should extended CHECK TABLE .. EXTENDED or alternative CHECK TABLE ... REFERENCES to check that all foreign key relations are consistent.

      This should preferably be done on the upper, sql, level and not in InnoDB.

      Attachments

        Issue Links

          Activity

            People

              elenst Elena Stepanova
              monty Michael Widenius
              Votes:
              0 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.