Re: Bug with 'iscachable' attribute (Was: Index selection bug)

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Andriy I Pilipenko <bamby(at)marka(dot)net(dot)ua>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: Bug with 'iscachable' attribute (Was: Index selection bug)
Date: 2000-07-27 13:35:56
Message-ID: 7806.964704956@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Andriy I Pilipenko <bamby(at)marka(dot)net(dot)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

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Bernie Huang 2000-07-27 17:30:26 inheritance in V.7.1?
Previous Message Andriy I Pilipenko 2000-07-27 07:38:57 Bug with 'iscachable' attribute (Was: Index selection bug)