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

Inaccurate documentation for SHOW CREATE statements

    XMLWordPrintable

Details

    Description

      Some KB pages for SHOW CREATE statements seem to me inaccurate:

      https://mariadb.com/kb/en/show-create-table/
      "Shows the CREATE TABLE statement that created the given table"

      This is incorrect, because some details might not match: non-significant characters, comments, quotes, table options...
      It is even less correct if the table was modified after creation (ALTER TABLE).

      The same bug is also in the output of the HELP statements.

      I think that, for each SHOW CREATE statement, the docs should say: "Shows a CREATE $what statement that can be used to recreate the $what".

      Attachments

        Activity

          People

            greenman Ian Gilfillan
            f_razzoli Federico Razzoli
            Votes:
            0 Vote for this issue
            Watchers:
            2 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.