• Tatiana A. Nurnberg's avatar
    Bug#31434 mysqldump dumps view as table · d49ee193
    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-max.result:
      add test results for 31434
    mysql-test/r/mysqldump.result:
      mysqldump sets engine-type (MyISAM) for stand-in tables
      for views now. Update test results.
    mysql-test/t/mysqldump-max.test:
      Show that mysqldump's stand-in tables for views explicitly
      set engine-type to MyISAM to avoid falling back on an engine
      that might support fewer columns than the final view requires
      (here's lookin' at you, inno). Also show that this actually
      has the desired effect by dumping and reloading a view that
      has more columns than inno supports.
    d49ee193
mysqldump.c 155 KB