Error:
Interrupted.
Compiling:
- pre-evaluating db:open("large_products")
- applying attribute index for $diffCatId_0
- inlining $diffCatId_0
Query:
declare namespace p = "a:b:c"; declare variable $prods := /products/*[@catid]; let $diffCatId := distinct-values($prods/@catid) let $catGroup := db:open('large_products')/products/p:category[@id = $diffCatId] return $prods[@catid = $catGroup/@id]
Optimized Query:
let $catGroup_1 := db:attribute("large_products", distinct-values((db:open-pre("large_products",3300002), ...)/@catid))/self::id/parent::p:category[parent::products/parent::document-node()] return ((db:open-pre("large_products",3300002), ...))[(@catid = $catGroup_1/@id)]
Query plan:
<QueryPlan compiled="true">
  <GFLWOR>
    <Let>
      <Var name="$catGroup" id="1"/>
      <CachedPath>
        <ValueAccess data="large_products" type="ATTRIBUTE">
          <FnDistinctValues name="distinct-values(items[,collation])">
            <CachedPath>
              <ItemSeq size="100723">
                <DBNode name="large_products" pre="3300002"/>
                <DBNode name="large_products" pre="3300005"/>
                <DBNode name="large_products" pre="3300008"/>
                <DBNode name="large_products" pre="3300011"/>
                <DBNode name="large_products" pre="3300014"/>
              </ItemSeq>
              <IterStep axis="attribute" test="catid"/>
            </CachedPath>
          </FnDistinctValues>
        </ValueAccess>
        <IterStep axis="self" test="id"/>
        <IterStep axis="parent" test="p:category">
          <CachedPath>
            <IterStep axis="parent" test="products"/>
            <IterStep axis="parent" test="document-node()"/>
          </CachedPath>
        </IterStep>
      </CachedPath>
    </Let>
    <IterFilter>
      <ItemSeq size="100723">
        <DBNode name="large_products" pre="3300002"/>
        <DBNode name="large_products" pre="3300005"/>
        <DBNode name="large_products" pre="3300008"/>
        <DBNode name="large_products" pre="3300011"/>
        <DBNode name="large_products" pre="3300014"/>
      </ItemSeq>
      <CmpG op="=">
        <CachedPath>
          <IterStep axis="attribute" test="catid"/>
        </CachedPath>
        <CachedPath>
          <VarRef>
            <Var name="$catGroup" id="1"/>
          </VarRef>
          <IterStep axis="attribute" test="id"/>
        </CachedPath>
      </CmpG>
    </IterFilter>
  </GFLWOR>
</QueryPlan>