Re: pgsql: Make Vars be outer-join-aware. - Mailing list pgsql-committers

From Tom Lane
Subject Re: pgsql: Make Vars be outer-join-aware.
Date
Msg-id 1075343.1675176628@sss.pgh.pa.us
Whole thread Raw
In response to Re: pgsql: Make Vars be outer-join-aware.  (Robins Tharakan <tharakan@gmail.com>)
List pgsql-committers
Robins Tharakan <tharakan@gmail.com> writes:
> Since this commit, my test setup is triggering asserts every few minutes.
> The repro SQL itself doesn't make much sense, but it's the smallest I could
> narrow it down to:

> create table t1(a int);
> create table t2(a int);
> SELECT table_catalog AS c2
> FROM public.t1
>      INNER JOIN (t2
>                  LEFT JOIN information_schema.column_udt_usage ON NULL)
>         ON NULL;

Thanks, I'll take a look.

            regards, tom lane



pgsql-committers by date:

Previous
From: Robins Tharakan
Date:
Subject: Re: pgsql: Make Vars be outer-join-aware.
Next
From: Tom Lane
Date:
Subject: pgsql: Remove over-optimistic Assert.