summaryrefslogtreecommitdiff
path: root/mysql-test/r/grant.result
diff options
context:
space:
mode:
authorunknown <thek@adventure.(none)>2008-02-01 14:14:37 +0100
committerunknown <thek@adventure.(none)>2008-02-01 14:14:37 +0100
commit36265f707c406afa4455dd24a6cc7c682f10efd3 (patch)
treef3a2815a6fd9457aa543771067bc63077a57d75f /mysql-test/r/grant.result
parent97355f4e0a39260b7c54f1ee688e4738f42a0166 (diff)
parentf7d8fb1cdde7a9655b984827547a7f4f85560834 (diff)
downloadmariadb-git-36265f707c406afa4455dd24a6cc7c682f10efd3.tar.gz
Merge adventure.(none):/home/thek/Development/cpp/bug33201/my50-bug33201
into adventure.(none):/home/thek/Development/cpp/bug33201/my51-bug33201 mysql-test/t/grant.test: Auto merged sql/sql_acl.cc: Auto merged mysql-test/r/grant.result: Manual merge
Diffstat (limited to 'mysql-test/r/grant.result')
-rw-r--r--mysql-test/r/grant.result24
1 files changed, 23 insertions, 1 deletions
diff --git a/mysql-test/r/grant.result b/mysql-test/r/grant.result
index 0df3ac6de8a..579c3fa9232 100644
--- a/mysql-test/r/grant.result
+++ b/mysql-test/r/grant.result
@@ -1283,4 +1283,26 @@ CALL mysqltest1.test();
DROP DATABASE mysqltest1;
RENAME TABLE mysql.procs_gone TO mysql.procs_priv;
FLUSH PRIVILEGES;
-End of 5.1 tests
+
+drop table if exists test;
+Warnings:
+Note 1051 Unknown table 'test'
+drop function if exists test_function;
+Warnings:
+Note 1305 FUNCTION test_function does not exist
+drop view if exists v1;
+Warnings:
+Note 1051 Unknown table 'test.v1'
+create table test (col1 varchar(30));
+create function test_function() returns varchar(30)
+begin
+declare tmp varchar(30);
+select col1 from test limit 1 into tmp;
+return '1';
+end|
+create view v1 as select test.* from test where test.col1=test_function();
+grant update (col1) on v1 to 'greg';
+revoke all privileges on v1 from 'greg';
+drop view v1;
+drop table test;
+drop function test_function;