Bug #50162 Backport: backup_security_var.test fails due to result mismatch in error numbers
Submitted: 7 Jan 2010 21:13 Modified: 25 Feb 2010 1:41
Reporter: Hema Sridharan Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Backup Severity:S3 (Non-critical)
Version: OS:Any
Assigned to: Hema Sridharan CPU Architecture:Any

[7 Jan 2010 21:13] Hema Sridharan
Description:
The test backup_security_var.test fails because of mismatch in error numbers in SHOW ERRORS statement.

How to repeat:
./mysql-test-run.pl --suite=backup backup_security_var.test

backup.backup_security_var               [ fail ]
        Test ended at 2010-01-07 22:03:34

@@ -261,7 +261,7 @@
 ERROR HY000: Insufficient privileges. You must have the RESTORE privilege to restore database 'backup_test_alt'.
 SHOW ERRORS;
 Level  Code    Message
-Error  #       Insufficient privileges. You must have the RESTORE privilege to restore database 'backup_test_alt'.
+Error  1799    Insufficient privileges. You must have the RESTORE privilege to restore database 'backup_test_alt'.

Suggested fix:
Mask the error numbers in SHOW ERRORS statement like,

--replace_column 2 #
SHOW ERRORS;
[7 Jan 2010 21:19] Bugs System
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/96334

3039 Hema Sridharan	2010-01-07
      BUG#50162 Backport: backup_security_var.test fails due to 
      result mismatch in error numbers
      
      This patch will mask the error numbers that is
      shown in SHOW ERRORS statement.
      modified:
        mysql-test/suite/backup/r/backup_security_var.result
        mysql-test/suite/backup/t/backup_security_var.test
[7 Jan 2010 21:34] Chuck Bell
Patch approved.
[7 Jan 2010 23:15] Bugs System
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/96335

3042 Hema Sridharan	2010-01-08
      BUG#50162 
      This patch will mask the errors that are shown 
      in SHOW ERRORS statement
      modified:
        mysql-test/suite/backup/r/backup_security_var.result
        mysql-test/suite/backup/t/backup_security_var.test
[8 Jan 2010 2:17] Bugs System
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/96341

2930 Hema Sridharan	2010-01-08
      Bug#50162 
      This patch masks the errors in SHOW ERRORS statement
      modified:
        mysql-test/suite/backup/r/backup_security_var.result
        mysql-test/suite/backup/t/backup_security_var.test
[20 Feb 2010 9:17] Bugs System
Pushed into 6.0.14-alpha (revid:ingo.struewing@sun.com-20100218152520-s4v1ld76bif06eqn) (version source revid:ingo.struewing@sun.com-20100119103538-wtp5alpz4p2jayl5) (merge vers: 6.0.14-alpha) (pib:16)
[25 Feb 2010 1:41] Paul DuBois
Changes to test case. No changelog entry needed.