maria-developers team mailing list archive

[Alexander Barkov <bar@xxxxxxxxxxx>]

Hi Sergei,

On 11/21/2013 03:51 PM, Sergei Golubchik wrote:
> Hi, Jocelyn!
>
> On Nov 21, Jocelyn Fournier wrote:
> > Hi,
> >
> > I have a query with a column named "get".
> > i.e. SELECT get FROM my_table...
> >
> > It works perfectly in 5.5, but in 10.0.6 it fails :
> >
> > 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 'get FROM my_table' at line 1
> >
> > I assume "get" is a new reserved word, probably inherited from MySQL 5.6
> > memcached support, although memcached is not supported in MariaDB ?
>
> GET comes from GET DIAGNOSTICS statement. And verb keywords are usually
> reserved.
>
> But not all (FLUSH is not). And I've just tried to unreserve GET, it
> didn't break anything. I'll test a bit more and if it'll work, I'll push
> that.

GET is a reserved keyword in the SQL standard:

http://savage.net.au/SQL/sql-2003-2.bnf.html#reserved%20word


Perhaps we should non un-reserve it.


Note, MySQL-5.6 also treats GET as a reserved word.
Why have this incompatibility.

I suggest this just should be documented.


> Regards,
> Sergei
>
> _______________________________________________
> 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