Re: [Maria-developers] Why reserved keywords: UTC_TIME, UTC_DATE, UTC_DATETIME

Hi, Alexander! On Apr 24, Alexander Barkov wrote:

Hello,

I noticed that UTC_TIME, UTC_DATE, UTC_DATETIME are reserved keywords:

MariaDB [test]> SELECT * FROM utc_time; 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 'utc_time' at line 1

I think they should not.

agree

- These keywords are not mentioned in the SQL standard - They are not involved in any complex grammar that would prevent them from being non-reserved keywords

Looks like a bug...

Any objections to make them non-reserved keywords in 10.2?

Not from me :) Regards, Sergei Chief Architect MariaDB and security@mariadb.org