Bug #31127 Unable to create table with the name inout

• Submitted: 21 Sep 2007 11:08
• Modified: 21 Sep 2007 11:51
• Reporter: Sylecn Song
• Status: Not a Bug
• Category: MySQL Server
• Severity: S3 (Non-critical)
• Version: 5.0.38-Ubuntu_0ubuntu1-log
• OS: Linux
• CPU Architecture: Any

[21 Sep 2007 11:08] Sylecn Song

Description:
Unable to create table with the name inout.

My system infomation:
$ uname -a
Linux sylecn 2.6.20-16-generic #2 SMP Fri Aug 31 00:55:27 UTC 2007 i686 GNU/Linux

$ mysqld --version
mysqld  Ver 5.0.38-Ubuntu_0ubuntu1-log for pc-linux-gnu on i486 (Ubuntu 7.04 distribution)

$ mysql --version
mysql  Ver 14.12 Distrib 5.0.38, for pc-linux-gnu (i486) using readline 5.2

$  echo $LANG
zh_CN.UTF-8

-------------------
Error message post below on "How to repeat".

Also I found Bug #12325: Unable to create table with the name nu. 
(But I cann't reopen it.)
Since mysql server and client version has grown, I don't think it is the same bug.  I can see the error message is different.

How to repeat:
$ mysql -u root -p

mysql> CREATE DATABASE tempdb;
Query OK, 1 row affected (0.00 sec)

mysql> use tempdb;
Database changed
mysql> CREATE TABLE testtable
    ->        (
    ->            id CHAR(10)
    ->        );
Query OK, 0 rows affected (0.10 sec)

mysql> CREATE TABLE inout
    ->        (
    ->            id CHAR(10)
    ->        );
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 'inout
       (
           id CHAR(10)
       )' at line 1

[21 Sep 2007 11:51] MySQL Verification Team

Thank you for the bug report.

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

[miguel@skybr 5.0]$ bin/mysql -uroot test
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.0.50-debug Source distribution

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

mysql> create table `inout` (id char(10));
Query OK, 0 rows affected (0.54 sec