I wonder, will SELECTing from the information_schema trim the trailing blank? If so, will
that hurt any internal actions? Or just external scripts?
Rick James
MySQL Geeks - Consulting & Review
> -----Original Message-----
> From: Zhixuan Zhu [mailto:zzhu@stripped]
> Sent: Tuesday, June 09, 2009 8:42 AM
> To: Ingo.Struewing@stripped
> Cc: internals@stripped
> Subject: RE: trailing space in column name
>
> No specific reason. We internally translate SELECT statement
> to CREATE TABLE AS SELECT statement for some purpose. And our
> QA generate lots of things to test including something like
> /select "a ", r_name from region/ stuff and that failed
> because literal "a " failed the create table part.
>
> You know it's hard to persuade QA that some tests they've
> done are not reasonable :). BTW, any insights to my question?
>
> -----Original Message-----
> From: Ingo.Struewing@stripped [mailto:Ingo.Struewing@stripped]
> Sent: Tuesday, June 09, 2009 1:39 AM
> To: Zhixuan Zhu
> Cc: internals@stripped
> Subject: Re: trailing space in column name
>
> Hi Zhixuan,
>
> Zhixuan Zhu, 09.06.2009 00:08:
>
> > This may sound minor, but it creates lots of trouble to us. For some
> > reason MySQL disallow column names with trailing space in
> create table.
> > We're doing lots of "create table as select" type of queries and so
> > statements like this will fail:
> >
> > Create table test as select "command ", command_type from
> command_table;
>
> just curious: Why do you want to have trailing space in column names?
>
> Regards
> Ingo
> --
> Ingo Strüwing, Database Group
> Sun Microsystems GmbH, Sonnenallee 1, D-85551 Kirchheim-Heimstetten
> Geschäftsführer: Thomas Schröder, Wolfgang Engels, Wolf Frenkel
> Vorsitzender des Aufsichtsrates: Martin Häring HRB München 161028
>
> --
> MySQL Internals Mailing List
> For list archives: http://lists.mysql.com/internals
> To unsubscribe:
> http://lists.mysql.com/internals?unsub=1
>
>