Re: Bug with 'iscachable' attribute (Was: Index selection bug) - Mailing list pgsql-bugs

From Tom Lane
Subject Re: Bug with 'iscachable' attribute (Was: Index selection bug)
Date
Msg-id 7806.964704956@sss.pgh.pa.us
Whole thread Raw
In response to Bug with 'iscachable' attribute (Was: Index selection bug)  (Andriy I Pilipenko <bamby@marka.net.ua>)
List pgsql-bugs
Andriy I Pilipenko <bamby@marka.net.ua> writes:
> create table a (a int)

> create table b (b int)

> create function f() returns int as '
>     select a
>           from a
>          where a = (select max(b) from b)
> ' language 'sql'
> with (iscachable)

> select f()

>   ERROR:  replace_vars_with_subplan_refs: variable not in subplan target list

Oh my, that's interesting :-( --- especially that it doesn't happen
without iscachable.  Will look into it.  Thanks for the report.

            regards, tom lane

pgsql-bugs by date:

Previous
From: Andriy I Pilipenko
Date:
Subject: Bug with 'iscachable' attribute (Was: Index selection bug)
Next
From: Bernie Huang
Date:
Subject: inheritance in V.7.1?