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

DB restore fails when CHECK and COMMENT are used

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Duplicate
    • Affects Version/s: 10.3.9, 10.2.21
    • Fix Version/s: N/A
    • Component/s: Parser
    • Labels:
    • Environment:
      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

            Activity

              People

              Assignee:
              Unassigned
              Reporter:
              hgl-it HGL IT
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: