Re: [HACKERS] Assertion failure in new outer/semi/anti join code

2008-12-07 Thread Tom Lane
Gregory Stark <[EMAIL PROTECTED]> writes: > 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); Fixed, thanks for the report. > Looks like it's assuming there's at least one relation on each side of the > joi

[HACKERS] Assertion failure in new outer/semi/anti join code

2008-12-04 Thread Gregory Stark
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