summaryrefslogtreecommitdiff
path: root/mysql-test/main/grant.test
diff options
context:
space:
mode:
Diffstat (limited to 'mysql-test/main/grant.test')
-rw-r--r--mysql-test/main/grant.test2
1 files changed, 2 insertions, 0 deletions
diff --git a/mysql-test/main/grant.test b/mysql-test/main/grant.test
index 82b68b3b6e6..c8ca440b3e8 100644
--- a/mysql-test/main/grant.test
+++ b/mysql-test/main/grant.test
@@ -1239,12 +1239,14 @@ drop function if exists test_function;
drop view if exists v1;
create table test (col1 varchar(30));
delimiter |;
+--enable_prepare_warnings
create function test_function() returns varchar(30)
begin
declare tmp varchar(30);
select col1 from test limit 1 into tmp;
return '1';
end|
+--disable_prepare_warnings
delimiter ;|
create view v1 as select test.* from test where test.col1=test_function();
grant update (col1) on v1 to 'greg'@'localhost';