1 files changed, 16 insertions, 0 deletions
diff --git a/mysql-test/r/partition_grant.result b/mysql-test/r/partition_grant.result
index f036b0bcc28..cd8f8a970d0 100644
--- a/mysql-test/r/partition_grant.result
+++ b/mysql-test/r/partition_grant.result
@@ -7,6 +7,7 @@ create user mysqltest_1@localhost;
 grant usage on *.* to mysqltest_1@localhost;
 revoke all privileges on *.* from mysqltest_1@localhost;
 grant select,alter on mysqltest_1.* to mysqltest_1@localhost;
+connect  conn1,localhost,mysqltest_1,,mysqltest_1;
 show grants for current_user;
 Grants for mysqltest_1@localhost
 GRANT USAGE ON *.* TO 'mysqltest_1'@'localhost'
@@ -14,21 +15,36 @@ GRANT SELECT, ALTER ON `mysqltest_1`.* 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'
+disconnect conn1;
+connection default;
 grant drop on mysqltest_1.* to mysqltest_1@localhost;
+connect  conn2,localhost,mysqltest_1,,mysqltest_1;
 alter table t1 drop partition p2;
+disconnect conn2;
+connection default;
 revoke alter on mysqltest_1.* from mysqltest_1@localhost;
+connect  conn3,localhost,mysqltest_1,,mysqltest_1;
 alter table t1 drop partition p3;
 ERROR 42000: ALTER command denied to user 'mysqltest_1'@'localhost' for table 't1'
+disconnect conn3;
+connection default;
 revoke select,alter,drop on mysqltest_1.* from mysqltest_1@localhost;
 drop table t1;
 create table t1 (s1 int);
 insert into t1 values (1);
 grant alter on mysqltest_1.* to mysqltest_1@localhost;
+connect  conn4,localhost,mysqltest_1,,mysqltest_1;
+connection conn4;
 alter table t1 partition by list (s1) (partition p1 values in (2));
 ERROR HY000: Table has no partition for some existing values
+connection default;
 grant select, alter on mysqltest_1.* to mysqltest_1@localhost;
+disconnect conn4;
+connect  conn5,localhost,mysqltest_1,,mysqltest_1;
 alter table t1 partition by list (s1) (partition p1 values in (2));
 ERROR HY000: Table has no partition for value 1
+disconnect conn5;
+connection default;
 drop table t1;
 drop user mysqltest_1@localhost;
 drop schema mysqltest_1;