Bug #9202 PRIVILEGES is not listed as a reserved word

• Submitted: 15 Mar 2005 18:12
• Modified: 17 Mar 2005 4:12
• Reporter: Mark Leith
• Status: Not a Bug
• Category: MySQL Server: Documentation
• Severity: S3 (Non-critical)
• Version: All
• OS: Any (Any)
• CPU Architecture: Any

[15 Mar 2005 18:12] Mark Leith

Description:
PRIVILEGES is not listed in the reserved word section of the manual.

How to repeat:
create table foo (privileges int);

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 'privi
leges int)' at line 1

Suggested fix:
Add PRIVILEGES to http://dev.mysql.com/doc/mysql/en/Reserved_words.html

[15 Mar 2005 21:25] Paul DuBois

This appears to be version-specific. PRIVILEGES is not
reserved in MySQL 5.0 and the statement works without
error.

[17 Mar 2005 4:12] Jorge del Conde

Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1 to server version: 5.0.3-alpha

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> create table privileges (a int);
Query OK, 0 rows affected (0.01 sec)

mysql>