Details
-
Bug
-
Status: Closed (View Workflow)
-
Minor
-
Resolution: Fixed
-
10.2(EOL), 10.3(EOL)
-
None
-
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