summaryrefslogtreecommitdiff
path: root/mysql-test/t/ps_grant.test
diff options
context:
space:
mode:
authorunknown <jimw@mysql.com>2005-04-04 12:43:58 -0700
committerunknown <jimw@mysql.com>2005-04-04 12:43:58 -0700
commit4189e7c85fcab96976f23dd89b01c3ba51d83578 (patch)
tree4f8a13865c65a18d89af9dbdac651926c0bc8847 /mysql-test/t/ps_grant.test
parentbee2a64d0b05c37d14906be103d3abbbb533a592 (diff)
downloadmariadb-git-4189e7c85fcab96976f23dd89b01c3ba51d83578.tar.gz
Cleanup tests and results after merge from 4.1 of embedded
server testing cleanups. mysql-test/r/innodb.result: Update results mysql-test/r/insert_select-binlog.result: Update results mysql-test/r/mix_innodb_myisam_binlog.result: Update results mysql-test/r/ps_1general.result: Update results mysql-test/r/ps_grant.result: Update results mysql-test/r/view.result: Update results mysql-test/t/client_xml.test: Skip test with embedded server mysql-test/t/flush_read_lock_kill.test: Skip test with embedded server mysql-test/t/grant3.test: Skip test with embedded server mysql-test/t/information_schema.test: Skip test with embedded server mysql-test/t/innodb.test: Fix up filenames mysql-test/t/multi_update.test: Skip test with embedded server mysql-test/t/mysqlshow.test: Skip test with embedded server mysql-test/t/ps_1general.test: Move grant-related tests to ps_grant, and fix cleanup of filename mysql-test/t/ps_grant.test: Add additional tests mysql-test/t/sp-security.test: Skip test with embedded server mysql-test/t/user_limits.test: Skip test with embedded server mysql-test/t/view.test: Split grant-related tests to new test file view_grant
Diffstat (limited to 'mysql-test/t/ps_grant.test')
-rw-r--r--mysql-test/t/ps_grant.test13
1 files changed, 13 insertions, 0 deletions
diff --git a/mysql-test/t/ps_grant.test b/mysql-test/t/ps_grant.test
index 06613072824..07bd70f6cff 100644
--- a/mysql-test/t/ps_grant.test
+++ b/mysql-test/t/ps_grant.test
@@ -116,4 +116,17 @@ show grants for second_user@localhost ;
drop database mysqltest;
+## grant/revoke + drop user
+--error 1295
+prepare stmt3 from ' grant all on test.t1 to drop_user@localhost
+identified by ''looser'' ';
+grant all on test.t1 to drop_user@localhost
+identified by 'looser' ;
+--error 1295
+prepare stmt3 from ' revoke all privileges on test.t1 from
+drop_user@localhost ';
+revoke all privileges on test.t1 from drop_user@localhost ;
+--error 1295
+prepare stmt3 from ' drop user drop_user@localhost ';
+drop user drop_user@localhost;