Request a Demo
Home   >   mailing lists

Re: BUG #17545: Incorrect selectivity for IS NOT DISTINCT FROM and NULLs - Mailing list pgsql-bugs

From shihao zhong
Subject Re: BUG #17545: Incorrect selectivity for IS NOT DISTINCT FROM and NULLs
Date
Msg-id CAGRkXqRDQXP-3fv7B8_6E=J+Sq2UZbTUFD4WkNn2wBxCmBm0fw@mail.gmail.com
Whole thread
In response to Re: BUG #17545: Incorrect selectivity for IS NOT DISTINCT FROM and NULLs  (Rahul <rahul@rhyadav.dev>)
List pgsql-bugs
Tree view
Hi Rahul,

Thanks for testing, and for the patch. I agree that EXISTS and NOT
EXISTS should be handled too.

v2 is attached, with your patch merged in and you as co-author. The
commit message of 0001 now mentions IS DISTINCT FROM too.

My test get the same numbers as you. 

Thanks,
Shihao

Attachment

pgsql-bugs by date:

Previous
From: Andrew Dunstan
Date:
Subject: Re: Issue Installing PostGIS via Stack Builder on MacBook (Apple Silicon / ARM64) – Application Buffers/Freezes
Next
From: Tom Lane
Date:
Subject: Re: BUG #19751: MIN aggregate + FETCH FIRST 1 ROW WITH TIES causes false 21000 error when index scan is forced