MySQL Bugs: #16100: Please note that IGNORE_SPACE sql_mode is not related to CREATE FUNCTION

Bug #16100	Please note that IGNORE_SPACE sql_mode is not related to CREATE FUNCTION
Submitted:	30 Dec 2005 16:22	Modified:	21 Jan 2006 18:18
Reporter:	Gleb Paharenko	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server: Documentation	Severity:	S4 (Feature request)
Version:	all	OS:	Any (all)
Assigned to:		CPU Architecture:	Any

Description:
Space are allowed in the CREATE FUNCTION clause after sp_name and '(', but from the description of IGNORE_SPACE some users have opinion that spaces are forbidden everywhere after the function name, even in the CREATE FUNCTION 'function_name' statement

How to repeat:
See:
  http://dev.mysql.com/doc/refman/5.0/en/create-procedure.html
  http://dev.mysql.com/doc/refman/5.0/en/server-sql-mode.html

Suggested fix:
Please add some notes, even if they're obvious, that spaces not prohibited everywhere after the function name

Thank you for your bug report. This issue has been addressed in the
documentation. The updated documentation will appear on our website
shortly, and will be included in the next release of the relevant
product(s).

Additional info:

I've added this to the pages in question:

        The <literal>IGNORE_SPACE</literal> SQL mode applies to built-in
        functions, not to stored routines. it is always allowable to
        have spaces after a routine name, regardless of whether
        <literal>IGNORE_SPACE</literal> is enabled.