`key` fails as a column name

2 posts / 0 new
Last post
ljackson
ljackson's picture
Offline
Last seen: 4 years 5 months ago
Joined: Feb 12 2010
Junior Boarder

Posts: 2

Leif Jackson
`key` fails as a column name

Seems possible is related to the bug for `date` as a column name?

mysql> CREATE TABLE `test` ( `key` int) ENGINE=InfiniDB;
ERROR 138 (HY000): The syntax or the data type(s) is not supported by InfiniDB. Please check the InfiniDB syntax guide for supported syntax or data types.
mysql> CREATE TABLE `test` ( `test_key` int) ENGINE=InfiniDB;
Query OK, 0 rows affected (0.59 sec)

davidhill
davidhill's picture
Offline
Last seen: 1 month 3 weeks ago
Joined: Oct 27 2009
Administrator

Posts: 595

david hill
Re:`key` fails as a column name

Thanks for checking out InfiniDB and providing feedback in your posts.

You are correct, "key" is the same as "date' where it's a protected word that doesn't currently work as a column name.

We will update the associated BUG for tracking purposes.

Thanks again for the input.