• unknown's avatar
    Bug#14871 mysqldump: invalid view dump output · 15c37025
    unknown authored
     - Add comments with embeded veriosn info around the parts of the view syntax that are only supported by a certain version of MySQL Server
    
    
    client/mysqldump.c:
      Use information_schema.views to gather information about the view, then replace some parts of the output from "SHOW CREATE VIEW" with comment markers with version, to make thos parts of the view syntax become parsed only of MySQL servers that supports it.
      Create common function "open_sql_file_for_table" to open the individual .sql file where to dump the table or view.
    mysql-test/r/mysqldump.result:
      Update results
    mysql-test/t/mysqldump.test:
      Add test to see that views can be deumped and reloaded alos when they contain "SECURITY TYPE", "CHECK OPTION" and "DEFINER"
    15c37025
mysqldump.c 105 KB