Creating Unique Indexes

Hi All,

I'm trying to create a unique index on an attribute using the below DQL:

EXECUTE make_index WITH type_name='mytest_obj', attribute='testattribute_id', is_unique=true;

This creates the index successfully but when I look at the underlying database I see that the index is NONUNIQUE.

Furthermore, the DQL reference manuals state the keyword to use is 'unique=true' but this actually throws an error and I have to use 'is_unique=true'

Any ideas what I'm doing wrong here?

Any feedback appreciated.

Thanks,

Eoghan

Find more posts tagged with

Comments

mszurap

Hi,

What error is thrown?

If you create the index directly in the database, is it created without errors? Maybe your attribute already contains non-unique values...

todwyer

Thanks for the reply.

No error is thrown, it successfully creates the index but it is non-unique. There is no data in the object so that is not the cause of the index being created as non-unique.

I have tried some different syntax but the result is the same - the index is created but it is non-unique:

EXECUTE make_index WITH type_name='ectest_obj', attribute='r_name', is_unique=1;

EXECUTE make_index WITH type_name='ectest_obj', attribute='r_lockedid', is_unique='T';

If I create the index directly on the database, it successfully creates a unique index.

Thanks,

Eoghan

Wiesnoepersad

Try the next:

apply,c,NULL,MAKE_INDEX,TYPE_NAME,S,ECTEST_OBJ,ATTRIBUTE,S,r_name,UNIQUE,B,T,INDEX_SPACE,S,<tblspc_name>

next,c,q0

dump,c,q0

get,c,q0

close,c,q0