diff options
author | unknown <thek@adventure.(none)> | 2008-02-01 14:14:37 +0100 |
---|---|---|
committer | unknown <thek@adventure.(none)> | 2008-02-01 14:14:37 +0100 |
commit | 36265f707c406afa4455dd24a6cc7c682f10efd3 (patch) | |
tree | f3a2815a6fd9457aa543771067bc63077a57d75f /mysql-test/r/grant.result | |
parent | 97355f4e0a39260b7c54f1ee688e4738f42a0166 (diff) | |
parent | f7d8fb1cdde7a9655b984827547a7f4f85560834 (diff) | |
download | mariadb-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.result | 24 |
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; |