← Back to team overview

maria-developers team mailing list archive

Why reserved keywords: UTC_TIME, UTC_DATE, UTC_DATETIME



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.

- 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?

Follow ups