← Back to team overview

maria-developers team mailing list archive

Re: Why reserved keywords: UTC_TIME, UTC_DATE, UTC_DATETIME


They are listed as reserved words in MySQL documentation for any version
from 5.0 and up (at least):

I think compablity with MySQL here is an even or a more valid/important
concern here than standards' compliance.
This is actually a minor issue with standards in MySQL ( + derivates ) as
compared to lots of other non-compliances IMO.
If standards should decide there would never have been MySQL!

Anyway it is not a big deal whether ON or OFF, I think.

But maybe the parser require them as reserved for some casesdue to
imperfections in the parser itself?  This could be why they were made
That sould at least be checked carefully before changing anything.

-- Peter
-- Webyog

On Sun, Apr 24, 2016 at 1:13 PM, Alexander Barkov <bar@xxxxxxxxxxx> 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?
> _______________________________________________
> Mailing list: https://launchpad.net/~maria-developers
> Post to     : maria-developers@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~maria-developers
> More help   : https://help.launchpad.net/ListHelp

Follow ups