MySQL Bugs: #29348: grant.test and partition

Bug #29348	grant.test and partition_grant.test not compatible
Submitted:	26 Jun 2007 0:08	Modified:	27 Jun 2008 15:56
Reporter:	Timothy Smith	Email Updates:
Status:	Can't repeat	Impact on me:	None
Category:	MySQL Server: Tests	Severity:	S3 (Non-critical)
Version:		OS:	Any
Assigned to:	Matthias Leich	CPU Architecture:	Any
Tags:	pbfail

Description:
grant.test leaves some information in mysql.* tables which shows up when partition_grant.test is run later on in the same server instance.  This causes some extra rows to show up in partition_grant.result, and the test fails.

How to repeat:
./mtr grant partition_grant

Suggested fix:
Have grant.test clean up after itself, revoking privileges or whatever is needed so that it can't affect results for later tests.

grant                          [ pass ]           4807
partition_grant                [ fail ]

Errors are (from /data/localhome/tsmith/bk/51-b29245/mysql-test/var/log/mysqltest-time) :
mysqltest: Result length mismatch
(the last lines may be the most important ones)
Below are the diffs between actual and expected results:
-------------------------------------------------------
*** r/partition_grant.result    Wed Apr  4 12:01:44 2007
--- r/partition_grant.reject    Tue Jun 26 03:10:00 2007
***************
*** 9,15 ****
--- 9,20 ----
  show grants for current_user;
  Grants for mysqltest_1@localhost
  GRANT USAGE ON *.* TO 'mysqltest_1'@'localhost'
+ GRANT SELECT ON `test`.* TO 'mysqltest_1'@'localhost'
+ GRANT ALL PRIVILEGES ON `db27878`.* TO 'mysqltest_1'@'localhost'
  GRANT SELECT, ALTER ON `mysqltest_1`.* TO 'mysqltest_1'@'localhost'
+ GRANT UPDATE (f1) ON `test`.`t1` TO 'mysqltest_1'@'localhost'
+ GRANT EXECUTE ON FUNCTION `mysqltest4`.`f_inv` TO 'mysqltest_1'@'localhost'
+ GRANT EXECUTE ON FUNCTION `mysqltest3`.`f_def` TO 'mysqltest_1'@'localhost'
  alter table t1 add b int;
  alter table t1 drop partition p2;
  ERROR 42000: DROP command denied to user 'mysqltest_1'@'localhost' for table 't1'
-------------------------------------------------------

Thank you for your bug report, but I cannot
repeat the effect any more.

mysql-5.1-bugteam last changeset ~ 2008-06-25
BUILD/compile-pentium-debug-max
#############################################
Logging: ./mtr grant partition_grant
MySQL Version 5.1.27
Using dynamic switching of binlog format
...
Installing Master Database
================================================
TEST                  RESULT      TIME (ms)
-------------------------------------------
main.grant            [ pass ]          178
main.partition_grant  [ pass ]            7
-------------------------------------------
Stopping All Servers
All 2 tests were successful.
The servers were restarted 1 times
Spent 0.185 of 2 seconds executing testcases

Logging: ./mtr --check-testcases grant
MySQL Version 5.1.27
Using dynamic switching of binlog format
....
Installing Master Database
=========================================
TEST                  RESULT    TIME (ms)
-----------------------------------------
main.grant            [ pass ]       133
-----------------------------------------
Stopping All Servers
All 1 tests were successful.
The servers were restarted 1 times
Spent 0.133 of 2 seconds executing testcases