Re: Allowing NOT IN to use ANTI joins

Поиск
Список
Период
Сортировка
От Jeevan Chalke
Тема Re: Allowing NOT IN to use ANTI joins
Дата
Msg-id CAM2+6=WasbauEfKMDNFXPchGj-q4s0QwaWG-rs+2F9bjQ4CHUg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Allowing NOT IN to use ANTI joins  (David Rowley <dgrowleyml@gmail.com>)
Список pgsql-hackers
Дерево обсуждения
Hi,



With further testing I noticed that the patch was not allowing ANTI joins in cases like this:

explain select * from a where id not in(select x from b natural join c);



I too found this with natural joins and was about to report that. But its good that you found that and fixed it as well.

I have reviewed this and didn't find any issues as such. So marking it "Ready for Committer".

Thanks

--
Jeevan B Chalke
Principal Software Engineer, Product Development
EnterpriseDB Corporation
The Enterprise PostgreSQL Company

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Jov
Дата:
Сообщение: Re: change alter user to be a true alias for alter role
Следующее
От: Pavel Stehule
Дата:
Сообщение: Re: psql: show only failed queries