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..
Bug
Minor
