← Back to team overview

maria-developers team mailing list archive

Re: 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.


> - 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 :)

Chief Architect MariaDB
and security@xxxxxxxxxxx