Re: BUG #18930: PostgreSQL fails to handle INTERSECT operation involving Empty Table - Mailing list pgsql-bugs

The following bug has been logged on the website:

Bug reference:      18930
Logged by:          jinhui lai
Email address:      jinhuilai@email.ncu.edu.cn
PostgreSQL version: 17.5
Operating system:   ubuntu 22.04
Description:       

Hi, PostgreSQL Developers,
Please consider such queries:
SELECT * FROM empty_table INTERSECT SELECT * FROM not_empty_table;
SELECT * FROM not_empty_table INTERSECT SELECT * FROM empty_table;
Obviously, the above queries always returns an empty set. I think it should
return an empty set quickly.