MySQL Bugs: #75277: White Space

Bug #75277	White Space
Submitted:	19 Dec 2014 16:57	Modified:	19 Dec 2014 18:37
Reporter:	Matti Ressler	Email Updates:
Status:	Not a Bug	Impact on me:	None
Category:	MySQL Server	Severity:	S2 (Serious)
Version:		OS:	Any
Assigned to:		CPU Architecture:	Any

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

Description:
MySQL allow whitespace before or after a column name (and probably elsewhere)

This can easily happen inadvertently for example when using a tool such as phpMyAdmin.

It should be standard practice to trim white space.

How to repeat:
Create a column name containing white space before or after the column name.

Suggested fix:
Trim whitespace

Thank you for the report.

When you create column using MySQL command line client and don't put column name into quotes the client trims white-spaces. So this is bug in phpMyAdmin, not in MySQL server.