Re: Create Index in ndbcluster engine

[ze ze]

Hi,

The DDL that i use to generate the table is the following:

CREATE TABLE IF NOT EXISTS DOCUMENT_ACRONYM_SEARCH
(
DOCUMENT_ID INT NOT NULL COMMENT 'Identificador do Documento',
CODE VARCHAR(20) COMMENT 'Código da Versão do Documento',
MAIN_ACRONYM VARCHAR(100) COMMENT 'Descrição Acrónimo Principal',
SECUNDARY_ACRONYMS VARCHAR(4000) COMMENT 'Descrição Acrónimos Secundários',
ALL_ACRONYMS VARCHAR(4000) COMMENT 'Descrição Acrónimo Principal mais Acrónimos Secundários',
CONSTRAINT PK_DOCUMENT_ACRONYM_SEARCH PRIMARY KEY (DOCUMENT_ID),
INDEX IDX_DOCACRSCH_01 (CODE ASC) ,
INDEX IDX_DOCACRSCH_02 (MAIN_ACRONYM ASC) ,
INDEX IDX_DOCACRSCH_03 (SECUNDARY_ACRONYMS ASC) ,
INDEX IDX_DOCACRSCH_04 (ALL_ACRONYMS ASC) ,
CONSTRAINT FK_DOCACRSCH_01 FOREIGN KEY (DOCUMENT_ID) REFERENCES DOCUMENT (DOCUMENT_ID) ON DELETE NO ACTION ON UPDATE NO ACTION
)
ENGINE = NDBCLUSTER,
COMMENT = 'Tabela de Pesquisas de Acrónimos de Documentos';

If i comment the lines

INDEX IDX_DOCACRSCH_03 (SECUNDARY_ACRONYMS ASC) ,
INDEX IDX_DOCACRSCH_04 (ALL_ACRONYMS ASC) ,

the table is created without any problem so i assume that the error is because the index creation.

Thanks for your response and i hope that you could help me on this one