`date` fails as a column name

3 posts / 0 new
Last post
gtowey
gtowey's picture
Offline
Last seen: 4 years 5 months ago
Joined: Apr 1 2010
Junior Boarder

Posts: 2

Gavin Towey
`date` fails as a column name

CREATE TABLE IF NOT EXISTS `stats` (
`date` date default NULL
) 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.

If I change the column name to anything else, it works. I didn't see this behavior in the documentation. This makes it very hard to migrate existing production data into a warehouse.

Is there a place to post bugs, other than on the forums?

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

Posts: 595

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

Thanks for downloading and checking out InfiniDB.

Sorry to here you are having the issue special names like 'date'.

We have an open BUG for this issue already:

https://bugs.launchpad.net/infinidb/+bug/461510

Users can open up BUGS here and we appreciate any BUGs or feedback to might provide:

https://launchpad.net/infinidb

And within this forum, a user can post suggestion/request:

http://www.infinidb.org/community/forums/3-suggestion-box

By posting to either of these places, this gives us an idea on what enhancements the user community would like to see in our product

David

gtowey
gtowey's picture
Offline
Last seen: 4 years 5 months ago
Joined: Apr 1 2010
Junior Boarder

Posts: 2

Gavin Towey
Re:`date` fails as a column name

Hi David,

Thanks so much for the near-instantaneous feedback! Glad to know you consider it a bug; I'll keep up on it with the link you posted.