Hi,
I¹ve some difficulties in ordering a search using a string element range
index.
This is my element range index config :
* Scalar type : string
* Namespace URI : (empty)
* Localname : atl
* Collation : http://marklogic.com/collation/
Here is my query :
xdmp:query-trace(true()),
(for $res in //article order by $res/fm/atl return $res)[1]
Here is the log :
2008-02-22 07:46:03.448 Info: Docs: line 3:
xdmp:eval(" xdmp:query-trace(true()), ((for $res in
//art...", (), <options
xmlns="xdmp:eval"><database>1615150627559396969</database><modules>0</module
s><roo...</options>)
2008-02-22 07:46:03.448 Info: Docs: line 3: Analyzing path for $res:
collection()/descendant::article
2008-02-22 07:46:03.448 Info: Docs: line 3: Step 1 is searchable:
collection()
2008-02-22 07:46:03.448 Info: Docs: line 3: Step 2 is searchable:
descendant::article
2008-02-22 07:46:03.448 Info: Docs: line 3: Path is fully searchable.
2008-02-22 07:46:03.448 Info: Docs: line 3: Gathering constraints.
2008-02-22 07:46:03.448 Info: Docs: line 3: Step 2 test contributed 1
constraint: article
2008-02-22 07:46:03.448 Info: Docs: line 3: Order by clause contributed 1
range ordering constraint for $res: order by $res/child::fm/child::atl
ascending
2008-02-22 07:46:03.448 Info: Docs: line 3: Executing search.
2008-02-22 07:46:03.450 Info: Docs: line 3: Selected 1232 fragments to
filter.
But I get this :
ERROR: eval-in Test at file:./Docs
XDMP-EXPNTREECACHEFULL: for $res as item()* in
collection()/descendant::article -- Expanded tree cache full on host
devexist.nature.com
Stack trace:
line 3:
1:
2: xdmp:query-trace(true()),
3: ((for $res in //article order by $res/fm/atl return $res)[1])
4:
5:
xdmp:eval(" xdmp:query-trace(true()), ((for $res in
//art...", (), <options
xmlns="xdmp:eval"><database>1615150627559396969</database><modules>0</module
s><roo...</options>)
in /cq/eval.xqy line 111:
I¹ve also defined an int range index on another field and when I order on
this field it works fine (the log tells me as well that the range index is
being used).
There must something wrong in my server config but I really don¹t know where
to look at. I¹ve followed the performance guide and everything look fine.
Any idea ?
Thanks,
Bruno
********************************************************************************
DISCLAIMER: This e-mail is confidential and should not be used by anyone who is
not the original intended recipient. If you have received this e-mail in error
please inform the sender and delete it from your mailbox or any other storage
mechanism. Neither Macmillan Publishers Limited nor any of its agents accept
liability for any statements made which are clearly the sender's own and not
expressly made on behalf of Macmillan Publishers Limited or one of its agents.
Please note that neither Macmillan Publishers Limited nor any of its agents
accept any responsibility for viruses that may be contained in this e-mail or
its attachments and it is your responsibility to scan the e-mail and
attachments (if any). No contracts may be concluded on behalf of Macmillan
Publishers Limited or its agents by means of e-mail communication. Macmillan
Publishers Limited Registered in England and Wales with registered number
785998
Registered Office Brunel Road, Houndmills, Basingstoke RG21 6XS
********************************************************************************
_______________________________________________
General mailing list
[email protected]
http://xqzone.com/mailman/listinfo/general
