summaryrefslogtreecommitdiff
path: root/mysql-test/r/grant.result
diff options
context:
space:
mode:
authorunknown <thek@adventure.(none)>2008-02-01 14:33:36 +0100
committerunknown <thek@adventure.(none)>2008-02-01 14:33:36 +0100
commitbc070bd3b307f265a407968778f737f4e6482b81 (patch)
tree0909e2ab2a30be2d048ee2b834b0e1bc09516132 /mysql-test/r/grant.result
parent36265f707c406afa4455dd24a6cc7c682f10efd3 (diff)
downloadmariadb-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.result46
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