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

DB restore fails when CHECK and COMMENT are used

    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: