diff options
author | unknown <thek@adventure.(none)> | 2008-02-01 14:33:36 +0100 |
---|---|---|
committer | unknown <thek@adventure.(none)> | 2008-02-01 14:33:36 +0100 |
commit | bc070bd3b307f265a407968778f737f4e6482b81 (patch) | |
tree | 0909e2ab2a30be2d048ee2b834b0e1bc09516132 /mysql-test/r/grant.result | |
parent | 36265f707c406afa4455dd24a6cc7c682f10efd3 (diff) | |
download | mariadb-git-bc070bd3b307f265a407968778f737f4e6482b81.tar.gz |
* Manual merge fix.
mysql-test/r/grant.result:
- Manual merge step 2: Verify test cases and record new result set.
Diffstat (limited to 'mysql-test/r/grant.result')
-rw-r--r-- | mysql-test/r/grant.result | 46 |
1 files changed, 23 insertions, 23 deletions
diff --git a/mysql-test/r/grant.result b/mysql-test/r/grant.result index 579c3fa9232..e4334972845 100644 --- a/mysql-test/r/grant.result +++ b/mysql-test/r/grant.result @@ -1218,6 +1218,28 @@ DROP USER mysqltest_1@localhost; DROP DATABASE db27878; use test; DROP TABLE t1; +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; End of 5.0 tests set names utf8; grant select on test.* to юзер_юзер@localhost; @@ -1283,26 +1305,4 @@ CALL mysqltest1.test(); DROP DATABASE mysqltest1; RENAME TABLE mysql.procs_gone TO mysql.procs_priv; FLUSH PRIVILEGES; - -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; +End of 5.1 tests |