1 files changed, 33 insertions, 0 deletions
diff --git a/mysql-test/t/sp.test b/mysql-test/t/sp.test
index 938bbc27777..78ac419e451 100644
--- a/mysql-test/t/sp.test
+++ b/mysql-test/t/sp.test
@@ -7495,6 +7495,39 @@ DROP FUNCTION f2;
 DROP TABLE t1;
 
 #
+# Bug#29408 Cannot find view in columns table if the selection contains a function
+#
+delimiter |;
+
+create function f1()
+    returns int(11)
+not deterministic
+contains sql
+sql security definer
+comment ''
+begin
+  declare x int(11);
+  set x=-1;
+   return x;
+end|
+                          
+delimiter ;|
+                  
+create view v1 as select 1 as one, f1() as days;
+                          
+connect (bug29408, localhost, root,,*NO-ONE*);                     
+connection bug29408;
+
+show create view test.v1;      
+select column_name from information_schema.columns
+where table_name='v1' and table_schema='test';
+
+connection default;
+disconnect bug29408;
+drop view v1;
+drop function f1;
+
+#
 # Bug#13675: DATETIME/DATE type in store proc param seems to be converted as
 # varbinary
 #