diff options
| author | unknown <dlenev@mysql.com> | 2004-12-23 21:59:36 +0300 |
|---|---|---|
| committer | unknown <dlenev@mysql.com> | 2004-12-23 21:59:36 +0300 |
| commit | 4a5ca0bc638b2e09bca1fc0b9b8bee02590c6e08 (patch) | |
| tree | f380646ec05c8f3f6c4dd9fa9d2d126b06aa429a /mysql-test/t/grant.test | |
| parent | e6dfed9f4cb88406dec37ffb5ca1fa0b0f2b3e75 (diff) | |
| download | mariadb-git-4a5ca0bc638b2e09bca1fc0b9b8bee02590c6e08.tar.gz | |
Make GRANTs, which change SSL attributes and/or user limits,
to behave well on 5.0 tables (well now you can't use tables from 4.1
and 5.0 with 4.0 because former use utf8, but still it is nice to have
similar code in acl_init() and replace_user_table()).
This also will make such GRANTs working in 5.0 (they are broken now).
mysql-test/r/grant.result:
Added test for GRANT which manipulates user limits.
mysql-test/t/grant.test:
Added test for GRANT which manipulates user limits.
Diffstat (limited to 'mysql-test/t/grant.test')
| -rw-r--r-- | mysql-test/t/grant.test | 17 |
1 files changed, 17 insertions, 0 deletions
diff --git a/mysql-test/t/grant.test b/mysql-test/t/grant.test index d9b4be04de3..960c55065fe 100644 --- a/mysql-test/t/grant.test +++ b/mysql-test/t/grant.test @@ -28,6 +28,23 @@ delete from mysql.user where user='mysqltest_1'; flush privileges; # +# Test of GRANTS specifying user limits +# +delete from mysql.user where user='mysqltest_1'; +flush privileges; +grant usage on *.* to mysqltest_1@localhost with max_queries_per_hour 10; +select * from mysql.user where user="mysqltest_1"; +show grants for mysqltest_1@localhost; +grant usage on *.* to mysqltest_1@localhost with max_updates_per_hour 20 max_connections_per_hour 30; +select * from mysql.user where user="mysqltest_1"; +show grants for mysqltest_1@localhost; +# This is just to double check that one won't ignore results of selects +flush privileges; +show grants for mysqltest_1@localhost; +delete from mysql.user where user='mysqltest_1'; +flush privileges; + +# # Test that the new db privileges are stored/retrieved correctly # |