From: | Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us> |
---|---|
To: | emkxp01(at)mtcc(dot)demon(dot)co(dot)uk |
Cc: | hackers(at)postgreSQL(dot)org |
Subject: | Re: [HACKERS] SIGSEGV in sebselect. |
Date: | 1998-02-23 00:17:09 |
Message-ID: | 199802230017.TAA04942@candle.pha.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
>
> 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(at)candle(dot)pha(dot)pa(dot)us
From | Date | Subject | |
---|---|---|---|
Next Message | Vadim B. Mikheev | 1998-02-23 02:14:11 | Re: [HACKERS] SIGSEGV in sebselect. |
Previous Message | Keith Parks | 1998-02-22 22:22:32 | Re: [HACKERS] SIGSEGV in sebselect. |