Bug #81836 Space/White space appears before a column name
Submitted: 13 Jun 2016 19:15 Modified: 14 Jun 2016 3:31
Reporter: Manoj Durisheti Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Server: DDL Severity:S3 (Non-critical)
Version:5.6.14 OS:Any
Assigned to: CPU Architecture:Any
Tags: columnname, space

[13 Jun 2016 19:15] Manoj Durisheti 
Description:
Table DDL allows to add a space/white space before a column name. Our DBA's accidentally created a table with one such column that has a space in front of the column name (example: 'table_name. job_category' instead of 'table_name.job_category'). Please fix this. Throw an error if possible when some one is creating such column.

How to repeat:
please create a DDL as below. I believe our DBAs have some automated tools to create DDLs and run them on the DB. In any case automated/manual table creation process, I believe, mysql should not allow space before a column name.

Create table tablename
(
` job_category` int
)
;
[14 Jun 2016 3:31] MySQL Verification Team 
Thank you for taking the time to write to us, but this is not a bug. Please double-check the documentation available at http://dev.mysql.com/doc/refman/5.6/en/identifiers.html and the instructions on how to report a bug at http://bugs.mysql.com/how-to-report.php