9.1rc1: TRAP: FailedAssertion("!(item_width > 0)", File: "costsize.c", Line: 3274)

From: "Erik Rijkers" <er(at)xs4all(dot)nl>
To: pgsql-hackers(at)postgresql(dot)org
Subject: 9.1rc1: TRAP: FailedAssertion("!(item_width > 0)", File: "costsize.c", Line: 3274)
Date: 2011-08-22 20:16:25
Message-ID: 090f1f94afdfab8a8ea1cc16de3c9217.squirrel@webmail.xs4all.nl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

I am developing against 9.1beta3 and encountered this problem. I repeated it against rc1 (or
actually, REL9_1_STABLE taken from git today).

The below SQL causes:

TRAP: FailedAssertion("!(item_width > 0)", File: "costsize.c", Line: 3274)

and the session crashes.

select *
from (
select
col1
, col2
, reviewed
from
(values
( 1111, 'aweyu', 3)
, ( 2222, 'bwetu', 2)
, ( 3333, 'vwxyz', 1)
)
as r(col1,col2,col3)
left join (
select 1 as reviewed, c2 from ( values ('abcde') ) as t1(c2)
union all select 0 as reviewed, c2 from ( values ('vwxyz') ) as t2(c2)
)
as up_all on up_all.c2 = r.col2
order by col3
)
as f
;

To simplify I used 'values' for the actual tables that I am using, but the above still causes the
FailedAssertion.

Removing the outer select avoids the error and
removing order by avoids the error

Erik Rijkers

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Jim Nasby 2011-08-22 21:17:26 Re: Single pass vacuum - take 2
Previous Message Alvaro Herrera 2011-08-22 18:07:44 Re: PushActiveSnapshot(GetTransactionSnapshot())