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

mysqldump bad format when using CHECK and COMMENT

    XMLWordPrintable

Details

    Description

      If the table has a CHECK and a COMMENT and mysqldump is used with this table, then the output will be like:

      ...
      `fieldname2` int(10) unsigned NOT NULL DEFAULT 0 ,
      `fieldname` int(10) unsigned NOT NULL DEFAULT 0 CHECK (`fieldname` <> 0 or `fieldname2` <> 0) COMMENT 'lala',
      ...

      But when trying to import that, this error is shown:

      ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'COMMENT 'lala',

      If the order is changed manually, this is, COMMENT first and then CHECK, it works.

      Attachments

        Issue Links

          Activity

            People

              danblack Daniel Black
              elvena MartĂ­n Alfano
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0d
                  0d
                  Logged:
                  Time Spent - 10m
                  10m

                  Git Integration

                    Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.