Re: BUG #18933: PostgreSQL fails to handle JOIN operation involving Empty Table

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: jinhuilai(at)email(dot)ncu(dot)edu(dot)cn
Cc: pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: Re: BUG #18933: PostgreSQL fails to handle JOIN operation involving Empty Table
Date: 2025-05-15 15:28:44
Message-ID: 11836.1747322924@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

PG Bug reporting form <noreply(at)postgresql(dot)org> writes:
> Obviously, the above queries always returns an empty set. I think it should
> return an empty set quickly.

None of these things are bugs. You are accomplishing little except
to annoy people, especially when the more appropriate way to proceed
was already explained to you a few weeks ago.

regards, tom lane

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2025-05-15 15:46:31 Re: Postgres: Queries are too slow after upgrading to PG17 from PG15
Previous Message Heikki Linnakangas 2025-05-15 14:41:42 Re: BUG #18929: After the view is created, executed query against the view definition, reported syntax error.