Re: [HACKERS] SIGSEGV in sebselect.

>
> Hi All,
>
> I'm getting a SIGSEGV with the following subselect:-
>
> select * from disks where diskid in
>  ( select distinct diskid from tracks where artist = 'Led Zeppelin');
>
> The source tree is a cvsup from 22nd Feb (AM GMT)
> Platform is Linux/SPARC
>
> I'm afraid my debugging skills are limited to generating a backtrace
> so here goes....

This is a partial fix.  In make_unique(), if Query->uniqueAttr is '*',
Unique->uniqueAttr gets null.  However, with this fix, I get:

    test=> select usesysid from pg_user where usesysid in (select distinct
    usesysid from pg_user);
    ERROR:  ExecReScan: node type 24 not supported

I have not installed this patch yet until Vadim comments and perhaps has
an idea on the ExecReScan message:


---------------------------------------------------------------------------

*** ./backend/nodes/copyfuncs.c.orig    Sun Feb 22 18:58:59 1998
--- ./backend/nodes/copyfuncs.c    Sun Feb 22 19:03:37 1998
***************
*** 549,555 ****
       *    copy remainder of node
       * ----------------
       */
!     newnode->uniqueAttr = pstrdup(from->uniqueAttr);
      newnode->uniqueAttrNum = from->uniqueAttrNum;
      Node_Copy(from, newnode, uniquestate);

--- 549,558 ----
       *    copy remainder of node
       * ----------------
       */
!     if (newnode->uniqueAttr)
!         newnode->uniqueAttr = pstrdup(from->uniqueAttr);
!     else
!         newnode->uniqueAttr = NULL;
      newnode->uniqueAttrNum = from->uniqueAttrNum;
      Node_Copy(from, newnode, uniquestate);



--
Bruce Momjian
maillist@candle.pha.pa.us