Starting with indexing

[Joseba Umbelina]

Hi, can someone tell me if this indexing is correct?

1. With a lot of queries like "//termEntry" and some "/count(//termEntry)" :
addindex "" termEntry "node-elemment-presence-none"

2. And like this: "//termEntry[@id='$tid']" :
addindex "" id "node-attribute-equality-string"

The id attribute is unique but a ' addindex "" id
"unique-node-attribute-equality-string" ' fails.

Very thanks. Cya




------------------------------------------
To remove yourself from this list, send an
email to xml-unsubscribe@...

[George Feinberg-3]

Joseba,

> Hi, can someone tell me if this indexing is correct?
>
> 1. With a lot of queries like "//termEntry" and some "/count(//
> termEntry)" :
> addindex "" termEntry "node-elemment-presence-none"

Yes.

>
> 2. And like this: "//termEntry[@id='$tid']" :
> addindex "" id "node-attribute-equality-string"

Yes.

>
> The id attribute is unique but a ' addindex "" id "unique-node-
> attribute-equality-string" ' fails.

What fails? the add operation?  It shouldn't.

Regards,

George




------------------------------------------
To remove yourself from this list, send an
email to xml-unsubscribe@...

[Joseba Umbelina]

Thx for answering George.

>>2. And like this: "//termEntry[@id='$tid']" :
>>addindex "" id "node-attribute-equality-string"
>
>Yes.
>
>>
>>The id attribute is unique but a ' addindex "" id "unique-node-
>>attribute-equality-string" ' fails.
>
>What fails? the add operation?  It shouldn't.

dbxml> addindex "" id "unique-node-attribute-equality-string"
Adding index type: unique-node-attribute-equality-string to node: {}:id
stdin:5: addIndex failed, Error: Uniqueness constraint violation for key:
key unique-node-attribute-equality-string id1_=5 Size=40 Occ=e
Hex=3131353236313630323074393530 Text=1152616020t950

I don't understand well what means that error. Isn't other element with that
'1152616020t950' value for the 'id' attribute.




------------------------------------------
To remove yourself from this list, send an
email to xml-unsubscribe@...

[Chris Carlin]

Joseba Umbelina wrote:

> dbxml> addindex "" id "unique-node-attribute-equality-string"
> Adding index type: unique-node-attribute-equality-string to node: {}:id
> stdin:5: addIndex failed, Error: Uniqueness constraint violation for
> key: key unique-node-attribute-equality-string id1_=5 Size=40 Occ=e
> Hex=3131353236313630323074393530 Text=1152616020t950

Are you sure you don't have ANY id attributes that repeat?

~Chris


------------------------------------------
To remove yourself from this list, send an
email to xml-unsubscribe@...

[Joseba Umbelina]

>
>>dbxml> addindex "" id "unique-node-attribute-equality-string"
>>Adding index type: unique-node-attribute-equality-string to node: {}:id
>>stdin:5: addIndex failed, Error: Uniqueness constraint violation for key:
>>key unique-node-attribute-equality-string id1_=5 Size=40 Occ=e
>>Hex=3131353236313630323074393530 Text=1152616020t950
>
>Are you sure you don't have ANY id attributes that repeat?
>
>~Chris

I was wrong, yes they are repeated, not in the same file but yes in the same
container.

Thanks, cya.




------------------------------------------
To remove yourself from this list, send an
email to xml-unsubscribe@...

[George Feinberg-3]

Joseba,

>>> 2. And like this: "//termEntry[@id='$tid']" :
>>> addindex "" id "node-attribute-equality-string"
>>
>> Yes.
>>
>>>
>>> The id attribute is unique but a ' addindex "" id "unique-node-  
>>> attribute-equality-string" ' fails.
>>
>> What fails? the add operation?  It shouldn't.
>
> dbxml> addindex "" id "unique-node-attribute-equality-string"
> Adding index type: unique-node-attribute-equality-string to node:  
> {}:id
> stdin:5: addIndex failed, Error: Uniqueness constraint violation  
> for key: key unique-node-attribute-equality-string id1_=5 Size=40  
> Occ=e Hex=3131353236313630323074393530 Text=1152616020t950
>
> I don't understand well what means that error. Isn't other element  
> with that '1152616020t950' value for the 'id' attribute.

It means that you have a document in the container that
already violates the uniqueness constraint that you are attempting
to add.

Specifically, you have more than one "id" attribute with the
same value.  Uniqueness is container-wide, not document.

Regards,

George




------------------------------------------
To remove yourself from this list, send an
email to xml-unsubscribe@...