summaryrefslogtreecommitdiff
path: root/mysql-test/r/drop.result
diff options
context:
space:
mode:
authorunknown <cmiller@zippy.cornsilk.net>2008-03-05 14:18:35 -0500
committerunknown <cmiller@zippy.cornsilk.net>2008-03-05 14:18:35 -0500
commit2eb67908704727d276cae0d63e5d116511a5fc7d (patch)
treebcc5c17b5d1675183037a745251a0a5abf8bf967 /mysql-test/r/drop.result
parent2b7dda9e9d06f2ab6036da39250a765926c9c437 (diff)
downloadmariadb-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.result39
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