diff options
author | unknown <ingo@mysql.com> | 2004-11-26 11:18:20 +0100 |
---|---|---|
committer | unknown <ingo@mysql.com> | 2004-11-26 11:18:20 +0100 |
commit | 2c2333e5f2f5bda27dd1079ba9302aa1fb200f2b (patch) | |
tree | 720e20a56841bc48f8467d226ad300bb446b6c4c /mysql-test/t/grant2.test | |
parent | 036a61c2416c0f3b52d5388950552862ee3488a3 (diff) | |
download | mariadb-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.test | 10 |
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@'%'; |