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

DB restore fails when CHECK and COMMENT are used

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Duplicate
    • 10.3.9, 10.2.21
    • N/A
    • Parser
    • CentOS 7

    Description

      We have found that MariaDB back-ups fail to restore if they include CHECKs on a column with COMMENTS.

      If we edit the SQL dump file, locate the lines with CHECK and COMMENT, and manually delete the COMMENT, then the restore will work.

      Alternatively, if we edit the DB prior to back-up, deleting comments against columns with CHECKs, and then perform the back-up - the restore completes.

      Attachments

        Issue Links

          duplicates

          Bug - A problem which impairs or prevents the functions of the product. MDEV-17654 Incorrect syntax returned for column with CHECK constraint in the "SHOW CREATE TABLE ..." result

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

          Bug - A problem which impairs or prevents the functions of the product. MDEV-19163 When you have a COMMENT and a CHECK on a column, the SHOW CREATE TABLE creates an invalid query

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

          Activity

            People

              Unassigned Unassigned
              hgl-it HGL IT
              Votes:
              0 Vote for this issue
              Watchers:
              2 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.