diff options
| author | unknown <gluh@gluh.mysql.r18.ru> | 2004-03-17 16:19:09 +0400 |
|---|---|---|
| committer | unknown <gluh@gluh.mysql.r18.ru> | 2004-03-17 16:19:09 +0400 |
| commit | ca0ece1374419e4edfd2cbfb0bc7a81ca707ef96 (patch) | |
| tree | 85993392ed529bbc9a9cc6f784a053934cc9cfab /mysql-test/t/grant.test | |
| parent | 6c8a28288abef532d4dbd6c74edc11feca50ebd4 (diff) | |
| download | mariadb-git-ca0ece1374419e4edfd2cbfb0bc7a81ca707ef96.tar.gz | |
Fix for bug#3086: SHOW GRANTS doesn't follow ANSI_QUOTES
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 e6b19e86c90..326759cb9ca 100644 --- a/mysql-test/t/grant.test +++ b/mysql-test/t/grant.test @@ -107,6 +107,23 @@ grant ALL PRIVILEGES on *.* to drop_user@localhost with GRANT OPTION; grant ALL PRIVILEGES on test.* to drop_user@localhost with GRANT OPTION; grant select(a) on test.t1 to drop_user@localhost; show grants for drop_user@localhost; + +# +# Bug3086 +# +set sql_mode=ansi_quotes; +show grants for drop_user@localhost; +set sql_mode=default; + +set sql_quote_show_create=0; +show grants for drop_user@localhost; +set sql_mode="ansi_quotes"; +show grants for drop_user@localhost; +set sql_quote_show_create=1; +show grants for drop_user@localhost; +set sql_mode=""; +show grants for drop_user@localhost; + revoke all privileges, grant option from drop_user@localhost; show grants for drop_user@localhost; drop user drop_user@localhost; |