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

CHECK TABLE should check that foreign key relations are correct

Details

    • New Feature
    • Status: In Testing (View Workflow)
    • Critical
    • Resolution: Unresolved
    • 12.0
    • 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

          causes

          Bug - A problem which impairs or prevents the functions of the product. MDEV-35730 Server crashes in Field::ptr_in_record / handler::check_record_reference

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

          Bug - A problem which impairs or prevents the functions of the product. MDEV-35731 Assertion `(mem_root->flags & 4) == 0' failed upon 2nd execution of CHECK TABLE with FK

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

          Bug - A problem which impairs or prevents the functions of the product. MDEV-35733 ASAN errors in row_mysql_store_col_in_innobase_format / check_key_referential_integrity

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

          Bug - A problem which impairs or prevents the functions of the product. MDEV-35734 ASAN errors in cmp_dtuple_rec_with_match_low / check_key_referential_integrity

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

          Bug - A problem which impairs or prevents the functions of the product. MDEV-35737 MSAN errors in check_table_referential_checks_needed upon LOAD INDEX

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

          Bug - A problem which impairs or prevents the functions of the product. MDEV-35908 Unexpected error, crash, MSAN errors, assertion failures upon CHECK

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

          Bug - A problem which impairs or prevents the functions of the product. MDEV-35936 More ASAN errors in check_key_referential_integrity

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

          Bug - A problem which impairs or prevents the functions of the product. MDEV-35961 Not quite correct error message upon CHECK with FK violation due to wrong engine

          • Trivial - Cosmetic problem like misspelt words or misaligned text.
          • Open

          Bug - A problem which impairs or prevents the functions of the product. MDEV-36643 Assertion failures upon concurrent CHECK and DML on table with FK

          • Critical - Crashes, loss of data, severe memory leak.
          • Open
          is blocked by

          Task - A task that needs to be done. MDEV-36171 Specify requirements for foreign keys

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

          Task - A task that needs to be done. MDEV-16356 Allow ALGORITHM=NOCOPY for ADD CONSTRAINT

          • Major - Major loss of function.
          • Open

          Bug - A problem which impairs or prevents the functions of the product. MDEV-35962 CREATE INDEX fails to heal a FOREIGN KEY constraint

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed
          mentioned in

          Page Loading...

          Activity

            Transition Time In Source Status Execution Times
            Nikita Malyavin made transition -
            Open In Progress
            		67d 4h 19m 1
            Nikita Malyavin made transition -
            In Progress Stalled
            		26d 16h 15m 3
            Nikita Malyavin made transition -
            In Progress In Review
            		7d 2h 21m 1
            Oleksandr Byelkin made transition -
            In Review Stalled
            		2d 13h 22m 1
            Nikita Malyavin made transition -
            Stalled In Progress
            		84d 5h 22m 4
            Nikita Malyavin made transition -
            In Progress In Testing
            		3d 9h 39m 1

            People

              elenst Elena Stepanova
              monty Michael Widenius
              Votes:
              0 Vote for this issue
              Watchers:
              10 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.