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

Поиск
Список
Период
Сортировка
От Erik Rijkers
Тема 9.1rc1: TRAP: FailedAssertion("!(item_width > 0)", File: "costsize.c", Line: 3274)
Дата
Msg-id 090f1f94afdfab8a8ea1cc16de3c9217.squirrel@webmail.xs4all.nl
обсуждение исходный текст
Ответы Re: 9.1rc1: TRAP: FailedAssertion("!(item_width > 0)", File: "costsize.c", Line: 3274)  (Robert Haas <robertmhaas@gmail.com>)
Re: 9.1rc1: TRAP: FailedAssertion("!(item_width > 0)", File: "costsize.c", Line: 3274)  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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








В списке pgsql-hackers по дате отправления:

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Re: PushActiveSnapshot(GetTransactionSnapshot())
Следующее
От: Jim Nasby
Дата:
Сообщение: Re: Single pass vacuum - take 2