Bug #39655 The mysql_upgrade process does not remove old online_backup tables.

Description:
If a user has installed version 6.0.7 or prior, the mysql_upgrade process does not remove the old backup logging tables.

It should remove:

mysql.online_backup
mysql.online_backup_progress

How to repeat:
Install an earlier version of mysql prior to WL#4296 implementation (6.0.7 or earlier).

Download latest code and compile.

Run mysql_upgrade.

Observe old tables still in the mysql database along with new tables.

Suggested fix:
Add the following to the the mysql_upgrade scripts that process the tables in the mysql database.

DROP TABLE IF EXISTS mysql.online_backup;
DROP TABLE IF EXISTS mysql.online_backup_progress;

Thank you for the report.

Verified as described.

Reviewers assigned.

A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/68150

2783 Chuck Bell	2009-03-03
      BUG#39655 : The mysql_upgrade process does not remove old online_backup tables
      
      This patch adds to the scripts mysql_upgrade uses to
      upgrade the mysql database tables. Specifically, it
      adds the drops to drop the old mysql online backup
      progress tables (online_backup, online_backup_progress).
      added:
        mysql-test/suite/backup/r/backup_mysql_upgrade.result
        mysql-test/suite/backup/t/backup_mysql_upgrade.test
      modified:
        scripts/mysql_system_tables.sql

Patch approved

Good to push.

A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/68433

2788 Chuck Bell	2009-03-05
      BUG#39655 : The mysql_upgrade process does not remove old online_backup tables
      
      This patch adds to the scripts mysql_upgrade uses to
      upgrade the mysql database tables. Specifically, it
      adds the drops to drop the old mysql online backup
      progress tables (online_backup, online_backup_progress).
      added:
        mysql-test/suite/backup/r/backup_mysql_upgrade.result
        mysql-test/suite/backup/t/backup_mysql_upgrade.test
      modified:
        scripts/mysql_system_tables.sql

Pushed into 6.0.11-alpha (revid:alik@sun.com-20090326121822-pt84kzxxayzho4mn) (version source revid:charles.bell@sun.com-20090309134019-vr480npdp30f2gvh) (merge vers: 6.0.11-alpha) (pib:6)

Noted in 6.0.11 changelog.

mysql_upgrade did not remove the online_backup and
online_backup_progress tables from the mysql database. (These are
what the backup_history and backup_progress tables were called
previously.)