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

mysqldump creates temporary MyISAM table for each VIEW

    XMLWordPrintable

Details

    Description

      The mysqldump tool included with MariaDB client generates SQL for creating a temporary table with the MyISAM engine.

      client/mysqldump.c#L3283-L3292

                /*
                  Stand-in tables are always MyISAM tables as the default
                  engine might have a column-limit that's lower than the
                  number of columns in the view, and MyISAM support is
                  guaranteed to be in the server anyway.
                */
                fprintf(sql_file,
                        "\n) ENGINE=MyISAM */;\n"
                        "SET character_set_client = @saved_cs_client;\n");
      

      Github

      This is problematic when trying to import this into Azure MariaDB service, since that doesn't support MyISAM.

      I have seen that MySQL's mysqldump produces temporary VIEWs with SELECT 1 AS fieldname, that might be a better option to consider as well..

      Attachments

        Activity

          People

            danblack Daniel Black
            Hipska Thomas Casteleyn
            Votes:
            0 Vote for this issue
            Watchers:
            4 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.