maria-developers team mailing list archive

[Jocelyn Fournier <jocelyn.fournier@xxxxxxxxxxxxxx>]

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 ?

(it's mentionned here : 
http://dev.mysql.com/doc/mysqld-version-reference/en/mysqld-version-reference-reservedwords-5-6.html#ftn.idm47406466381872 
)

Is there a specific KB entry for MariaDB 10.0.6 reserved words ? (I only 
see an entry for 5.5 here : https://mariadb.com/kb/en/reserved-words/ )

Thanks and regards,
  Jocelyn Fournier