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?
From: Ingo.Struewing@stripped [mailto:Ingo.Struewing@stripped]
Sent: Tuesday, June 09, 2009 1:39 AM
To: Zhixuan Zhu
Subject: Re: trailing space in column name
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?
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