10 Mar 2012 21:42:06,734 GMT INFO  [org.teiid.PLANNER] (Worker274_QueryProcessorQueue36197) 
============================================================================
USER COMMAND:
SELECT XMLELEMENT(NAME metadata, XMLFOREST(objectName AS objectName), (SELECT XMLAGG(XMLELEMENT(NAME subTypes, XMLFOREST(subType))) FROM chorus_metadata.property_filtered AS b WHERE b.objectName = a.objectName)) FROM chorus_metadata.property_filtered AS a GROUP BY objectName LIMIT 1

----------------------------------------------------------------------------
OPTIMIZE: 
SELECT XMLELEMENT(NAME metadata, XMLFOREST(objectName AS objectName), (SELECT XMLAGG(XMLELEMENT(NAME subTypes, XMLFOREST(subType))) FROM chorus_metadata.property_filtered AS b WHERE b.objectName = a.objectName)) FROM chorus_metadata.property_filtered AS a GROUP BY objectName LIMIT 1

----------------------------------------------------------------------------
GENERATE CANONICAL: 
SELECT XMLELEMENT(NAME metadata, XMLFOREST(objectName AS objectName), (SELECT XMLAGG(XMLELEMENT(NAME subTypes, XMLFOREST(subType))) FROM chorus_metadata.property_filtered AS b WHERE b.objectName = a.objectName)) FROM chorus_metadata.property_filtered AS a GROUP BY objectName LIMIT 1

CANONICAL PLAN: 
TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=1, IS_STRICT=true})
  Project(groups=[anon_grp0], props={PROJECT_COLS=[XMLELEMENT(NAME metadata, XMLFOREST(anon_grp0.gcol0 AS objectName), (SELECT XMLAGG(XMLELEMENT(NAME subTypes, XMLFOREST(subType))) FROM chorus_metadata.property_filtered AS b WHERE b.objectName = a.objectName))]})
    Group(groups=[chorus_metadata.property_filtered AS a, anon_grp0], props={GROUP_COLS=[objectName], SYMBOL_MAP={anon_grp0.gcol0=objectName}})
      Source(groups=[chorus_metadata.property_filtered AS a], props={NESTED_COMMAND=/*+ cache */ SELECT * FROM #MAT_CHORUS_METADATA.PROPERTY_FILTERED, SYMBOL_MAP={a.propertyName=#MAT_CHORUS_METADATA.PROPERTY_FILTERED.propertyName, a.objectInstance=#MAT_CHORUS_METADATA.PROPERTY_FILTERED.objectInstance, a.subType=#MAT_CHORUS_METADATA.PROPERTY_FILTERED.subType, a.objectName=#MAT_CHORUS_METADATA.PROPERTY_FILTERED.objectName, a.propertyValue=#MAT_CHORUS_METADATA.PROPERTY_FILTERED.propertyValue}})
        Project(groups=[#MAT_CHORUS_METADATA.PROPERTY_FILTERED], props={PROJECT_COLS=[#MAT_CHORUS_METADATA.PROPERTY_FILTERED.propertyName, #MAT_CHORUS_METADATA.PROPERTY_FILTERED.objectInstance, #MAT_CHORUS_METADATA.PROPERTY_FILTERED.subType, #MAT_CHORUS_METADATA.PROPERTY_FILTERED.objectName, #MAT_CHORUS_METADATA.PROPERTY_FILTERED.propertyValue]})
          Source(groups=[#MAT_CHORUS_METADATA.PROPERTY_FILTERED])


----------------------------------------------------------------------------
OPTIMIZE: 
SELECT XMLAGG(XMLELEMENT(NAME subTypes, XMLFOREST(subType))) FROM chorus_metadata.property_filtered AS b WHERE b.objectName = a.objectName

----------------------------------------------------------------------------
GENERATE CANONICAL: 
SELECT XMLAGG(XMLELEMENT(NAME subTypes, XMLFOREST(subType))) FROM chorus_metadata.property_filtered AS b WHERE b.objectName = a.objectName

CANONICAL PLAN: 
Project(groups=[anon_grp1], props={PROJECT_COLS=[anon_grp1.agg0 AS "xmlagg"]})
  Group(groups=[anon_grp1], props={SYMBOL_MAP={anon_grp1.agg0=XMLAGG(XMLELEMENT(NAME subTypes, XMLFOREST(subType)))}})
    Select(groups=[chorus_metadata.property_filtered AS b], props={SELECT_CRITERIA=b.objectName = a.objectName})
      Source(groups=[chorus_metadata.property_filtered AS b], props={NESTED_COMMAND=/*+ cache */ SELECT * FROM #MAT_CHORUS_METADATA.PROPERTY_FILTERED, SYMBOL_MAP={b.propertyName=#MAT_CHORUS_METADATA.PROPERTY_FILTERED.propertyName, b.objectInstance=#MAT_CHORUS_METADATA.PROPERTY_FILTERED.objectInstance, b.subType=#MAT_CHORUS_METADATA.PROPERTY_FILTERED.subType, b.objectName=#MAT_CHORUS_METADATA.PROPERTY_FILTERED.objectName, b.propertyValue=#MAT_CHORUS_METADATA.PROPERTY_FILTERED.propertyValue}})
        Project(groups=[#MAT_CHORUS_METADATA.PROPERTY_FILTERED], props={PROJECT_COLS=[#MAT_CHORUS_METADATA.PROPERTY_FILTERED.propertyName, #MAT_CHORUS_METADATA.PROPERTY_FILTERED.objectInstance, #MAT_CHORUS_METADATA.PROPERTY_FILTERED.subType, #MAT_CHORUS_METADATA.PROPERTY_FILTERED.objectName, #MAT_CHORUS_METADATA.PROPERTY_FILTERED.propertyValue]})
          Source(groups=[#MAT_CHORUS_METADATA.PROPERTY_FILTERED])


============================================================================
EXECUTING PlaceAccess

AFTER: 
Project(groups=[anon_grp1], props={PROJECT_COLS=[anon_grp1.agg0 AS "xmlagg"]})
  Group(groups=[anon_grp1], props={SYMBOL_MAP={anon_grp1.agg0=XMLAGG(XMLELEMENT(NAME subTypes, XMLFOREST(subType)))}})
    Select(groups=[chorus_metadata.property_filtered AS b], props={SELECT_CRITERIA=b.objectName = a.objectName})
      Source(groups=[chorus_metadata.property_filtered AS b], props={NESTED_COMMAND=/*+ cache */ SELECT * FROM #MAT_CHORUS_METADATA.PROPERTY_FILTERED, SYMBOL_MAP={b.propertyName=#MAT_CHORUS_METADATA.PROPERTY_FILTERED.propertyName, b.objectInstance=#MAT_CHORUS_METADATA.PROPERTY_FILTERED.objectInstance, b.subType=#MAT_CHORUS_METADATA.PROPERTY_FILTERED.subType, b.objectName=#MAT_CHORUS_METADATA.PROPERTY_FILTERED.objectName, b.propertyValue=#MAT_CHORUS_METADATA.PROPERTY_FILTERED.propertyValue}})
        Project(groups=[#MAT_CHORUS_METADATA.PROPERTY_FILTERED], props={PROJECT_COLS=[#MAT_CHORUS_METADATA.PROPERTY_FILTERED.propertyName, #MAT_CHORUS_METADATA.PROPERTY_FILTERED.objectInstance, #MAT_CHORUS_METADATA.PROPERTY_FILTERED.subType, #MAT_CHORUS_METADATA.PROPERTY_FILTERED.objectName, #MAT_CHORUS_METADATA.PROPERTY_FILTERED.propertyValue]})
          Access(groups=[#MAT_CHORUS_METADATA.PROPERTY_FILTERED])
            Source(groups=[#MAT_CHORUS_METADATA.PROPERTY_FILTERED])


============================================================================
EXECUTING AssignOutputElements

AFTER: 
Project(groups=[anon_grp1], props={PROJECT_COLS=[anon_grp1.agg0 AS "xmlagg"], OUTPUT_COLS=[anon_grp1.agg0 AS "xmlagg"]})
  Group(groups=[anon_grp1], props={SYMBOL_MAP={anon_grp1.agg0=XMLAGG(XMLELEMENT(NAME subTypes, XMLFOREST(subType)))}, OUTPUT_COLS=[anon_grp1.agg0]})
    Select(groups=[chorus_metadata.property_filtered AS b], props={SELECT_CRITERIA=b.objectName = a.objectName, OUTPUT_COLS=[subType]})
      Source(groups=[chorus_metadata.property_filtered AS b], props={NESTED_COMMAND=/*+ cache */ SELECT * FROM #MAT_CHORUS_METADATA.PROPERTY_FILTERED, SYMBOL_MAP={b.objectName=#MAT_CHORUS_METADATA.PROPERTY_FILTERED.objectName, b.subType=#MAT_CHORUS_METADATA.PROPERTY_FILTERED.subType}, OUTPUT_COLS=[b.objectName, subType]})
        Project(groups=[#MAT_CHORUS_METADATA.PROPERTY_FILTERED], props={PROJECT_COLS=[#MAT_CHORUS_METADATA.PROPERTY_FILTERED.objectName, #MAT_CHORUS_METADATA.PROPERTY_FILTERED.subType], OUTPUT_COLS=[#MAT_CHORUS_METADATA.PROPERTY_FILTERED.objectName, #MAT_CHORUS_METADATA.PROPERTY_FILTERED.subType]})
          Access(groups=[#MAT_CHORUS_METADATA.PROPERTY_FILTERED], props={OUTPUT_COLS=[#MAT_CHORUS_METADATA.PROPERTY_FILTERED.objectName, #MAT_CHORUS_METADATA.PROPERTY_FILTERED.subType]})
            Source(groups=[#MAT_CHORUS_METADATA.PROPERTY_FILTERED], props={OUTPUT_COLS=[#MAT_CHORUS_METADATA.PROPERTY_FILTERED.objectName, #MAT_CHORUS_METADATA.PROPERTY_FILTERED.subType]})


============================================================================
EXECUTING PushSelectCriteria

AFTER: 
Project(groups=[anon_grp1], props={PROJECT_COLS=[anon_grp1.agg0 AS "xmlagg"], OUTPUT_COLS=[anon_grp1.agg0 AS "xmlagg"]})
  Group(groups=[anon_grp1], props={SYMBOL_MAP={anon_grp1.agg0=XMLAGG(XMLELEMENT(NAME subTypes, XMLFOREST(subType)))}, OUTPUT_COLS=[anon_grp1.agg0]})
    Select(groups=[chorus_metadata.property_filtered AS b], props={SELECT_CRITERIA=b.objectName = a.objectName, OUTPUT_COLS=[subType], IS_PHANTOM=true})
      Source(groups=[chorus_metadata.property_filtered AS b], props={NESTED_COMMAND=/*+ cache */ SELECT * FROM #MAT_CHORUS_METADATA.PROPERTY_FILTERED, SYMBOL_MAP={b.objectName=#MAT_CHORUS_METADATA.PROPERTY_FILTERED.objectName, b.subType=#MAT_CHORUS_METADATA.PROPERTY_FILTERED.subType}, OUTPUT_COLS=[b.objectName, subType]})
        Project(groups=[#MAT_CHORUS_METADATA.PROPERTY_FILTERED], props={PROJECT_COLS=[#MAT_CHORUS_METADATA.PROPERTY_FILTERED.objectName, #MAT_CHORUS_METADATA.PROPERTY_FILTERED.subType], OUTPUT_COLS=[#MAT_CHORUS_METADATA.PROPERTY_FILTERED.objectName, #MAT_CHORUS_METADATA.PROPERTY_FILTERED.subType]})
          Access(groups=[#MAT_CHORUS_METADATA.PROPERTY_FILTERED], props={OUTPUT_COLS=[#MAT_CHORUS_METADATA.PROPERTY_FILTERED.objectName, #MAT_CHORUS_METADATA.PROPERTY_FILTERED.subType], MODEL_ID=__TEMP__})
            Select(groups=[#MAT_CHORUS_METADATA.PROPERTY_FILTERED], props={SELECT_CRITERIA=#MAT_CHORUS_METADATA.PROPERTY_FILTERED.objectName = a.objectName})
              Source(groups=[#MAT_CHORUS_METADATA.PROPERTY_FILTERED], props={OUTPUT_COLS=[#MAT_CHORUS_METADATA.PROPERTY_FILTERED.objectName, #MAT_CHORUS_METADATA.PROPERTY_FILTERED.subType]})


============================================================================
EXECUTING MergeVirtual

AFTER: 
Project(groups=[anon_grp1], props={PROJECT_COLS=[anon_grp1.agg0 AS "xmlagg"], OUTPUT_COLS=[anon_grp1.agg0 AS "xmlagg"]})
  Group(groups=[anon_grp1], props={SYMBOL_MAP={anon_grp1.agg0=XMLAGG(XMLELEMENT(NAME subTypes, XMLFOREST(#MAT_CHORUS_METADATA.PROPERTY_FILTERED.subType)))}, OUTPUT_COLS=[anon_grp1.agg0]})
    Select(groups=[#MAT_CHORUS_METADATA.PROPERTY_FILTERED], props={SELECT_CRITERIA=#MAT_CHORUS_METADATA.PROPERTY_FILTERED.objectName = a.objectName, OUTPUT_COLS=[subType], IS_PHANTOM=true})
      Access(groups=[#MAT_CHORUS_METADATA.PROPERTY_FILTERED], props={OUTPUT_COLS=[#MAT_CHORUS_METADATA.PROPERTY_FILTERED.objectName, #MAT_CHORUS_METADATA.PROPERTY_FILTERED.subType], MODEL_ID=__TEMP__})
        Select(groups=[#MAT_CHORUS_METADATA.PROPERTY_FILTERED], props={SELECT_CRITERIA=#MAT_CHORUS_METADATA.PROPERTY_FILTERED.objectName = a.objectName})
          Source(groups=[#MAT_CHORUS_METADATA.PROPERTY_FILTERED], props={OUTPUT_COLS=[#MAT_CHORUS_METADATA.PROPERTY_FILTERED.objectName, #MAT_CHORUS_METADATA.PROPERTY_FILTERED.subType]})


============================================================================
EXECUTING CleanCriteria

AFTER: 
Project(groups=[anon_grp1], props={PROJECT_COLS=[anon_grp1.agg0 AS "xmlagg"], OUTPUT_COLS=null})
  Group(groups=[anon_grp1], props={SYMBOL_MAP={anon_grp1.agg0=XMLAGG(XMLELEMENT(NAME subTypes, XMLFOREST(#MAT_CHORUS_METADATA.PROPERTY_FILTERED.subType)))}, OUTPUT_COLS=null})
    Access(groups=[#MAT_CHORUS_METADATA.PROPERTY_FILTERED], props={OUTPUT_COLS=null, MODEL_ID=__TEMP__})
      Select(groups=[#MAT_CHORUS_METADATA.PROPERTY_FILTERED], props={SELECT_CRITERIA=#MAT_CHORUS_METADATA.PROPERTY_FILTERED.objectName = a.objectName, OUTPUT_COLS=null})
        Source(groups=[#MAT_CHORUS_METADATA.PROPERTY_FILTERED], props={OUTPUT_COLS=null})


============================================================================
EXECUTING RaiseAccess

AFTER: 
Project(groups=[anon_grp1], props={PROJECT_COLS=[anon_grp1.agg0 AS "xmlagg"], OUTPUT_COLS=null})
  Group(groups=[anon_grp1], props={SYMBOL_MAP={anon_grp1.agg0=XMLAGG(XMLELEMENT(NAME subTypes, XMLFOREST(#MAT_CHORUS_METADATA.PROPERTY_FILTERED.subType)))}, OUTPUT_COLS=null})
    Access(groups=[#MAT_CHORUS_METADATA.PROPERTY_FILTERED], props={OUTPUT_COLS=null, MODEL_ID=__TEMP__})
      Select(groups=[#MAT_CHORUS_METADATA.PROPERTY_FILTERED], props={SELECT_CRITERIA=#MAT_CHORUS_METADATA.PROPERTY_FILTERED.objectName = a.objectName, OUTPUT_COLS=null})
        Source(groups=[#MAT_CHORUS_METADATA.PROPERTY_FILTERED], props={OUTPUT_COLS=null})


============================================================================
EXECUTING PushAggregates

AFTER: 
Project(groups=[anon_grp1], props={PROJECT_COLS=[anon_grp1.agg0 AS "xmlagg"], OUTPUT_COLS=null})
  Group(groups=[anon_grp1], props={SYMBOL_MAP={anon_grp1.agg0=XMLAGG(XMLELEMENT(NAME subTypes, XMLFOREST(#MAT_CHORUS_METADATA.PROPERTY_FILTERED.subType)))}, OUTPUT_COLS=null})
    Access(groups=[#MAT_CHORUS_METADATA.PROPERTY_FILTERED], props={OUTPUT_COLS=null, MODEL_ID=__TEMP__})
      Select(groups=[#MAT_CHORUS_METADATA.PROPERTY_FILTERED], props={SELECT_CRITERIA=#MAT_CHORUS_METADATA.PROPERTY_FILTERED.objectName = a.objectName, OUTPUT_COLS=null})
        Source(groups=[#MAT_CHORUS_METADATA.PROPERTY_FILTERED], props={OUTPUT_COLS=null})


============================================================================
EXECUTING AssignOutputElements

AFTER: 
Project(groups=[anon_grp1], props={PROJECT_COLS=[anon_grp1.agg0 AS "xmlagg"], OUTPUT_COLS=[anon_grp1.agg0 AS "xmlagg"]})
  Group(groups=[anon_grp1], props={SYMBOL_MAP={anon_grp1.agg0=XMLAGG(XMLELEMENT(NAME subTypes, XMLFOREST(#MAT_CHORUS_METADATA.PROPERTY_FILTERED.subType)))}, OUTPUT_COLS=[anon_grp1.agg0]})
    Access(groups=[#MAT_CHORUS_METADATA.PROPERTY_FILTERED], props={OUTPUT_COLS=[#MAT_CHORUS_METADATA.PROPERTY_FILTERED.subType], MODEL_ID=__TEMP__})
      Select(groups=[#MAT_CHORUS_METADATA.PROPERTY_FILTERED], props={SELECT_CRITERIA=#MAT_CHORUS_METADATA.PROPERTY_FILTERED.objectName = a.objectName, OUTPUT_COLS=[#MAT_CHORUS_METADATA.PROPERTY_FILTERED.subType]})
        Source(groups=[#MAT_CHORUS_METADATA.PROPERTY_FILTERED], props={OUTPUT_COLS=[#MAT_CHORUS_METADATA.PROPERTY_FILTERED.objectName, #MAT_CHORUS_METADATA.PROPERTY_FILTERED.subType]})


============================================================================
EXECUTING CalculateCost

AFTER: 
Project(groups=[anon_grp1], props={PROJECT_COLS=[anon_grp1.agg0 AS "xmlagg"], OUTPUT_COLS=[anon_grp1.agg0 AS "xmlagg"], EST_CARDINALITY=1.0, EST_COL_STATS={anon_grp1.agg0 AS "xmlagg"=[1.0, -1.0]}})
  Group(groups=[anon_grp1], props={SYMBOL_MAP={anon_grp1.agg0=XMLAGG(XMLELEMENT(NAME subTypes, XMLFOREST(#MAT_CHORUS_METADATA.PROPERTY_FILTERED.subType)))}, OUTPUT_COLS=[anon_grp1.agg0], EST_CARDINALITY=1.0, EST_COL_STATS={anon_grp1.agg0=[1.0, -1.0]}})
    Access(groups=[#MAT_CHORUS_METADATA.PROPERTY_FILTERED], props={OUTPUT_COLS=[#MAT_CHORUS_METADATA.PROPERTY_FILTERED.subType], MODEL_ID=__TEMP__, EST_CARDINALITY=1311.9027, EST_COL_STATS={#MAT_CHORUS_METADATA.PROPERTY_FILTERED.subType=[-1.0, -1.0]}})
      Select(groups=[#MAT_CHORUS_METADATA.PROPERTY_FILTERED], props={SELECT_CRITERIA=#MAT_CHORUS_METADATA.PROPERTY_FILTERED.objectName = a.objectName, OUTPUT_COLS=[#MAT_CHORUS_METADATA.PROPERTY_FILTERED.subType], EST_CARDINALITY=1311.9027, EST_COL_STATS={#MAT_CHORUS_METADATA.PROPERTY_FILTERED.subType=[-1.0, -1.0]}})
        Source(groups=[#MAT_CHORUS_METADATA.PROPERTY_FILTERED], props={OUTPUT_COLS=[#MAT_CHORUS_METADATA.PROPERTY_FILTERED.objectName, #MAT_CHORUS_METADATA.PROPERTY_FILTERED.subType], EST_COL_STATS={#MAT_CHORUS_METADATA.PROPERTY_FILTERED.objectName=[-1.0, -1.0], #MAT_CHORUS_METADATA.PROPERTY_FILTERED.subType=[-1.0, -1.0]}, EST_CARDINALITY=431616.0})


============================================================================
EXECUTING MergeCriteria

AFTER: 
Project(groups=[anon_grp1], props={PROJECT_COLS=[anon_grp1.agg0 AS "xmlagg"], OUTPUT_COLS=[anon_grp1.agg0 AS "xmlagg"], EST_CARDINALITY=1.0, EST_COL_STATS={anon_grp1.agg0 AS "xmlagg"=[1.0, -1.0]}})
  Group(groups=[anon_grp1], props={SYMBOL_MAP={anon_grp1.agg0=XMLAGG(XMLELEMENT(NAME subTypes, XMLFOREST(#MAT_CHORUS_METADATA.PROPERTY_FILTERED.subType)))}, OUTPUT_COLS=[anon_grp1.agg0], EST_CARDINALITY=1.0, EST_COL_STATS={anon_grp1.agg0=[1.0, -1.0]}})
    Access(groups=[#MAT_CHORUS_METADATA.PROPERTY_FILTERED], props={OUTPUT_COLS=[#MAT_CHORUS_METADATA.PROPERTY_FILTERED.subType], MODEL_ID=__TEMP__, EST_CARDINALITY=1311.9027, EST_COL_STATS={#MAT_CHORUS_METADATA.PROPERTY_FILTERED.subType=[-1.0, -1.0]}})
      Select(groups=[#MAT_CHORUS_METADATA.PROPERTY_FILTERED], props={SELECT_CRITERIA=#MAT_CHORUS_METADATA.PROPERTY_FILTERED.objectName = a.objectName, OUTPUT_COLS=[#MAT_CHORUS_METADATA.PROPERTY_FILTERED.subType], EST_CARDINALITY=1311.9027, EST_COL_STATS={#MAT_CHORUS_METADATA.PROPERTY_FILTERED.subType=[-1.0, -1.0]}})
        Source(groups=[#MAT_CHORUS_METADATA.PROPERTY_FILTERED], props={OUTPUT_COLS=[#MAT_CHORUS_METADATA.PROPERTY_FILTERED.objectName, #MAT_CHORUS_METADATA.PROPERTY_FILTERED.subType], EST_COL_STATS={#MAT_CHORUS_METADATA.PROPERTY_FILTERED.objectName=[-1.0, -1.0], #MAT_CHORUS_METADATA.PROPERTY_FILTERED.subType=[-1.0, -1.0]}, EST_CARDINALITY=431616.0})


============================================================================
EXECUTING PlanSorts

AFTER: 
Project(groups=[anon_grp1], props={PROJECT_COLS=[anon_grp1.agg0 AS "xmlagg"], OUTPUT_COLS=[anon_grp1.agg0 AS "xmlagg"], EST_CARDINALITY=1.0, EST_COL_STATS={anon_grp1.agg0 AS "xmlagg"=[1.0, -1.0]}})
  Group(groups=[anon_grp1], props={SYMBOL_MAP={anon_grp1.agg0=XMLAGG(XMLELEMENT(NAME subTypes, XMLFOREST(#MAT_CHORUS_METADATA.PROPERTY_FILTERED.subType)))}, OUTPUT_COLS=[anon_grp1.agg0], EST_CARDINALITY=1.0, EST_COL_STATS={anon_grp1.agg0=[1.0, -1.0]}})
    Access(groups=[#MAT_CHORUS_METADATA.PROPERTY_FILTERED], props={OUTPUT_COLS=[#MAT_CHORUS_METADATA.PROPERTY_FILTERED.subType], MODEL_ID=__TEMP__, EST_CARDINALITY=1311.9027, EST_COL_STATS={#MAT_CHORUS_METADATA.PROPERTY_FILTERED.subType=[-1.0, -1.0]}})
      Select(groups=[#MAT_CHORUS_METADATA.PROPERTY_FILTERED], props={SELECT_CRITERIA=#MAT_CHORUS_METADATA.PROPERTY_FILTERED.objectName = a.objectName, OUTPUT_COLS=[#MAT_CHORUS_METADATA.PROPERTY_FILTERED.subType], EST_CARDINALITY=1311.9027, EST_COL_STATS={#MAT_CHORUS_METADATA.PROPERTY_FILTERED.subType=[-1.0, -1.0]}})
        Source(groups=[#MAT_CHORUS_METADATA.PROPERTY_FILTERED], props={OUTPUT_COLS=[#MAT_CHORUS_METADATA.PROPERTY_FILTERED.objectName, #MAT_CHORUS_METADATA.PROPERTY_FILTERED.subType], EST_COL_STATS={#MAT_CHORUS_METADATA.PROPERTY_FILTERED.objectName=[-1.0, -1.0], #MAT_CHORUS_METADATA.PROPERTY_FILTERED.subType=[-1.0, -1.0]}, EST_CARDINALITY=431616.0})


============================================================================
EXECUTING CollapseSource

AFTER: 
Project(groups=[anon_grp1], props={PROJECT_COLS=[anon_grp1.agg0 AS "xmlagg"], OUTPUT_COLS=[anon_grp1.agg0 AS "xmlagg"], EST_CARDINALITY=1.0, EST_COL_STATS={anon_grp1.agg0 AS "xmlagg"=[1.0, -1.0]}})
  Group(groups=[anon_grp1], props={SYMBOL_MAP={anon_grp1.agg0=XMLAGG(XMLELEMENT(NAME subTypes, XMLFOREST(#MAT_CHORUS_METADATA.PROPERTY_FILTERED.subType)))}, OUTPUT_COLS=[anon_grp1.agg0], EST_CARDINALITY=1.0, EST_COL_STATS={anon_grp1.agg0=[1.0, -1.0]}})
    Access(groups=[#MAT_CHORUS_METADATA.PROPERTY_FILTERED], props={OUTPUT_COLS=[#MAT_CHORUS_METADATA.PROPERTY_FILTERED.subType], MODEL_ID=__TEMP__, EST_CARDINALITY=1311.9027, EST_COL_STATS={#MAT_CHORUS_METADATA.PROPERTY_FILTERED.subType=[-1.0, -1.0]}, ATOMIC_REQUEST=SELECT #MAT_CHORUS_METADATA.PROPERTY_FILTERED.subType FROM #MAT_CHORUS_METADATA.PROPERTY_FILTERED WHERE #MAT_CHORUS_METADATA.PROPERTY_FILTERED.objectName = a.objectName})


============================================================================
CONVERTING PLAN TREE TO PROCESS TREE

PROCESS PLAN = 
ProjectNode(2) output=[anon_grp1.agg0 AS "xmlagg"] [anon_grp1.agg0 AS "xmlagg"]
  GroupingNode(3) output=[anon_grp1.agg0] null{anon_grp1.agg0=XMLAGG(XMLELEMENT(NAME subTypes, XMLFOREST(#MAT_CHORUS_METADATA.PROPERTY_FILTERED.subType)))}
    AccessNode(4) output=[#MAT_CHORUS_METADATA.PROPERTY_FILTERED.subType] SELECT #MAT_CHORUS_METADATA.PROPERTY_FILTERED.subType FROM #MAT_CHORUS_METADATA.PROPERTY_FILTERED WHERE #MAT_CHORUS_METADATA.PROPERTY_FILTERED.objectName = chorus_metadata.property_filtered.objectName

============================================================================

----------------------------------------------------------------------------
OPTIMIZATION COMPLETE:
PROCESSOR PLAN:
ProjectNode(2) output=[anon_grp1.agg0 AS "xmlagg"] [anon_grp1.agg0 AS "xmlagg"]
  GroupingNode(3) output=[anon_grp1.agg0] null{anon_grp1.agg0=XMLAGG(XMLELEMENT(NAME subTypes, XMLFOREST(#MAT_CHORUS_METADATA.PROPERTY_FILTERED.subType)))}
    AccessNode(4) output=[#MAT_CHORUS_METADATA.PROPERTY_FILTERED.subType] SELECT #MAT_CHORUS_METADATA.PROPERTY_FILTERED.subType FROM #MAT_CHORUS_METADATA.PROPERTY_FILTERED WHERE #MAT_CHORUS_METADATA.PROPERTY_FILTERED.objectName = chorus_metadata.property_filtered.objectName

============================================================================

============================================================================
EXECUTING PlaceAccess

AFTER: 
TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=1, IS_STRICT=true})
  Project(groups=[anon_grp0, chorus_metadata.property_filtered AS a], props={PROJECT_COLS=[XMLELEMENT(NAME metadata, XMLFOREST(anon_grp0.gcol0 AS objectName), (SELECT XMLAGG(XMLELEMENT(NAME subTypes, XMLFOREST(subType))) FROM chorus_metadata.property_filtered AS b WHERE b.objectName = a.objectName))]})
    Group(groups=[chorus_metadata.property_filtered AS a, anon_grp0], props={GROUP_COLS=[objectName], SYMBOL_MAP={anon_grp0.gcol0=objectName}})
      Source(groups=[chorus_metadata.property_filtered AS a], props={NESTED_COMMAND=/*+ cache */ SELECT * FROM #MAT_CHORUS_METADATA.PROPERTY_FILTERED, SYMBOL_MAP={a.propertyName=PROPERTY_FILTERED__1.propertyName, a.objectInstance=PROPERTY_FILTERED__1.objectInstance, a.subType=PROPERTY_FILTERED__1.subType, a.objectName=PROPERTY_FILTERED__1.objectName, a.propertyValue=PROPERTY_FILTERED__1.propertyValue}})
        Project(groups=[#MAT_CHORUS_METADATA.PROPERTY_FILTERED AS PROPERTY_FILTERED__1], props={PROJECT_COLS=[PROPERTY_FILTERED__1.propertyName, PROPERTY_FILTERED__1.objectInstance, PROPERTY_FILTERED__1.subType, PROPERTY_FILTERED__1.objectName, PROPERTY_FILTERED__1.propertyValue]})
          Access(groups=[#MAT_CHORUS_METADATA.PROPERTY_FILTERED AS PROPERTY_FILTERED__1])
            Source(groups=[#MAT_CHORUS_METADATA.PROPERTY_FILTERED AS PROPERTY_FILTERED__1])


============================================================================
EXECUTING AssignOutputElements

AFTER: 
TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=1, IS_STRICT=true, OUTPUT_COLS=[XMLELEMENT(NAME metadata, XMLFOREST(anon_grp0.gcol0 AS objectName), (SELECT XMLAGG(XMLELEMENT(NAME subTypes, XMLFOREST(subType))) FROM chorus_metadata.property_filtered AS b WHERE b.objectName = a.objectName))]})
  Project(groups=[anon_grp0, chorus_metadata.property_filtered AS a], props={PROJECT_COLS=[XMLELEMENT(NAME metadata, XMLFOREST(anon_grp0.gcol0 AS objectName), (SELECT XMLAGG(XMLELEMENT(NAME subTypes, XMLFOREST(subType))) FROM chorus_metadata.property_filtered AS b WHERE b.objectName = a.objectName))], OUTPUT_COLS=[XMLELEMENT(NAME metadata, XMLFOREST(anon_grp0.gcol0 AS objectName), (SELECT XMLAGG(XMLELEMENT(NAME subTypes, XMLFOREST(subType))) FROM chorus_metadata.property_filtered AS b WHERE b.objectName = a.objectName))]})
    Group(groups=[chorus_metadata.property_filtered AS a, anon_grp0], props={GROUP_COLS=[objectName], SYMBOL_MAP={anon_grp0.gcol0=objectName}, OUTPUT_COLS=[anon_grp0.gcol0, a.objectName]})
      Source(groups=[chorus_metadata.property_filtered AS a], props={NESTED_COMMAND=/*+ cache */ SELECT * FROM #MAT_CHORUS_METADATA.PROPERTY_FILTERED, SYMBOL_MAP={a.objectName=PROPERTY_FILTERED__1.objectName}, OUTPUT_COLS=[objectName]})
        Project(groups=[#MAT_CHORUS_METADATA.PROPERTY_FILTERED AS PROPERTY_FILTERED__1], props={PROJECT_COLS=[PROPERTY_FILTERED__1.objectName], OUTPUT_COLS=[PROPERTY_FILTERED__1.objectName]})
          Access(groups=[#MAT_CHORUS_METADATA.PROPERTY_FILTERED AS PROPERTY_FILTERED__1], props={OUTPUT_COLS=[PROPERTY_FILTERED__1.objectName]})
            Source(groups=[#MAT_CHORUS_METADATA.PROPERTY_FILTERED AS PROPERTY_FILTERED__1], props={OUTPUT_COLS=[PROPERTY_FILTERED__1.objectName]})


============================================================================
EXECUTING MergeVirtual

AFTER: 
TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=1, IS_STRICT=true, OUTPUT_COLS=[XMLELEMENT(NAME metadata, XMLFOREST(anon_grp0.gcol0 AS objectName), (SELECT XMLAGG(XMLELEMENT(NAME subTypes, XMLFOREST(subType))) FROM chorus_metadata.property_filtered AS b WHERE b.objectName = a.objectName))]})
  Project(groups=[anon_grp0, #MAT_CHORUS_METADATA.PROPERTY_FILTERED AS PROPERTY_FILTERED__1], props={PROJECT_COLS=[XMLELEMENT(NAME metadata, XMLFOREST(anon_grp0.gcol0 AS objectName), (SELECT XMLAGG(XMLELEMENT(NAME subTypes, XMLFOREST(subType))) FROM chorus_metadata.property_filtered AS b WHERE b.objectName = a.objectName))], OUTPUT_COLS=[XMLELEMENT(NAME metadata, XMLFOREST(anon_grp0.gcol0 AS objectName), (SELECT XMLAGG(XMLELEMENT(NAME subTypes, XMLFOREST(subType))) FROM chorus_metadata.property_filtered AS b WHERE b.objectName = a.objectName))]})
    Group(groups=[anon_grp0, #MAT_CHORUS_METADATA.PROPERTY_FILTERED AS PROPERTY_FILTERED__1], props={GROUP_COLS=[PROPERTY_FILTERED__1.objectName], SYMBOL_MAP={anon_grp0.gcol0=PROPERTY_FILTERED__1.objectName}, OUTPUT_COLS=[anon_grp0.gcol0, a.objectName]})
      Access(groups=[#MAT_CHORUS_METADATA.PROPERTY_FILTERED AS PROPERTY_FILTERED__1], props={OUTPUT_COLS=[PROPERTY_FILTERED__1.objectName]})
        Source(groups=[#MAT_CHORUS_METADATA.PROPERTY_FILTERED AS PROPERTY_FILTERED__1], props={OUTPUT_COLS=[PROPERTY_FILTERED__1.objectName]})


============================================================================
EXECUTING CleanCriteria

AFTER: 
TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=1, IS_STRICT=true, OUTPUT_COLS=null})
  Project(groups=[anon_grp0, #MAT_CHORUS_METADATA.PROPERTY_FILTERED AS PROPERTY_FILTERED__1], props={PROJECT_COLS=[XMLELEMENT(NAME metadata, XMLFOREST(anon_grp0.gcol0 AS objectName), (SELECT XMLAGG(XMLELEMENT(NAME subTypes, XMLFOREST(subType))) FROM chorus_metadata.property_filtered AS b WHERE b.objectName = a.objectName))], OUTPUT_COLS=null})
    Group(groups=[anon_grp0, #MAT_CHORUS_METADATA.PROPERTY_FILTERED AS PROPERTY_FILTERED__1], props={GROUP_COLS=[PROPERTY_FILTERED__1.objectName], SYMBOL_MAP={anon_grp0.gcol0=PROPERTY_FILTERED__1.objectName}, OUTPUT_COLS=null})
      Access(groups=[#MAT_CHORUS_METADATA.PROPERTY_FILTERED AS PROPERTY_FILTERED__1], props={OUTPUT_COLS=null})
        Source(groups=[#MAT_CHORUS_METADATA.PROPERTY_FILTERED AS PROPERTY_FILTERED__1], props={OUTPUT_COLS=null})


============================================================================
EXECUTING RaiseAccess
cannot push group by, since group by is not supported by source Group(groups=[anon_grp0, #MAT_CHORUS_METADATA.PROPERTY_FILTERED AS PROPERTY_FILTERED__1], props={GROUP_COLS=[PROPERTY_FILTERED__1.objectName], SYMBOL_MAP={anon_grp0.gcol0=PROPERTY_FILTERED__1.objectName}, OUTPUT_COLS=null}

AFTER: 
TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=1, IS_STRICT=true, OUTPUT_COLS=null})
  Project(groups=[anon_grp0, #MAT_CHORUS_METADATA.PROPERTY_FILTERED AS PROPERTY_FILTERED__1], props={PROJECT_COLS=[XMLELEMENT(NAME metadata, XMLFOREST(anon_grp0.gcol0 AS objectName), (SELECT XMLAGG(XMLELEMENT(NAME subTypes, XMLFOREST(subType))) FROM chorus_metadata.property_filtered AS b WHERE b.objectName = a.objectName))], OUTPUT_COLS=null})
    Group(groups=[anon_grp0, #MAT_CHORUS_METADATA.PROPERTY_FILTERED AS PROPERTY_FILTERED__1], props={GROUP_COLS=[PROPERTY_FILTERED__1.objectName], SYMBOL_MAP={anon_grp0.gcol0=PROPERTY_FILTERED__1.objectName}, OUTPUT_COLS=null})
      Access(groups=[#MAT_CHORUS_METADATA.PROPERTY_FILTERED AS PROPERTY_FILTERED__1], props={OUTPUT_COLS=null, MODEL_ID=__TEMP__})
        Source(groups=[#MAT_CHORUS_METADATA.PROPERTY_FILTERED AS PROPERTY_FILTERED__1], props={OUTPUT_COLS=null})


============================================================================
EXECUTING PushAggregates

AFTER: 
TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=1, IS_STRICT=true, OUTPUT_COLS=null})
  Project(groups=[anon_grp0, #MAT_CHORUS_METADATA.PROPERTY_FILTERED AS PROPERTY_FILTERED__1], props={PROJECT_COLS=[XMLELEMENT(NAME metadata, XMLFOREST(anon_grp0.gcol0 AS objectName), (SELECT XMLAGG(XMLELEMENT(NAME subTypes, XMLFOREST(subType))) FROM chorus_metadata.property_filtered AS b WHERE b.objectName = a.objectName))], OUTPUT_COLS=null})
    Group(groups=[anon_grp0, #MAT_CHORUS_METADATA.PROPERTY_FILTERED AS PROPERTY_FILTERED__1], props={GROUP_COLS=[PROPERTY_FILTERED__1.objectName], SYMBOL_MAP={anon_grp0.gcol0=PROPERTY_FILTERED__1.objectName}, OUTPUT_COLS=null})
      Access(groups=[#MAT_CHORUS_METADATA.PROPERTY_FILTERED AS PROPERTY_FILTERED__1], props={OUTPUT_COLS=null, MODEL_ID=__TEMP__})
        Source(groups=[#MAT_CHORUS_METADATA.PROPERTY_FILTERED AS PROPERTY_FILTERED__1], props={OUTPUT_COLS=null})


============================================================================
EXECUTING PushLimit

AFTER: 
Project(groups=[anon_grp0, #MAT_CHORUS_METADATA.PROPERTY_FILTERED AS PROPERTY_FILTERED__1], props={PROJECT_COLS=[XMLELEMENT(NAME metadata, XMLFOREST(anon_grp0.gcol0 AS objectName), (SELECT XMLAGG(XMLELEMENT(NAME subTypes, XMLFOREST(subType))) FROM chorus_metadata.property_filtered AS b WHERE b.objectName = a.objectName))], OUTPUT_COLS=null})
  TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=1, IS_STRICT=true, OUTPUT_COLS=null})
    Group(groups=[anon_grp0, #MAT_CHORUS_METADATA.PROPERTY_FILTERED AS PROPERTY_FILTERED__1], props={GROUP_COLS=[PROPERTY_FILTERED__1.objectName], SYMBOL_MAP={anon_grp0.gcol0=PROPERTY_FILTERED__1.objectName}, OUTPUT_COLS=null})
      Access(groups=[#MAT_CHORUS_METADATA.PROPERTY_FILTERED AS PROPERTY_FILTERED__1], props={OUTPUT_COLS=null, MODEL_ID=__TEMP__})
        Source(groups=[#MAT_CHORUS_METADATA.PROPERTY_FILTERED AS PROPERTY_FILTERED__1], props={OUTPUT_COLS=null})


============================================================================
EXECUTING AssignOutputElements

AFTER: 
Project(groups=[anon_grp0, #MAT_CHORUS_METADATA.PROPERTY_FILTERED AS PROPERTY_FILTERED__1], props={PROJECT_COLS=[XMLELEMENT(NAME metadata, XMLFOREST(anon_grp0.gcol0 AS objectName), (SELECT XMLAGG(XMLELEMENT(NAME subTypes, XMLFOREST(subType))) FROM chorus_metadata.property_filtered AS b WHERE b.objectName = a.objectName))], OUTPUT_COLS=[XMLELEMENT(NAME metadata, XMLFOREST(anon_grp0.gcol0 AS objectName), (SELECT XMLAGG(XMLELEMENT(NAME subTypes, XMLFOREST(subType))) FROM chorus_metadata.property_filtered AS b WHERE b.objectName = a.objectName))]})
  TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=1, IS_STRICT=true, OUTPUT_COLS=[anon_grp0.gcol0, PROPERTY_FILTERED__1.objectName]})
    Group(groups=[anon_grp0, #MAT_CHORUS_METADATA.PROPERTY_FILTERED AS PROPERTY_FILTERED__1], props={GROUP_COLS=[PROPERTY_FILTERED__1.objectName], SYMBOL_MAP={anon_grp0.gcol0=PROPERTY_FILTERED__1.objectName}, OUTPUT_COLS=[anon_grp0.gcol0, PROPERTY_FILTERED__1.objectName]})
      Access(groups=[#MAT_CHORUS_METADATA.PROPERTY_FILTERED AS PROPERTY_FILTERED__1], props={OUTPUT_COLS=[PROPERTY_FILTERED__1.objectName], MODEL_ID=__TEMP__})
        Source(groups=[#MAT_CHORUS_METADATA.PROPERTY_FILTERED AS PROPERTY_FILTERED__1], props={OUTPUT_COLS=[PROPERTY_FILTERED__1.objectName]})


============================================================================
EXECUTING CalculateCost

AFTER: 
Project(groups=[anon_grp0, #MAT_CHORUS_METADATA.PROPERTY_FILTERED AS PROPERTY_FILTERED__1], props={PROJECT_COLS=[XMLELEMENT(NAME metadata, XMLFOREST(anon_grp0.gcol0 AS objectName), (SELECT XMLAGG(XMLELEMENT(NAME subTypes, XMLFOREST(subType))) FROM chorus_metadata.property_filtered AS b WHERE b.objectName = a.objectName))], OUTPUT_COLS=[XMLELEMENT(NAME metadata, XMLFOREST(anon_grp0.gcol0 AS objectName), (SELECT XMLAGG(XMLELEMENT(NAME subTypes, XMLFOREST(subType))) FROM chorus_metadata.property_filtered AS b WHERE b.objectName = a.objectName))], EST_CARDINALITY=1.0, EST_COL_STATS={XMLELEMENT(NAME metadata, XMLFOREST(anon_grp0.gcol0 AS objectName), (SELECT XMLAGG(XMLELEMENT(NAME subTypes, XMLFOREST(subType))) FROM chorus_metadata.property_filtered AS b WHERE b.objectName = a.objectName))=[1.0, -1.0]}})
  TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=1, IS_STRICT=true, OUTPUT_COLS=[anon_grp0.gcol0, PROPERTY_FILTERED__1.objectName], EST_CARDINALITY=1.0, EST_COL_STATS={anon_grp0.gcol0=[1.0, -1.0], PROPERTY_FILTERED__1.objectName=[-1.0, -1.0]}})
    Group(groups=[anon_grp0, #MAT_CHORUS_METADATA.PROPERTY_FILTERED AS PROPERTY_FILTERED__1], props={GROUP_COLS=[PROPERTY_FILTERED__1.objectName], SYMBOL_MAP={anon_grp0.gcol0=PROPERTY_FILTERED__1.objectName}, OUTPUT_COLS=[anon_grp0.gcol0, PROPERTY_FILTERED__1.objectName], EST_CARDINALITY=215808.0, EST_COL_STATS={anon_grp0.gcol0=[71936.0, -1.0], PROPERTY_FILTERED__1.objectName=[-1.0, -1.0]}})
      Access(groups=[#MAT_CHORUS_METADATA.PROPERTY_FILTERED AS PROPERTY_FILTERED__1], props={OUTPUT_COLS=[PROPERTY_FILTERED__1.objectName], MODEL_ID=__TEMP__, EST_CARDINALITY=431616.0, EST_COL_STATS={PROPERTY_FILTERED__1.objectName=[-1.0, -1.0]}})
        Source(groups=[#MAT_CHORUS_METADATA.PROPERTY_FILTERED AS PROPERTY_FILTERED__1], props={OUTPUT_COLS=[PROPERTY_FILTERED__1.objectName], EST_COL_STATS={PROPERTY_FILTERED__1.objectName=[-1.0, -1.0]}, EST_CARDINALITY=431616.0})


============================================================================
EXECUTING PlanSorts

AFTER: 
Project(groups=[anon_grp0, #MAT_CHORUS_METADATA.PROPERTY_FILTERED AS PROPERTY_FILTERED__1], props={PROJECT_COLS=[XMLELEMENT(NAME metadata, XMLFOREST(anon_grp0.gcol0 AS objectName), (SELECT XMLAGG(XMLELEMENT(NAME subTypes, XMLFOREST(subType))) FROM chorus_metadata.property_filtered AS b WHERE b.objectName = a.objectName))], OUTPUT_COLS=[XMLELEMENT(NAME metadata, XMLFOREST(anon_grp0.gcol0 AS objectName), (SELECT XMLAGG(XMLELEMENT(NAME subTypes, XMLFOREST(subType))) FROM chorus_metadata.property_filtered AS b WHERE b.objectName = a.objectName))], EST_CARDINALITY=1.0, EST_COL_STATS={XMLELEMENT(NAME metadata, XMLFOREST(anon_grp0.gcol0 AS objectName), (SELECT XMLAGG(XMLELEMENT(NAME subTypes, XMLFOREST(subType))) FROM chorus_metadata.property_filtered AS b WHERE b.objectName = a.objectName))=[1.0, -1.0]}})
  TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=1, IS_STRICT=true, OUTPUT_COLS=[anon_grp0.gcol0, PROPERTY_FILTERED__1.objectName], EST_CARDINALITY=1.0, EST_COL_STATS={anon_grp0.gcol0=[1.0, -1.0], PROPERTY_FILTERED__1.objectName=[-1.0, -1.0]}})
    Group(groups=[anon_grp0, #MAT_CHORUS_METADATA.PROPERTY_FILTERED AS PROPERTY_FILTERED__1], props={GROUP_COLS=[PROPERTY_FILTERED__1.objectName], SYMBOL_MAP={anon_grp0.gcol0=PROPERTY_FILTERED__1.objectName}, OUTPUT_COLS=[anon_grp0.gcol0, PROPERTY_FILTERED__1.objectName], EST_CARDINALITY=215808.0, EST_COL_STATS={anon_grp0.gcol0=[71936.0, -1.0], PROPERTY_FILTERED__1.objectName=[-1.0, -1.0]}})
      Access(groups=[#MAT_CHORUS_METADATA.PROPERTY_FILTERED AS PROPERTY_FILTERED__1], props={OUTPUT_COLS=[PROPERTY_FILTERED__1.objectName], MODEL_ID=__TEMP__, EST_CARDINALITY=431616.0, EST_COL_STATS={PROPERTY_FILTERED__1.objectName=[-1.0, -1.0]}})
        Source(groups=[#MAT_CHORUS_METADATA.PROPERTY_FILTERED AS PROPERTY_FILTERED__1], props={OUTPUT_COLS=[PROPERTY_FILTERED__1.objectName], EST_COL_STATS={PROPERTY_FILTERED__1.objectName=[-1.0, -1.0]}, EST_CARDINALITY=431616.0})


============================================================================
EXECUTING CollapseSource

AFTER: 
Project(groups=[anon_grp0, #MAT_CHORUS_METADATA.PROPERTY_FILTERED AS PROPERTY_FILTERED__1], props={PROJECT_COLS=[XMLELEMENT(NAME metadata, XMLFOREST(anon_grp0.gcol0 AS objectName), (SELECT XMLAGG(XMLELEMENT(NAME subTypes, XMLFOREST(subType))) FROM chorus_metadata.property_filtered AS b WHERE b.objectName = a.objectName))], OUTPUT_COLS=[XMLELEMENT(NAME metadata, XMLFOREST(anon_grp0.gcol0 AS objectName), (SELECT XMLAGG(XMLELEMENT(NAME subTypes, XMLFOREST(subType))) FROM chorus_metadata.property_filtered AS b WHERE b.objectName = a.objectName))], EST_CARDINALITY=1.0, EST_COL_STATS={XMLELEMENT(NAME metadata, XMLFOREST(anon_grp0.gcol0 AS objectName), (SELECT XMLAGG(XMLELEMENT(NAME subTypes, XMLFOREST(subType))) FROM chorus_metadata.property_filtered AS b WHERE b.objectName = a.objectName))=[1.0, -1.0]}})
  TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=1, IS_STRICT=true, OUTPUT_COLS=[anon_grp0.gcol0, PROPERTY_FILTERED__1.objectName], EST_CARDINALITY=1.0, EST_COL_STATS={anon_grp0.gcol0=[1.0, -1.0], PROPERTY_FILTERED__1.objectName=[-1.0, -1.0]}})
    Group(groups=[anon_grp0, #MAT_CHORUS_METADATA.PROPERTY_FILTERED AS PROPERTY_FILTERED__1], props={GROUP_COLS=[PROPERTY_FILTERED__1.objectName], SYMBOL_MAP={anon_grp0.gcol0=PROPERTY_FILTERED__1.objectName}, OUTPUT_COLS=[anon_grp0.gcol0, PROPERTY_FILTERED__1.objectName], EST_CARDINALITY=215808.0, EST_COL_STATS={anon_grp0.gcol0=[71936.0, -1.0], PROPERTY_FILTERED__1.objectName=[-1.0, -1.0]}})
      Access(groups=[#MAT_CHORUS_METADATA.PROPERTY_FILTERED AS PROPERTY_FILTERED__1], props={OUTPUT_COLS=[PROPERTY_FILTERED__1.objectName], MODEL_ID=__TEMP__, EST_CARDINALITY=431616.0, EST_COL_STATS={PROPERTY_FILTERED__1.objectName=[-1.0, -1.0]}, ATOMIC_REQUEST=SELECT PROPERTY_FILTERED__1.objectName FROM #MAT_CHORUS_METADATA.PROPERTY_FILTERED AS PROPERTY_FILTERED__1})


============================================================================
CONVERTING PLAN TREE TO PROCESS TREE

PROCESS PLAN = 
ProjectNode(5) output=[XMLELEMENT(NAME metadata, XMLFOREST(anon_grp0.gcol0 AS objectName), (SELECT XMLAGG(XMLELEMENT(NAME subTypes, XMLFOREST(subType))) FROM chorus_metadata.property_filtered AS b WHERE b.objectName = a.objectName))] [XMLELEMENT(NAME metadata, XMLFOREST(anon_grp0.gcol0 AS objectName), (SELECT XMLAGG(XMLELEMENT(NAME subTypes, XMLFOREST(subType))) FROM chorus_metadata.property_filtered AS b WHERE b.objectName = a.objectName))]
  LimitNode(6) output=[anon_grp0.gcol0, PROPERTY_FILTERED__1.objectName] limit 1
    GroupingNode(7) output=[anon_grp0.gcol0, PROPERTY_FILTERED__1.objectName] [PROPERTY_FILTERED__1.objectName]{anon_grp0.gcol0=PROPERTY_FILTERED__1.objectName}
      AccessNode(8) output=[PROPERTY_FILTERED__1.objectName] SELECT #MAT_CHORUS_METADATA.PROPERTY_FILTERED.objectName FROM #MAT_CHORUS_METADATA.PROPERTY_FILTERED

============================================================================

----------------------------------------------------------------------------
OPTIMIZATION COMPLETE:
PROCESSOR PLAN:
ProjectNode(5) output=[XMLELEMENT(NAME metadata, XMLFOREST(anon_grp0.gcol0 AS objectName), (SELECT XMLAGG(XMLELEMENT(NAME subTypes, XMLFOREST(subType))) FROM chorus_metadata.property_filtered AS b WHERE b.objectName = a.objectName))] [XMLELEMENT(NAME metadata, XMLFOREST(anon_grp0.gcol0 AS objectName), (SELECT XMLAGG(XMLELEMENT(NAME subTypes, XMLFOREST(subType))) FROM chorus_metadata.property_filtered AS b WHERE b.objectName = a.objectName))]
  LimitNode(6) output=[anon_grp0.gcol0, PROPERTY_FILTERED__1.objectName] limit 1
    GroupingNode(7) output=[anon_grp0.gcol0, PROPERTY_FILTERED__1.objectName] [PROPERTY_FILTERED__1.objectName]{anon_grp0.gcol0=PROPERTY_FILTERED__1.objectName}
      AccessNode(8) output=[PROPERTY_FILTERED__1.objectName] SELECT #MAT_CHORUS_METADATA.PROPERTY_FILTERED.objectName FROM #MAT_CHORUS_METADATA.PROPERTY_FILTERED

============================================================================

10 Mar 2012 21:42:06,741 GMT ERROR [org.teiid.PROCESSOR] (Worker274_QueryProcessorQueue36197) Unexpected exception for request TZ4qMAkGIAh1.0
java.lang.NullPointerException
	at org.teiid.query.processor.relational.GroupingNode.initialize(GroupingNode.java:197)
	at org.teiid.query.processor.relational.RelationalPlan.connectExternal(RelationalPlan.java:117)
	at org.teiid.query.processor.relational.RelationalPlan.connectExternal(RelationalPlan.java:122)
	at org.teiid.query.processor.relational.RelationalPlan.connectExternal(RelationalPlan.java:122)
	at org.teiid.query.processor.relational.RelationalPlan.initialize(RelationalPlan.java:112)
	at org.teiid.query.processor.QueryProcessor.init(QueryProcessor.java:176)
	at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:126)
	at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:105)
	at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:147)
	at org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:374)
	at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:287)
	at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:49)
	at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:215)
	at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:232)
	at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:118)
	at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:288)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1121)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:614)
	at java.lang.Thread.run(Thread.java:769)