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

Document that SHOW CREATE TABLE on InnoDB tables only shows ROW_FORMAT when explicitly set

    XMLWordPrintable

Details

    Description

      Not sure whether this should be bug or task, but ...

      When creating an InnoDB table with explicit ROW_FORMAT the ROW_FORMAT is shown on SHOW CREATE TABLE, when using the implicit default on the other hand this is not shown in SHOW CREATE output.

      Now when using SHOW CREATE output for creating the table on a new server for doing an ALTER...IMPORT there, if ROW_FORMAT was not explicitly set, and the default setting differs between source and target server, the IMPORT will fail.

      This can of course be worked around by adding the correct ROW_FORMAT manually, but it is an odd step to take ...

      Attachments

        Issue Links

          Activity

            People

              GeoffMontee Geoff Montee (Inactive)
              hholzgra Hartmut Holzgraefe
              Votes:
              0 Vote for this issue
              Watchers:
              6 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.