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
-
-
- Closed
-
Activity
I've tried a bit to make the grammar work with un-reserving the keyword. It doesn't seem to be possible (or I haven't found a good solution yet).
Thanks for the update. The ISO standard costs real money, unfortunately, but according to https://www.postgresql.org/docs/9.6/static/sql-keywords-appendix.html WINDOW has actually been reserved since SQL:2008.
ErikCederstrand I'm working on a fix that will allow usage of WINDOW as an identifier except in Table Aliases. We can't guarantee if this will remain permanent for all future versions (10.4, etc) but 10.2 and 10.3 should have it.
Fixed by allowing a workaround within the grammar. The fix was suggested by monty. Window can not be used as a table alias, as it would make the following statement ambiguous:
SELECT *
FROM t1
WINDOW ...
However, we are able to use WINDOW in all other contexts, so we allow it.
8cee2f136d7cccb4bf8d6ac4ecfc224a495b9cec
window is a reserved word in the latest SQL:2016 standard. And, looking at the parser, I don't see how we can "un-reserve" it, if we do, the grammar would become ambiguous.