← Back to team overview

maria-developers team mailing list archive

Re: Why reserved keywords: UTC_TIME, UTC_DATE, UTC_DATETIME


Hi, Bar!

I personally believe this bikeshed color issue has got an unreasonable
amount of attention. But anyway, let's listen to our community and not
fix this bug in 10.2. We can get back to it again later, e.g. in 10.3

Meanwhile, everyone who cares to comment on the synax, is welcome to
have an opinion on https://jira.mariadb.org/browse/MDEV-7773 -
that syntax is something we need to decide on fairly soon.
And the better the syntax will be... well, the better :)

So, please, do have an opinion and comment. Here or in Jira.

Chief Architect MariaDB
and security@xxxxxxxxxxx

On Apr 28, Jean-François Gagné wrote:
> On 2016-04-24 20:31, 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.  If standards should
> >> decide there would never have been MySQL!
> > 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 ?
> I am also with Peter and with Colin's 1st opinion.
> I also saw Sergei mail which I interpret as a wish to go forward on 
> removing the reserved words and Colin's reply about agreeing with this.  
> This seems precipitated to me.
> Opening a bug upstream is the least of things to do to get a minimal 
> amount of feedback.  Blogging about it would be a good 2nd step to get 
> opinion (and buy-in) from the community.  Opening a low priority MDEV 
> stating that this will be done in 10.3 is also another way to get feedback.
> I was at a BOF about MySQL 5.8 at Percona Live, we discussed about 
> adding reserved words, not removing them (I cannot recall the motivation 
> for it).
> What is the rush in doing that in 10.2 ?  Is this an important thing to 
> do now ?
> And more importantly, does MariaDB really want to go in the direction 
> "locking" user in by opening the possibility of having application 
> working with MariaDB but not with MySQL on such a trivial thing ?
> I personally have no strong objection about removing those reserved 
> keywords (if they will also be removed from MySQL), but not without 
> first widening the discussion.  But please do not ask me to lead the 
> effort on getting consensus, I have more important things to do.
> Best regards,
> Jean-François Gagné
> System Engineer
> Booking.com BV
> Rembrandt Square Office
> Herengracht 597, 1017 CE Amsterdam