6 Replies Latest reply on Feb 11, 2013 2:11 PM by markaddleman

    ConnectorWorkItem gets wrong result from CommandContext.getReusableExecution()

    markaddleman

      We have a query that joins a reusable execution to a non reusable execution called in non-continuous mode.  In our case, I see that when ConnectorWorkItem is processing the non-reusable execution, it reaches into this.requestMsg.getCommandContext().getReusableExecution(this.securityContext.getPartIdentifier()) and gets the reusable execution when it should get null.  I believe that this.securityContext.getPartIdentifier() is returning the wrong nodeId. 

       

      Attached is the query plan.  The chorus_time.timetable stored proc is a reusable execution while all performance_netmaster.* are regular executions.