MySQL Bugs: #20244: Column named "release"

Bug #20244	Column named "release"
Submitted:	3 Jun 2006 8:50	Modified:	3 Jun 2006 11:28
Reporter:	Patrik Carlsson	Email Updates:
Status:	Not a Bug	Impact on me:	None
Category:	MySQL Server	Severity:	S3 (Non-critical)
Version:	Ver 14.12 Distrib 5.0.21	OS:	Linux (Ubuntu 6.06)
Assigned to:		CPU Architecture:	Any

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

Description:
If you have a column named "release" in a table, there's many things you can't do with it. Some examples: You can't rename the column, or select from the table using where release = 'something';
Maybe it's something new i have missed in mysql 5, but sounds strange if you can create a column named release, but can't fully use it?

/Patrik

How to repeat:
see above.

Hello Patrik,

This is not a bug. 'release' is a reserved word and you should quote reserved words with backticks.
http://dev.mysql.com/doc/refman/5.0/en/reserved-words.html