[MDEV-14371] Unable to select field named window - syntax error Created: 2017-11-12  Updated: 2017-12-07  Resolved: 2017-12-07

Status: Closed
Project: MariaDB Server
Component/s: Documentation
Affects Version/s: 10.2.10
Fix Version/s: N/A

Type: Bug Priority: Minor
Reporter: Alex Assignee: Ian Gilfillan
Resolution: Fixed Votes: 0
Labels: None
Environment:

CentOS 7


 Description   

Hello,
We've just upgraded to 10.2.10 and found out that selecting a field named window leads to syntax error:

> select window from table;
 
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 from table' at line 1


> select `window` from table;
 
Empty set (0.00 sec)



 Comments   
Comment by Elena Stepanova [ 2017-11-12 ]

WINDOW was added to the list of reserved words in scope of MDEV-6115. It is also a reserved word in SQL standard, so I don't see a bug here.
It should, however, be reflected in the KB and currently it's not.

Comment by Alex [ 2017-11-12 ]

Hi Elena,
I thought about something like that but couldn't find any reference, so thought it might be a bug.

Thanks!

Alex

Comment by Ian Gilfillan [ 2017-12-07 ]

This has been documented on https://mariadb.com/kb/en/library/reserved-words/

Generated at Thu Feb 08 08:13:02 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.