Details
-
Type:
Bug
-
Status: Closed (View Workflow)
-
Priority:
Minor
-
Resolution: Fixed
-
Affects Version/s: 10.2, 10.3
-
Fix Version/s: 10.2.12
-
Component/s: Data Definition - Alter Table, Optimizer - Window functions
-
Labels:None
-
Environment:official MariaDB docker container on Debian 8 (jessie)
Description
When I try to make a table with a column called "window" I get the following error:
mysql> CREATE TABLE door (id INT, window VARCHAR(10)); |
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'window VARCHAR(10))' at line 1 |
If I do the same with another column name it works though:
mysql> CREATE TABLE door (id INT, door VARCHAR(10)); |
Query OK, 0 rows affected (0.04 sec) |
If I look at the reserved keywords: https://mariadb.com/kb/en/mariadb/reserved-words/ "window" doesn't appear to be listed there.
I use the official mariadb docker image without any custom config changes. Tested in an empty database.
Attachments
Issue Links
- relates to
-
MDEV-12809 Bad column type created for TEXT(1431655798) CHARACTER SET utf8
-
- Closed
-