• unknown's avatar
    Fixed bug #28524. · 2bfe84d4
    unknown authored
    For each view the mysqldump utility creates a temporary table
    with the same name and the same columns as the view 
    in order to satisfy views that depend on this view.
    After the creation of all tables, mysqldump drops all
    temporary tables and creates actual views.
    However, --skip-add-drop-table and --compact flags disable
    DROP TABLE statements for those temporary tables. Thus, it was
    impossible to create the views because of existence of the
    temporary tables with the same names.
    
    
    client/mysqldump.c:
      Fixed bug #28524.
      The mysqldump utility has been modified to unconditionally drop
      temporary tables before the creation of views.
    mysql-test/t/mysqldump.test:
      Updated test case for bug #28524 and updated result of previous tests.
    mysql-test/r/mysqldump.result:
      Updated test case for bug #28524 and updated result of previous tests.
    2bfe84d4
mysqldump.result 141 KB