MySQL Bugs: #62324: Table name "signal" not allowed?

Bug #62324	Table name "signal" not allowed?
Submitted:	1 Sep 2011 14:57	Modified:	1 Sep 2011 15:33
Reporter:	Georg Gut	Email Updates:
Status:	Not a Bug	Impact on me:	None
Category:	MySQL Server: DDL	Severity:	S2 (Serious)
Version:	5.5.15	OS:	Windows (7)
Assigned to:		CPU Architecture:	Any
Tags:	table name signal

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

Description:
I tried to create a table named signal and always get an error regarding my syntax.

So something like "CREATE TABLE signal (testcolumn INT)" does not work, whereas "CREATE TABLE myDB.signal (....)" does.

Same behaviour with DROP, INSERT, ... statements.

Other table names work properly, for example "signals" or "signjal" ...

Can you help me on that?

Regards,
Georg

How to repeat:
Just set up a query.

SIGNAL is a reserved word in MySQL 5.5. Read http://dev.mysql.com/doc/refman/5.5/en/reserved-words.html.