What namespace is your element and attribute in, and what namespace is your range index in? It looks (according to the query trace) like both the element and the attribute are in the http://tpox-benchmark.com/custacc namespace, but the first query is requesting the id attribute in no namespace. Maybe somewhere here lies the clue? Do you have any default namespaces in play here?
-Danny -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Ling Ling Sent: Wednesday, May 05, 2010 3:53 PM To: [email protected] Subject: [MarkLogic Dev General] attribute range index Hello, I have a question about query and attribute range query I have a customer xml file stored in database and an attribute range index on Customer id, if my query is like: for $cust in doc() where $cust/Customer/@id = 1002 return $cust The range index is not used and the trace file is here: Info: benchHttp: line 7: xdmp:eval("xquery version "1.0-ml"; (: buffer 2 :) &...", (), <options xmlns="xdmp:eval"><root>benchHttp</root><isolation>different-transaction</isolatio...</options>) Info: benchHttp: line 7: Analyzing path for $cust: fn:doc() Info: benchHttp: line 7: Step 1 is searchable: fn:doc() Info: benchHttp: line 7: Path is fully searchable. Info: benchHttp: line 7: Gathering constraints. Info: benchHttp: line 7: Step 1 contributed 1 constraint: fn:doc() Info: benchHttp: line 8: Comparison contributed hash value constraint: Customer/@id = 1002 Info: benchHttp: line 7: Where clause contributed 2 constraints for $cust: $cust/Customer/@id = 1002 Info: benchHttp: line 7: Executing search. Info: benchHttp: line 7: Selected 1 fragment to filter If I wrote query like this: cts:search(doc()/Customer, cts:element-attribute-range-query(xs:QName("Customer"), xs:QName("id"), "=" ,1002)) xdmp:query-trace(true()),( cts:search(doc()/Customer, cts:element-attribute-range-query(xs:QName("Customer"), xs:QName("id"), "=" ,1002)) ) The index is used but no results returned. Here is the trace file: line 7: xdmp:eval("xquery version "1.0-ml"; (: buffer 2 :) &...", (), <options xmlns="xdmp:eval"><root>benchHttp</root><isolation>different-transaction</isolatio...</options>) line 7: Analyzing path for search: fn:doc()/Customer line 7: Step 1 is searchable: fn:doc() line 7: Step 2 is searchable: Customer line 7: Path is fully searchable. line 7: Gathering constraints. line 7: Step 2 test contributed 1 constraint: Customer line 7: Comparison contributed int range value constraint: Customer/@id = 1002 line 7: Search query contributed 1 constraint: cts:element-attribute-range-query(fn:QName("http://tpox-benchmark.com/custacc";, "Customer"), fn:QName("http://tpox-benchmark.com/custacc";, "id"), "=", 1002, (), 1) line 7: Executing search. line 7: Selected 0 fragments to filter Could you show me the reason? Thank you very much! Regards, Ling _______________________________________________ General mailing list [email protected] http://developer.marklogic.com/mailman/listinfo/general _______________________________________________ General mailing list [email protected] http://developer.marklogic.com/mailman/listinfo/general
