Bug #4567 Can't create a table named log
Submitted: 15 Jul 2004 18:56 Modified: 15 Jul 2004 19:25
Reporter: Will Hoffman Email Updates:
Status: Can't repeat Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version:4.1.3 OS:Linux (SuSE Linux)
Assigned to: Dean Ellis CPU Architecture:Any

[15 Jul 2004 18:56] Will Hoffman 
Description:
When I try to create a table named 'log' I get an error saying my syntax is wrong.  If I change the table name then the table gets created.

How to repeat:
Try creating a table named log.

Suggested fix:
Either document sorts of table names that are not allowed or allow this table name.  I can create a table named log in 4.0.
[15 Jul 2004 19:25] Dean Ellis 
I cannot repeat:

mysql> CREATE TABLE log ( a int );
Query OK, 0 rows affected (0.02 sec)

Perhaps you have no space between log and the parenthesis and it thinks you are using the log() function.