From 2fc1d5c1467421bae7405b1a5707bd53ba2b03e2 Mon Sep 17 00:00:00 2001 From: "bar@bar.intranet.mysql.r18.ru" <> Date: Fri, 14 May 2004 12:16:27 +0500 Subject: Bug #3403 Wrong encoding in SHOW GRANTS, EPLAIN SELECT output This change fixes SHOW GRANTS problem, while EXPLAIN will be fixed in a separate patch. --- mysql-test/t/grant.test | 23 +++++++++++++++++++++++ 1 file changed, 23 insertions(+) (limited to 'mysql-test/t/grant.test') diff --git a/mysql-test/t/grant.test b/mysql-test/t/grant.test index 832541b0f86..6bd2fa0c703 100644 --- a/mysql-test/t/grant.test +++ b/mysql-test/t/grant.test @@ -148,3 +148,26 @@ grant usage on *.* to mysqltest_1@localhost identified by "password"; grant select, update, insert on test.* to mysqltest@localhost; show grants for mysqltest_1@localhost; drop user mysqltest_1@localhost; + +# +# Bug #3403 Wrong encodin in SHOW GRANTS output +# +SET NAMES koi8r; +CREATE DATABASE бд; +USE бд; +CREATE TABLE таб (кол int); + +GRANT SELECT ON бд.* TO юзер@localhost; +SHOW GRANTS FOR юзер@localhost; +REVOKE SELECT ON бд.* FROM юзер@localhost; + +GRANT SELECT ON бд.таб TO юзер@localhost; +SHOW GRANTS FOR юзер@localhost; +REVOKE SELECT ON бд.таб FROM юзер@localhost; + +GRANT SELECT (кол) ON бд.таб TO юзер@localhost; +SHOW GRANTS FOR юзер@localhost; +REVOKE SELECT (кол) ON бд.таб FROM юзер@localhost; + +DROP DATABASE бд; +SET NAMES latin1; -- cgit v1.2.1