← Back to team overview

maria-developers team mailing list archive

Re: get is now a reserved word in mariadb 10 ?

 

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.

Regards,
Sergei


Follow ups

References