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

SHOW CREATE TABLE only shows ROW_FORMAT when explicitly set

    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

              • Assignee:
                marko Marko Mäkelä
                Reporter:
                hholzgra Hartmut Holzgraefe
              • Votes:
                0 Vote for this issue
                Watchers:
                4 Start watching this issue

                Dates

                • Created:
                  Updated: