2010-11-23 08:59:16,233 DEBUG [org.teiid.COMMAND_LOG] (New I/O server worker #1-2) 	START USER COMMAND:	startTime=2010-11-23 08:59:16.233	requestID=QPjlI18+nKci.8	txID=null	sessionID=QPjlI18+nKci	applicationName=JDBC	principal=pnittel@teiid-security	vdbName=TpcrTest	vdbVersion=1	sql=select * from vTpcr.Q22 ORDER BY cntrycode
2010-11-23 08:59:16,233 DEBUG [org.teiid.PROCESSOR] (New I/O server worker #1-2) after executeRequest : org.teiid.client.util.ResultsFuture@1bd3498
2010-11-23 08:59:16,233 DEBUG [org.teiid.RUNTIME] (Worker8_QueryProcessorQueue268) Beginning work with virtual worker Worker8_QueryProcessorQueue268
2010-11-23 08:59:16,261 DEBUG [org.teiid.PROCESSOR] (Worker8_QueryProcessorQueue268) QPjlI18+nKci.8 start processing MORE_WORK
2010-11-23 08:59:16,261 DEBUG [org.teiid.PROCESSOR] (Worker8_QueryProcessorQueue268) Request Thread QPjlI18+nKci.8 with state NEW
2010-11-23 08:59:16,262 DEBUG [org.teiid.PROCESSOR] (Worker8_QueryProcessorQueue268) QPjlI18+nKci.8 No cache directive
2010-11-23 08:59:16,262 DEBUG [org.teiid.PROCESSOR] (Worker8_QueryProcessorQueue268) QPjlI18+nKci.8 executing  select * from vTpcr.Q22 ORDER BY cntrycode
2010-11-23 08:59:16,262 DEBUG [org.teiid.PLANNER.RESOLVER] (Worker8_QueryProcessorQueue268) Resolving command SELECT * FROM vTpcr.Q22 ORDER BY cntrycode
2010-11-23 08:59:16,279 DEBUG [org.teiid.PLANNER] (Worker8_QueryProcessorQueue268) 
============================================================================
USER COMMAND:
SELECT * FROM vTpcr.Q22 ORDER BY vTpcr.Q22.cntrycode LIMIT 100

----------------------------------------------------------------------------
OPTIMIZE: 
SELECT * FROM vTpcr.Q22 ORDER BY vTpcr.Q22.cntrycode LIMIT 100

----------------------------------------------------------------------------
GENERATE CANONICAL: 
SELECT * FROM vTpcr.Q22 ORDER BY vTpcr.Q22.cntrycode LIMIT 100

CANONICAL PLAN: 
TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=100})
  Sort(groups=[vTpcr.Q22], props={SORT_ORDER=ORDER BY vTpcr.Q22.cntrycode})
    Project(groups=[vTpcr.Q22], props={PROJECT_COLS=[vTpcr.Q22.cntrycode, vTpcr.Q22.numcust, vTpcr.Q22.totacctbal]})
      Source(groups=[vTpcr.Q22], props={SYMBOL_MAP={vTpcr.Q22.cntrycode=cntrycode, vTpcr.Q22.numcust=COUNT(*), vTpcr.Q22.totacctbal=SUM(c_acctbal)}, NESTED_COMMAND=SELECT cntrycode, COUNT(*) AS numcust, SUM(c_acctbal) AS totacctbal FROM (SELECT left(C_PHONE, 2) AS cntrycode, TPCR.CUSTOMER.C_ACCTBAL FROM TPCR.CUSTOMER WHERE (left(C_PHONE, 2) IN ('13', '17', '18', '23', '29', '30', '31')) AND (TPCR.CUSTOMER.C_ACCTBAL > (SELECT AVG(TPCR.CUSTOMER.C_ACCTBAL) FROM TPCR.CUSTOMER WHERE (TPCR.CUSTOMER.C_ACCTBAL > 0E-15) AND (left(C_PHONE, 2) IN ('13', '17', '18', '23', '29', '30', '31')))) AND (NOT (EXISTS (SELECT * FROM TPCR.ORDERS WHERE O_CUSTKEY = C_CUSTKEY)))) AS custsale GROUP BY cntrycode})
        Project(groups=[custsale], props={PROJECT_COLS=[cntrycode, COUNT(*) AS numcust, SUM(c_acctbal) AS totacctbal]})
          Group(groups=[custsale], props={GROUP_COLS=[cntrycode]})
            Source(groups=[custsale], props={SYMBOL_MAP={CUSTSALE.cntrycode=left(C_PHONE, 2), CUSTSALE.C_ACCTBAL=TPCR.CUSTOMER.C_ACCTBAL}, NESTED_COMMAND=SELECT left(C_PHONE, 2) AS cntrycode, TPCR.CUSTOMER.C_ACCTBAL FROM TPCR.CUSTOMER WHERE (left(C_PHONE, 2) IN ('13', '17', '18', '23', '29', '30', '31')) AND (TPCR.CUSTOMER.C_ACCTBAL > (SELECT AVG(TPCR.CUSTOMER.C_ACCTBAL) FROM TPCR.CUSTOMER WHERE (TPCR.CUSTOMER.C_ACCTBAL > 0E-15) AND (left(C_PHONE, 2) IN ('13', '17', '18', '23', '29', '30', '31')))) AND (NOT (EXISTS (SELECT * FROM TPCR.ORDERS WHERE O_CUSTKEY = C_CUSTKEY)))})
              Project(groups=[TPCR.CUSTOMER], props={PROJECT_COLS=[left(C_PHONE, 2) AS cntrycode, TPCR.CUSTOMER.C_ACCTBAL]})
                Select(groups=[], props={SELECT_CRITERIA=NOT (EXISTS (SELECT * FROM TPCR.ORDERS WHERE O_CUSTKEY = C_CUSTKEY))})
                  Select(groups=[TPCR.CUSTOMER], props={SELECT_CRITERIA=TPCR.CUSTOMER.C_ACCTBAL > (SELECT AVG(TPCR.CUSTOMER.C_ACCTBAL) FROM TPCR.CUSTOMER WHERE (TPCR.CUSTOMER.C_ACCTBAL > 0E-15) AND (left(C_PHONE, 2) IN ('13', '17', '18', '23', '29', '30', '31')))})
                    Select(groups=[TPCR.CUSTOMER], props={SELECT_CRITERIA=left(C_PHONE, 2) IN ('13', '17', '18', '23', '29', '30', '31')})
                      Source(groups=[TPCR.CUSTOMER])


----------------------------------------------------------------------------
OPTIMIZE: 
SELECT * FROM TPCR.ORDERS WHERE O_CUSTKEY = C_CUSTKEY

----------------------------------------------------------------------------
GENERATE CANONICAL: 
SELECT * FROM TPCR.ORDERS WHERE O_CUSTKEY = C_CUSTKEY

CANONICAL PLAN: 
Project(groups=[TPCR.ORDERS], props={PROJECT_COLS=[TPCR.ORDERS.O_ORDERKEY, TPCR.ORDERS.O_CUSTKEY, TPCR.ORDERS.O_ORDERSTATUS, TPCR.ORDERS.O_TOTALPRICE, TPCR.ORDERS.O_ORDERDATE, TPCR.ORDERS.O_ORDERPRIORITY, TPCR.ORDERS.O_CLERK, TPCR.ORDERS.O_SHIPPRIORITY, TPCR.ORDERS.O_COMMENT]})
  Select(groups=[TPCR.ORDERS], props={SELECT_CRITERIA=O_CUSTKEY = C_CUSTKEY})
    Source(groups=[TPCR.ORDERS])


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

AFTER: 
Project(groups=[TPCR.ORDERS], props={PROJECT_COLS=[TPCR.ORDERS.O_ORDERKEY, TPCR.ORDERS.O_CUSTKEY, TPCR.ORDERS.O_ORDERSTATUS, TPCR.ORDERS.O_TOTALPRICE, TPCR.ORDERS.O_ORDERDATE, TPCR.ORDERS.O_ORDERPRIORITY, TPCR.ORDERS.O_CLERK, TPCR.ORDERS.O_SHIPPRIORITY, TPCR.ORDERS.O_COMMENT]})
  Select(groups=[TPCR.ORDERS], props={SELECT_CRITERIA=O_CUSTKEY = C_CUSTKEY})
    Access(groups=[TPCR.ORDERS])
      Source(groups=[TPCR.ORDERS])


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

AFTER: 
Project(groups=[TPCR.ORDERS], props={PROJECT_COLS=[TPCR.ORDERS.O_ORDERKEY, TPCR.ORDERS.O_CUSTKEY, TPCR.ORDERS.O_ORDERSTATUS, TPCR.ORDERS.O_TOTALPRICE, TPCR.ORDERS.O_ORDERDATE, TPCR.ORDERS.O_ORDERPRIORITY, TPCR.ORDERS.O_CLERK, TPCR.ORDERS.O_SHIPPRIORITY, TPCR.ORDERS.O_COMMENT]})
  Access(groups=[TPCR.ORDERS], props={MODEL_ID=Schema name=TPCR, nameInSource=null, uuid=mmuuid:ee4db7ad-7aa7-4258-815b-07ed88feca9c})
    Select(groups=[TPCR.ORDERS], props={SELECT_CRITERIA=O_CUSTKEY = C_CUSTKEY})
      Source(groups=[TPCR.ORDERS])


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

AFTER: 
Project(groups=[TPCR.ORDERS], props={PROJECT_COLS=[TPCR.ORDERS.O_ORDERKEY, TPCR.ORDERS.O_CUSTKEY, TPCR.ORDERS.O_ORDERSTATUS, TPCR.ORDERS.O_TOTALPRICE, TPCR.ORDERS.O_ORDERDATE, TPCR.ORDERS.O_ORDERPRIORITY, TPCR.ORDERS.O_CLERK, TPCR.ORDERS.O_SHIPPRIORITY, TPCR.ORDERS.O_COMMENT]})
  Access(groups=[TPCR.ORDERS], props={MODEL_ID=Schema name=TPCR, nameInSource=null, uuid=mmuuid:ee4db7ad-7aa7-4258-815b-07ed88feca9c})
    Select(groups=[TPCR.ORDERS], props={SELECT_CRITERIA=O_CUSTKEY = C_CUSTKEY})
      Source(groups=[TPCR.ORDERS])


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

AFTER: 
Access(groups=[TPCR.ORDERS], props={MODEL_ID=Schema name=TPCR, nameInSource=null, uuid=mmuuid:ee4db7ad-7aa7-4258-815b-07ed88feca9c})
  Project(groups=[TPCR.ORDERS], props={PROJECT_COLS=[TPCR.ORDERS.O_ORDERKEY, TPCR.ORDERS.O_CUSTKEY, TPCR.ORDERS.O_ORDERSTATUS, TPCR.ORDERS.O_TOTALPRICE, TPCR.ORDERS.O_ORDERDATE, TPCR.ORDERS.O_ORDERPRIORITY, TPCR.ORDERS.O_CLERK, TPCR.ORDERS.O_SHIPPRIORITY, TPCR.ORDERS.O_COMMENT]})
    Select(groups=[TPCR.ORDERS], props={SELECT_CRITERIA=O_CUSTKEY = C_CUSTKEY})
      Source(groups=[TPCR.ORDERS])


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

AFTER: 
Access(groups=[TPCR.ORDERS], props={MODEL_ID=Schema name=TPCR, nameInSource=null, uuid=mmuuid:ee4db7ad-7aa7-4258-815b-07ed88feca9c})
  Project(groups=[TPCR.ORDERS], props={PROJECT_COLS=[TPCR.ORDERS.O_ORDERKEY, TPCR.ORDERS.O_CUSTKEY, TPCR.ORDERS.O_ORDERSTATUS, TPCR.ORDERS.O_TOTALPRICE, TPCR.ORDERS.O_ORDERDATE, TPCR.ORDERS.O_ORDERPRIORITY, TPCR.ORDERS.O_CLERK, TPCR.ORDERS.O_SHIPPRIORITY, TPCR.ORDERS.O_COMMENT]})
    Select(groups=[TPCR.ORDERS], props={SELECT_CRITERIA=O_CUSTKEY = C_CUSTKEY})
      Source(groups=[TPCR.ORDERS])


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

AFTER: 
Access(groups=[TPCR.ORDERS], props={EST_CARDINALITY=500000.0, MODEL_ID=Schema name=TPCR, nameInSource=null, uuid=mmuuid:ee4db7ad-7aa7-4258-815b-07ed88feca9c})
  Project(groups=[TPCR.ORDERS], props={PROJECT_COLS=[TPCR.ORDERS.O_ORDERKEY, TPCR.ORDERS.O_CUSTKEY, TPCR.ORDERS.O_ORDERSTATUS, TPCR.ORDERS.O_TOTALPRICE, TPCR.ORDERS.O_ORDERDATE, TPCR.ORDERS.O_ORDERPRIORITY, TPCR.ORDERS.O_CLERK, TPCR.ORDERS.O_SHIPPRIORITY, TPCR.ORDERS.O_COMMENT], EST_CARDINALITY=500000.0})
    Select(groups=[TPCR.ORDERS], props={EST_CARDINALITY=500000.0, SELECT_CRITERIA=O_CUSTKEY = C_CUSTKEY})
      Source(groups=[TPCR.ORDERS], props={EST_CARDINALITY=1500000.0})


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

AFTER: 
Access(groups=[TPCR.ORDERS], props={EST_CARDINALITY=500000.0, MODEL_ID=Schema name=TPCR, nameInSource=null, uuid=mmuuid:ee4db7ad-7aa7-4258-815b-07ed88feca9c, OUTPUT_COLS=[TPCR.ORDERS.O_ORDERKEY, TPCR.ORDERS.O_CUSTKEY, TPCR.ORDERS.O_ORDERSTATUS, TPCR.ORDERS.O_TOTALPRICE, TPCR.ORDERS.O_ORDERDATE, TPCR.ORDERS.O_ORDERPRIORITY, TPCR.ORDERS.O_CLERK, TPCR.ORDERS.O_SHIPPRIORITY, TPCR.ORDERS.O_COMMENT]})
  Project(groups=[TPCR.ORDERS], props={PROJECT_COLS=[TPCR.ORDERS.O_ORDERKEY, TPCR.ORDERS.O_CUSTKEY, TPCR.ORDERS.O_ORDERSTATUS, TPCR.ORDERS.O_TOTALPRICE, TPCR.ORDERS.O_ORDERDATE, TPCR.ORDERS.O_ORDERPRIORITY, TPCR.ORDERS.O_CLERK, TPCR.ORDERS.O_SHIPPRIORITY, TPCR.ORDERS.O_COMMENT], EST_CARDINALITY=500000.0, OUTPUT_COLS=[TPCR.ORDERS.O_ORDERKEY, TPCR.ORDERS.O_CUSTKEY, TPCR.ORDERS.O_ORDERSTATUS, TPCR.ORDERS.O_TOTALPRICE, TPCR.ORDERS.O_ORDERDATE, TPCR.ORDERS.O_ORDERPRIORITY, TPCR.ORDERS.O_CLERK, TPCR.ORDERS.O_SHIPPRIORITY, TPCR.ORDERS.O_COMMENT]})
    Select(groups=[TPCR.ORDERS], props={EST_CARDINALITY=500000.0, SELECT_CRITERIA=O_CUSTKEY = C_CUSTKEY, OUTPUT_COLS=[TPCR.ORDERS.O_ORDERKEY, TPCR.ORDERS.O_CUSTKEY, TPCR.ORDERS.O_ORDERSTATUS, TPCR.ORDERS.O_TOTALPRICE, TPCR.ORDERS.O_ORDERDATE, TPCR.ORDERS.O_ORDERPRIORITY, TPCR.ORDERS.O_CLERK, TPCR.ORDERS.O_SHIPPRIORITY, TPCR.ORDERS.O_COMMENT]})
      Source(groups=[TPCR.ORDERS], props={EST_CARDINALITY=1500000.0, OUTPUT_COLS=[O_CUSTKEY, TPCR.ORDERS.O_ORDERKEY, TPCR.ORDERS.O_ORDERSTATUS, TPCR.ORDERS.O_TOTALPRICE, TPCR.ORDERS.O_ORDERDATE, TPCR.ORDERS.O_ORDERPRIORITY, TPCR.ORDERS.O_CLERK, TPCR.ORDERS.O_SHIPPRIORITY, TPCR.ORDERS.O_COMMENT]})


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

AFTER: 
Access(groups=[TPCR.ORDERS], props={EST_CARDINALITY=500000.0, MODEL_ID=Schema name=TPCR, nameInSource=null, uuid=mmuuid:ee4db7ad-7aa7-4258-815b-07ed88feca9c, OUTPUT_COLS=[TPCR.ORDERS.O_ORDERKEY, TPCR.ORDERS.O_CUSTKEY, TPCR.ORDERS.O_ORDERSTATUS, TPCR.ORDERS.O_TOTALPRICE, TPCR.ORDERS.O_ORDERDATE, TPCR.ORDERS.O_ORDERPRIORITY, TPCR.ORDERS.O_CLERK, TPCR.ORDERS.O_SHIPPRIORITY, TPCR.ORDERS.O_COMMENT]})
  Project(groups=[TPCR.ORDERS], props={PROJECT_COLS=[TPCR.ORDERS.O_ORDERKEY, TPCR.ORDERS.O_CUSTKEY, TPCR.ORDERS.O_ORDERSTATUS, TPCR.ORDERS.O_TOTALPRICE, TPCR.ORDERS.O_ORDERDATE, TPCR.ORDERS.O_ORDERPRIORITY, TPCR.ORDERS.O_CLERK, TPCR.ORDERS.O_SHIPPRIORITY, TPCR.ORDERS.O_COMMENT], EST_CARDINALITY=500000.0, OUTPUT_COLS=[TPCR.ORDERS.O_ORDERKEY, TPCR.ORDERS.O_CUSTKEY, TPCR.ORDERS.O_ORDERSTATUS, TPCR.ORDERS.O_TOTALPRICE, TPCR.ORDERS.O_ORDERDATE, TPCR.ORDERS.O_ORDERPRIORITY, TPCR.ORDERS.O_CLERK, TPCR.ORDERS.O_SHIPPRIORITY, TPCR.ORDERS.O_COMMENT]})
    Select(groups=[TPCR.ORDERS], props={EST_CARDINALITY=500000.0, SELECT_CRITERIA=O_CUSTKEY = C_CUSTKEY, OUTPUT_COLS=[TPCR.ORDERS.O_ORDERKEY, TPCR.ORDERS.O_CUSTKEY, TPCR.ORDERS.O_ORDERSTATUS, TPCR.ORDERS.O_TOTALPRICE, TPCR.ORDERS.O_ORDERDATE, TPCR.ORDERS.O_ORDERPRIORITY, TPCR.ORDERS.O_CLERK, TPCR.ORDERS.O_SHIPPRIORITY, TPCR.ORDERS.O_COMMENT]})
      Source(groups=[TPCR.ORDERS], props={EST_CARDINALITY=1500000.0, OUTPUT_COLS=[O_CUSTKEY, TPCR.ORDERS.O_ORDERKEY, TPCR.ORDERS.O_ORDERSTATUS, TPCR.ORDERS.O_TOTALPRICE, TPCR.ORDERS.O_ORDERDATE, TPCR.ORDERS.O_ORDERPRIORITY, TPCR.ORDERS.O_CLERK, TPCR.ORDERS.O_SHIPPRIORITY, TPCR.ORDERS.O_COMMENT]})


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

AFTER: 
Access(groups=[TPCR.ORDERS], props={EST_CARDINALITY=500000.0, MODEL_ID=Schema name=TPCR, nameInSource=null, uuid=mmuuid:ee4db7ad-7aa7-4258-815b-07ed88feca9c, OUTPUT_COLS=[TPCR.ORDERS.O_ORDERKEY, TPCR.ORDERS.O_CUSTKEY, TPCR.ORDERS.O_ORDERSTATUS, TPCR.ORDERS.O_TOTALPRICE, TPCR.ORDERS.O_ORDERDATE, TPCR.ORDERS.O_ORDERPRIORITY, TPCR.ORDERS.O_CLERK, TPCR.ORDERS.O_SHIPPRIORITY, TPCR.ORDERS.O_COMMENT], ATOMIC_REQUEST=SELECT TPCR.ORDERS.O_ORDERKEY, TPCR.ORDERS.O_CUSTKEY, TPCR.ORDERS.O_ORDERSTATUS, TPCR.ORDERS.O_TOTALPRICE, TPCR.ORDERS.O_ORDERDATE, TPCR.ORDERS.O_ORDERPRIORITY, TPCR.ORDERS.O_CLERK, TPCR.ORDERS.O_SHIPPRIORITY, TPCR.ORDERS.O_COMMENT FROM TPCR.ORDERS WHERE O_CUSTKEY = C_CUSTKEY})


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

PROCESS PLAN = 
AccessNode(1) output=[TPCR.ORDERS.O_ORDERKEY, TPCR.ORDERS.O_CUSTKEY, TPCR.ORDERS.O_ORDERSTATUS, TPCR.ORDERS.O_TOTALPRICE, TPCR.ORDERS.O_ORDERDATE, TPCR.ORDERS.O_ORDERPRIORITY, TPCR.ORDERS.O_CLERK, TPCR.ORDERS.O_SHIPPRIORITY, TPCR.ORDERS.O_COMMENT] SELECT g_0.O_ORDERKEY, g_0.O_CUSTKEY, g_0.O_ORDERSTATUS, g_0.O_TOTALPRICE, g_0.O_ORDERDATE, g_0.O_ORDERPRIORITY, g_0.O_CLERK, g_0.O_SHIPPRIORITY, g_0.O_COMMENT FROM TPCR.ORDERS AS g_0 WHERE g_0.O_CUSTKEY = TPCR.CUSTOMER.C_CUSTKEY

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

----------------------------------------------------------------------------
OPTIMIZATION COMPLETE:
PROCESSOR PLAN:
AccessNode(1) output=[TPCR.ORDERS.O_ORDERKEY, TPCR.ORDERS.O_CUSTKEY, TPCR.ORDERS.O_ORDERSTATUS, TPCR.ORDERS.O_TOTALPRICE, TPCR.ORDERS.O_ORDERDATE, TPCR.ORDERS.O_ORDERPRIORITY, TPCR.ORDERS.O_CLERK, TPCR.ORDERS.O_SHIPPRIORITY, TPCR.ORDERS.O_COMMENT] SELECT g_0.O_ORDERKEY, g_0.O_CUSTKEY, g_0.O_ORDERSTATUS, g_0.O_TOTALPRICE, g_0.O_ORDERDATE, g_0.O_ORDERPRIORITY, g_0.O_CLERK, g_0.O_SHIPPRIORITY, g_0.O_COMMENT FROM TPCR.ORDERS AS g_0 WHERE g_0.O_CUSTKEY = TPCR.CUSTOMER.C_CUSTKEY

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

----------------------------------------------------------------------------
OPTIMIZE: 
SELECT AVG(TPCR.CUSTOMER.C_ACCTBAL) FROM TPCR.CUSTOMER WHERE (TPCR.CUSTOMER.C_ACCTBAL > 0E-15) AND (left(C_PHONE, 2) IN ('13', '17', '18', '23', '29', '30', '31'))

----------------------------------------------------------------------------
GENERATE CANONICAL: 
SELECT AVG(TPCR.CUSTOMER.C_ACCTBAL) FROM TPCR.CUSTOMER WHERE (TPCR.CUSTOMER.C_ACCTBAL > 0E-15) AND (left(C_PHONE, 2) IN ('13', '17', '18', '23', '29', '30', '31'))

CANONICAL PLAN: 
Project(groups=[TPCR.CUSTOMER], props={PROJECT_COLS=[AVG(TPCR.CUSTOMER.C_ACCTBAL)]})
  Group(groups=[])
    Select(groups=[TPCR.CUSTOMER], props={SELECT_CRITERIA=left(C_PHONE, 2) IN ('13', '17', '18', '23', '29', '30', '31')})
      Select(groups=[TPCR.CUSTOMER], props={SELECT_CRITERIA=TPCR.CUSTOMER.C_ACCTBAL > 0E-15})
        Source(groups=[TPCR.CUSTOMER])


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

AFTER: 
Project(groups=[TPCR.CUSTOMER], props={PROJECT_COLS=[AVG(TPCR.CUSTOMER.C_ACCTBAL)]})
  Group(groups=[])
    Select(groups=[TPCR.CUSTOMER], props={SELECT_CRITERIA=left(C_PHONE, 2) IN ('13', '17', '18', '23', '29', '30', '31')})
      Select(groups=[TPCR.CUSTOMER], props={SELECT_CRITERIA=TPCR.CUSTOMER.C_ACCTBAL > 0E-15})
        Access(groups=[TPCR.CUSTOMER])
          Source(groups=[TPCR.CUSTOMER])


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

AFTER: 
Project(groups=[TPCR.CUSTOMER], props={PROJECT_COLS=[AVG(TPCR.CUSTOMER.C_ACCTBAL)]})
  Group(groups=[])
    Access(groups=[TPCR.CUSTOMER], props={MODEL_ID=Schema name=TPCR, nameInSource=null, uuid=mmuuid:ee4db7ad-7aa7-4258-815b-07ed88feca9c})
      Select(groups=[TPCR.CUSTOMER], props={SELECT_CRITERIA=(TPCR.CUSTOMER.C_ACCTBAL > 0E-15) AND (left(C_PHONE, 2) IN ('13', '17', '18', '23', '29', '30', '31'))})
        Source(groups=[TPCR.CUSTOMER])


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

AFTER: 
Project(groups=[TPCR.CUSTOMER], props={PROJECT_COLS=[AVG(TPCR.CUSTOMER.C_ACCTBAL)]})
  Group(groups=[])
    Access(groups=[TPCR.CUSTOMER], props={MODEL_ID=Schema name=TPCR, nameInSource=null, uuid=mmuuid:ee4db7ad-7aa7-4258-815b-07ed88feca9c})
      Select(groups=[TPCR.CUSTOMER], props={SELECT_CRITERIA=(TPCR.CUSTOMER.C_ACCTBAL > 0E-15) AND (left(C_PHONE, 2) IN ('13', '17', '18', '23', '29', '30', '31'))})
        Source(groups=[TPCR.CUSTOMER])


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

AFTER: 
Access(groups=[TPCR.CUSTOMER], props={MODEL_ID=Schema name=TPCR, nameInSource=null, uuid=mmuuid:ee4db7ad-7aa7-4258-815b-07ed88feca9c})
  Project(groups=[TPCR.CUSTOMER], props={PROJECT_COLS=[AVG(TPCR.CUSTOMER.C_ACCTBAL)]})
    Group(groups=[])
      Select(groups=[TPCR.CUSTOMER], props={SELECT_CRITERIA=(TPCR.CUSTOMER.C_ACCTBAL > 0E-15) AND (left(C_PHONE, 2) IN ('13', '17', '18', '23', '29', '30', '31'))})
        Source(groups=[TPCR.CUSTOMER])


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

AFTER: 
Access(groups=[TPCR.CUSTOMER], props={MODEL_ID=Schema name=TPCR, nameInSource=null, uuid=mmuuid:ee4db7ad-7aa7-4258-815b-07ed88feca9c})
  Project(groups=[TPCR.CUSTOMER], props={PROJECT_COLS=[AVG(TPCR.CUSTOMER.C_ACCTBAL)]})
    Group(groups=[])
      Select(groups=[TPCR.CUSTOMER], props={SELECT_CRITERIA=(TPCR.CUSTOMER.C_ACCTBAL > 0E-15) AND (left(C_PHONE, 2) IN ('13', '17', '18', '23', '29', '30', '31'))})
        Source(groups=[TPCR.CUSTOMER])


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

AFTER: 
Access(groups=[TPCR.CUSTOMER], props={MODEL_ID=Schema name=TPCR, nameInSource=null, uuid=mmuuid:ee4db7ad-7aa7-4258-815b-07ed88feca9c})
  Project(groups=[TPCR.CUSTOMER], props={PROJECT_COLS=[AVG(TPCR.CUSTOMER.C_ACCTBAL)]})
    Group(groups=[])
      Select(groups=[TPCR.CUSTOMER], props={SELECT_CRITERIA=(TPCR.CUSTOMER.C_ACCTBAL > 0E-15) AND (left(C_PHONE, 2) IN ('13', '17', '18', '23', '29', '30', '31'))})
        Source(groups=[TPCR.CUSTOMER])


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

AFTER: 
Access(groups=[TPCR.CUSTOMER], props={EST_CARDINALITY=1.0, MODEL_ID=Schema name=TPCR, nameInSource=null, uuid=mmuuid:ee4db7ad-7aa7-4258-815b-07ed88feca9c})
  Project(groups=[TPCR.CUSTOMER], props={PROJECT_COLS=[AVG(TPCR.CUSTOMER.C_ACCTBAL)], EST_CARDINALITY=1.0})
    Group(groups=[], props={EST_CARDINALITY=1.0})
      Select(groups=[TPCR.CUSTOMER], props={EST_CARDINALITY=50000.0, SELECT_CRITERIA=(TPCR.CUSTOMER.C_ACCTBAL > 0E-15) AND (left(C_PHONE, 2) IN ('13', '17', '18', '23', '29', '30', '31'))})
        Source(groups=[TPCR.CUSTOMER], props={EST_CARDINALITY=150000.0})


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

AFTER: 
Access(groups=[TPCR.CUSTOMER], props={EST_CARDINALITY=1.0, MODEL_ID=Schema name=TPCR, nameInSource=null, uuid=mmuuid:ee4db7ad-7aa7-4258-815b-07ed88feca9c, OUTPUT_COLS=[AVG(TPCR.CUSTOMER.C_ACCTBAL)]})
  Project(groups=[TPCR.CUSTOMER], props={PROJECT_COLS=[AVG(TPCR.CUSTOMER.C_ACCTBAL)], EST_CARDINALITY=1.0, OUTPUT_COLS=[AVG(TPCR.CUSTOMER.C_ACCTBAL)]})
    Group(groups=[], props={EST_CARDINALITY=1.0, OUTPUT_COLS=[AVG(TPCR.CUSTOMER.C_ACCTBAL)]})
      Select(groups=[TPCR.CUSTOMER], props={EST_CARDINALITY=50000.0, SELECT_CRITERIA=(TPCR.CUSTOMER.C_ACCTBAL > 0E-15) AND (left(C_PHONE, 2) IN ('13', '17', '18', '23', '29', '30', '31')), OUTPUT_COLS=[TPCR.CUSTOMER.C_ACCTBAL]})
        Source(groups=[TPCR.CUSTOMER], props={EST_CARDINALITY=150000.0, OUTPUT_COLS=[TPCR.CUSTOMER.C_ACCTBAL, C_PHONE]})


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

AFTER: 
Access(groups=[TPCR.CUSTOMER], props={EST_CARDINALITY=1.0, MODEL_ID=Schema name=TPCR, nameInSource=null, uuid=mmuuid:ee4db7ad-7aa7-4258-815b-07ed88feca9c, OUTPUT_COLS=[AVG(TPCR.CUSTOMER.C_ACCTBAL)]})
  Project(groups=[TPCR.CUSTOMER], props={PROJECT_COLS=[AVG(TPCR.CUSTOMER.C_ACCTBAL)], EST_CARDINALITY=1.0, OUTPUT_COLS=[AVG(TPCR.CUSTOMER.C_ACCTBAL)]})
    Group(groups=[], props={EST_CARDINALITY=1.0, OUTPUT_COLS=[AVG(TPCR.CUSTOMER.C_ACCTBAL)]})
      Select(groups=[TPCR.CUSTOMER], props={EST_CARDINALITY=50000.0, SELECT_CRITERIA=(TPCR.CUSTOMER.C_ACCTBAL > 0E-15) AND (left(C_PHONE, 2) IN ('13', '17', '18', '23', '29', '30', '31')), OUTPUT_COLS=[TPCR.CUSTOMER.C_ACCTBAL]})
        Source(groups=[TPCR.CUSTOMER], props={EST_CARDINALITY=150000.0, OUTPUT_COLS=[TPCR.CUSTOMER.C_ACCTBAL, C_PHONE]})


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

AFTER: 
Access(groups=[TPCR.CUSTOMER], props={EST_CARDINALITY=1.0, MODEL_ID=Schema name=TPCR, nameInSource=null, uuid=mmuuid:ee4db7ad-7aa7-4258-815b-07ed88feca9c, OUTPUT_COLS=[AVG(TPCR.CUSTOMER.C_ACCTBAL)], ATOMIC_REQUEST=SELECT AVG(TPCR.CUSTOMER.C_ACCTBAL) FROM TPCR.CUSTOMER WHERE (TPCR.CUSTOMER.C_ACCTBAL > 0E-15) AND (left(C_PHONE, 2) IN ('13', '17', '18', '23', '29', '30', '31'))})


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

PROCESS PLAN = 
AccessNode(2) output=[AVG(TPCR.CUSTOMER.C_ACCTBAL)] SELECT AVG(g_0.C_ACCTBAL) FROM TPCR.CUSTOMER AS g_0 WHERE (g_0.C_ACCTBAL > 0E-15) AND (left(g_0.C_PHONE, 2) IN ('13', '17', '18', '23', '29', '30', '31'))

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

----------------------------------------------------------------------------
OPTIMIZATION COMPLETE:
PROCESSOR PLAN:
AccessNode(2) output=[AVG(TPCR.CUSTOMER.C_ACCTBAL)] SELECT AVG(g_0.C_ACCTBAL) FROM TPCR.CUSTOMER AS g_0 WHERE (g_0.C_ACCTBAL > 0E-15) AND (left(g_0.C_PHONE, 2) IN ('13', '17', '18', '23', '29', '30', '31'))

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

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

AFTER: 
TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=100})
  Sort(groups=[vTpcr.Q22], props={SORT_ORDER=ORDER BY vTpcr.Q22.cntrycode})
    Project(groups=[vTpcr.Q22], props={PROJECT_COLS=[vTpcr.Q22.cntrycode, vTpcr.Q22.numcust, vTpcr.Q22.totacctbal]})
      Source(groups=[vTpcr.Q22], props={SYMBOL_MAP={vTpcr.Q22.cntrycode=cntrycode, vTpcr.Q22.numcust=COUNT(*), vTpcr.Q22.totacctbal=SUM(c_acctbal)}, NESTED_COMMAND=SELECT cntrycode, COUNT(*) AS numcust, SUM(c_acctbal) AS totacctbal FROM (SELECT left(CUSTOMER__1.C_PHONE, 2) AS cntrycode, TPCR.CUSTOMER.C_ACCTBAL FROM TPCR.CUSTOMER WHERE (left(CUSTOMER__1.C_PHONE, 2) IN ('13', '17', '18', '23', '29', '30', '31')) AND (CUSTOMER__1.C_ACCTBAL > (SELECT AVG(TPCR.CUSTOMER.C_ACCTBAL) FROM TPCR.CUSTOMER WHERE (TPCR.CUSTOMER.C_ACCTBAL > 0E-15) AND (left(C_PHONE, 2) IN ('13', '17', '18', '23', '29', '30', '31')))) AND (NOT (EXISTS (SELECT * FROM TPCR.ORDERS WHERE O_CUSTKEY = C_CUSTKEY)))) AS custsale GROUP BY cntrycode})
        Project(groups=[custsale], props={PROJECT_COLS=[cntrycode, COUNT(*) AS numcust, SUM(c_acctbal) AS totacctbal]})
          Group(groups=[custsale], props={GROUP_COLS=[cntrycode]})
            Source(groups=[custsale], props={SYMBOL_MAP={CUSTSALE.cntrycode=left(CUSTOMER__1.C_PHONE, 2), CUSTSALE.C_ACCTBAL=CUSTOMER__1.C_ACCTBAL}, NESTED_COMMAND=SELECT left(CUSTOMER__1.C_PHONE, 2) AS cntrycode, TPCR.CUSTOMER.C_ACCTBAL FROM TPCR.CUSTOMER WHERE (left(CUSTOMER__1.C_PHONE, 2) IN ('13', '17', '18', '23', '29', '30', '31')) AND (CUSTOMER__1.C_ACCTBAL > (SELECT AVG(TPCR.CUSTOMER.C_ACCTBAL) FROM TPCR.CUSTOMER WHERE (TPCR.CUSTOMER.C_ACCTBAL > 0E-15) AND (left(C_PHONE, 2) IN ('13', '17', '18', '23', '29', '30', '31')))) AND (NOT (EXISTS (SELECT * FROM TPCR.ORDERS WHERE O_CUSTKEY = C_CUSTKEY)))})
              Project(groups=[TPCR.CUSTOMER AS CUSTOMER__1], props={PROJECT_COLS=[left(CUSTOMER__1.C_PHONE, 2) AS cntrycode, CUSTOMER__1.C_ACCTBAL]})
                Select(groups=[TPCR.CUSTOMER AS CUSTOMER__1], props={SELECT_CRITERIA=NOT (EXISTS (SELECT * FROM TPCR.ORDERS WHERE O_CUSTKEY = C_CUSTKEY))})
                  Select(groups=[TPCR.CUSTOMER AS CUSTOMER__1], props={SELECT_CRITERIA=CUSTOMER__1.C_ACCTBAL > (SELECT AVG(TPCR.CUSTOMER.C_ACCTBAL) FROM TPCR.CUSTOMER WHERE (TPCR.CUSTOMER.C_ACCTBAL > 0E-15) AND (left(C_PHONE, 2) IN ('13', '17', '18', '23', '29', '30', '31')))})
                    Select(groups=[TPCR.CUSTOMER AS CUSTOMER__1], props={SELECT_CRITERIA=left(CUSTOMER__1.C_PHONE, 2) IN ('13', '17', '18', '23', '29', '30', '31')})
                      Access(groups=[TPCR.CUSTOMER AS CUSTOMER__1])
                        Source(groups=[TPCR.CUSTOMER AS CUSTOMER__1])


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

AFTER: 
TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=100})
  Sort(groups=[vTpcr.Q22], props={SORT_ORDER=ORDER BY vTpcr.Q22.cntrycode})
    Project(groups=[vTpcr.Q22], props={PROJECT_COLS=[vTpcr.Q22.cntrycode, vTpcr.Q22.numcust, vTpcr.Q22.totacctbal]})
      Source(groups=[vTpcr.Q22], props={SYMBOL_MAP={vTpcr.Q22.cntrycode=cntrycode, vTpcr.Q22.numcust=COUNT(*), vTpcr.Q22.totacctbal=SUM(c_acctbal)}, NESTED_COMMAND=SELECT cntrycode, COUNT(*) AS numcust, SUM(c_acctbal) AS totacctbal FROM (SELECT left(CUSTOMER__1.C_PHONE, 2) AS cntrycode, TPCR.CUSTOMER.C_ACCTBAL FROM TPCR.CUSTOMER WHERE (left(CUSTOMER__1.C_PHONE, 2) IN ('13', '17', '18', '23', '29', '30', '31')) AND (CUSTOMER__1.C_ACCTBAL > (SELECT AVG(TPCR.CUSTOMER.C_ACCTBAL) FROM TPCR.CUSTOMER WHERE (TPCR.CUSTOMER.C_ACCTBAL > 0E-15) AND (left(C_PHONE, 2) IN ('13', '17', '18', '23', '29', '30', '31')))) AND (NOT (EXISTS (SELECT * FROM TPCR.ORDERS WHERE O_CUSTKEY = C_CUSTKEY)))) AS custsale GROUP BY cntrycode})
        Project(groups=[custsale], props={PROJECT_COLS=[cntrycode, COUNT(*) AS numcust, SUM(c_acctbal) AS totacctbal]})
          Group(groups=[custsale], props={GROUP_COLS=[cntrycode]})
            Source(groups=[custsale], props={SYMBOL_MAP={CUSTSALE.cntrycode=left(CUSTOMER__1.C_PHONE, 2), CUSTSALE.C_ACCTBAL=CUSTOMER__1.C_ACCTBAL}, NESTED_COMMAND=SELECT left(CUSTOMER__1.C_PHONE, 2) AS cntrycode, TPCR.CUSTOMER.C_ACCTBAL FROM TPCR.CUSTOMER WHERE (left(CUSTOMER__1.C_PHONE, 2) IN ('13', '17', '18', '23', '29', '30', '31')) AND (CUSTOMER__1.C_ACCTBAL > (SELECT AVG(TPCR.CUSTOMER.C_ACCTBAL) FROM TPCR.CUSTOMER WHERE (TPCR.CUSTOMER.C_ACCTBAL > 0E-15) AND (left(C_PHONE, 2) IN ('13', '17', '18', '23', '29', '30', '31')))) AND (NOT (EXISTS (SELECT * FROM TPCR.ORDERS WHERE O_CUSTKEY = C_CUSTKEY)))})
              Project(groups=[TPCR.CUSTOMER AS CUSTOMER__1], props={PROJECT_COLS=[left(CUSTOMER__1.C_PHONE, 2) AS cntrycode, CUSTOMER__1.C_ACCTBAL]})
                Access(groups=[TPCR.CUSTOMER AS CUSTOMER__1], props={MODEL_ID=Schema name=TPCR, nameInSource=null, uuid=mmuuid:ee4db7ad-7aa7-4258-815b-07ed88feca9c})
                  Select(groups=[TPCR.CUSTOMER AS CUSTOMER__1], props={SELECT_CRITERIA=(left(CUSTOMER__1.C_PHONE, 2) IN ('13', '17', '18', '23', '29', '30', '31')) AND (CUSTOMER__1.C_ACCTBAL > (SELECT AVG(TPCR.CUSTOMER.C_ACCTBAL) FROM TPCR.CUSTOMER WHERE (TPCR.CUSTOMER.C_ACCTBAL > 0E-15) AND (left(C_PHONE, 2) IN ('13', '17', '18', '23', '29', '30', '31')))) AND (NOT (EXISTS (SELECT * FROM TPCR.ORDERS WHERE O_CUSTKEY = C_CUSTKEY)))})
                    Source(groups=[TPCR.CUSTOMER AS CUSTOMER__1])


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

AFTER: 
TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=100})
  Sort(groups=[custsale], props={SORT_ORDER=ORDER BY cntrycode})
    Project(groups=[custsale], props={PROJECT_COLS=[cntrycode, COUNT(*) AS numcust, SUM(c_acctbal) AS totacctbal]})
      Group(groups=[custsale], props={GROUP_COLS=[cntrycode]})
        Source(groups=[custsale], props={SYMBOL_MAP={CUSTSALE.cntrycode=left(CUSTOMER__1.C_PHONE, 2), CUSTSALE.C_ACCTBAL=CUSTOMER__1.C_ACCTBAL}, NESTED_COMMAND=SELECT left(CUSTOMER__1.C_PHONE, 2) AS cntrycode, TPCR.CUSTOMER.C_ACCTBAL FROM TPCR.CUSTOMER WHERE (left(CUSTOMER__1.C_PHONE, 2) IN ('13', '17', '18', '23', '29', '30', '31')) AND (CUSTOMER__1.C_ACCTBAL > (SELECT AVG(TPCR.CUSTOMER.C_ACCTBAL) FROM TPCR.CUSTOMER WHERE (TPCR.CUSTOMER.C_ACCTBAL > 0E-15) AND (left(C_PHONE, 2) IN ('13', '17', '18', '23', '29', '30', '31')))) AND (NOT (EXISTS (SELECT * FROM TPCR.ORDERS WHERE O_CUSTKEY = C_CUSTKEY)))})
          Project(groups=[TPCR.CUSTOMER AS CUSTOMER__1], props={PROJECT_COLS=[left(CUSTOMER__1.C_PHONE, 2) AS cntrycode, CUSTOMER__1.C_ACCTBAL]})
            Access(groups=[TPCR.CUSTOMER AS CUSTOMER__1], props={MODEL_ID=Schema name=TPCR, nameInSource=null, uuid=mmuuid:ee4db7ad-7aa7-4258-815b-07ed88feca9c})
              Select(groups=[TPCR.CUSTOMER AS CUSTOMER__1], props={SELECT_CRITERIA=(left(CUSTOMER__1.C_PHONE, 2) IN ('13', '17', '18', '23', '29', '30', '31')) AND (CUSTOMER__1.C_ACCTBAL > (SELECT AVG(TPCR.CUSTOMER.C_ACCTBAL) FROM TPCR.CUSTOMER WHERE (TPCR.CUSTOMER.C_ACCTBAL > 0E-15) AND (left(C_PHONE, 2) IN ('13', '17', '18', '23', '29', '30', '31')))) AND (NOT (EXISTS (SELECT * FROM TPCR.ORDERS WHERE O_CUSTKEY = C_CUSTKEY)))})
                Source(groups=[TPCR.CUSTOMER AS CUSTOMER__1])


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

AFTER: 
TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=100})
  Sort(groups=[custsale], props={SORT_ORDER=ORDER BY cntrycode})
    Project(groups=[custsale], props={PROJECT_COLS=[cntrycode, COUNT(*) AS numcust, SUM(c_acctbal) AS totacctbal]})
      Group(groups=[custsale], props={GROUP_COLS=[cntrycode]})
        Source(groups=[custsale], props={SYMBOL_MAP={CUSTSALE.cntrycode=left(CUSTOMER__1.C_PHONE, 2), CUSTSALE.C_ACCTBAL=CUSTOMER__1.C_ACCTBAL}, NESTED_COMMAND=SELECT left(CUSTOMER__1.C_PHONE, 2) AS cntrycode, TPCR.CUSTOMER.C_ACCTBAL FROM TPCR.CUSTOMER WHERE (left(CUSTOMER__1.C_PHONE, 2) IN ('13', '17', '18', '23', '29', '30', '31')) AND (CUSTOMER__1.C_ACCTBAL > (SELECT AVG(TPCR.CUSTOMER.C_ACCTBAL) FROM TPCR.CUSTOMER WHERE (TPCR.CUSTOMER.C_ACCTBAL > 0E-15) AND (left(C_PHONE, 2) IN ('13', '17', '18', '23', '29', '30', '31')))) AND (NOT (EXISTS (SELECT * FROM TPCR.ORDERS WHERE O_CUSTKEY = C_CUSTKEY)))})
          Project(groups=[TPCR.CUSTOMER AS CUSTOMER__1], props={PROJECT_COLS=[left(CUSTOMER__1.C_PHONE, 2) AS cntrycode, CUSTOMER__1.C_ACCTBAL]})
            Access(groups=[TPCR.CUSTOMER AS CUSTOMER__1], props={MODEL_ID=Schema name=TPCR, nameInSource=null, uuid=mmuuid:ee4db7ad-7aa7-4258-815b-07ed88feca9c})
              Select(groups=[TPCR.CUSTOMER AS CUSTOMER__1], props={SELECT_CRITERIA=(left(CUSTOMER__1.C_PHONE, 2) IN ('13', '17', '18', '23', '29', '30', '31')) AND (CUSTOMER__1.C_ACCTBAL > (SELECT AVG(TPCR.CUSTOMER.C_ACCTBAL) FROM TPCR.CUSTOMER WHERE (TPCR.CUSTOMER.C_ACCTBAL > 0E-15) AND (left(C_PHONE, 2) IN ('13', '17', '18', '23', '29', '30', '31')))) AND (NOT (EXISTS (SELECT * FROM TPCR.ORDERS WHERE O_CUSTKEY = C_CUSTKEY)))})
                Source(groups=[TPCR.CUSTOMER AS CUSTOMER__1])


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

AFTER: 
Access(groups=[custsale], props={MODEL_ID=Schema name=TPCR, nameInSource=null, uuid=mmuuid:ee4db7ad-7aa7-4258-815b-07ed88feca9c})
  TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=100})
    Sort(groups=[custsale], props={SORT_ORDER=ORDER BY cntrycode})
      Project(groups=[custsale], props={PROJECT_COLS=[cntrycode, COUNT(*) AS numcust, SUM(c_acctbal) AS totacctbal]})
        Group(groups=[custsale], props={GROUP_COLS=[cntrycode]})
          Source(groups=[custsale], props={SYMBOL_MAP={CUSTSALE.cntrycode=left(CUSTOMER__1.C_PHONE, 2), CUSTSALE.C_ACCTBAL=CUSTOMER__1.C_ACCTBAL}, INLINE_VIEW=true, NESTED_COMMAND=SELECT left(CUSTOMER__1.C_PHONE, 2) AS cntrycode, TPCR.CUSTOMER.C_ACCTBAL FROM TPCR.CUSTOMER WHERE (left(CUSTOMER__1.C_PHONE, 2) IN ('13', '17', '18', '23', '29', '30', '31')) AND (CUSTOMER__1.C_ACCTBAL > (SELECT AVG(TPCR.CUSTOMER.C_ACCTBAL) FROM TPCR.CUSTOMER WHERE (TPCR.CUSTOMER.C_ACCTBAL > 0E-15) AND (left(C_PHONE, 2) IN ('13', '17', '18', '23', '29', '30', '31')))) AND (NOT (EXISTS (SELECT * FROM TPCR.ORDERS WHERE O_CUSTKEY = C_CUSTKEY)))})
            Project(groups=[TPCR.CUSTOMER AS CUSTOMER__1], props={PROJECT_COLS=[left(CUSTOMER__1.C_PHONE, 2) AS cntrycode, CUSTOMER__1.C_ACCTBAL]})
              Select(groups=[TPCR.CUSTOMER AS CUSTOMER__1], props={SELECT_CRITERIA=(left(CUSTOMER__1.C_PHONE, 2) IN ('13', '17', '18', '23', '29', '30', '31')) AND (CUSTOMER__1.C_ACCTBAL > (SELECT AVG(TPCR.CUSTOMER.C_ACCTBAL) FROM TPCR.CUSTOMER WHERE (TPCR.CUSTOMER.C_ACCTBAL > 0E-15) AND (left(C_PHONE, 2) IN ('13', '17', '18', '23', '29', '30', '31')))) AND (NOT (EXISTS (SELECT * FROM TPCR.ORDERS WHERE O_CUSTKEY = C_CUSTKEY)))})
                Source(groups=[TPCR.CUSTOMER AS CUSTOMER__1])


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

AFTER: 
Access(groups=[custsale], props={MODEL_ID=Schema name=TPCR, nameInSource=null, uuid=mmuuid:ee4db7ad-7aa7-4258-815b-07ed88feca9c})
  TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=100})
    Sort(groups=[custsale], props={SORT_ORDER=ORDER BY cntrycode})
      Project(groups=[custsale], props={PROJECT_COLS=[cntrycode, COUNT(*) AS numcust, SUM(c_acctbal) AS totacctbal]})
        Group(groups=[custsale], props={GROUP_COLS=[cntrycode]})
          Source(groups=[custsale], props={SYMBOL_MAP={CUSTSALE.cntrycode=left(CUSTOMER__1.C_PHONE, 2), CUSTSALE.C_ACCTBAL=CUSTOMER__1.C_ACCTBAL}, INLINE_VIEW=true, NESTED_COMMAND=SELECT left(CUSTOMER__1.C_PHONE, 2) AS cntrycode, TPCR.CUSTOMER.C_ACCTBAL FROM TPCR.CUSTOMER WHERE (left(CUSTOMER__1.C_PHONE, 2) IN ('13', '17', '18', '23', '29', '30', '31')) AND (CUSTOMER__1.C_ACCTBAL > (SELECT AVG(TPCR.CUSTOMER.C_ACCTBAL) FROM TPCR.CUSTOMER WHERE (TPCR.CUSTOMER.C_ACCTBAL > 0E-15) AND (left(C_PHONE, 2) IN ('13', '17', '18', '23', '29', '30', '31')))) AND (NOT (EXISTS (SELECT * FROM TPCR.ORDERS WHERE O_CUSTKEY = C_CUSTKEY)))})
            Project(groups=[TPCR.CUSTOMER AS CUSTOMER__1], props={PROJECT_COLS=[left(CUSTOMER__1.C_PHONE, 2) AS cntrycode, CUSTOMER__1.C_ACCTBAL]})
              Select(groups=[TPCR.CUSTOMER AS CUSTOMER__1], props={SELECT_CRITERIA=(left(CUSTOMER__1.C_PHONE, 2) IN ('13', '17', '18', '23', '29', '30', '31')) AND (CUSTOMER__1.C_ACCTBAL > (SELECT AVG(TPCR.CUSTOMER.C_ACCTBAL) FROM TPCR.CUSTOMER WHERE (TPCR.CUSTOMER.C_ACCTBAL > 0E-15) AND (left(C_PHONE, 2) IN ('13', '17', '18', '23', '29', '30', '31')))) AND (NOT (EXISTS (SELECT * FROM TPCR.ORDERS WHERE O_CUSTKEY = C_CUSTKEY)))})
                Source(groups=[TPCR.CUSTOMER AS CUSTOMER__1])


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

AFTER: 
Access(groups=[custsale], props={MODEL_ID=Schema name=TPCR, nameInSource=null, uuid=mmuuid:ee4db7ad-7aa7-4258-815b-07ed88feca9c})
  TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=100})
    Sort(groups=[custsale], props={SORT_ORDER=ORDER BY cntrycode})
      Project(groups=[custsale], props={PROJECT_COLS=[cntrycode, COUNT(*) AS numcust, SUM(c_acctbal) AS totacctbal]})
        Group(groups=[custsale], props={GROUP_COLS=[cntrycode]})
          Source(groups=[custsale], props={SYMBOL_MAP={CUSTSALE.cntrycode=left(CUSTOMER__1.C_PHONE, 2), CUSTSALE.C_ACCTBAL=CUSTOMER__1.C_ACCTBAL}, INLINE_VIEW=true, NESTED_COMMAND=SELECT left(CUSTOMER__1.C_PHONE, 2) AS cntrycode, TPCR.CUSTOMER.C_ACCTBAL FROM TPCR.CUSTOMER WHERE (left(CUSTOMER__1.C_PHONE, 2) IN ('13', '17', '18', '23', '29', '30', '31')) AND (CUSTOMER__1.C_ACCTBAL > (SELECT AVG(TPCR.CUSTOMER.C_ACCTBAL) FROM TPCR.CUSTOMER WHERE (TPCR.CUSTOMER.C_ACCTBAL > 0E-15) AND (left(C_PHONE, 2) IN ('13', '17', '18', '23', '29', '30', '31')))) AND (NOT (EXISTS (SELECT * FROM TPCR.ORDERS WHERE O_CUSTKEY = C_CUSTKEY)))})
            Project(groups=[TPCR.CUSTOMER AS CUSTOMER__1], props={PROJECT_COLS=[left(CUSTOMER__1.C_PHONE, 2) AS cntrycode, CUSTOMER__1.C_ACCTBAL]})
              Select(groups=[TPCR.CUSTOMER AS CUSTOMER__1], props={SELECT_CRITERIA=(left(CUSTOMER__1.C_PHONE, 2) IN ('13', '17', '18', '23', '29', '30', '31')) AND (CUSTOMER__1.C_ACCTBAL > (SELECT AVG(TPCR.CUSTOMER.C_ACCTBAL) FROM TPCR.CUSTOMER WHERE (TPCR.CUSTOMER.C_ACCTBAL > 0E-15) AND (left(C_PHONE, 2) IN ('13', '17', '18', '23', '29', '30', '31')))) AND (NOT (EXISTS (SELECT * FROM TPCR.ORDERS WHERE O_CUSTKEY = C_CUSTKEY)))})
                Source(groups=[TPCR.CUSTOMER AS CUSTOMER__1])


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

AFTER: 
Access(groups=[custsale], props={MODEL_ID=Schema name=TPCR, nameInSource=null, uuid=mmuuid:ee4db7ad-7aa7-4258-815b-07ed88feca9c})
  TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=100})
    Sort(groups=[custsale], props={SORT_ORDER=ORDER BY cntrycode})
      Project(groups=[custsale], props={PROJECT_COLS=[cntrycode, COUNT(*) AS numcust, SUM(c_acctbal) AS totacctbal]})
        Group(groups=[custsale], props={GROUP_COLS=[cntrycode]})
          Source(groups=[custsale], props={SYMBOL_MAP={CUSTSALE.cntrycode=left(CUSTOMER__1.C_PHONE, 2), CUSTSALE.C_ACCTBAL=CUSTOMER__1.C_ACCTBAL}, INLINE_VIEW=true, NESTED_COMMAND=SELECT left(CUSTOMER__1.C_PHONE, 2) AS cntrycode, TPCR.CUSTOMER.C_ACCTBAL FROM TPCR.CUSTOMER WHERE (left(CUSTOMER__1.C_PHONE, 2) IN ('13', '17', '18', '23', '29', '30', '31')) AND (CUSTOMER__1.C_ACCTBAL > (SELECT AVG(TPCR.CUSTOMER.C_ACCTBAL) FROM TPCR.CUSTOMER WHERE (TPCR.CUSTOMER.C_ACCTBAL > 0E-15) AND (left(C_PHONE, 2) IN ('13', '17', '18', '23', '29', '30', '31')))) AND (NOT (EXISTS (SELECT * FROM TPCR.ORDERS WHERE O_CUSTKEY = C_CUSTKEY)))})
            Project(groups=[TPCR.CUSTOMER AS CUSTOMER__1], props={PROJECT_COLS=[left(CUSTOMER__1.C_PHONE, 2) AS cntrycode, CUSTOMER__1.C_ACCTBAL]})
              Select(groups=[TPCR.CUSTOMER AS CUSTOMER__1], props={SELECT_CRITERIA=(left(CUSTOMER__1.C_PHONE, 2) IN ('13', '17', '18', '23', '29', '30', '31')) AND (CUSTOMER__1.C_ACCTBAL > (SELECT AVG(TPCR.CUSTOMER.C_ACCTBAL) FROM TPCR.CUSTOMER WHERE (TPCR.CUSTOMER.C_ACCTBAL > 0E-15) AND (left(C_PHONE, 2) IN ('13', '17', '18', '23', '29', '30', '31')))) AND (NOT (EXISTS (SELECT * FROM TPCR.ORDERS WHERE O_CUSTKEY = C_CUSTKEY)))})
                Source(groups=[TPCR.CUSTOMER AS CUSTOMER__1])


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

AFTER: 
Access(groups=[custsale], props={EST_CARDINALITY=1.0, MODEL_ID=Schema name=TPCR, nameInSource=null, uuid=mmuuid:ee4db7ad-7aa7-4258-815b-07ed88feca9c})
  TupleLimit(groups=[], props={EST_CARDINALITY=1.0, MAX_TUPLE_LIMIT=100})
    Sort(groups=[custsale], props={EST_CARDINALITY=1.0, SORT_ORDER=ORDER BY cntrycode})
      Project(groups=[custsale], props={PROJECT_COLS=[cntrycode, COUNT(*) AS numcust, SUM(c_acctbal) AS totacctbal], EST_CARDINALITY=1.0})
        Group(groups=[custsale], props={GROUP_COLS=[cntrycode], EST_CARDINALITY=1.0})
          Source(groups=[custsale], props={SYMBOL_MAP={CUSTSALE.cntrycode=left(CUSTOMER__1.C_PHONE, 2), CUSTSALE.C_ACCTBAL=CUSTOMER__1.C_ACCTBAL}, INLINE_VIEW=true, EST_CARDINALITY=1.0, NESTED_COMMAND=SELECT left(CUSTOMER__1.C_PHONE, 2) AS cntrycode, TPCR.CUSTOMER.C_ACCTBAL FROM TPCR.CUSTOMER WHERE (left(CUSTOMER__1.C_PHONE, 2) IN ('13', '17', '18', '23', '29', '30', '31')) AND (CUSTOMER__1.C_ACCTBAL > (SELECT AVG(TPCR.CUSTOMER.C_ACCTBAL) FROM TPCR.CUSTOMER WHERE (TPCR.CUSTOMER.C_ACCTBAL > 0E-15) AND (left(C_PHONE, 2) IN ('13', '17', '18', '23', '29', '30', '31')))) AND (NOT (EXISTS (SELECT * FROM TPCR.ORDERS WHERE O_CUSTKEY = C_CUSTKEY)))})
            Project(groups=[TPCR.CUSTOMER AS CUSTOMER__1], props={PROJECT_COLS=[left(CUSTOMER__1.C_PHONE, 2) AS cntrycode, CUSTOMER__1.C_ACCTBAL], EST_CARDINALITY=1.0})
              Select(groups=[TPCR.CUSTOMER AS CUSTOMER__1], props={EST_CARDINALITY=1.0, SELECT_CRITERIA=(left(CUSTOMER__1.C_PHONE, 2) IN ('13', '17', '18', '23', '29', '30', '31')) AND (CUSTOMER__1.C_ACCTBAL > (SELECT AVG(TPCR.CUSTOMER.C_ACCTBAL) FROM TPCR.CUSTOMER WHERE (TPCR.CUSTOMER.C_ACCTBAL > 0E-15) AND (left(C_PHONE, 2) IN ('13', '17', '18', '23', '29', '30', '31')))) AND (NOT (EXISTS (SELECT * FROM TPCR.ORDERS WHERE O_CUSTKEY = C_CUSTKEY)))})
                Source(groups=[TPCR.CUSTOMER AS CUSTOMER__1], props={EST_CARDINALITY=150000.0})


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

AFTER: 
Access(groups=[custsale], props={EST_CARDINALITY=1.0, MODEL_ID=Schema name=TPCR, nameInSource=null, uuid=mmuuid:ee4db7ad-7aa7-4258-815b-07ed88feca9c, OUTPUT_COLS=[cntrycode, COUNT(*) AS numcust, SUM(c_acctbal) AS totacctbal]})
  TupleLimit(groups=[], props={EST_CARDINALITY=1.0, MAX_TUPLE_LIMIT=100, OUTPUT_COLS=[cntrycode, COUNT(*) AS numcust, SUM(c_acctbal) AS totacctbal]})
    Sort(groups=[custsale], props={EST_CARDINALITY=1.0, OUTPUT_COLS=[cntrycode, COUNT(*) AS numcust, SUM(c_acctbal) AS totacctbal], SORT_ORDER=ORDER BY cntrycode})
      Project(groups=[custsale], props={PROJECT_COLS=[cntrycode, COUNT(*) AS numcust, SUM(c_acctbal) AS totacctbal], EST_CARDINALITY=1.0, OUTPUT_COLS=[cntrycode, COUNT(*) AS numcust, SUM(c_acctbal) AS totacctbal]})
        Group(groups=[custsale], props={GROUP_COLS=[cntrycode], EST_CARDINALITY=1.0, OUTPUT_COLS=[cntrycode, COUNT(*), SUM(c_acctbal)]})
          Source(groups=[custsale], props={SYMBOL_MAP={CUSTSALE.cntrycode=left(CUSTOMER__1.C_PHONE, 2), CUSTSALE.C_ACCTBAL=CUSTOMER__1.C_ACCTBAL}, INLINE_VIEW=true, EST_CARDINALITY=1.0, OUTPUT_COLS=[cntrycode, c_acctbal], NESTED_COMMAND=SELECT left(CUSTOMER__1.C_PHONE, 2) AS cntrycode, TPCR.CUSTOMER.C_ACCTBAL FROM TPCR.CUSTOMER WHERE (left(CUSTOMER__1.C_PHONE, 2) IN ('13', '17', '18', '23', '29', '30', '31')) AND (CUSTOMER__1.C_ACCTBAL > (SELECT AVG(TPCR.CUSTOMER.C_ACCTBAL) FROM TPCR.CUSTOMER WHERE (TPCR.CUSTOMER.C_ACCTBAL > 0E-15) AND (left(C_PHONE, 2) IN ('13', '17', '18', '23', '29', '30', '31')))) AND (NOT (EXISTS (SELECT * FROM TPCR.ORDERS WHERE O_CUSTKEY = C_CUSTKEY)))})
            Project(groups=[TPCR.CUSTOMER AS CUSTOMER__1], props={PROJECT_COLS=[left(CUSTOMER__1.C_PHONE, 2) AS cntrycode, CUSTOMER__1.C_ACCTBAL], EST_CARDINALITY=1.0, OUTPUT_COLS=[left(CUSTOMER__1.C_PHONE, 2) AS cntrycode, CUSTOMER__1.C_ACCTBAL]})
              Select(groups=[TPCR.CUSTOMER AS CUSTOMER__1], props={EST_CARDINALITY=1.0, SELECT_CRITERIA=(left(CUSTOMER__1.C_PHONE, 2) IN ('13', '17', '18', '23', '29', '30', '31')) AND (CUSTOMER__1.C_ACCTBAL > (SELECT AVG(TPCR.CUSTOMER.C_ACCTBAL) FROM TPCR.CUSTOMER WHERE (TPCR.CUSTOMER.C_ACCTBAL > 0E-15) AND (left(C_PHONE, 2) IN ('13', '17', '18', '23', '29', '30', '31')))) AND (NOT (EXISTS (SELECT * FROM TPCR.ORDERS WHERE O_CUSTKEY = C_CUSTKEY))), OUTPUT_COLS=[CUSTOMER__1.C_PHONE, CUSTOMER__1.C_ACCTBAL]})
                Source(groups=[TPCR.CUSTOMER AS CUSTOMER__1], props={EST_CARDINALITY=150000.0, OUTPUT_COLS=[CUSTOMER__1.C_PHONE, CUSTOMER__1.C_ACCTBAL, CUSTOMER__1.C_CUSTKEY]})


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

AFTER: 
Access(groups=[custsale], props={EST_CARDINALITY=1.0, MODEL_ID=Schema name=TPCR, nameInSource=null, uuid=mmuuid:ee4db7ad-7aa7-4258-815b-07ed88feca9c, OUTPUT_COLS=[cntrycode, COUNT(*) AS numcust, SUM(c_acctbal) AS totacctbal]})
  TupleLimit(groups=[], props={EST_CARDINALITY=1.0, MAX_TUPLE_LIMIT=100, OUTPUT_COLS=[cntrycode, COUNT(*) AS numcust, SUM(c_acctbal) AS totacctbal]})
    Sort(groups=[custsale], props={EST_CARDINALITY=1.0, OUTPUT_COLS=[cntrycode, COUNT(*) AS numcust, SUM(c_acctbal) AS totacctbal], SORT_ORDER=ORDER BY cntrycode})
      Project(groups=[custsale], props={PROJECT_COLS=[cntrycode, COUNT(*) AS numcust, SUM(c_acctbal) AS totacctbal], EST_CARDINALITY=1.0, OUTPUT_COLS=[cntrycode, COUNT(*) AS numcust, SUM(c_acctbal) AS totacctbal]})
        Group(groups=[custsale], props={GROUP_COLS=[cntrycode], EST_CARDINALITY=1.0, OUTPUT_COLS=[cntrycode, COUNT(*), SUM(c_acctbal)]})
          Source(groups=[custsale], props={SYMBOL_MAP={CUSTSALE.cntrycode=left(CUSTOMER__1.C_PHONE, 2), CUSTSALE.C_ACCTBAL=CUSTOMER__1.C_ACCTBAL}, INLINE_VIEW=true, EST_CARDINALITY=1.0, OUTPUT_COLS=[cntrycode, c_acctbal], NESTED_COMMAND=SELECT left(CUSTOMER__1.C_PHONE, 2) AS cntrycode, TPCR.CUSTOMER.C_ACCTBAL FROM TPCR.CUSTOMER WHERE (left(CUSTOMER__1.C_PHONE, 2) IN ('13', '17', '18', '23', '29', '30', '31')) AND (CUSTOMER__1.C_ACCTBAL > (SELECT AVG(TPCR.CUSTOMER.C_ACCTBAL) FROM TPCR.CUSTOMER WHERE (TPCR.CUSTOMER.C_ACCTBAL > 0E-15) AND (left(C_PHONE, 2) IN ('13', '17', '18', '23', '29', '30', '31')))) AND (NOT (EXISTS (SELECT * FROM TPCR.ORDERS WHERE O_CUSTKEY = C_CUSTKEY)))})
            Project(groups=[TPCR.CUSTOMER AS CUSTOMER__1], props={PROJECT_COLS=[left(CUSTOMER__1.C_PHONE, 2) AS cntrycode, CUSTOMER__1.C_ACCTBAL], EST_CARDINALITY=1.0, OUTPUT_COLS=[left(CUSTOMER__1.C_PHONE, 2) AS cntrycode, CUSTOMER__1.C_ACCTBAL]})
              Select(groups=[TPCR.CUSTOMER AS CUSTOMER__1], props={EST_CARDINALITY=1.0, SELECT_CRITERIA=(left(CUSTOMER__1.C_PHONE, 2) IN ('13', '17', '18', '23', '29', '30', '31')) AND (CUSTOMER__1.C_ACCTBAL > (SELECT AVG(TPCR.CUSTOMER.C_ACCTBAL) FROM TPCR.CUSTOMER WHERE (TPCR.CUSTOMER.C_ACCTBAL > 0E-15) AND (left(C_PHONE, 2) IN ('13', '17', '18', '23', '29', '30', '31')))) AND (NOT (EXISTS (SELECT * FROM TPCR.ORDERS WHERE O_CUSTKEY = C_CUSTKEY))), OUTPUT_COLS=[CUSTOMER__1.C_PHONE, CUSTOMER__1.C_ACCTBAL]})
                Source(groups=[TPCR.CUSTOMER AS CUSTOMER__1], props={EST_CARDINALITY=150000.0, OUTPUT_COLS=[CUSTOMER__1.C_PHONE, CUSTOMER__1.C_ACCTBAL, CUSTOMER__1.C_CUSTKEY]})


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

AFTER: 
Access(groups=[custsale], props={EST_CARDINALITY=1.0, MODEL_ID=Schema name=TPCR, nameInSource=null, uuid=mmuuid:ee4db7ad-7aa7-4258-815b-07ed88feca9c, OUTPUT_COLS=[cntrycode, COUNT(*) AS numcust, SUM(c_acctbal) AS totacctbal], ATOMIC_REQUEST=SELECT cntrycode, COUNT(*) AS numcust, SUM(c_acctbal) AS totacctbal FROM (SELECT left(CUSTOMER__1.C_PHONE, 2) AS cntrycode, CUSTOMER__1.C_ACCTBAL FROM TPCR.CUSTOMER AS CUSTOMER__1 WHERE (left(CUSTOMER__1.C_PHONE, 2) IN ('13', '17', '18', '23', '29', '30', '31')) AND (CUSTOMER__1.C_ACCTBAL > (SELECT AVG(g_0.C_ACCTBAL) FROM TPCR.CUSTOMER AS g_0 WHERE (g_0.C_ACCTBAL > 0E-15) AND (left(g_0.C_PHONE, 2) IN ('13', '17', '18', '23', '29', '30', '31')))) AND (NOT (EXISTS (SELECT g_0.O_ORDERKEY, g_0.O_CUSTKEY, g_0.O_ORDERSTATUS, g_0.O_TOTALPRICE, g_0.O_ORDERDATE, g_0.O_ORDERPRIORITY, g_0.O_CLERK, g_0.O_SHIPPRIORITY, g_0.O_COMMENT FROM TPCR.ORDERS AS g_0 WHERE g_0.O_CUSTKEY = CUSTOMER__1.C_CUSTKEY)))) AS custsale GROUP BY cntrycode ORDER BY cntrycode LIMIT 100})


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

PROCESS PLAN = 
AccessNode(3) output=[cntrycode, COUNT(*) AS numcust, SUM(c_acctbal) AS totacctbal] SELECT v_0.c_0, COUNT(*) AS c_1, SUM(v_0.c_1) AS c_2 FROM (SELECT left(g_0.C_PHONE, 2) AS c_0, g_0.C_ACCTBAL AS c_1 FROM TPCR.CUSTOMER AS g_0 WHERE (left(g_0.C_PHONE, 2) IN ('13', '17', '18', '23', '29', '30', '31')) AND (g_0.C_ACCTBAL > (SELECT AVG(g_1.C_ACCTBAL) FROM TPCR.CUSTOMER AS g_1 WHERE (g_1.C_ACCTBAL > 0E-15) AND (left(g_1.C_PHONE, 2) IN ('13', '17', '18', '23', '29', '30', '31')))) AND (NOT (EXISTS (SELECT g_2.O_ORDERKEY, g_2.O_CUSTKEY, g_2.O_ORDERSTATUS, g_2.O_TOTALPRICE, g_2.O_ORDERDATE, g_2.O_ORDERPRIORITY, g_2.O_CLERK, g_2.O_SHIPPRIORITY, g_2.O_COMMENT FROM TPCR.ORDERS AS g_2 WHERE g_2.O_CUSTKEY = g_0.C_CUSTKEY)))) AS v_0 GROUP BY v_0.c_0 ORDER BY c_0 LIMIT 100

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

----------------------------------------------------------------------------
OPTIMIZATION COMPLETE:
PROCESSOR PLAN:
AccessNode(3) output=[cntrycode, COUNT(*) AS numcust, SUM(c_acctbal) AS totacctbal] SELECT v_0.c_0, COUNT(*) AS c_1, SUM(v_0.c_1) AS c_2 FROM (SELECT left(g_0.C_PHONE, 2) AS c_0, g_0.C_ACCTBAL AS c_1 FROM TPCR.CUSTOMER AS g_0 WHERE (left(g_0.C_PHONE, 2) IN ('13', '17', '18', '23', '29', '30', '31')) AND (g_0.C_ACCTBAL > (SELECT AVG(g_1.C_ACCTBAL) FROM TPCR.CUSTOMER AS g_1 WHERE (g_1.C_ACCTBAL > 0E-15) AND (left(g_1.C_PHONE, 2) IN ('13', '17', '18', '23', '29', '30', '31')))) AND (NOT (EXISTS (SELECT g_2.O_ORDERKEY, g_2.O_CUSTKEY, g_2.O_ORDERSTATUS, g_2.O_TOTALPRICE, g_2.O_ORDERDATE, g_2.O_ORDERPRIORITY, g_2.O_CLERK, g_2.O_SHIPPRIORITY, g_2.O_COMMENT FROM TPCR.ORDERS AS g_2 WHERE g_2.O_CUSTKEY = g_0.C_CUSTKEY)))) AS v_0 GROUP BY v_0.c_0 ORDER BY c_0 LIMIT 100

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

2010-11-23 08:59:16,279 DEBUG [org.teiid.PROCESSOR] (Worker8_QueryProcessorQueue268) ProcessTree for QPjlI18+nKci.8 AccessNode(3) output=[cntrycode, COUNT(*) AS numcust, SUM(c_acctbal) AS totacctbal] SELECT v_0.c_0, COUNT(*) AS c_1, SUM(v_0.c_1) AS c_2 FROM (SELECT left(g_0.C_PHONE, 2) AS c_0, g_0.C_ACCTBAL AS c_1 FROM TPCR.CUSTOMER AS g_0 WHERE (left(g_0.C_PHONE, 2) IN ('13', '17', '18', '23', '29', '30', '31')) AND (g_0.C_ACCTBAL > (SELECT AVG(g_1.C_ACCTBAL) FROM TPCR.CUSTOMER AS g_1 WHERE (g_1.C_ACCTBAL > 0E-15) AND (left(g_1.C_PHONE, 2) IN ('13', '17', '18', '23', '29', '30', '31')))) AND (NOT (EXISTS (SELECT g_2.O_ORDERKEY, g_2.O_CUSTKEY, g_2.O_ORDERSTATUS, g_2.O_TOTALPRICE, g_2.O_ORDERDATE, g_2.O_ORDERPRIORITY, g_2.O_CLERK, g_2.O_SHIPPRIORITY, g_2.O_COMMENT FROM TPCR.ORDERS AS g_2 WHERE g_2.O_CUSTKEY = g_0.C_CUSTKEY)))) AS v_0 GROUP BY v_0.c_0 ORDER BY c_0 LIMIT 100

2010-11-23 08:59:16,280 DEBUG [org.teiid.TXN_LOG] (Worker8_QueryProcessorQueue268) before getOrCreateTransactionContext:org.teiid.dqp.internal.process.TransactionServerImpl@905b91(QPjlI18+nKci)
2010-11-23 08:59:16,280 DEBUG [org.teiid.TXN_LOG] (Worker8_QueryProcessorQueue268) after getOrCreateTransactionContext : QPjlI18+nKci NONE ID:NONE
2010-11-23 08:59:16,280 DEBUG [org.teiid.BUFFER_MGR] (Worker8_QueryProcessorQueue268) Creating FileStore: 57
2010-11-23 08:59:16,280 DEBUG [org.teiid.BUFFER_MGR] (Worker8_QueryProcessorQueue268) Creating TupleBuffer: 57 of type  PROCESSOR
2010-11-23 08:59:16,280 DEBUG [org.teiid.CONNECTOR] (Worker8_QueryProcessorQueue268) QPjlI18+nKci.8.3.41 Create State
2010-11-23 08:59:16,280 DEBUG [org.teiid.PROCESSOR] (Worker8_QueryProcessorQueue268) Request Thread QPjlI18+nKci.8 - processor blocked
2010-11-23 08:59:16,280 DEBUG [org.teiid.RUNTIME] (Worker7_QueryProcessorQueue269) Beginning work with virtual worker Worker7_QueryProcessorQueue269
2010-11-23 08:59:16,280 DEBUG [org.teiid.TXN_LOG] (Worker8_QueryProcessorQueue268) before suspend:org.teiid.dqp.internal.process.TransactionServerImpl@905b91(QPjlI18+nKci NONE ID:NONE)
2010-11-23 08:59:16,280 DEBUG [org.teiid.CONNECTOR] (Worker7_QueryProcessorQueue269) QPjlI18+nKci.8.3.41 Processing NEW request: SELECT v_0.c_0, COUNT(*) AS c_1, SUM(v_0.c_1) AS c_2 FROM (SELECT left(g_0.C_PHONE, 2) AS c_0, g_0.C_ACCTBAL AS c_1 FROM TPCR.CUSTOMER AS g_0 WHERE (left(g_0.C_PHONE, 2) IN ('13', '17', '18', '23', '29', '30', '31')) AND (g_0.C_ACCTBAL > (SELECT AVG(g_1.C_ACCTBAL) FROM TPCR.CUSTOMER AS g_1 WHERE (g_1.C_ACCTBAL > 0E-15) AND (left(g_1.C_PHONE, 2) IN ('13', '17', '18', '23', '29', '30', '31')))) AND (NOT (EXISTS (SELECT g_2.O_ORDERKEY, g_2.O_CUSTKEY, g_2.O_ORDERSTATUS, g_2.O_TOTALPRICE, g_2.O_ORDERDATE, g_2.O_ORDERPRIORITY, g_2.O_CLERK, g_2.O_SHIPPRIORITY, g_2.O_COMMENT FROM TPCR.ORDERS AS g_2 WHERE g_2.O_CUSTKEY = g_0.C_CUSTKEY)))) AS v_0 GROUP BY v_0.c_0 ORDER BY c_0 LIMIT 100
2010-11-23 08:59:16,281 DEBUG [org.teiid.TXN_LOG] (Worker8_QueryProcessorQueue268) after suspend : null
2010-11-23 08:59:16,281 DEBUG [org.teiid.PROCESSOR] (Worker8_QueryProcessorQueue268) QPjlI18+nKci.8 end processing WORKING
2010-11-23 08:59:16,281 DEBUG [org.teiid.CONNECTOR] (Worker7_QueryProcessorQueue269) QPjlI18+nKci.8.3.41 Obtained execution
2010-11-23 08:59:16,281 DEBUG [org.teiid.COMMAND_LOG] (Worker7_QueryProcessorQueue269) 	START DATA SRC COMMAND:	startTime=2010-11-23 08:59:16.281	requestID=QPjlI18+nKci.8	sourceCommandID=3	txID=null	modelName=TPCR	connectorBindingName=sqlserver	sessionID=QPjlI18+nKci	principal=pnittel@teiid-security	sql=SELECT v_0.c_0, COUNT(*) AS c_1, SUM(v_0.c_1) AS c_2 FROM (SELECT left(g_0.C_PHONE, 2) AS c_0, g_0.C_ACCTBAL AS c_1 FROM TPCR.CUSTOMER AS g_0 WHERE (left(g_0.C_PHONE, 2) IN ('13', '17', '18', '23', '29', '30', '31')) AND (g_0.C_ACCTBAL > (SELECT AVG(g_1.C_ACCTBAL) FROM TPCR.CUSTOMER AS g_1 WHERE (g_1.C_ACCTBAL > 0E-15) AND (left(g_1.C_PHONE, 2) IN ('13', '17', '18', '23', '29', '30', '31')))) AND (NOT (EXISTS (SELECT g_2.O_ORDERKEY, g_2.O_CUSTKEY, g_2.O_ORDERSTATUS, g_2.O_TOTALPRICE, g_2.O_ORDERDATE, g_2.O_ORDERPRIORITY, g_2.O_CLERK, g_2.O_SHIPPRIORITY, g_2.O_COMMENT FROM TPCR.ORDERS AS g_2 WHERE g_2.O_CUSTKEY = g_0.C_CUSTKEY)))) AS v_0 GROUP BY v_0.c_0 ORDER BY c_0 LIMIT 100
2010-11-23 08:59:16,282 DEBUG [org.teiid.CONNECTOR] (Worker7_QueryProcessorQueue269) Source-specific command: SELECT TOP 100 v_0.c_0, COUNT(*) AS c_1, SUM(v_0.c_1) AS c_2 FROM (SELECT left(g_0.C_PHONE, 2) AS c_0, g_0.C_ACCTBAL AS c_1 FROM CUSTOMER g_0 WHERE left(g_0.C_PHONE, 2) IN (?, ?, ?, ?, ?, ?, ?) AND g_0.C_ACCTBAL > (SELECT AVG(g_1.C_ACCTBAL) FROM CUSTOMER g_1 WHERE g_1.C_ACCTBAL > ? AND left(g_1.C_PHONE, 2) IN (?, ?, ?, ?, ?, ?, ?)) AND NOT (EXISTS (SELECT g_2.O_ORDERKEY, g_2.O_CUSTKEY, g_2.O_ORDERSTATUS, g_2.O_TOTALPRICE, g_2.O_ORDERDATE, g_2.O_ORDERPRIORITY, g_2.O_CLERK, g_2.O_SHIPPRIORITY, g_2.O_COMMENT FROM ORDERS g_2 WHERE g_2.O_CUSTKEY = g_0.C_CUSTKEY))) v_0 GROUP BY v_0.c_0 ORDER BY custsale.c_0
2010-11-23 08:59:16,384 DEBUG [org.teiid.COMMAND_LOG] (Worker7_QueryProcessorQueue269) 	ERROR SRC COMMAND:	endTime=2010-11-23 08:59:16.384	requestID=QPjlI18+nKci.8	sourceCommandID=3	txID=null	modelName=TPCR	connectorBindingName=sqlserver	sessionID=QPjlI18+nKci	principal=pnittel@teiid-security	finalRowCount=null
2010-11-23 08:59:16,385 WARN  [org.teiid.CONNECTOR] (Worker7_QueryProcessorQueue269) Connector worker process failed for atomic-request=QPjlI18+nKci.8.3.41
[JDBCExecutionException] 107: Error Code:107 Message:'The column prefix 'custsale' does not match with a table name or alias name used in the query.' error executing statement(s): [Prepared Values: ['13', '17', '18', '23', '29', '30', '31', 0E-15, '13', '17', '18', '23', '29', '30', '31'] SQL: SELECT TOP 100 v_0.c_0, COUNT(*) AS c_1, SUM(v_0.c_1) AS c_2 FROM (SELECT left(g_0.C_PHONE, 2) AS c_0, g_0.C_ACCTBAL AS c_1 FROM CUSTOMER g_0 WHERE left(g_0.C_PHONE, 2) IN (?, ?, ?, ?, ?, ?, ?) AND g_0.C_ACCTBAL > (SELECT AVG(g_1.C_ACCTBAL) FROM CUSTOMER g_1 WHERE g_1.C_ACCTBAL > ? AND left(g_1.C_PHONE, 2) IN (?, ?, ?, ?, ?, ?, ?)) AND NOT (EXISTS (SELECT g_2.O_ORDERKEY, g_2.O_CUSTKEY, g_2.O_ORDERSTATUS, g_2.O_TOTALPRICE, g_2.O_ORDERDATE, g_2.O_ORDERPRIORITY, g_2.O_CLERK, g_2.O_SHIPPRIORITY, g_2.O_COMMENT FROM ORDERS g_2 WHERE g_2.O_CUSTKEY = g_0.C_CUSTKEY))) v_0 GROUP BY v_0.c_0 ORDER BY custsale.c_0]
1 [SQLException]The column prefix 'custsale' does not match with a table name or alias name used in the query.
	at org.teiid.translator.jdbc.JDBCQueryExecution.execute(JDBCQueryExecution.java:88)
	at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:263)
	at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:281)
	at org.teiid.dqp.internal.process.DataTierTupleSource.access$000(DataTierTupleSource.java:71)
	at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:123)
	at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:120)
	at org.teiid.dqp.internal.process.DQPCore$FutureWork.run(DQPCore.java:108)
	at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:188)
	at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:116)
	at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:290)
	at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
	at java.lang.Thread.run(Thread.java:619)
Caused by: java.sql.SQLException: The column prefix 'custsale' does not match with a table name or alias name used in the query.
	at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:368)
	at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2820)
	at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2258)
	at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:632)
	at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQLQuery(JtdsStatement.java:477)
	at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeQuery(JtdsPreparedStatement.java:776)
	at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeQuery(WrappedPreparedStatement.java:342)
	at org.teiid.translator.jdbc.JDBCQueryExecution.execute(JDBCQueryExecution.java:84)
	... 12 more
2010-11-23 08:59:16,386 DEBUG [org.teiid.PROCESSOR] (Worker7_QueryProcessorQueue269) QPjlI18+nKci.8 more work IDLE
2010-11-23 08:59:16,386 DEBUG [org.teiid.RUNTIME] (Worker8_QueryProcessorQueue270) Beginning work with virtual worker Worker8_QueryProcessorQueue270
2010-11-23 08:59:16,386 DEBUG [org.teiid.PROCESSOR] (Worker8_QueryProcessorQueue270) QPjlI18+nKci.8 start processing MORE_WORK
2010-11-23 08:59:16,387 DEBUG [org.teiid.PROCESSOR] (Worker8_QueryProcessorQueue270) Request Thread QPjlI18+nKci.8 with state PROCESSING
2010-11-23 08:59:16,387 DEBUG [org.teiid.PROCESSOR] (Worker8_QueryProcessorQueue270) closed atomic-request: QPjlI18+nKci.8.3.41
2010-11-23 08:59:16,387 DEBUG [org.teiid.RUNTIME] (Worker7_QueryProcessorQueue271) Beginning work with virtual worker Worker7_QueryProcessorQueue271
2010-11-23 08:59:16,387 DEBUG [org.teiid.PROCESSOR] (Worker8_QueryProcessorQueue270) QueryProcessor: closing processor
2010-11-23 08:59:16,387 DEBUG [org.teiid.PROCESSOR] (Worker8_QueryProcessorQueue270) [Ljava.lang.Object;@4e7d4a
[TeiidProcessingException] 107: Error Code:107 Message:Error Code:107 Message:'The column prefix 'custsale' does not match with a table name or alias name used in the query.' error executing statement(s): [Prepared Values: ['13', '17', '18', '23', '29', '30', '31', 0E-15, '13', '17', '18', '23', '29', '30', '31'] SQL: SELECT TOP 100 v_0.c_0, COUNT(*) AS c_1, SUM(v_0.c_1) AS c_2 FROM (SELECT left(g_0.C_PHONE, 2) AS c_0, g_0.C_ACCTBAL AS c_1 FROM CUSTOMER g_0 WHERE left(g_0.C_PHONE, 2) IN (?, ?, ?, ?, ?, ?, ?) AND g_0.C_ACCTBAL > (SELECT AVG(g_1.C_ACCTBAL) FROM CUSTOMER g_1 WHERE g_1.C_ACCTBAL > ? AND left(g_1.C_PHONE, 2) IN (?, ?, ?, ?, ?, ?, ?)) AND NOT (EXISTS (SELECT g_2.O_ORDERKEY, g_2.O_CUSTKEY, g_2.O_ORDERSTATUS, g_2.O_TOTALPRICE, g_2.O_ORDERDATE, g_2.O_ORDERPRIORITY, g_2.O_CLERK, g_2.O_SHIPPRIORITY, g_2.O_COMMENT FROM ORDERS g_2 WHERE g_2.O_CUSTKEY = g_0.C_CUSTKEY))) v_0 GROUP BY v_0.c_0 ORDER BY custsale.c_0]
1 [JDBCExecutionException] 107: Error Code:107 Message:'The column prefix 'custsale' does not match with a table name or alias name used in the query.' error executing statement(s): [Prepared Values: ['13', '17', '18', '23', '29', '30', '31', 0E-15, '13', '17', '18', '23', '29', '30', '31'] SQL: SELECT TOP 100 v_0.c_0, COUNT(*) AS c_1, SUM(v_0.c_1) AS c_2 FROM (SELECT left(g_0.C_PHONE, 2) AS c_0, g_0.C_ACCTBAL AS c_1 FROM CUSTOMER g_0 WHERE left(g_0.C_PHONE, 2) IN (?, ?, ?, ?, ?, ?, ?) AND g_0.C_ACCTBAL > (SELECT AVG(g_1.C_ACCTBAL) FROM CUSTOMER g_1 WHERE g_1.C_ACCTBAL > ? AND left(g_1.C_PHONE, 2) IN (?, ?, ?, ?, ?, ?, ?)) AND NOT (EXISTS (SELECT g_2.O_ORDERKEY, g_2.O_CUSTKEY, g_2.O_ORDERSTATUS, g_2.O_TOTALPRICE, g_2.O_ORDERDATE, g_2.O_ORDERPRIORITY, g_2.O_CLERK, g_2.O_SHIPPRIORITY, g_2.O_COMMENT FROM ORDERS g_2 WHERE g_2.O_CUSTKEY = g_0.C_CUSTKEY))) v_0 GROUP BY v_0.c_0 ORDER BY custsale.c_0]
2 [SQLException]The column prefix 'custsale' does not match with a table name or alias name used in the query.
	at org.teiid.dqp.internal.process.DataTierTupleSource.exceptionOccurred(DataTierTupleSource.java:371)
	at org.teiid.dqp.internal.process.DataTierTupleSource.nextTuple(DataTierTupleSource.java:214)
	at org.teiid.query.processor.relational.AccessNode.nextBatchDirect(AccessNode.java:154)
	at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:274)
	at org.teiid.query.processor.relational.RelationalPlan.nextBatch(RelationalPlan.java:107)
	at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:150)
	at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:105)
	at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:115)
	at org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:250)
	at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:184)
	at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:49)
	at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:188)
	at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:116)
	at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:290)
	at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
	at java.lang.Thread.run(Thread.java:619)
Caused by: [JDBCExecutionException] 107: Error Code:107 Message:'The column prefix 'custsale' does not match with a table name or alias name used in the query.' error executing statement(s): [Prepared Values: ['13', '17', '18', '23', '29', '30', '31', 0E-15, '13', '17', '18', '23', '29', '30', '31'] SQL: SELECT TOP 100 v_0.c_0, COUNT(*) AS c_1, SUM(v_0.c_1) AS c_2 FROM (SELECT left(g_0.C_PHONE, 2) AS c_0, g_0.C_ACCTBAL AS c_1 FROM CUSTOMER g_0 WHERE left(g_0.C_PHONE, 2) IN (?, ?, ?, ?, ?, ?, ?) AND g_0.C_ACCTBAL > (SELECT AVG(g_1.C_ACCTBAL) FROM CUSTOMER g_1 WHERE g_1.C_ACCTBAL > ? AND left(g_1.C_PHONE, 2) IN (?, ?, ?, ?, ?, ?, ?)) AND NOT (EXISTS (SELECT g_2.O_ORDERKEY, g_2.O_CUSTKEY, g_2.O_ORDERSTATUS, g_2.O_TOTALPRICE, g_2.O_ORDERDATE, g_2.O_ORDERPRIORITY, g_2.O_CLERK, g_2.O_SHIPPRIORITY, g_2.O_COMMENT FROM ORDERS g_2 WHERE g_2.O_CUSTKEY = g_0.C_CUSTKEY))) v_0 GROUP BY v_0.c_0 ORDER BY custsale.c_0]
1 [SQLException]The column prefix 'custsale' does not match with a table name or alias name used in the query.
	at org.teiid.translator.jdbc.JDBCQueryExecution.execute(JDBCQueryExecution.java:88)
	at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:263)
	at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:281)
	at org.teiid.dqp.internal.process.DataTierTupleSource.access$000(DataTierTupleSource.java:71)
	at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:123)
	at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:120)
	at org.teiid.dqp.internal.process.DQPCore$FutureWork.run(DQPCore.java:108)
	... 6 more
Caused by: java.sql.SQLException: The column prefix 'custsale' does not match with a table name or alias name used in the query.
	at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:368)
	at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2820)
	at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2258)
	at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:632)
	at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQLQuery(JtdsStatement.java:477)
	at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeQuery(JtdsPreparedStatement.java:776)
	at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeQuery(WrappedPreparedStatement.java:342)
	at org.teiid.translator.jdbc.JDBCQueryExecution.execute(JDBCQueryExecution.java:84)
	... 12 more
2010-11-23 08:59:16,387 DEBUG [org.teiid.CONNECTOR] (Worker7_QueryProcessorQueue271) QPjlI18+nKci.8.3.41 Processing Close : SELECT v_0.c_0, COUNT(*) AS c_1, SUM(v_0.c_1) AS c_2 FROM (SELECT left(g_0.C_PHONE, 2) AS c_0, g_0.C_ACCTBAL AS c_1 FROM TPCR.CUSTOMER AS g_0 WHERE (left(g_0.C_PHONE, 2) IN ('13', '17', '18', '23', '29', '30', '31')) AND (g_0.C_ACCTBAL > (SELECT AVG(g_1.C_ACCTBAL) FROM TPCR.CUSTOMER AS g_1 WHERE (g_1.C_ACCTBAL > 0E-15) AND (left(g_1.C_PHONE, 2) IN ('13', '17', '18', '23', '29', '30', '31')))) AND (NOT (EXISTS (SELECT g_2.O_ORDERKEY, g_2.O_CUSTKEY, g_2.O_ORDERSTATUS, g_2.O_TOTALPRICE, g_2.O_ORDERDATE, g_2.O_ORDERPRIORITY, g_2.O_CLERK, g_2.O_SHIPPRIORITY, g_2.O_COMMENT FROM TPCR.ORDERS AS g_2 WHERE g_2.O_CUSTKEY = g_0.C_CUSTKEY)))) AS v_0 GROUP BY v_0.c_0 ORDER BY c_0 LIMIT 100
2010-11-23 08:59:16,427 DEBUG [org.teiid.CONNECTOR] (Worker7_QueryProcessorQueue271) QPjlI18+nKci.8.3.41 Closed execution
2010-11-23 08:59:16,427 DEBUG [org.teiid.CONNECTOR] (Worker7_QueryProcessorQueue271) QPjlI18+nKci.8.3.41 Remove State
2010-11-23 08:59:16,427 DEBUG [org.teiid.CONNECTOR] (Worker7_QueryProcessorQueue271) QPjlI18+nKci.8.3.41 Closed connection
2010-11-23 08:59:16,427 DEBUG [org.teiid.COMMAND_LOG] (Worker8_QueryProcessorQueue270) 	ERROR USER COMMAND:	endTime=2010-11-23 08:59:16.427	requestID=QPjlI18+nKci.8	txID=null	sessionID=QPjlI18+nKci	principal=pnittel@teiid-security	vdbName=TpcrTest	vdbVersion=1	finalRowCount=null
2010-11-23 08:59:16,428 WARN  [org.teiid.PROCESSOR] (Worker8_QueryProcessorQueue270) Processing exception 'Error Code:107 Message:Error Code:107 Message:'The column prefix 'custsale' does not match with a table name or alias name used in the query.' error executing statement(s): [Prepared Values: ['13', '17', '18', '23', '29', '30', '31', 0E-15, '13', '17', '18', '23', '29', '30', '31'] SQL: SELECT TOP 100 v_0.c_0, COUNT(*) AS c_1, SUM(v_0.c_1) AS c_2 FROM (SELECT left(g_0.C_PHONE, 2) AS c_0, g_0.C_ACCTBAL AS c_1 FROM CUSTOMER g_0 WHERE left(g_0.C_PHONE, 2) IN (?, ?, ?, ?, ?, ?, ?) AND g_0.C_ACCTBAL > (SELECT AVG(g_1.C_ACCTBAL) FROM CUSTOMER g_1 WHERE g_1.C_ACCTBAL > ? AND left(g_1.C_PHONE, 2) IN (?, ?, ?, ?, ?, ?, ?)) AND NOT (EXISTS (SELECT g_2.O_ORDERKEY, g_2.O_CUSTKEY, g_2.O_ORDERSTATUS, g_2.O_TOTALPRICE, g_2.O_ORDERDATE, g_2.O_ORDERPRIORITY, g_2.O_CLERK, g_2.O_SHIPPRIORITY, g_2.O_COMMENT FROM ORDERS g_2 WHERE g_2.O_CUSTKEY = g_0.C_CUSTKEY))) v_0 GROUP BY v_0.c_0 ORDER BY custsale.c_0]' for request QPjlI18+nKci.8.  Exception type org.teiid.core.TeiidProcessingException thrown from net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:368). Enable more detailed logging to see the entire stacktrace.
2010-11-23 08:59:16,428 DEBUG [org.teiid.PROCESSOR] (Worker8_QueryProcessorQueue270) Removing tuplesource for the request QPjlI18+nKci.8
2010-11-23 08:59:16,428 DEBUG [org.teiid.BUFFER_MGR] (Worker8_QueryProcessorQueue270) Removing TupleBuffer: 57
2010-11-23 08:59:16,428 DEBUG [org.teiid.PROCESSOR] (Worker8_QueryProcessorQueue270) [Ljava.lang.Object;@72342a
[TeiidProcessingException] 107: Error Code:107 Message:Error Code:107 Message:'The column prefix 'custsale' does not match with a table name or alias name used in the query.' error executing statement(s): [Prepared Values: ['13', '17', '18', '23', '29', '30', '31', 0E-15, '13', '17', '18', '23', '29', '30', '31'] SQL: SELECT TOP 100 v_0.c_0, COUNT(*) AS c_1, SUM(v_0.c_1) AS c_2 FROM (SELECT left(g_0.C_PHONE, 2) AS c_0, g_0.C_ACCTBAL AS c_1 FROM CUSTOMER g_0 WHERE left(g_0.C_PHONE, 2) IN (?, ?, ?, ?, ?, ?, ?) AND g_0.C_ACCTBAL > (SELECT AVG(g_1.C_ACCTBAL) FROM CUSTOMER g_1 WHERE g_1.C_ACCTBAL > ? AND left(g_1.C_PHONE, 2) IN (?, ?, ?, ?, ?, ?, ?)) AND NOT (EXISTS (SELECT g_2.O_ORDERKEY, g_2.O_CUSTKEY, g_2.O_ORDERSTATUS, g_2.O_TOTALPRICE, g_2.O_ORDERDATE, g_2.O_ORDERPRIORITY, g_2.O_CLERK, g_2.O_SHIPPRIORITY, g_2.O_COMMENT FROM ORDERS g_2 WHERE g_2.O_CUSTKEY = g_0.C_CUSTKEY))) v_0 GROUP BY v_0.c_0 ORDER BY custsale.c_0]
1 [JDBCExecutionException] 107: Error Code:107 Message:'The column prefix 'custsale' does not match with a table name or alias name used in the query.' error executing statement(s): [Prepared Values: ['13', '17', '18', '23', '29', '30', '31', 0E-15, '13', '17', '18', '23', '29', '30', '31'] SQL: SELECT TOP 100 v_0.c_0, COUNT(*) AS c_1, SUM(v_0.c_1) AS c_2 FROM (SELECT left(g_0.C_PHONE, 2) AS c_0, g_0.C_ACCTBAL AS c_1 FROM CUSTOMER g_0 WHERE left(g_0.C_PHONE, 2) IN (?, ?, ?, ?, ?, ?, ?) AND g_0.C_ACCTBAL > (SELECT AVG(g_1.C_ACCTBAL) FROM CUSTOMER g_1 WHERE g_1.C_ACCTBAL > ? AND left(g_1.C_PHONE, 2) IN (?, ?, ?, ?, ?, ?, ?)) AND NOT (EXISTS (SELECT g_2.O_ORDERKEY, g_2.O_CUSTKEY, g_2.O_ORDERSTATUS, g_2.O_TOTALPRICE, g_2.O_ORDERDATE, g_2.O_ORDERPRIORITY, g_2.O_CLERK, g_2.O_SHIPPRIORITY, g_2.O_COMMENT FROM ORDERS g_2 WHERE g_2.O_CUSTKEY = g_0.C_CUSTKEY))) v_0 GROUP BY v_0.c_0 ORDER BY custsale.c_0]
2 [SQLException]The column prefix 'custsale' does not match with a table name or alias name used in the query.
	at org.teiid.dqp.internal.process.DataTierTupleSource.exceptionOccurred(DataTierTupleSource.java:371)
	at org.teiid.dqp.internal.process.DataTierTupleSource.nextTuple(DataTierTupleSource.java:214)
	at org.teiid.query.processor.relational.AccessNode.nextBatchDirect(AccessNode.java:154)
	at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:274)
	at org.teiid.query.processor.relational.RelationalPlan.nextBatch(RelationalPlan.java:107)
	at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:150)
	at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:105)
	at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:115)
	at org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:250)
	at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:184)
	at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:49)
	at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:188)
	at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:116)
	at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:290)
	at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
	at java.lang.Thread.run(Thread.java:619)
Caused by: [JDBCExecutionException] 107: Error Code:107 Message:'The column prefix 'custsale' does not match with a table name or alias name used in the query.' error executing statement(s): [Prepared Values: ['13', '17', '18', '23', '29', '30', '31', 0E-15, '13', '17', '18', '23', '29', '30', '31'] SQL: SELECT TOP 100 v_0.c_0, COUNT(*) AS c_1, SUM(v_0.c_1) AS c_2 FROM (SELECT left(g_0.C_PHONE, 2) AS c_0, g_0.C_ACCTBAL AS c_1 FROM CUSTOMER g_0 WHERE left(g_0.C_PHONE, 2) IN (?, ?, ?, ?, ?, ?, ?) AND g_0.C_ACCTBAL > (SELECT AVG(g_1.C_ACCTBAL) FROM CUSTOMER g_1 WHERE g_1.C_ACCTBAL > ? AND left(g_1.C_PHONE, 2) IN (?, ?, ?, ?, ?, ?, ?)) AND NOT (EXISTS (SELECT g_2.O_ORDERKEY, g_2.O_CUSTKEY, g_2.O_ORDERSTATUS, g_2.O_TOTALPRICE, g_2.O_ORDERDATE, g_2.O_ORDERPRIORITY, g_2.O_CLERK, g_2.O_SHIPPRIORITY, g_2.O_COMMENT FROM ORDERS g_2 WHERE g_2.O_CUSTKEY = g_0.C_CUSTKEY))) v_0 GROUP BY v_0.c_0 ORDER BY custsale.c_0]
1 [SQLException]The column prefix 'custsale' does not match with a table name or alias name used in the query.
	at org.teiid.translator.jdbc.JDBCQueryExecution.execute(JDBCQueryExecution.java:88)
	at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:263)
	at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:281)
	at org.teiid.dqp.internal.process.DataTierTupleSource.access$000(DataTierTupleSource.java:71)
	at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:123)
	at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:120)
	at org.teiid.dqp.internal.process.DQPCore$FutureWork.run(DQPCore.java:108)
	... 6 more
Caused by: java.sql.SQLException: The column prefix 'custsale' does not match with a table name or alias name used in the query.
	at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:368)
	at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2820)
	at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2258)
	at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:632)
	at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQLQuery(JtdsStatement.java:477)
	at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeQuery(JtdsPreparedStatement.java:776)
	at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeQuery(WrappedPreparedStatement.java:342)
	at org.teiid.translator.jdbc.JDBCQueryExecution.execute(JDBCQueryExecution.java:84)
	... 12 more
2010-11-23 08:59:16,428 DEBUG [org.teiid.TRANSPORT] (Worker8_QueryProcessorQueue270)  message: MessageHolder: contents=ResultsMessage rowCount=0 finalRow=-1 for request ID:25
2010-11-23 08:59:16,435 DEBUG [org.teiid.TXN_LOG] (Worker8_QueryProcessorQueue270) before suspend:org.teiid.dqp.internal.process.TransactionServerImpl@905b91(QPjlI18+nKci NONE ID:NONE)
2010-11-23 08:59:16,435 DEBUG [org.teiid.TXN_LOG] (Worker8_QueryProcessorQueue270) after suspend : null
2010-11-23 08:59:16,435 DEBUG [org.teiid.PROCESSOR] (Worker8_QueryProcessorQueue270) QPjlI18+nKci.8 end processing WORKING
2010-11-23 08:59:16,435 DEBUG [org.teiid.PROCESSOR] (Worker8_QueryProcessorQueue270) QPjlI18+nKci.8 done processing WORKING