summaryrefslogtreecommitdiff
path: root/mysql-test/r/temp_table.result
diff options
context:
space:
mode:
Diffstat (limited to 'mysql-test/r/temp_table.result')
-rw-r--r--mysql-test/r/temp_table.result2
1 files changed, 1 insertions, 1 deletions
diff --git a/mysql-test/r/temp_table.result b/mysql-test/r/temp_table.result
index 23d4f2a79b6..da2a303456d 100644
--- a/mysql-test/r/temp_table.result
+++ b/mysql-test/r/temp_table.result
@@ -111,7 +111,7 @@ t1 CREATE TEMPORARY TABLE `t1` (
) ENGINE=MyISAM DEFAULT CHARSET=latin1
show create view t1;
View Create View
-t1 CREATE ALGORITHM=UNDEFINED VIEW `t1` AS select _latin1'This is view' AS `A`
+t1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `test`.`t1` AS select _latin1'This is view' AS `A`
drop view t1;
select * from t1;
A