summaryrefslogtreecommitdiff
path: root/mysql-test/t/ps_grant.test
diff options
context:
space:
mode:
authormonty@mysql.com <>2005-07-28 17:09:54 +0300
committermonty@mysql.com <>2005-07-28 17:09:54 +0300
commit15d48525afc66df10f8f4e68c0a33a4e3ef2ae8c (patch)
treeefa95d21efbbc033b0cabce038118a09be44e9ac /mysql-test/t/ps_grant.test
parentb3cbd0048fe5fe36fe4fba9ce591b0d1b26e10a1 (diff)
parent3c12d0ae54eccaef7c265af4f782d95250308dc9 (diff)
downloadmariadb-git-15d48525afc66df10f8f4e68c0a33a4e3ef2ae8c.tar.gz
Merge mysql.com:/home/my/mysql-4.1
into mysql.com:/home/my/mysql-5.0
Diffstat (limited to 'mysql-test/t/ps_grant.test')
-rw-r--r--mysql-test/t/ps_grant.test15
1 files changed, 5 insertions, 10 deletions
diff --git a/mysql-test/t/ps_grant.test b/mysql-test/t/ps_grant.test
index 0b33a2dadde..81c842de459 100644
--- a/mysql-test/t/ps_grant.test
+++ b/mysql-test/t/ps_grant.test
@@ -1,7 +1,6 @@
# Can't test grants with embedded server
-- source include/not_embedded.inc
-
let $type= 'MYISAM' ;
################ GRANT/REVOKE/DROP affecting a parallel session ################
@@ -80,6 +79,7 @@ execute s_t1 ;
######## Question 2: The table t9 does not exist. ########
--error 1146
execute s_t9 ;
+deallocate prepare s_t9;
#### revoke the access rights to t1
@@ -112,8 +112,11 @@ show grants for second_user@localhost ;
drop database mysqltest;
+# End of 4.1 tests
-## grant/revoke + drop user
+#
+# grant/revoke + drop user
+#
--error 1295
prepare stmt3 from ' grant all on test.t1 to drop_user@localhost
identified by ''looser'' ';
@@ -126,11 +129,3 @@ 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;
-
-# This test must be the last one, otherwise it may produce extra
-# rows in the processlist under high load.
-# Tested here simply so it is not tested with embedded server
-prepare stmt4 from ' show full processlist ';
---replace_column 1 number 6 time 3 localhost
-execute stmt4;
-deallocate prepare stmt4;