diff options
| author | serg@serg.mylan <> | 2004-11-27 23:07:30 +0100 |
|---|---|---|
| committer | serg@serg.mylan <> | 2004-11-27 23:07:30 +0100 |
| commit | 319546d5f011a4252f1e143719955dbcaccfb183 (patch) | |
| tree | 6aee196afde28c5ab6978f8c8b0563c01cdb5f8e /mysql-test/t/grant2.test | |
| parent | 2c3159eb9e1900b7e7357020b8f7a07a85d5cd6c (diff) | |
| download | mariadb-git-319546d5f011a4252f1e143719955dbcaccfb183.tar.gz | |
create/drop/rename user cleanup
Diffstat (limited to 'mysql-test/t/grant2.test')
| -rw-r--r-- | mysql-test/t/grant2.test | 12 |
1 files changed, 6 insertions, 6 deletions
diff --git a/mysql-test/t/grant2.test b/mysql-test/t/grant2.test index 70cec9e0e35..69c42ce2252 100644 --- a/mysql-test/t/grant2.test +++ b/mysql-test/t/grant2.test @@ -91,7 +91,7 @@ create table t2(c1 int, c2 int); # # Three forms of CREATE USER create user 'mysqltest_1'; ---error 1268 +--error 1396 create user 'mysqltest_1'; create user 'mysqltest_2' identified by 'Mysqltest-2'; create user 'mysqltest_3' identified by password 'fffffffffffffffffffffffffffffffffffffffff'; @@ -127,7 +127,7 @@ drop user 'mysqltest_1', 'mysqltest_3'; # Grant must not create user --error 1211 grant all on test.t1 to 'mysqltest_1'; ---error 1268 +--error 1396 drop user 'mysqltest_1'; # # Cleanup @@ -164,18 +164,18 @@ create user 'mysqltest_1', 'mysqltest_2', 'mysqltest_3'; drop user 'mysqltest_1', 'mysqltest_2', 'mysqltest_3'; create user 'mysqltest_1', 'mysqltest_2' identified by 'Mysqltest-2', 'mysqltest_3' identified by password 'fffffffffffffffffffffffffffffffffffffffff'; rename user 'mysqltest_1' to 'mysqltest_1a', 'mysqltest_2' TO 'mysqltest_2a', 'mysqltest_3' TO 'mysqltest_3a'; ---error 1268 +--error 1396 drop user 'mysqltest_1', 'mysqltest_2', 'mysqltest_3'; drop user 'mysqltest_1a', 'mysqltest_2a', 'mysqltest_3a'; # # Let one of multiple users fail create user 'mysqltest_1', 'mysqltest_2', 'mysqltest_3'; ---error 1268 +--error 1396 create user 'mysqltest_1a', 'mysqltest_2', 'mysqltest_3a'; ---error 1268 +--error 1396 rename user 'mysqltest_1a' to 'mysqltest_1b', 'mysqltest_2a' TO 'mysqltest_2b', 'mysqltest_3a' TO 'mysqltest_3b'; drop user 'mysqltest_1', 'mysqltest_2', 'mysqltest_3'; ---error 1268 +--error 1396 drop user 'mysqltest_1b', 'mysqltest_2b', 'mysqltest_3b'; # # Obsolete syntax has been dropped |