MySQL Bugs: #71635: Using "Window" as a column name results in strange error condition

Bug #71635	Using "Window" as a column name results in strange error condition
Submitted:	8 Feb 2014 13:18	Modified:	9 Feb 2014 13:49
Reporter:	James NOT_FOUND	Email Updates:
Status:	Can't repeat	Impact on me:	None
Category:	MySQL Server: Errors	Severity:	S3 (Non-critical)
Version:	5.5	OS:	Any
Assigned to:		CPU Architecture:	Any
Tags:	column names, reserved words

Description:
When creating a column with the name "Window" which is not in the reserved word list, the server creates the column in information schema but does not populate the column in the actual table in the database. If you try to add it again, because it doesn't show up in the list of database columns, the server will report a duplicate column error. Happens under WinXP Pro and Ubuntu Linux 12.0.4 and with master slave replication.

How to repeat:
Create a column with the name "Window" in any table.

Please check for SQL RESERVED WORDS:

https://drupal.org/node/141051

813 WINDOW

use `WINDOW`if it works.

Thanks.

But it is not listed here:
https://dev.mysql.com/doc/refman/5.5/en/reserved-words.html

Peter
(not a MySQL/Oracle person).

Not reproducible for me:

SELECT VERSION(); -- 5.5.35  

CREATE TABLE window (id INT, window VARCHAR(10)); - success

SHOW CREATE TABLE window;
/* returns

CREATE TABLE `window` (
  `id` int(11) DEFAULT NULL,
  `window` varchar(10) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8
*/

mysql> create table tbx (window int);
Query OK, 0 rows affected (0.42 sec)

mysql> insert into tbx values (1);
Query OK, 1 row affected (0.11 sec)

mysql> select * from tbx;
+--------+
| window |
+--------+
|      1 |
+--------+
1 row in set (0.00 sec)