Re: ERROR: wrong varnullingrels (b 3) (expected (b)) for Var 2/1 - Mailing list pgsql-hackers

From Tom Lane
Subject Re: ERROR: wrong varnullingrels (b 3) (expected (b)) for Var 2/1
Date
Msg-id 1452533.1686627279@sss.pgh.pa.us
Whole thread Raw
In response to Re: ERROR: wrong varnullingrels (b 3) (expected (b)) for Var 2/1  (Richard Guo <guofenglinux@gmail.com>)
Responses Re: ERROR: wrong varnullingrels (b 3) (expected (b)) for Var 2/1
List pgsql-hackers
Richard Guo <guofenglinux@gmail.com> writes:
> Oh, wait ... It occurred to me that we may have this same issue with
> Memoize cache keys.  In get_memoize_path we collect the cache keys from
> innerpath's ppi_clauses and innerrel's lateral_vars, and the latter may
> contain nullingrel markers that need adjustment.  As an example,
> consider the query below

> explain (costs off)
> select * from onek t1
>     left join onek t2 on true
>     left join lateral
>       (select * from onek t3 where t3.two = t2.two offset 0) s
>       on t2.unique1 = 1;
> ERROR:  wrong varnullingrels (b 3) (expected (b)) for Var 2/3

Good catch --- I'll take a closer look tomorrow.

            regards, tom lane



pgsql-hackers by date:

Previous
From: Richard Guo
Date:
Subject: Re: ERROR: wrong varnullingrels (b 3) (expected (b)) for Var 2/1
Next
From: Kyotaro Horiguchi
Date:
Subject: Re: pg_stat_io for the startup process