← Back to team overview

maria-developers team mailing list archive

Re: merge for MySQL56 temporal literals


> -----Original Message-----
> From: Maria-developers [mailto:maria-developers-
> bounces+wlad=montyprogram.com@xxxxxxxxxxxxxxxxxxx] On Behalf Of
> Alexander Barkov
> Sent: Mittwoch, 3. Juli 2013 10:18
> To: Sergei Golubchik
> Cc: maria-developers@xxxxxxxxxxxxxxxxxxx
> Subject: Re: [Maria-developers] merge for MySQL56 temporal literals

> >> +{d'2001-01-01'},
> >> +{d'2001-01-01 10:10:10'};
> >
> > This (the second value, I mean) is what, backward compatibility?
> These are ODBC escape sequences.
> http://msdn.microsoft.com/en-us/library/ms190234%28v=sql.90%29.aspx
> IIRC, applications like MSQuery and MSAccess use this format.

Bar, in the documentation above, for  ODBC escape sequences  (those are used
in JDBC as well),  there is a space between curly brace and literal type,
and space after the literal type and before ' .

Like, { d '2001-01-01 10:10:10' } has space after '{' and after 'd'.

Maybe the documented form with spaces works with your patch , as well .
however there are no tests that prove it ,i.e all tests have no spaces in
the literals


Follow ups