Assertion failure in new outer/semi/anti join code

Поиск
Список
Период
Сортировка
От Gregory Stark
Тема Assertion failure in new outer/semi/anti join code
Дата
Msg-id 87prk813fi.fsf@oxford.xeocode.com
обсуждение исходный текст
Ответы Re: Assertion failure in new outer/semi/anti join code  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
The following query causes an assertion failure on CVS head:

SELECT * FROM (SELECT 1 AS i) AS a WHERE NOT EXISTS (SELECT 1 WHERE 1 <> i);

TRAP: FailedAssertion("!(!bms_is_empty(min_righthand))", File: "initsplan.c", Line: 685)

Looks like it's assuming there's at least one relation on each side of the
join. Incidentally originally triggered with a VALUES clause but I think by
the point the code runs that distinction is long gone.

--  Gregory Stark EnterpriseDB          http://www.enterprisedb.com Ask me about EnterpriseDB's Slony Replication
support!


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

Предыдущее
От: ohp@pyrenet.fr
Дата:
Сообщение: Re: cvs head initdb hangs on unixware
Следующее
От: tmp
Дата:
Сообщение: Optimizing DISTINCT with LIMIT