create function foo() returns int return 1; create view v1 as select foo() from dual; create view v2 as select * from v1; select * from v1; select * from v2; --exec $MYSQL_DUMP --routines test v1 v2 > $MYSQL_TEST_DIR/var/tmp/bug61961.sql drop function foo; drop view v1, v2; --exec $MYSQL test <$MYSQL_TEST_DIR/var/tmp/bug61961.sql select * from v1; select * from v2;