Bug #57635 do not allow space in column name
Submitted: 21 Oct 2010 19:19 Modified: 28 Oct 2010 10:19
Reporter: Petronel Laviniu Malutan Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Workbench Severity:S3 (Non-critical)
Version:5.2.28 OS:Any
Assigned to: CPU Architecture:Any
Tags: column name, space

[21 Oct 2010 19:19] Petronel Laviniu Malutan 
Description:
I think you should not allow colum names which include spaces ?!

How to repeat:
Create column name "cod postal" ! I think you should not allow colum names which include spaces ?!

Suggested fix:
exporting to yml such a column name will produce a error when creating models
[21 Oct 2010 19:58] Peter Laursen 
Space characters are perfectly valid in identifiers (at least from MySQL 5.1).  WB should not add rules different from what rules the the server has (it is more than serious enough that it does not handle non-ascii identifiers properly).

Peter
(not a MySQL person)
[28 Oct 2010 10:19] Johannes Taxacher 
we can't add this as - mentioned by peter already - spaces are valid characters for MySQL table-names. If you are exporting data to some other format/app, the export needs to take care of such translations.