diff options
author | unknown <msvensson@shellback.(none)> | 2006-04-18 10:46:17 +0200 |
---|---|---|
committer | unknown <msvensson@shellback.(none)> | 2006-04-18 10:46:17 +0200 |
commit | 3bcbf91376ff05ee9da1736c98998356c3bcbc56 (patch) | |
tree | b5c897a1916d22ac7c068c451037aa4300b77c41 /mysql-test/t/grant2.test | |
parent | d33fc7bad1a7e019434692d5244f6477373771f3 (diff) | |
download | mariadb-git-3bcbf91376ff05ee9da1736c98998356c3bcbc56.tar.gz |
BUG#13310 incorrect user parsing by SP
- Strip surrounding ''s from username when a new user connects. There
is no user 'a@', it should be a@
mysql-test/r/grant2.result:
Update test result
mysql-test/t/grant2.test:
Add tests for bug 13310
sql/sql_parse.cc:
Strip surrounding ''s from username when a new user connects. There
is no user 'a@', it should be a@
Diffstat (limited to 'mysql-test/t/grant2.test')
-rw-r--r-- | mysql-test/t/grant2.test | 25 |
1 files changed, 25 insertions, 0 deletions
diff --git a/mysql-test/t/grant2.test b/mysql-test/t/grant2.test index 2c62d2f1bd3..32232360afa 100644 --- a/mysql-test/t/grant2.test +++ b/mysql-test/t/grant2.test @@ -465,3 +465,28 @@ drop table t1, t2; drop database TESTDB; flush privileges; +# +# BUG#13310 incorrect user parsing by SP +# + +grant all privileges on test.* to `a@`@localhost; +grant execute on * to `a@`@localhost; +connect (bug13310,localhost,'a@',,test); +connection bug13310; +create table t2 (s1 int); +insert into t2 values (1); +--disable_warnings +drop function if exists f2; +--enable_warnings +delimiter //; +create function f2 () returns int begin declare v int; select s1 from t2 +into v; return v; end// +delimiter ;// +select f2(); + +drop function f2; +drop table t2; +disconnect bug13310; + +connection default; +REVOKE ALL PRIVILEGES, GRANT OPTION FROM `a@`@localhost; |