Hi folks
I am trying to evaluate infobright and ran into an issue right away with a create table.
CREATE TABLE t (
id bigint not null auto_increment,
token varchar(64) NOT NULL,
constraint pk_t primary key (id)
)engine=brighthouse;

This gives me an error

“ERROR 1070 (42000): Too many key parts specified; max 0 parts allowed”

Am I making a mistake? Is auto increment supported in ICE?

At another level, I would like to know if people are using ICE (or even the Enterprise edition) in production and if so how is their experience.

A quick response would be appreciated.

Thanx!

Hi !
auto increment is not supported in ICE. There are some links in the forum to the docs describing what is the supported SQL subset.

IS it supported in Enterprise Edition? Thanx for a quick response!

Menon

Hello Menon,

ICE uses a meta data layer called the Knowledge Grid to represent the data contained in the warehouse. The Infobright Optimizer executes queries against the Knowledge Grid to determine what data needs to be de-compressed to fulfill the query. The results of this is that ICE does not use or support indexing/keys, and as an extension does not support Auto Increment. This is true of all versions of Infobright, both ICE and IEE.

Kind regards,
Andrew

Thanx Andrew
That answers my question.