bzr commit into mysql-6.0-backup branch (cbell:2682) Bug#39017

[Chuck Bell]

#At file:///D:/source/bzr/mysql-6.0-backup/

 2682 Chuck Bell	2008-08-25
      Disabled portion of tests. See BUG#39017 and BUG#39017.
modified:
  mysql-test/r/backup_db_grants.result
  mysql-test/r/backup_default.result
  mysql-test/t/backup_db_grants.test
  mysql-test/t/backup_default.test

=== modified file 'mysql-test/r/backup_db_grants.result'
--- a/mysql-test/r/backup_db_grants.result	2008-08-20 13:23:10 +0000
+++ b/mysql-test/r/backup_db_grants.result	2008-08-25 18:14:40 +0000
@@ -115,11 +115,6 @@ SHOW GRANTS FOR 'bup_user3'@'%';
 ERROR 42000: There is no such grant defined for user 'bup_user3' on host '%'
 SHOW GRANTS FOR 'no_user'@'%';
 ERROR 42000: There is no such grant defined for user 'no_user' on host '%'
-Now demonstrate what happens when grants are altered in backup image.
-Run Restore
-RESTORE FROM 'bup_db_grants.bak';
-ERROR HY000: The grant 'GRANT SELECT ON boo_db_grants.* TO 'bup_user1'@'%' failed. Database not included in the backup image.
-FLUSH PRIVILEGES;
 Cleanup
 DROP USER 'bup_user1'@'%';
 DROP USER 'bup_user1'@'nosuchhost';

=== modified file 'mysql-test/r/backup_default.result'
--- a/mysql-test/r/backup_default.result	2008-08-18 08:25:56 +0000
+++ b/mysql-test/r/backup_default.result	2008-08-25 18:14:40 +0000
@@ -44,15 +44,6 @@ INSERT INTO partition_table VALUES (5,'j
 INSERT INTO partition_table VALUES (20,'UezFi');
 INSERT INTO partition_table VALUES (25,'cxmeH');
 INSERT INTO partition_table VALUES (65,'lIuNS');
-backup on partitioned falcon
-BACKUP DATABASE db1 to 'bup_falcon.bak';
-backup_id
-#
-DROP DATABASE db1;
-restore on partitioned falcon
-RESTORE FROM 'bup_falcon.bak';
-backup_id
-#
 testing content in restored tables
 SELECT * FROM partition_table ORDER BY int_column;
 int_column	char_column

=== modified file 'mysql-test/t/backup_db_grants.test'
--- a/mysql-test/t/backup_db_grants.test	2008-08-21 19:28:49 +0000
+++ b/mysql-test/t/backup_db_grants.test	2008-08-25 18:14:40 +0000
@@ -103,14 +103,17 @@ SHOW GRANTS FOR 'bup_user3'@'%';
 --error ER_NONEXISTING_GRANT
 SHOW GRANTS FOR 'no_user'@'%';
 
---echo Now demonstrate what happens when grants are altered in backup image.
-
---exec perl -pi.bak -e "s/ON bup/ON boo/" $MYSQLTEST_VARDIR/master-data/bup_db_grants.bak 
---echo Run Restore
---error ER_BACKUP_GRANT_WRONG_DB
-RESTORE FROM 'bup_db_grants.bak';
-
-FLUSH PRIVILEGES;
+#
+# Section of test disabled due to errors in PB. See BUG#39016
+#
+#--echo Now demonstrate what happens when grants are altered in backup image.
+#
+#--exec perl -pi.bak -e "s/ON bup/ON boo/" $MYSQLTEST_VARDIR/master-data/bup_db_grants.bak 
+#--echo Run Restore
+#--error ER_BACKUP_GRANT_WRONG_DB
+#RESTORE FROM 'bup_db_grants.bak';
+#
+#FLUSH PRIVILEGES;
 
 --echo Cleanup
 
@@ -127,7 +130,7 @@ FLUSH PRIVILEGES;
 
 --remove_file $MYSQLTEST_VARDIR/master-data/bup_db_grants.bak
 
---remove_file $MYSQLTEST_VARDIR/master-data/bup_db_grants.bak.bak
+#--remove_file $MYSQLTEST_VARDIR/master-data/bup_db_grants.bak.bak
 
 --echo Now test for encoded user names with an x40 in the middle.
 

=== modified file 'mysql-test/t/backup_default.test'
--- a/mysql-test/t/backup_default.test	2008-08-18 08:25:56 +0000
+++ b/mysql-test/t/backup_default.test	2008-08-25 18:14:40 +0000
@@ -62,15 +62,18 @@ INSERT INTO partition_table VALUES (20,'
 INSERT INTO partition_table VALUES (25,'cxmeH');
 INSERT INTO partition_table VALUES (65,'lIuNS');
 
---echo backup on partitioned falcon
---replace_column 1 #
-BACKUP DATABASE db1 to 'bup_falcon.bak';
-
-DROP DATABASE db1;
-
---echo restore on partitioned falcon
---replace_column 1 #
-RESTORE FROM 'bup_falcon.bak';
+#
+# This portion of the test has been disabled. See BUG#39017
+#
+#--echo backup on partitioned falcon
+#--replace_column 1 #
+#BACKUP DATABASE db1 to 'bup_falcon.bak';
+#
+#DROP DATABASE db1;
+#
+#--echo restore on partitioned falcon
+#--replace_column 1 #
+#RESTORE FROM 'bup_falcon.bak';
 
 --echo testing content in restored tables
 SELECT * FROM partition_table ORDER BY int_column;
@@ -125,6 +128,6 @@ SELECT * FROM myisam_table ORDER BY i;
 DROP DATABASE db1;
 
 --remove_file $MYSQLTEST_VARDIR/master-data/bup_csv.bak
---remove_file $MYSQLTEST_VARDIR/master-data/bup_falcon.bak
+#--remove_file $MYSQLTEST_VARDIR/master-data/bup_falcon.bak
 --remove_file $MYSQLTEST_VARDIR/master-data/bup_mixed.bak