Yes,I already read this section.
But, maybe there are haven't relation to my question.
Are the effect of setting IGNORE_SPACE in sql mode allowing add space between
function name and "("?
If my attitude is right,then if i haven't setting IGNORE_SPACE in sql mode,I
shouldn't add space between function name and "(".But fact not like this.
Please note example in my reference.
> ----- Original Message -----
> From: "Gleb Paharenko" <[EMAIL PROTECTED]>
> To: <[email protected]>
> Sent: Friday, December 30, 2005 2:04 AM
> Subject: Re: create function with space
>
>
> > Hello.
> >
> > >From the manual:
> >
> > ANSI
> >
> > Equivalent to REAL_AS_FLOAT, PIPES_AS_CONCAT, ANSI_QUOTES, IGNORE_SPACE.
> > Before MySQL 5.0.3, ANSI also includes ONLY_FULL_GROUP_BY. See Section
> > 1.8.3, ���Running MySQL in ANSI Mode��?
> >
> > wangxu wrote:
> > >I set my sql_mode =
> > >'STRICT_TRANS_TABLES,ANSI_QUOTES,ERROR_FOR_DIVISION_BY_ZERO'.
> >
> > >Note,IGNORE_SPACE not include sql mode.
> >
> > >But i still execute statement as follow :
> >
> > >------------------------------------------------------------
> > >CREATE FUNCTION "wangxu"."user " () RETURNS int(11)
> > >BEGIN
> > > return 1;
> > >END
> > >---------------------------------------------------------------------
> > >There is a space in function name and there is a space between function
> > >name and "(".In mysql word,this funciton can't be created.But i created
> > >it well.
> >
> >
> > --
> > For technical support contracts, goto https://order.mysql.com/?ref=ensita
> > This email is sponsored by Ensita.NET http://www.ensita.net/
> > __ ___ ___ ____ __
> > / |/ /_ __/ __/ __ \/ / Gleb Paharenko
> > / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
> > /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET
> > <___/ www.mysql.com
> >
> >
> >
> >
> > --
> > MySQL General Mailing List
> > For list archives: http://lists.mysql.com/mysql
> > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
> >
> >
