MySQL Bugs: #22235: BackUp and Restore operation fails on Stored Functions

Bug #22235	BackUp and Restore operation fails on Stored Functions
Submitted:	11 Sep 2006 13:06	Modified:	6 Feb 2008 11:01
Reporter:	Dogan Erdogant	Email Updates:
Status:	Duplicate	Impact on me:	None
Category:	MySQL Administrator	Severity:	S3 (Non-critical)
Version:	1.2.3 rc	OS:	Windows (WinXp SP2)
Assigned to:		CPU Architecture:	Any
Tags:	Error 1418, stored function

Description:
I'm trying to 1.2.3 rc GUI bundle. Bakcup function works properly, but restore operation fails if the backup has a "stored function" and displays 

"MySQL Error Nr.1418-This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in its declaration and binary logging is enabled (you *might* want to use the less safe log_bin_trust_function_creators variable)"

I didn't understand the message and couldn't find a relation between its meaning and the situation. Also I haven't face with the message before with the previous versions of the administrator.

Both BackUp and Restore databases and administrator softwares are same (db 5.0.17, admin 1.2.3 rc). And all the backup and restore parameters are left as default.

How to repeat:
Backup a stored function, and then restore it. The progress form will display a "The restoration failed" message.

Thank you for taking the time to write to us, but this is not a bug. Please double-check the documentation available at http://dev.mysql.com/doc/ and the instructions on
how to report a bug at http://bugs.mysql.com/how-to-report.php

See also http://dev.mysql.com/doc/refman/5.0/en/stored-procedure-logging.html

Investigating bug #34316 found same error is repeatable even with acceptable create function statement. So marked as duplicate of bug #22235, because latter contains test case.