trailing space in column name

[Zhixuan Zhu]

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;

We plan to relax the trailing space limitation by modifying table.cc (we
build mysql 5.1.26 from source). Will that cause troubles else where?
Another option is that we can remove the trailing spaces in sql_table.cc
before the field name is passed to check_column_name(). But just
wondering why MySQL wouldn't do the same thing. Is there any pitfalls?

Thanks,
Zhixuan