summaryrefslogtreecommitdiff
path: root/mysql-test/r/sp.result
diff options
context:
space:
mode:
Diffstat (limited to 'mysql-test/r/sp.result')
-rw-r--r--mysql-test/r/sp.result4
1 files changed, 4 insertions, 0 deletions
diff --git a/mysql-test/r/sp.result b/mysql-test/r/sp.result
index 9453a1da3ca..de6b87d67cd 100644
--- a/mysql-test/r/sp.result
+++ b/mysql-test/r/sp.result
@@ -6417,6 +6417,8 @@ set x=-1;
return x;
end|
create view v1 as select 1 as one, f1() as days;
+connect bug29408, localhost, root,,*NO-ONE*;
+connection bug29408;
show create view test.v1;
View Create View character_set_client collation_connection
v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `test`.`v1` AS select 1 AS `one`,`f1`() AS `days` latin1 latin1_swedish_ci
@@ -6425,6 +6427,8 @@ where table_name='v1' and table_schema='test';
column_name
one
days
+connection default;
+disconnect bug29408;
drop view v1;
drop function f1;