Postgres Pro
Downloads
Home   >   mailing lists

Re: BUG #18905: The opposite WHERE clause intersects and is always an empty set. It should perform no action. - Mailing list pgsql-bugs

From David G. Johnston
Subject Re: BUG #18905: The opposite WHERE clause intersects and is always an empty set. It should perform no action.
Date
Msg-id CAKFQuwZQB2=CRdqd1rT8cs+ziUjnDCbbnNot-UzyMBypDUkA+A@mail.gmail.com
Whole thread Raw
In response to BUG #18905: The opposite WHERE clause intersects and is always an empty set. It should perform no action.  (PG Bug reporting form <noreply@postgresql.org>)
Responses Re: BUG #18905: The opposite WHERE clause intersects and is always an empty set. It should perform no action.
List pgsql-bugs
Tree view
On Sunday, April 27, 2025, PG Bug reporting form <noreply@postgresql.org> wrote:
The following bug has been logged on the website:

Bug reference:      18905
Logged by:          jinhui lai
Email address:      jh.lai@qq.com
PostgreSQL version: 17.4
Operating system:   ubuntu 22.04
Description:        

As with 18904, this is not a bug.

David J.

pgsql-bugs by date:

Previous
From: "David G. Johnston"
Date:
Subject: BUG #18904: INTERSECT with an impossible where should eliminate both from the query plan
Next
From: "David G. Johnston"
Date:
Subject: Re: BUG #18906: EXCEPT with identical left/right queries isn't eliminated