diff options
author | unknown <cmiller@zippy.cornsilk.net> | 2008-03-05 14:18:35 -0500 |
---|---|---|
committer | unknown <cmiller@zippy.cornsilk.net> | 2008-03-05 14:18:35 -0500 |
commit | 2eb67908704727d276cae0d63e5d116511a5fc7d (patch) | |
tree | bcc5c17b5d1675183037a745251a0a5abf8bf967 /mysql-test/r/drop.result | |
parent | 2b7dda9e9d06f2ab6036da39250a765926c9c437 (diff) | |
download | mariadb-git-2eb67908704727d276cae0d63e5d116511a5fc7d.tar.gz |
Move test that has more to do with grants than DROP. We shouldn't have
grant warnings on embedded server.
mysql-test/r/drop.result:
Move test that has more to do with grants than DROP.
mysql-test/r/grant.result:
Move test that has more to do with grants than DROP.
mysql-test/t/drop.test:
Move test that has more to do with grants than DROP.
mysql-test/t/grant.test:
Move test that has more to do with grants than DROP.
Diffstat (limited to 'mysql-test/r/drop.result')
-rw-r--r-- | mysql-test/r/drop.result | 39 |
1 files changed, 0 insertions, 39 deletions
diff --git a/mysql-test/r/drop.result b/mysql-test/r/drop.result index b4f6395819f..71d6fcc7cd0 100644 --- a/mysql-test/r/drop.result +++ b/mysql-test/r/drop.result @@ -91,43 +91,4 @@ create table mysql_test.`#sql-347f_7` (f1 int); create table mysql_test.`#sql-347f_8` (f1 int); drop table mysql_test.`#sql-347f_8`; drop database mysql_test; -CREATE DATABASE dbbug33464; -CREATE USER 'userbug33464'@'localhost'; -GRANT CREATE ROUTINE ON dbbug33464.* TO 'userbug33464'@'localhost'; - -userbug33464@localhost dbbug33464 -DROP PROCEDURE IF EXISTS sp3; -DROP FUNCTION IF EXISTS fn1; -CREATE PROCEDURE sp3(v1 char(20)) -BEGIN -SELECT * from dbbug33464.t6 where t6.f2= 'xyz'; -END// -CREATE FUNCTION fn1() returns char(50) SQL SECURITY INVOKER -BEGIN -return 1; -END// -CREATE FUNCTION fn2() returns char(50) SQL SECURITY DEFINER -BEGIN -return 2; -END// -USE dbbug33464; - -root@localhost dbbug33464 -SELECT fn1(); -fn1() -1 -SELECT fn2(); -fn2() -2 -DROP USER 'userbug33464'@'localhost'; -DROP FUNCTION fn1; -Warnings: -Warning 1403 There is no such grant defined for user 'userbug33464' on host 'localhost' on routine 'fn1' -DROP FUNCTION fn2; -Warnings: -Warning 1403 There is no such grant defined for user 'userbug33464' on host 'localhost' on routine 'fn2' -DROP PROCEDURE sp3; -DROP USER 'userbug33464'@'localhost'; -use test; -DROP DATABASE dbbug33464; End of 5.1 tests |