• Tatiana A. Nurnberg's avatar
    Bug#31434 mysqldump dumps view as table · 6e162ea9
    Tatiana A. Nurnberg authored
    mysqldump creates stand-in tables before dumping the actual view.
    Those tables were of the default type; if the view had more columns
    than that (a pathological case, arguably), loading the dump would
    fail. We now make the temporary stand-ins MyISAM tables to prevent
    this.
    
    client/mysqldump.c:
      When creating a stand-in table, specify its type to
      avoid defaulting to a type with a column-number limit
      (like Inno). The type is always MyISAM as we know that
      to be available.
    mysql-test/r/mysqldump.result:
      mysqldump sets engine-type (MyISAM) for stand-in tables
      for views now. Update test results.
    6e162ea9
mysqldump.result 149 KB