diff options
Diffstat (limited to 'mysql-test/t/partition_grant.test')
| -rw-r--r-- | mysql-test/t/partition_grant.test | 8 |
1 files changed, 8 insertions, 0 deletions
diff --git a/mysql-test/t/partition_grant.test b/mysql-test/t/partition_grant.test index e2e80a7ca04..ee7c71b497a 100644 --- a/mysql-test/t/partition_grant.test +++ b/mysql-test/t/partition_grant.test @@ -17,6 +17,14 @@ use mysqltest_1; create table t1 (a int) partition by list (a) (partition p1 values in (1), partition p2 values in (2), partition p3 values in (3)); insert into t1 values (1),(2); +# We don't have DROP USER IF EXISTS. Use this workaround to +# cleanup possible grants for mysqltest_1 left by previous tests +# and ensure consistent results of SHOW GRANTS command below. +--disable_warnings +grant usage on *.* to mysqltest_1@localhost; +revoke all privileges on *.* from mysqltest_1@localhost; +--enable_warnings + grant select,alter on mysqltest_1.* to mysqltest_1@localhost; connect (conn1,localhost,mysqltest_1,,mysqltest_1); |