← Back to team overview

maria-developers team mailing list archive

Re: Why reserved keywords: UTC_TIME, UTC_DATE, UTC_DATETIME


Hi, Colin!

On Apr 25, Colin Charles wrote:
> > On 24 Apr 2016, at 19:43, Peter Laursen <peter_laursen@xxxxxxxxxx> wrote:
> > 
> > They are listed as reserved words in MySQL documentation for any version from 5.0 and up (at least):
> > https://dev.mysql.com/doc/refman/5.0/en/keywords.html.
> > 
> > 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.

This change should not cause any compatibility issues.

> I’m with Peter here - maybe one should also file a bug with MySQL to
> find out why they have done so before it is removed in MariaDB Server
> 10.2 ?

Nah, not this time.
It was done by Dmitry Lenev in 2003 on his second month in MySQL AB.
You can as well ask me or Bar :)
(MySQL AB back then was probably smaller than MariaDB Corporation now,
and everyone knew what everyone else is doing, so we should know)

And as far as I an concerned, I'm pretty sure it was implemented that
way unintentionally. An omission, an easy mistake.

Chief Architect MariaDB
and security@xxxxxxxxxxx

Follow ups