Re: [HACKERS] incorrect query result using complex structures (views?)

[Tom Lane]

Kovacs Zoltan <[EMAIL PROTECTED]> writes:
> Thanks in advance. Zoltan

You're welcome ;-)

                        regards, tom lane


*** src/backend/executor/nodeAppend.c.orig      Thu Mar 22 01:16:12 2001
--- src/backend/executor/nodeAppend.c   Tue May  8 15:48:02 2001
***************
*** 8,14 ****
   *
   *
   * IDENTIFICATION
!  *      $Header: 
/home/projects/pgsql/cvsroot/pgsql/src/backend/executor/nodeAppend.c,v 1.40 2001/03/22 
06:16:12 momjian Exp $
   *
   *-------------------------------------------------------------------------
   */
--- 8,14 ----
   *
   *
   * IDENTIFICATION
!  *      $Header: 
/home/projects/pgsql/cvsroot/pgsql/src/backend/executor/nodeAppend.c,v 1.40.2.1 
2001/05/08 19:48:02 tgl Exp $
   *
   *-------------------------------------------------------------------------
   */
***************
*** 362,375 ****
  
        for (i = 0; i < nplans; i++)
        {
!               Plan       *rescanNode;
  
!               appendstate->as_whichplan = i;
!               rescanNode = (Plan *) nth(i, node->appendplans);
!               if (rescanNode->chgParam == NULL)
                {
                        exec_append_initialize_next(node);
!                       ExecReScan((Plan *) rescanNode, exprCtxt, (Plan *) node);
                }
        }
        appendstate->as_whichplan = 0;
--- 362,386 ----
  
        for (i = 0; i < nplans; i++)
        {
!               Plan       *subnode;
  
!               subnode = (Plan *) nth(i, node->appendplans);
!               /*
!                * ExecReScan doesn't know about my subplans, so I have to do
!                * changed-parameter signaling myself.
!                */
!               if (node->plan.chgParam != NULL)
!                       SetChangedParamList(subnode, node->plan.chgParam);
!               /*
!                * if chgParam of subnode is not null then plan will be re-scanned by
!                * first ExecProcNode.
!                */
!               if (subnode->chgParam == NULL)
                {
+                       /* make sure estate is correct for this subnode (needed??) */
+                       appendstate->as_whichplan = i;
                        exec_append_initialize_next(node);
!                       ExecReScan(subnode, exprCtxt, (Plan *) node);
                }
        }
        appendstate->as_whichplan = 0;
*** src/backend/executor/nodeSubqueryscan.c.orig        Thu Mar 22 01:16:13 2001
--- src/backend/executor/nodeSubqueryscan.c     Tue May  8 15:48:02 2001
***************
*** 12,18 ****
   *
   *
   * IDENTIFICATION
!  *      $Header: 
/home/projects/pgsql/cvsroot/pgsql/src/backend/executor/nodeSubqueryscan.c,v 1.6 
2001/03/22 06:16:13 momjian Exp $
   *
   *-------------------------------------------------------------------------
   */
--- 12,18 ----
   *
   *
   * IDENTIFICATION
!  *      $Header: 
/home/projects/pgsql/cvsroot/pgsql/src/backend/executor/nodeSubqueryscan.c,v 1.6.2.1 
2001/05/08 19:48:02 tgl Exp $
   *
   *-------------------------------------------------------------------------
   */
***************
*** 267,273 ****
                return;
        }
  
!       ExecReScan(node->subplan, NULL, node->subplan);
  
        subquerystate->csstate.css_ScanTupleSlot = NULL;
  }
--- 267,284 ----
                return;
        }
  
!       /*
!        * ExecReScan doesn't know about my subplan, so I have to do
!        * changed-parameter signaling myself.
!        */
!       if (node->scan.plan.chgParam != NULL)
!               SetChangedParamList(node->subplan, node->scan.plan.chgParam);
!       /*
!        * if chgParam of subnode is not null then plan will be re-scanned by
!        * first ExecProcNode.
!        */
!       if (node->subplan->chgParam == NULL)
!               ExecReScan(node->subplan, NULL, node->subplan);
  
        subquerystate->csstate.css_ScanTupleSlot = NULL;
  }

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
    (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])