Re: A bug in make_outerjoininfo
| От | Richard Guo |
|---|---|
| Тема | Re: A bug in make_outerjoininfo |
| Дата | |
| Msg-id | CAMbWs49BXMEvdFM9Uzj-bihDucSQSwFEkpOme_BGo2NpU_Ry=g@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: A bug in make_outerjoininfo (Tom Lane <tgl@sss.pgh.pa.us>) |
| Ответы |
Re: A bug in make_outerjoininfo
|
| Список | pgsql-hackers |
On Wed, Feb 8, 2023 at 7:33 AM Tom Lane <tgl@sss.pgh.pa.us> wrote:
We might want to see if we can devise a new example (or wait for
Robins to break it ;-)) before expending a lot of effort on making
the commute_xxx bits more precise.
Here is an example that can trigger the same assertion as in bug #17781
with HEAD. But I haven't got time to look into it, so not sure if it is
the same issue.
select
coalesce(ref_0.permissive, 'a') as c0
from
(SELECT pol.polpermissive::text as permissive
FROM pg_policy pol JOIN pg_class c ON c.oid = pol.polrelid
LEFT JOIN pg_namespace n ON n.oid = c.relnamespace) as ref_0
right join pg_catalog.pg_amop as sample_0 on (true)
where (select objsubid from pg_catalog.pg_shdepend) < 1;
Thanks
Richard
with HEAD. But I haven't got time to look into it, so not sure if it is
the same issue.
select
coalesce(ref_0.permissive, 'a') as c0
from
(SELECT pol.polpermissive::text as permissive
FROM pg_policy pol JOIN pg_class c ON c.oid = pol.polrelid
LEFT JOIN pg_namespace n ON n.oid = c.relnamespace) as ref_0
right join pg_catalog.pg_amop as sample_0 on (true)
where (select objsubid from pg_catalog.pg_shdepend) < 1;
Thanks
Richard
В списке pgsql-hackers по дате отправления: