summaryrefslogtreecommitdiff
path: root/mysql-test/t/grant2.test
diff options
context:
space:
mode:
authorunknown <ingo@mysql.com>2004-11-26 11:18:20 +0100
committerunknown <ingo@mysql.com>2004-11-26 11:18:20 +0100
commit2c2333e5f2f5bda27dd1079ba9302aa1fb200f2b (patch)
tree720e20a56841bc48f8467d226ad300bb446b6c4c /mysql-test/t/grant2.test
parent036a61c2416c0f3b52d5388950552862ee3488a3 (diff)
downloadmariadb-git-2c2333e5f2f5bda27dd1079ba9302aa1fb200f2b.tar.gz
Changed test to remove node name from output.
(was from WL#2050 - CREATE USER and DROP USER and RENAME USER) mysql-test/r/grant2.result: Replaced test results after removing node name from output. (was from WL#2050 - CREATE USER and DROP USER and RENAME USER)
Diffstat (limited to 'mysql-test/t/grant2.test')
-rw-r--r--mysql-test/t/grant2.test10
1 files changed, 6 insertions, 4 deletions
diff --git a/mysql-test/t/grant2.test b/mysql-test/t/grant2.test
index c439bd05d2f..70cec9e0e35 100644
--- a/mysql-test/t/grant2.test
+++ b/mysql-test/t/grant2.test
@@ -125,8 +125,10 @@ show grants for 'mysqltest_1';
drop user 'mysqltest_1', 'mysqltest_3';
#
# Grant must not create user
-#grant all on test.t1 to 'mysqltest_1';
-#drop user 'mysqltest_1';
+--error 1211
+grant all on test.t1 to 'mysqltest_1';
+--error 1268
+drop user 'mysqltest_1';
#
# Cleanup
drop table t1, t2;
@@ -198,7 +200,7 @@ grant usage on *.* to mysqltest_2@localhost with grant option;
connect (user2,localhost,mysqltest_2,,);
connection user2;
--error 1044
-select host,user,password from mysql.user order by host,user,password;
+select host,user,password from mysql.user where user like 'mysqltest_%' order by host,user,password;
create user mysqltest_A@'%';
rename user mysqltest_A@'%' to mysqltest_B@'%';
drop user mysqltest_B@'%';
@@ -211,7 +213,7 @@ create user mysqltest_3@localhost;
grant all privileges on mysql.* to mysqltest_3@localhost;
connect (user3,localhost,mysqltest_3,,);
connection user3;
-select host,user,password from mysql.user order by host,user,password;
+select host,user,password from mysql.user where user like 'mysqltest_%' order by host,user,password;
insert into mysql.user set host='%', user='mysqltest_B';
--error 1044
create user mysqltest_A@'%';