Bug #34862 log_output needs TABLE quoted, but not FILE

• Submitted: 26 Feb 2008 20:44
• Modified: 23 Sep 2008 7:07
• Reporter: Tobias Asplund
• Status: Not a Bug
• Category: MySQL Server
• Severity: S3 (Non-critical)
• Version: 5.1.23/6.0
• OS: Any
• CPU Architecture: Any

[26 Feb 2008 20:44] Tobias Asplund

Description:
Inconsistency in quoting with log_output when set from a client.

How to repeat:
mysql> SET GLOBAL log_output=FILE;
Query OK, 0 rows affected (0.05 sec)

mysql> SET GLOBAL log_output=TABLE;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TABLE' at line 1
mysql> SET GLOBAL log_output='TABLE';
Query OK, 0 rows affected (0.01 sec)

[26 Feb 2008 20:52] MySQL Verification Team

Thank you for the bug report.

[26 Feb 2008 20:55] Paul DuBois

Presumably because TABLE is a reserved word and FILE is not.

http://dev.mysql.com/doc/refman/5.1/en/reserved-words.html