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

            Assignee:
            Unassigned Unassigned
            Reporter:
            Hipska Thomas Casteleyn
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

              Created:
              Updated:

                Git Integration