Re: BUG #17199: Calling stored procedure with stable function as argument results in wrong result

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: notegihu(at)confused(dot)at
Cc: pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: Re: BUG #17199: Calling stored procedure with stable function as argument results in wrong result
Date: 2021-09-21 15:49:56
Message-ID: 2031644.1632239396@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

I wrote:
> Ugh. Looks like I broke this in 84f5c2908, by not thinking about the
> possibility that a CALL's argument expressions would need an up-to-date
> snapshot.

Concretely, the attached seems to take care of it. I'll refrain
from pushing this till later, though, since v14 is frozen for rc1
for a few hours more.

regards, tom lane

Attachment Content-Type Size
eval-CALL-arguments-with-fresh-snapshot.patch text/x-diff 3.7 KB

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Andriy Bartash 2021-09-21 16:27:06 Re: BUG #17198: Planning time too high when execute query on standby cluster
Previous Message Tom Lane 2021-09-21 15:01:11 Re: BUG #17199: Calling stored procedure with stable function as argument results in wrong result