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

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: BUG #17199: Calling stored procedure with stable function as argument results in wrong result
Дата
Msg-id 1980152.1632236471@sss.pgh.pa.us
обсуждение исходный текст
Ответ на BUG #17199: Calling stored procedure with stable function as argument results in wrong result  (PG Bug reporting form <noreply@postgresql.org>)
Ответы Re: BUG #17199: Calling stored procedure with stable function as argument results in wrong result  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-bugs
PG Bug reporting form <noreply@postgresql.org> writes:
> When a function that returns just a row count of a table is marked as STABLE
> and is called from a stored procedure as argument, the result of the
> function is different than when the function is called beforehand and stored
> to a local variable.

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.

Will fix, thanks for the report!

            regards, tom lane



В списке pgsql-bugs по дате отправления:

Предыдущее
От: PG Bug reporting form
Дата:
Сообщение: BUG #17199: Calling stored procedure with stable function as argument results in wrong result
Следующее
От: Tom Lane
Дата:
Сообщение: Re: BUG #17199: Calling stored procedure with stable function as argument results in wrong result